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,078 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,311 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,112 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)
14,403 reads
SQL Declare Variable Code Examples
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
Fixing "Login failed for user" error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2025-11-25 (first published: 2020-11-24)
51,566 reads
PowerShell Day By Day: The Pipeline
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2025-11-25 (first published: 2020-12-31)
4,314 reads
2025-11-25 (first published: 2025-04-16)
1,536 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers