Creating a Striped Backup Set with AI
I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem...
2025-10-22
4 reads
I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem...
2025-10-22
4 reads
DBAs should never run SSMS under their everyday Windows account
If you open SSMS under the same Windows identity you use for email, browsing, and chat, you bring all that...
2025-10-22 (first published: 2025-10-07)
980 reads
In every organization there is a hidden currency more valuable than capital, more enduring than strategy, and more transformative than technology. That currency is feedback. Leaders who learn to...
2025-10-22 (first published: 2025-09-29)
99 reads
Disable the sa login in SQL Server (and sleep better)If you run SQL Server in 2025 and your sa login is still usable, you’re giving attackers a giant, blinking...
2025-10-21
16 reads
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs), DBAs sometimes face a frustrating scenario: replication stalls when a secondary replica or subscriber is...
2025-10-21
15 reads
I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...
2025-10-20 (first published: 2025-09-06)
1,402 reads
Change is inevitable. What separates thriving organizations from those that falter is not the scale of disruption but how leaders respond to it. In times of shifting technologies, evolving...
2025-10-20
7 reads
SQL Server 2025 introduces native support for vector data types and external AI models. This opens up new scenarios for semantic search and AI-driven experiences directly in the database....
2025-10-20 (first published: 2025-09-27)
1,357 reads
In less than one month, I will be speaking not once but twice at PASS Data Community Summit 2025.
Thursday, November 20th at 1 PM I will be in the...
2025-10-20
9 reads
It’s been a good year for me. With my sabbatical, I felt like I’ve gotten away from work quite a bit this year. I’ve had a few vacations around...
2025-10-20
13 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
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...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
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;