| A community of more than 1,600,000 database professionals and growing |
| | The Creepiness of AI Last year, I watched a keynote talk from Matthew Renze about AI. In his talk, there were examples of the amazing things that Artificial Intelligence can do, as well as some of the creepier things have have been developed. It was an interesting talk, one that gives me inspiration and hope for the benefits of better computer algorithms as well as the concerns for various issues that we may be unprepared to deal with as a society. One of the more controversial items that occurred recently with AI was the Google phone call, where a computer answers a call and interacts with a human. What's disconcerting here is that the person doesn't know this is a computer, and there are speech patterns the computer uses, like um interspersed in the answers, that deceive someone. While this certainly might be helpful in scheduling situations shown in the call, there is a downside. Could you imagine artificial personas used in telephone scams or phishing situations? A help desk knowing some information and then asking for verification of other data? There are perhaps greater concerns, such as the work done with imitations of President Obama. There are fake speeches, generated by computer. While movie studios might want fake actors used to reduce labor costs, do we worry about the implications of a computer actually being able to imitate one of us in a video call? The use of AI and ML, with lots of data an organization might have gathered could be good and bad, but certainly opens the world to more problems than benefits if there isn't mandatory disclosure of the cases where this is used. Since there are always going to be criminal elements that don't obey rules, this might be very scary. There are certainly other issues, such as Target predicting a pregnancy, which was the first really, creepy data analysis thing I saw. That one is a few years old, and still bothers me as it was accurate, but an unrefined use of the data. A good example of where marketing groups are a bit too excited to use AI/ML technologies and don't think through the implications. Fortunately this case seems to have dampened some of enthusiasm for prediction in retailing. Perhaps this item that is a bit funny, but it is also very worrisome for me. It's the case of an AI system playing video games. The AI system decided the best way to get the best score was to pause the game. Rather than compete and try to do better, the computer decided to just stop. A completely unexpected outcome, probably because the feedback and expectations weren't explicit. Since it seems quite often humans don't specify their requirements or expectations very well, I could imagine this being a very large issue in AI systems as they are used more often. It could even be deadly or problematic when a system does something we didn't anticipate, and impacts human health. Most of us won't work with AI much as a technician, other than providing or managing some of the data. I do expect AI and ML systems to touch more and more of our lives, perhaps using our data for good, perhaps not. Hopefully we can help steer applications into the former more than the latter situation. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.7MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. | |
|
|
| ADVERTISEMENT | | How SQL Server monitoring benefits your whole organization SQL Server monitoring doesn’t just benefit your DBAs. In this new guide from Redgate, we take you through the different ways a robust monitoring solution has a positive impact across your organization, from your development teams to IT management, and from finance to your C-suite. Download your free copy now |
| | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
|
|
|
| | | Additional Articles from Redgate Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing. More » |
| Additional Articles from Database Journal A new error message in SQL Server 2019 will make your life much easier!? Learn more... More » |
| meaganl from SQLServerCentral Blogs In case you aren’t familiar, I would like to introduce you to the violin plot. A violin plot is a... More » |
| Bert Wagner from SQLServerCentral Blogs Watch this week’s episode on YouTube. One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)... More » |
|
|
| | Today's Question (by Kendra.Little): You create a new SQL Server database. You check right away, and there is a table in the database named dbo.foo. It has 10 rows of data in it. What is the most likely cause of this? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: Administration. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I run this batch: CREATE OR ALTER PROCEDURE dbo.GetTwo AS BEGIN SELECT 2 AS 'Two' END SELECT @@version GO Now I run this: EXEC dbo.GetTwo What happens? Answer: There are two result sets returned. Explanation: The CREATE PROCEDURE command includes all statements until the end of the batch, so the SELECT @@VERSION becomes part of the procedure. Ref: CREATE PROCEDURE - click here » 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. Domain Accounts for SQL Server Services - Hi I have installed SQL Server 2017 (RTM-CU12) on a server. When installing I used domain accounts that I have used on... BCP usage - Hi All, I am trying to one bcp command I am not able to execute it correctly. I have created below table: CREATE... Help with OUTPUT INSERTED syntax needed - I want to collect a value from the source table of a SELECT statement used in an INSERT statement, that... HOW TO USE EXISTS FUNCTION WITH 3 TABLES - Can you Please show me that how can we use EXISTS FUNCTION WITH 3 OR MORE TABLE. Please show me... Using SQL to update and add records to a database within Excel - I have an Excel file with data in it. I want to use Data tab > MS Query window where... TWO SQL JOIN Problems - I have three Tables which I Joined them , got the duplicate result as I had unique Document No. Present in slbReceivablesTrx... WHERE Clause exclusions, best practices. - Hello, I was just wondering if anyone has a good idea on how to implement a set of filters that we... SQL Service Start before App DBs Drives on line - What happens if SQL starts up from C drive, but it takes 5 minutes before the E and F drives... SSIS service account password change - hi we're going through a password change policy - to make things more complex. Only 200 to change. SQL service accounts - easy... recreate a Basic Availability Group question - hi, In the process of changing IPs for one node of a clustered server with databases in a Basic Availability Group... DBA left and they shut off his AD account - Our DBA left and they shut off his account. Of course, things started failing all over the place so I... Why would SQL Server not run? - I've got SQL Server 2016 Developer Edition installed on my desktop. I don't get in it frequently, I'll admit. However,... how to join tables with key combinations? primary vs foreign - In SQL, how do I join tables with keys. I mean...can I do a join on the following.. 1. primary key... Connecion Issue's to a SQL Instance - Hi, Recently we started experiencing connection issues for a specific Instance on a server where multiple instances are present. This is... Need counts of orders per week grouped by week - Hello Everyone, I hope someone can help me out with this. I have an order table that stores order information. SQl 2014 Database records have bad data how to clear - SQL 2014 Cluster 2 Nodes on Windows 2012 R2 Server both are VMs on ESXI 6.5 Hosts all working well. I have... Help With Database Normilization - SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE .( NULL, (255) NULL, (255) NULL, (255) NULL, (255) NULL, (255) NULL ) ON... How does the target table size impact the insert performance - I have a target table which is incrementing with 2 Million records every day from the past 30 days. Earlier... Is Power BI Desktop only for enterprise users? - I realize that this forum isn't for Power BI. I couldn't find a forum that is. So, here goes. I... Overlapping Exams - Morning Guys, I am considering doing the MCSE/MCSA in various SQL Server subjects. I noticed that some of the MCSA exams... |
|
| 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. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|