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
 

Life's Little Frustrations

As with others, I've had to deal with death in the family recently. Some other family members are dealing with cancer (a few friends too). Happily none of us has recently been a disaster zone, but that's happened too. So yeah, big, nasty scary stuff happens in life.

However, for most of us, most of the time, it's the little frustrations we're dealing with the most. Not, OMG the car is on fire, but, low tire pressure.... again. Not, where are going to live with the house gone, but, AC is acting up so we need to call the repairman. Stuff like that.

My son and I spent a whole day working on putting together a retractable awning he wants to mount on his deck. It was a long, involved, confusing and frustrating process. However, we work really well together and were able to overcome every challenge. After getting it all put together, it was time to mount it. So we pulled out the mounting hardware that came with it. Start reading through a new set of documentation only to find that the kit only included bolts for mounting the awning to concrete. We needed to mount it to wood. At that point, we walked away.  Oh, we'll finish it. It's just the frustration had hit that point where it was too much. We weren't ready to run down to the hardware store, track down the right kinds of carriage bolts AND THEN go back up and do all the work to mount the awning. It's just going to wait a few days.

It's those little frustrations that seem the chew on us all the time. Nope. No big lesson from this one. Just the observation.

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.
AI/Machine Learning/Cognitive Services

Finding value with AI automation

From Technology Review Feed - Tech Review Top Stories

In June 2023, technology leaders and IT services e...

Delta Uses AI to Set Personalised Prices for Some Flights: Is It Ethical?

From Past News - RSS Feeds

Prices are based on Delta’s internal data, such as historical bookings, as well as external variables like weather and market trends. The post Delta Uses AI to Set Personalised Prices...

Netflix’s first show with generative AI is a sign of what’s to come in TV, film

From Ars Technica

The Eternaut debuted on Netflix with a generative AI-assisted scene.

Administration of SQL Server

Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide

From Simple Talk

Everything you need to know about Regular Expressi...

SQL Server Database Compatibility Levels

From SQLServerCentral Blogs

Why You Shouldn’t Overlook This Quiet but Critic...

How to Automatically Install SQL Server Service Packs and Cumulative Updates with Update-DbaInstance (dbatools)

From StraightPath Solutions SQL Blog

Keeping your SQL Server instance up to date with t...

Learn T-SQL With Erik: Grouping Sets vs Union All

From Erik Darling Data

Learn T-SQL With Erik: Grouping Sets vs Union All ...

Azure Databricks, Spark and Snowflake

Making Snowflake Flow Better: Cleaner Queries

From Sherpa of Data

In a recent Snowflake release, a slick new operato...

Azure SQL

Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.

From SQLServerCentral Blogs

