SQL Power Doc Update - Version 1.0.2.1
I'm at the 2013 PASS Summit in Charlotte, NC, this week, and presented a session about documenting your databases using...
2013-10-17
1,267 reads
Blog Posts
Top 10 Tips when synchronising your database and Mailchimp
Okay, sooner or later someone is going to need to synchronise all those people who registered on your company website...
2013-10-17
585 reads
Cluster failover fails
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
885 reads
Getting Started with CI and Databases
It’s fairly easy. At least, I think it is if a salesperson can do it.
Alex Yates, salesman extraordinaire at Red...
2013-10-16
827 reads
I’ve refreshed a test database from prod but now the users can’t access it.
This happens to me all the time. I get a request from a developer to overwrite the test copy of...
2013-10-16 (first published: 2013-10-09)
2,666 reads
Liveblogging PASS Sumit Day 1 Keynote with Quentin Clark (#SQLPASS #Summit13)
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
518 reads
LogReader agent failed
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
830 reads
PASS 2013 Keynotes Live Day 1
Final thoughts Dear Reader. This is a big launch year for Microsoft and we are getting some very cool toys...
2013-10-16
711 reads
PASS Summit 2013 - Day 2 - Highlights Q&A - What Are You Presenting On?
Today, October 16, 2013: PASS DAY2
PASS Summit Day 1……complete……..Great learning, check! Awesome sessions and nuclear networking! You can read my...
2013-10-16
1,127 reads
PASS Summit 2013 – Day 2: The PASS Spirit
This is my second day into the PASS Summit 2013, and the excitement is still rising. My first day was...
2013-10-16
391 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