SQL Server 2012 Service Pack 1 CU5
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I...
2013-07-23
1,492 reads
Glenn Berry
OT: Kicked Out of a Motel for Charging at 12 Amps
This is a pretty long story…
My wife and I had an interesting road trip to Salida, CO this past weekend,...
2013-07-16
1,293 reads
SQL Server Diagnostic Information Queries for July 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-07-09
1,147 reads
SQL Server 2008 R2 Cumulative Updates Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 R2 Service...
2013-06-17
1,631 reads
Speaking in Denver and Boulder in June
I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL...
2013-06-06
945 reads
New Immersion Event Classes at SQLskills
There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the...
2013-05-28
837 reads
Tesla Time
I now have a red, P85 Tesla Model S. I picked it up at the Denver Tesla Service Center on...
2013-05-14
1,314 reads
SQL Server 2005 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-08
833 reads
SQL Server 2008 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-08
700 reads
SQL Server 2008 R2 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
746 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