Article Of the Week
I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way...
2009-08-24
945 reads
SQLDownSouth
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,269 reads
August SQL Server User Group – Near Real-time Data Warehouse
Well we had a really good meeting this week at our User Group. There were about 17 physical attendees and...
2009-08-19
853 reads
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
2009-08-17
1,272 reads
Upgrading To Windows 7
Well I spent most of this past Saturday upgrading my Laptop to Windows 7 Ultimate, which I have to say...
2009-08-13
751 reads
Database is in Transition
One of my clients called saying they were receiving the following error when trying to access a database: "Error 952...
2009-08-12
7,037 reads
LIVE MEETING REMINDER - Baton Rouge SQL Server User Group
Reminder: The Baton Rouge Area SQL Server User Group will be broadcasting its user group via live meeting. If you...
2009-08-12
453 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
81,712 reads
Baton Rouge SQL Saturday – Evaluation Summary
Well I just finished reviewing the evaluations for my presentation, Introduction to SQL Profiler, which I gave at the Baton...
2009-08-07
482 reads
Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,358 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