This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity Virtual Group entitled “3 Reasons Why Focusing on Tech Is The Worst Way To Deploy...
2021-08-02
13 reads
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel 9 where I discuss setting up Linux storage appropriate for on-demand disk expansion for your...
2021-07-29
92 reads
I’m thrilled to be presenting with Deji Akomolafe a new session at this year’s VMworld 2021 conference called “Virtualization Microsoft SQL Server on vSphere – Stories from the Trenches”...
2021-07-22
48 reads
Do you have quite large MDF files on your database? By large, I mean hundreds of gigabytes (or larger). Have you ever noticed that your SQL Server disk stall...
2021-07-21 (first published: 2021-07-08)
757 reads
I’m pleased to announce that this month’s presentation for the Microsoft Data Platform Continuity Virtual Group will be on July 29th at 2pm Eastern time. This presentation from Edwin...
2021-07-20
11 reads
I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...
2021-07-09 (first published: 2021-06-28)
256 reads
Disasters big and small happen, and as data professionals, you should be prepared for the worst! I’m thrilled to announce that we’re launching the Microsoft Data Platform Continuity Virtual...
2021-06-15
16 reads
With the rise of Kubernetes and other completely cloud-based deployments, on-premises data centers seem to be on the way out to make way for the scalability and dynamism of...
2021-06-08
11 reads
I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey. He recently recorded a different podcast that talks about the journey from being an IT...
2021-05-28 (first published: 2021-05-18)
94 reads
This past week I had a great Client ask an even greater question, and it got me thinking. The question is straightforward (albeit nerdy, which I love). “We’ve enabled...
2021-05-19 (first published: 2021-05-10)
891 reads
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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...
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