For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure to announce that the Indexing episode was released today, well at lease half of it. After we finished the recording, we realized that there was too much content to fit it in to our normal …

Podcast Episode – The Long Awaited Index Episode Read more »

Please join Carlos and I for our first Database Corruption webcast on May 3rd. I have teamed up with Carlos and we will be presenting some thoughts on database corruption with an extended Q&A session. One important detail is we will be taking questions and answering them live on the webcast so this will be a great way to engage …

Database Corruption Webcast – May 3rd Read more »

TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation, however shrink database does shrink the log file. Not shrinking your database is one of the more counter intuitive …

DBCC ShrinkDatabase – I want to shrink my database. Read more »