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

What Can AI Really Do?

I wonder how many of you have tried vibe coding something with an AI tool. If you haven't, I certainly recommend it. I've been a bit amazed with a few of my AI Experiments, including my loading of a lot of inconsistently formatted data into a database for USD$5.

To be clear, there's plenty of vibe coding that might not be production-ready, but have you ever been handed code from a human developer you didn't think was production-ready? Or deployed code like that? Certainly, AI could exacerbate the situation, but it can also spark ideas, ease (and speed) development in small ways, and tackle the backlog of things your org needs.

Especially small tools.

How big a concern or help will this be? I ran across an interesting article from a semi-technical person trying to build a text analysis tool. This is the type of thing we may do as database pros, but we wouldn't have time to service every request for this assistance. There is a mixed bag of success in the piece, and a recognition that software developers have skills and knowledge that AI tools can't necessarily duplicate in the hands of a non-pro.

However, that's where I think software engineers and database professionals have to learn to leverage AI tools to become more efficient, prove their worth, and, honestly, get more done without working longer hours. It's also a place where you might guide users in producing some useful, but less mission critical software for themselves with AI. That might lower the number of requests I get.

To me, that's the direction I want to go with AI. More productive, less stress, and the same (or fewer) hours.

What do you think AI can do for you? Let us know today.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Sanket Parmar from SQLServerCentral

Built the index, but SQL Server still scans the whole table? Learn how to read execution plans and find exactly why your index is being ignored.

External Article

Improve Query Performance in the Fabric Warehouse with Clustering

Additional Articles from MSSQLTips.com

Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.

Blog Post

From the SQL Server Central Blogs - A Redgate Data Modeler Gotcha with Relationships

Steve Jones - SSC Editor from The Voice of the DBA

This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add a relationship and was confused about the behavior. Read...

Blog Post

From the SQL Server Central Blogs - Why Claude?

BLOB EATER from All About SQL

Every major model out there can summarise documents, write code and answer multi step questions – then if you decide to go with a specific vendor based on costs...

Storytelling with Data: Let's Practice!

Site Owners from SQLServerCentral

Influence action through data! This is not a book. It is a one-of-a-kind immersive learning experience through which you can become—or teach others to be—a powerful data storyteller.

 

 Question of the Day

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

 

Distance Metric Algorithms

What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?

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)

Detecting Deadlocks Quickly

In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?

Answer: A variable number from 100ms to 5s depending on the frequency of deadlocks.

Explanation: From the docs: If the lock monitor thread finds deadlocks, the deadlock detection interval drops from 5 seconds to as low as 100 milliseconds depending on the frequency of deadlocks. Ref: Detecting Deadlocks - https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-deadlocks-guide?view=sql-server-ver17#deadlock-detection

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 2022 - Development
BCA KCP Jatinegara Timur Call CSO (+62 821°3111°179 - Call CSO (+62 821°3111°179 Jl. Jatinegara Timur No.37 Pav, RT.8/RW.4, Bali Mester, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13310
BCA KCP Kelapa Gading Raya Telpn/wa (08218171891) - Telpn/wa (08218171891) Jl. Boulevard Raya No.1 Blok L, Klp. Gading Tim., Kec. Klp. Gading, Jkt Utara, Daerah Khusus Ibukota Jakarta 14240
BCA KCP Buaran Raya Call CSO (+62 821°3111°179 - Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13470
BCA KCP Boulevard Timur Telpn/wa (08218171891) - Jl. Boulevard Timur No.54-55 Blok NC 1, Pegangsaan Dua, Kec. Klp. Gading, Jkt Utara, Daerah Khusus Ibukota Jakarta 14240
BCA KCP Pondok Bambu Call CSO (+62 821°3111°179 - Call CSO (+62 821°3111°179 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec. Duren Sawit, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13430
BCA KCP Kramat Jaya Telpn/wa (08218171891) - Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah Khusus Ibukota Jakarta 14130
BCA KCU SEMARANG Call CSO (+62 821°3111°179 - Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
BCA KCU RAWAMANGUN Call CSO (+62 821°3111°179 - Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13220
BCA KCP Kramat Jaya Call CSO (+62 821°3111°179 - Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah Khusus Ibukota Jakarta 14130
BCA KCP Arundina Cibubur Telpn/wa (08218171891) - Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24, RT.2/RW.11, Cibubur, Kec. Ciracas, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13720
BCA KCP Kramat Jati Call CSO (+62 821°3111°179 - Call CSO (+62 821°3111°179 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13510
BCA KCP Pondok Gede Telpn/wa (08218171891) - Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13810
BCA KCP Jatinegara Barat Telpn/wa (08218171891) - Jl. Jatinegara Bar. No.4 C 1, RT.2/RW.4, Wil, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13320
BCA KCU THAMRIN Call CSO:(+62 821°3111°179 - Call CSO:(+62 821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10310
BCA KCU KALIMALANG Telpn/wa (08218171891) - Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren Sawit, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13450
 

 

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

 

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