T-SQL Tuesday #61 – Giving Back

It just seems to me that these block parties of T-SQL Tuesday come quicker each month. I’m always thrilled when...

DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do...

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...