In this article, we have discussed how to perform SQL server disaster recovery easily. Also in this problem tackling blog will discuss the tips to prevent SQL database from disaster.
Category: SQL 2008 R2
Simple Way to Find Transaction Log Activities in SQL Server
“I am using SQL Server 2005. When I was doing modification to my database, I found that some of the data has already been modified.
SQL Server 2012 NUMA Node Imbalance–Conclusion
Final post in the series, I hope to summarize my findings for everyone. Thanks for all the comments, feedback and comments I have received to-date
SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 Released!
SQL Server 2008 SP4 (link) and SQL Server 2008 R2 SP3 (link) have been released. Please note these are the final service packs for these
Online Index Rebuild can Cause Fragmentation
As Microsoft SQL Server PFE, I am always playing with SQL Server. I generally spend most of my time on the engine side of world;
SQL Server 2008 R2 SP2 CU6 Released!
SQL Build: 10.50.4279 KB: 2830140 Many fixes are same as those released for SP1 CU12. But there are some additional fixes in this CU for
SQL Canada (SQLCAN) 