Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

How Helpful is a GenAI Copilot

I'm sure many of you have tried a GenAI LLM to do something. Maybe write some code, maybe get some sort of recommendation or suggestion, maybe to rewrite something or summarize text. I'm sure you have had some feelings about whether the tool made you more or less productive.

There was a trial conducted by the Australia Department of the Treasury on Microsoft's 365 Copilot, asking for volunteers to participate and use the tool in their daily work. They used it and then completed a survey, which are summarized in this piece. Only 218 people went through the trial, and the results are interesting.

The headline says that the staff rater the GenAI less useful than expected. Those last two words are interesting because your expectations shape a lot of how you view anything in the world. If you expect little and get a little more, you might be happy. If you expect a lot and don't get it, you might be very disappointed.

The sub-headline and the first sentence note that there still is an ROI from the tool. It isn't as helpful and isn't as widely applicable as people expected, but they chalk some of this up to product limitations and some to limited use by people. It was useful in summarizing things and drafting content, which are what they call basic administrative tasks.

Maybe the most interesting thing to me is that if Copilot saves 13 minutes a week for mid-level workers, it pays for itself. I don't know how much time it would have to save me, but an hour or two a week might make me use it more. So far, I haven't committed, and I think I still spend more time learning and typing with GenAI tools than I'd like. I'm not sure if I am saving time over just doing the task myself.

This also brings up something I wonder about with these GenAI services. With the cost of compute, there might not be a lot of margin for them to raise prices if people are only lightly more productive. I can see lots of companies starting to use these tools, realize there isn't as much value, and dropping the cost from their budget. That might be some of what we saw in this years State of the Database Landscape, with less people using AI for database management tasks. I suspect some of the hype has died down and people aren't finding the tools as useful as they expected.

I do think GenAI is helpful, but just helpful. It can't do the work, and it can't be trusted more than a junior worker. At least not yet. Maybe that will change, but I haven't seen it to date.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
Stairway to Synapse Analytics

Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool

Sucharita Das from SQLServerCentral

This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.

External Article

SQL Server Cursor Example

Additional Articles from MSSQLTips.com

I know SQL cursors exist, but I am not sure how or why to use them. Can you provide a SQL cursor example? Can you give any guidance on when to use a SQL Server cursor?

Blog Post

From the SQL Server Central Blogs - Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

aen from Anthony Nocentino Blog

As AI continues to evolve, many of us are looking for ways to leverage large language models (LLMs) without relying on cloud services. As we learned in my previous...

Blog Post

From the SQL Server Central Blogs - Can AI Read Execution Plans?

Grant Fritchey from The Scary DBA

Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML...

Introduction to PostgreSQL for the data professional

Introduction to PostgreSQL for the data professional

Site Owners from SQLServerCentral

Adoption and use of PostgreSQL is growing all the time. From mom-and-pop shops to large enterprises, more data is being managed by PostgreSQL. In turn, this means that more data professionals need to learn PostgreSQL even when they have experience with other databases. While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The TEXTSIZE Default

What is the default value of SET TEXTSIZE?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Secondary Query Store

If I enable the Query Store for secondary replicas, what does this do?

Answer: This lets the secondary replica query store send its data to the secondary primary replicas

Explanation: According to the MS Docs: "When Query Store for secondary replicas is enabled, replicas send the query execution information that would normally be stored in the Query Store back to the primary replica" Ref: Query Store for secondary replicas - https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-store-for-secondary-replicas?view=sql-server-ver16

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2019 - Administration
Size of DB on physical disk doesn't match Disk Usage by Table report - Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS report Disk Usage by Table.  The size of the mdf file on my storage drive is close to 37 GB.  The sum of all tables and indexes (columns Data (KB) + Indexes (KB)) on the […]
SSIS Won't Create Log Entries - Hi everyone My SSIS package will not log to sysssislog.  I am not sure what to do to troubleshoot.  Can someone please provide some guidance on what I can do to help fix this? Setup configuration: The configuration manager I use is the same one I use in SSIS when I have tasks that read […]
SQL Server is terminating in response to a 'stop' request from Service error - Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing in logs except this Message SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. please help to find some solution to fix […]
SQL Server 2019 - Development
Update particular record in a table - I need to update greatherthan8 (category) record to Missing (status) if the same member is in different (category) but having same (status) and that also only when they are  compliant. for example 123 PID i have both lessthan8 and greaterthan8 (category) but having same (status) that is compliant so for this member 123 for greaterthan8 […]
SSIS giving "Error converting data type varchar to float" error - issue resolved.
General Cloud Computing Questions
Recommendation required for Ingest, Validate, Transform Client Data - Hi everyone, Our company receives data sets from over 100 clients on a monthly basis. A single file may contain as few as 100 records, while some data sets are split across up to 5 files containing up to 15 million records in total. The client may send few types of files: Inforce, Premium, Claims, […]
Reporting Services
Report Server Configuration Manager - The target principal name is incorrect SSL - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection I am able to log into the SQL Server in SSMS without checking […]
Report Server Configuration Manager - Change Database - SSL Error - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. I'm trying to set the database in the configuration manager and when I click on 'Test Connection' or 'Next' in the 'Change Database' popup box, I get that error. Report Server Configuration […]
SQL Server 2022 - Administration
Third party backup softwares - Hi Team, Can you someone suggest a few good third part backup tools, with good speed? The requirement is looking for a tool that should work without affecting db performance, in a way it should take a snapshot of the database. Ashru
How to take a backup as a .bak file while omitting some tables? - Hi Guys, I'm not sure if this is possible or not, but let me explain my situation. I have a scenario where I need to create a job that takes a backup(With Compression), keeps recent backups, and deletes older ones based on the date. The problem is, my database is quite large, and I don't […]
How do you keep track of the purpose for SQL Logins? - Wondering how others keep track of the purpose for SQL Logins?  I'm not talking about Windows Logins since you can put notes in Active Directory. We have different systems that use SQL logins and I have a hard time remembering what they are used for, such as just upgrades or regular use by the system. […]
Just a rant about the SQL Server 2022 upgrade - Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am so glad we're doing this in our test environment. During the install, got a popup about a missing file C:\Windows\ProPatches\msoledbsql_18.7.4_x64.msi Try again fails, obviously - I have no idea why they even have "try again" as an option, the file is […]
SQL Server 2022 - Development
2022 SSIS PackageFormatVersion? - Recently I upgraded my ssis package from 2016 to 2022, but package format version is showing 8. Is it correct?
Parse XML data from SQL table using temp tables and variables - Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL to parse XML data. This is a daily process that is taking a long time to complete, and the data is not available until the afternoon. I installed SQLXML 4.0 and was able to SELECT nodes from the XML column directly, […]
Internationalisation - Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a product for some time now that had an entirely UK-only customer base. The powers that be now want to flog it to Australia and the ROI. For one reason or another, there are a few places […]
 

 

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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