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

Great to see you at SQLSaturday Houston 2017

Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers....

Friday Reading 2017-06-16

Been looking forward to this weekend for a while now as it’s SQLSaturday Dublin tomorrow. I did a lightening talk...

Install SQL Server Agent on Ubuntu (Linux)

With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...