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
 

Why End-User Testing Is Even More Important with AI

I don’t think I’m alone in this frustration, but it crystallized for me recently while trying to do something that should have taken less than two minutes: check in for a flight.

What followed was a cascade of app switching and authentication failures. I started in my favorite travel app, moved to one airline app, then another because it was a partner flight. When those failed, I tried both airlines through web browsers where MFA codes timed out,   and sessions repeatedly expired mid-redirect. One login succeeded but couldn’t retrieve the reservation. Another recognized the booking but couldn’t complete the check-in because it originated with a partner carrier. What should have been a simple confirmation and boarding pass download required multiple attempts across five different interfaces.

This wasn’t an outlier for me, but the most recent example.

Mobile is Essential

Increasingly, mobile applications, especially those in the U.S. market, (and I travel enough internationally, using local apps on my travels to make this claim) are struggling to perform their most basic, core functionality. Logging in, completing a transaction, submitting required information or maybe just to retrieve a application document. These are not edge cases, but reasons the apps came to exist in the first place.

From a technical standpoint, this isn’t about engineers not doing their jobs, but misplaced priorities around testing and I question if it really should be their job. Somewhere between aggressive release cycles, roadmaps, competitive pressure, and the rush to embed AI into everything, rigorous end-user testing of real-world workflows has slipped down the stack.

This isn’t about QA scripts or simulated happy paths. This is about real usage and on real devices and on unstable networks with expired sessions and MFA timing windows which is how it often is with mobile devices. These are the exact conditions under which actual customers operate every day.

Instead, what many users experience now is what I can only describe as “feature disfunction.” AI assistants layered onto dashboards, pop-up prompts appearing mid-navigation, and smart recommendations interrupting data entry.  Our mobile apps possess conversational interfaces offering summaries, while execution and authentication complexity are expanded in the name of security, but insufficiently hardened in the name of usability.

The irony is that most of these problems as part of innovation is unintentional. AI copilots, predictive systems, and contextual assistance can be powerful when thoughtfully integrated. But too often they feel duct-taped onto existing systems, increasing surface area and fragility without meaningfully improving the primary task.

Layers Upon Layers

Every additional layer introduces complexity: more dependencies, more API calls, more failure states, more integration paths, more latency considerations, more telemetry pipelines, and more security conditions. If the original workflow was not already hardened through extensive real-world testing, each additive feature compounds instability. The system doesn’t just become more capable- it becomes more brittle.

What users experience is not cutting-edge innovation. They experience frozen screens, authentication loops, pop-ups obscuring required fields, forced transitions between app and browser, broken redirects between partner systems, and opaque “something went wrong” messages. The technical sophistication behind the scenes becomes irrelevant the moment the one job the app really needed to complete is the last thing it can perform.

Earlier this week at SQL Konferenz, Grant, Ben, and I presented our session titled “Aren’t We All Tired of AI, Yet?” We explored fatigue around the relentless layering of AI into products, platforms, and workflows. One of the questions I repeatedly ask is this: "Do we need an AI feature in so many areas of a product?"

That question isn’t anti-AI. I work in AI-driven environments. I advocate for thoughtful governance, smart automation, and meaningful augmentation. But innovation without restraint has a cost. When the addition of AI features compromises core workflow stability, we’ve inverted our priorities.  AI, just as with any feature, should be justified, otherwise it wastes innovation time, it provides little to no value and can actually take away value.

Do the Thing, Julie

The most important path in any application is the primary task. In a travel app, that’s booking and check-in. In a banking app, it’s transferring funds. In a database platform, it’s deploying and querying safely. These flows should be nearly unbreakable and everything else is an enhancement. Instead, in many products today, the enhancement layer is robust while the foundational layer is fragile. Roadmaps reward feature velocity, marketing rewards differentiation, investors reward AI narratives, but we often forget that users reward reliability.

There is also a deeper cost: erosion of trust. When basic functionality repeatedly fails, users begin to distrust not just the product, but the entire digital ecosystem around it. Each failed MFA attempt, each expired session mid-check-in, each broken partner redirect adds friction that chips away at confidence.

As technologists, we spend enormous energy on architecture, compliance, governance, and AI ethics frameworks. Those matter and I mean they absolutely matter. At the same time, none of it carries weight if the user cannot complete the reason they opened the app in the first place.

Justify the AI

