Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

FinOps - the new name for performance tuning

This year I have been speaking with an increasing number of people about FinOps and what it means. Fundamentally, it is all about getting a handle on the cost for our technology spend. When we step back and look at the bigger picture it also has ramifications on corporate Environmental, Social, and Governance (ESG) programs about how the business is run. But what does this mean for a technology professional today?

First, FinOps is not a new concept. We have been doing the core work for most of our careers, and I have been speaking to people about this for years. There have been conference sessions from luminary speakers in the data community like Paul Randal, Kendra Little, Eric Darling, and many others at events for years. Right about now you are probably thinking, I don’t remember seeing or hearing them talk about FinOps…

That is because FinOps is all about performance tuning our workloads, getting the most efficient usage out of the resources we allocate to run these workloads. The only real difference is that now we have much better cost visibility through virtualization platforms and cloud. Historically we only had limited opportunities to optimize our spend, if we were buying hardware for a three- or five-year lifecycle then most of the work was concentrated around those refresh cycles. Now, our ability to create and scale resources on-demand and see the costs change almost monthly means that we can also affect it monthly.

Things that came up as top of the list for FinOps practices in my conversations were.

  • Monitoring seasonality of workload so you know when to scale up/down or out/in based on resource needs.
  • Turning off what is not being used.
  • Performance tune queries to be as efficient as possible.
  • Shift performance analysis left into development, understand the resource profile of the app and define what is an acceptable increase for a release to consume.

There are nuances to all of these and the wider processes, but this is all something that we are familiar with. So, when someone comes along and starts telling you about the latest and greatest trend called FinOps you can say that you’re familiar with it and have been doing parts of that for years.

It would be great to hear about whether you have access to all the things you need to move towards FinOps models, or about a time when you tuned a query that freed up a load of resources to the system.

John Martin

Join the debate, and respond to the editorial on the forums

 
Ad for State of Database Landscape survey
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

A New, Simpler Microsoft Teams Integration For Redgate Monitor

Microsoft is retiring Office 365 connectors, but there is now a new and easier way to send Redgate Monitor alert notifications to Teams, ready-formatted.

Redgate Software recognized as a Strong Performer in Gartner® Peer Insights™ Voice of the Customer for Infrastructure Monitoring Software

We’re thrilled to share that Redgate Software has been recognized as a ‘Strong Performer’ in the 2025 Gartner® Peer Insights™ Voice of the Customer for Infrastructure Monitoring Tools category with our Redgate Monitor solution. We believe this recognition is a reflection of the trust and feedback from the people who matter most: our customers.

AI/Machine Learning/Cognitive Services

Why Decision Trees Fail (and How to Fix Them)

In this article, you will learn why decision trees sometimes fail in practice and how to correct the most common issues with simple, effective techniques.

Four Ways AI Is Being Used to Strengthen Democracies Worldwide

From Schneier on Security

Democracy is colliding with the technologies of artificial intelligence.

Administration of SQL Server

Dry-run xp_delete_file Before Actually Deleting Files?

xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove.

PowerShell script to extract SSMS 21 and 22 saved connection data

In this post I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information.

5 Strategies to Refactor SQL Code

Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality code – yet somehow often gets overlooked in SQL. In this article, we’ll explain what refactoring is, how it helps, and give concrete examples on how it can make your code more readable, reliable, and maintainable.

How to Monitor and Optimize Batched Deletion Processes in SQL Server

Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log usage. Learn how to monitor and optimize these processes for smooth, efficient database performance.

15 Practical Tips for Securing SQL Server

From Simple Talk

15 practical, high-impact steps for securing your SQL Server environment.… The post 15 Practical Tips for Securing SQL Server appeared first on Simple Talk.

Cloud - AWS

Build production-ready applications without infrastructure complexity using Amazon ECS Express Mode

From AWS News Blog

Today, I’m excited to announce Amazon ECS Express Mode, a new capability from Amazon Elastic Container Service (Amazon ECS) that helps you launch highly available, scalable containerized applications with a single command.

New one-click onboarding and notebooks with a built-in AI agent in Amazon SageMaker Unified Studio

From AWS News Blog

