The Three T’s of Backups

I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume,...

PASS Board Elections

Well, it is almost that time of the year again. Elections for the PASS Board. This is a great way to show your passion for this wonderful community...

Webinar with Rubrik: Simplifying SQL Server Data Protection – Near Zero RTO

I am very proud to contribute to a new webinar with Rubrik on Thursday, June 22 at 8AM PT / 11AM ET...

SQL Server TDE – Is TempDB Encrypted?

A really quick one today, something that made me think for a minute and I thought it might make others...

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...

Microsoft Professional Program in Data Science – Continued

A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...

Understanding Relative Risk – with T-SQL

In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...

Monday Coffee: SQL Saturday Dublin

Last weekend was SQL Saturday Dublin, and it was a good one.
My session on An introduction to SQL Server & Containers...

SQL Server Installed and Running on macOS In Less Than 5 Minutes (With Video)

SQL Server 2017 is the first version of SQL Server that will also run natively on Linux and on macOS...

PASS Board Elections

Well, it is almost that time of the year again. Elections for the PASS Board.

This is a great way to...