SQL in the City/PASS Summit
My great organization, Redgate, is doing things a little different this year at PASS Summit. Instead of hosting our own event, we’ve decided to host a pre-con at the...
2019-10-08
54 reads
Blog Posts
SQL Server Admin Best Practices with DMV's at GroupBy
Excited to be presenting at virtual GroupBy Conference for the first time on Thursday, during the North America time slots. I just finished tuning up this old presentation that I've presented...
2019-10-08
53 reads
T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
57 reads
T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
8 reads
T-SQL Tuesday #119 - Changing Your Mind
For T-SQL Tuesday this month, Alex Yates (blog | twitter) gives us this challenge:
I would like you to write about something in your IT career that you have changed...
2019-10-08
5 reads
T-SQL Tuesday #119 – Changing Your Mind
This month Alex Yates (B|T) is hosting T-SQL Tuesday which is a monthly blog party started by Adam Machanic (B|T) and co-ordinated by Steve Jones (B|T) The challenge that...
2019-10-08
80 reads
T-SQL Tuesday #119 – What changes my mind
T-SQL Tuesday series (the monthly blog party) has been started by Adam Machanic and co-ordinated by Steve Jones. This month’s topic is hosted by my friend Alex Yates. He...
2019-10-08
16 reads
T-SQL Tuesday #119–Changing My Mind
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
18 reads
A #DevOps Discussion on Thursday with Abel Wang
I’m hosting a webinar later this week with Abel Wang, one of the talented members of the League of Extraordinary Cloud DevOps Advocates at Microsoft. This Thursday, October 10,...
2019-10-07
47 reads
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading
2019-10-07 (first published: 2019-09-23)
839 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