U-SQL Defined
Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately...
2017-03-23
473 reads
Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately...
2017-03-23
473 reads
I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements). There is some confusion on PolyBase use...
2017-03-15
606 reads
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost.
Customers using...
2017-03-10
293 reads
Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI...
2017-03-09
569 reads
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS....
2017-03-01
439 reads
There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid...
2017-02-08
331 reads
Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads. This...
2017-01-18
339 reads
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or...
2017-01-04
267 reads
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
410 reads
I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....
2016-12-14
316 reads
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers