Here is a question that I received from a friend today and I thought it would be a good post explaining the details: Steve, I have a question on DBCC FREEPROCCACHE. I used sp_blitzcache from Brent and it shows that …
I am excited to announce that I will be speaking at (and helping organize) the SQL Conference called Companero Conference in Norfolk VA on October 4th and 5th 2017. SQL Server Conference for the Accidental, Lone or New DBA The …
I’m Presenting at the Compañero Conference In October Read more »
Today Episode 91 released and it is our pleasure to present this episode on DBA Tools. DBA Tools is an open source project (http://DBATools.io) that provides a number of powershell scripts to better help the DBA perform common SQL Server …
Podcast Episode 91: DBA Tools – Listen and find out what you are missing. Read more »
From time to time I get asked about checkDB, and there are many solutions out there, but I have one that I generally use that is very simple and does the job. The script below created a stored procedure in …
This weeks episode of the is Episode 90 released today. Episode Quote “I would say that the bigger issue is probably going to be something like snapshot space for your disk” “When the rubber hits the road I’m still running …