Serious Storage
Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.
2013-03-19
210 reads
Editorials
The Backup Process
Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.
2013-03-18
202 reads
Inconsistency
This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.
2013-03-15
134 reads
The Gambler
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
2013-03-14
221 reads
Resetting DMVs
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
2013-03-13
183 reads
Self Describing Databases
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
2013-03-12
364 reads
Cloud Services. Waiting for the 'paint to dry'?
Despite recent 'outages', The canny CIO will make use of the obvious advantages of public cloud services where it risks neither security or availability. Adoption of the Cloud services and platforms is going to be most effective where the Cloud’s advantages of rapid scalability can be harnessed.
2013-03-11
83 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest. This editorial was originally published on May 20, 2008. It is being re-run as Steve is on vacation.
2013-03-11 (first published: 2008-05-20)
409 reads
2013-03-08 (first published: 2008-05-09)
179 reads
Productivity and Accountability
The recent decision by Yahoo to end telecommuting elicits some comments from Steve Jones on the topic of remote work.
2013-03-07
162 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