2015-05-27
371 reads
Editorials
Hack Us
A challenge from United intrigues Steve Jones. How many other companies would make a challenge like this?
2015-05-26
189 reads
2015-05-25
80 reads
Native Audits
This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.
2015-05-22
147 reads
Naming Confusion
The naming of systems and other technological constructs is always a debate within groups. Steve Jones points out a few places where this might actually prevent mistakes.
2015-05-21
137 reads
Controlling Alerts
Being on call is not much fun for anyone, but it can certainly be hard on those that receive lots of calls for systemic issues. Are there better ways to manage this?
2015-05-20
136 reads
Awareness
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
2015-05-18
79 reads
Searching for Plans
Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.
2015-05-15 (first published: 2010-09-13)
283 reads
2015-05-13
833 reads
Opening Up Data
Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.
2015-05-12
100 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