Author: SteveStedman

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: , , , ,

Podcast Episode – The Long Awaited Index Episode

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 (episode 81) was released today, well at lease half

Posted in Podcast Tagged with: , , , , , ,

Azure PDW What is Active

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

Posted in Azure PDW Tagged with: , , ,

Bellingham SQL Server Users Group – January 25th

On Wednesday January 25th at 6:00pm we will be hosting the monthly meeting of the Bellingham SQL Server Users Group. January SQL Server Users Group In-Person @ 709 West Orchard Drive #4 Bellingham, Washington 18:00 – 20:00 (UTC-08:00) Pacific Time

Posted in PASS Chapter Tagged with: , , , , ,

Podcast Episode 79: SSIS Catalog with Andy Leonard

This weeks episode we are pleased to host Andy Leonard to discuss his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture. Although the SSIS Catalog DB is created with management studio, it does not

Posted in Podcast Tagged with: , , , , ,

The On Call DBA For Corruption

  One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to

Posted in Corruption Tagged with: ,

Latest Podcast Episodes

Here is a quick update on the last 3 podcast episodes that we have published, ending up 2016, and starting out 2017 with some great information from Paul Turley, Jimmy May and Argenis Fernandez. Episode 77: New Reporting Options with

Posted in Podcast Tagged with: , , , ,