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
16 reads
Blog Posts
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)
521 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)
326 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)
652 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
452 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
23 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)
668 reads
Set-Based vs Row-Based Database Code
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...
2023-12-18 (first published: 2023-12-01)
604 reads
A New Word: Nementia
nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering...
2023-12-15
47 reads
Comparing Two Scripts with kdiff3
I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw...
2023-12-15 (first published: 2023-11-27)
400 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers