PASS Summit Announcements: DMA/DEA
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. My next few blogs...
2016-10-28
905 reads
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. My next few blogs...
2016-10-28
905 reads
Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to...
2016-10-19
960 reads
A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. ...
2016-10-05
762 reads
Cortana Intelligence Solutions is a new tool just released in public preview that enables users to rapidly discover, easily provision, quickly experiment...
2016-09-29
904 reads
In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with...
2016-09-21
693 reads
One thing I try to do in my role with Microsoft is to get clients to think of possible use...
2016-09-08
510 reads
SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both...
2016-08-24
650 reads
A new performance level for Azure SQL Database was recently announced, called P15. This new offering is more than two...
2016-08-17
691 reads
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important...
2016-08-17 (first published: 2016-08-10)
1,933 reads
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,227 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