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
2025-12-01 (first published: 2025-09-19)
2,517 reads
Articles
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.
2025-12-01
1,574 reads
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?
2025-12-01
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 […]
2025-11-28
8,387 reads
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:
2025-11-28
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.
2025-11-26 (first published: 2025-10-15)
15,048 reads
SQL Declare Variable Code Examples
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Learn about filtered indexes in SQL Server, how they work, and how they can help improve performance.
2025-11-24
4,663 reads
2025-11-24 (first published: 2018-09-24)
23,303 reads
The Version Store Won’t Clear If ANY Database Has Open Transactions.
Short story: what the title says.
2025-11-24
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers