SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup files
2019-11-26 (first published: 2019-11-18)
249 reads
Blog Posts
When a SQL UPDATE Statement DELETES Rows
Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...
2019-11-26
11 reads
When a SQL UPDATE Statement DELETES Rows
Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...
2019-11-26
11 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
10 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
8 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
11 reads
Monday Morning Module Maintenance Monoliners
Or: Andy Authors An Amazing Alliteration
Do enough work with PowerShell and you’ll build up a decent collection of modules installed from the gallery into either your computer or your...
2019-11-25
7 reads
SQLSaturday Orlando Notes – Cupcakes & Ice Cream
For the past few years we’ve had a a local sponsor provide cupcakes as the “sweet treat”. We started with mid afternoon but found it worked well if we...
2019-11-25
19 reads
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the ... Continue reading
2019-11-25 (first published: 2019-11-14)
1,138 reads
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with the new SQL Server 2019 RTM images. Microsoft changed the way SQL runs within a...
2019-11-25 (first published: 2019-11-18)
3,678 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers