Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines
Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025
Don't Let Corner Cases Drive Your Design
When we design a database or system, we often do so with corner cases in mind. We don't have to do this.
Troubleshooting Common SQL Server Errors: 823, and 824
Learn about the critical 823 and 824 errors in SQL Server and how to deal with them in this article.
Random Number Generator in SQL using Marsaglia Polar
How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?
FinOps - the new name for performance tuning
This year I have been speaking with an increasing number of people about FinOps and what it means. Fundamentally, it is all about getting a handle on the cost for our technology spend. When we step back and look at the bigger picture it also has ramifications on corporate Environmental, Social, and Governance (ESG) programs […]
T-SQL in SQL Server 2025: The PRODUCT Function
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]
How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:
Done is Better than Good
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
Identify Unused Tables in SQL Server and Azure SQL
This article presents a way to discover those tables that are unused over a period of time, along with suggestions on how to get rid of these tables.
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers