Do You Support the Ancient Ones?
Do You Support the Ancient Ones?
Are you still supporting SQL Server 2000? How about 7.0 or 6.5?
Officially, Microsoft support has...
2009-03-29
2,224 reads
Blog Posts
Notes on the 2009 Orlando Code Camp
This was an interesting year to watch the local Code Camp. Shawn Weisfeld organized it the previous two years, but...
2009-03-29
1,434 reads
SQLBits a Smashing Success
SQLBits IV was held in Manchester, England, Saturday March 28th, 2009, and was attended by more than 360 attendees. This...
2009-03-29
2,100 reads
Tweet Your Job Away
A great example of how to “Tweet” poorly. This guy got fired before he started work.
Twitter is a series...
2009-03-27
1,757 reads
Android v Windows Mobile
I’ve had a number of cell phones in my life, probably more than many people. Typically I’ve just grabbed a...
2009-03-26
3,958 reads
Featured Blog - Brian Kelley
My friend Brian writes Databases, Infrastructure, and Security and like me, he writes about an eclectic mix that goes beyond...
2009-03-26
1,446 reads
Gone Dark
This afternoon was quite interesting around the office. A strong thunderstorm moved through the area, a common occurrence in Texas...
2009-03-25
1,400 reads
How to Deal with the Difficult Forum User
It has happened to us all at one time or another. We are trying to help someone on an online...
2009-03-25
1,554 reads
Launch Replication Monitor Without SSMS
I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs...
2009-03-25
847 reads
Minimalist Design
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,608 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