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
84 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
109 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)
879 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)
227 reads
SQL Server 2025 Release Candidate Available
For those testing SQL Server 2025 before it officially releases, Microsoft has made the first release candidate available. There's a lengthy article on all the new features that are...
2025-08-26
141 reads
SQL Server 2025 Backup Compression and Restore Review
SQL Server 2025 In my previous blog post, we briefly covered the new compression being introduced in SQL Server 2025. After some...
2025-08-26
5 reads
Scooby-Doo and the Mystery of Cloud Costs (Let’s have some fun!) – Scooby Dooing Episode 1
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other database performance tuning isn’t just about faster queries—it’s directly tied to your bottom line in...
2025-09-10 (first published: 2025-08-25)
317 reads
Fabric Real Time Data: Making the Shift from Batch to Live Insights
Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations transform raw information into actionable insights. For decades, leaders have relied on batch processing as...
2025-09-17 (first published: 2025-08-25)
147 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers