I just had my one-year anniversary working for Redgate, and I must tell you, it’s been one of the best years of my professional career of 25 years. People aside (and there are a lot of really great people!), one of the reasons I’ve enjoyed this year so much is that Redgate understands and believes […]
2023-10-28
142 reads
One piece of advice for engineers is to be valuable, but not critical. It's a mistake Steve made early in his career, but he hopes you can do better.
2023-10-27
968 reads
Having a good process for managing security is important, but how many of us enforce that?
2023-10-25 (first published: 2019-01-18)
418 reads
Another company has hard-coded credentials, which Steve feels are a sign of bad culture.
2023-10-23
134 reads
I can't hide this in any way. I love it when I accomplish something. It's such a great feeling. Even more than that, I really do love getting some acknowledgement for it. Almost as good, is when I see others, especially friends and acquaintances, doing well. So many people I know, regularly just knock it […]
2023-10-21
53 reads
A busy year got a little too busy for Steve and he is taking steps to improve his work life balance.
2023-10-20
153 reads
Steve has had to change his security, which is good, but annoying.
2023-10-18
160 reads
Code reviews are a part of many software development processes, but not used that often with database work. Today Steve has a few thoughts and asks if you have any formal code review process.
2023-10-16
435 reads
2023-10-14
81 reads
If you build software for customers, you have a pipeline. It might not be good, but you have one. Steve recommends you work to make sure this is a repeatable, reliable pipeline.
2023-10-13
87 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