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

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

Watch my PASS Summit Session on PASS TV

I’m just returning from an amazing week at PASS Summit where I meet many of you while working our Pragmatic...

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

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

The Halloween Problem

DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really...

Master Data Services – Database Error has Occured when Publishing Business Rule

I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016....

PASSion Award and what it means to me

2016 is going to be a special year in my life. There was an article on Oscar awards a while...

Thank you to @MrDenny

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

For...