SQL Bits – Europe’s largest SQL Conference

4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...

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