With the Rise of AI Chat, are Experts Still Needed?

As I was looking at the feed of technology stories this week, two things jumped out at me.

First, Valentine's day happened to fall on the monthly release day for Microsoft updates and feature previews. If you work with Azure services, specifically in the data platform space, there are a lot of update announcements to work through from this past week.

Second, the constant feed of news about AI-driven chat platforms isn't going to abate any time soon.

Just over a week ago Microsoft announced the release of the new Bing with OpenAI technology in limited preview. Within 24 hours, Google announced their entry into the AI chat space with the Bard chatbot. Unfortunately for Google, Bard's announcement started with a factual error and the internet couldn't handle it.

While the technology is fascinating and the signup numbers outpace nearly all previous "unicorn" projects, I have a confession to make.

I didn't try to use ChatGPT until earlier this week.

There are a few reasons why I waited so long, not the least of which was simply having the time to learn where to start. But if I'm being honest, it felt like a gimmick ready to waste more of my precious time. Within days of the public preview, Twitter, YouTube, and LinkedIn were (and still are) overrun by "10 Best Prompts for ChatGPT" threads and videos. I just didn't have the need or time to risk being sucked into a vortex.

As a database developer I could appreciate the samples of code writing and query generation. With the correct prompts it was fun to see ChatGPT provide digestible answers to technical design challenges. But in the end, it felt like everything I saw was another example of someone spending time trying to get ChatGPT to provide the answers that they could have coded in less time.

However, something finally pushed me over the edge on Monday.

My New Research Assistant

I was doing research for some blog posts about PostgreSQL patches and upcoming features. There is an endless stream of information for each topic that delves into the history, highlights, bugs, requests for improvement, and more. The PostgreSQL documentation alone is dense and time consuming to get through. I realized that ChatGPT might be able to help me summarize some of the questions I had.

I wanted to direct the service to a set of publicly available email threads and have it summarize the conversation. Unfortunately, that's not possible, yet.

Next, I tried to copy portions of the back and forth into ChatCPT but my text selection was always too long (with no feedback on what the maximum length was). Finally, I realized I had to take a different approach.

As I re-read the email thread conversation, I used ChatGPT to explain concepts that weren't clear to me. While I could have done the same in Google or another search engine, this did end up being a more natural experience. "What is the difference between X and Y?" "Is Y better in situations where Z happens?"

The answers helped me understand the concepts at the level I needed without clicking through multiple web pages or Stack Overflow threads.

Finally, I had found a use for ChatGPT - and I probably should have tried this sooner.

Your Skills and Knowledge Are Still Valuable

While I came away with a sense intrigue, I also came away with a stronger sense of how essential it is to retain and encourage professionals that care about their craft. For the time-being, at least, our skills and knowledge are more valuable than ever... with or without ChatGPT.

Yes, ChatGPT might have the ability to quickly suggest the right SQL JOIN or which WINDOW function will produce the results you are expecting. But ChatGPT will never know your specific, private business data (and if it does, we have other problems to worry about).

You know your problem domain best. You know the distribution of your data best. You understand the nuances of how your data model works and the access patterns throughout each day, week, and season.

ChatGPT and all the AI assistant bots coming down the pike are just additional tools at your disposal. Every day we have a growing stream of new information coming at us and having a tool available that can quickly summarize and correlate that information will be particularly helpful.

Use these new tools wisely, not blindly.

What About You?

Have you found a particular use case for tools like AI chat that's benefited your day-to-day job responsibilities? How have tools like these helped you solve database or analysis problems?

Ryan Booz

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

The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps.

The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call and in this case, store data, include Firebase and Supabase. Firebase is a NoSQL database, while Supabase is a relational database. The Firestore database, which lets you store “documents,” is the core of Firebase. These are collections of key-value pairs where different sub-value documents may be present.

This article will cover using the TOP clause in a SELECT statement and how it can be used to return a partial set of records.

The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data Science with Azure Machine Learning (Azure ML). Readers don’t need prior knowledge...

How did we get to a place where a conversational chatbot can quickly create a personalized letter? Join us as we explore some of the key innovations over the...

On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR is an out-of-band update... The...

In this article, we look at using SQL Server filtered indexes to improve performance, why SQL Server will sometimes ignore these indexes, and what you can do to ensure...

Featured image photo by Susan Holt Simpson on Unsplash Everybody loves freebies, and the SQL Server community is full of them. Free scripts, stored procedures, blog posts, books, and...

