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
 

Feeling your age? How would you know?

As this idea is being born, I am sitting in a dueling piano bar and I have never felt so old ever. And I don’t mean physically. I have only recognized about 1/4 of the songs being played, and everyone just seems younger than me. Even the people I think are older seem younger as I watch them seemingly sing along.

Which led me to start writing and ask the question, "Do I really feel old? Is this just not my thing? And will I actually know what old feels like?" Is it loss of energy? Will I feel super wise? 

How will I know, when I feel older?

I think we all kind of know what old looks like. When I am sorting pictures from vacations and conferences and see the changes in my face...I know I am older. Pictures really highlight the years passing, no matter what you have done, and I have gained and lost a lot of weight through the years. (This is a large part of why I am more of a building/landscape photographer!) But what is age?

I often hear from many of my friends/family as they reach different milestone birthdays. "I feel/am so old." But what does this feel like? Feeling more tired? Will I start wanting to listen to string quartets playing Brahms instead of an Elvis Costello song? Maybe I will stop watching cartoons or riding roller coasters? In this TikTok video, a person is filming themselves and their 90 year old "grandma" riding a pretty intense (if short) roller coaster! We don't know what happened after this, so maybe she needed a nap or passed out after this (there was a lot of screaming involved!), but I have known 40 year old's who weren't taking on that challenge because they were too old. Is age even actually that involved?

Part of it for me is that I spent a lot of my life in really poor physical shape. I have lost quite a bit of weight in the past 10 years and while I have had plenty of orthopedic setbacks with broken bones and metal implants, I have more strength and energy now than 15 years ago. If anything I feel somewhat younger now than 10 years ago.

But what about in technology?

When working in technology, I have rarely felt that age played a large part in how people treated me, or how I see others, at least not in a direct manner. I work with some people who are physically older but more energetic than I have ever been. I also work with younger people who have a wisdom about them that I never really had. I always figured I would have more confidence as I aged, but it hasn't changed much over the years.

Probably the one way I feel old is that I see more and more that no one seems to learn anything. We all have to make the same mistakes over and over again. I have been writing about Database Design for 25 years now. And it isn't like it is just me. There are always people basically preaching about data quality. But it feels like everyone I talk to is always in a time loop with the same basic process; every inexperienced person basically has to fail for themselves before they learn.

Failure is a great teacher, but the more you see it as the primary way a lot of people learn (or even don't learn), I guess this is what actually makes me feel old. Like I have said the same things over and over and over and no one is listening.

The reality

If my dad was still around, he would be laugh so hard at that last statement, and would utter the words that every parent says to their children eventually. "I told you so." And unlike when I was younger, this time I wouldn't take it as an insult.

 

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

Creating Custom Regex Rules for Code Analysis in Flyway

Every development team has its own coding standards. While Flyway provides built-in rules focused on security and data protection, teams quickly find they need additional checks to maintain SQL code quality and consistency across their projects. This article will walk through the ways of defining and testing custom rules, provides a starter pack of custom rules for common code smells, and then explains how to manage your rules efficiently as your rule library grows.

Redgate Software recognized as a Strong Performer in the 2024 Gartner® Peer Insights™ Voice of the Customer for Integrated Development Environment Software

We’re excited to announce that Redgate Software has been named a Strong Performer in the 2024 Gartner® Peer Insights™ Voice of the Customer for Integrated Development Environment Software. We’re proud of this recognition from our customers as it reflects one of our core values: “When our customers succeed, so do we”.

Administration of SQL Server

Checking Who Created a Table in SQL Server

From Curated SQL

Burt King reviews the logs: I have noticed new SQL Server database objects have been created and want to know how we can track down…

SQL Server Source Control on a $0 Budget

From DallasDBAs.com

The Source Control Dilemma Every DBA has been ther...

Distributed Availability Group Dashboard

From SQL Undercover

The Distributed Availability Group Dashboard can b...

Azure Databricks, Spark and Snowflake

Implementing Enterprise Data Security in Snowflake: Practical Concepts

As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed firsthand how challenging it can be to architect a robust security framework that balances protection with accessibility. Whether you’re dealing with regulatory compliance requirements, implementing multi-tenant data solutions, or simply trying to ensure proper data access controls, the journey can seem daunting at first. In this practical guide, we’ll explore techniques to help you secure your use of Snowflake.

Database Design, Theory and Development

Data Quality: The Foundation for Business Agility and Growth

From Simple Talk

We live in a world awash with vast amounts of data...

Domains in ANSI SQL

From Curated SQL

Joe Celko describes a domain in SQL and the pros and cons of how they have been implemented.

DocumentDB/Key-Value/Graph/other NoSQL Databases

Importing and exporting data in MongoDB Compass

When working with MongoDB, you’ll likely need to import or export document data from time-to-time. You can use MongoDB Compass for both types of operations, working with either the JavaScript Object Notation (JSON) format or the comma-separated values (CSV) format.

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

Two Takeaways from FabCon 2025

From Prologika (Teo Lachev's Weblog)

The 2025 Fabric Community conference has just conc...

Fabric Database: Advanced Vector Search Features

From Simple Talk

A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about some advanced features available in both of them. Before...

Understanding Lakehouse Permissions in Microsoft Fabric

From Joyful Craftsmen – The Business Intelligence Agency

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access to Lakehouses, SQL Endpoints, or Semantic Models.

Performance Tuning SQL Server

Strange Query Plans With Inequality Predicates In SQL Server

From Erik Darling Data

Strange Query Plans With Inequality Predicates In ...

How Do You Pick Events in Extended Events?

From Scary DBA (Grant Fritchey)

A while back I wrote about using AI to explore why...

All About SQL Server Stored Procedures: Dynamic SQL For Performance

From Erik Darling Data

All About SQL Server Stored Procedures: Dynamic SQL For Performance Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training....

PostgreSQL

B-Tree Indexes in PostgreSQL vs SQL Server

From Curated SQL

Lukas Fittl compares and contrasts: When it comes to optimizing query performance, indexing is one of the most powerful tools available to database engineers. Both…

Semantic Search in PostgreSQL

From Curated SQL

Hans-Jürgen Schönig performs a search: PostgreSQL offers advanced capabilities through extensions like pgvector, which enable semantic search at a level and quality never achieved before.…

Dave Stokes: Saving The Output From psql

From Planet Postgres

Occasionally, you will need to capture data from your queries, in this article Dave Stokes shows you haw to do this from psql

PowerPivot/PowerQuery/PowerBI

DAX and semantic models announcements at the Fabric Conference 2025

From Sqlbi

I usually do not write about announcements and new...

Finding Mismatched Rows in Power Query

From Curated SQL

Reza Rad looks for that other sock: Finding rows that are in one table, but not the other is one of the most common scenarios…

Professional Development

Focus on Core Skills

From SQLServerCentral Blogs

Core skills depends on the position, but the point...

Improving Our Conversations

From SQLServerCentral Blogs

If we aren't having the same conversation, we aren...

Python

The Power of Virtual Environments in Python

From Curated SQL

I have a new video: In this video, I explain why virtual environments are such an important concept in Python and why you should generally…

SQL Server News

What’s New in SQL Server 2025

From Brent Ozar Unlimited

This year’s release of Microsoft’s enterprise-...

SQL Server Security and Auditing

SQL Server Linked Servers Should Never Use An Account With Sysadmin Rights

From DCAC

When setting up linked servers, the selection of t...

T-SQL and Query Languages

Calculating a Matrix Inversion in SQL Server

From Curated SQL

Sebastiao Pereira performs matrix math in-database: There are numerous applications to obtain a Matrix inverse for a given Matrix. Is it possible to do it…

Things I Wish Inline Table Valued Functions Helped With In SQL Server

From Erik Darling Data

Things I Wish Inline Table Valued Functions Helped...

The Lighter Side

Explaining MicroSD Express cards and why you should care about them

From Ars Technica

Little-used 2019 standard bridges a gap between internal and external storage.

Web

Web Browser Security: Evolving Threats, Safeguards, and the Road Ahead

Web browsers are essential for navigating the Internet, serving as gateways to online information, services, and applications. However, their ubiquity and complexity make them prime targets for cyberattacks, ranging from malware infections to sophisticated zero-day vulnerabilities.

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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