T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

It's time for T-SQL Tuesday #198! This month's topic is change detection.
The post T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes? first appeared on Data Savvy.

A Redgate Data Modeler Gotcha with Relationships

This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add a relationship and was confused about the behavior. Read...

AWS RDS Aurora - our first approach

When starting with AWS RDS Aurora for managing relational databases in the cloud, many data engineers face the challenge of leveraging its cutting-edge features while maintaining performance and reliability....

How to Connect to SQL Server When Nothing Else Works – DAC

It's 2 AM. Your phone is going off. Users can't connect to the application, and when you open SSMS to investigate, the connection spinner just keeps spinning. SQL Server...

Monday Monitor Tips: Oracle Custom Metrics

One of the popular features of Redgate Monitor has been the ability to add custom mertics for various purposes. This has been popular, and along with our curated list...

PowerShell Strikes Back: Know Your Quotes, Young Padawan

This is Week 1 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the...

Understanding Fabric MCP

Model Context Protocol, or MCP, is one of those technical ideas that sounds more complicated than it really is. The easiest way to think about it is this: MCP...

Why Claude?

Every major model out there can summarise documents, write code and answer multi step questions – then if you decide to go with a specific vendor based on costs...

Advice I Like: Celebrate Success

“On the way to a grand goal, celebrate the smallest victories as if each one were the final goal. That way, no matter where it ends, you are victorious.”...

Beware of Generic SQL Server License Keys (What to Use Instead)

Beware of Generic SQL Server License Keys (What to Use Instead)

I (think) realize that content here is probably more applicable to mid-to-large organizations than small...