Blogs from Suhas
Dirtying my hands in SQL Server
Internals of Database Snapshot – Part 3: Snapshot and Mirroring
In my earlier posts, we have seen how database snapshots work, and how the Buffer Pool is used when...
Date: 08/15/2011
Internals of Database Snapshot – Part 2: Snapshot and the Buffer Pool
In my earlier post, we have seen what Database Snapshots are, and how the Database Snapshots are...
Date: 08/02/2011
Advanced Performance Tuning – 4 :: Designing for better performance contd…
Few months back, I was working with one of my customers, who was engaged by his client to design a...
Date: 07/15/2011
Advanced Performance Tuning – 3 :: Designing for better performance
If you have read my earlier post, you might be saying “Heck! This guy loves to post questions...
Date: 07/14/2011
Advanced Performance Tuning – 2 :: Which side of the operator
If you have read my earlier blog post on the Importance of data-types, you might be wondering, “What...
Date: 07/13/2011
Transaction Log Backup Size in Bulk Logged Recovery Model
Assume that I have a database in Bulk Logged Recovery Model, and I perform a bulk operation that is...
Date: 12/29/2010
Advanced Performance Tuning – 1 :: Importance of data-types
Why did we develop DBMS systems? Not just for storing data – but also to be able to search for...
Date: 09/12/2010
INF: How to re-setup Database Mirroring In SQL Server
One of my friends was asking this to me offline the other day: "I have Database in SQL Server,...
Date: 08/25/2010
INF: Automatic Identity Range Management with Merge Replication in Microsoft SQL Server 2005 / 2008
I have been working with SQL Server Replication for over 4 years now; and till now each case that I...
Date: 03/21/2010
Is NFR set?
Hi Friends, After a long break of about 8 months, I am back again!! Many things changed recently,...
Date: 03/12/2010
Revealing the secrets - Truncating a Transaction Log File
In my earlier blog post on Shrinking the Transaction Log files in SQL Server, I had mentioned that a...
Date: 07/18/2009
Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup
This post is again in response to requests from customers who want to know how to configure Database...
Date: 07/13/2009
How to configure SQL Server Database Mail to send email using your Windows Live Mail Account or your GMail Account
Hi Friends, This post comes as a response to requests from many of our customers, who want to know...
Date: 07/12/2009
Database Corruption Part 5 :: Dealing with Log File Corruption
Hi Friends, I am back again after a long time. Last month was the end of yet another financial year,...
Date: 07/11/2009
Registry check-pointing on a Windows Cluster
Over the last few years that I have been in Microsoft, I have come across multiple issues where...
Date: 05/26/2009
Lock pages in memory now available for 64 bit Standard Edition of SQL Server
Great news!!! Due to over-whelming customer demand for the "Lock pages in memory" support...
Date: 05/21/2009
Database Corruption Part 4 :: Recovering from a failed disk
It was a nice day a few days back - nice sunny day, with moderate temperatures. I got up early and...
Date: 05/18/2009
Server Side Encryption in SQL Server
Hi Friends, After 3 posts on Database Corruption, I hope you would not mind if I divert my attention...
Date: 05/15/2009
Database Corruption Part 3 :: Differences between CHECKTABLE and CHECKDB
In this post, we would have a look at the differences between DBCC CHECKTABLE and DBCC CHECKDB. We...
Date: 05/14/2009
Database Corruption Part 2 :: How to attach a database using the Create-Replace method
Ok, so, as promised, here’s my next post on Database Corruption. In this post, we will have a look...
Date: 05/12/2009
Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server
Hello Everybody, I think you will all agree with me that database corruption is one of the...
Date: 04/08/2009
Property Owner is not available for Database '[DBName]'.
Hi Friends, This issue that I am talking about is a very common issue that I have seen. I have, in...
Date: 04/05/2009
Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server, Error: 208)
Hi Friends, The last month has been a very busy month for all of us, and its not over yet. However,...
Date: 04/05/2009
Shrinking the Transaction Log files in SQL Server
Hi Friends! This blog post is mainly to address concerns about increasing log file space, and how to...
Date: 03/16/2009
How to find sizes of all user tables in a database
Hi Friends! Recently I was asked to write a query that would us us know the sizes of all user tables...
Date: 03/16/2009
SQL Server Agent is unable to come online on a cluster
Going through Varun's blog on Lock Pages in Memory in SQL Server 64-Bit, I remembered an issue that...
Date: 03/14/2009
Working with Multibase Differential Backups
While working with databases, SQL Server Database Administrators are required to take various types...
Date: 03/14/2009