Default Schemas

The Time to Patch

Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]

Delaying the code

Exporting Data with PowerShell

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]

Finding Motivation to Learn

There isn't a good excuse to avoid investing in yourself.

Prompt in ADS

Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...

Getting a Dictionary

Happy New Year 2020

Happy New Year from SQLServerCentral and Redgate Software.

Looking Back at the Decade

Today is the last day of 2019, and the last day of the 2010 decade. I'm still somewhat amazed by the fact that we're entering the 2020s and we still don't really have flying cars. We're well past 2001 and 2010, and still not much space exploration, though the growth in computing power and AI/ML […]

The End of 2019