Reblog: April 19 to April 25
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-26
1,035 reads
StrateSQL
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
846 reads
Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
499 reads
Last Weeks Top “Reading” Links #29
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-22
1,023 reads
Staggering SQLIO Sessions Across Multiple Volumes
In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able...
2013-04-22 (first published: 2013-04-10)
2,005 reads
Reblog: April 12 to April 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-19
877 reads
Backing Up Azure SQL Database to the Cloud
When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database....
2013-04-18
1,802 reads
Last Weeks Top “Reading” Links #28
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
482 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat211
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
445 reads
Presentation Materials “What Are You Waiting For?” #SQLSat211
After lunch, I led the session “What Are You Waiting For?” at SQL Saturday Chicago #211. It was another well-received...
2013-04-13
517 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