DBAs and the Dark Closet
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,022 reads
The Scary DBA
New DMO in Azure SQL Database: sys.dm_db_wait_stats
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....
2013-02-04
1,399 reads
Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,873 reads
Saving Execution Plans on Azure SQL Database
In my previous post showing how to get to execution plans in the Database Management Portal, I showed that it’s...
2013-01-23
1,825 reads
Pro SQL Server 2012 Practices: Chapter 12
I was very privileged to get the opportunity to write a chapter in a book with some of my friends...
2013-01-21
1,099 reads
You Can Say “No”
I heard about this new law that was passed to prevent employers from asking for your social media passwords. After...
2013-01-16
972 reads
Execution Plans on Azure SQL Database Portal
If you’ve been working with the Azure SQL Database portal, you know that you have a query window. Within the...
2013-01-16 (first published: 2013-01-14)
1,844 reads
Plans for 2013
I have lists. Lots of lists. I even have them in different locations sometimes. Some of them are carefully written...
2013-01-09
892 reads
Statistics Update Clarification
By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...
2013-01-11 (first published: 2013-01-07)
2,522 reads
SQLBits Public Sessions
If you’re over in the UK, or close to it, you’ve probably heard of SQL Bits even if you haven’t...
2013-01-07 (first published: 2013-01-03)
1,534 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