All Day, Training Day at SQLBits
It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February...
2019-01-23
227 reads
The Scary DBA
Critiquing Grant Fritchey: Circa 2008
For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of...
2019-01-22
159 reads
Get Your Learn On
There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...
2019-01-21
153 reads
DevOps and Automation Will Eliminate the DBA
I’ve been reading about the death of the DBA ever since I first made the jump from full time developer...
2019-01-23 (first published: 2019-01-14)
2,684 reads
PowerShell to Simulate Load
Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...
2019-01-17 (first published: 2019-01-07)
2,316 reads
Redgate Reviews 2018, Predicts 2019
Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just...
2018-12-17
168 reads
Privacy and Protection in the Age of the GDPR
We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at...
2018-12-10
238 reads
Database Fundamentals #20: Using the JOIN Operator, Inner Join
It is entirely possible to try to JOIN two tables on almost any field, as long as the two data...
2018-12-21 (first published: 2018-12-03)
2,513 reads
Forcing a Plan That Has a Plan Guide
The question that came up during a recent class I was teaching was: What if you have a plan guide...
2018-12-11 (first published: 2018-11-26)
1,815 reads
Query Store and Plan Cache Plans Compared
Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...
2018-12-03 (first published: 2018-11-19)
2,013 reads
Blogs
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...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
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