Auto Renew Subscriptions

This week I saw an announcement from Azure that you can set up auto-renew subscriptions for your reservations for your resources. This allows you to set up auto-renew for reservations to prevent them from not renewing and being charged at the pay-as-you-go rates. This reminds me of the old Columbia House deals, which I had for both cassettes and CDs. For some time these were good deals for me, but over time, I'd lose track of the subscription, forget to return things, and end up purchasing items I didn't want.

An auto-renewal is likely both a good idea and a bad one, as I suspect that many organizations lose track of their renewal dates when they have an estate of any size. Administrators or finance people will come and go, and they might not know the history of why we reserved something, like a VM, and could forget to renew these. Often we are still using resources, so renewals make sense.

However, we also stop using resources or don't use them at the same capacity levels, so perhaps we want to not renew. The docs for this feature note that the renewal creates a new reservation, and this setting can be changed at any time. However, some of the other docs aren't clear to me. The descriptions read as though someone has an idea about how this works, and they don't quite clearly detail the workings of the system for readers that are not familiar with this feature.

As an example, the docs say if you enable renewal more than 30 days before expiration, then  you get an email explaining renewal costs. However, with automatic renewal, do you get the email? When are costs disclosed or detailed? Maybe more importantly, the doc notes the price may change between when you lock the renewal price and when the renew time occurs. Does this mean you pay the higher price? Are you notified each year?

Maybe more importantly, if we create resources at different times, can we somehow get renewals dates to align? Whether this comes to finance people or IT people, at some point with a big cloud presence, you might have renewals coming every month or week. Who would be able to track this stuff appropriately if it's a constant item to check? I can see plenty of people starting to ignore these notices if they come too often. There are other issues as well, such as a SKU being different (or deprecated) over time. Will someone figure out how to upgrade to a newer SKU? If so, will they remember to set auto-renewal? Does this transition to the new SKU?

The documentation is woefully incomplete, though I'd be happy to submit PRs for edits. I just don't know what the answers are, and I suspect that whoever built this feature might not have thought through all the scenarios. Certainly the individual writing the documentation didn't.

The cloud is complex, and billing is complex. Tracking and managing this is going to be partially a technical role, and I suspect many of us won't know what the implications are for the choices we make. I also suspect we'll get notifications for resources that we have no knowledge of and will need to research more about the item. We'll become more of a financial DBA over time, which may or may not be the job we want.

Steve Jones - SSC Editor

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

This mini-essay was my contribution to a round table on Power and Governance in the Age of AI.  It’s nothing I haven’t said here before, but for anyone who...

Alex Zhavoronkov has been messing around with arti...

Artificial intelligence (AI) has the power to change the global economy and potentially, one day, every aspect of our lives. There are numerous possible uses for the technology across industries, and...

We are excited to announce that Copilot in Azure S...

The buzz around Microsoft Copilot has been well-do...

In this article, we look at how AI tools can gener...

Learn how to use Spark SQL numeric functions that ...

When you’re working between SQL Server and Snowflake, there can be a lot of crossover that may make you forget what system you’re working in. Sometimes it’s close, but...

Learn about the future of Azure SQL with Microsoft SQL Product Leader, Sanjay Mishra.   Watch on Data Exposed   Resources: Azure SQL Documentation   View/share our latest episodes on Microsoft Learn and YouTube!

An issue was reported recently where the customer complained that in their cost analysis report of their Azure SQL DBs, the db name appears appended with a comma(,) and a number. While they agreed with the DB name in the report, they didn’t understand the number after the comma and its significance.

Reliable, in-depth, and at-scale monitoring of database performance has been a long-standing top priority for SQL customers. Today, we are pleased to announce the public preview of database watcher...

We are excited to announce the public preview of N...

Last year, I submitted and was accepted to present at the EightKB conference. At first, I thought my current presentation wasn’t advanced enough, but Tracy Boggiano convinced me otherwise.... The...

The blog describes all the steps required to safely migrate your Heroku PostgreSQL database to self managed PostgreSQL on AWS EC2 instance using logshipping method. The post Transitioning...

Starting from May 1, 2024, you will be charged for stateful log alerts in Azure Monitor.

You can now opt in automatically renew your reservation at time of purchase, which provides an easy way to continue getting reservation discounts.

Here are seven strategies that businesses should consider adopting to reduce their cloud spending.

After delivering the first training day at SqlBits 2024 – it was intense!

And yet another new SQL Down Under show is published! Once again, I had the great pleasure yesterday to record a podcast with one of my long-term data platform...

You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it works, how SQL Server and Azure SQL DB turn your queries...

Spring Training This May, I’ll be presenting my full day training session The Foundations Of SQL Server Performance Tuning. All attendees will get free access for life to my...

Ever want to make your own PowerShell cmdlets? Wat...