Before we add another conversational overlay, another predictive engine, another AI assistant panel, we should be asking simpler questions.

  • Does the core workflow function flawlessly on a mobile device?
  • Have we tested it under real network instability? Have we tested MFA expiration mid-session?
  • Have we walked through partner integrations from the user’s perspective, not just the API contract?

And perhaps the most sobering question of all: if we remove the AI layer tomorrow, would the product become more reliable?  If the answer is yes, that’s not a signal to abandon AI, but a signal to rebuild the foundation.

Innovation should not outpace usability and the core workflow should be sacred. Make it resilient and make it boringly reliable…then innovate on top of that stability.

Because in 2026, no one should need three applications and two browsers to check in for a flight.

Peace out-

DBAKevlar

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

Database Security Failures Don’t Start in Security Teams

When a database security incident happens, everyone turns to the security team. We look for a simple root cause analysis, and then we add a control, tighten a policy, and maybe even buy a silver bullet tool. We feel progress! But the incident didn’t start there.

AI/Machine Learning/Cognitive Services

Get AI-Ready With Erik: Why Approximate Search Matters

From Erik Darling Data

Get AI-Ready With Erik: Why Approximate Search Matters...

Administration of SQL Server

What are database keys? A practical guide

There’s not much to database keys, right? When you build a new table, you add a column to act as the primary key, then set it to auto-generate. Done. That’s all there is to know…right? The goal of this article is to demonstrate that there’s much more to the process than this. There are options to selecting, defining, and using keys. For optimal design and performance, consider your choices carefully.

Why disabling the SQL Server sa account still matters in 2026

Disabling (or at least renaming and tightly restricting) the sa login still matters – not because SQL Server is insecure, but because attackers haven’t changed their habits, and neither have many operational risks. This post explains why the sa account is still relevant, what risks remain, and what modern best practice looks like today.

Linked Servers in SQL Server 2025 and Strict TLS

From Curated SQL

Rebecca Lewis notes a common failure point...

Why disabling the SQL Server sa account still matters in 2026

From Simple Talk

Disabling the SQL Server sa account isn’t outdated...

Get AI-Ready With Erik: Combining Search Scoring

From Erik Darling Data

Get AI-Ready With Erik: Combining Search Scoring Vectors...

Optimized Locking part 2: Lock After Qualification

From SQL Server Fast

SQL Server 2025 introduced Optimized Locking...

Lock after Qualification in SQL Server 2025

From Curated SQL

Hugo Kornelis has a new video: One of these two features...

The goal of naming standards

From Dr SQL

I am starting a new, huge project soon, using some different tools than I have used before...

Ad Hoc SQL Server Help

From DallasDBAs.com

I just need a few hours of your time… We get a variation of this request a LOT. So now it’s time to do something about it!...

Updates for sp_Check Tooling

From Curated SQL

Jeff Iannucci announces some updates: It’s been a while since we have updated some of these tools, so we have reviewed a lot of outstanding…

Cloud - AWS

Putting AWS To Work On My Hobby

Mainly, I want to talk about three topics, AWS as a development platform, PostgreSQL as a data storage engine, more specifically though, AWS Aurora hosting PostgreSQL, and the postGIS extension to get geographical information into and out of my database.

Community Interests

Ramblings about data communities and your contributions, no excuses

From Data on Wheels (Steve Hughes)

I have been active in the data community throughout...

Conferences, Classes, Events, and Webinars

Your Environment Evolved. Has Your Database Monitoring? See What’s New at SQLCon

Database teams are rethinking legacy monitoring as estates grow more complex. Slow alerting, limited cloud visibility, and outdated workflows make it harder to stay ahead. At SQLCon Atlanta, visit Redgate Booth 131 to explore the shift to modern monitoring and get our guide on why teams are moving beyond legacy tools.

DMO/SMO/Powershell

MicrosoftFabricMgmt: The PowerShell Pipeline - Idiomatic Automation

From SQL DBA with A Beard

Introduction Last week I showed you how to work with...

Database Design, Theory and Development

SEMANTICS, DATABASE RELATIONS, AND TABLES

From Database Debunkings

    This was said years ago: ”Table (n.) – ...

Thoughts on Database Keys and Constraints

From Curated SQL

Lee Asher digs into keys: Keys come in two basic flavors: natural and surrogate. Natural keys, as their name suggests, are values that occur naturally…

ETL/SSIS/Azure Data Factory/Biml

ADF Pipeline Debugging Fails with BadRequest – The Sequel

From SQLServerCentral Blogs

A while ago I blogged about a use case where a pipeline...

Failure Tracking in SSIS

From Curated SQL

Andy Brownsword keeps a log: SSIS packages provide...

Creating Azure Data Factory Pipelines via Python

From Curated SQL

Michael Bourgon writes a script: I hate creating Scripts...

Editorial

My thoughts on Redgate’s 2026 State of the Database Landscape report

I always really look forward to reading Redgate’s annual State of the Database Landscape report, and 2026 was no exception. I love the level of detailed statistics they collected from many thousands of database professionals worldwide, from DBAs to senior leaders, and from and so many different organizations. There’s a lot to digest, so here are my thoughts on it.

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

Workspace Operations with MicrosoftFabricMgmt

From Curated SQL

Rob Sewell continues a series: The workspace is...

An Overview of the Fabric Native Execution Engine

From Curated SQL

Ankita Victor-Levi introduces a new process...

Report On SAP And Salesforce Data In Fabric With Business Process Solutions

From Chris Webb's BI Blog

If you want to build a reporting solution on SAP...

Fabric terminology

From Mainri

Learn the definitions of terms used in Microsoft Fabric, including terms specific to Fabric Data Engineering, Data Factory, Fabric Data Science, Fabric Data Warehouse, IQ, Real-Time Intelligence, and Power BI...

MicrosoftFabricMgmt: Help and Discovery - Finding Your Way Around 295+ Cmdlets

From SQL DBA with A Beard

Introduction Most of this blog post is going to be more about PowerShell in general than this specific module. The MicrosoftFabricMgmt module has over 295 cmdlets, which can be overwhelming...

Evaluating Power Query Programmatically in Microsoft Fabric

From Curated SQL

Mihir Wagle announces a new preview capability: Power Query has long been at the center of data preparation across Microsoft products—from Excel and Power BI…

Oracle/MySQL/other RDBMS

How to secure MySQL and PostgreSQL in the world of AI

Given the fact that databases aren’t just repositories of information but backbones for your applications, securing databases like MySQL and PostgreSQL is becoming increasingly critical and, while we can use basic security practices to secure our most precious data, some things have to change.

How to secure MySQL and PostgreSQL in the world of AI 

From Simple Talk

Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster attacks, and evolving vulnerabilities.… The post How to secure MySQL...

Performance Tuning SQL Server

Creating Data from Literals in SQL Server

From Curated SQL

Louis Davidson has values. Many, many values...

SQL Server Diagnostic Information Queries for March 2026

From Glenn Berry

Introduction These are my SQL Server Diagnostic...

Tune Stored Procedures For Actual Usage, Not Assumed Usage

From DCAC

I was recently working on a performance tuning engagement for a client. They had a stored procedure that looked similar to the following sample code...

Query Tuning and Premature Optimization

From Curated SQL

Denny Cherry shares some advice: This runs about as inconsistently as you would expect, given that it’s the same plan every time, no matter what…

PostgreSQL

Alastair Turner: A reponsible role for AI in Open Source projects?

From Planet Postgres

AI-driven pressure on open source maintainers...

Tomas Vondra: The real cost of random I/O

From Planet Postgres

The random_page_cost was introduced ~25 years ago,...

Radim Marek: PostgreSQL Statistics: Why queries run slow

From Planet Postgres

Every query starts with a plan. Every slow query performance...

Vibhor Kumar: Open Source, Open Nerves

From Planet Postgres

Trust, Governance, Talent, and the Enterprise Real...

JSONB Data in Postgres and Performance Due to TOAST

From Curated SQL

Paul Ramsey lays out the facts and the data...

Connection Pooling in PostgreSQL vs SQL Server

From Curated SQL

Haripriya Naidu compares two systems: If you speak...

PowerPivot/PowerQuery/PowerBI

Building Power BI Reports from the Desktop or Fabric

From Curated SQL

James Serra clears up some confusion...

SQL Server 2025

Backup Updates in SQL Server 2025

From Curated SQL

AK Gonzalez summaries some changes...

SESSION_CONTEXT and Parallelism Bug in SQL Server

From Curated SQL

Rebecca Lewis lays out the consequences of an existing bug: If you use SESSION_CONTEXT() in any query that can run with parallelism, you may be getting wrong…

 
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

 

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