New built-in functions in SQL Server 2012

Introduction:
Microsoft SQL Server 2012 Release Candidate 0 introduces 14 new built-in functions. These functions will make the migration path for...

SQL Saturday #132 Pensacola and Wheeling, WV PASS UG

I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...

Backup duration statistics

Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...

Building a Presentation Map

This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

MDS and Best Practice Analyzer new features were introduced in sql...

Exercise in the Margins

This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting...

From the Labs of SQL Prompt

I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written....

The Done Stamp

I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...