Microsoft has released SP1 for SQL Server 2008 http://support.microsoft.com/kb/968382
List of the bugs that are fixed in SQL Server 2008 Service Pack 1
SQL Server security best practice
Security! This is the word comes in mind of every concerned person when it come...
Change the Collation Settings in MS SQL Server
This post will show you how to change the collation settings in MS SQL Server for specific database...
Resolve collation conflict
In this post I will show you how you can resolve collation conflict error...
Book: SQL Server 2008 High Availability
In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...
Why to recompile Stored Procedure
Generally, we create views and stored procedures (proc here after) ...
Showing posts with label kb. Show all posts
Showing posts with label kb. Show all posts
4/08/2009
7/30/2007
Failed to connecto to SSIS
Sometimes we receive "SSMS failed to connect to SSIS on client machine", Microsoft has released KB 940232 for the workaround
4/24/2007
Logging and Data Storage Algorithms in MS SQL Server
Ever wonder how SQL Server Logs data in T-Log and Data Files? What algorithm it uses!!! What is ARIES (Algorithm for Recovery and Isolation Exploiting Semantics), refer Microsoft Knowledge Base Article http://support.microsoft.com/kb/230785 which gives the complete details how it works!! With the detail explanation on each steps and terms.
7/01/2006
Handling Deadlock in Microsoft SQL Server
Hi,
I have found wonderfull KB for handling deadlock conditions in SQL Server
http://support.microsoft.com/kb/118552/en-us just FYR
