Ruminations on Writing Great T-SQL

Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I...

SQL Sentry Pro Explorer is worth it...

UPDATE: 2015-04-28 15:49

- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

Instances and Ports with PowerShell

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...

Find blocking using sp_who in SQL Server

Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...

SQL Sentry Pro Explorer is worth it…

UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

How Many SQL Log Files Do You Keep? - WaterOx Consulting

Reading Time: 2 minutesEver have this happen? You (on vacation): I’ll have another piña colada...
The post How Many SQL Log...

Optimizing the Modern Data Platform with SQL Server 2014

Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server...

Overview of Published Articles – 2015Q1

Here is an overview of the articles I published in the first quarter of 2015.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...

Backup before you restore

You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...

Make Sure to Schedule Your SQL Server Replication Jobs

You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.
Right? Wrong..
At...