Introduction These are my SQL Server Diagnostic In...

Eliminate the need to set up new servers and complete manual upgrades with in-place major version upgrade for Azure Database for PostgreSQL – Flexible Server.

Optimizing resource allocation to achieve performance goals while controlling costs can be a challenging balance to strike especially for database workloads with complex usage patterns.  Azure SQL Database serverless...

The quantity of structured and unstructured data that enterprises must deal with today is such that most require the best in databases and data warehouses. A large data warehouse...

Reading Time: 2 minutes For this months T-SQL Tuesday contribution I want to cover Azure Synapse Link and certifications. In addition, this post contains plenty of links. Community...

It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of February 2023? Do you wanna work with the kinds of people...

The T-SQL Tuesday #159 invitation comes from Deepthi Goguri who has not one, but two invitation topics. First, what is a favorite SQL Server 2022 or Azure feature? Second,...

SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book. Register now using 10REDGATE.

I had an impromptu consulting session yesterday with a friend who was looking for guidance on how to visualize data for an important new initiative he is spearheading at...

Steven Sanderson shows off a useful R library: Are you interested in visualizing time series data in a clear and concise way? The R package {healthyR.ts} provides…Continue readingVisualizing Moving Averages in...

Christian Lorentzen digs into quantile calculation: Applied statistics is dominated by the ubiquitous mean. For a change, this post is dedicated to quantiles. I will give my…Continue readingEstimating Quantiles in Python

It was a lot of fun to speak at the Louisville Data Technology Group in February. Sheila and I presented on Jupyter notebooks in Azure Data Studio. The session...

This article explains how we can use the ephemeral, containerized databases delivered by Redgate Clone to increase database code quality and therefore the stability, reliability, and performance of the...

Microsoft’s partnership with OpenAI may soon acc...

+OK

Learn how to troubleshoot SQL Server User-Defined Function performance issues using actual execution plans, estimated execution plans, and live query statistics and why it makes a difference.

+OK

Learn how to build and format a Sankey Chart using Power BI along with step-by-step instructions.

Gilbert Quevauvilliers has us synchronize our watches: In this blog post I am going to detail how to create a schedule, test and confirm that…Continue readingScheduling a Power BI...

DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article...

Chris Webb breaks the limits: My recent post on passing any value to a Power BI dynamic M parameter from a report generated quite a lot of…Continue readingDynamic What-Ifs in Power...

Reza Rad brings order to things: The question I often get in my Power BI architecture consulting sessions is; “How should we organize our workspaces?…Continue readingOrganizing Power BI Workspaces

Create a what-if parameter in Power BI based on end user inputted values

A popular performance tuning book gets updated for SQL Server 2022, how does it fare?

Python has the ability to create many different types of charts and graphs and in this article, we look at how to create animated line plots with Python.

The goal: Ensure that data is always finely curated and accessible, and that security decisions get made with high-fidelity data.

A tailored spear-phishing attack successfully conv...

The authentication bypass used by the Nobelium gro...

Magda Bronowska rounds to the nearest minute: From MS Learn: DATETRUNC() function returns an input date truncated to a specified datepart. On the surface the…Continue readingThe Power of Date...

Rob Farley enjoys the syntax: This month, Deepthi Goguri (@dbanuggets) asks us about our favourite new feature in SQL Server 2022 or Azure. And while there are always…Continue readingThe Benefit of IS...

Now that we understand a little more how dynamic SQL works, let’s see how it helped me solve the problem. What is OPENROWSET? OPENROWSET is a functionality that allows...

It’s a good time to be a search startup. When I spoke to Richard Socher, the CEO of You.com, last week he was buzzing: “Man, what an exciting day—looks...

Microsoft has published an official support page offering guidance for running Windows 11 on Macs with Apple's M1 and M2 processors.

Microsoft has been trying to kill Internet Explore...

We've been exploring the ChatGPT-powered Bing 'Sydney' and have had some interesting conversations.

Here we reveal key lessons data center operators can glean from Uber's recent migration announcement. We also share a repatriation case study along with strategic considerations for either data...

A beta build of ChromeOS 111 shows what the keyboard shortcuts app will look like.

This SLA printer is no taller than a matchstick, b...

Database development with SQL projects is available for Windows, macOS, and Linux through Visual Studio, VS Code, and Azure Data Studio. SQL projects are a .NET-based project type for...