T-SQL Tuesday: Common SQL Server myths – Series I–Setup and Services
As part of the Microsoft CSS group, we get to deal with a lot of production as well as non-production …
Category Archives: Best Practices
CU10 is a must for all instances where mirroring is being used
If you happen to use Database Mirroring on SQL Server 2005, then Cumulative Update 10 for SQL Server 2005 Service …
SQL performance gotchas for Distributed Queries
I am not sure how many of us pay attention to BOL notes under certain topics. I must admit that …
Now SQL Server 2008 has BPA too
This has been an ask from the community for a long time now. We just launched SQL Server 2008 R2 …
The need for a sound Backup Strategy
Backup strategy needs to be designed in such a manner that it causes minimum amount of downtime in case during …
