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
 

Planes, Trains, and Automobiles

I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just a few years ago for the first time in a couple of decades, it really is a classic of my childhood with two of the most popular comedy actors at the time (RIP John Candy).

A comedy movie from 1987? What in the world does that have to do with data and technology on a balmy July Saturday in 2024? Has anyone ever heard of a company called Crowdstrike?

(pause for dramatic effect)

As you may have seen from a few other Redgate employees, we gathered in Austin this week to celebrate our 25th anniversary. It was a great opportunity to see lots of people that I don’t normally get to connect with in person, and a lovely time of celebration. Plus, Steve, Grant, and I may have gotten a few new Simple Talks podcast episodes recorded to release later this year.

And then, Friday happened.

I had scheduled a later morning flight to get from Austin back to State College. With one connection in Washington, D.C., the trip was supposed to take about five hours total. Then, at 9:30am, the first delay notification for two hours arrived. Then another. And another. In total, the flight was delayed by more than four hours. Even though it was clear we would eventually leave Austin, it was becoming even more clear that there was no way I’d make my connecting flight in D.C. The earliest United could get me home from there was Sunday afternoon. That just wasn’t going to work.

“No problem,” I thought, “I’ll just rent a car and drive 4.5 hours.” Nope, the rental car companies were having nothing of the one-way rental game this weekend.

“OK, I’ll catch a Megabus!” except that option was going to take 12.5 hours.

“No worries! A Greyhound will surely be quicker and more direct.” Heh… guess not.

“Oh wait, I could get a train to within about 30 miles of State College and have someone pick me up. Yeah, that’s the ticket!” (pun intended). With a brief search, this actually seemed like it was a viable option so I booked the tickets. And it all went smoothly this morning; Uber to the train station, departed on time, spacious seats, smooth ride. But since I don’t travel by train in the U.S. ever, it never occurred to me that a 25-minute layover in Philadelphia might be cutting it close. That is, until the train rolled in into the station as my connecting train was pulling away.

And yes, there’s only one train a day that goes near State College.

My only option at this point was to take a later train to Harrisburg and have family pick me up from there, an 80-mile trip. As I type this, I’m waiting at the Philadelphia 30th Street Station for that connecting train. It’s been a long 32 hours, but at least I’ll be home tonight.

If you made it this far, thanks for letting me detail my little travel adventure. I’m not looking for pity or to complain. Life happens, and surprisingly, most people I’ve been around the last two days have been understanding and kind to the employees just trying to do their job.

But wow! 8.5 million Windows computers were affected by a “routine” update of some definition files for their Falcon Sensor software. At least, I assume, based on initial reporting, that these updates were a routine update used to enhance security capabilities of the software. The engineers that were involved (and there was certainly more than just one), had probably created updates like this dozens of times. To them, this had become a routine thing with apparently low risk of causing a crippling worldwide computer outage that would disrupt the lives and services of untold numbers of people.

Having routine tasks is often really good for us, until we forget what’s at stake. As data professionals, our days are often filled with routine tasks. Select some data from here. Update a report there. Modify the application schema for the next application release. Unfortunately, many of these tasks rarely include testing or validation in a proper environment that can help the team spot problems before a defect causes real damage. Does your routine work still support best practices like testing and validation?

Friday was quite a unique day. However, if we just let it pass by as a one-day headline, we miss the opportunity to examine our current practices and procedures to help identify weaknesses that may exist simply because so much of what we do has become routine.

So don’t miss the wakeup call. Take the time, do the work, and help protect your future self, and your future customers, from a minor update becoming a major event. While I have some more time on this travel adventure, I’m going to start doing the same.

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

Running Database Tasks and Tests on Clones in Redgate Test Data Manager

This article demonstrates how to adapt your current database development and testing regimes to use clones (data containers) in Redgate Test Data Manager. It demonstrates how to handle dynamic connection details and how to get from the containers the connection and database information that your development tasks and tests need to function correctly.

Administration of SQL Server

Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT

From MSSQL Tips

This article explores how enabling READ_COMMITTED_...

Azure Databricks, Spark and Snowflake

Finding Query History in Snowflake

From Curated SQL

Kevin Wilkie digs into the history: If you’re ru...

Azure SQL

Choosing between Azure SQL DB Ledger and Azure Confidential Ledger

From Curated SQL

Pieter Vanhove reminds me that ledger tables exist: Ledger technology is a way of storing data that ensures its integrity, immutability, and verifiability. It can…

Community Interests

Updated, Larger Stack Overflow Demo Database

From Brent Ozar Unlimited

Stack Overflow publishes a data dump with all user...

Conferences, Classes, Events, and Webinars

PASS Summit Futures Scholarship

In celebration of their 25th anniversary in 2024, Redgate, as the host of PASS Summit, is thrilled to introduce the PASS Summit Futures Scholarship. This initiative aims to empower the next generation of data professionals from diverse backgrounds. Applications are open internationally to students and early-career professionals. Each of the 10 lucky winners will be awarded: - one complimentary 3-day ticket to PASS Summit 2024 - US$2000 payment towards flights, accommodation and expenses. Applicants should ensure they can comply with the full Terms and Conditions before applying, and the deadline to submit applications is August 23, 2024. Forward this email to anyone you think might be interested and encourage them to apply now!

Database Design, Theory and Development

Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions

The temporal database is a database that can keep information on time when the facts represented in the database were, are, or will be valid. We briefly described major concepts of temporal databases and discussed types of queries that such databases can support in part 1 of this article series. The content of part 1 is essential for understanding the part 2.

DevOps and Continuous Delivery (CI/CD)

Viewing the File System of an ADO Pipeline Agent

From Curated SQL

Justin Bird goes spelunking: There are several predefined variables that you can use within an Azure DevOps pipeline, some of which allow you to reference…

Script Tasks in Azure DevOps Pipelines

From Curated SQL

Justin Bird builds a script task: There are several dedicated script tasks that can be used for different purposes, some of the tasks have shortcut…

DocumentDB/Key-Value/Graph/other NoSQL Databases

Working with Documents in the MongoDB Compass GUI

Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following along, you should now have a good sense of how to perform basic create, read, update, and delete (CRUD) operations. As you might recall, much of my focus has been on how to use MongoDB Shell to carry out these operations. This has been especially true when it comes to modifying data. In this article, I focus squarely on the MongoDB Compass GUI, demonstrating features within the interface for working with the documents directly.

ETL/SSIS/Azure Data Factory/Biml

SSIS: Reading pipe delimited text and selecting particular output columns

From The Bit Bucket

There was a question on the Q&A forums today, ...

MDX/DAX

When are variables evaluated in DAX?

From SQLBI

This article clarifies how DAX evaluates variables...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Three ways to create a Microsoft Fabric Data Warehouse Database Project

From Kevin Chant

Reading Time: 5 minutes In this post I want to co...

Overwhelmed with all the Microsoft Fabric Updates???

From Guy in a Cube

There are a lot of updates coming with Microsoft F...

Performance Tuning SQL Server

A Little About Index Design Patterns In SQL Server

From Erik Darling Data

A Little About Index Design Patterns In SQL Server...

Query Exercise: Fix This Computed Column.

From Brent Ozar Unlimited

Take any size of the Stack Overflow database and c...

PostgreSQL

Andrei Lepikhov: How expensive is it to maintain extended statistics?

From Planet Postgres

In the previous post, I passionately advocated for...

Tomas Vondra: Autovacuum Tuning Basics

From Planet Postgres

A few weeks ago I covered the basics of tuning che...

Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions

From Simple Talk

The temporal database is a database that can keep ...

HammerDB and PostgreSQL- Part I

From DBAKevlar

There’s a large influx of PostgreSQL databases c...

Elizabeth Garrett Christensen: Magic Tricks for Postgres psql: Settings, Presets, Echo, and Saved Queries

From Planet Postgres

As I’ve been working with Postgres psql cli, I’ve picked up a few good habits from my Crunchy Data co-workers that make my terminal database environment easier to work...

PowerPivot/PowerQuery/PowerBI

Why Power BI Table Visuals With Scrollbars Can Cause Problems

From Chris Webb's BI Blog

Concluding my series of blog posts on seemingly ha...

Comparing calculation options in Power BI, including Visual Calculations

From Data – Marc

There are tons of options in Power BI to add your ...

Security News and Issues

Review your Disaster Recovery Plans and keep them ready

From DCAC

If you didn’t notice yesterday (July 18, 2024), ...

T-SQL and Query Languages

Statistics IO. IO... IO... it's off to parse we go.

From SQL Rod

Again, this is another one of those little bits of...

Daniel Vérité: Implementing UUIDs v7 in pure SQL

From Planet Postgres

In May 2024, the IETF standard on UUIDs (Universal...

flyway

Friday Flyway Tips–Comparison Defaults

From SQLServerCentral Blogs

One of the little details that I find matter more and more in enterprises is understanding why a tool behaves a certain way. OSS/home-grown ones often have limited docs,... The...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -