SQL Server 2008 SP3 CU1
Microsoft has been busy getting SQL Server Cumulative Updates released over the past couple of days. The latest release is...
2011-10-18
707 reads
Glenn Berry
SQL Server 2008 R2 RTM CU10
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 10. This is Build 10.50.1807.0, and it has 13 listed...
2011-10-18
826 reads
SQL Server 2008 R2 SP1 CU3
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 3. This is Build 10.50.2789.0, and it has 22 listed...
2011-10-18
1,158 reads
Scaling SQL Server
On Friday, October 14, 2011, I had the pleasure of delivering my new Scaling SQL Server presentation at the PASS...
2011-10-17
803 reads
Liveblog for Day 2 Keynote at SQL PASS Summit 2011
There are four racks of servers and storage on stage for today’s keynote complete with roaring fans and flashing lights....
2011-10-14
600 reads
Liveblog for Day 1 Keynote at SQL PASS 2011
It is hard to live tweet or live blog when the Wi-Fi is not working reliably. The keynote starts out...
2011-10-12
616 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,097 reads
New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,341 reads
Microsoft Releases SQL Server 2008 SP3 RTM
Microsoft has released the final, RTM version of SQL Server 2008 Service Pack 3. This is build 10.00.5500. It includes...
2011-10-07
1,641 reads
September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,242 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