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

The AI View From Above

It likely isn't a surprise to many of you that executives like AI. A survey shows that 74% of executives surveyed have greater confidence in AI-generated insights than advice from colleagues or friends. At the board level, even more (85%) favor AI-driven advice.

That's amazing to me, and while I might think this is a bit too much trust being placed in these GenAI LLMs, perhaps it's also partially because they work with too many people who aren't great at their jobs. Plenty of people skim through data or focus on certain things and might miss the details. While an AI can read and summarize a lot, it might not have the context we expect. I tend to be a bit skeptical of AI summaries, often because they don't necessarily weigh the different parts of an article the same way that I do. However, they can be helpful.

Even more interesting, 44% of executives say they would trust a GenAI to override their decisions based on insights, and 38% would trust AI to make decisions on their behalf. Business decisions based on data, or conclusions from a lot of inputs are different than producing working code, so I don't know how accurate these models might be in this context. I do know that I want experienced people reviewing and judging GenAI outputs, and I would not allow an AI to override me without my input.

However, I wouldn't just discount a GenAI recommendation. I tend to have strong opinions, but loosely held. I'll change if there is evidence or a good argument to do so. It's possible a GenAI might see things I miss and produce an insight that gets me to change a decision.

What's a bit scary about the stats from this survey is that many executives see a skills gap in their staff, and their trust in GenAI might lead them to replace or augment existing staff with more GenAI tools. They might expect hiring can be delayed or slowed (or eliminated) with GenAI filling gaps. This might be especially true as many tech companies talk about how GenAI tools are making them more efficient.

That means that tech professionals should consider a few things. First, learn to work with GenAI tools and use them to prove your value to an organization. This includes learning when not to use them. Second, continue to improve your skills to ensure you can judge Gen AI results and emphasize that you are still the expert. Lastly, as the technology improves, consider adding some skills in how to train an AI to be a better assistant for you. The more efficient you are, especially with a GenAI helper, the more likely you are to impress executives and managers that are choosing which staff to keep.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Helpful Management Studio Settings and Features

Tony Savoie from SQLServerCentral

Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.

External Article

Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security

Additional Articles from MSSQLTips.com

In Part 2, we shift our focus to securing containerized deployments and cloud infrastructure. We will cover Kubernetes security hardening, real-time monitoring, infrastructure as code (IaC) security, and shifting security left to catch misconfigurations early. These strategies will help your team secure workloads in production and respond to potential threats before they lead to a security breach.

Blog Post

From the SQL Server Central Blogs - SQL Server Engineering in Austin

Steve Jones - SSC Editor from The Voice of the DBA

I was lucky enough to attend SQL Saturday Austin 2025 a little over a week ago in conjunction with some work at the Redgate office. The opening keynote at...

Blog Post

From the SQL Server Central Blogs - Using Cron in Postgres Flex

hellosqlkitty from SQLKitty

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It allows you to schedule PostgreSQL commands directly from your database, similar...

The Phoenix Project

The Phoenix Project: A Graphic Novel about IT, DevOps, and Helping Your Business Win

Site Owners from SQLServerCentral

Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.

 

  Question of the Day

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

 

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

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)

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

Answer: For torn page protection, an exclusive latch is used. For checksum, an update latch is used

