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

Assistants in the Age of AI

When I started working for a living, there were secretaries in many organizations. These were people who actually did a lot of correspondence (written or verbal) and busy work for managers or executives. Over time, as email and computers became commonplace on desks, I saw fewer of these positions. As more people started to send email, we had to actually alter software to allow assistants to impersonate their bosses and manage the volume of communications that many of us deal with.

We're in a new age of assistants with the emergence of Generative AIs powered by LLMs that can appear to respond in a conversational style to requests and perform actions on our behalf. In this new era, will AIs function as old-style secretaries, handling simple, but important tasks? Are they the trusted helpers that secretaries used to be for many executives? Are we all going to have an assistant, and do we want one, or need one?

There was a post on the role of AIs in this new world, and their ability to not only be a cheap, reliable assistant for many of us, but also a powerful tool for those that still have personal assistants helping them manage their workload. However, it's not a tool that takes the place of a secretary, for many reasons mentioned in the post. It's just a tool that can help manage some work, but isn't really intelligent, empathetic, or able to discern subtleties that come from the context of the humans involved in a situation.

In many ways, that's what I see for Copilot-like AIs used by technical people. They are assistants, and they can help with tasks, but with general, tedious, common tasks. They are a better search engine, and they can handle small tasks, but they aren't replacing talented people, and they certainly don't always understand enough of the context of a particular situation. If a general or common solution works, AIs are good, but in terms of being efficient and optimal when solving subtle, complex problems, we still need a human to guide the AI and assess whether the response is appropriate.

I am both enamored by AI, but also very skeptical that the technology will do more than provide faster searching for information and light guidance of options. Perhaps I'll be proven wrong, but I think that continuing to improve your own judgment while learning through experience will ensure that you not only are more valuable than an AI, but that you can use one effectively as a tool. A useful assistant, but one that you know to overrule when appropriate.

Steve Jones - SSC Editor

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

 
 Featured Contents
Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN

Greg Larsen from SQLServerCentral.com

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.

External Article

Top-Down and Bottom-Up Approaches in Microsoft Fabric

Additional Articles from SimpleTalk

Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to be used in lakehouses or data warehouses. One major question that arises is, “should we use a top-down or bottom-up (or both) approach in Microsoft Fabric?

Blog Post

From the SQL Server Central Blogs - Foreign Keys in SQL Data Generator

Steve Jones - SSC Editor from The Voice of the DBA

A customer recently asked about using FKs in SQL Data Generator, and I decided to write a short post showing how these work. The Scenario I’ve got a copy...

Blog Post

From the SQL Server Central Blogs - How Redgate’s Test Data Manager Can Enhance Automated Testing

Chris Yates from The SQL Professor

A brief overview of the benefits and challenges of automated testing and how Redgate’s Test Data Manager can help. Automated testing uses software tools to execute predefined tests on...

Transact-SQL: The Building Blocks to SQL Server Programming eBook by Gregory A. Larsen

Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen

Greg Larsen from SQLServerCentral

Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by SQL Server Central and Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.

 

 Question of the Day

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

 

Avoiding Exchange Operators

Which type of query processing mode can operate on compressed data and avoid the exchange operator?

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)

Logical Operators

I have this table and data:

CREATE TABLE ProdList
(ProductID INT NOT NULL
, ProductName VARCHAR(100)
, ProductCategory VARCHAR(40)
, ProductSize VARCHAR(4)
, ProductColor VARCHAR(20)
)
GO
INSERT dbo.ProdList
  (ProductID, ProductName, ProductCategory, ProductSize, ProductColor)
VALUES
  (1, 'Dirt Bike', 'Bike', '26', 'Blue'),
  (2, 'Mtn Bike', 'Bike', '26', 'Red'),
  (3, 'Dirt Bike', 'Bike', '24', 'Blue'),
  (4, 'Downhill', 'Ski', '180', 'White'),
  (5, 'Telemark', 'Ski', '175', 'Blue'),
  (6, 'Snowboard', 'Ski', '182', 'Various'),
  (7, 'Goggles', 'Ski', 'L', 'Clear')

How many rows are returned from this code:

