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...

Author: Suhas De 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...

Author: Suhas De Date: 08/02/2011

Internals of Database Snapshot

In this post, we will explore the internals of Database Snapshot. Most of this information is...

Author: Suhas De Date: 07/31/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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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,...

Author: Suhas De 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...

Author: Suhas De Date: 03/21/2010

INF: A missing exception handler can cause blocking and eventual application hang.

Very recently, I had the opportunity to help troubleshoot a Blocking issue that one of our...

Author: Suhas De Date: 03/17/2010

Is NFR set?

Hi Friends, After a long break of about 8 months, I am back again!! Many things changed recently,...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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,...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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,...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De 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...

Author: Suhas De Date: 03/14/2009

Working with Multibase Differential Backups

While working with databases, SQL Server Database Administrators are required to take various types...

Author: Suhas De Date: 03/14/2009