Author: drweb

SQL

Ramblings of a retired data architectLet me start by saying that I have been working with data for over thirty years. I think that just means I am old. Anyway, I have written blog posts, delivered presentations, and authored books on these languages through the years. Understanding and using these languages have grown and shaped my career through the years. I thought it would be fun to discuss my thoughts on each one. This is my take and some of my thoughts are definitely “tongue in cheek.” So, enjoy the ride and feel free to share your take in the…

Read More
SQL

A customer was testing Redgate Data Modeler and complained that it auto-generated PK names. I had to test and discover if I could make things better, and I could. This post shows how.This is part of a series on Redgate Data Modeler.Adding a New EntityI can easily add a new Table to my diagram. I’ll click the New Table icon in the menu.When I click in the design surface, I get a new table.On the right, I see the table properties. I’ll need to fill these in.Let’s change the name and add a few columns to this design. Note that…

Read More

At 2:07 a.m., a core production node went down. CPU usage spiked, latency ballooned and requests started timing out across the cluster. Monitoring tools caught it instantly as dashboards glowed red, alert rules fired and incident payloads were dutifully sent downstream. Everything functioned exactly as designed. Except no one responded. The alert reached every configured […]

Read More

I used to think capacity planning was about setting up CloudWatch alarms and hoping they’d fire before things broke. Spoiler: that’s not capacity planning—that’s just reactive firefighting with extra steps. Real capacity planning means knowing you’ll need more database capacity three weeks from now, not three minutes after your site starts timing out. It means […]

Read More

In today’s rapidly developing software world, security cannot be an afterthought. DevSecOps, the integration of security practices into every phase of DevOps, requires continuous monitoring and actionable insights to detect and mitigate threats effectively. Observability plays an essential role in this ecosystem by providing deep visibility into the security posture of the development process, enabling […]

Read More