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

Database Weekly for April 20, 2024 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  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 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 [The Flyway Info Command Explained Simply]( 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. AI/Machine Learning/Cognitive Services [Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts]( From SQLServerCentral Blogs If you've ever wrestled with complex SQL code, you... [Microsoft’s AI Copilot Is Starting to Automate the Coding Industry]( From IT Pro - Microsoft Windows Information, Solutions, Tools 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. Administration of SQL Server [Waiting for a Job to Complete in Powershell]( From Curated SQL 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… [Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager]( From MS SQL Server Blog 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... [How to Have a Conversation About Software Licensing]( From Brent Ozar Unlimited 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... [Dynamic Telegraf Installation for SQL Server - Hold my Place.]( From SQL Rod (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... Azure SQL [Enhanced Patching for SQL Server on Azure VMs]( From Curated SQL 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… Career, Employment, and Certifications [SQL Database Administration: Not For Everyone (But Maybe It’s for You)]( From SQLServerCentral Blogs 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... Community Interests [Collect and report session feedback for your Data/SQL Saturday event!]( From SQLSunday 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... Data Privacy, Compliance, and Governance [Microsoft Purview new data governance features]( From SQLServerCentral Blogs 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... General [Database Subetting and Data Generation]( From Curated SQL 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 ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Mirroring Snowflake in Fabric: Supercharged Analytics at No Extra Costs]( From RADACAD Microsoft Fabric offers an end-to-end SaaS analyti... [A Scaffolding Design Pattern for Microsoft Fabric Pipelines]( From Curated SQL Andy Leonard shares some thoughts on design: When ... Oracle/PostgreSQL/MySQL/other RDBMS [semab tariq: PostgreSQL Internals Part 3: Understanding Processes in PostgreSQL]( From Planet Postgres 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... [SQL/JSON in Postgres]( From Curated SQL Hubert Lubaczewski makes note of some forthcoming ... [Andrew Atkinson: Use Cases for Merging and Splitting Partitions With Minimal Locking in PostgreSQL 17]( From Planet Postgres 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... Performance Tuning SQL Server [Indexing SQL Server Queries For Performance: Equality vs. Inequality Searches]( From Erik Darling Data 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.... Security News and Issues [Why data anonymization is important to organizations – and their customers]( From Blog – Redgate Software The rise of the digital era has led to increasing ... Software Development [Branch Cleanup with git prune]( From Curated SQL Steve Jones breaks out the branch cutters: As I’... T-SQL and Query Languages [Pagination and ordering by large values]( 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. [Data Analysis with Window Functions]( From Curated SQL 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… [The How To Write SQL Server Queries Correctly Cheat Sheet: Views And Common Table Expressions Are The Same Thing]( From Erik Darling Data 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... [Avoid ROLLBACK in Triggers]( From Curated SQL Thom Andrews shares a bit of advice: A problem I�... [Snake draft sorting in SQL Server, part 2]( From Simple Talk In my previous post, I showed how to borrow a snak... Theory and Design [Department of Redundancy Department]( 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. Virtualization and Containers/Kubernetes [Kubernetes For Complete Beginners]( 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. Web [Cloudfare Turnstile, A New Way To Prove You Are Real]( 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.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -