Changing the Cardinality of a FK in Redgate Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this  easy,...

Future-Proofing: How to Stay Ahead in FinOps

Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly last year’s “perfectly optimised” setup isn’t so perfect anymore. Over time, I’ve realised that FinOps...

Introducing the SQL Server on Kubernetes Operator

Are you considering replatforming your SQL Server workload due to recent vendor changes, but still need high availability and disaster recovery? You’re not alone. One of the challenges with...

Advice I Like: Rewards from Work

The greatest rewards come from working on something that nobody has words for. If you possibly can, work where there are no names for what you do.” – from...

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but I’ve also watched teams stumble during adoption. FinOps sounds simple in theory: collaborate, track costs,...

Why your data still can’t answer a simple question 

Every organization I talk to has the same problem dressed up in different clothes. Somewhere in the business, a decision maker is sitting on a question that the data...

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new to this blog party, I encourage you to check out the rules. If you are...

Voxxed Days Zurich

That was my first experience at a Voxxed Days event. Obviously I like Oracle-focussed events, but that can give you a blinkered view of the world. There’s a lot...

Did You Really Name That Default?

Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:

SQL Server...

Monday Monitor Tips: A New Analysis Page

We have multiple teams (8) working on Redgate Monitor. Some work on the Standard Edition, a few on the Enterprise Edition, and others handling core work, like the Linux/PostgreSQL...