Gotta love the Information Age
First it was CNN 24x7. Next the Internet brought us live information from around the globe.
Now this... real-time pizza tracking...
2008-04-27
1,437 reads
Blog Posts
Orlando Heroes Launch Event
I attended this on Friday along with fellow oPASS members Mike Antonovich and Ulysses Vasquez to represent PASS, and we...
2008-04-27
1,507 reads
SQL Server in the Cloud
The April 15, 2008 edition of SDTimes (PDF download here) has some information about SSDS, the SQL Server in the...
2008-04-27
1,507 reads
Recent slate of IIS attacks - more info
The recent slate of attacks on IIS servers don't seem to be an attack directly against IIS or against SQL...
2008-04-26
2,198 reads
Cursors and high gas prices
Using cursors is a controversal topic. As a former developer, that is the way I thought about processing data at one...
2008-04-25
1,392 reads
I've got a date with an Error Log -- Error Logs Part II
Error Logs Part II -- Enumerating the error logs
In my first post on SQL Server Error Logs, I briefly mentioned using...
2008-04-25
1,749 reads
More LINQ Discussion
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,771 reads
Tribute to Jim Gray
Ran across this in the Mar/Apr ACM Queue, http://www.eecs.berkeley.edu/IPRO/JimGrayTribute/ will be held at UC Berkeley on May 31st, 2008. Jim Gray...
2008-04-24
1,358 reads
Desktop or Laptop
Most of that do any time of training or consulting typically use laptops, and they are even reasonably common in...
2008-04-23
1,614 reads
Difference between truncate and delete
This is an old topic and well documented, just google it and I believe you will get a lot,
However,...
2008-04-22
2,223 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