Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-27
4,181 reads
Jason Brimhall
Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,412 reads
Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-24
1,665 reads
Sp_whoAmI
I was doing a little catching up on some blog reading today and came across a new post from Adam...
2010-08-24
929 reads
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
503 reads
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred?
Recently I have been working...
2010-08-17
770 reads
S3OLV August Recap
The SQL Server Society of Las Vegas meeting has come and gone once again. This meeting is held typically on...
2010-08-16
432 reads
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time
I hope you enjoyed your time in the sun with your toes in the sand. We...
2010-08-13
793 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
743 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
468 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