What I Love About My Job
In June this year I took redundancy from the company I’d worked at for the previous 11 years. It was of course an uncertain time while I figured out...
2023-12-25 (first published: 2023-12-07)
211 reads
Blog Posts
A New Word: the whipgraft delusion
whipgraft delusion – n. the phenomenon in which you catch your reflection in the mirror and get the sense that you’re peering into the eyes of a strange, as...
2023-12-22
37 reads
Executing One Line in VSCode–#SQLNewBlogger
I wrote about arrays in PowerShell last week, but I realized one of the things I did while experimenting was look up how to run code a line at...
2023-12-22 (first published: 2023-12-11)
343 reads
Friday Flyway Tips–Above Target Migrations
Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and not others. I don’t recommend this, but a customer was doing this and I wanted...
2023-12-22
17 reads
How to Test Trace Flag 3625
Recently, one of my customers considered enabling Trace Flag 3625 on one of their SQL Servers, but they wanted a way to quickly test its functionality beforehand. For those...
2023-12-22 (first published: 2023-12-12)
524 reads
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in SSMS, but I wanted to learn how to use them in Azure Data Studio (ADS)....
2023-12-20 (first published: 2023-11-30)
329 reads
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to talk about which version of SQL Server you should be on, now that we’re at...
2023-12-20 (first published: 2023-12-05)
662 reads
Hello Microsoft Entra ID, good bye Azure Active Directory
A couple of months ago where I work, a major product started undergoing a rebrand. I don’t pretend to understand marketing folks, but a change this big needed to...
2023-12-19
462 reads
Last Weeks Reading (2023-12-17)
📰 News What happened in the DAX world in 2022 New DAX functions… in 2022 The Microsoft Learn Cloud Skills Challenge Microsoft Ignite edition is back! How to build...
2023-12-18
32 reads
Microsoft Fabric – the great unifier
I’m seeing a lot of excitement from customers over Microsoft Fabric, now that it GA’d a few weeks ago. One thing that is generating a lot of that excitement...
2023-12-18 (first published: 2023-12-12)
681 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers