Using Secrets in Docker Swarm for SQL Server
In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...
2023-08-23 (first published: 2023-08-02)
206 reads
Blog Posts
What’s in a SQL Server Managed Instance?
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading
2023-08-23 (first published: 2023-08-03)
457 reads
Creating and Configuring a Power BI VNet Data Gateway
If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can...
2023-08-21 (first published: 2023-08-01)
764 reads
Decrypting Stored Procedures with SQL Compare
I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...
2023-08-21
250 reads
Reflections on the Software Industry
Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...
2023-08-21 (first published: 2023-08-01)
172 reads
A New Word: Rückkehrunruhe
rückkehrunruhe – n. the feeling of returning from an immersive trip only to notice if fading rapidly from your awareness, as if your brain had automatically assumed it was...
2023-08-18
277 reads
Getting a Summary of Changes in SQL Compare 15
A client asked for a summary of changes, so I wrote this quick post to show where to find this in SQL Compare 15. If you use SQL Compare,...
2023-08-18 (first published: 2023-07-31)
177 reads
The DevOps Roadshow(s) from Redgate
I’m back from an office trip this week to Pasadena. I had the chance to go to the office, do some internal training for people, and spend time with...
2023-08-18
31 reads
Updated training list for a new DBA
Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training...
2023-08-18 (first published: 2023-07-31)
602 reads
Adding Copilot to Azure Data Studio and a Few Experiments
As a part of a recent Data Exposed that I was on, there was an ADS update which mentioned Copilot being added. Since I’ve been experimented, I decided to...
2023-08-17
80 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...
Storytelling with Data: Let's Practice!
Comments posted to this topic are about the item Storytelling with Data: Let's Practice!
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers