SSDT: Build in VSCode

Over the last couple of years I have been using VSCode more and more and Visual Studio less and less, this is great but there isn't first class support...

SSDT: Build in VSCode

Over the last couple of years I have been using VSCode more and more and Visual Studio less and less,...

Input Into Azure Data Studio

I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going...

Pro SQL Server Linux–Connecting and Building an App

As part of my learning goals for 2018, I wanted to work through various books. This is part of my...

Defaults In msdb Database

The defaults in the msdb database are about what is missing. It's missing quite a few things that could be critical to your environment.
Related Posts:

SQL Server Configurations - Back...

Defaults In msdb Database

Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of...

Disabling Indexes

Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...

Cool Stuff in Snowflake – Part 4: Aliasing all the things

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....

My alternative to sp_WhoIsActive

I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...

How to Encrypt and Restore Your SQL Server Database Backups

We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...