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

Everything is the right question away

When I was young and needed to learn about something, I had to go to a library or a bookstore to get information. I often started by looking through an encyclopedia. I had to wander between entries to learn more about the topic I was researching. A few lucky friends had their own copy of an encyclopedia, which was nice since we could research at home. At some point these collections of information were moved to CD/DVDs, which made them more portable and more accessible to a larger group of people than in the past.

In the 90s we had the innovation of search engines, which allows us to more quickly move through information. There was more information available on the Internet than was ever published in encyclopedias. Over the years, these search engines improved their ability to rank and recommend information that is relevant to your query. However, you still need some idea of what you are trying to learn about. You have to direct the searches, although the Google auto-complete felt very predictive at times.

However, I heard a quote recently that is the title of this piece: everything is the right question away.

That might seem like something a search engine or even an encyclopedia would help with, but consider the fact that with an AI LLM you don't have to specify much at all to get started. You can even ask it the question of how do I do/learn/find something and get a result that seems better than any computer system in the past. It might be better than what you get from most humans as well.

Of course, you might not get the answer you want or need, though you can continue to ask the LLM and refine what you need. What's even better is that once you get a good answer, you can shortcut the route to that knowledge by asking the LLM to provide you with a better prompt to get you to the place you end up in faster.

Asking the right question to get an answer is an age-old human problem. Philosophers and religious figures have debated and hinted at this for centuries. You still need to build strong communication skills to ask a clear question and some expertise to judge the results. AI LLMs, however, make this a much easier and quicker process than at any time previously in human history.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Vectors in SQL Server 2025

Daniel Calbimonte from SQLServerCentral

Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]

External Article

SQL Server Concurrency Issues with Parallel Query Plans

Additional Articles from MSSQLTips.com

Parallelism can reduce concurrency. This is a strong reason not to allow SQL Server to execute queries aggressively in parallel mode. In this tip, I will set up a demo to show that parallelism reduces query performance on a server with high concurrency.

Blog Post

From the SQL Server Central Blogs - AI: Blog a Day – Day 7: Vector and Vector Databases

Vinay Thankur from Vinay Thakur

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...

Blog Post

From the SQL Server Central Blogs - ADF Pipeline Debugging Fails with BadRequest – The Sequel

Koen Verbeeck from Koen Verbeeck

A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

 Question of the Day

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

 

Odd Sequences

What values are returned from this code?
CREATE SEQUENCE NumericSequence
    AS NUMERIC(5,1)
    START WITH 1.0
    INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO

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)

Identities and Sequences I

When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?

Answer: Both can be linked

Explanation: Both can be linked. The identity property is assigned to a column in a table. A sequence can be bound in a default as shown here:

CREATE TABLE dbo.IdentityTest
(
     id INT IDENTITY(1,1) PRIMARY KEY,
     id2 INT DEFAULT (NEXT VALUE FOR IdentityTestseqeuence),
     somevalue VARCHAR(20)
)
GO

Ref:

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
Windows logins for users migrated from DomainA to DomainB - Hi, I have a SQL Server instance where users connect to via Windows Authentication, so for each user there is a row in sys.server_principals with (as example) "DomainA\JohnDoe". Recently a lot of users were migrated to DomainB (same forest) using the ADMigration wizard. Although I haven't created a new "DomainB\JohnDoe" login, this user is still […]
SQL Server 2019 - Development
how to write this query? - Hi everyone I asked this earlier but the desired outcome is a bit different this time so I am starting a new post.  I would like to transform the source table into the desired outcome format.  How can I do this? Desired Outcome: Sample Data: drop table if exists #temp1 create table #temp1 ( report_run_time […]
would it be so terrible to install ssms on a few user desktops? - Hi, ssms is free here.   I can think of other reasons to do this but i would like to install ssms on the desktops of a FEW users who already know, or have the aptitude to learn sql.   and are willing to be limited to very small "governed" datsets. We have excel sprawl from 2 […]
Editorials
Breaking Down Your Work - Comments posted to this topic are about the item Breaking Down Your Work
Multiple Deployment Processes - Comments posted to this topic are about the item Multiple Deployment Processes
A Full Shutdown - Comments posted to this topic are about the item A Full Shutdown
I'm thinking about submitting some articles - I've written some documentation on using different Markdown types of files on GitHub. It's a series of documents. Some of them are long, but others are short. Anyway, what I don't know is if I should just submit them as separate articles or if they would qualify as a Stairway. Would someone with SQL Server […]
Not Just an Upgrade - Comments posted to this topic are about the item Not Just an Upgrade
Article Discussions by Author
Restoring On Top II - Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text) - Comments posted to this topic are about the item SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases - Comments posted to this topic are about the item How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Upgrading Admin Queries - Comments posted to this topic are about the item Upgrading Admin Queries
OPENQUERY Flexibility - Comments posted to this topic are about the item OPENQUERY Flexibility
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform - Comments posted to this topic are about the item Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
SQL Server 2022 - Administration
XACT_ABORT being set to ON by web services - We have two "identical" instances of an ASP.NET web service (or so I have been told), that are connecting to databases that are also reasonably identical, running on separate instances of SQL Server 2022. For some reason, XACT_ABORT has been found to be set to ON with one of the web services, but not with […]
 

 

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

 

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