I recently had to copy an Azure SQL database (SQL ...

Azure SQL Managed Instance

Azure SQL Managed Instance: Boost Performance with Read-Scale Out

From SQLServerCentral Blogs

The Business Critical tier of Azure SQL Managed In...

Understanding Zonal Redundancy in Azure SQL MI

From SQLServerCentral Blogs

Do you know what happens when you enable zonal red...

Cloud - AWS

AWS Free Tier update: New customers can get started and explore AWS with up to $200 in credits

From AWS News Blog

AWS is enhancing its Free Tier program with up to ...

Introducing Amazon S3 Vectors: First cloud storage with native vector support at scale (preview)

From AWS News Blog

Amazon S3 Vectors is a new cloud object store that...

Top announcements of the AWS Summit in New York, 2025

From AWS News Blog

Read about all the new launches, including Nova en...

Simplify serverless development with console to IDE and remote debugging for AWS Lambda

From AWS News Blog

Developers can now build serverless applications f...

AWS AI League: Learn, innovate, and compete in our new ultimate AI showdown

From AWS News Blog

AWS AI league is a program that helps organization...

Accelerate safe software releases with new built-in blue/green deployments in Amazon ECS

From AWS News Blog

Perform safer container application deployments wi...

AWS Summit NYC: Suite of Production-Ready AI Agent Tools Debut

From IT Pro - Microsoft Windows Information, Solutions, Tools

At its 2025 NYC Summit, AWS launches Amazon Bedroc...

Cloud - Azure

DP-203: The Complete Guide to Becoming a Microsoft Azure Data Engineer Associate

From SQLServerCentral Blogs

In today’s data-driven world, organizations rely...

Community Interests

How to Add Schema Markup to WordPress Sites (And Why You Should)

From https://chrisadkin.io

Curious how you can add review scores, pricing, FA...

The PASS Summit on Tour in the Netherlands

From SQLServerCentral Blogs

The PASS Summit goes on tour this year, with the f...

DMO/SMO/Powershell

Managing Windows Firewall Rules with PowerShell, Part 2: Overcoming Cmdlet Limitations

From IT Pro - Microsoft Windows Information, Solutions, Tools

In Part 2 of this series, discover how to extract ...

Data Mining / Data Analysis

ALLSELECTED best practices

From Sqlbi

Learn the best practices for ALLSELECTED to avoid ...

Partner perspectives: Succeeding with SAS

From AllAnalytics

At SAS Innovate in Orlando, some of our partners s...

Database Design, Theory and Development

How to Script Dimensions with data build tool (dbt) Macros

From Simple Talk

Learn how to script dimensions with data build too...

The Evolution of Data: From Databases to Spark to Lakebases

From SQLServerCentral Blogs

The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling their jeans or people with bellbottoms or the 80’s music playing in grocery stores… It’s... The...

DevOps and Continuous Delivery (CI/CD)

Shaping the future with adaptive production

From Technology Review Feed - Tech Review Top Stories

Adaptive production is more than a technological u...

GitHub abused to distribute payloads on behalf of malware-as-a-service

From Ars Technica

The repository offered the MaaS a distribution channel not blocked in many networks.

Flyway code analysis – These are a few of my favorite rules

From Blog – Redgate Software

Clean, consistent SQL code isn’t just a preferen...

Hardware

Edge Computing Trends: Adoption, Challenges, and Future Outlook

From IT Pro - Microsoft Windows Information, Solutions, Tools

This report shares insights on edge computing, gat...

Seagate’s massive, 30TB, $600 hard drives are now available for anyone to buy

From Ars Technica

Seagate's heat-assisted drive tech has been percol...

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

Why Microsoft Fabric Signals the Next Wave of Data Strategy

From SQLServerCentral Blogs

In today’s data-driven economy, organizations are no longer asking if they should invest in data, they are asking how fast they can turn data into decisions. The answer, increasingly,... The...

Oracle/MySQL/other RDBMS

PostgreSQL for the Oracle DBA, Part 6: Tuples, MVCC, and Two Views

From DBAKevlar

After our first two weeks of ensuring Grant and I ...

RavenDB & Distributed Debugging

From Ayende @ Rahien

TLDR: Check out the new Cluster Debug View announ...

PostgreSQL

Looking at PostgreSQL Internals with pg_visibility

From Curated SQL

Ian Parker introduces us to an extension: When mos...

Ajin Cherian: Detection and resolution of conflicts in PostgreSQL logical replication

From Planet Postgres

At this year’s PGConf.dev, the premier gathering...

Comparing Storage Options in PostgreSQL

From Curated SQL

Hans-Jürgen Schönig compares data sizes: In this...

PostgreSQL Timeline: History and Evolution

From SQLServerCentral Blogs

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community... The...

Practical PostgreSQL Schema Comparison with Redgate pgCompare

From Product learning – Redgate Software

Managing PostgreSQL schema changes across environm...

PowerPivot/PowerQuery/PowerBI

How to get the details for Power BI Performance load testing

From FourMoo

When completing the Power BI performance load test...

Create a Variance Line ONLY Between First and Last Values in Power BI

From Havens Consulting

Video by: Reid HavensWrap up the Power BI visual c...

Python

Incrementally Loading Data into Parquet with Python

From Simple Talk

In this article, we'll introduce the Parquet forma...

Security News and Issues

Report from the Cambridge Cybercrime Conference

From Schneier on Security

The Cambridge Cybercrime Conference was held on 23...

Military Veterans May Be What Cybersecurity Is Looking For

From IT Pro - Microsoft Windows Information, Solutions, Tools

As the field struggles with a shortage, programs t...

Hacking Trains

From Schneier on Security

Seems like an old system system that predates any ...

Inside the Ethical Hacker’s Mind: How Pros Make Split-Second Security Decisions

From O'Reilly Radar - Insight

When a cybercriminal finds a vulnerability, the ou...

Google finds custom backdoor being installed on SonicWall network devices

From Ars Technica

Overstep backdoor nukes key log entries, making de...

How to Fix a Hacked Website: A Step-by-Step Recovery Guide

From https://chrisadkin.io

How do you fix a hacked website? How can you tell ...

Security Vulnerabilities in ICEBlock

From Schneier on Security

The ICEBlock tool has vulnerabilities: The develop...

To Secure AI, Start Thinking Like an Attacker

From IT Pro - Microsoft Windows Information, Solutions, Tools

The rapid development of AI has created new demand...

Tech News

In defense of air-conditioning

From Technology Review Feed - Tech Review Top Stories

I’ll admit that I’ve rarely hesitated to point...

Fanfic study challenges leading cultural evolution theory

From Ars Technica

Fanfic community craves familiarity much more than...

Cocky cop jailed for stealing bitcoins had log of his crypto theft in his office

From Ars Technica

Silk Road criminal tipped police off to dirty cop ...

How Android phones became an earthquake warning system

From Ars Technica

The system uses phones' accelerometers to trigger warnings ahead of the shaking.

Dictionary.com “devastated” paid users by abruptly deleting saved words lists

From Ars Technica

Dictionary website isn't offering refunds and is now only available with ads.

After a partly successful test flight, European firm eyes space station mission

From Ars Technica

"One year ago, this was out of the discussion."

Local cuisine was on the menu at Cafe Neanderthal

From Ars Technica

We’re starting to find features that distinguish one Neanderthal culture from another.

The Lighter Side

Medieval preacher invoked chivalric hero as a meme in sermon

From Ars Technica

"This is very early evidence of a preacher weaving...

CodeSOD: Just a Few Updates

From Daily WTF

Misha has a co-worker who has unusual ideas about ...

Virtualization and Containers/Kubernetes

More VMware cloud partners axed as Broadcom launches new invite-only program

From Ars Technica

Smaller businesses most likely to be affected as w...

 
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

 

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