Things I Learned at Summit v20 - Visual Studio Code

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll...

A curious case of case when and Null values

For some reason I have always written my Case statements using the following logic:

SELECT
CASE
WHEN @Priority = 1 THEN 'Very High'
WHEN @Priority...

Bulk insert and an identity column

TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...

Getting the SQL Version from a backup using dbatools ………. on PowerShell Core

Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and...

Lessons from the Phoenix Project–Leave Slack

Not @Slack, but slack time, time when you aren’t buried on a particular project.
In the book, The Phoenix Project, the...

Some databases may show a NULL collation in the sys.databases DMV

While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the...

Some differences with SQL Server when running on AWS RDS

If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then...

SQL Server Vulnerability Assessment

SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for...

T-SQL Tuesday #109–Influence

This month’s T-SQL Tuesday host is Jason Brimhall. He asks everyone to write about influence, which is something that I...

T-SQL Tuesday 109: To influence and to be influenced

The last T-SQL Tuesday of this year is hosted by Jason Brimhall – one of my long-time friends in the SQL...