A Jumble of Letters With A Purpose

Database Weekly for September 21, 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  etaoin shrdlu No, I haven't had a stroke. I'm 100% sure this is probably something that comes up every couple of years. I've no doubt that the editorial I'm about to write has been written 20 times by others, but here we go. What the heck is etaoin shrdlu? Well, it's simple. Linotype machines (which I've operated because my uncle owned a newspaper back in the 1970s) used hot lead to set the type for newspaper printing. Because it was using hot lead to make a line of print, there was no such thing as a backspace or delete key. So if you committed the dreadful sin of a typo, you had to finish the line. It became a standard practice to just run your finger down the line of keys on the left side of the Linotype machine which spelled, yeah, you got it, etaoin on the first set of keys and shrdlu on the second. In theory, the proofreader would spot this and eliminate that line from the newspaper (literally toss the lead back into the hopper for tomorrow's edition). Yet, there are thousands of examples of this making it into the paper regardless. I do so love history. It's the stories you see. They're so fun. Anyway, back to the editorial... My question to you, dear reader, is simple. What is our equivalent of etaoin shrdlu? What artifact have we created, or are we actively creating, that the future is going to look back on and simply say, "wut"? Without a doubt we're, somewhere, somehow, running our fingers down the figurative side of our Linotype keyboard and accidently letting it out into the wild. I'd love to hear what you think it is. I have a theory or three, but I'm not sharing them at this time (it's a good idea to greedily hold on to good ideas for future editorials). What have you got? Grant Fritchey [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 [Microsoft to Showcase Latest Database Innovations at PASS Summit 2024]( Join Microsoft at PASS Summit 2024 to discover the latest advancements in database technologies. Learn how Azure database solutions power apps in the AI era by enhancing performance, security, and scalability. Connect with peers, hear from Microsoft leaders, and attend expert-led sessions on database modernization and migration. Register today for expert-led sessions and networking opportunities! Use code AZURE150 to get $150 off tickets. AI/Machine Learning/Cognitive Services [Why OpenAI’s new model is such a big deal]( From Technology Review Feed - Tech Review Top Stories This story is from The Algorithm, our weekly newsl... [There are more than 120 AI bills in Congress right now]( From Technology Review Feed - Tech Review Top Stories More than 120 bills related to regulating artifici... [How AI can help spot wildfires]( From Technology Review Feed - Tech Review Top Stories This article is from The Spark, MIT Technology Rev... [AI applications in the manufacturing sector]( From Purple Frog Systems Artificial Intelligence (AI) is revolutionizing industries across the globe, and the manufacturing sector is no exception. By leveraging AI, manufacturers can enhance efficiency, reduce costs, and improve product quality.... Administration of SQL Server [Can You See Who Forced a Plan]( From SQLServerCentral Blogs I had an excellent group of people in Gothenburg S... [What is Change Management and the SQL Server DBAs Role]( From MSSQL Tips This article will explain Change Management, how D... [What is Change Management and the SQL Server DBAs Role]( From MSSQL Tips This article will explain Change Management and how DBAs are involved and can benefit from it. [Can You See Who Forced a Plan]( From Scary DBA (Grant Fritchey) I had an excellent group of people in Gothenburg Sweden when I taught there and I was asked: Can You See Who Forced a Plan? I didn’t know the... [Troubleshooting Security Cache Growth In SQL Server (USERSTORE_TOKENPERM And TokenAndPermUserStore)]( From Erik Darling Data Troubleshooting Security Cache Growth In SQL Server (USERSTORE_TOKENPERM And TokenAndPermUserStore) Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... Analysis Services / BI on the MS Stack [Why CFOs Can’t Afford to Delay BI Adoption]( From Joyful Craftsmen – The Business Intelligence Agency The post Why CFOs Can’t Afford to Delay BI Adopt... Azure Databricks, Spark and Snowflake [Instant data replication with Databricks table cloning]( The simplest use case to explain why table cloning is helpful is this: Let’s say you have a large table, and you want to test some new process on it, but you don’t want to ruin the data for other processes, so you need a clean copy of your table (or multiple tables) to play with. Coping a large table might take time (Databricks does it very fast, but if it’s a big table it still takes time to copy the data) ,and what happens if you then need to change your code? [Snowflake Data Catalog and Objects]( From Mike McQuillan Blog Used any type of RDBMS before? Then you might find a lot of Snowflake's objects familiar. Despite its cloud-based nature, Snowflake is in essence a relational database system. Which... [When you have a really bad morning in Snowflake]( From Sherpa of Data This week, I want to talk about something we’ve all done at least once – especially before our first cup of coffee in the morning. Yes, that’s right –... Azure SQL [Moving from Amazon Quantum Ledger Database (QLDB) to ledger in Azure SQL]( From Azure SQL Overview Amazon Web Services (AWS) has announced the discontinuation of its Amazon Quantum Ledger Database (QLDB). Their documentation has been updated to indicate that support for QLDB will end on... Career, Employment, and Certifications [Skills-Based Hiring in IT: How to Do It Right]( From IT Pro - Microsoft Windows Information, Solutions, Tools By focusing directly on skills instead of more sub... Cloud - AWS [AWS Services Using SQL for Big Data Analysis]( SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can create specific and customized queries to extract essential data subsets, making it easier to begin exploring and comprehending the dataset. Additionally, it is important in data transformation because it offers a variety of tools for standardizing, cleaning, and preprocessing data. [Data engineering professional certificate: New hands-on specialization by DeepLearning.AI and AWS]( From AWS News Blog Gain indispensable data engineering expertise thro... [AWS named as a Leader in the 2024 Gartner Magic Quadrant for Desktop as a Service (DaaS)]( From AWS News Blog The 2024 Gartner Magic Quadrant positions AWS as a Leader, reflecting our commitment to diverse virtual desktop solutions and operational excellence - driving innovation for remote and hybrid workforces. [AWS Services Using SQL for Big Data Analysis]( From Simple Talk SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can create specific and customized queries to extract essential data subsets, making it... Cloud - Azure [How To Use Managed Identities in your Azure Logic Apps]( From Simple Talk Azure Logic Apps are a cloud-based service where y... [SQL Server on Azure VM: Automated Patching Retirement and Replacement with Azure Update Manager]( From MS SQL Server Blog The automated patching feature for SQL Server on Azure VM will be retired on September 17th, 2027.  While Automated Patching is being retired, we’re excited to replace it with Azure... Community Interests [What I learned volunteering at a children's summer camp]( From SQLServerCentral Blogs  "Stories are where memories go when they are for... Computing in the Cloud (Azure, Google, AWS) [Guide to Cloud Computing ETFs]( From IT Pro - Microsoft Windows Information, Solutions, Tools Cloud computing ETFs provide an easy, diversified ... Conferences, Classes, Events, and Webinars [Microsoft return to PASS Summit 2024 as Sapphire sponsor]( Get ready to meet Microsoft's experts on-site in the exhibit hall and in multiple educational sessions (including a pre-con, keynote and learning pathway). Watch a sneak peek of Microsoft's learning pathway 'Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA' [Contest: What’s Your Biggest Database Regret?]( From Brent Ozar Unlimited We all make mistakes. I certainly have. I’ll give you a recent one, actually: when we designed the database for SQL ConstantCare®, when we’re storing diagnostic data like wait... [Join Me And @Kendra_Little At @PASSDataSummit For 2 Days Of SQL Server Performance Tuning Precons!]( From Erik Darling Data Last Year Kendra and I both taught solo precons, and got to talking about how much easier it is to manage large crowds when you have a little helper... DMO/SMO/Powershell [Parsing EXE Output in PowerShell]( From SQLServerCentral Blogs I saw a post internally that asked this question: ... Data Visualisation [what's the right ratio of words to data?]( From Storytelling with Data Goldilocks and the Three Bears is an oft-invoked metaphor for the situation in which, among a range of options, the target is a zone between “too much” and “too... Database Design, Theory and Development [Charting a Course Through the Data Mapping Maze in Three Parts]( From Dataversity Companies are dealing with more data sources than ... DocumentDB/Key-Value/Graph/other NoSQL Databases [Introducing Schema Validation in MongoDB]( Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems in which well-defined schemas are essential to ensuring data integrity. In MongoDB, you can add documents to a collection that contain different fields or that include the same fields but with different data types or value ranges. You can even add documents that are completely unrelated. As long as you use proper Binary JSON (BSON) formatting, just about anything goes. [Working with Schema Validation in MongoDB]( From Simple Talk In the previous article in this series, I introduc... ETL/SSIS/Azure Data Factory/Biml [SSIS Extension Updates – Sep 2024]( From AndyLeonard.blog() Back in Jun 2024, I announced I was changing the w... [SSIS with SQL Always Encrypted Data]( Unfortunately, the gotchas continue, as it isn't straight forward when using yet more toolsets to access Always Encrypted data. All easily doable, as long as you make a tweak or two to the normal methods you may be using already. General [Automating Data Cleaning Processes with Pandas]( Few data science projects are exempt from the necessity of cleaning data. Data cleaning encompasses the initial steps of preparing data. Its specific purpose is that only the relevant and useful information underlying the data is retained, be it for its posterior analysis, to use as inputs to an AI or machine learning model, and so on. Unifying or converting data types, dealing with missing values, eliminating noisy values stemming from erroneous measurements, and removing duplicates are some examples of typical processes within the data cleaning stage. MDX/DAX [DAX Optimizer 1.2 – new features]( From Sqlbi Explore the new metrics introduced by DAX Optimize... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Data Lake Strategy: Its Benefits, Challenges, and Implementation]( From Dataversity In today’s hyper-competitive business environmen... [Microsoft Fabric: Resolving Capacity Admin Permission Issues in Automate Capacity Scaling with Azure LogicApps]( From BI Insight A while back, I published a blogpost explaining how to use Azure LogicApps to automate scaling Microsoft Fabric F capacities under the PAYG (Pay-As-You-Go) licensing option. Some of my... Oracle/PostgreSQL/MySQL/other RDBMS [Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024]( From Simple Talk This blog outlines why you should be coming to see... Performance Tuning SQL Server [Query Exercise Answers: Why Are These 3 Estimates So Wrong?]( From Brent Ozar Unlimited This week’s Query Exercise challenged you to fig... [Query Plan Patterns For Windowing Functions: Indexes And Memory]( From Erik Darling Data Query Plan Patterns For Windowing Functions: Index... PostgreSQL [Peter Morgan: A Kafka Compatible Broker With A PostgreSQL Storage Engine]( From Planet Postgres Tansu is an Apache Kafka API compatible broker wit... [Elizabeth Garrett Christensen: Window Functions for Data Analysis with Postgres]( From Planet Postgres SQL makes sense when it's working on a single row,... [Karen Jex: Optimising your Database for Analytics]( From Planet Postgres This post contains the slides and transcript from ... [Sven Klemm: Bridging the Gap Between Compressed and Uncompressed Data in Postgres: Introducing Compression Tuple Filtering]( From Planet Postgres When we introduced columnar compression for Postgr... [Andrew Atkinson: Trying out Solid Queue and Mission Control with PostgreSQL]( From Planet Postgres Why Solid Queue? Background jobs are used comm... [Florent Jardin: Hierarchical data types]( From Planet Postgres The SQL standard defines a set of rules so that da... [Umair Shahid: Transitioning from Oracle to PostgreSQL: Understanding the Concept of Schema]( From Planet Postgres As businesses increasingly move toward open-source... [Why Data Analysts Love PostgreSQL (and You Will Too!)]( From SQLServerCentral Blogs Data analysis is all about wrangling massive datas... [Jonathan Katz: Hybrid search with PostgreSQL and pgvector]( From Planet Postgres A key metric when evaluating vector similarity search algorithms is “recall” - which measures the relevancy of the returned search results. Typically better recall means better quality search results,... PowerPivot/PowerQuery/PowerBI [Connect to Power BI as a Guest User in another Tenant]( From SQLServerCentral Blogs Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when you’re a... The... [Power BI Quick Reference Guide]( From MSSQL Tips Check out this structured reference guide to just ... [(Livestream Replay) Practical Use Cases for DAX Calculated Columns - Tristan Malherbe]( From Havens Consulting DESCRIPTION Over the last few years, many deba... [Sync two slicers without bi-directional relationships in Power BI]( From Data – Marc Have you ever wanted to sync two slicers on a report page? Even when both slicers are coming from different dimensions? A lot of users end up setting the... Product Reviews and Articles [The Importance of Access Checks and Controls in Database Development]( From Product learning – Redgate Software This article illustrates the importance in any database development project of a 'multi-layered' approach to database access controls and security checks, based on the Principle of Least Privilege. It... [Monday Monitor Tips–Finding CUs for My Instance]( From SQLServerCentral Blogs How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every... The... Professional Development [Beyond the “IT Guy” Stereotype: How Technology Leaders Drive Business Success]( From Dataversity Traditionally, IT departments have been viewed as ... [Semperis’s Marty Momdjian on Handling Ransomware in Healthcare]( From Past News - RSS Feeds Hospitals are particularly vulnerable to ransomware attacks. Marty Momdjian, EVP and General Manager at Semperis, discussed how healthcare organizations can best handle the many difficult issues involved with ransomware.... [Guide To Navigating the Legal Perils After a Cyber Incident]( From IT Pro - Microsoft Windows Information, Solutions, Tools Jess Nall, a defense attorney specializing in info... Python [Text Cleaning and Preprocessing with Python for NLP Tasks]( From MSSQL Tips This tip introduces some basic text preprocessing ... Security News and Issues [Remotely Exploding Pagers]( From Schneier on Security Wow. It seems they all exploded simultaneously, wh... [Why Relying on IT Security Strategies Puts ICS Environments at Risk]( From IT Pro - Microsoft Windows Information, Solutions, Tools Despite heightened awareness, security maturity in... [Putting Threat Modeling into Practice: A Guide for Business Leaders]( From Dataversity Recognizing the value of threat modeling – a pro... [AI and Cybersecurity: The Dual Role of Automation in Threat Mitigation and Attack Facilitation]( From IT Pro - Microsoft Windows Information, Solutions, Tools AI is revolutionizing cybersecurity by enhancing t... [Python Developers Targeted with Malware During Fake Job Interviews]( From Schneier on Security Interesting social engineering attack: luring potential job applicants with fake recruiting pitches, trying to convince them to download malware. From a news article These particular attacks from North Korean state-funded... [Putting Threat Modeling Into Practice: A Guide for Business Leaders]( From IT Pro - Microsoft Windows Information, Solutions, Tools Threat modeling offers significant benefits such as improved time to market, reduced defects, and reusable security patterns, and is essential for compliance and enhancing overall security strategy. T-SQL and Query Languages [Auto Generate SQL Variable Syntax for Table Column Names]( From MSSQL Tips Check out this SQL Server stored procedure and fun... Tech News [Introducing Netflix’s Key-Value Data Abstraction Layer]( From Netflix TechBlog - Medium Vidhya Arvind, Rajasekhar Ummadisetty, Joey Lynch,... [CIOs: Get Tech Sprawl Under Control]( From IT Pro - Microsoft Windows Information, Solutions, Tools Find out what the impacts of tech sprawl can be an... [Java 23 Modernizes Open Source Language to Better Compete With Python, Rust]( From IT Pro - Microsoft Windows Information, Solutions, Tools The latest iteration of Java adds incremental preview capabilities as the open source programming language continues to modernize and improve. The Lighter Side [CodeSOD: String in your Colon]( From Daily WTF Anders sends us an example which isn't precisely a... [CodeSOD: A Managed Session]( From Daily WTF Some time ago, Roald started an internship on a AS... [Sus SQL]( From Andy Broadsword For this week’s short post I’ve been inspired ... Tools for Dev (SSMS, ADS, VS, etc.) [Video: Profiles in VS Code and Azure Data Studio]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, I show off a not-so-well-known capability in Visual Studio Code and Azure Data Studio: creating profiles. LINKS AND ADDITIONAL INFORMATION All of... Virtualization and Containers/Kubernetes [Recommended Codespace Configuration for Polyglot Notebooks]( In order to get Polyglot Notebooks to work with GitHub Codespaces, you’ll need to match the current requirements of the Polyglot Notebooks extension and its underlying .NET Interactive kernels. flyway [Flyway’s Repair Command Explained Simply]( The Repair command allows Flyway migrations to recommence on a database, following one or more validation errors. It modifies various details recorded in the schema history table, for applied migrations, to make them consistent with the data and metadata of the current set of Flyway migration files. This article explains what problems Repair can fix and how to run it safely, and a few alternative strategies.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -