Moore's Law: Navigating the Pace of Technologic al Change (DBW 2023-04-15)

Moore's Law: Navigating the Pace of Technological Change

Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In more recent years, this concept has been broadly applied to technology in general, reflecting the exponential growth of available information.

The recent passing of Gordon Moore, the co-founder of Intel and the man behind Moore's Law, in late March, has prompted me to reflect on the pace of change in technology. While I'm not sure if the features, speed, or abilities of relational databases have doubled every two years, the constant pace of innovation and change can be dizzying. The challenge, however, is that most companies like their databases to be boring and stable. Upgrades were often seen as a disruption that needed to be minimized until there was a truly compelling reason to move forward.

However, recent data from a post by Brent Ozar, detailing the distribution of currently running SQL Server versions for the service his company provides, surprised me. According to the report, more than 80% of servers were running SQL Server 2016 or newer, with a surprising 33% running SQL Server 2019. This suggests that many companies are keeping up with the pace of change and upgrading their databases to newer versions. I believe there are two main reasons for this trend.

First, the process of upgrading databases and applications has become significantly easier over the years, with improved tooling and increased confidence in successful outcomes. Second, the adoption of cloud-managed services has allowed companies to delegate the management of complex tasks, such as database upgrades, to external providers, allowing them to focus on development and innovation.

While these improvements may not have occurred at the speed of Moore's Law, in the context of a 25-30 year career, the overall pace of change is still impressive. It's a testament to the innovation happening around us and how much more we're able to accomplish as technology continues to advance.

As we reflect on the legacy of Gordon Moore and the concept of Moore's Law, it's important to acknowledge the benefits of keeping up with the pace of technological change. Upgrading databases and leveraging cloud-managed services can enable companies to stay competitive, take advantage of new features and capabilities, and drive innovation in their industries. While the pace of change in technology may be relentless, it also presents us with unprecedented opportunities for growth and progress.

Now, who's upgrading to SQL Server 2022 this week?

Ryan Booz

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

Armed with a schema comparison engine and an object-level directory of the source for every recent version of the database, you'll be able to remove a lot of the uncertainty around merging database changes back into development.

This article outlines the syntax of the three and four dot references that usually denote external database references, demonstrates how to find them either from a live database or by using a text search of a script, and explains some of the complicating factors that can lead to 'false positives'.

In an IT environment, ChatGPT can be useful for researching tasks, generating step-by-step instructions, and creating custom scripts and files.

The Biden administration follows China, Italy, Canada and the U.K.

I always like to start with something easy, or at least easy for me… ChatGPT, using GPT4 is moving Tags: Azure CLI, ChatGPT Del.icio.us Facebook TweetThis Digg ...

This story originally appeared in The Algorithm, our weekly newsletter on AI. To get stories like this in your inbox first, sign up here. This year millions of people have...

Moving from #SQLServer to #PostgreSQL as a developer or DBA can be challenging with knowing how to use your existing knowledge in context of the new platform. Whenever I talk to folks working through this process, I always start by talking about these four memory and connection settings.

David Fowler gives it to us straight: xp_cmdshell is an extended SQL stored proc that allows users to run Windows command prompt commands from within…

Ed Pollack gives us the scoop on ordered columnstore indexes: One of the more challenging technical details of columnstore indexes that regularly gets attention is…

Almost all Azure virtual machine sizes come with a...

Free Work Recently I answered a question on Stack ...

This month we will be covering some features in SQL 2022. Specifically, I will create a new SQL 2022 Development instance and connect it to Azure Arc. Azure Arc...

A while back I posted a blog on how to recover data with crash consistent snapshots. Snapshots are pretty handy in certain situations so I thought I’d show you...

THE VIDEO THE SYNOPSIS Want to try out SQL Server without explicitly installing (or needing to uninstall) it? Here’s how to run SQL Server on Linux in a container....

Sandeep Arora has a checklist for us: We have broken our Snowflake Migration Checklist into nine phases to help plan and execute an end-to-end migration…

Power BI and Azure are two related services, but with a considerable independence between them. Power BI share the Azure Tenant for security management, but in relation to networking, they are in completely different environments.

Niko Neugebauer makes a few recommendations: Optimizing costs in SQL Managed Instance isn’t a one-size-fits-all situation—there are several cost-saving benefits and capabilities to take advantage…

Want to leverage the power of the cloud with your on-prem SQL Server? Azure SQL Managed Instance may be the answer for you! Dani joins us to talk about...

Check out these tips and tricks for a successful video interview so the next time you have an online interview you are better prepared.

Many IT professionals are feeling overworked and u...

Is block storage better than object storage for storing data in the cloud? That depends on your needs. Here are the pros and cons of both types of storage.

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more.

In this video tutorial, Brien Posey demonstrates h...

Like an invisible virus, “dirty data” plagues ...

Being a DBA and/or a database programmer is like playing several chess games simultaneously. Each opponent is formidable, crafty, and unlike a chess-playing computer, completely unpredictable. This unpredictability has led to software development methodologies that seek to manage this problem. But just like chess, if you have no forethought of where your opponents will move next, it can only exasperate your problems.

In this series of blog posts, we speak with database professionals from Financial Services organizations around the world to better understand how DevOps is shaping the sector. On the...

There is no excerpt because this is a protected po...

I delivered a session on graph databases, and in it I used RedisGraph to show how you can work with graph data on that platform. This blog shows a... The...

Laetitia Avrot is not a fan of triggers: My opinion comes from years of practicing as a production DBA, then as a database consultant. As…

Ryan Booz shares some thoughts on triggers: By design, plain ANSI SQL is declarative (“hey database, this is the data I want, you figure out…

A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part of this series, we spoke about MySQL Replication, the different types, replication...

An important aspect of building and managing a database is organizing the objects within your database. You may have tables that support different functions, for example, a schema for...

Connections When one thinks of effective communicators, indexes aren’t usually at the top of the list. And for good reason! They’re more the strong, silent type. Like Gary Cooper,...

Stick And Move If you take performance for your SQL Servers seriously, you should be using Query Store for your business critical databases. I used to say this about...

Why the "a measure is used in cross highlighting" ...

Power BI supports the security of the data at the dataset level. This security means everyone can see the data they are authorized to see. There are different levels...

Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem.

Imagine, you have everything setup and well secured in your data lakehouse, or data warehouse if you will. Then a user starts consuming the data in Power BI and...

Amieroh Abrahams builds some graphs: In Excel it is challenging to eye-ball which changes have been made to a graph, especially if these were minor…

Steven Sanderson does a bit of Excel file reading: Reading in an Excel file with multiple sheets can be a daunting task, especially for users…

Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the spring 2023...

Hackers can compromise public charging hubs to ste...

Home Security Heroes, a cybersecurity firm, shares...

I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data set such as a numbers or calendar table. A few favorites include building sample data, pivoting an unknown number of columns, data extrapolation, and filling gaps in date or time ranges.

In this article, we will compare APPLY to ROW_NUMBER() for returning the TOP (n) rows from a SQL Server table.

Words: 1,283 Time to read: ~ 7 minutes Welcome to T-SQL Tuesday, the monthly blogging party where a host provides a topic, and we blog about it. This month...

There are trillions of microbes living in and on our bodies—and we might be able to modify them to help us treat diseases. Scientists have altered the genomes of...

New editor is integrated with Python lessons, but ...

A new beta application enables Android and Windows...

Distributed computing project uses RP2040-powered ...

Apple personal computer shipments declined by 40.5% in the first quarter. Shipments by all PC makers have slumped as the demand surge driven by pandemic-era remote work evaporated, according...

A constant challenge for many development teams is how to include test data management in the development process. Testing with consistent, realistic and compliant datasets, and bringing the database...