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

The AI Manager

One of the advantages of a computer is that it will handle repetitive tasks very well. That's one reason the DevOps world pushes for automation of simple tasks, like compiling code or copying files between machines. We know the software will perform the task the same way every time, giving us a reliable, repeatable process. Even in many AI systems, the structure of the program ensures some level of reliability, though the actual actions or results may vary dramatically based on the inputs.

For some tasks, this is great. If we have a system watching for a change in code to rebuild the application, that's certainly a job for a computer rather than a human. If a sensor needs to be checked and an action taken if it exceeds a value, certainly the watching ought to be done by software, though the actions may or may not be something we want a system to do without human input.

In some sense, I likewise think that the use of AI to manage workers is a bad idea. This was something I read about in Manna, which seemed exxagerated when I first perused the story. Now it seems that some of this is coming true in this story about workers in a call center being manager by an AI system. There is a software on their machines that tracks their activity, the way they interact with customers, and more. If there are potential problems, the software tries to give them messages about how to alter their behavior. Many employees aren't bothered by this, but I wonder if that will be the case over time, especially if this software starts to affect employment and pay decisions.

I think this is micromanagement at a level I'd never want to work under. I know that some of these jobs are akin to factory jobs that make widgets, with employees doing the same thing over and over again. However, there also is some creativity and thought required, otherwise I'd assume an AI could just do the whole job. That might be coming, and I wouldn't be surprised to see it, but as long as humans are working here, there ought to be plenty of human oversight.

Could you see this in our industry? Maybe AI reminders that you're slow to close a ticket, or not committing enough, or even that you're not doing enough testing. It's crazy to think that there could be software that companies use to manage developers and other technology staff.  My guess is most of you think this would be a poor idea, but I could see this becoming used in help desks and infrastructure at some point. If it works there, who knows what types of AI software might be deployed by companies.

Perhaps more worrisome for many is that if this becomes a trend, this might affect the middle management levels in companies more than workers. One manager might do the job of 10s,  or even 100s, which is its own societal implications if we use less people as supervisors. Maybe this would make for more efficient companies, and hopefully, less meetings. I don't know if I think that's a good evolution of software being used to manage a process.

Steve Jones - SSC Editor

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

Redgate SQL Compare
 
 Featured Contents

Stairway to Database Containers Level 3: Building Custom Container Images by Hand

Steve Jones - SSC Editor from SQLServerCentral

In this next level of the Stairway to Database Containers learn how to customer a container and save the changes to a new image.

Testing Databases: What’s Required?

Additional Articles from Redgate

Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.

Using Attributes with Unity

Additional Articles from SimpleTalk

Attributes in Unity allow you to add features like strings and menu items to objects. In this article, Lance Talbert shows you how to add attributes that can then be tested while in editing mode.

From the SQL Server Central Blogs - Powershell script to get list of databases on a server

SQLPals from Mission: SQL Homeostasis

At one of my clients I received an email from one of the IT Project Managers asking a simple question:"Can you please let us know which databases reside on...

From the SQL Server Central Blogs - Join a List of Values

SQLRNNR from SQL RNNR

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Correlate Trace...

 

 Question of the Day

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

 

Altering a Filegroup

I have a very large SQL Server 2017 database and I am very busy. I start a backup of my 1TB database that I know will take at least 15 minutes to run. While this is running, I want to perform some maintenance and add another file to my OLTP filegroup. What happens when I run the ALTER DATABASE command to add a new file?  

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)

A Pandas Series

I have this list in Python:

>>> a
['Ford', 'Chevrolet', 'BMW', 'Audi', 'GMC', 'Porsche', 'Toyota', 'Honda']

I have the Pandas package and I run this:

>>>import Pandas as pd
>>> pd.Series(a)

Of these four choices, which one is output?

1:

{0:'Ford', 1:'Chevrolet', 2:'BMW', 3:'Audi', 4:'GMC', 5:'Porsche', 6:'Toyota', 7:'Honda'}

2:

{1:'Ford', 2:'Chevrolet', 3:'BMW', 4:'Audi', 5:'GMC', 6:'Porsche', 7:'Toyota', 8:'Honda'}

3:

>>> pd.Series(a)
0         Ford
1    Chevrolet
2          BMW
3         Audi
4          GMC
5      Porsche
6       Toyota
7        Honda
dtype: object

4:

>>> pd.Series(a)
1         Ford
2    Chevrolet
3          BMW
4         Audi
5          GMC
6      Porsche
7       Toyota
8        Honda
dtype: object

Answer: 3

