Best Practices and Band Plans

Allow me to suggest a few database best practices:

• Use enforced referential constraints in your relational databases
• Write your code to avoid calculations on columns in the WHERE and ON clauses
• Do not enable auto-shrink on the database

There are lots of other best practices I could recommend, but we’ll go with these three. To my mind, these are reasonable statements, and I’m making them based on years of experience, knowledge, study, and the advice of experts that I trust (due to their years of experience and knowledge). However, you’ll find that not everyone can agree. Further, some people have decided that, for example, foreign key constraints slow down development, so we’re tossing them. Others that we can’t afford to buy a disk, and keeping the databases shrunk is vital, so we’ll let them shrink every chance we get. I’ve literally heard the statement “Who are you to tell me different?” when it comes to best practices.

Short answer: Nobody. But I’m Still Right.

Let’s look at something related, but utterly different: Band Plans.

I’ve been working with Ham radios for about year since I got my Technician’s license. I’m actively studying for my General license (and will probably pass the test before this gets published). While the licensing is through the United States government by way of the Federal Communications Commission (FCC), that’s as far as government involvement goes. Volunteers manage the rest of Ham radio within the US.

While the radio waves can appear to be quite vast, they are a limited resource. To better manage this resource, the Ham radio volunteers have established several best practices. The best practices I’m referring to at the moment are the Band Plans. These define what kinds of radio signals you can send within the spectrum — Upper Side Band above 10mhz and Lower Side Band below. Phone (voice) only between 24.93mhz and 24.99mhz, but RTTY (don’t ask) and data only between 24.89mhz and 24.93mhz. The FCC enforces none of these. These are all volunteer defined best practices to which a good Ham operator adheres. However, be sure, the other Ham operators will point out when you’re violating the Band Plans. The best practices, despite not being hard and fast laws with punishment meted out by the government are still managed.

Could I decide that, instead of following the band plan, I’m going to transmit via phone (talking) way down in the data segment between 24.89mhz and 24.93mhz? Yes. Unfortunately, since no one will be looking for phone communications down there, it’s going to be awfully lonely until I step on someone’s data signal and I get an education from my fellow Hams.

Frankly, the best practices for databases should be equally well enforced. Yeah, sometimes, someone is going to make up a silly “best practice” that really shouldn’t be one (I’m old enough to remember when I was told that anything more than three joins was against best practices. It was silly 25 years ago, and it’s silly now). However, most of what is defined as best practices are good guidelines for the majority of your operations. In a true emergency, can I transmit pretty much anywhere I please? You bet. In a real emergency, can you violate any of these best practices? Absolutely. However, is this a true emergency, or are you just unwilling to realize that, maybe your development practices are to blame, not foreign key enforcement? I’m able and willing to support any violation of best practices you’re willing to show me, but you have to back it up with valid reasons, not just because it was an easy, short term choice. We data professionals should define our Band Plans and help everyone to operate within them.

Grant Fritchey

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

Phil Factor demonstrates a clever way to create 'stub' objects, in SQL Change Automation pre-deployment scripts, in order to overcome the problems caused by 'missing objects' when building databases that have circular, or mutual, dependencies. In the subsequent deployment, SQL Change Automation fully builds every object in each of the databases, so all dependencies are fully tested.

Greta Rudžioniene provides a step-by-step guide to running SQL code analysis checks, as defined by SQL Code Guard, in SonarQube, a general-purpose code quality tool that can perform continuous code analysis on a variety of languages.

Five SQL Server experts have brought their collect...

Dealing with errors is one of the essential elements of programming applications. The way to do so has changed over the years and versions of ASP.NET. In this article, Dino Esposito discusses how handle exceptions with ASP.NET Core 3.0.

Click to learn more about author Rosaria Silipo. T...

Don’t. It’s not your job. No, seriously, hang ...

You can now set MaxDOP during SQL 2019 CTP3.0 setu...

So far in the DBA Training Plan, we’ve been work...

Log backup for database "SQLAuthority" on secondar...

sys.dm_db_database_page_allocations is an undocume...

Erin Stellato uses a simple example to demonstrate...

Microsoft goes to great lengths to ensure data int...

Thomas Rushton warns us that undocumented commands...

SQL Server Agent operators are used by SQL Server ...

Welcome back to The Ironic DBA Files, a series whe...

I’ve said it before and I will repeat myself on ...

I’ve said it before and I will repeat myself on ...

Azure SQL Database has a new “serverless” mode...

One year and nine months ago, I took my first form...

If you are interested in learning Azure, cool! I a...

Google has announced a new feature for its cloud p...

eWEEK RESOURCE PAGE: The three largest cloud compu...

When dealing with cloud technology there is a phra...

