Meme Monday: SQL Family
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me?
Wow…
Geez Tom, couldn’t you ask a hard question for...
2011-11-07
1,782 reads
The Scary DBA
Book Review: Guerilla Leader, T.E. Lawrence and the Arab Revolt
As part of my commitment to read and review 12 books in an effort to be active in my own...
2011-11-07
1,767 reads
SQL Server XQuery Against Execution Plans
One of the greatest things about all the DMOs is how you can combine the information they present to you...
2011-10-25
2,037 reads
I Can’t Go To Space
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,451 reads
PASS Summit 2011: Wrap-Up
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,429 reads
Extended Events Data
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,854 reads
PASS Keynote Day #3: Dr. Dewitt
And we’re off. We opened with a video of people saying “Connect, Share, Learn” and “This, is Community”
Rob Farley & Buck...
2011-10-14
1,326 reads
PASS Summit Day 2–Key Notes
Bill Graziano has come out on stage, looking marvelous, in a traditional kilt and stockings. Thanks Bill.
For those who don’t...
2011-10-13
1,085 reads
PASS Summit So Far
This is Day 2 of the Summit proper. But for me, this is the fifth day of the Summit and...
2011-10-13
1,013 reads
PASS Summit 2011 Day #1 Post #1
Hello again. The PASS Organization has once more allowed me to sit at the bloggers table for the key note....
2011-10-12
984 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
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