Isolation Levels in SQL Server
Do your eyes start to cross whenever you think about isolation levels? Mine did, too. Here's how I keep it all straight.
2019-04-03
34 reads
The Non-Cluttered Index
Distributed Replay Utility – The Search for the Cure
The Complaint(s) When I was young, I went to nursing school. In school, we were taught that in order to come up with a proper diagnosis, the doctor first...
2019-04-01
38 reads
The Distributed Replay Utility: Replaying for Real (Where Could It Possibly Go Wrong)?
The Short Answer? (In at least a couple of places) When I first learned about the DRU, I was very excited about the possibilities. I began to play with...
2019-03-28
11 reads
Capture/Replay a Sample Workload on the Distributed Replay Utility
Part I: Capture a Workload Make a backup of the database(s) in question, as it will be necessary for the replay. Using the TSQL Replay template, fire up Profiler...
2019-03-26
65 reads
Improving Performance of the Distributed Replay Utility on SQL Server 2012
Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...
2019-03-24
191 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers