Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
736 reads
StrateSQL
Lost in Translation – Deprecated System Tables – sysreferences
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-28
1,336 reads
Querying Performance Counters in SQL Server
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. ...
2012-12-06 (first published: 2012-11-27)
6,791 reads
Help Bring #SQLFamily to Fargo, North Dakota
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,178 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
808 reads
Last Weeks Top 10 “Reading” Links #8
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
634 reads
Reblog: November 16 to November 22
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-23
648 reads
Lost in Translation – Deprecated System Tables – sysperfinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,331 reads
Lost in Translation – Deprecated System Tables – sysobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,559 reads
Lost in Translation – Deprecated System Tables – sysusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,769 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
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) GOSee possible answers