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
 

Learn From History

I've just spent a week in the UK visiting the Redgate HQ with my fellow advocates. I'm really blessed to get to work with such a great bunch of people. A couple of the conversations we had stuck with me and I'd like to share them here.

Sitting in the midst of Cambridge, Cambridgeshire, UK, history is inevitably on your  mind. After all, the first bridge across the Cam there was Roman. The University is just a little shy of 900 years old. The colleges, churches (including one with the Washington family crest), and other buildings feel literally old. Now, we weren't discussing actual history. We talked about the history of data platforms. Lots of jokes cracked about the dead platforms that many of us had worked on, our own history with Oracle, PostgreSQL and SQL Server. Where those platforms have come from and are headed. It's fascinating because they've all evolved quite a lot over the years. New functionality, whole new ways of dealing with old problems, even the complete elimination of old problems through new technology. A lot has happened to all these platforms over the last 20-30 years.

So, that was one conversation.

Another conversation we had was about you. OK, maybe not you, the person in particular currently reading this, but you, our peers, our customers, the people we help out and the people we learn from. To a degree, and yes, there's a lot more subtlety to this than I'm going to use here, you all kind of break down into two camps. The smaller camp is the one that's curious. How do things works? How do I apply them? Can I put this new technique to work? Does it apply to me? Even if I reject it, I understand it, and I'm making an informed choice. The larger camp, I'm sorry to say, isn't all that curious. They've put in a year, 18 months, maybe even two years, learning their data platform. And then, they've repeated that same year, over and over. You'll see these people all the time. They've got 10 maybe 20 years of experience... on paper. In reality though, it's one year of experience multiplied 20 times.

I'm going to ask you straight up. Which camp do you think you're in?

If you're in that second, larger camp, I want to encourage you to first, see that. Then, do something about it. I'm going to continue to be blunt. You know who is literally scared that AI is going to replace them? The people who haven't been learning. The people who don't see that, while history doesn't repeat, it sure does rhyme really good. They've seen technologies come and go. They've learned them, then learned more, then dug in as necessary. Yeah, they've discarded, or been discarded, technologies and techniques. They've got 5, 10, 20, more, years of true growth where they've learned from history. They're not scared of AI, the cloud, Extended Events, PostgreSQL, or anything else. Why? Because they've learned from history. Yeah, sure, a lot of that is their own history, sure. However, if you're the one that's been sitting on that one year of experience and stacking it on top of the exact same year of experience, doing stuff because, and man I hate this phrase, WE'VE ALWAYS DONE IT THIS WAY, then yeah, maybe, just maybe, you should be a little afraid of , cause yeah, it's likely to kick you to the curb.

However, you don't have to let it. Learn from history. Get out there and ride the waves. See the rhythm. See the patterns. See the rhyming and take advantage of it. I'm not saying it's easy. It's not. It's actually pretty hard. However, building that knowledge, those skills, that understanding, that's what's going to allow you to have long, storied, career. Learn from history.

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 in the Database

Generative AI in the Real World: AI for Real Estate with Ben Miller

From O'Reilly Radar - Insight

A typical apartment building generates data on eve...

AI/Machine Learning/Cognitive Services

Don’t Fight with AI

From SQLServerCentral Blogs

I was recently trying to handle a simple task with...

AI professors are negotiating the new realities of academic research

From Technology Review Feed - Tech Review Top Stories

This story originally appeared in The Algorithm, o...

AI Can Perform the Work, But Who Owns the Decision?

From Past News - RSS Feeds

As AI takes on more accounting tasks, finance team...

Ford Rolls Out AI Assistant That Knows Your Vehicle’s Fuel, Tire Pressure and More

From Past News - RSS Feeds

Ford is expanding an AI assistant that uses vehicl...

Separating AI’s Technological Problems from Its Capitalism Problems

From Schneier on Security

This essay was written with Nathan E. Sanders, and originally appeared in Tech Policy Press. AI represents the first time we humans can do cognitive work outside of our bodies...

Why enterprise AI isn’t a model problem anymore

From AllAnalytics

Organizations rarely struggle to build AI models. They struggle to scale them. Across industries, organizations continue to invest heavily in data and AI, yet many initiatives never move beyond...

Prompt Debt and “Fighting the Weights”

From O'Reilly Radar - Insight

Drew Breunig is one of the smartest voices writing...

Claude Cowork Comes to Chrome, Letting AI Work Across Browser Sessions

From Past News - RSS Feeds

Anthropic is bringing Claude Cowork to Chrome, add...

Administration of SQL Server

msdb attack paths: how to secure SQL Server Agent, triggers, and restores

From Simple Talk

Learn how msdb, SQL Server Agent jobs, triggers, a...

Curse of the Catch-All query

From DualCoreDBA

The catch-all query – a fairly common pattern th...

When Do You Reach For A #temp Table?

From SQLServerCentral Blogs

I needed to do some research because there is more...

Temp Tables: Foe When It's a Reflex, Friend When It's a Decision

From SQLFingers

This month Jeff Taylor is hosting T-SQL Tuesday #2...

T-SQL Tuesday #201 – Temp Tables: Friend or Foe?

From Deb the DBA

It’s another T-SQL Tuesday! Thanks to Jeff Taylo...

Excellent article on securing msdb

From SQLServerCentral Blogs

Fabiano Amorim has written an excellent article at...

T-SQL Tuesday #201 – Temp Data

From Callihan Data

This month for T-SQL Tuesday, Jeff Taylor asks us ...

T-SQL Tuesday #201 – Temp Tables, Friend, Foe, None, or All of the Above?

From Dr SQL

This month’s T-SQL Tuesday invitation from Jeff ...

T-SQL Tuesday #201 - Temp Tables, Friend or Foe?

From FLX SQL

T-SQL Tuesday is a monthly blog party hosted by a ...

T-SQL Tuesday #201 - Temp Tables, Friend or Foe?

From SQLServerCentral Blogs

T-SQL Tuesday is a monthly blog party hosted by a ...

Learn T-SQL With Erik: DATEDIFF Precision

From Erik Darling Data

Learn T-SQL With Erik: DATEDIFF Precision Chapters...

Database Animations: Why Higher Maxdop Equals More TempDB Spills

From Brent Ozar Unlimited

You’ve probably heard of the setting Max Degree of Parallelism. I hate that name: it should really be called just plain ol’ Degrees of Parallelism, and here’s why. There...

Why Use TRY_PARSE(): #SQLNewBlogger

From SQLServerCentral Blogs

Someone asked why I would use TRY_PARSE after I po...

Brent and I Wrote About Temp Tables Yesterday. We Found Different Things.

From SQLFingers

Brent Ozar and I both published temp table posts y...

How to Run Essential Diagnostic Queries in SQL Server for August 2026

From Glenn Berry

Introduction Here are my Diagnostic Information Queries for August 2026 focused on SQL Server. They let you view configuration and performance comprehensively in a short time. This post discusses...

Demo for Parameter Sniffing and Memory Grant Feedback

From SQLServerCentral Blogs

Disclaimer: The following is built with Claude Cod...

Learn T-SQL With Erik: Performance Solutions For DATEDIFF Queries

From Erik Darling Data

Learn T-SQL With Erik: Performance Solutions For D...

Simplest way to make a query faster

From Dr SQL

This week, I want to sell you on two ideas. First,...

 
Analysis Services / BI on the MS Stack

Constructing orthogonal vectors in SAS

From AllAnalytics

One of the great algorithms of linear algebra is t...

Career, Employment, and Certifications

Accept the no and move on

From SQLServerCentral Blogs

Here is a short emotional intelligence (EI) post f...

Beyond gout: what high uric acid can mean for your health

From AllAnalytics

Gout has become common enough that most of us know what it is—or at least know someone who has dealt with it. But while gout gets most of the...

My Social Media Rules

From SQLServerCentral Blogs

I developed these rules a while back, before COVID...

Why “It Depends” Is the Most Future-Proof Phrase in Software

From O'Reilly Radar - Insight

Ask an architect almost any question and you’ll ...

The Two Pillars of Post-training: Reinforcement Learning and Supervised Fine-Tuning

From O'Reilly Radar - Insight

This is the second article in Sharon Zhou’s post...

“Where are my patches?!?!”

From Connor McDonald

Anyone that follows me on the socials knows that I...

Tech Conferences Are Worth It. The Sessions Are Not.

From Journey to SQL Authority with Pinal Dave

Tech conferences are worth every hour I have ever ...

Cloud - AWS

AWS Weekly Roundup: AWS Heroes Summit, Web Search on Amazon Bedrock, Dogwood, Kiro Crew, and more (August 10, 2026)

From AWS News Blog

Last week, we brought together AWS Heroes from aro...

Community Interests

Reflections on 15 Years

From In Recovery...

(This was the editorial for my 300th SQLskills Ins...

The full story of PASS Data Community Summit: 25 years of connect, share, and learn

From Simple Talk

PASS Data Community Summit turns 25: from a 1999 M...

Mark Wong: PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema

From Planet Postgres

Please note different time and location this month at UpStart Collective at the U.S. Bancorp Tower (a.k.a. Big Pink). Please RSVP on MeetUp. Tuesday September 8, 2026 from 6:30pm...

What to See at WordCamp US 2026: Speakers, Demos, and More

From https://chrisadkin.io

WordCamp US 2026 is coming to Phoenix for the firs...

Data Mining / Data Analysis

Zero to Agent in 30 Minutes: Build a YouTube Analytics Agent with Vicki Reyzelman

From O'Reilly Radar - Insight

On the most recent episode of Zero to Agent in 30 ...

apply color thoughtfully in your graphs

From Storytelling with Data

Read a step-by-step guide to using color intention...

MDX/DAX

Creating DAX functions with AI to remove duplicated code

From Sqlbi

Code written by AI can contain many duplicate part...

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

Five Ways to Get Data from Fabric Semantic Models in Excel

From Prologika (Teo Lachev's Weblog)

Ask a business user where they want to work with t...

PostgreSQL

Wellingtone Luvonga: Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO

From Planet Postgres

You have probably read a dozen tutorials on settin...

Christophe Pettus: All Your GUCs in a Row: integer_datetimes

From Planet Postgres

Every PostgreSQL connection since 8.0 has heard th...

Regina Obe: PostGIS 3.7.0beta2

From Planet Postgres

The PostGIS Team is pleased to release PostGIS 3.7...

Umair Shahid: Choosing the Right PostgreSQL Partition Key

From Planet Postgres

Partitioning gets sold as a performance switch. Yo...

Popping the Hood on Postgres Plan Caching

From DBA Unfiltered

Talk Is Cheap In my last post, I talked about how ...

Setting up the Stack Overflow database in Postgres

From DualCoreDBA

I’ve worked with Microsoft SQL Server for many y...

Dimitri Fontaine: Introducing sqlfmt: an SQL gofmt-style formatter

From Planet Postgres

Formatting SQL tends to bring some of the same que...

Tudor Golubenco: Multi-tenant BYOK encryption in PostgreSQL with pgcrypto

From Planet Postgres

Implement multi-tenant BYOK column encryption in P...

Christophe Pettus: All Your GUCs in a Row: IntervalStyle

From Planet Postgres

IntervalStyle changes how PostgreSQL parses interv...

Christophe Pettus: All Your GUCs in a Row: io_combine_limit and io_max_combine_limit

From Planet Postgres

PostgreSQL 17 introduced read streams that combine...

Jeremy Schneider: Postgres Checkpoint Followup and Collation Visualization and Codex Luna

From Planet Postgres

My previous article talked about the checkpoint happiness hint: You probably should not change the checkpoint_timeout setting from its default of 5 minutes. Checkpoint Followup Questions A...

Ryan Booz: Postgres in Production Special Series: Diagnosing High Cardinality Workloads in pg_stat_statements (Part 6)

From Planet Postgres

In Part 6 of this special Postgres in Production deep dive series, Ryan Booz asks a question that determines how useful pg_stat_statements can be for you at all: do...

Christophe Pettus: All Your GUCs in a Row: io_max_concurrency

From Planet Postgres

PostgreSQL 18's new io_max_concurrency caps per-process I/O operations in flight.

Bertrand Drouvot: Welcome to pg_walviz: PostgreSQL WAL segment visualizer

From Planet Postgres

Introduction The purpose of this blog post is to introduce pg_walviz, a new tool to visualize PostgreSQL WAL segment files. pg_waldump is very useful to display a...

Christophe Pettus: All Your GUCs in a Row: io_method and io_workers

From Planet Postgres

Choose your I/O execution engine with `io_method` and size the worker pool with `io_workers`—and yes, you can resize workers without restarting.

PowerPivot/PowerQuery/PowerBI

Using Detail Rows Expressions To Drill To A Different Fact Table In Power BI

From Chris Webb's BI Blog

If you have a DirectQuery fact table in Power BI y...

Restoring alternating rows in Power BI matrices with Fluent 2

From Sqlbi

Microsoft recently introduced a new default visual...

How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot 

From Simple Talk

Learn how Microsoft's Power BI Desktop Bridge and Fabric AI Skills let GitHub Copilot edit and hot-reload Power BI reports. No restart needed!… The post How to use the Power...

Python

Python Now Has a Post-Quantum Encryption Library

From Schneier on Security

This is good: Post-quantum cryptography is now one...

Python your way: 6 ways to run Python in SAS Viya

From AllAnalytics

Want the flexibility of modern Python development with the power of SAS behind it? Explore how SAS Viya Workbench combines familiar tools, on-demand compute, and Python-native access to advanced...

Security News and Issues

Prompt Injections for Defense

From Schneier on Security

This seems to work: Researchers from Tracebit on Monday said they found that placing prompt injections alongside passwords, cryptographic keys, and other secrets stored on Amazon Web Services was often...

Flock is tightening its rules in response to a growing surveillance backlash

From Technology Review Feed - Tech Review Top Stories

The police-tech giant Flock is announcing today that it will change officers’ access to its nationwide network of license plate readers, in an apparent effort to quell a growing...

Building a practical path to post-quantum cryptography

From Technology Review Feed - Tech Review Top Stories

Quantum computing has alternated between breakthrough darling and overhyped promise in technology circles. Its powerful new capabilities come with a threat to break current cryptography, but for business leaders...

AI Surveillance in Australia: Police Scanned 130,000 Faces in One Week

From Past News - RSS Feeds

Australian police scanned 130,000 faces in one wee...

Tech News

Google WeatherNext Predicts Cyclones More Than a Day Earlier

From Past News - RSS Feeds

Google DeepMind says WeatherNext Cyclones improves...

ALLEX’s Power-Drill Test Reveals How Far Humanoid Robots Still Have to Go

From Past News - RSS Feeds

WIRobotics’ ALLEX humanoid operated a power dril...

KIT Robot Adapts Mid-Task to Disassemble Broken Machines

From Past News - RSS Feeds

KIT’s robotic disassembly system can detect stuc...

China’s New Robot 6S Store Lets Shoppers Test, Lease and Customize Robots

From Past News - RSS Feeds

Qingdao has opened a robot 6S experience store whe...

Unreleased Claude Model Makes Breakthrough on 167-Year-Old Math Problem

From Past News - RSS Feeds

Anthropic says an unreleased Claude model produced...

Scientists just created female clones of male mice

From Technology Review Feed - Tech Review Top Stories

Scientists have deliberately turned male mouse embryos into females for the first time. A team based in Japan used a CRISPR-based approach to remove the Y chromosome from male...

Tesla Builds Starlink Into Cybercab — Why Robotaxis Need Satellite Internet

From Past News - RSS Feeds

Tesla has built Starlink into Cybercab to give its...

Meet R-Dog, the Robot Dog That Climbs Stairs With Packages

From Past News - RSS Feeds

R-Dog is a dog-inspired quadruped built to climb s...

Roundtables: Inside the “Censorship-Industrial Complex” Idea Shaping US Policy

From Technology Review Feed - Tech Review Top Stories

Listen to the session or watch below The “censorship-industrial complex” is an idea that a network of government, tech, and research groups is collaborating to suppress conservative online speech....

The Lighter Side

A Guatemalan's Guide to Drinking Coffee Properly

From SQLServerCentral Blogs

My mugI grew up surrounded by coffee farms in Guat...

CodeSOD: Never Eating the Cookie

From Daily WTF

Maciej works as a freelancer, and that frequently means picking up old PHP code that nobody wants to support. One project had been lingering for ages with key features missing....

 
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

 

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