T-SQL Tuesday #47: Your Best SQL Server SWAG
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit...
2013-10-07 (first published: 2013-10-03)
1,665 reads
Blog Posts
Wrapping Up The 2013 PASS Election-Part 3
Today I’ll continue with my notes and thoughts on the 2013 election process and a good place to start is...
2013-10-06
717 reads
One-stop Shopping for Backups
First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing...
2013-10-05
377 reads
Wrapping Up The PASS 2013 Election–Part 2
I watched the election this year with interest and the advantage of having seen PASS elections from a number of different...
2013-10-05
674 reads
Disaster Recovery and Business Continuity
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,163 reads
Reblog: September 27 to October 3
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-04
936 reads
SQL Server Analysis Services Activity Viewer 2012 1.0.0.1 Beta Released
(Worth noting that there is a more recent version available here!)
Hi all, yesterday morning I created a project based on an old blog post Upgrade Analysis Services Activity Viewer...
2013-10-04
6 reads
The SQL in the City Tour is Almost Here
Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for...
2013-10-04
718 reads
DevConnections Slides and Code
I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of...
2013-10-03
590 reads
Does Business Intelligence equal Data Warehousing?
I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these...
2013-10-03
933 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