SELECT productid, pl.ProductName
 FROM dbo.ProdList AS pl
 WHERE pl.ProductCategory = 'Bike'
 OR pl.ProductCategory = 'Ski'
 AND pl.ProductColor = 'Red'

Answer: 3

Explanation: This code returns 3 rows, all from the bike category. The precedence of logical operators means the AND is executed before the OR, which means the query is equivalent to this:

SELECT productid, pl.ProductName
 FROM dbo.ProdList AS pl
 WHERE pl.ProductCategory = 'Bike'
 OR (pl.ProductCategory = 'Ski'
     AND pl.ProductColor = 'Red')

Ref: Operator precedence - https://learn.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql?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 2016 - Administration
system_health configuration - I'm on SQL Server 2016 (SP2-CU11-GDR) (KB4535706) - 13.0.5622.0 (X64) Dec 15 2019 08:03:11 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor) Is there a way to change the lock timeout in System_Health GUI?  In the u_table.sql it looks like it's seto […]
SQL Server 2012 - T-SQL
row changes per hour by TagID - I have a large table being written too every second with equipment (PLC) information. I need to figure out how much of this data is redundant using an hour window, so from 7am-8am how many different values did I capture per Tagid(Machine). I'm trying to figure out for floatvalue how many distinct values where recorded […]
row changes per hour by TagID - I have a large table being written too every second with equipment (PLC) information. I need to figure out how much of this data is redundant using an hour window, so from 7am-8am how many different values did I capture per Tagid(Machine). I'm trying to figure out for floatvalue how many distinct values where recorded […]
SQL Server 2019 - Administration
Can CDC replicate data? - As far as I can tell all CDC does is capture and log data changes, can it also replicate like transactional replication?
Linked Server Connection Issue - Hi all, I have 2 SQL servers on different domains (lets call them SQL-A and SQL-B), network connected via IPSEC vpn. DNS is not yet set up between the two networks, so I have amended the hosts file on SQL-A. On the machine running SQL-A, I can use SSMS to connect to SQL-B successfully. I […]
High availability group synchronization - For high availability group, is there an option like transaction log shipping that I can choose the interval of time to synchronize the database. So for example  ,   delay it to 30 minutes to synchronize. Thanks    
SQL Server 2019 - Development
Sending messages on table rows updates/inserts/deletes to RabbitMQ from SQL Srvr - We have a requirement here. Whenever certain rows in a table are inserted, updated or deleted, we need to send messages to a message broker for further processing. Currently we are using triggers and SQL Server Service Broker for this purpose. But we want to use RabbitMQ for scalability and wider reach. Is there a […]
Indexing strategy very long text strings - Hey guys,  Just looking to see if anyone has any bright ideas how to solve this problem. Background I have been handed down a project to report on files that have gone 'missing'.. Ignoring the fact that are using the wrong tools for the job... I have a process which effectively writes the resutlts of […]
Frustrated trying to get Cross DB Access by Signing SP with Certificate - Maybe it is lack of caffeine, but I cannot see why the following test code does not work. I keep getting: Msg 916, Level 14, State 2, Procedure dbo.TestTrunc, Line 7 [Batch Start Line 92] The server principal "XDBSignTest" is not able to access the database "db2" under the current security context. Can anyone see […]
SSIS Execute Package Fail in SSMS but Agent Job Succeeds - Hello, I created a SSIS package to transfer data from an XML file to a  database in SQL Server instance A. It works perfectly in Visual Studio. Then the SSIS package was deployed to SQL Server instance B. When I set up a SQL agent job and run as a proxy user "svcSSIS", it works […]
Integration Services
Not picking up a specific period - Please assist. I am trying to bring in Period 8 which i find myself in. Its available in the data. I just cant seem to bring it into the ETL. Source and SSIS is attached.
Business Intelligence
How to merge first 3 rows when exporting to excel - Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named […]
How to merge first 3 rows when exporting to excel - Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named […]
How to merge first 3 rows when exporting to excel - Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named […]
SQL Server 2022 - Administration
SQL Server UCP - Hello everybody, I just read on the Microsoft homepage that SQL Server Utility Control Point is still available in SQL Server 2022 Entertrise Edition (https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16). I couldn't find it in the SSMS what so ever.
 

 

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

 

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