T-SQL Tricks – Customizing SSMS Templates with Parameters

I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I...

Video – Identifying large queries using Extended Events

A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...

Converting Dates

I ran across a post recently where someone had dates stored as characters (never good), but also in this format:...

On Perspective

Perspective can make or break a career.  Maintaining a proper perspective is very often the differentiating factor between a good...

Runbooks in SQL Azure

Runbooks in SQL Azure
DECEMBER 2, 2014

SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable you to use PowerShell Scripts inside of SQL Azure...

Runbooks in SQL Azure

Runbooks in SQL AzureDECEMBER 2, 2014SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable...

Sequence feature TIP #76

Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...

SQL Saturday NYC Update #2

Just over 2 weeks now since SQL Saturday NYC went live and planning is in full force.  An update on...

SQL Server Bugs That Might Bite You

I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...

The Modern Data Warehouse

The traditional data warehouse has served us well for many years, but new trends are causing it to break in...