A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-10-21 (first published: 2024-09-30)
344 reads
I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time,...
2024-10-21 (first published: 2024-10-07)
264 reads
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens to come along, spending hours wallowing in the handful of details you can gather about...
2024-10-18
37 reads
Here are the slides from my talk today: CI in Azure DevOps If you have questions, please feel free to contact me (top menu above).
2024-10-18
11 reads
I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how...
2024-10-18 (first published: 2024-10-02)
270 reads
I speak to many people who use cloud technologies, especially database tech and how little consideration they give to their MISSION CRITICAL Databases that run in the cloud and...
2024-10-18
30 reads
Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...
2024-10-18 (first published: 2024-10-04)
155 reads
At a recent conference I was asked how I executed code during my presentation. Running code during a presentation should be as smooth as possible…so in VS Code I...
2024-10-16 (first published: 2024-09-27)
403 reads
SQL is essential for modern businesses and applications that rely on data. It's a robust language that lets you work with databases, pull out the information you need, and...
2024-10-16
106 reads
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I’m happy that you have...
2024-10-16 (first published: 2024-09-30)
258 reads
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
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...
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