Bad Admins: Attacking via Group Membership
This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...
2011-07-13
1,869 reads
Databases – Infrastructure – Security
Gaining Speaker Experience Credentials
One of the things I saw on Twitter yesterday was several folks saying their abstract submissions had been turned down...
2011-06-16
1,884 reads
Speaking at the 2011 PASS Summit
The emails came in today and 2 out of 4 of my sessions were selected. Both are the ones I...
2011-06-15
889 reads
Planning Your Upgrade Well
Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...
2011-06-07
965 reads
The Importance of a Business Recovery Plan
Recently I was in one of those chain restaurants (the middle-priced, sit-down types) and shortly after we got there, we...
2011-06-06
1,890 reads
Re-Focusing the Blog a Bit
In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...
2011-06-01
731 reads
Project Management: Dedicated vs. Shared Resources
As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...
2011-05-13
18,808 reads
You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
731 reads
Vote for My PASS Summit Sessions
Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...
2011-05-11
952 reads
Dealing with Frustration in the Workplace
Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...
2011-05-11
3,024 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