Explanation: Torn page protection requires an exclusive latch, preventing other threads from reading. Checksum uses an update latch, which allows other threads to read, but not modify. Ref: How SQL Server writes a modified data page - https://learn.microsoft.com/en-us/sql/relational-databases/writing-pages?view=sql-server-ver16#how-sql-server-writes-a-modified-data-page

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
SSPI handshake failed error code 0x80090311 - Hi, I have a workstation with SQL Express 2019 installed and I have a PC with a .NET application built in VB.NET. The App logs in as Attendance and the SQL PC logs in as Phone System. They are on the same domain and the SPNs match the server and Attendance has access to the […]
SQL Server 2019 - Development
Merge spans with Dates Logic - --for a given member if the startdate and endate is continous we need to keep in single record and if start date and end date is not continous i need to keep in separate record for a given member.   drop table #test create table #test (ID int, startdate datetime, enddate datetime ) insert into […]
Problem creating a Linked Server to MS Access 97 database from SQL Server 2019 - Hi there I need help on creating a Linked Server to an MS Access 97 database from a SQL Server 2019 express instance. We have a SQL Server Express 2019 instance and we are trying to create a Linked Server to an MS Access 97 database located on a network drive. Now I know that […]
continuous membership - Hi, I am trying to find everyone who had membership for a continuous year without any gaps. The sample below shows two members, one who is correct,760890291, and should be returned but the other one, 82928404, should not but it does. My code is below. What would I need to change? Thanks.   CREATE TABLE […]
SQL Azure - Administration
Azure Managed Instance Backups - Could Backup Be Completely Lost? - Some of our more regulated customers (banks, gambling sites and suchlike) like to know that we have a robust and tested recovery routine. We use Azure Managed Instance (MI) and the backup/restore process for 'normal' requirements is quite simple. But this had me thinking - is it possible for Azure to be in such a […]
DP-300 exam - Hi, I would like to know if anyone has taken the DP-300 exam recently, so that they can recommend some material for me to study. The company I work for has taken on a project and I need to get this certification as soon as possible. Thank you.
cleanup/dropping of all interimtables - Is there a [best] method of dropping all interim tables within a Azure SQL database.  I have inadvertently, with some pipeline fails, created an awful lot of them. If there is a way to do this in one query it would be really helpful.
Reporting Services
Multiple value Parameters in SSRS connecting to Teradata returns error - I am connecting to Teradata using SSRS and have multiple parameters, many of them that seek multiple values. The challenge is all these parameters may not be always filled, sometimes it could be blank. So I am using a logic as below - Select * from Table Where (Param1 in (?) or ? = '') […]
Integration Services
SSIS Automatically Coverting a NULL to a Blank Space - Hello, I was wondering if anyone knew how to prevent this issue I am experiencing. I have a SQL Source with a query that is just selecting data where fields are casted as a varchar value. When running the query in SQL Server, the values either have a valid value or are null as expected. […]
how to export clickable urls in excel from SSIS - I'm using ssis to copy excel file from a template, and update some cells on each copied files. problem is that after generating the Excel filen when opening it, the cell that is supposed to contains the clickable url is still I have to select the cell, then click on the formula bar and then […]
PostgreSQL
Need query help - MAX record - Hello - I have attached a Word document here with details about my issue. I have shown an excerpt from the main table in the first section.  There are 5 different records for the subscriber in question. The second section shows how the MAX command restricts the output to 2 records.  This output makes sense. […]
Need query help - MAX record - I am having trouble writing linking the MAX query that I created back to the table to produce other data elements about the MAX record.  I have created a Word document showing an excerpt from the main data table, how the MAX query pulls in the appropriate records, but then I am stumped on how […]
SQL Server 2022 - Development
Merge data from two different source until the data is available from both sourc - I have two sources , one coming from datalake and another is file. we need to match date to combine both dates. But , the data from source may not be avilable daily or might be delayed. So, we have data from datalake coming daily but data from file comes only from Tuesday - Saturday […]
Migrating data from using ManagerId to HierarchyId - I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id] [smallint] IDENTITY(1,1) NOT NULL, [FirstName] [nvarchar](50) NOT NULL, [LastName] [nvarchar](50) NOT NULL, [LineManagerId] [smallint] NULL, [OrganisationLevel] [hierarchyid] NULL ) ON [PRIMARY] GO LineManagerId is a FK to the People.Person table to identify the person in the table who is the Person's […]
Parse SQL XML column into dynamic temp tables - Hello SSC, I hope everyone is happy and healthy and ready for spring! I am looking for some alternatives to parsing an XML column in SQL. I have over 1000 rows in XML format that I would like to parse one time into a SQL table or multiple SQL tables. The caveat is that the […]
 

 

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]

 

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