T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike Walsh. Mike’s call for us is to end the year on a poignant note –...
2025-12-24 (first published: 2025-12-09)
145 reads
Mala's Data Blog
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and community volunteer Taiob Ali – Taiob’s call is to blog on how AI, (the biggest...
2025-08-13
11 reads
TSQL Tuesday #188 Growing community
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call is about various ways to grow young data community/speakers. I’m going to take a brief...
2025-07-13
22 reads
Ethics, Productivity, Age and AI:How do these correlate with Developers’ Stances Towards AI at work, 2024
AI is deemed to be the new superpower. Adoption of AI in various capacities is at 72% across industries, world wide, according to one study, and it does not...
2025-07-01
25 reads
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video on any topic of your choice. I liked his reasoning for this and appreciate his...
2025-04-23 (first published: 2025-04-08)
219 reads
T-SQL Tuesday #184 Mentoring and Sponsorship
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin – Data Platform MVP, WIT co-lead and WITspiration founder. Deb’s invitation is to blog about mentoring and sponsorship. What...
2025-03-21 (first published: 2025-03-11)
6,659 reads
PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...
2025-01-22 (first published: 2025-01-13)
306 reads
T-SQL Tuesday 177 roundup: Managing database code
I was privileged to host yet another T-SQL Tuesday, for the month of August, 2024. My topic was on Managing database code. I was worried about getting responses, given...
2024-09-09 (first published: 2024-08-18)
324 reads
Managing Database code
This is my own contribution to the T-SQL Tuesday I am hosting – on managing database code. I am from the older generation – where the farthest we went...
2024-08-18
41 reads
T-SQL Tuesday 177: Managing database code
I am excited to host the T-SQL Tuesday blog party for August 2024. I’ve done this many times, but I always remember when I was new to the community...
2024-08-07
34 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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