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
 

Fantasy baseball and old habits

Old habits are hard to change sometimes. Time and again, regardless of what the task or query for information might be, my go-to source of information is Google. Whether on my phone or computer, my muscle memory instinctively opens a browser window or clicks into the search widget and starts typing. My “google foo” has been honed and developed over more 32 years (yes, before Google existed) starting with Gopher on a DEC 5000. Regardless of the search engine – Altavista, Yahoo, Ask Jeeves, DuckDuckGo, etc. – I’ve learned which kind of results to favor and how to quickly refine the search further. Because I have a pretty decent typing speed, it just always feels more efficient than trying something new.

Maybe you’ve heard of that “something new”, a little tool called ChatGPT and related variants??

In the last week, however, I’ve been reminded in a couple of ways that my old habits need some tweaking. When my instinct is to start typing into a search bar, I’m trying to do a quick analysis if traditional search is more efficient for the task at hand than asking a Large Language Model (LLM).

  • Hours of a local business? Google.
  • Definition of a Postgres or database term? Google (generally)
  • Finding alternative approaches to writing a query? ChatGPT/Copilot
  • Converting a series of values or text into another form? ChatGPT/Copilot
  • Asking for an analysis of the fantasy baseball team I help manage? ChatGPT/Copilot
  • Cooking dinner, hands messy, and wondering what certain additives are in some of the food ingredients? Copilot voice conversation… which was way more natural and realistic than I expected it to feel.

At the same time, I had a friend message me this week to complain about some step-by-step instructions he had received from ChatGPT regarding the administration of some networking equipment. It was quickly evident that multiple steps contradicted each other and caused more confusion than help. Hallucinations are, and will continue to be, a problem that LLMs suffer from for the foreseeable future.

There is no magic bullet. Both traditional search and LLMs still require the end user to have enough knowledge or experience to judge a good answer from a “bad” one. The more experience we have in a certain area, the better able we are to refine our searches and interactions to attain a better, more helpful answer. But the last week has reminded me that my first, instinctual approach might not always be the best one. Although LLMs have their own problems too, I have found that the ability to converse in more long-form conversation often draws out questions and details that I might not have gotten using traditional search.

There is a space for both technologies, and personally, I think there will be for a long time to come. But I’m glad that I keep being pushed to explore my options and learn which technology is best for the job at hand.

Now, about those fantasy baseball trade waivers…

Ryan Booz

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

Announcing Public Preview: Static Data for PostgreSQL Database Using Flyway

We are thrilled to announce the public preview of our new feature: Static Data for PostgreSQL Database using Flyway. This feature is designed to enhance your database management experience by allowing you to manage static data alongside your schema seamlessly for versioning and deploying your database changes.

Getting Started with Flyway SQL Code Analysis Rules

Before you apply pending SQL migration scripts, Flyway can automatically check them for a range of code smells. The check -code command can perform a static code analysis on these scripts to check that they comply with a set of rules designed to encourage good coding practices. You can opt to use SQL Fluff, provide your own Regex rules, or use both. This article explains how Flyway's regex-based code checks work, their strengths and limitations and how to start running checks on Flyway-managed databases.

Administration of SQL Server

Reporting Query Errors via Extended Events

From Curated SQL

Tom Collins wants to know what’s going wrong: We have an ETL job failing every night . The ETL job is using SQL Server Stored…

All About SQL Server Stored Procedures: Wrapper Stored Procedures

From Erik Darling Data

All About SQL Server Stored Procedures: Wrapper St...

Azure SQL

Why Your Azure SQL DB Hyperscale Bill is Higher Than You’d Expect

From Brent Ozar Unlimited

tl;dr: if you use Azure SQL DB Hyperscale’s auto...

Big Data

Don’t Treat Your Data Catalog Like a Data Museum

From Joyful Craftsmen – The Business Intelligence Agency

Introduction Treating your data catalog like a “...

Computing in the Cloud (Azure, Google, AWS)

Beyond Single-Cloud: A Peek into Multi-Cloud

In this article, we look at key drivers behind the rise of multi-cloud adoption, explore the main challenges enterprises face, such as cost management and security, while suggesting practical insights to help businesses build effective multi-cloud strategies.

Conferences, Classes, Events, and Webinars

Registration is now open for PASS Summit 2025!

Join us this November (17-21) in Seattle for the ultimate data professional experience: PASS Summit 2025! Connect with the data community, choose from hundreds of expert-led sessions across diverse topics, and gain practical skills you can apply right away to accelerate your career. Plus, don’t miss our Community Experts Clinic and Deep Dive sessions – your chance to learn directly from industry leaders. Save your spot – register now!

MDX/DAX

Performance Profiles of SUM() and SUMX() in DAX

From Curated SQL

Eugene Meidinger blows the doors off of this conspiracy: For years, I told people to avoid iterators. I compared them to cursors in SQL, which are really…

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

Querying a Microsoft Fabric SQL Endpoint from a Notebook

From Curated SQL

Dennes Torres wants to hit a SQL endpoint: Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can…

Fabric Espresso Episodes on Data Warehousing and Storage

From Curated SQL

Estera Kot shares some links: For the past 1.5 years, the Microsoft Fabric Product Group Product Managers have been publishing a YouTube series featuring deep dives…

Fabric: Query a SQL Endpoint from a Notebook

From Simple Talk

Let’s analyse why we would like to query an SQL ...

Oracle/PostgreSQL/MySQL/other RDBMS

MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization)

In this third installment, we’ll continue our series by going into another important aspect of database optimization—disk I/O and storage.

Performance Tuning SQL Server

Can You Tell Why a Plan Didn’t Go Parallel?

From SQLServerCentral Blogs

Let’s face it, most of the time, you probably do...

PostgreSQL

Alexander Korotkov: Why PostgreSQL needs a better API for alternative table engines?

From Planet Postgres

For a long time now, PostgreSQL has had an extensi...

The Wide World of GiST Indexes

From Simple Talk

  In Parts I (Solving the Overlap Query Problem i...

Hans-Juergen Schoenig: Semantic Search in PostgreSQL: An Overview

From Planet Postgres

PostgreSQL offers advanced capabilities through ex...

Regina Obe: Converting JSON documents to relational tables

From Planet Postgres

JSON is one of the most popular ways of disseminating data between systems. It is probably the most common offered by webservices. PostgreSQL is a database perfectly suited for...

PowerPivot/PowerQuery/PowerBI

Speed Up Dataflow Publishing/ Validation Times In Power BI And Fabric

From Chris Webb's BI Blog

If you’re working with slow data sources in Powe...

Security News and Issues

A Sneaky Phish Just Grabbed my Mailchimp Mailing List

From Troy Hunt's Blog

You know when you're really jet lagged and really ...

Software Development

The trade-offs associated with low-code solutions

From SQLServerCentral Blogs

Low-code solutions often accelerate development an...

Tech News

After 50 million miles, Waymos crash a lot less than human drivers

From Ars Technica

Waymo has been in dozens of crashes. Most were not...

What is Signal? The messaging app, explained.

From Technology Review Feed - Tech Review Top Stories

MIT Technology Review Explains: Let our writers un...

 
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

 

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