DevOps anti-patterns: what they are and how to avoid them
In software development, DevOps promises faster delivery, increased collaboration, and more reliable deployments. However, many teams unknowingly fall into anti-patterns.
2026-04-10
Articles
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Learn more about dbt in this next article on Data Engineering in Fabric.
2026-04-08
5,222 reads
Why use a Composite Index in SQL Server
SQL queries can take a long time to run, especially on large tables if not properly indexed. Full table scans can be costly operations when all a user wants is to fetch a few rows based on multiple columns and a WHERE filter. How can we properly index our tables to support multi-column queries?
2026-04-08
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Sometimes the problems aren't your code. Here a few places where re-examining your assumptions can help improve software development.
2026-04-06
2,628 reads
How to determine the last value used by a sequence in SQL Server
I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to that, developers had a choice of IDENTITY columns or a roll-your-own table mechanism.
2026-04-06
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
2026-04-03
6,579 reads
IDENTITY vs SEQUENCE in SQL Server – which should you use?
This guide explains how IDENTITY columns and SEQUENCE objects differ in SQL Server, and how you might decide which one is appropriate for a given design.
2026-04-03
The Grafana Alternative to SSRS and Power BI
Learn how you can use Grafana natively inside SQL Server Reporting Services.
2026-04-01
6,586 reads
How to migrate from on-prem to the cloud: uncovering legacy system ‘skeletons’
In this article, Pat Wright explains how to identify hidden risks in legacy applications before moving to the cloud. It features practical advice and guidance to avoid migration failures and surprises.
2026-04-01
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Learn about the new JSON_OBJECTAGG function in SQL Server 2025.
2026-03-30
2,999 reads
Blogs
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Forums
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers