Author: SteveStedman

Database Health Monitor – May 2017 version released today

Today I had the opportunity to release the May 2017 update of Database Health Monitor. This release is version 2.5.4. There are some new cross-instance reports available to allow you to check on your backup and CheckDB work on all

Posted in Database Health Tagged with: , , , ,

DBCC FREEPROCCACHE – What is the impact.

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

Posted in Performance Tagged with: , ,

I’m Presenting at the Compañero Conference In October

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

Posted in Companero Conference Tagged with:

Podcast Episode 91: DBA Tools – Listen and find out what you are missing.

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

Posted in Podcast Tagged with: , , , ,

My CheckDB Script

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

Posted in Uncategorized Tagged with: , , , , , , ,

Podcast Episode 90: DBCC CheckDB

This weeks episode of the SQL Data Partners Podcast 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

Posted in Uncategorized Tagged with: , , , , ,

Finding Blocking Queries

One of the common problems with when diagnosing what appears to be a slow scenario where there may be blocking involved is determining what is blocking on SQL Server. Here is a query that I like to use. If there

Posted in TSQL Tagged with: , , , , ,

February 2017 Release of Database Health Monitor

Today I had the opportunity to complete and launch the February 2017 version of Database Health Monitor. I hope you like the latest version. Here are the Release Notes: Version 2.5 Release Notes – February 2017. Version 2.5 is the

Posted in Database Health Tagged with: , , , , , , ,

SQL Compañero

If you have listened to the SQL Data Partners Podcast where Carlos Chacon and I are the co-hosts of the show, you have probably heard us use the term SQL compañero. In case you are wondering where the term comes from and

Posted in Podcast Tagged with: , , ,

Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters

On March 18th I will be attending SQL Saturday 610 in Richmond Virginia and the day before I will be presenting a pre conference session covering half a day on Database Corruption and half a day on Disaster Recovery Planning.

Posted in Corruption, SQL Saturday Tagged with: , , , ,