Last Week Reading (2022-01-02)
? Press Efficient Upserts into Data Lakes with Databricks Delta When MERGE on data lake is inefficient. Building a Data Mesh Architecture in Azure – part 1 With this...
2022-01-02
3 reads
Blog Posts
Source Control – The Best GUI For Productivity
Source control is quintessential to a productive development environment. A well maintained and organized source control system is akin to having known-good database backups. Having the right tools to...
2022-01-02
60 reads
Memory – How to Find when Excess is a Bad Thing
Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue. Memory grants are directly linked to the queries.
The post...
2022-01-01
118 reads
A Few #2021Wins
It’s the end of the year. I’m on vacation, celebrating time with family now, but I wanted to write this post. I got a prompt from LinkedIn last week...
2021-12-31
12 reads
Daily Coping 31 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-31
16 reads
Memory – How to Find when Excess is a Bad Thing
Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue. Memory grants are directly linked to the queries.
The post...
2021-12-31
382 reads
The Chili Shirt–Memories of Euan Garden
Early on in the history of SQL Server Central, we were offered the chance to work in a booth a TechEd and promote our little site. Brian Knight, Andy...
2021-12-31 (first published: 2021-12-13)
299 reads
Three-part virtual SQL Server learning this week
I’m thrilled to announce a three-part remote education event in conjunction with the Iowa SQL Server community! The topic is SQL Server IaaS and virtualization performance tuning, and it’s...
2021-12-31 (first published: 2021-12-12)
271 reads
2021 a year in review
No matter where you are in the world the last couple of years have been, shall we say, difficult. More ... Continue reading
2021-12-30
5 reads
Daily Coping 30 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-30
37 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers