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
 

Just Answer the Question!

I've taken part in online forums since... hoo boy, I was using a dial up modem and had to constantly remind my wife not to pick up the phone while I was using the computer.  Man I'm old. Anyway...

I've asked a lot of questions over the years, and I've tried to answer them as well. I've been posting stuff here on SQL Server Central for over two decades now (see, old). Lately, I've been doing a lot of posting around amateur radio on various forums. Not to bring AI into it, but, I've found that the information available from AI when it comes to radios and how to make them work, is weak. Very weak in some cases (looking at you CoPilot). I don't know if that's because the information is too new for it to be a part of their models, or if the sites where the information can be found is too obscure, or what. However, the simple fact of the matter is, if you want information on radios, you may be required to ask someone for help, and the online forums are where you go to get it. Cool, right? Nope.

See, for whatever reason, a lot of people in these forums are obsessed. With answering questions? Nope. With two things. First, and foremost, gatekeeping. The question can be really innocuous like "Does this radio transmit on 1.25m?". The answer will inevitably be "What's your license? You know you can't transmit on 1.25m in Kenya!" Like that has anything to do with the question (and maybe the person is in Somalia, where you can). The other thing that will come up, over and over, is to answer the same question this way: "Well, if you'd read the manual, you'd know."

Both these make me want to pluck my eyebrow hairs out, one-by-one.

Generally speaking, we don't see much of that around here in our forums. Overall, we're a pretty helpful bunch. Yeah, we may ask a lot of follow-up questions, but really, we do try to simply help people, even if the same question has been asked 50 times before. Just as with my AI example earlier, search engines aren't trusted by a lot of people. For some good reasons and some bad, I get it. So, go somewhere to find experts and ask them rather than rely on possibly sketch answers from an AI or search engine.

EXCEPT THEY CAN'T GET THE ANSWER!!!

I think this is something we have to be really cautious about in online forums, but, let's be clear, in real life too. Very frequently, I know, because I do this, people don't listen to the full question, or don't listen well to the question. Then they proceed to answer what they think was asked, and it's wrong. Or, we decide rather than helping a person, they need a lecture on why, oh, I don't know, I'll pick on myself, why there's only one kind of execution plan, not two, in SQL Server.

Again, this is not directed at our online forums or any of you (although, we have done it), but rather, something to keep an eye on. I've always said, an expert is someone who is one page ahead of you in a book. So, we can all be experts at something that we know more than the person asking a question. So, let's remember that they're trying to learn or solve a problem, same as us.

Just answer the question!

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.
Vendors/3rd Party Products

Simple Safeguards for PowerShell Scripting with Flyway

This article demonstrates simple techniques to security-check any processes that use Bash or PowerShell scripts to automate database tasks, when using Flyway. These checks help ensure a script is trusted, hasn't been tampered with since creation, and doesn't contain commands commonly used with malicious intent. They add a valuable layer of protection, without sacrificing the power and flexibility that makes Flyway so effective.

AI/Machine Learning/Cognitive Services

ChatGPT’s Deep Research is Available to Free Users For the First Time

From Past News - RSS Feeds

Lightweight o4-mini activates after users hit usag...

New study shows why simulated reasoning AI models don’t yet live up to their billing

From Ars Technica

Top AI models excel at math problems but lack reas...

Is AI cheating?

From Purple Frog Systems

I was recently a Judge at a  ‘Dragons Den’ ev...

We need to start thinking of AI as “normal”

From Technology Review Feed - Tech Review Top Stories

Right now, despite its ubiquity, AI is seen as any...

Billionaire Hoffman Praises Shopify CEO’s New AI-Focused Management Approach

From Past News - RSS Feeds

Reid Hoffman praises Shopify CEO Tobi Lütke’s r...

Google search’s made-up AI explanations for sayings no one ever said, explained

From Ars Technica

A partial defense of (some of) AI Overview's fanci...

This data set helps researchers spot harmful stereotypes in LLMs

From Technology Review Feed - Tech Review Top Stories

AI models are riddled with culturally specific bia...

‘Creative Codependency’ With AI Helped Write Acclaimed Philosophy Book About Digital Manipulation

From Past News - RSS Feeds

“Hypnocracy: Trump, Musk, and the New Architectu...

Google is quietly testing ads in AI chatbots

From Ars Technica

Unsurprisingly, an advertising company is finding ...

Time saved by AI offset by new work created, study suggests

From Ars Technica

Survey of 2023–2024 data finds that AI created m...

Administration of SQL Server

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

From SQLServerCentral Blogs

I have recently had the privilege of working with ...

SQL Server 2022 Finally Fixed a SQL Server 2008 Query Plan Bug!

From Brent Ozar Unlimited

For yeeeeeears, when I’ve explained execution pl...

Index Maintenance Can Change NORECOMPUTE Settings

From SQLServerCentral Blogs

I had a customer recently ask about a change in on...

Fixing OPTIMIZATION_REPLAY_FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+

From Kendra Little's Blog

Forcing plans with Query Store can be a powerful t...

Purging Data from a Large Table in SQL Server

From Simple Talk

Purging data from a table is a common database maintenance task to prevent it from growing too large or to stay in compliance with data retention. When dealing with...

SQL Server Budgets: How to Justify Cost to Management

From DallasDBAs.com

Ever tried to request SQL Server funding from the ...

SQL Server Diagnostic Information Queries for May 2025

From Glenn Berry

Introduction These are my SQL Server Diagnostic Information Queries for May 2025, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration...

Analysis Services / BI on the MS Stack

Security in Tabular Semantic Models

From SQLBI

How to implement security in Tabular semantic mode...

SQLBI+ updates in April 2025

From SQLBI

We released a new course for our SQLBI+ subscriber...

Atlanta Microsoft BI Group Meeting on May 5th (Optimize Power BI Reports and Semantic Models Using External Tools)

From Prologika (Teo Lachev's Weblog)

Atlanta BI fans, please join us in person for our ...

Mind the Gap: Assessing Data Quality Readiness

From Dataversity

This is the second in a two-part series exploring data quality and the ISO 25000 standard.  OK. You’re with the program. You recognize that having quality data is important...

Cloud - AWS

AWS Weekly Roundup: Amazon Q Developer, AWS Account Management updates, and more (April 28, 2025)

From AWS News Blog

Summit season is in full throttle! If you haven’...

Reduce your operational overhead today with Amazon CloudFront SaaS Manager

From AWS News Blog

Amazon CloudFront SaaS Manager helps software-as-a...

Announcing second-generation AWS Outposts racks with breakthrough performance and scalability on-premises

From AWS News Blog

AWS announces significant upgrades to Outposts rac...

Community Interests

PGDay Chicago 2025 Roundup

From Simple Talk

Just got back home last night about 2 AM, and I am...

Henrietta Dombrovskaya: PG Day Chicago 2025

From Planet Postgres

We did it! Thank you so much to everyone who m...

Speaking at SQL Saturday Austin 2025

From SQLServerCentral Blogs

SQL Saturday Austin 2025 is in just a few days. I ...

Study: Women in Tech Flourish Despite Industry Hurdles

From IT Pro - Microsoft Windows Information, Solutions, Tools

A new study reveals 88% of women in tech are thriv...

DevOps Day – Atlanta

From SQLServerCentral Blogs

No tour this year, but Redgate does have a few Dev...

The Have I Been Pwned Alpine Grand Tour

From Troy Hunt

Presently sponsored by: Malwarebytes Browser Guard...

SQL Saturday Raleigh 2025 Is Coming up Soon!

From 36 Chambers – The Legendary Journeys

SQL Saturday Raleigh 2025 is going to take place o...

Conferences, Classes, Events, and Webinars

Redgate Summit Is Coming To New York, Dallas, and the Netherlands this Fall!

After an amazing Redgate Summit in London earlier this year, we’re thrilled to be bringing Redgate Summit to New York in August, Dallas in September, and Utrecht, the Netherlands in October! This series aims to bring together data professionals who want to improve their skills and knowledge about Database DevOps, learn about moving to the Cloud, AI, and navigate the increasingly complex database landscape.

DMO/SMO/Powershell

PowerShell: Changing Active Directory User Logon Names (Bulk)

From Sid 500 PoSh

Active Directory users log on with their logon nam...

Testing for End of Month in PowerShell

From FLX SQL

This is one of those blog posts you write so that ...

Data Mining / Data Analysis

Comply, compete or collapse: The new rules of risk modeling

From AllAnalytics

The financial services industry is undergoing a period of profound change, driven by a dynamic economic landscape, increased regulatory scrutiny, changing consumer behavior and rapid technological advances. Banks operating...

Why Data as a Product Is Replacing Dashboards in the Modern Enterprise

From Dataversity

For years, organizations have invested heavily in dashboards, data warehouses, and centralized reporting platforms. Yet many still struggle to turn their growing volumes of data into real business results....

Data Privacy, Compliance, and Governance

Why One-Size-Fits-All Data Governance Doesn’t Work in the Age of AI

From Dataversity

Data has evolved from a back-office function into ...

Database Design, Theory and Development

Best Practices for Automating Complex Unstructured Data Migration

From Dataversity

In today’s data-driven business environment, ent...

Machine Learning

Video: The Azure ML SDK v1 Is Going Away in 2026

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, I cover some...

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

Execute Fabric Data Pipeline from Azure Data Factory

From SQLServerCentral Blogs

In the blog post Call a Fabric REST API from Azure...

Configure Azure Security for the Fabric Data Factory REST API

From AndyLeonard.blog()

Please find the landing page for this series here....

Presenting Data Engineering Fundamentals with Fabric Data Factory at PASS Data Community Summit 2025

From AndyLeonard.blog()

Data Engineering Fundamentals with Fabric Data Fac...

Automate testing Microsoft Fabric Data Pipelines with YAML Pipelines

From Kevin Chant

Reading Time: 7 minutesIn this post I want to cover one way that you can automate testing Microsoft Fabric Data Pipelines with YAML pipelines in Azure DevOps....

Query Lineage in Fabric Lakehouses

From Simple Talk

I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability to track the queries back to a semantic model, report and visual...

Fabric: Query a SQL Endpoint from a Notebook

Dennes Torres analyzes why we would like to query a SQL Endpoint and how we'd go about doing it.

Oracle/PostgreSQL/MySQL/other RDBMS

Working with the MongoDB Database Tools

From Simple Talk

The MongoDB Database Tools are a set of command-li...

Oracle Memory Management: Common Configurations, Parameters, and Monitoring

From DBAKevlar

After the initial overview of memory monitoring in...

Performance Tuning SQL Server

How I Used Claude Code To Refactor My Stored Procedures

From Erik Darling Data

How I Used Claude Code To Refactor My Stored Proce...

PostgreSQL

Regina Obe: FROM function or SELECT function

From Planet Postgres

When I have set returning functions and even non-s...

Dave Stokes: Incremental Backups in PostgreSQL 17

From Planet Postgres

 The old adage that a DBA or SRE is only as good ...

KUNTAL GHOSH: Exploring the limits of Postgres

From Planet Postgres

Postgres is a powerful and feature-rich database, ...

Tomas Vondra: [PATCH IDEA] adaptive execution for `IN` queries

From Planet Postgres

Last week I visited the Malmö PUG to talk about p...

Andreas 'ads' Scherbaum: Adam Hendel

From Planet Postgres

PostgreSQL Person of the Week Interview with Adam ...

David Wheeler: Update Your Control Files

From Planet Postgres

Reviews of the extension search path patch, now co...

Laurenz Albe: Orphaned files after a PostgreSQL crash

From Planet Postgres

© Laurenz Albe 2025 PostgreSQL is famous for ...

Shayon Mukherjee: A PostgreSQL planner gotcha with CTEs DELETE and LIMIT

From Planet Postgres

I recently discovered an unexpected behavior in Po...

Ian Barwick: PgPedia Week, 2025-04-27

From Planet Postgres

A very minimal edition this week, due to lack of t...

Andrew Atkinson: Source code line numbers for database queries in Ruby on Rails with Marginalia and Query Logs

From Planet Postgres

Back in 2022, we covered how to log database query...

Pavel Luzanov: PostgreSQL 18: part 4 or CommitFest 2025-01

From Planet Postgres

We continue to follow the news about PostgreSQL 18...

Pavlo Golub: PostgreSQL Trusted Extensions for Beginners

From Planet Postgres

Introduction Recently, we had a long discussio...

Dave Stokes: Queries on Vacuum

From Planet Postgres

 I am (slowly) adding handy PostgreSQL queries to...

The Wide World of GiST Indexes

Lee Asher explores some of the many ways GiST indexes can be used.

PowerPivot/PowerQuery/PowerBI

Two New Power BI/Power Query Books

From Chris Webb's BI Blog

It’s time for another one of my occasional posts...

BLANK() Function Not Working As Expected

From Purple Frog Systems

Trying to handle blank values in Power BI… I nee...

Professional Development

The power of connecting in person

From Simple Talk

To start off I want to be clear, I am a big propon...

How to Launch a Freelance Software Development Career

From IT Pro - Microsoft Windows Information, Solutions, Tools

Whether by choice or necessity, freelancing as a s...

Python

How to use SQL Code to read from Delta Tables in a Python Notebook

From FourMoo

I come from a TSQL background, so using SQL makes ...

R Language

Calculating Grouped Counts and Weighted Means in R

From Curated SQL

Michael Mayer doesn’t want to wait: Read on for ...

Security News and Issues

iOS and Android juice jacking defenses have been trivial to bypass for years

From Ars Technica

New ChoiceJacking attack allows malicious chargers...

Applying Security Engineering to Prompt Injection Security

From Schneier on Security

This seems like an important advance in LLM securi...

Redditor accidentally reinvents discarded ’90s tool to escape today’s age gates

From Ars Technica

The '90s called. They want their flawed age verifi...

The Rising Threat of Social Engineering: How Today's Phishing Scams Are Exploiting Trust

From IT Pro - Microsoft Windows Information, Solutions, Tools

Cybercriminals are increasingly leveraging AI-gene...

'Digital Twins' Bring Simulated Security to the Real World

From IT Pro - Microsoft Windows Information, Solutions, Tools

By simulating business environments or running sof...

Millions of Apple Airplay-enabled devices can be hacked via Wi-Fi

From Ars Technica

Hackers can run their code on AirPlay devices than...

Windows RDP lets you log in using revoked passwords. Microsoft is OK with that.

From Ars Technica

Researchers say the behavior amounts to a persiste...

Secure by Design vs. DevSecOps: Same Security Goal, Different Paths

From IT Pro - Microsoft Windows Information, Solutions, Tools

While both secure by design and DevSecOps aim to i...

Why MFA is getting easier to bypass and what to do about it

From Ars Technica

Why multifactor authentication based on one-time p...

DevSecOps Reality Check: Context Reduces Critical Security Alerts by 82%

From IT Pro - Microsoft Windows Information, Solutions, Tools

Cutting through security noise, Datadog's 2025 Sta...

Tech News

Silicon Valley billionaires literally want the impossible

From Ars Technica

Ars chats with physicist and science journalist Ad...

What’s it like to be 70 years old in space? “All those little aches and pains heal up.”

From Ars Technica

"When the flight docs say I'm ready to go back, I'...

Spain is about to face the challenge of a “black start”

From Ars Technica

Major power facilities require power to operate, a...

A rocket launch Monday night may finally jump-start Amazon’s answer to Starlink

From Ars Technica

A United Launch Alliance Atlas V rocket lifted off...

Will Humanoid Robots Sort Your UPS Packages in the Future?

From Past News - RSS Feeds

UPS is reportedly in advanced talks with robotics ...

Raspberry Pi cuts product returns by 50% by changing up its pin soldering

From Ars Technica

Combining both the big and little solder jobs made...

Compact Discs Are Back!

From Glenn Berry

Introduction If you were born in the 20th Century, you probably remember when audio compact discs (CDs) were the most popular format for listening to music, whether it was...

Neanderthals invented their own bone weapon technology by 80,000 years ago

From Ars Technica

Neanderthals used sleek bone projectiles to hunt b...

New material may help us build Predator-style thermal vision specs

From Ars Technica

Films of IR-sensitive material only tens of nanome...

Rocket Report: Starbase the city is coming soon; Alpha remains in beta

From Ars Technica

"A commitment to keeping on with the Moon mission ...

Eric Schmidt apparently bought Relativity Space to put data centers in orbit

From Ars Technica

"Gives you a sense of how big this crisis is."

The Lighter Side

Monty Python and the Holy Grail turns 50

From Ars Technica

Ars staffers reflect upon the things they love mos...

So You Think You Should Get a Radio

From Scary DBA (Grant Fritchey)

This is not database related, so if you’re not i...

“Older than Google,” this Elder Scrolls wiki has been helping gamers for 30 years

From Ars Technica

Interviewing the people behind the 30-year-old Uno...

Error'd: Charge Me

From Daily WTF

The lights are on here and the roof is intact and I'm grateful. Is anybody home? You decide. Pharm fan Ian S. clucked "Perhaps they'll put those as dates on my headstone."...

Theory and Design

The CREATE DOMAIN Statement

One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does not exist in SQL Server as of SQL Server 2022, but it has been a part of PostgreSQL since 7.3.

Virtualization and Containers/Kubernetes

Containers Land RPG

From Barketr

map created with Perilous Shores, by wata.watabou ...

Containers Land: docker setup on WSL2

From Barketr

Whole series, assumptions, and map: Container Land...

 
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

 

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