Microsoft Ignite Announcements
Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all...
2017-09-28
936 reads
Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all...
2017-09-28
936 reads
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
723 reads
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,027 reads
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
896 reads
I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:
Already...
2017-08-08
680 reads
Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow...
2017-08-02
674 reads
Azure SQL Data Sync has been ignored for quite some time, but has finally gotten an update (it’s in public...
2017-07-20
585 reads
Microsoft has introduced two new disk sizes for Azure IaaS VMs in P40 (2TB) and P50 (4TB) for both managed...
2017-07-07
1,017 reads
I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide...
2017-06-29
4,565 reads
The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data...
2017-06-23 (first published: 2017-06-14)
2,440 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