Last year I had the most wonderful opportunity. I took part in Data Relay, an event in the UK which tours several cities. Wonderful time, but not the focus here. The very first one was held at the National Museum of Computing at Bletchley Park. Without a doubt, you've heard of Alan Turing, Enigma, and […]
2024-02-10
76 reads
Today Steve wonders if you have a go-to person at work or maybe if you are that person. Or if that is even a good thing in a company. It might be better if there were more tools available to help others.
2024-02-09
417 reads
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
2024-02-07
157 reads
A software bug causes a lot of legal issues in the UK. It's something that upsets Steve, partially because the software wasn't well tested.
2024-02-05
212 reads
Steve thinks that the growth of private clouds make sense, especially as more companies turn to platform engineering.
2024-02-03
99 reads
I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop […]
2024-02-02
411 reads
You mind can influence your body. Maybe. A study Steve found says that could be true, but he certainly thinks it can influence your attitude and how you respond to situations at work.
2024-01-31
134 reads
Today we have a guest editorial where Andy Warren asks you if you know how to ask for things at work. Many IT works struggle to ask for resources, but read on to understand how Andy might help you get more done at your job.
2024-01-29
102 reads
During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to […]
2024-01-27
85 reads
Do you enjoy your workplace or employer? Steve does and has a few thoughts on what that is like for him.
2024-01-26
163 reads
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...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
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