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 FeedTwitter
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

 

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