Seven Reasons You Should Attend SQLBits 7
SQLBits is Europe’s Largest SQL Server Event
That’s right, just take a moment to let that point hit home. If you...
2010-07-22
866 reads
John Sansom
Simplify Your DBCC CHECKDB Output
"Defend Your Data"
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to...
2010-07-14
521 reads
Jump Start Your SQL Server Learning Today (T-SQL Tuesday)
One of the great things about working with SQL Server is the opportunity to be involved in our fantastic SQL...
2010-07-13
577 reads
How to Provide Great Feedback
As a DBA you will encounter processes, code and design decisions within your environment that require change for the better....
2010-07-01
609 reads
The Politics of SQL Server Performance
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,516 reads
How much memory is each SQL Server database using?
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify...
2010-06-25
563 reads
With Great Advice Comes Great Responsibility
I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...
2010-05-02
571 reads
Part 2: Why you should be using the Full Recovery Model
Part 2 of the SQL Server Essentials Series looks at why you should be using the Full Recovery Model to protect your data assets.
2009-09-21
9,090 reads
SQL Server Memory Configuration, Determining MemToLeave Settings
Tweaking SQL Server memory settings to provide support for managed code.
2009-07-06
12,371 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