How to take Database backup in SQL SERVER
This article explain the simple way to take up the backup of a database which can be easily understandable by...
2014-08-17
913 reads
Blog Posts
Friday Followup For August 15, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-15
649 reads
Murder in Raleigh
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-08-15 (first published: 2014-08-04)
7,922 reads
Notes From the August 14, 2014 ONETUG Meeting
ONETUG team graciously gave me time at the beginning of the meeting to talk about the upcoming SQLSaturday OrlandoAsked them...
2014-08-15
631 reads
PASS SQL Saturday Events: September 2014
DateEventSeptember 6 SQLSaturday #301 – Cape Town 2014September 6 SQLSaturday #320 – Raleigh 2014September 13 SQLSaturday #323 – Paris 2014September 13 SQLSaturday #300...
2014-08-15
713 reads
PASS Virtual Chapter Events: August 2014
DateTimeTitle LinkAugust 15th 12:00 EST Manage Your Shop with CMS and Policy Based Management https://attendee.gotowebinar.com/register/4279519516082609665August 19th 11:00 CST The Roadmap...
2014-08-15
590 reads
Please please tell me now…
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
398 reads
Reblog: August 8 to August 14
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-08-15
708 reads
SQL Downgrades Made Easy
I was reading Kendra Little’s ( b | t ) post on SQL Server Edition Changes and it reminded me of the work...
2014-08-15 (first published: 2014-08-06)
8,854 reads
SQLSaturday Orlando Marketing Plan-Part 35
Quick update on registrations. We’re at 287 as of noon on August 15th, not bad. The blue part of the...
2014-08-15
517 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