Coding Magic Values

It's 2022. I would hope all software developers would learn that hard coding specific values in your system is more likely to cause issues than not. Across the years, we've learned not everything is installed on the c: drive, or that not everyone wants to put all data in a Documents folder (or in OneDrive). We've learned that any sort of magic number is poor practice, and we ought to know that hard-coded names are problematic as well.

Yet, we still see it happening.

This week I was reading about an admin issue in the Microsoft TechCommunity. This is related to Azure Managed Instance, but it's really an In-Memory OLTP issue. That was introduced in SQL Server 2014, so I know the code for this was likely written in the 2011-2013 timeframe, but how can this type of issue get through code review and be released?

In this case, the name of a filegroup is set specifically to XTP. It's a logical name, and I'm sure that some developer thought that things might be faster with a known location. That doesn't make sense, and while this might not be an issue for most customers, I'm sure there have been some databases built with a filegroup called XTP. After all, there are companies named XTP. What about if this feature evolves to allow a second filegroup, maybe because of some distributed architecture need in the future? Are there then code paths looking for XTP or XTP2?

As much as possible, avoid coding values in your code that a user might enter as data. Names, paths, etc. Just don't do it. Use variables, which are in every language, and let those values be read from the environment. This ensures that you don't end up with weird support requests from customers because they chose the same value you did.

Steve Jones - SSC Editor

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

If you’re championing a DevOps implementation in your organization, or wish to see where your current processes measure up against your peers, read on.

This article explains how, by use of schemas and stub interfaces, we can use Flyway to manage the main development work smoothly alongside any changes or additions required to maintain production-only code.

Optimizing read operations is one of the most prominent problems concerning any database administrator. In this blog, we’re going to walk you through how to solve the issues posed and at the end of the article, we’ll also walk you through some DDL operations to load test data.

In this article, I will take you through the development process of building an API on the serverless cloud with C#. This API will be built to serve pizzas, with two endpoints, one for making pizza and the other for tasting fresh pizzas. I expect some general familiarity with AWS and serverless computing. Any previous experience with building APIs in .NET will also come in handy.

When I started using GitHub Copilot, I was quite amazed at how good it was. Sessions using ChatGPT can be jaw dropping in terms of the generated content. The immediate...

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application...

If there were a Mount Rushmore of SQL Server community tools, Adam Machanic would have to be one of the four faces. You may not know his name, but...

Today, we had a new service request where our customer receives the following error when they try to run a created job in SQL Managed Instance: Cannot start the job...

If you don’t have the backups of the certificate and private key from the old server, as well as the password used to encrypt the private key backup then... The...

Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when... The...

Today, we worked on a service request that our customer got the following two error messages: The file name 'XTP' is reserved for the files containing In-Memory OLTP data or The...

Today, I got a question from a customer that they want to connect from their OnPremise environment to Azure SQL Database Private Endpoint. I would like to share with you...

Many of us are using Ola Hallengren’s maintenance solution. This post will assist you in configuring this solution when you add it to your SQL Servers. Jobs are created...

One of those functions that can be helpful – in the right circumstances – is SOUNDEX. If you hop into the Wayback Machine with Sherman, Mr. Peabody, and me,...

In this video, our colleague Kenny Yu is going to show us how to configure Azure SQL Managed Link.  

This article contains over 50 questions that can h...

Over the last year, at work and after work, I’ve...

Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild...

If you have an Azure environment when you have your DNS servers in a separate vNet from your new AKS environment you’ll notice that you get an error when...

In case that you are using Archive Access Tier res...

Today, we are launching a new reference architectu...

Learn how to deploy SQL Server instances on a virtual machine (VM) inside the Google Cloud Platform (GCP) in this step-by-step article.

SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy to announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.

SQLBits, one of the largest data conferences in the world, will be taking over the ICC Wales for a marathon of top-quality training from global specialists. With a brand-new...

In this free training I have poured my 30+ years of SQL Server experience and personally curate my favorite performance tuning tips, tricks and tactics. I am excited to...

Data Product Infrastructure as a Service Another b...

As businesses handle ever-expanding amounts of dat...

Organizations should start to rethink how data science experts collaborate and communicate with each other, but a tight IT market means offering opportunities other businesses won't.

Did you know that about 8% of the world's men are ...

Intel says it will cease selling Optane SSD DC P48...

Samsung has been enjoying market success with their lineup of portable SSDs, starting with the T1 back in 2015. The company has been regularly updating their PSSD lineup with...

Backblaze has published the company's annual repor...

A comparison in the Forspoken benchmark reveals that, with DirectStorage, PCIe Gen3 SSDs are not considerably slower than PCIe Gen5 SSDs when it comes to load times and real...

Every Power BI model has dates and the need for ca...

In December 2022, DAX was enriched with window fun...

This video introduces the syntax and functionalities of the new DAX window functions: INDEX, OFFSET, and WINDOW.

One of the most important aspects of data management is the ability to ensure that the data in your database is well defined and consistent. Some aspects of that...

Optimizing read operations is one of the most prominent problems concerning any database administrator. No matter what kind of database management system is in use – MySQL, its flavors...

+OK

In this episode of Data Exposed with Anna Hoffman and Bob Ward, take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query...

This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database's performance. First appeared on 11...

+OK

Microsoft Power BI is a very popular data visualization tool. In this article, we will discuss the most frequently asked Power BI Interview Questions and Answers. What is Power...

Use the script from Azure Runbook Can use this as reference: Steps on how I backed up my Power BI Premium Per User / Premium Database – FourMoo |...

Back in August 2022, Microsoft released a feature to have multiple audiences for Power BI Apps, or if you will deploying multiple versions of the same app where you...

This article uses Flyway and a PowerShell framewor...

In a previous post, I set up the basic databases f...

We recently released the next beta of the Microsof...

Keeping your R code organised is not as straightforward as one might think. Just think about the libraries, variables, functions, and many more. All these objects can be defined...

Today, our customer got the following error messag...

The average organization does business with 11 third parties, and 98% of organizations do business with a third party who has suffered a breach, an analysis finds.

UK sportswear retailer asks exposed customers to s...

Security vulnerabilities in VMware's vRealize Log Insight platform can be chained together to offer a cybercriminals a gaping hole to access corporate crown jewels.

This is the result of a security audit: More than a fifth of the passwords protecting network accounts at the US Department of the Interior—including Password1234, Password1234!, and ChangeItN0w!—were weak...

Learn about the new functions JSON_OBJECT and JSON...

This article talks about the commonly used scenarios of SQL Select Distinct in an easily understandable format equally suitable for beginners and professionals. The article also brings into light...

Fun With KQL - Max, MaxIf, Min, and MinIf

I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very... The...

I admit it – I do waaayyyy too much with dynamic SQL. But I just keep running into situations that require it. That being said, I ran into an...

Your detective journey starts with the Kusto Detective Agency for Azure Data Explorer. This is a really fun way to learn the Kusto Query Languate (KQL)! Patrick gets you...

Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get... The...

Intel lowers its expenses by cutting employee compensation by 5% – 25%.

Microsoft has officially stopped selling downloadable licenses for Windows 10...