This Week in SQL: Cloud Without Losing the Plot
Hey SQL Humans,
Ever notice how the cloud doesn’t break anything outright? It just rearranges the furniture.
This week we’re covering a mix of things that help keep footing. Cloud monitoring that still feels like SQL, a practical video on audit data that refuses to stay put, and a couple updates from around the Idera-verse.
Let’s waddle in 🦆
🛠 Product Spotlight: Cloud SQL Without Losing the Plot
Running SQL in the cloud does not mean starting from scratch. The fundamentals still matter. What changes is where the data lives, how authentication works, and how quickly things can get noisy if visibility slips.
That’s where cloud-aware SQL monitoring makes the difference. Tools designed for hybrid environments help keep things grounded by letting you monitor Azure SQL and managed instances alongside on-prem systems, use native cloud identity without gymnastics, and see performance trends without hopping between dashboards.
If you want a deeper look at what actually changes when SQL moves to the cloud, and what very much does not, this breakdown on cloud SQL monitoring lays it out clearly.
And when the question shifts from “how should we think about this?” to “how does the tooling actually handle it?”, SQL Diagnostic Manager is built to cover both sides of that equation. It supports monitoring across cloud and hybrid SQL environments without forcing a different workflow for each one.
The goal is not cloud for cloud’s sake. It’s staying oriented when parts of your SQL estate stop living under the same roof.
🦆 Quacky says the cloud works best when it behaves like SQL, not a mystery box.
📺 Video Corner:
Audit data loves to grow legs and walk off with your time.
This walkthrough focuses on archiving in SQL Compliance Manager, one of those features that quietly saves hours once it’s set up right. It shows how to move older audit data out of the hot path while keeping it searchable, organized, and ready when questions come up later.
It’s not flashy, but it’s extremely practical.
Watch here
🦆 Quacky says audits age better when they stop living in the present forever.
🌌 Around the Idera-verse:
ER/Studio at DMZ 2026
March 3–5, 2026 | Redwood City, CA
ER/Studio is heading to Data Modeling Zone (DMZ) 2026, the world’s only conference dedicated entirely to data modeling. Meet Jamie Knowles, ER/Studio Product Director, and Lauren Capozella, Sales Director, attend our featured session on semantic guardrails for AI, and join a hands-on data modeling workshop using ER/Studio.
Save 25% on registration with code ERSTUDIO26.
Wherescape
Migrating from SQL Server to Azure or Microsoft Fabric isn’t a simple lift-and-shift. Join WhereScape’s live panel on February 5 with experts from Engaging Data, infoVia, Scalefree, and WhereScape to break down what works, what breaks, and how to avoid costly mistakes.
Register now to get real-world migration guidance you can actually apply.
🧠 Understanding SQL:
When too many workloads hit your server at once, they do not negotiate. They fight. Resource contention is the brute-force Invader. CPU spikes, blocking chains, PAGEIOLATCH waits, and queries that suddenly take twice as long.
🦆 Quacky says: “If the CPU is screaming, something is winning and it is not you.”
📅 Upcoming Webinars:
What to audit, where to start, and how to pass audits faster
Thursday, February 12
Audit prep has a habit of expanding until it fills every available hour.
This SQL CM session focuses on narrowing that scope. Where to start, what actually matters, and how to move through audits faster without cutting corners or drowning in noise.
If audits keep creeping into unrelated work, this one’s worth an hour.
Save your seat:
🦆 Quacky already labeled the scope and refuses to add “just one more thing.”
🦆 Quacky’s Favourite Reads:
Maximizing SQL Server Performance in the Cloud: A practical look at what actually affects SQL performance once workloads move to the cloud. It breaks down what still behaves the same, where assumptions change, and how to avoid chasing cloud-specific ghosts instead of real bottlenecks.
Cloud SQL Monitoring: What Changes and What Still Matters: A clear reminder that while infrastructure shifts, good monitoring instincts do not. This one helps separate what needs rethinking in the cloud from what still works exactly the way it always has.
Thanks for reading. We’ll be back soon with more tips, tools, and the occasional duck.
—The Idera SQL Team & Quacky (Quacky is convinced this alert behaved differently in the cloud. He has notes.)