SQL Server Time Bombs
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental prod DBA) you’ve gotten that frantic call in the middle of the night. Or maybe...
2025-03-12 (first published: 2025-02-28)
571 reads
Book Review: A Radical Enterprise
I grabbed this book over the 2024 holiday season as it was on sale and recommended by the DevOps practitioners over at ITRevolution. A Radical Enterprise looks at a...
2025-03-14 (first published: 2025-02-28)
143 reads
Advice I Like: Investing and Growing Rich
Investing small amounts of money over a long time works miracles, but no one wants to get rich slow. – from Excellent Advice for Living This is incredible advice,...
2025-02-28
32 reads
The London Redgate Summit
In a week I’m heading to London for the Redgate Summit. I enjoyed these last year and had some very interesting conversations with customers, prospects, and a few Redgate...
2025-02-28
25 reads
Eliminating Unnecessary DELETE Operations
SQL Server performance issues often stem from easy fix bottle necks that can be fixed with the right tuning strategies. This short blog will focus on the DELETE statement....
2025-03-12 (first published: 2025-02-28)
775 reads
T-SQL Tuesday #183: Improving Permission Management
This is my (late) answer to my own invitation for T-SQL Tuesday #183. I was very busy a few weeks ago when the invite when out (glad it was...
2025-03-07 (first published: 2025-02-26)
450 reads
Enterprise Digital Exhaust
Digital exhaust, or data exhaust, is the information you generate as you interact digitally. We've typically thought of this in terms of tracking cookies and the like, but it...
2025-03-07 (first published: 2025-02-25)
204 reads
Monday Monitor Tips: VLF Alerts
A recent change made to Redgate Monitor to add a new alert for VLF count. This post looks at the change. This is part of a series of posts...
2025-03-03 (first published: 2025-02-24)
339 reads
Using T-SQL Snapshot Backup - Seeding Availability Groups
In this post, the fifth in our series, I want to illustrate an example of using the T-SQL Snapshot Backup feature in SQL Server 2022 to seed Availability Groups...
2025-02-24
150 reads
A New Word: Tangency
tangency– n. a fleeting glimpse of what might have been. I tend to live in the real world as it is, not too dreamy or wishful that things were...
2025-02-21
22 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers