Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
868 reads
Blog Posts
Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By
In a previous blog written back in June, I showed you how to use the interactive sort option on a...
2010-11-04
1,841 reads
MDX - Color Formatting on All Measures at Once
In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services...
2010-11-04
2,942 reads
Powershell and Performance Monitoring
When I was doing performance monitoring of servers, I typically struggled with a good way to get the data. In...
2010-11-04
795 reads
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,141 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th,...
2010-11-04
513 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th, the first Thursday of the month rather than the...
2010-11-04
4 reads
Slides and Example Code for SQL Lunch #42 - Auditing Database Permission in SQL Server
As promised, here are the slides and sample code from my SQL Lunch presentation today. Thanks for all who came...
2010-11-04
685 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
596 reads
SQLSaturday #59 Speaker Interview Series #17 with Bill Pearson
SQLSaturday #59: Speaker Interview Series #17 with Bill Pearson
Today, we pick up the series, with another worldly well-rounded individual, by...
2010-11-04
781 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
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