SQL Intersection, Spring 2014
I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting...
2014-03-04 (first published: 2014-02-26)
1,634 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Let’s Talk Query Tuning
I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...
2014-02-27
1,281 reads
The CASE Statement and Performance
In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...
2014-02-25 (first published: 2014-02-18)
6,541 reads
SQL Server 2014 and the New Cardinality Estimator
Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...
2014-02-12
1,169 reads
Book Review: The Phoenix Project
Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...
2014-02-11 (first published: 2014-02-05)
1,930 reads
Speaker of the Month, February 2014
I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...
2014-02-07
708 reads
Thank You!
I am humbled and honored (and more than a little horrified) to be on this list of the Best of...
2014-02-06
701 reads
Time for a Quick Rant
This is an actual quote from what we can only assume is a functional human being:
The database is very big...
2014-01-20
698 reads
Database in Source Control
Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...
2014-01-15
1,192 reads
Sausage Making
For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...
2014-01-15 (first published: 2014-01-08)
2,040 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
SQL Server audit with windows ad group
I am trying to create a filter on a SQL Server audit to capture...
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers