Know Your Limits
A little over a week ago I roughed up my back moving sound equipment after a ministry event. I have...
2011-05-10
1,708 reads
Databases – Infrastructure – Security
I Won't Be at SQL Rally
I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...
2011-05-05
860 reads
My PASS Summit Submissions
Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...
2011-05-05
787 reads
Outlook Productivity Tricks
I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...
2011-05-05
2,100 reads
Writing Better Emails
In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...
2011-05-04
2,927 reads
How often do you check email?
If you read the experts, most folks check their emails too many times during the day. Today, while giving a...
2011-05-03
791 reads
Love What You Do
I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...
2011-04-29
1,539 reads
SQL University: Who has access to my SQL Server?
Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...
2011-04-26
2,784 reads
If a web page asks you to update Adobe Flash Player
You don't want to do so from that web page. Instead you want to go to the Adobe web site...
2011-04-22
1,117 reads
Why having two accounts is a good thing
Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...
2011-04-22
698 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
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