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

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools....

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get 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...

PASS Board Elections

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

This is a great way to...

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

PASS Security VC Presentation – The Dirty Business of Auditing

On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...

Powershell Module Improvements for SQL Server in 2017

simple setup
A major improvement that seems to have quietly slipped into the sql developers world is an improved SQLServer powershell...

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

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