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 […]
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:
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
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.
This tutorial will discuss using variables with SQL DECLARE along with various examples.
Learn about filtered indexes in SQL Server, how they work, and how they can help improve performance.
Today Steve tasks data modeling and wonders how many people still build and maintain models.
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers