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

The Era of Cloned Humans

AI-technologies are evolving at an alarming rate. The ability of LLMs to produce drafts, review work, even write some code continues to improve to the point where junior level workers are in danger of having less opportunity than in the past.

Perhaps even more alarming is the ability of AI technologies to mimic what they find in the real world, which can include voices. As with any technology created to make the world better, criminals will find a way to use it for nefarious purposes. This article notes that the FBI has warned families to have a secret word or phrase, as criminals are using AI to clone the voice of a family member asking for financial help.

Can you imagine getting a call from your spouse, parents, or children, saying that they're in trouble and need some money right away? With AI tech, the voice could even respond to your questions, mimic anxiety or distress, cry, or who knows what.

Last year Microsoft announced a text to speech technology that can closely simulate a person's voice with just 3 seconds of audio. I'm sure that capability has improved in a year and soon we may not be able to trust the voices we hear. We certainly can't trust the photographs we see, something that we enjoy when we see artists photoshop images for fun, but when we look at an image  in the news, we want it to be real, but we can't trust that an organization hasn't manipulated a photo. When anyone could simulate another's voice, things can go wrong quickly.

I assume the ability to fake video in real time is coming soon. With enough hardware and some imagery, I would guess AI models will be able to hold a Facetime-type call as a human, fooling most people that might not know the person extremely well. At some point, since all our images and video are digital anyway, I assume that without some security measure, the tech could likely fool almost everyone.

Even as I write this I doubt how well the quality is, but I'm sure that it will continue to improve to the point where we might be loathe to trust remote interactions. This has the potential to be a security nightmare for some people, and I worry about the scams and losses criminals will inflict upon the unsuspecting.

This is one type of technology whose negatives will far outweigh the positives.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE

Noman072 from SQLServerCentral

Learn how to quickly and efficiently attach multiple SQL Server databases using the undocumented DBCC CHECKPRIMARYFILE command. Automate the process with minimal effort, saving time and reducing errors.

External Article

Add and Subtract Dates using DATEADD in SQL Server

Additional Articles from MSSQLTips.com

Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.

Blog Post

From the SQL Server Central Blogs - Removing the REST Endpoint in the Data API Builder

Steve Jones - SSC Editor from The Voice of the DBA

The more I work with the Data API Builder (DAB), the more I lean towards GraphQL instead of REST. Rest isn’t bad, but it’s tough. This is part of...

Blog Post

From the SQL Server Central Blogs - 15 Characters or Less: The Challenge of SQL Server Listeners Name

SQLPals from Mission: SQL Homeostasis

15 Characters or Less: The Challenge of SQL Server Listeners Name

There is a hard limit on how long your AlwaysOn listener name can be. That...

T-SQL Fundamentals

T-SQL Fundamentals

Additional Articles from SQLServerCentral

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

 

  Question of the Day

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

 

The AG Synchronous Replicas

In a SQL Server 2022 Enterprise Edition AG, how many replicas can be configured with synchronous commit mode?

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)

Counting Bits

What does the BIT_COUNT function do in SQL Server?

Answer: This returns the number of 1s in a binary version of a number

Explanation: This function returns the number of bits set to 1 in the binary representation of a number. Ref: BIT_COUNT - https://learn.microsoft.com/en-us/sql/t-sql/functions/bit-count-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
Symmetric Key EncryptByKey returns NULL value - I haven't used column level encryption because usually the vendors I deal with have .dlls to do that work. But now I have a dev working on this and having issues in one specific environment. Because the code works in the other environments, I feel like the issue is more about something missed in Symmetric […]
SQL Server 2016 - Administration
SQL Clustered Resource in online pending for about 3-5 mins before coming online - Hello! SQL Clustered resource used to come online during manual or automatic failover in less than a minute but now it is taking about 3-5 mins. What could be causing it? Thanks in advance.    
SQL Server 2019 - Administration
PK violation in replication but only one subscriber - We have a publication with three subscribers; it's basically a part list with around 1.2 million rows.  The local table is on a SQL Server 2019 instance, and is updated nightly via a MERGE statement from a larger part list.  This table and several smaller ones are replicated via Transactional Replication to three different Azure […]
orphaned users in sys.sysusers - Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility to delete those entries? With DELETE ... we got this error: "Msg 259, Level 16, State 1, Line 4 Ad hoc updates to system catalogs are not allowed." And further it is not possible with the reconfigure option. Thanks Kind regards, […]
SQL Server 2019 - Development
SQL Query to use in MS SSRS server to give you your report structure. - Code that can be used in order to create dashboard or SSRS report on report statuses based on Report Structure that can be used to be filtered.   /* Created By: wolfsvein Create Date: 2025-01-17 Details: Used to see distinct list of Report Folder Structure. Revisions: Version By Notes 1.0 wolfsvein Created */ SET TRANSACTION […]
Temp table security - So, I have an interesting situation that I need a double-check on. One of my coworkers (who is no longer at the company so I can't ask him) advised some users on a PII security situation that doesn't quite make sense to me. App team creates global temp table for a job that does "stuff" […]
TDE for multiple databases and severs - We are self hosting sql servers, we are not using Azure for sql servers. and we would like to do encryption on data that is at rest for multiple sql servers that has multiple databases. I understand using TDE includes Encryption for data files and backup files. My question is since we have multiple servers […]
Azure Data Factory
Sending SQL Query Result via an Email in ADF - New to Azure Data Factory, and as a starting point, we're trying to see if we can use it to to run some of the menial tasks. We have a couple of SSIS jobs that we'd like to get rid of and ADF is being pushed as a likely replacement. One such task requires it […]
Powershell
search text files for multiple keywords - How can I modify this script to do a couple more features. 1) process only the most current file from the folder. 2) if I find 4 occurrences of the word FULL in that most recent file .. then issue an email many thanks to the people in this forum. # Define the path to […]
Integration Services
Replace OLEDB source editor task with a powershell script - I want to replace all the oledb source editors as shown below with powershell script tasks that execute sql queries.  Please give me some inputs on how to construct the powershell script so that it will a replacement for all the oledb source editor task   so the powershell script could be something like below […]
How create a Google bigquery connection manager in SSIS - Hi So I have created a system dsn to google bigquery data warehouse. However I am not able to figure out how to add a connection manager in the ssis canvas using this Datasource? Can someone guide on the bigquery connection      
SQL Server 2022 - Administration
Recovery Takes 10-20 mins with ADR enabled - Hi Experts, I have database about 300GB in size with ADR enabled but after every failover\restart it takes about 10-20 minutes to come online. The database have multiple files and the tables are all partitioned. Can anyone shed some light on this ?   CREATE DATABASE [LogsDB] CONTAINMENT = NONE ON PRIMARY ( NAME = […]
Searching a Form (using "Find") after an Access to SQL Migration - I have completed a successful migration of an access database to SQL Express. Most things work fine in Access except when in a "Form" and using "Find" (CTRL+F) in a field & doing a search. It takes forever (over 5 mins) & in some cases crashes the database totally. Is all the users need to […]
AlwaysOn Standard o Enterprise edition - Hi everyone, I need advice from the experts, this is the structure I created for testing and it works wonderfully: AWS Balancer that serves 2 Windows server instances (on 2 different datacenters) -Server 1 EC2 c5.2xlarge with our application + SQL Server Evaluation. -Server 2 EC2 c5.2xlarge with our application + SQL Server Evaluation. the […]
SQL Server 2022 - Development
Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv - SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure works 95% but it occasionally generates overflow errors (BEX64) in the Windows event log. In the Event Viewer we have an Information Event 1001 from Windows Error Reporting (Event name BEX64  and SQLException64). What's strange is that this indicates that there […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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