Wednesday August 21 16.00-17.00 BST/ 10.00-11.00 Central - SQL Clone enables dev, test and CI environments to be created and refreshed in seconds, on demand or through self-service, with the latest copy of production data, masked for compliance.

Thursday August 29 18.00-19.00 BST / 10.00-11.00 Pacific - Register for this Microsoft hosted webinar to learn how Redgate tools for SQL Server help deliver software quickly.

Wednesday September 4 14.00-19.00 BST/ 08.00-13.00 Central - Register for our free virtual learning event, to enjoy educational and entertaining sessions from Microsoft MVPs and celebrate 20 years of Redgate.

I am honored to deliver my brand-spanking-new full...

I am honored to deliver Moving Data with ADF to th...

My pre-conferences (a day-long training in Prague ...

Save the Date! September 18, 2019 – Dallas, TX 8...

The settlement does nothing to address the underly...

The O’Reilly Data Show Podcast: Cassie Kozyrkov ...

There’s been a lot of excitement about the book ...

SQL Server AlwaysOn Availability Groups is Microso...

Liqid, a maker of SSDs for mission critical and pe...

Ice Lake boasts significant power savings and much...

So far in this series, Andy Brown of Wise Owl Training has shed light on functions like CALCULATE, VALUES and FILTER, but it’s only when you understand the idiosyncrasies of the EARLIER function that you can claim to have genuinely cracked DAX. This article gives four examples of the use of this peculiar function, in the process explaining why it has such a misleading name. Using the EARLIER function properly all boils down (as is so often the case with DAX) to understanding row and filter context. The article also shows how to use the RANKX function to sort data into your required order.

So far in this series, Andy Brown of Wise Owl Trai...

Level: Intermediate In my last article, I introduc...

Matt Allington takes us through the FILTER() funct...

I would like to start my first Machine Learning pr...

Holger von Jouanne-Diedrich takes us through an ex...

I had a server that looked like it had been suffer...

Thirsty Thursday If you’ve made it this far, you...

SQL Server caches object data in memory in the buf...

Many Have Entered, Few Have Left For some backgrou...

Watch this week’s Statistics video on YouTube. L...

Imbalance In yesterday’s post, we looked at a fu...

One of the more interesting parts of SQL Server 20...

The SQL Server 2019 CTP 3.2 release notes includes...

Power BI licensing options are a mystery to many. ...

This post discusses new features released in May 2...

Debugging DAX codes can be sometimes a bit of chal...

Patrick shows you how to create Siri shortcuts wit...

Power Query can connect to a web page and get data...

I wrote about the violin plot custom visual by Dan...

Marc Lelijveld has started a series on storytellin...

Jess Pomfret shows us how we can aggregate data us...

In a recent post I wrote about collecting server p...

Kathi Kellenberger explains how to avoid build pro...

What if you have several people in the team who ar...

Microsoft Machine Learning Server, the enhanced de...

Are you interested in guest posting? Publish at Da...

Are you interested in guest posting? Publish at Da...

Are you interested in guest posting? Publish at Da...

Are you interested in guest posting? Publish at Da...

If you use replication, you have had the situation...

Pamela Mooney takes us through tearing down replic...

This article talks about creating a professional S...

PolyBase has been around since 2016, but Microsoft is enhancing it in 2019 with the ability to connect to more data sources. You can now use PolyBase to connect to other SQL Server instances, and it’s easy to set up with a wizard. In this article Benjamin Weissman explains what’s new in PolyBase and walks you through setting it up and connecting to an external table.

Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to work with columnstore indexes, a different way to store tables that can drastically improve the performance of specific workloads.

If you’re still using sp_who, sp_who2, and Activ...

(Glenn’s Tech Insights… used to be part of our...

Three Louisiana school districts, Georgia agency p...

It was revealed today that about 100 Million recor...

In this piece of research, attackers successfully ...

Dear Engineer. You failed your licensing exam. Ope...

Whistleblower said Cisco waited more than 4 years ...

I was generally reading about SQL Server and how t...

This post describes how to apply an Entity Framewo...

Question: How to Remove Quotes of QUOTENAME? I re...

Phil Factor demonstrates why SQL Prompt has a 'Bes...

If you are executing a stored procedure with a bun...

Hello, and welcome to today’s class on storing p...

Preventing direct access to database tables for us...

The ASCII character set is comprised of 128 charac...

As the price of this class high, I wanted to keep ...

Madhivanan shows how you can find special characte...

I did an interesting form of crossword recently an...

"Boeing became furious and tried to get me fired."...

This post continues looking at my process of learn...

One of the things that’s handy when working with...

Being able to seamlessly run Linux on Windows is m...