Runing tSQLt Tests with Claude
Running tSQLt unit tests is great from Visual Studio but my development workflow isn’t just write tests, run tests, fix tests, run tests anymore, it is 2026 and...
2026-01-28 (first published: 2026-01-14)
557 reads
Blog Posts
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to boost memory or I/O, you had to scale the whole instance, paying for extra CPU...
2026-01-26 (first published: 2026-01-12)
226 reads
Learn Better: Pause to Review More
If you want to learn better, pause more in your learning to intentionally review.
2026-01-26 (first published: 2026-01-13)
219 reads
SQL, MDX, DAX – the languages of data
Ramblings of a retired data architect Let me start by saying that I have been working with data for over thirty years. I think that just means I am...
2026-01-23 (first published: 2026-01-12)
425 reads
Using Prompt AI to Help Setup Data Analysis
I used Claude to build an application that loaded data for me. However, there were a few others things I needed done to help me get the data ready...
2026-01-23 (first published: 2026-01-07)
284 reads
Using SQL Compare with Redgate Data Modeler
Redgate recently released SQL Compare v16, which included a new feature to work with Redgate Data Modeler. I decided to give it a try in this post. I’ll take...
2026-01-23 (first published: 2026-01-22)
26 reads
An LLM Saved My ATtiny85 From Certain Death
I almost ordered parts for a circuit that would have destroyed itself the instant I powered it on.
Instead, an LLM caught the critical flaw in my design, saving me...
2026-01-21 (first published: 2026-01-07)
256 reads
Learning from Mistakes: T-SQL Tuesday #194
We’re a week late, once again my fault. I was still coming out of the holidays and forgot to check on my host. Luckily, Louis Davidson (who did have...
2026-01-21 (first published: 2026-01-20)
50 reads
NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and DiskSpd results and analysis.
2026-01-21 (first published: 2026-01-07)
253 reads
Stupid Things I Did With AI: ASCII Art
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece of ASCII Art. I have a screenshot here: For some reason, I thought, “I should...
2026-01-20 (first published: 2026-01-19)
21 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers