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

PowerBi and API – Visualising my Checkins

For my own amusement and also to show my wife where I have been I use the Swarm check-in app...