Learn how to use PowerShell for password generation and automation within Active Directory environments, focusing on adherence to security policies and best practices.

In this previous post, I introduced momentum-based gradient descent (GD) as well as Nesterov’s accelerated gradient descent (AGD). In this post, I show a few plots of how the...

When you’re visualizing categorical data, sorting the bars in your chart is usually a straightforward task. Or is it?In most cases, you probably take the category with the largest...

DevOps is benefiting in many ways from platform engineering, according to a new report from Puppet by Perforce.

Nobody likes to do the same monontonous task over and over again. Well, saying that, maybe some out there do in order to look and feel...

THE VIDEO THE SYNOPSIS In this video, we dig into GitHub’s process for executing code: GitHub Actions workflows. We’ll learn what Actions and workflows are, how we can create...

In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than... The...

Today, Redis, a leading provider of in-memory data store solutions, announced a transition in its open-source licensing approach. Redis is moving away from the BSD 3-Clause License to a dual-license model, offering developers the choice between the Redis Source Available License version 2 (RSALv2) or the Server-Side Public License version 1 (SSPLv1).

With the recent beta release of Apache Cassandra 5.0, now is a great time for teams to give it a spin and discover 5.0’s most interesting and anticipated new capabilities. ...

A colleague of mine once asked about cancellation tokens in AWS. This question got me thinking about this problem and got me curious on whether there is any support. Turns out it is an interesting topic with lots of pitfalls.

Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to be used in lakehouses or data warehouses. One major question that arises is, “should we use a top-down or bottom-up (or both) approach in Microsoft Fabric?” This decision especially affects custom projects built for large corporations.

It is always an afterthought. New objects are created that start off small and current. New feature development takes over and the recently architected data structures become old news. Over time, data grows and suddenly a previously small table contains millions or billions of rows. Is all that data necessary? How long should it be retained for? If there is no answer to this question, then the actuality may be “Forever”, or more honestly “No one knows for sure.” Retention takes on many forms and this article dives into ways in which data can be managed over time to ensure that it is fast, accurate, and readily available.

We live in the height of the digital age, where the digital space has become a thriving community, with every person craving a great yet personalized experience. In this era, there is one centralized truth with undeniable clarity: Accessibility is no longer a mere option; it is the cornerstone that will lead to the creation of a truly welcoming community. In this second part of our series on accessibility design, we will discuss essential topics that lie at the heart of crafting accessible digital environments. We’ll begin by throwing more light on three of the five fundamental visual patterns vital to your designs: color contrasting, font sizing, and labeling and iconography.

Last year, we introduced AI capabilities to SQL Prompt via the Prompt+ Early Access Program (EAP). Using generative AI-powered insights and context-based awareness, Prompt+ takes natural language queries and turns them into SQL coding suggestions. Check out this blog to learn more about Prompt+ and how to join the EAP waitlist.

Microsoft unveiled two new Surface devices during ...

StarTech.com has introduced its latest Thunderbolt 4/USB4 docking station, which has a plethora of ports and supports four display outputs. This makes it suitable for 4Kp60 quad-monitor setups often...

Learn how to use the new Vpax obfuscator to send anonymized VPAX files to DAX Optimizer. Read more: https://www.tabulartools.com/blog/supporting-obfuscation-in-dax-optimizer/

Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and we can only see or change its value through...

Feature engineering is the process of using domain knowledge to extract features (characteristics, properties, attributes) from raw data. The extracted features are used for training the models that can predict values for relevant business scenarios. A feature engineering system provides the tools, processes, and techniques used to perform feature engineering consistently and efficiently.

Reading Time: 5 minutes In this post I introduce ...

You might know the feeling: you’re writing code ...

There’s a lot of excitement about Copilot in Power BI and in Fabric as a whole. The number one question I’m asked about Copilot by customers is “How much...

I was very sad to learn today that the Redis project will no longer be released under an open source license. Sad for two reasons: as a longtime Redis user and pretty early adopter, and as an open source contributor.

PostgreSQL “extensions” are a big part of what makes this database special. The developers building the core Postgres database are amazing. But many people don’t realize just how...

Explore intricacies of PostgreSQL's internal page structure and how pages are organized, their default size, and more. The post PostgreSQL Internals Part 2: Understanding Page Structure appeared first...

The article explores the deployment of pgAdmin4, a popular graphical user interface for PostgreSQL, within a CloudNativePG environment, primarily for evaluation and educational purposes. The process involves deploying pgAdmin4...

Last Phriday we explored just where Postgres could end up in the future. One possible question which may have occurred to a reader was probably something along the lines...

(2024-Mar-16) I have been a big fan of using the ...

Fixing Parallel Row Skew With TOP In SQL Server (With A Brief Re-Complaint About CXCONSUMER Waits) Going Further If this is the kind of SQL Server stuff you love...

A Little About SOS_SCHEDULER_YIELD Waits In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering...

