It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to...
2011-09-01
440 reads
Tim Radney
Shrinking Transaction Logs
I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space...
2011-08-31
2,194 reads
PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for...
2011-08-30
1,398 reads
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course...
2011-08-24
700 reads
Adding an Index to Save Space
Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that...
2011-08-17
1,037 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
548 reads
Data Warehousing with SSIS
As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with...
2011-08-08
1,580 reads
If You Aren’t Measuring It, You Can’t Manage It
It sounds simple and logical doesn’t it. One could say it is common sense right? How many of us are...
2011-08-08
526 reads
I Am Going to Be a Big Brother #sqlpass #firsttimers
Well at the PASS Summit at least. The Summit is trying to make sure that all of our first timers...
2011-08-05
1,121 reads
Register for 24 Hours of PASS NOW! #sqlpass
Do you need to perfect your SQL Server skills? Would you like to get 24 hours of free SQL Server...
2011-08-03
577 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