The Curious Engineer

All blogs / Databases

Blogs from Suhas

learn.microsoft.com/en-us/archive/blogs/suhde

Dirtying my hands in SQL Server

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
27 from 14 Mar 2009 to 15 Aug 2011
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/suhde/feed.xml

2011 5

  1. Internals of Database Snapshot – Part 3: Snapshot and Mirroring
  2. Internals of Database Snapshot – Part 2: Snapshot and the Buffer Pool
  3. Advanced Performance Tuning – 4 :: Designing for better performance contd…
  4. Advanced Performance Tuning – 3 :: Designing for better performance
  5. Advanced Performance Tuning – 2 :: Which side of the operator

2010 5

  1. Transaction Log Backup Size in Bulk Logged Recovery Model
  2. Advanced Performance Tuning – 1 :: Importance of data-types
  3. INF: How to re-setup Database Mirroring In SQL Server
  4. INF: Automatic Identity Range Management with Merge Replication in Microsoft SQL Server 2005 / 2008
  5. Is NFR set?

2009 17

  1. Revealing the secrets - Truncating a Transaction Log File
  2. Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup
  3. How to configure SQL Server Database Mail to send email using your Windows Live Mail Account or your GMail Account
  4. Database Corruption Part 5 :: Dealing with Log File Corruption
  5. Registry check-pointing on a Windows Cluster
  6. Lock pages in memory now available for 64 bit Standard Edition of SQL Server
  7. Database Corruption Part 4 :: Recovering from a failed disk
  8. Server Side Encryption in SQL Server
  9. Database Corruption Part 3 :: Differences between CHECKTABLE and CHECKDB
  10. Database Corruption Part 2 :: How to attach a database using the Create-Replace method
  11. Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server
  12. Property Owner is not available for Database '[DBName]'.
  13. Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server, Error: 208)
  14. Shrinking the Transaction Log files in SQL Server
  15. How to find sizes of all user tables in a database
  16. SQL Server Agent is unable to come online on a cluster
  17. Working with Multibase Differential Backups