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.

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...

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...

On Speaking Well

Professor Patrick Winston of MIT used to give a one-hour talk about how to speak. Though Professor Winston is no longer with us, his talk still is. If you...

SWAG Saves the Day

PASS Summit East is in one week. I was on the road last week in the UK and then Houston for the Houston AI-lytics event. I had been a...

OpenClaw- Agentic Engineering

This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...

Visualising Vectors in High Dimensional Space

Following on from my previous post on building The Burrito Bot, I want to delve into visualisation of vector embeddings that were generated from the restaurant data pulled from...

Fabric Mirroring doesn’t start copying Rows

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not...