You can now start working with any data you have access to in a new serverless notebook with a built-in AI agent.

Community Interests

Thankfulness Week!

From Dr SQL

In the US this week, we are celebrating Thanksgiving. It also marks the time of the year when we many of us really start celebrating the holidays full steam ahead.

Floor Drees: PostgreSQL Contributor Story: Vaibhav Dalvi

From Planet Postgres

Earlier this year we started a program (“Developer U”) to help colleagues who show promise for PostgreSQL Development to become contributors.

Conferences, Classes, Events, and Webinars

PASS Data Summit 2025 Recap

There were several exciting product announcements from this week. I won’t try to rehash all of these, but I’ll summarize a few of them I found particularly interesting

Simon Sabin on Data, AI and SQLBits 2026

Steve Jones is joined by SQLBits founder Simon Sabin at Redgate’s Cambridge HQ to discuss Simon’s early days in the data world (and how the industry has evolved), the importance of context when working with AI, and what’s ahead for SQLBits in 2026. They also dive into the nuances of conference speaking and, for a change of pace, Simon talks about his foray into UK motor racing.

Gabriele Bartolini: KubeCon NA Atlanta 2025: a recap and CloudNativePG’s path to CNCF Incubation

From Planet Postgres

This blog post recaps my eventful participation in KubeCon + CloudNativeCon North America 2025 in Atlanta

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Announcing Copy Job Activity in Data Factory Pipeline (Generally Available)

This milestone marks a major step forward in unifying and simplifying data movement experiences across Data Factory.

Data Viz in Fabric Notebooks

Lots of people have created Power BI reports, using interactive data visualizations to explore and communicate data.

Back Up and Restore a Fabric Lakehouse

From Purple Frog Systems

Fabric Lakehouses have been around for a while, but they still offer no native way to back them up or restore them. Fortunately, the way Lakehouses are structured makes...

Oracle/MySQL/other RDBMS

How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles and H3 Indexes (Part 2)

Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the attention, but often overlooked are two additions that dramatically expand support for complex geospatial problem-solving.

Performance Tuning SQL Server

How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server

From Kendra Little's Blog

I frequently need to see rowcounts and execution time for queries while they’re running.

PostgreSQL

Hans-Juergen Schoenig: Super fast aggregations in PostgreSQL 19

From Planet Postgres

PostgreSQL 18 has just been born and we are already talking about the blessings of PostgreSQL 19 and beyond?

Esther Minano: pgstream v0.9.0: Better schema replication, snapshots and cloud support

From Planet Postgres

We just shipped pgstream v0.9.0, and it comes packed with new features, memory improvements and some much appreciated contributions from the community.

Robins Tharakan: Settling COUNT(*) vs COUNT(1) debate in Postgres 19

From Planet Postgres

A recent commit to the PostgreSQL master branch brings a nice quality-of-life optimization for a very common SQL pattern - improving performance by up to 64% for SELECT COUNT(h)...

Jan Wieremjewicz: TDE is now available for PostgreSQL 18

From Planet Postgres

Back in October, before PGConf.EU, I explained the issues impacting the prolonged wait for TDE in PostgreSQL 18. Explanations were needed as users were buzzing with anticipation, and they...

PowerPivot/PowerQuery/PowerBI

Power BI, Build Permissions And Security

If there is sensitive data in your Power BI semantic model that you don’t want some users to see then you need to use row-level security or object-level security to control access to that data.

Chatting with Power BI: Who Benefits from This Conversation?

From SQLServerCentral Blogs

Having a real conversation with Power BI is not a novel idea. Its ‘Q&A’ feature has been available for the past 10 years.

SQL

The Cost of Convenience with the Import Data Wizard

From Andy Broadsword

If you need to create a copy of a table in another database, the ‘Import Data’ option may seem convenient.

Software Development

Demystifying Determinism in Durable Execution

Determinism is a key concept to understand when writing code using durable execution frameworks such as Temporal, Restate, DBOS, and Resonate.

Virtualization and Containers/Kubernetes

Getting SQL Server 2025 RTM Running in Containers on macOS

SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you might have hit a wall trying to get it running.

 
RSS FeedTwitter
This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -