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
52 reads
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
52 reads
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
42 reads
🌐 What is Azure SQL Migration Extension? The Azure SQL Migration Extension for Azure Data Studio is a powerful tool that simplifies the process of migrating on-premises SQL Server...
2025-08-27 (first published: 2025-08-06)
225 reads
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL Server is the problem. And “slow” means nothing without context and ability to verify. More...
2025-08-27 (first published: 2025-08-06)
491 reads
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
87 reads
Microsoft’s latest wave of announcements in July 2025 offers a compelling snapshot of how the tech giant is navigating innovation, security, and global responsibility. For tech leaders, these updates...
2025-08-25 (first published: 2025-08-04)
527 reads
Following on from my previous post about hitting the Kubernetes API from SQL Server 2025 let’s go a little further and deploy SQL Server 2025 to Kubernetes from…SQL Server...
2025-08-25 (first published: 2025-08-01)
256 reads
How long has AI been around in different domains? What was it called before we starting using the phrase, "Artificial Intelligence?" Is Clippy included in said history? Here is...
2025-08-22 (first published: 2025-08-05)
500 reads
rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain...
2025-08-22
11 reads
Let's build a real data dashboard. This guide will walk you through the entire process using free tools like BigQuery and Looker Studio, even if you’re just getting your...
2025-08-22 (first published: 2025-08-04)
963 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;