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.
Barely Reviewed Code
Code reviews can be challenging in many places, and with AI, could be even more of an issue in the future.
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.
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?
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.
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.
This Week's AI Trust Problem Became Everyone’s Problem
There’s a saying in security circles: the weakest link isn’t the lock on the front door but the spare key under the mat. This past week gave us two vivid, simultaneous demonstrations of that principle, and if you’re building anything in the AI space right now, both deserve your full attention. The Mythos Leak and […]
A Double Failure
A company has both a server without a password and live data in test environments. Not a good situation.
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers