Updated SQLSaturday Advisory Council
About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...
2011-05-17
699 reads
Blog Posts
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,132 reads
Colorado SQL Server User Groups – May
I saw a post from Marc Beacom on the presentations this week for various groups. You can get the info...
2011-05-16
751 reads
ColoradoSQL in May
All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so...
2011-05-16
738 reads
DBA’s, want to earn the big bucks? Learn BI
While there are many DBA’s who do business intelligence, or BI, I believe there are even more who do not. ...
2011-05-16
1,168 reads
May 2011 SQL Server 2008 Diagnostic Information Queries
Since we are in the middle of May 2011, I thought was was time to update my SQL Server 2008...
2011-05-16
639 reads
Notes from SQLRally Orlando–Part 3
Our last day went well, even extremely well. By day 2 (or day 3 if you attended a seminar) everyone...
2011-05-16
685 reads
Shuttle Endeavor last mission STS-134: I felt the shockwave
I witnessed a piece of history today at 8:56am; the last voyage of shuttle Endeavor on its STS-134 mission. It was...
2011-05-16
640 reads
What Are You Waiting For?
I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting...
2011-05-16
1,005 reads
An Update To My Previous Post
I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file. I’ve...
2011-05-13
557 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