What are you listening to as you are reading this week’s Database Weekly newsletter?

Do you listen to music when you work?

I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies?

For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I have on music. It is something I have done for many years, even before I was a full-time telecommuter. When I was in an office many years ago (and when I infrequently go to, I think it started to help drown out the sound of other people talking. Call me nosy, but I always find myself interested in the discussions around me… then I can’t get any work done. After I got used to it, it sort of became part of what makes it easier to keep me on task.

The type of music varies wildly, depending on the task. For something like this editorial that takes me varying amounts of time, I just usually click shuffle on a playlist of mostly rock and pop songs. Elvis Costello, Paul McCartney, Queen, Beatles, Marvel Soundtracks, etc. Old and new (primarily old), but the changing songs and tempo give me micro-breaks to think about every so often.

When I have a big task to do (like writing a tech article/chapter), I tend to start up something in (or near) the longer form of the prog-rock genre. So Moody Blues first few albums, many of Pink Floyd’s, The Who’s rock operas, and right now I have on one of the longest songs I know of Thick as a Brick (and I will probably follow it up with Thick as a Brick 2, and if this is a really long session, maybe Passion Play). There are plenty of other examples of long sets of music that flow together, which will work equally well. The idea here is that the singular theme doesn’t really have a big breaking point or change in mood, and the continuous theme keeps me more or less engaged.

Ultimately, I want my work music to energize and not distract me too much. The goal is to not feel the need to press the [NEXT >>] button more than once or twice an hour. Even my favorite playlist will require me to hit the skip button occasionally. The worst thing for music to do is to become a distraction.

Drop your ideas in the comments. Do you even have a well-thought-out reason for your work sound/video ritual? We would all love to know!

Louis Davidson (@drsql)

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

The Flyway info command gives you full insight into the state of your database schema and migrations, for Flyway-managed databases in every environment. When we run the Flyway info command, Flyway presents basic details of every valid migration file it can locate for that project, including files that have already been applied to the database, and any that could be. It also extracts status information about the migration files that have already been applied to a database from a special metadata table in the database called the Flyway Schema History table. This allows it to present the current schema version of any copy of the database. With the info command, you can inspect all this information on-screen or save it as a JSON file, for a script to use.

If you've ever wrestled with complex SQL code, you...

Microsoft's Copilot is responsible for an increasingly significant percentage of software being written — and is even being used to program corporations’ critical systems. But there are limitations.

Patrick Grueanuer waits for a job: The cmdlet Wait-Job waits until one or all of the PowerShell jobs running in the session are in a…

We are pleased to announce the GA release of enhanced patching capabilities for SQL Server on Azure VMs using Azure Update Manager. When you register your SQL Server on Azure...

As a consultant, I sometimes see SQL Servers with high CPU core counts relative to their workload. For example, the situation that inspired this post was seeing half a...

(Or any Telegraf config file you need to be honest... ) I like using telegraf to collect metrics, that's no secret. I've blogged the end...

Taryn Pratt has an update: We are pleased to announce the GA release of enhanced patching capabilities for SQL Server on Azure VMs using Azure Update Manager. When you…

Let's get one thing straight: database administration isn't the most glamorous tech job out there. You won't be building flashy user interfaces or trendy AI models. But if you... The...

In case you missed it, I designed a solution last year to collect session feedback for my annual Data Saturday Stockholm event, and I made this solution publicly available...

Starting last week is a rollout of the public preview of a new and fully reimagined Microsoft Purview data governance solution. Data governance has become so much more important... The...

Phil Factor tells us about two possibilities for loading a lower environment: When dealing with the development, testing and releasing of new versions of an…

Microsoft Fabric offers an end-to-end SaaS analyti...

Andy Leonard shares some thoughts on design: When ...

We explore PostgreSQL Internals in detail - its processes, architecture, the different types of processes available, and their respective responsibilities. The post PostgreSQL Internals Part 3: Understanding Processes...

Hubert Lubaczewski makes note of some forthcoming ...

This post looks at some interesting new capabilities managing Partitioned Tables coming in PostgreSQL 17, expected for release Fall 2024. The current major version is 16. Current Table...

Big, Bold Flavor Since I first started reading about indexes, general wisdom has been to design the key of your indexes to support the most restrictive search predicates first....

The rise of the digital era has led to increasing ...

Steve Jones breaks out the branch cutters: As I’...

Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to spend the resources required to present them all to us, so we are offered a manageable set of results (a “page”) at a time. In this post, I want to talk specifically about pagination when you have to order by large values.

Erika Balla looks out the window: Window functions are an advanced feature of SQL that provides powerful tools for detailed data analysis and manipulation without…

Vapor Trail Perhaps one of the most exhausting parts of my job is disabusing developers of the notion that common table expressions hold some weight in gold over any...

Thom Andrews shares a bit of advice: A problem I�...

In my previous post, I showed how to borrow a snak...

Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies. The first source of redundancy back in the dark ages, when I was just beginning the program, was a product called “carbon paper.” You younger people probably have not seen it. Paper forms came with sheets of this thin black carbon paper between duplicates of the form. As you pressed on the paper form, pressure transferred the image to the duplicates.

Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential. But what exactly is Kubernetes, and why is it such a fundamental tool in the world of software development? If you’re a complete beginner to Kubernetes, this guide is tailored just for you.

CAPTCHAs are probably the most hated things on the internet. How often are you tired of clicking those traffic lights and motorcycles? A single CAPTCHA takes 32 seconds to complete on average. Given 4.6 billion global internet users see a CAPTCHA every ten days, that would equate to 500 human years wasted every single day. This madness has to stop, but developers sometimes have to show CAPTCHA in front of a user to keep an application secure and keep the bots away. We didn’t have any better alternatives until just recently. This article describes the recommended way to integrate Cloudflare Turnstile into a React application. Cloudflare can reduce the average verification time to about a second - a substantial reduction from 32 seconds.