SQL RNNR

Blog Post

Blackout

What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA. In support of the community, my site will be...

2012-01-18

2 reads

Blog Post

A Trio of Functions

I found myself perusing an execution plan the other day.  I know, big surprise there.  This execution plan showed me some interesting things I had never really paid much...

2012-01-17

7 reads

Blog Post

Meme15 Twitter

Twitter and Your Career With the new blog party on the block, we have Jason Strate (blog | twitter) asking us this month these two questions: Why should average...

2012-01-16

7 reads

Blog Post

Missing Indexes

SQL Server has means built into it to track possible missing indexes.  This used to be found through the use of the Index Tuning Wizard.  The process has improved...

2012-01-12

5 reads

Blogs

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By

Do you spend so long manipulating your data into something vaguely useful that you...

The Book of Redgate: SQL Server Central

By

It was neat to stumble on this in the book, a piece by me,...

Read the latest Blogs

Forums

Fun with JSON

By ateraa

Comments posted to this topic are about the item Fun with JSON

Creating JSON II

By Steve Jones - SSC Editor

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

Engineer Lessons

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Engineer Lessons

Visit the forum

Question of the Day

Creating JSON II

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

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO

See possible answers