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

PASS Summit 2016-Thursday Part II

The second half of the day was spent talking with various speakers and attendees. I got into a great conversation...

PASS Summit Announcements: DMA/DEA

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  My next few blogs...

Power BI with Narrative Science: Look Who's Talking (Part 2: Predicting the Future)

[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well...