Mistakes IT Shops Without a DBA Make
We get it. There’s no budget for a DBA on staff, or even a contract support firm like Dallas DBAs. You are not alone! There are thousands of firms...
2025-03-19 (first published: 2025-03-07)
595 reads
Blog Posts
Our SQL Server is Slow! What Do I Do First?
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before blindly restarting SQL Server, let’s walk through quick checks that don’t require deep DBA skills....
2025-03-19
240 reads
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot of SQL, but for the SQL I do write, I have SQLFluff to help me...
2025-03-18
183 reads
A Couple Quick GENERATE_SERIES Tests
I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than...
2025-03-17 (first published: 2025-03-05)
366 reads
Excel to SQL: Ditch the Spreadsheet Headaches
If you're a data analyst drowning in Excel, you know the pain. Endless filtering, formula nightmares, and the dreaded "file not responding" message. Excel's great for small stuff, but...
2025-03-17
198 reads
Hidden Killers of SQL Server Performance
I’ve been working with SQL Server for a very long time. Out of the box, SQL Server works great, however there is regular care and feeding that needs to...
2025-03-17
6 reads
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft Certified: Fabric Data Engineer Associate certification. It’s the second Fabric certification, and it focuses more...
2025-03-17 (first published: 2025-03-05)
885 reads
Securing Kubernetes With External Secrets Operator on AWS
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and reduce secret exposure risks.Secrets management is an essential aspect of modern application development. It is vital...
2025-03-15
50 reads
Book Review: A Radical Enterprise
I grabbed this book over the 2024 holiday season as it was on sale and recommended by the DevOps practitioners over at ITRevolution. A Radical Enterprise looks at a...
2025-03-14 (first published: 2025-02-28)
114 reads
The Book of Redgate: What’s Great about Redgate?
“I’m sick of hearing about Red Gate.” The first article in the book has this title, which might seem strange, but the short piece then talks about how many...
2025-03-14
24 reads
Blogs
The Third Sabbatical
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Advice I Like: Focus on what’s important
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions
By Rohit Garg
Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...
Forums
Azure Database Watcher Monitoring
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Can You Ask for a Raise?
Comments posted to this topic are about the item Can You Ask for a...
Stored Procedure Generation Script
Comments posted to this topic are about the item Stored Procedure Generation Script
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers