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 one particular query is horrendous ( I already knew that as I ran it and cancelled it after 10 minutes …
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 Compañero Conference is a two-day DBA centered conference bringing together an amazing network of professionals to help you get actionable …
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 tasks. This was a fun episode with the panel of Chrissy, Rob, Constantine, and Aaron who were super excited to talk …
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 the DBHealthHistory database that can be used to check as many databases as you can get through in a specific …
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 CheckDB and CheckTable but it’s all about the process behind it” Overview DBCC CheckDB. It is a simple command, but …
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 is no blocking occurring then this query will return nothing. This script works on SQL Server 2008, 2008R2, 2012, …
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 February 2017 release of Database Health Monitor, released on February 19, 2017. What People Are Saying About Database Health Monitor …
February 2017 Release of Database Health Monitor Read more »
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. This event has just been announced, and you can sign up for the pre-con session now. I will be presenting with …
Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters Read more »
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 »
Lately I have had the opportunity to work with performance tuning of queries running on the Azure Parallel Data Warehouse (Azure PDW). This has been interesting in that everything you thought you knew about SQL Server DMV’s, writing queries and overall performance tuning is just a little bit different. My goal was to write a query to show me what …