| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| 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 |
| 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 |
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. |
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 |
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. |
Democracy is colliding with the technologies of artificial intelligence. |
| Administration of SQL Server |
xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. |
In this post I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information. |
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. |
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, high-impact steps for securing your SQL Server environment.… The post 15 Practical Tips for Securing SQL Server appeared first on Simple Talk. |
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. |
You can now start working with any data you have access to in a new serverless notebook with a built-in AI agent. |
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. |
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 |
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 |
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. |
This blog post recaps my eventful participation in KubeCon + CloudNativeCon North America 2025 in Atlanta |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
This milestone marks a major step forward in unifying and simplifying data movement experiences across Data Factory. |
Lots of people have created Power BI reports, using interactive data visualizations to explore and communicate data. |
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 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 |
I frequently need to see rowcounts and execution time for queries while they’re running. |
PostgreSQL 18 has just been born and we are already talking about the blessings of PostgreSQL 19 and beyond? |
We just shipped pgstream v0.9.0, and it comes packed with new features, memory improvements and some much appreciated contributions from the community. |
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)... |
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 |
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. |
Having a real conversation with Power BI is not a novel idea. Its ‘Q&A’ feature has been available for the past 10 years. |
If you need to create a copy of a table in another database, the ‘Import Data’ option may seem convenient. |
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 |
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. |
  | 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. |
|
|