Downtime Caused by the Postgres Transaction ID Wraparound Problem
Learn about transaction ID wraparound in PostgreSQL, which caused a problem for the author.
2026-02-23 (first published: 2026-02-13)
1,746 reads
Chandan Shukla
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Learn how backup and restore work in Azure SQL Hyperscale in this next level in the stairway series.
2025-12-17
781 reads
Stairway to Azure SQL Hyperscale Level 5: Data Growth and Fast Auto-Grow Mechanism
In this level, we learn about the database file size growth in Hyperscale.
2025-12-03
83 reads
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,032 reads
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Learn about unlogged tables and how they work in PostgreSQL.
2025-11-21
4,718 reads
MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Learn about a MySQL feature that could be useful in some scenarios for SQL Server.
2025-11-10
4,256 reads
Stairway to Azure SQL Hyperscale Level 4: Log Service and Transaction Management
Learn about how the Log Service helps manage transactions in the Hyperscale Tier.
2025-10-29
1,068 reads
How Implicit Transactions Hurt SQL Server Performance Without You Knowing
Learn about implicit transaction and why you might not want to enable this setting.
2025-10-24
6,457 reads
Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals
In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.
2025-10-08
423 reads
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Learn how a setting an improve high concurrency inserts with the OPTIMIZE_FOR_SEQUENTIAL_KEY option.
2025-10-01
6,006 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers