The public preview version of Azure Synapse Analytics has three compute options and four types of storage that it can access (mentioned in my blog at SQL on-demand in...
2020-09-23 (first published: 2020-09-16)
279 reads
I am starting to see this relatively new phrase, “Data Lakehouse”, being used in the data platform world. It’s the combination of “Data Lake” and “Data Warehouse”. In this...
2020-09-17 (first published: 2020-09-10)
784 reads
I had a previous blog comparing Cosmos DB to a relational database (see Understanding Cosmos DB coming from a relational world) and one topic that it did not address...
2020-09-07 (first published: 2020-08-24)
362 reads
The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics opens up a whole new world of getting insights into data immediately, at low-cost, using...
2020-08-20 (first published: 2020-08-10)
943 reads
I have wrote a number of blogs on the topic of business continuity in SQL Database before (HA/DR for Azure SQL Database, Azure SQL Database high availability, Azure SQL...
2020-08-03 (first published: 2020-07-20)
430 reads
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure Data Lake Store Gen2 (ADLS Gen2): Archive tier is now GA: The archive tier provides...
2020-07-14 (first published: 2020-07-06)
263 reads
I discover a small new feature the other day, but a very useful one. Previously, there was no way to upload files to an ADLS Gen2 storage account via...
2020-07-07 (first published: 2020-06-22)
246 reads
Power BI has become hugely popular and I find common questions about functionality and features, so I thought I would put in this blog some of those questions with...
2020-06-23 (first published: 2020-06-08)
611 reads
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob storage. Now there are more new features for blog storage that I will talk about....
2020-06-11 (first published: 2020-05-25)
276 reads
A few data platform announcements yesterday at Microsoft Build that I wanted to blog about. The biggest one is Azure Synapse Analytics is now available in public preview! You...
2020-05-20
331 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers