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

Database Weekly for April 15, 2023 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  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](  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 [Database Branching and Merging without the Tears]( 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. [Finding External References in Database Deployments]( 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'. AI/Machine Learning/Cognitive Services [How ChatGPT Can Make Life Easier for IT Professionals]( From IT Pro - Microsoft Windows Information, Solutions, Tools In an IT environment, ChatGPT can be useful for researching tasks, generating step-by-step instructions, and creating custom scripts and files. [U.S. Takes First Step to Formally Regulate AI]( From IT Pro - Microsoft Windows Information, Solutions, Tools The Biden administration follows China, Italy, Canada and the U.K. [ChatGPT – Oracle Deployment in Azure via Azure CLI]( From DBAKevlar 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 ... [AI literacy might be ChatGPT’s biggest lesson for schools]( From Technology Review Feed - Tech Review Top Stories 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... Administration of SQL Server [PostgreSQL for the SQL Server DBA: The First Four Settings to Check]( 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. [xp_cmdshell Is Not the Problem]( From Curated SQL 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… [Ordered Columnstore Indexes in SQL Server 2022]( From Curated SQL 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… [How to put tempdb on your Azure VM temp disk]( From Sunday morning T Almost all Azure virtual machine sizes come with a... [The SQL Server Documentation About Parallelism Is Misleading]( From Erik Darling Data Free Work Recently I answered a question on Stack ... [How to Provision a Low-Cost SQL 2022 Testing Lab]( From StraightPath Solutions SQL Blog 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... [Video – Recovering data with crash consistent snapshots]( From DBA From The Cold 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... [Video: Installing SQL Server in a Container]( From 36 Chambers – The Legendary Journeys 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.... Azure Databricks, Spark and Snowflake [Checklist for a Snowflake Migration]( From Curated SQL 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… Azure SQL [Using Virtual Network Data Gateways to Secure Access to Azure SQL in Power BI]( 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. Azure SQL Managed Instance [Cost Optimization with Azure SQL Managed Instance]( From Curated SQL 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… [Use Azure SQL Managed Instance Link to have a Read Replica in the cloud!]( From Guy in a Cube 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... Career, Employment, and Certifications [Tips for Successful Video Interviews for Technology Professionals]( From MSSQL Tips Check out these tips and tricks for a successful video interview so the next time you have an online interview you are better prepared. [Angling for a Pay Raise: IT Workers Hold the Advantage]( From IT Pro - Microsoft Windows Information, Solutions, Tools Many IT professionals are feeling overworked and u... Computing in the Cloud (Azure, Google, AWS) [Block Storage vs. Object Storage in the Cloud]( From IT Pro - Microsoft Windows Information, Solutions, Tools 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. Conferences, Classes, Events, and Webinars [PASS Data Community Summit registrations are open!]( 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. DMO/SMO/Powershell [Secure Sensitive Information in PowerShell Scripts With Encryption]( From IT Pro - Microsoft Windows Information, Solutions, Tools In this video tutorial, Brien Posey demonstrates h... Data Mining / Data Analysis [Overcoming a World Awash in Dirty Data]( From Dataversity Like an invisible virus, “dirty data” plagues ... Database Design, Theory and Development [The role of forethought for a computer engineer]( 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. DevOps and Continuous Delivery (CI/CD) [How DevOps is shaping Financial Services #3: The impact of technical debt]( From Blog – Redgate Software 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... [Protected: DevOps & CI/CD for Power BIÂ]( From Paul Turley's SQL Server BI Blog There is no excerpt because this is a protected po... DocumentDB/Key-Value/Graph/other NoSQL Databases [Creating a Simple Graph in RedisGraph]( From SQLServerCentral Blogs 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... Oracle/PostgreSQL/MySQL/other RDBMS [Against Triggers in PostgreSQL]( From Curated SQL 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… [A Love-Hate Relationship with Triggers]( From Curated SQL 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]( From Simple Talk 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... [PostgreSQL Schema: Learning PostgreSQL with Grant]( From Simple Talk 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... Performance Tuning SQL Server [How Indexes Talk To Each Other In SQL Server]( From Erik Darling Data 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,... [How To Find Poorly Performing SQL Server Queries To Tune Using Query Store]( From Erik Darling Data 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... PowerPivot/PowerQuery/PowerBI [Understanding The “A Measure Is Used In Cross Highlighting” Error In Power BI]( From Chris Webb's BI Blog Why the "a measure is used in cross highlighting" ... [Data-Level Security in Power BI]( From RADACAD 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... [Optimizing SWITCH on slicer selection with Group By Columns]( From Sqlbi 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. [Simplifying Security Replication in Power BI: A Step-by-Step Guide]( From Data – Marc 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... R Language [Comparing Data Visualization in Excel and R]( From Curated SQL 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… [Reading Multi-Sheet Excel Files in R]( From Curated SQL 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… SQL Server News [SQL ConstantCare® Population Report: Spring 2023]( From Brent Ozar Unlimited 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... Security News and Issues [FBI & FCC Warn on 'Juice Jacking' at Public Chargers, but What's the Risk?]( From Dark Reading: Dark Reading News Analysis Hackers can compromise public charging hubs to ste... [AI Can Crack Most Common Passwords In Less Than A Minute]( From Tom's Hardware US Home Security Heroes, a cybersecurity firm, shares... T-SQL and Query Languages [GENERATE_SERIES: My new go-to to build sets]( 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. [Return TOP (N) Rows using APPLY or ROW_NUMBER() in SQL Server]( From MSSQL Tips In this article, we will compare APPLY to ROW_NUMBER() for returning the TOP (n) rows from a SQL Server table. [T-SQL Tuesday 161: Having Fun with SQL]( From No Column Name 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... Tech News [Bacteria can be engineered to fight cancer in mice. Human trials are coming.]( From Technology Review Feed - Tech Review Top Stories 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... [Raspberry Pi Launches Online Code Editor to Help Kids Learn]( From Tom's Hardware US New editor is integrated with Python lessons, but ... [How To Send Files from Phone to PC With Android Nearby Share]( From Tom's Hardware US A new beta application enables Android and Windows... [Developer Builds Cluster with 9 Raspberry Pi Pico Boards]( From Tom's Hardware US Distributed computing project uses RP2040-powered ... [Apple Takes a Sharp Plunge in Personal Computer Shipments]( From IT Pro - Microsoft Windows Information, Solutions, Tools 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... Virtualization and Containers/Kubernetes [Redgate opens the doors to cross-database DevOps Test Data Management]( From Blog – Redgate Software 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...  [RSS Feed]( 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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -