Daily Coping 25 Nov 2022
Today’s coping tip is to connect with someone from a different generation. This tip makes me feel old. When I see “different generation” I used to think of someone...
2022-11-25
11 reads
Blog Posts
PASS Summit 2022 - Day 1 In Pictures
The first "full" day of PASS 2022 kicked off with a bang when Rohan Kumar (@RohanKData) stepped out on the keynote stage to announce SQL Server 2022 was GA...
2022-11-25 (first published: 2022-11-17)
223 reads
Select All in a Power BI Slicer–#SQLNewBlogger
One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want...
2022-11-25 (first published: 2022-11-09)
239 reads
Snowflake Classic UI vs Snowsight
This blog post is not about which User Interface is better, Classic or Snowsight – If anyone does want my feedback on what I like and don’t like about...
2022-11-25
235 reads
Daily Coping 24 Nov 2022
Today’s coping tip is to try a new way to practice self-care and be kind to yourself. One of the things that I learned to do better during the...
2022-11-24
5 reads
Daily Coping 23 Nov 2022
Today’s coping tip is to build new ideas by thinking “Yes, and what if…”. I tend to look for the holes, problems, limitations, and downside of various proposals. I’ve...
2022-11-23
9 reads
Testing the code (T-SQL Tuesday #156)
Foreword
Even though I picked the question, I struggled to answer it.
Following my train of thought - production code should be of the highest quality. To enforce quality, we use...
2022-11-23 (first published: 2022-11-08)
270 reads
What is production grade code? : T-SQL Tuesday #156
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
365 reads
Daily Coping 22 Nov 2022
Today’s coping tip is to do something playful outdoors. Easy. Skiing today. First day of the season. I started to add a daily coping tip to the SQL Server...
2022-11-22
13 reads
Daily Coping 21 Nov 2022
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
14 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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