Attaching All Databases with PowerShell–Checking All Databases
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-05-27
1,306 reads
Blog Posts
Building The SQLSaturday Orlando Marketing Plan-Part 13
Here is the second of the two flyers I ordered from fiverr.com (see the first one here). The center image...
2014-05-27
548 reads
Escaping from a runaway Logon trigger
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...
2014-05-27 (first published: 2014-05-19)
1,756 reads
Get User In Reporting Services-Question of the Day
Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....
2014-05-27
508 reads
How Much Value Would a SQLSaturday Certificate of Completion Have?
Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...
2014-05-27
699 reads
NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)
This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.
If you are interested,...
2014-05-27
376 reads
SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014
This event promises to be a highlight of the Canadian SQL Server calendar year.
The presenters are all 'first class'.
All...
2014-05-27
807 reads
Webcast Follow-Up: 5 SQL Server Indexing Myths
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-05-27
898 reads
Attaching All Databases with PowerShell–Finding My MDF Files
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-05-26
1,530 reads
Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,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