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

A Quick Second Opinion

I saw this article and thought, surely there's nothing I could use in here: 10 Best AI Prompts for Everyday Tasks. Quite often, when these articles appear, they are very high-level and contrived examples of things that I rarely find myself doing.

So I clicked the link.

For most of the prompts, I didn't think these were the types of things that I do often, nor were the prompts useful. I'm rarely looking for AI to draft emails or perform some of the simple creative things. I'm not sure these are big burdens on time for others, but perhaps I'm wrong. I know many people struggle to build plans or rewrite things, but I do those often and have gotten good at them. I tried using an LLM, but it wasn't helpful. I do sometime ask Claude to turn things into checklists because I'm being lazy, but getting the things organized is usually the hard part. Pasting them into Word/Powerpoint and changing the bullet format is easy.

If anyone finds value in these items, and you should try them, that's great. I find an LLM to be a great quick assistant that can do something for me while I move on to another task. If you struggle to get drafts started, or you need a second opinion and don't want to call/slack/message/text/etc. a friend, use an LLM. I don't know using an LLM like this provides an ROI, but it definitely prevents your blocker from interrupting others and forcing them to context-switch to respond to you.

I found another article on prompts for professionals, which has other prompts that might help you get that second opinion. Perhaps you can use these in technical ways, asking for an evaluation of your algorithmic approach or your message to co-workers. If you find them valuable, or you try them in a situation, let me know. Leave a comment. This AI stuff is new, and we can help each other learn.

If nothing else, experimenting with an LLM will teach you about communication and how clear and direct you are being with your assistant. Do a poor job and the LLM often won't quite give you the results you want. Get something back that you can use? Examine how well you communicated to the assistant. Many of us can improve here, and learning to be clear and concise with an LLM will also aid you in those communications you send to other humans.

 

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload

vgupta from SQLServerCentral

Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload.

External Article

How to call an Ollama-based AI text embeddings model from SQL Server 2025

Additional Articles from SimpleTalk

Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint

Blog Post

From the SQL Server Central Blogs - Fabric for Operational Reporting & SQL Endpoint Trap

Joyful Craftsmen from Joyful Craftsmen Blog

With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting build entirely in Fabric where you can have almost live data in reports. The pitch...

Blog Post

From the SQL Server Central Blogs - No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another...

SQL Server 2022 Query Performance Tuning

Grant Fritchey from SQLServerCentral

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

 

 Question of the Day

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

 

Checking the Error Log I

On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?

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)

TempDB Facts I

Can I set Accelerated Database Recovery on tempdb?

Answer: Yes, but only on SQL Server 2025+

Explanation: Yes, but ACR is only supported on SQL Server 2025 +. Ref: tempdb - https://learn.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-ver17

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 2017 - Administration
ALAMAT BCA KCP Ampera Tlp:08218154393 - WA:08218154393 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12560
SQL Server 2019 - Administration
ALAMAT BCA KCP Mayestik Tlp:08218154393 - WA:08218154393 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12120
Editorials
Is Fabric a Reliable Service or a Ripped Resource? - Comments posted to this topic are about the item Is Fabric a Reliable Service or a Ripped Resource?
I Want to Use My Brain - Comments posted to this topic are about the item I Want to Use My Brain
Spending Time in the Office - Comments posted to this topic are about the item Spending Time in the Office
What is the Cloud? - Comments posted to this topic are about the item What is the Cloud?
Article Discussions by Author
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About - Comments posted to this topic are about the item SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About, which is is not currently available on the site.
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values - Comments posted to this topic are about the item SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
BIT_COUNT I - Comments posted to this topic are about the item BIT_COUNT I
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments - Comments posted to this topic are about the item Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Multiple Values Inserted - Comments posted to this topic are about the item Multiple Values Inserted
Extreme DAX: Take your Power BI and Fabric analytics skills to the next level - Comments posted to this topic are about the item Extreme DAX: Take your Power BI and Fabric analytics skills to the next level
SQL Server 2022 - Administration
ALAMAT KONTAK BCA KCU SCBD Tlp:08218154393 - WA:08218154393 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman Floor 9, RT.5/RW.3, Senayan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12190
SQL Server 2022 - Development
locking down agent for new user on our dev machine - hi , a new user wants to be able to add sql agent jobs on our dev machine.  i stood up a db there for him and will make sure his rights are on that db only.   how can i give him rights to set up and run agent jobs but with the constraint that […]
Finding 'bad' characters - Hi All I am trying to find 'bad' characters that users might type in. My query is finding them as expected, but the results include records that I think my query should not return. Here is my query select NOTES  , ascii(left(NOTES ,1)) from trip with(nolock) where (patindex('%[^ !-~]%' collate Latin1_General_BIN, NOTES ) > 0 […]
 

 

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

 

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