The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they...
2019-07-08 (first published: 2019-06-25)
311 reads
The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources. Another way...
2019-06-20 (first published: 2019-06-06)
1,743 reads
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event last week, the major announcements in the data platform and AI space were: Machine Learning...
2019-05-30 (first published: 2019-05-16)
309 reads
As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...
2019-04-25
2,174 reads
I recently made available two more presentations that you might find helpful. Feel free to download them and present them to others (adding a line that you got them...
2019-04-04
66 reads
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data...
2019-03-14
2,271 reads
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes...
2019-03-14
291 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We all know technology changes so quickly so there is...
2019-03-11
14 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2019-03-11
362 reads
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
2019-02-19
805 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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