The other day, I was in a Twitter discussion interviewing people for technical positions. This reminded me of one of my favorite things to do in interviews… reading the list of qualifications/skills and asking questions about its contents. If you put it on the resume, I assume you know something about it and are willing […]
2023-07-15
130 reads
2023-07-14
151 reads
2023-07-12
146 reads
Today Steve talks about bare metal servers and virtual machines. He wonders if any of you still run bare metal.
2023-07-10
344 reads
Two weeks ago, I had the opportunity to hear a keynote by Vik Fearing at Swiss PGDay 2023. He talked about Property Graphs and the Graph Query Language (not to be confused with GraphQL), a recent addition to the SQL:2023 standard. The discussion was mostly theoretical in nature because only Oracle has a current implementation […]
2023-07-08
94 reads
2023-07-07 (first published: 2018-09-13)
379 reads
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
2023-07-05 (first published: 2018-09-21)
278 reads
We have a guest editorial today from Mala Mahadevan on the changing data community.
2023-07-03
140 reads
I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I […]
2023-07-01
71 reads
If you found out you were being laid off, would you be ready? Steve thinks you should be lightly planning for this to happen.
2023-06-30
155 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