Recently I was trying to use a connection string to connect in SSMS. There are some tools that have a connection string available as an output, including some Redgate...
2024-10-11 (first published: 2024-09-25)
3,506 reads
This was actually a cool tip I saw internally from one of the product managers, when trying to find specific text in a migration. I’ve been working with Flyway...
2024-10-11
18 reads
The slides and scripts for my session “Tackling the Gaps & Islands Problem with T-SQL Window Functions” at dataMinds Connect 2024 can be downloaded from GitHub. If you want...
2024-10-10
26 reads
Look, we all know data is king these days. But having mountains of data and actually using it to make your business better are two different things. That's where...
2024-10-10
20 reads
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
188 reads
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
2,343 reads
Another discussion in Gothenburg (such a great group of people) around Extended Events lead to a (admittedly, tiny) idea for an additional use for sp_statement_completed. The basics for sp_statement_completed...
2024-10-09 (first published: 2024-09-23)
369 reads
The post Analytics vs. Advanced Analytics appeared first on Joyful Craftsmen.
2024-10-09 (first published: 2024-09-25)
356 reads
Sometimes a solution is no longer viable because there isn’t a path forward and sometimes a solution isn’t viable because there are better options out there from the organization’s...
2024-10-09
16 reads
A TON of new features announcements at the European Microsoft Fabric Community Conference help last week. The full list is here, and I wanted to list my favorite announcements...
2024-10-08 (first published: 2024-10-07)
22 reads
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
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...
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