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

Unreliable Narrators

I listened to an interview with Grady Booch. If you've never heard of him, he has been a software engineer for a long time, developed UML, and worked at IBM and a number of other places. He has devoted his life to improving software engineering. He even told Bill Gates he didn't want to be the Chief Software Architect at Microsoft.

At one point he had a less than flattering description of AI LLMs. Politely, they are unreliable narrators. Less politely, he feels that they allow us to build at a global scale, unreliable BS generators. This is because the LLMs that are stochastic parrots, which can produce some coherent results. Primarily they allow us to navigate a very large lake in space, i.e. the Internet. I think that's true. I have found AIs to be pretty good search engines. Not perfect, but good.

Mr. Booch notes that LLMs, while interesting, are a shadow or a whisper of what humans can do. He's critical of those who think AI is going to compete with humans. Here are limitations on what the tech can do, and Mr. Booch thinks that the approaches people are taking, architecturally, are wrong. As part of his work, he studies more of how humans work and think as a way of trying to build better software architecture.

Caveat, he does think we can build more intelligent systems, but it's not with Gen AI/LLM architectures.

I tend to agree with him and do think that the LLMs are unreliable. They appear to be intelligent, but they are more predictive engines in many ways. They can be very helpful in many ways, but they aren't necessarily replacing smart humans. They might help smart humans replace some other humans, but they are likely to be better assistants than replacements.

It's a great interview and worth listening to. There's a walk-through where Mr. Booch touched on computing as well as a very positive outlook on the future of his career and the things that he is working on. It's long, (1.5 hours), but a fun listen. Give it a go and let me know what you think.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT

Noman072 from SQLServerCentral

Learn how to effectively use SQL Server's data type conversion functions PARSE, TRY_PARSE, and TRY_CONVERT

External Article

How to use @@ROWCOUNT in SQL Server

Additional Articles from MSSQLTips.com

I would like to know the number of rows affected by my SQL Server query. I know this is displayed as a message in SQL Server Management Studio, but I have to check the number of rows in an IF statement to verify if everything went alright. How can I do this in SQL Server?

Blog Post

From the SQL Server Central Blogs - AIs Struggle with Family

Steve Jones - SSC Editor from The Voice of the DBA

This post looks at a logic problem asked to an AI, and which is struggles at finding an answer. This is based on an article noting this question stumps...

Blog Post

From the SQL Server Central Blogs - Cool AI sites

James Serra from James Serra's Blog

As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI and LLMs, Introduction to OpenAI and LLMs – Part 2 and Introduction to OpenAI and...

Refactoring Databases cover

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

 

  Question of the Day

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

 

Counting Bits II

What is the result of this query in SQL Server 2022+?
select bit_count('7')

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)

CHOOSing an Alias

I have this code:

SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;

What is a good name for the column alias?

Answer: SaleSeason

Explanation: The CHOOSE function takes an index as the first parameter, which in this case is the month number. The index is used to pick from the values in the function, which are the seasons of the year. These aren't quarters as the seasons are offset by one month. Ref: CHOOSE - https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-choose-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 2017 - Development
Execution Timeout Expired Error while executing an SQL query - Following error comes while executing an SQL query. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This happens after 30 seconds, even though I have set the Command Timeout property to 300 seconds. Here’s what I’ve already verified: The connection is working fine. I've […]
SQL Server 2016 - Development and T-SQL
Data Joining technique help - Hey All, I'm wondering if there is a different/better way to join the data from these two tables. Please see my sample data and example query below. Cart_id is unique #mytable_main and not in #mytable_Krb2. I need the Field_name and field_values from #mytable_krb2 joined to #mytable_main. Hopefully, what I'm trying to do makes sense to […]
SQL Server 2019 - Development
IF then Else statement not exiting - I have an always on availability group of 3 servers (1 primary and 1 secondary (both on primary site) and the other secondary on DR site, as the only read-only secondary). A scheduled job runs every day that should only execute the tsql if the server is the primary derived from the 'sys.dm_hadr_availability_replica_states',  here's my […]
SSIS Connection Manager Errors - issue resolved
SQL Azure - Administration
Replication from SQL Managed Instance to RDS - Is transactional replication from SQL MI to RDS SQL server supported. There isn't any documentation available from Microsoft. There are a few articles about replicating from Onprem SQL server to RDS or Azure SQL DB to RDS, I couldn't find anything for SQL Managed Instance. If not replication, are there any other options available for […]
Microsoft's comparison to Azure DB vs Managed Instance - I'm migrating to the cloud from SQL Server 2016 to the cloud. On the list of differences between Azure DB and a Managed Instance, there are several features listed, such as DBCC, and DML Triggers where they say that Azure DB has "Yes, most". How can anyone find this as an acceptable answer. Any idea […]
Storage Cost - What will be the storage cost 1 Managed Disk – S15; 256 GB HDD in Azure for DISK it costs around $11.33 per month in addition to that I want to know exact cost for 100IOPs for S15. Also it would be great one can share cost for E15 too.    
General Cloud Computing Questions
Text search emails and other json items - Problably SQL Server is not the best solution What would you use for searching lots of emails / jsons on specific terms? We're trying to provide a solution to business to allow to search if a specific mail is sent Like subject contains X sent around interval. Body contains Y
Reporting Services
Having issues with backing up SSRS for SQL Server 2008 - We have an old server running SQL Server 2008 SSRS. We are in the planning stages of upgrading the Windows Server OS as well as the SQL Server version and need to backup the SSRS database and encryption keys so we can upgrade (same hardware, just in-place upgrades). When I run this rskeymgmt command I […]
Integration Services
"External table is not in the expected format" - Good Afternoon. I have been manually running an SSIS package on an adhoc basis, which populates an Excel file from a SQL Server Table. There is no apparent issue with the package, but often I get the following error: "External table is not in the expected format" And it resolves when I Shut Down and […]
Convert Project model back to package model - What started out as an attempt to use the SSIS Project-model combined with deployment using the SSISDB catalog has been superseded by the requirement to use devops+pipeline to deploy packages from dev to production. This means using direct deployment at file level and converting everything build from project to package. Are there any best practices […]
Backups
Hyper-V VM / Google Drive syncing issue - Hi everyone, I have a server running **Windows Server 2022**, named **"DATA SERVER"**. This server has two drives: **C and D**. What I Did: 1. **Enabled Hyper-V** and created a virtual machine (VM) called **"DATA VM"**. 2. Used **Disk2VHD.exe** to create **VHDX files** of the host machine's **C and D drives** and attached them to […]
SQL Server 2022 - Administration
error when trying to change replication settings - We have three servers that use SQL replication; PROD, BI, and PARTS. We have one database that replicates from PARTS to PROD and we have a around five databases that replication from BI to various Azure servers. We used to have a database called IRES that replicated from PROD to Azure - but we deleted […]
windows services monitor - With no budget for some paid tools to monitor sql server service and sql agent service ; how can we send an email alert when they go down etc..what are the options ? I do not want processes where I have to run some piece of code(t-sql/powershell--I can set this up but is there a […]
SQL Server 2022 - Development
what happens to ssis and ssrs whenb we migrate to sql saas - Hi we know (or believe)  ssas saas gets stood up separately when a company migrates to sql saas. But what happens to ssis and ssrs?  from what i remember there is no such thing as ssis in azure.   And the recommendation on sssrs is to move all those objects to pbi as paginated reports.  we […]
 

 

RSS FeedTwitter

This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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.
[email protected]

 

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