Supported Compatibility Levels in SQL Server
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in...
2014-05-21
17,390 reads
Jason Brimhall
Supported Compatibility Levels in SQL Server
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode. This setting is something that can...
2014-05-21
12 reads
T-SQL Tuesday #54 – Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring...
2014-05-16 (first published: 2014-05-14)
1,760 reads
Missing Indexes Script v2
As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a...
2014-05-15
7 reads
T-SQL Tuesday #54 – Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring of SQL Server Professionals. This is a...
2014-05-14
2 reads
Omaha BI/SQL User Group – What?
I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in May. Imagine my surprise when reading the email...
2014-05-07
4 reads
Omaha BI/SQL User Group – What?
I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in...
2014-05-07
770 reads
T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard
It is April and April Fools has only just begun. Well, or so Matt Velic (blog | twitter) would have us...
2014-04-08
974 reads
T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard
It is April and April Fools has only just begun. Well, or so Matt Velic (blog | twitter) would have us believe. Matt decided that this month for TSQL...
2014-04-08
6 reads
SQLSaturday Vegas Style
We are mere moments from the inaugural SQL Saturday (announced a few short months ago) event in fabulous Las Vegas, Nevada. Can you feel the excitement building? The SQLSat...
2014-04-03
5 reads
Blogs
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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