SQL Server recovery models often incorrectly referred to as (MS SQL Recovery Mode) define how your SQL Server database will treat your transaction logs. There are 3 SQL Server Recovery Models to choose from, Simple, Full and Bulk Logged. Simple: …
I often times get the question similar to “Why is my log file not shrinking when I do regular backups”? It goes to show there the functionality of the SQL Server transaction log is not entirely clear. The way that …
Why is my log file not shrinking when I do regular backups? Read more »
Yesterday I had the opportunity to practice one of my sessions on Backup and Restore that I will be presenting at PASS Summit this year. I presented it at two different SQL Server Users Group meetings, one in Bellingham WA, …
Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This and Don’t Do That”, and it covers a bunch of tips and best practices around …
If you haven’t tried Database Health Monitor Version 2.4 might be a good time to try it out. Five and a half years of my development time has gone into Database Health monitor, and hopefully the features will show it. Here …
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 …
DBCC ShrinkDatabase – I want to shrink my database. Read more »
Today I am presenting my “TempDB – Do This and Don’t Do That” session at SQL Saturday Redmond. Here is the download of the presentation and samples. StedmanTempDbPresentation.zip Some of the sample code from the session: I hope …