T-SQL Tuesday #040: File and Filegroup Wisdom
Backstory
Each month the SQL community comes together for an important party. This is the blog party that was the brain...
2013-03-12
1,070 reads
Jason Brimhall
T-SQL Tuesday #040: File and Filegroup Wisdom
Backstory Each month the SQL community comes together for an important party. This is the blog party that was the brain child of Adam Machanic (Twitter) known as T-SQL Tuesday....
2013-03-12
4 reads
March 2013 LV UG Meeting
Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area. This month we will be getting back on schedule with the usual...
2013-03-11
2 reads
March 2013 LV UG Meeting
Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area.
This month we will...
2013-03-11
895 reads
Is your LOG backed up?
You have been doing a fantastic job of late. You have all of your databases being backed up on a...
2013-02-12 (first published: 2013-02-11)
1,642 reads
Las Vegas February 2013 UG
I know it is right in the middle of TSQL2SDAY when this post is to go live. If you don’t...
2013-02-12
610 reads
Las Vegas February 2013 UG
I know it is right in the middle of TSQL2SDAY when this post is to go live. If you don’t know what that is, you should go check out...
2013-02-12
5 reads
Is your LOG backed up?
You have been doing a fantastic job of late. You have all of your databases being backed up on a regular schedule. Now you get an alert that your...
2013-02-11
2 reads
Join Operations – Nested Loops
This is part I of III in a series on the physical join operators in SQL Server.
2013-02-01 (first published: 2011-01-04)
26,736 reads
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server?
Are you wondering when...
2013-01-30 (first published: 2013-01-24)
4,207 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