StraightforwardSQL

Blog Post

My Toolbox - SSMS

No matter how hard Azure Data Studio (ADS) is pushed by Microsoft, most DBAs still use SQL Server Management Studio (SSMS). In this blog post, I’ll go through my...

2024-08-14 (first published: )

863 reads

Blog Post

Async stats update causing blocking

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...

2024-07-03 (first published: )

92 reads

Blog Post

Advent of Code 2022

Foreword
Advent of Code is an annual event in which participants solve a series of coding puzzles. It typically begins on December 1 and runs through the end of the...

2022-12-23 (first published: )

155 reads

Blog Post

T-SQL Tuesday #156 - Wrap Up

Foreword
Thank you everyone for participating! There is a total of 15 submissions and thanks to them, I’ve widened my perspective.
The order of the posts is chosen at random.
Greg Moore
Contribution|Blog|Twitter
Greg...

2022-11-17

12 reads

Blogs

Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution

By

For decades, enterprises have approached data management with the same mindset as someone stuffing...

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

Read the latest Blogs

Forums

Technological Dinosaurs or Social Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?

DBCC CHECKIDENT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKIDENT

Distributed Availability Group Health: T-SQL and Zabbix

By Pablo Echeverria

Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...

Visit the forum

Question of the Day

DBCC CHECKIDENT

What is returned as a result set when I run this command without a new seed value?

See possible answers