Using Customer Docker Compose File Names
As I use containers more and more to run various things, I decided I not only wanted to set up docker compose files, I wanted to name them something...
2025-09-26 (first published: 2025-09-03)
355 reads
SQL Server Failover Cluster Instances
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve heard of Failover Cluster Instances (FCIs). They’ve been part of SQL’s high availability toolbox since...
2025-09-19 (first published: 2025-09-03)
214 reads
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs encounter: accessing a SQL Server instance when you don’t have the SA password, and no...
2025-09-17 (first published: 2025-09-02)
1,569 reads
Secure Your SQL Estate: Best Practices for Azure SQL Security
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital estate – a castle of data, with towers of insight and vaults of sensitive information....
2025-09-22 (first published: 2025-09-02)
452 reads
The Book of Redgate: Meetings
I think we might have forgotten this a bit, but on one of the pages, we have this title: A Meeting without an Objective is a Chat. You can...
2025-08-29
58 reads
New article: Automating SQL Server Builds
I refresh my test SQL Servers at least monthly with a fresh VM. Setting up directories, installing SQL Server, setting up security, and restoring databases all take time. And...
2025-08-28
83 reads
Leading with Accountability: How Extreme Ownership Transforms Leadership
Embracing Total Responsibility In every organization there comes a moment when teams must choose between passing blame or owning every outcome. The mindset of extreme ownership calls on leaders...
2025-08-28
19 reads
Unlock Your Notion Data with SQL
If your Notion workspace feels more like a data graveyard than a command center, you're not alone. I’ll show you how to connect SQL to your Notion setup so...
2025-08-28
101 reads
How to Reset the SA Password When You Get Locked Out
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved...
2025-09-15 (first published: 2025-08-27)
841 reads
SQL Server Log Shipping: The Tried and True of DR
It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....
2025-09-15 (first published: 2025-08-27)
226 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
ALAMAT BCA KCU SUBANG Telp:08218154393
WA:08218154393 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers