SQL In The Wild

Blog Post

First Impressions

SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...

2010-11-09

1,427 reads

Blog Post

Come and gone

Or “Plan cache monitoring – insert and remove”
Previously I took a look at the CacheHit and CacheMiss events to see how...

2010-08-31

1,812 reads

Blog Post

Hit and miss

Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...

2010-07-27

1,131 reads

Blog Post

DBA Hell

On the first day of DBA hell, the server gave to me

A database with damaged system tables and no good...

2010-06-15

963 reads

Blogs

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Creating JSON I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON I

Expensive CPUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expensive CPUs

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers