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
 

Personal Contact Is Vital

I'm writing this while in hiding at the PASS Data Community Summit that's taking place in Seattle this week. I just had a real surprise, finding out that DocumentDB is PostgreSQL under the covers and always has been. However, as much as I enjoy talking PostgreSQL, for the moment, I'll shut up about it. Instead, I'd like to take some time and share a couple of lessons I had this week that have reminded me just how important direct, personal, contact between humans really is.

I'm not speaking for anyone but myself when I say, it's easy to lose sight of how important creating, and then maintaining, direct communication with other people is. I screwed up this year and I didn't reach out to a few people who I absolutely should have been in contact with. Either, I just wasn't paying attention, or I thought other people would do it. Regardless of the excuse, I dropped the ball. I didn't talk to them through any of the mediums I had available. Because of it, frankly, we're missing a few voices this year. That's my fault. I'll own it.

Don't worry, this isn't all Debbie Downer talk.

I also, just a couple of minutes ago, had a great moment. Wonderful in fact. I was hanging out at the PostgreSQL Community booth (hey, it's fair within the rules, I'm talking about the community, not the data platform). I had someone walk up and thank me, because years ago, I gave them a little advice during a session. It was almost a throwaway line, but it resonated and they've been applying it for years to great success. It gave me such a warm and fuzzy, I just had to share.

I know a lot of you are like me, introverts. Please, don't lose sight of keeping in touch with the people around you. I know it's not easy, but it's so important. I just had my positive and negative reminders. Get out there, make your reminders all positive ones.

And in case anyone wants to know, the advice was simple. Before you get into all the complexities of query tuning, try just getting a WHERE clause in there to filter the data you're dealing with. That's it. Simple, but evidently effective.

Grant Fritchey

Join the debate, and respond to the editorial on the forums

 
Ad for State of Database Landscape survey
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

Countering a Brutal Job Market with AI

From O'Reilly Radar - Insight

Headlines surfaced by a simple “job market” se...

Realizing value with AI inference at scale and in production

From Technology Review Feed - Tech Review Top Stories

Training an AI model to predict equipment failures...

Building the Foundations for AI Readiness

From Blog – Redgate Software

Everyone wants to move faster with AI, but few are truly ready for it. This is where organizations can position themselves better as AI readiness isn’t just about algorithms,...

SQL Prompt AI Versus Smart Quotes

From Product learning – Redgate Software

SQL Prompt AI can repair certain types of broken SQL almost instantly, saving hours of clean-up time. Just prompt it clearly, check the results are exactly what you intended,...

Scaling innovation in manufacturing with AI

From Technology Review Feed - Tech Review Top Stories

Manufacturing is getting a major system upgrade. As AI amplifies existing technologies—like digital twins, the cloud, edge computing, and the industrial internet of things (IIoT)—it is enabling factory operations...

The AI paradox: A path to success – and failure

From AllAnalytics

Discover how to establish a foundation for success with AI in insurance. The post The AI paradox: A path to success – and failure appeared first on SAS Blogs.

Designing digital resilience in the agentic AI era

From Technology Review Feed - Tech Review Top Stories

Digital resilience—the ability to prevent, withstand, and recover from digital disruptions—has long been a strategic priority for enterprises. With the rise of agentic AI, the urgency for robust resilience...

Administration of SQL Server

Github Copilot in SSMS can include data in its memory, simple prompt injections ahead

From AgileSQL - Ed Elliot

SQL Server Management Studio (SSMS) has recently a...

Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe

From Born SQL

 

The Roundup for T-SQL Tuesday #192

From SQLServerCentral Blogs

Last week I asked you to write about SQL Server 20...

Writing Better Dynamic SQL

From SQLServerCentral Blogs

Writing Better Dynamic SQL This updated and "sort"...

SQL Server 2025 is GA

From Callihan Data

As many expected, Microsoft kicked off their Microsoft Ignite conference today by announcing that SQL Server 2025 is now generally available with new features like built-in regex, AI capabilities,...

AI, Crazy Quoted Identifiers, and comparing column names between tables

From Dr SQL

As I was working on another problem the other day, I had the need to compare two tables that had been created and modified by AI. I created fairly...

How to Monitor and Optimize Batched Deletion Processes in SQL Server

From Simple Talk

Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log...

Finding the Last Last Name in SQL: #SQLNewBlogger

From SQLServerCentral Blogs

I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting... The...

Understanding SQL Server’s Dedicated Admin Connection (DAC)

From Andy Broadsword

Slow queries are one thing, but under heavy pressu...

Awesome Use of RegEx in SQL Server – Multiple Filters

From Dr SQL

Since Microsoft Ignite and PASS Summit is this week, I figured a quick RegEx post was in order. I will be shocked if SQL Server 2025 is not released...

SQL Server Reliability: Clearing the Fuzzy Thinking

From DallasDBAs.com

The terminology around reliability is a mess If you’ve ever said, “We’re covered, it’s replicated,” you’re in good company.   SQL Server is a massive, 35+ year-old product that...

Ad for State of Database Landscape survey
Cloud - AWS

Streamlined multi-tenant application development with tenant isolation mode in AWS Lambda

From AWS News Blog

AWS Lambda introduces tenant isolation mode, enabling separate execution environments for each tenant within a single function to meet strict security requirements without managing dedicated per-tenant infrastructure.

Community Interests

PASS Data Community Summit 2025 Slides and Code

From FLX SQL

Thank you for attending my PASS Summit 2025 sessio...

Computing in the Cloud (Azure, Google, AWS)

Pavlo Golub: Google Summer of Code 2025 - A Journey of Growth and Achievement!

From Planet Postgres

What a journey! I’m very happy to announce that ...

Google’s new Gemini 3 “vibe-codes” responses and comes with its own agent

From Technology Review Feed - Tech Review Top Stories

Google today unveiled Gemini 3, a major upgrade to...

Data Mining / Data Analysis

Quasi-Monte Carlo integration in SAS

From AllAnalytics

It is difficult to evaluate high-dimensional integ...

Building modern marketing journeys

From AllAnalytics

This is the fourth in a five-part blog post series...

The Trillion Dollar Problem

From O'Reilly Radar - Insight

Picture this: You’re a data analyst on day one a...

Data Privacy, Compliance, and Governance

Five Ways to Simplify Data Masking

From Product learning – Redgate Software

How do we protect sensitive data and still get realistic test databases without creating a masking process that is slow, brittle, or impossible to maintain? This article sets out...

Database Design, Theory and Development

Natural Language SQL: Talk to Your Data Like It’s 1999

From Sherpa of Data

You’ve been there. It’s late. You’re staring...

A Simple, Reliable Integration Between Redgate Monitor and ServiceNow

From Blog – Redgate Software

Redgate Monitor v14.1.0 now provides a simple, built-in integration with ServiceNow that uses its REST API directly. This replaces the older webhook-based approach and removes much of the setup...

MDX/DAX

Linking Queries Run From DAX Studio To Workspace Monitoring And The Capacity Metrics App

From Chris Webb's BI Blog

A few weeks ago I wrote a blog post about how you ...

Model dependent and model independent user defined functions in DAX

From Sqlbi

Differences between model-dependent and model-inde...

Model-dependent and model-independent user-defined functions in DAX

From Sqlbi

This article explains the distinction between mode...

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

FabCon Vienna 2025 Recap

From Data on Wheels (Steve Hughes)

Holy cow FabCon Vienna was incredible! This recap ...

Oracle/MySQL/other RDBMS

How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles and H3 Indexes (Part 2)

From Simple Talk

Discover how to build ultra-fast mapping applicati...

PostgreSQL

Jimmy Angelakos: Announcing the inaugural PostgreSQL Edinburgh meetup

From Planet Postgres

The beautiful Old College building at the University of Edinburgh. Photo by LWYang from USA (CC BY 2.0). I'm thrilled to announce that the PostgreSQL Edinburgh meetup is...

Robert Bernier: Performing Standby Datacentre Promotions of a Patroni Cluster

From Planet Postgres

Unlike the standard multi-node Postgres replication cluster, when managed by Patroni, all failovers are automatically executed. However, this is not the case when dealing with inter-datacentre failovers when for...

Cornelia Biacsics: Contributions for week 46, 2025

From Planet Postgres

Berlin PostgreSQL Meetup on Thursday, November 13 ...

Jeremy Schneider: KubeCon 2025: Bookmarks on Memory and Postgres

From Planet Postgres

Just got home from KubeCon. One of my big goal...

Umair Shahid: PostgreSQL License: Free to Use, Enterprise-Ready, and Cost-Efficient in Production

From Planet Postgres

Do you need a PostgreSQL license for critical prod...

Stefan Fercot: pgBackRest TLS server mode for a primary-standby setup with a repository host

From Planet Postgres

The TLS server provides an alternative to using SS...

Bruce Momjian: Third Place

From Planet Postgres

I recently watched a video about Starbucks and how...

Hans-Juergen Schoenig: Storing products, prices and orders in PostgreSQL

From Planet Postgres

When creating data models in PostgreSQL (or any ot...

Mayur B.: Why Application Developers Using AI Is Great For DBA Job Security

From Planet Postgres

Everyone’s freaking out about AI taking their jo...

Ahsan Hadi: Postgres 18: Skip Scan -Breaking Free from the Left-Most Index Limitation

From Planet Postgres

Postgres 18, released on September 25, 2025, intro...

PowerPivot/PowerQuery/PowerBI

Power BI PBIR Format Admin Setting

From SQLServerCentral Blogs

The Power BI Enhanced Report Format (PBIR) will so...

The Power BI modeling MCP server in plain English

From SQLGene – Learning SQL Slowly

Microsoft has released a Power BI modeling MCP server. The responses have ranged from “This is awesome!” to “I have no idea what any of this means”. So, in...

How to Access a Former Employee’s Power BI “My Workspace” and Recover Reports

From FourMoo

One of the common challenges I’ve seen in organizations is when a team member leaves and their Power BI reports are stored in their personal My Workspace. These reports...

Bind A Power BI Thin Report To A Local Model

From eHansalytics

It isn’t terribly difficult to rebind a thin report to another model in the Power BI service. I’ll let you ask your favorite LLM how to do that. When...

Professional Development

Feedly Friday – Feeds I Read #13

From Dr SQL

Feeds I Read Page | Other Feedly Friday Posts Welc...

The database professional of the future: headlines from Redgate’s Keynote at PASS Data Community Summit 2025

From Blog – Redgate Software

Redgate took the main stage earlier today to open PASS Data Community Summit with our keynote, where we shared our vision for the future of the database development experience...

Managing subscribers, creating newsletters

From Data on Wheels (Steve Hughes)

When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous...

Security News and Issues

Scam USPS and E-Z Pass Texts and Websites

From Schneier on Security

Google has filed a complaint in court that details the scam: In a complaint filed Wednesday, the tech giant accused “a cybercriminal group in China” of selling “phishing for dummies”...

Software Development

How Does Open Source Make WordPress Different (And Better)?

From https://chrisadkin.io

Open source is the reason WordPress is the way it is — flexible, customizable, and fully yours. This guide breaks down what that actually means and how it compares...

The Lighter Side

Using an ADE: Ancient Development Environment

From Daily WTF

One of the things that makes legacy code legacy is...

CodeSOD: Invalid Route and Invalid Route

From Daily WTF

Someone wanted to make sure that invalid routes logged an error in their Go web application. Artem found this when looking at production code. if (requestUriPath != "/config:system") && ...

 
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

 

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