Do you know how to optimize database costs by query | Adam Cogan | SSW Rules - SSW TV - Learn from Professional Software Developers

You open your Azure bill and see a large monthly spend on Azure SQL or SQL Server, but no clear explanation of why. There are dozens (or hundreds) of databases, and you’re unsure which application, query, or piece of code is driving the cost. Without visibility at the query level, optimization becomes guesswork. Tools like Fortified’s WISdom allow you to drill into query-level spending and identify which SQL statements are responsible for the biggest share of your bill.

00:00 | Introduction to SQL cost optimization

00:43 | Introducing the tool: Wisdom by Fortified

01:15 | Dashboard overview: Monitoring multiple databases

01:25 | Finding the most expensive queries on your server

02:35 | Using the ROI Planner to calculate potential savings

03:31 | Conclusion and feedback

Links:
Rule: https://www.ssw.com.au/rules/database-query-costops

Follow us:
LinkedIn: https://linkedin.com/company/ssw/
Twitter: https://twitter.com/ssw_tv
Facebook: https://facebook.com/SSW.page
Instagram: https://instagram.com/ssw_tv
Tiktok: https://www.tiktok.com/@ssw_tv

Get in touch:
Adam Cogan – SSW Chief Architect + Microsoft Regional Director
About: https://www.ssw.com.au/people/adam-co…
LinkedIn: https://www.linkedin.com/in/adamcogan/
Twitter: https://x.com/adamcogan

For more information about SSW’s consulting services, please visit https://ssw.com.au/

#productivitytips #queryoptimization #sswrules #database #sqlserver #databaseoptimization #finops

V3 – Ken

About the speakers

Adam Cogan blogs at adamcogan.com and interviews for SSW TV frequently. He is the Chief Architect at SSW, a Microsoft Solutions Partner specializing in custom enterprise .NET and Azure solutions mostly using Blazor, Angular, and React. His solutions also involve AI, Office 365, SharePoint, Dynamics 365, and the Power Platform.

Adam is currently working on TinaCMS - the world's best Markdown GitHub editor.

His deep knowledge of SharePoint's many capabilities, combined with the latest technologies (Angular, React, SPFx), let him propose high-quality tailored SharePoint Applications to clients.

Do you explain why you’ve deleted or updated an appointment? | Adam Cogan | SSW Rules

Ever wonder why a meeting was moved or cancelled? Adam Cogan explains the “Secret Ingredient” to professional scheduling: always include a version history and reason for change at the top of your appointments. Improve clarity, keep a record of changes, and hold participants accountable with this simple SSW Rule.

Chat first before changing others’ code | Adam Cogan

Changing someone else’s code? Don’t just dive in! Adam explains why it’s important to check the source history and talk to the original developer before making changes. A quick chat can save headaches and keep everyone on the same page. Perfect advice for devs working in teams!

SSW TimePro – Create a new tenant | Jeoffrey Fischer

Learn how to provision a new tenant in TimePro and sync it with an external Dynamics 365 CRM system.

How to Report Bugs in Seconds | Brady Stroud

Tired of tedious bug reporting? Watch how Brady uses YakShaver.ai to turn a quick screen recording into a professional PBI instantly.

White space – Tips for recording demo | Adam Cogan

Awkward pauses can ruin an otherwise good presentation. In this video, Adam shares a simple tip to handle white space during demos and recordings. By telling your audience what’s about to happen, you avoid silence, cut out useless fillers, and sound more confident. Perfect for product demos, meetings, or presentations on any stage.

Don’t throw things over the fence until you’ve done what you can | Adam Cogan

“Throwing it over the fence” means passing your work or problem to others. This short video delivers one clear message: before you hand something off, do what you can yourself. It’s a simple reminder about responsibility, effort, and ownership in work, teamwork, and daily life.

SSW Strasbourg Office in Europe | Walkthrough with Jean

Hear from SSW Senior Software Engineer Jake Bayliss about the importance of providing context, showcasing your work and asking for questions & direction from Product Owners.

Liking Github issues when they are read | Adam Cogan

How to supercharge a company with AI | Ulysses Maclaren

Explore how AI is transforming businesses right now! In this video, Ulysses Maclaren from SSW walks us through the innovative ways AI is being used at Tina CMS. From automating customer interactions to analyzing vast amounts of data and even managing sales leads, AI is revolutionizing workflows