Explanation: A series is a one dimensional array with an index. Similar to a dataframe with one column. Ref: Pandas Series - https://www.tutorialspoint.com/python_pandas/python_pandas_series.htm

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 - Administration
which linux - I would like to try to install SQL server and PostgreSQl on a linux system. It is a test environment This is just for explore and learn linux and how to work with database. What linux system do you recommend, Redhat or ubuntu?   Thanks
SQL Server Training - Can anyone recommend the best place to get the SQL training when the company is willing to pay for it?
Store Procedure... - Hi Is there anyone who can help me explaining, in real job field, in what kind of scenario I would need to use output parameters in my store procedures. And also I would like to know how data gets into tables, do we manually entered it or its gets inserted via back end file? Thank […]
Is DBA responsible for ETL operations and cube creation in DW design project? - If a company wants to build a DW from sketch, is DBA responsible for schema design, ETL extraction and transformation process, loading physical data from different sources into a DW database? Or DBA is responsible only for physical design, and tools like SSIS or SSAS should be used by developers.   Thanks
SQL Server 2016 - Development and T-SQL
Change data capture - is it possible Updates getting applied out of sequence - I am using the CDC objects in SSIS to do replication between two servers I have a large table that does not have a Primary key so must be set to all. Occasionally when I do validation between the two, the record count is correct but values don't add up. I am doing a simple […]
Changing @ExecutionTime parameter value in SSRS subscription - Hi Everyone,   Can you please guide me how to change @ExecutionTime parameter value in SSRS standard subscription and version is 2012? Thanks Kanagarajan S
How to disable Upload options to end user in SQL SERVER REPORT Services 2016 v? - Hi Every one,   Could you please help me to achieve this requirement? I am having a requirement like need to disable the upload RDL or IMAGE option to end user also, restrict to view hidden data sources list in reporting manager.   Thanks Kanagarajan s.            
How to do Count of values on mutiple columns - I have the folllowing data in a table If OBJECT_ID(N'tempdb..#OutputTable', N'U') IS NOT NULL DROP TABLE #OutputTable CREATE TABLE [#OutputTable]( [MainHoldingID] [int] NULL, [OfferingElementID] [int] NULL ) ON [PRIMARY] GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT […]
Administration - SQL Server 2014
error upgrade ssis - Hello everyone I proceed to update my ssis package from SQL server 2008R2 to 2016 during the upgrade wizard phase I got this message   thank you for your help    
SQL Server 2012 - T-SQL
In a t-sql 2012, I can trying to make a case statement work in an update statem - In a t-sql 2012, I can trying to make a case statement work in an update statement and I am getting the error ' Msg 207, Level 16, State 1, Line 5 Invalid column name 'TOT_ABSENCES'. from the following sql: UPDATE Milestone set TOT_ABSENCES = case when (details.TOT_ABSENCES is not null) or isnumeric(details.TOT_ABSENCES) = 0 […]
SQL Server 2008 - General
identify stored proc calls with missing input parameters - I'm checking to see if anyone has already written a stored procedure that can be run to identify any and all stored procedure calls from within a trigger or other stored procedure that are missing some of their input parameters. For example, if I have a procedure named SP_MyProc and three input parameters whenever I […]
Free Webinar: SQL Server 2008 has gone out of extended support - Hi All I thought I would post, I'm not sure its the correct place, but thought I'd let you know that I'm putting on a free webinar on 31st July - midday UK time. With SQL Server 2008 and SQL Server 2008 R2 going out of extended support with Microsoft last week, the webinar will […]
Error: Database is already open and can only have one user at a time - Any idea how to resolve this error? seemingly a nightly process loads data into my joebloggs_DB database, its then copied from jobbloggs_DB database to LIVE DB. Issue is sometimes the process fails with the following error: Error: Database 'JoeBloggs' is already open and can only have one user at a time. It looks like the […]
Dynamic Pivot Query with three fields - Hi,   I am creating a dynamic pivot query to produce a simple monthly table showing clients on the left column, calendar dates across the top and simple text in the middle. Table are CREATE TABLE [dbo].[TblClientActivity]( [ID] [int] IDENTITY(1,1) NOT NULL, [ClientID] [int] NULL, [LocationID] [int] NULL, [ADate] [date] NULL, [Outcome] [nvarchar](10) NULL) Data […]
Integration Services
Upgrade file SSIS - Hello everyone I have two dtx file SSIS develloper EN SSDT 2008 AND I'm going to migrate it in SQL2014 If I import these files through SSDT 2013 the files are well imported then if I click on the button upgrade all package i have this message At least one package has to be selected […]
 

 

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

 

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