Presenting Azure Vs. Working With Azure
I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and...
2017-11-15
299 reads
The Scary DBA
All Day Query Tuning Class at SQLSaturday Virginia
March 23rd, 2018, I’ll be teaching an all day class on Query Tuning Tools in Richmond Virginia. I hope to...
2017-11-14
360 reads
The GDPR and You
Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.
I can already hear...
2017-11-13
302 reads
Extended Events and Profiler: XE Profiler
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
426 reads
Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
563 reads
PASS Summit and Redgate Software
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
317 reads
Database Fundamentals #14: Modifying Data Through SSMS
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
510 reads
Database Fundamentals #13: Data Entry Through T-SQL
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,868 reads
Database Fundamentals #12: Adding Data with SSMS GUI
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
465 reads
Azure, PowerShell, Databases and the PASS Summit
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
428 reads
Blogs
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...
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...
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