Data Gravity
Does data have gravity? Will the law affect how applications are built and deployed? Steve Jones has a few thoughts.
2012-03-07
139 reads
Editorials
Zettabyte
Today we have an editorial originally published on Mar 13, 2007 that is being re-run as Steve is on vacation. This one looks at all the world's data.
2012-03-06
194 reads
Code Scanning
Today Steve Jones talks about code scanning and the analysis that tools can do for us today.
2012-03-05
200 reads
Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-05
267,356 reads
High Availability Upgrades
Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgrade for your company?
2012-03-02
264 reads
Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-01
338 reads
Use the 4th Dimension
Today Steve Jones talks about the conflicting demands of home and work and how you can reconcile the requirements of both.
2012-03-01
199 reads
The Cloud is good for your career
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
2012-02-29
267 reads
Taking a Sabbatical
Today we have a guest editorial from Andy Warren as Steve is on vacation. Today Andy discusses sabbaticals, and a change in his life.
2012-02-28
159 reads
Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
2012-02-27
280 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