Sweeping out SQL Server 2005
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
150 reads
Editorials
QA for Data
Often DBAs and developers might make quick data changes to correct user problems or application shortfalls. Steve Jones notes that we can make mistakes, and perhaps we should ensure we QA, or at least log, our changes.
2015-04-16
150 reads
Don't exaggerate the difficulties of the RDBMS
Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".
2015-04-13
156 reads
Pre-built or Ad Hoc
Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.
2015-04-13
152 reads
Kanban
Steve Jones talks about organizing and tracking work with kanban and how that might help you.
2015-04-07
326 reads
The Devil's in the Details
This week Steve Jones notes that the little details can sometimes have a big impact in your code.
2015-04-06
150 reads
Your Cloud Held Hostage – Could It Happen?
Today's guest editorial by Andy Warren is more of a movie plot than reality, but perhaps it's worth considering.
2015-04-06
135 reads
Large Chunks of Data
This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it's just wasting space.
2015-04-03 (first published: 2010-09-17)
361 reads
2015-04-01
313 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
152 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