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

Storage options for SQL Server database files in Azure

If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf).  Most...

Storage options for SQL Server database files in Azure

If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to...

What a Software Evangelist Does – and Where the Job is Going (Dear SQL DBA Episode 67)

I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software...

Beware! Beware of Unintended Changes When Altering Columns!

(last updated: 2019-01-15 @ 19:50 EST / 2019-01-16 @ 00:50 UTC )
I haven’t seen a lot written about these particular behaviors so I...

Central Management Server – not just three boring words

Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...

Central Management Server – not just three boring words

Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...

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

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