How do you validate what is stored in a specific partition and the filegroup the partition resides on?  I have found this handy when designing a partition strategy and to double check it is behaving as I expect and my data is stored correctly for the requirements.  It also can help if you document as part of your disaster recovery ...

Recently I had a few questions about how to go about partial restores if you have media failure that affects only specific filegroups, and your database is inaccessible because of the missing file(s).   The steps while simple, are not readily apparent in example form in books online. In this example you have a multi filegroup database ...

Here is a situation one of my client's recently encountered on SQL Server 2005.  It was incredibly painful and a challenge to determine what was happening, plus it's an issue that is supposed to be fixed in SP2.  So wanted to share the details of the symptoms in case you experience it too.  My client is on a SP2+ build.  They ...

Hello, I wanted to take a moment to introduce myself with my first blog and give you a bit of background about me.  While I am new to blogging, I am not new to SQL Server.  I started with SQL Server 4.2 back in the early nineties.  I was supporting an application that was written in PowerBuilder that did screen scraping off of a ...