When working with databases, high resource usage or a query reporting a timeout could indicate that the statistics of the tables involved in the query are not up to...

Direct Lake in Power BI could possibly fall back t...

If you're in Power BI Desktop, how do you actually...

With the introduction of visual calculation in the February 2024 release of Power BI desktop (https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/) – this gives us some new possibilities to add calculations on the individual visual and some new functions gives us some exiciting options.

Video by: Reid HavensHave conversation with me as we review the concepts of chart (visualization) junk, and how to remove them, or choose carefully what you'd want to include...

You may have heard of test data management (TDM). ...

Reviewing The New DACPAC Code Analysis Rules For T-SQL You can read the announcement post here. Going Further If this is the kind of SQL Server stuff you love...

We’re excited to talk about our vision for Tableflow, which makes it push-button simple to take Apache Kafka® data and feed it directly into your data lake, warehouse, or analytics engine as Apache Iceberg® tables.

I had a client that was concerned about SQL Compare behavior when a developer adds a column to the middle of a table. I wanted to reassure them, so... The...

At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM), which was a new product for us. You can watch the video linked above to... The...

The next generation of general purpose service tie...

On March 14, 2024, Microsoft released SQL Server 2022 Cumulative Update 12. This is Build 16.0.4115.5. By Microsoft’s count, there are 50 public fixes and improvements in this CU,...

In the realm of data analysis, understanding how to effectively segment your data is paramount. Whether you’re dealing with age groups, income brackets, or any other continuous variable, the ability to categorize your data can provide invaluable insights. In R, the cut() function is a powerful tool for precisely this purpose. In this guide, we’ll explore how to harness the full potential of cut() to slice and dice your data with ease.

If you’re looking for something a little different, ggbrick creates a ‘waffle’ style chart with the aesthetic of a brick wall. The usage is similar to geom_col where you supply counts as the height of the bar and a fill for a stacked bar. Each whole brick represents 1 unit. Two half bricks equal one whole brick.

This blog featured a post on mocking, the art of replacing a function with whatever fake we need for testing, years ago. Since then, we’ve entered a new decade, the second edition of Hadley Wickham’s and Jenny Bryan’s R packages book was published, and mocking returned to testthat, so it’s time for a new take/resources roundup!

Are you working with a dataset where you need to duplicate certain rows multiple times? Perhaps you want to create synthetic data by replicating existing observations, or you need to handle imbalanced data by oversampling minority classes. Whatever the reason, replicating rows in a data frame is a handy skill to have in your R programming toolkit.

We’re excited to announce that Extensible Key Management (EKM) using Azure Key Vault in SQL Server on Linux is now generally available from SQL Server 2022 CU12 onwards, which allows you to manage encryption keys outside of SQL Server using Azure Key Vaults.

Enhancing Security with EKM using Azure Key Vault in SQL Server on Linux:   We’re excited to announce that Extensible Key Management (EKM) using Azure Key Vault in SQL Server on...

BleepingComputer has the details. It’s $2M less than in 2022, but it’s still a lot. The highest reward for a vulnerability report in 2023 was $113,337, while the total tally...

I hate having to use that word - "alleged" - becau...

In a recent support case, our customer faced an intriguing issue where a query execution in a .NET application was unexpectedly canceled during asynchronous operations against Azure SQL Database....

Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a beginner, it’s easy to get lost in a maze of numbers and functions. You may stumble over pitfalls that can lead to incorrect results. But fear not because we’re about to make SQL percentage calculations as easy as pie!

I recently encountered a question related to views...

We are pleased to announce the private preview of regular expressions (regex) support in Azure SQL Database. Regex is a powerful tool that allows you to search, manipulate, and...

Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results: [crayon-65fb165a4173b420702082/] Their actual execution plans are wildly...

I’m a big fan of dynamic SQL in the right conditions. One key to crafting safe dynamic query of the use of the QUOTENAME function. The issue Using dynamic...

Today we will learn about the SQL IN operator. The RDBMS systems are very popular today in terms of data storage, data security, and data analysis. SQL stands for...

Making Plans For Nigel Views get a somewhat bad rap from performance tuners, but… It’s not because views are inherently bad. It’s just that we’ve seen things. Horrible things....

More organizations are moving toward skills-based hiring and getting mixed results. Here’s how to avoid some of the pitfalls.

Observability over the entire application estate expands the concept of downtime to encompass secure, exceptional, performant digital experiences.

It's imperative that I&O leaders overseeing the digital workplace choose technology that strengthens organization-wide DEI efforts.

rubatosis– n. the unsettling awareness of your own heartbeat, whose tenuous muscular throbbing feels less like a metronome than a nervous ditty your heart is tapping to itself, as... The...

Hey all!  This is the final post in a series of three covering SQL Server Management Studio (SSMS), and we are happy to announce that SSMS 20 is now...