Be Cautious Offering Guidance
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,321 reads
The Scary DBA
Speaker of the Month, August 2013
I’m trying out a new blog post series, mostly for myself as an exercise. I’m going to pick one speaker...
2013-08-02
625 reads
Azure for Prototyping and Development
Psssttt!
Developers. Man, have I got something good for you.
Are your DBAs slowing down your development processes? Are they keeping you...
2013-07-29
1,738 reads
24 Hours of Education
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more...
2013-07-24
563 reads
A Tale of Two Hotels
This is a long and convoluted post about my experiences at two hotels, but it has a point for DBAs...
2013-07-15
828 reads
SQL in the City London 2013
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
725 reads
Getting Started With SQL Server 2014 the Easy Way
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,146 reads
I Don’t Care
It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...
2013-06-24
732 reads
Azure First
Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...
2013-06-20 (first published: 2013-06-17)
2,249 reads
Praise and a Suggestion for AlwaysOn
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are...
2013-06-10
814 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