Redefining Tech Leadership in the Age of Microsoft AI
AI is no longer a niche capability – it is a leadership catalyst. As Microsoft continues to push boundaries with tools like Azure and Fabric, the demands on today’s...
2025-07-14
19 reads
AI is no longer a niche capability – it is a leadership catalyst. As Microsoft continues to push boundaries with tools like Azure and Fabric, the demands on today’s...
2025-07-14
19 reads
A friend was asking for help with some data analysis. This was in PowerBI, and the source data was PII. I asked them to mask the data for me...
2025-07-14
32 reads
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
I may think I'm trying to reach the crowd, but I'm really trying to reach each person within the crowd. The "crowd" doesn't actually exist.
2025-07-11 (first published: 2025-06-24)
111 reads
Measuring and Improving SQL Server Query Plan Cache Efficiency
The query plan cache hit ratio in SQL Server indicates the percentage of queries that are executed...
2025-07-11 (first published: 2025-06-24)
623 reads
I am honored to announce that I have been renewed as a Microsoft MVP for the ninth consecutive year, recognized in the Azure SQL and SQL Server technical areas...
2025-07-11
29 reads
I am honored to announce that I have been renewed as a Microsoft MVP for the ninth consecutive year, recognized in the Azure SQL and SQL Server technical areas...
2025-07-11
4 reads
It’s been forgotten about and neglected for few years but I’ve decided to dust off the cobwebs and revive our YouTube channel. Keep an eye on it, every new...
2025-07-11
22 reads
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT and Agile In the realm of IT operations and software development, not all tasks are...
2025-07-10
31 reads
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet in question was New-AzRoleAssignment, but the cmdlet itself isn’t important. What is important is that...
2025-07-09
62 reads
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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