SQL Server 2005 Cluster which has many instances or contain many nodes may gives you error while upgrading it with hotfix or service pack; the simple procedure to update hotfix and sp has been given by Microsoft, read more on KB 936488
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) ...
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
Timeout occured while running dbcc freeproccache/alter database/sp_configure/sp_detace_db
Some of us might have face timeout when we run DBCC FREEPROCCACHE, Alter Database, Restore Database, SP_configure or sp_detach_db ; Microsoft has released KB 925419 which has workaround for the problem.
7/16/2007
Disaster Recovery Articles on MS SQL Server
Here are some good Disaster Recovery articles on MS SQL Server
http://support.microsoft.com/kb/307775
