A Recap of PASS Summit 2016

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I...

DB CI: Getting Test Results in VSTS

One of the things I struggled with a bit was getting test results to appear in VSTS from my builds....

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...

t-sql random string generator

Note: originally published in our old blog on December 2008.

CodeProject
This is a simple stored procedure that you can use to generate a random string. You can use it...

t-sql random string generator

Note: originally published in our old blog on December 2008.

CodeProjectThis is a simple stored procedure that you can use...

Why Halloween slowed your queries

Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...

Thank you to @MrDenny

I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.

For...

Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...

PASS Summit 2016 Recap

It has been a fantastic week here in Seattle at the annual PASS Summit. I’ve spent the last five days...