SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

AI Regulators

With the GDPR now being enforced in the European Union, there are plenty of companies that are getting concerned about the potential fines from regulatory authorities if they aren't complying with the law, or at least, making an attempt. There certainly is leeway for regulators to adjust fines or give warnings if a company is making efforts to comply. This has likely contributed to the work inside many organizations to move towards compliance.

There are likely some companies that might not worry, since there are relatively few regulatory employees and many companies. There are lots of complaints coming in, which could easily overwhelms the relatively small staff in each EU country. Complaints might not be investigated in a timely manner or even lost because of the workload. The problem will likely get worse as more consumers complain about data processing practices. I don't expect regulatory authority staffing to increase, so I'm sure only the most aggregious or complained about companies will get caught.

There is one way to help amplify the capabilities of the relatively small staffs reviewing complaints. There are researchers in the EU Institute in Florence that are are working with consumer organizations to create AI programs that can help by performing some of the work. The initial thrust is to evaluate privacy policies of companies. If there are issues, the software doesn't assess a fine, but it does alert a human to perform additional checks.

In one sense, this is exactly what computers can do well. They amplify the capabilities of humans by doing a piece of the work. We can build systems, whether traditional programmed ones or AI based applications, that handle a piece of the work that requires lots of human labor. Once initial evaluations are made, a human can review the work and make more refined judgments.

The danger, to me, is that humans will be lazy. They'll start to trust the AI systems as authorities and use less of their own judgment, mostly because it's just easier. I could see these systems evolve over time to actually train humans involuntarily. New employees would initially trust the AI results, learning from the AI rather than teaching it and constantly evaluating its effectiveness.

I think AI can really help improve the way that we accomplish work in many ways, but it should be regularly audited and approached with some skepticism. There certainly needs to be some sort of supervisory group overseeing the program that isn't involved in the outcome. We should be sure that the goals and results from any AI system continue to be focused on what we want to achieve, and that we transparently define those goals for anyone impacted. Otherwise we might end up having AIs evolve in ways that are counter to the original purpose.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.5MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

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
SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Featured Contents

 

Generating Completely Random Sample Output from a Dataset

Adam Aspin from SQLServerCentral.com

This short article shows a simple example of how to generate completely random sample output from a Dataset More »


 

Help Redgate do a better job (and win a $250 Amazon voucher)

Could you spare a few minutes to help Redgate improve its products and services? They’re running a survey of their users and the wider SQL Server community and they’d appreciate your insights. As a thank you for taking part, you’ll also be entered in a prize draw for a $250 Amazon Voucher. More »


 

Principles of Data Protection

Additional Articles from SimpleTalk

Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features in SQL Server, such as Transparent Data Encryption, production data may end up in places throughout the organization. In this article, Brian Kelley talks about the best ways to secure data using the concept of least privilege. More »


 

SQL Change Automation with PowerShell Scripts: getting up-and-running

In this article, Phil Factor demonstrates how to use SQL Change Automation, a PowerShell script, to take the contents of a source control directory for a database, check that it is possible to build from it, document it and then create a NuGet package and place the code in it, along with the documentation. More »


 

From the SQLServerCentral Blogs - Why Aren’t You Using SSMS 17?

Grant Fritchey from SQLServerCentral Blogs

Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server... More »


 

From the SQLServerCentral Blogs - MSDTC Supported Configurations

Ryan Adams from SQLServerCentral Blogs

The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think.  It’s a different choice if... More »

Question of the Day

Today's Question (by Steve Jones):

When most CTE code is published, it looks something like this:

;
WITH Tally_CTE
AS
(
SELECT     TOP 52 ROW_NUMBER() OVER (ORDER BY StockCode) AS Num
FROM       Data.Stock
)
SELECT           Num, SalesForTheWeek
FROM             Tally_CTE CTE
LEFT OUTER JOIN  
                 (
                 SELECT         SUM(TotalSalePrice) AS SalesForTheWeek
                               ,DatePart(wk, SaleDate) AS WeekNo
                 FROM          Data.Sales
                 WHERE         YEAR(SaleDate) = 2016
                 GROUP BY      DatePart(wk, SaleDate)
                 ) SLS
                 ON CTE.Num = SLS.WeekNo 

What is the semi colon on the line at the beginning?

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: CTE.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

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

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced.  Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have this data in the file sscdownload.py:

from urllib.request import urlopen

with urlopen('https://www.sample-videos.com/text/Sample-text-file-10kb.txt') as events:
    for line in events:
        print(line.decode('utf-8'))
 

At a command REPL for Python, I type this:

import sscdownload 

What happens?

Answer: Each line of the text file is printed on the screen

Explanation:

When I import a file in the REPL, I do not need to specify the extension. If there are functions, they are imported. If there is code, it is run, which is what happens here. Each line of the file is printed.

Ref: Modules - 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.

SQL Server 2017 : SQL Server 2017 - Administration

Jobs running indefinitely - Hi, I have an sql server 2017 enterprise and sometimes (not always), when it runs a job (the jobs he...


SQL Server 2017 : SQL Server 2017 - Development

Need to display a column with deleted overlapping dates - I want to get rid of the following overlapping records from the table and display the below output. Also, I...


SQL Server 2016 : SQL Server 2016 - Administration

A Stairway series on Performance Tuning would be amazing! - Hi all I didn't know where to post this so just posting this here. I know it's a big topic with...

High availability solution - Hi Please suggest best high availability disaster recovery  solution for sqlserver2016 standard edition on windows server 2016 standard edition. Is the Logshipping ...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

SSRS Fixed Position Rectangles - Hello, I have a report that is designed to give us a visual representation of available kennel space in our facility....


SQL Server 2014 : Development - SQL Server 2014

Getting Max date from rows - Hi all, I'm trying to get the latest date for every distinct value in a column:  CREATE TABLE .(   NOT NULL,  ...

Pivoting a 2 columns table to a 6 columns table with 1/3 the rows - Hello, I have a table with 3 columns: RowNumber integer xImage Image xImageDesc nvarchar(30) I need to flip this into a table with 6 columns...

how do i find a specific status, and only that status - We have a table that contains part numbers, along with a status. because of the way the DB was designed, a...

It is possible to create a dynamic table from a result set ? - Hi guys, I need help for store in a table #temp result set of a function PIVOT dynamics and join others...

Clock hands churning and high stolen memory - Hi, I've been observing some odd behaviour on one of our se


SQL Server 2012 : SQL 2012 - General

SQL Query - Hourly Count - Hi I am not a DBA so please excuse me if this question is very basic I want a report to...

Changing network packet size - Hi our network has an MTU of 1500 so I've changed the network packet size to 1472 to stop the packet...

Why would changing the compatibility mode affect parallelism in a query? - Hi, We changed the compatibility mode from 100 (2008) to 110 (2012) on a 2012 Enterprise SQL server last week. Since then...


SQL Server 2012 : SQL Server 2012 - T-SQL

query help needed - Hi Experts, Need sql query help. create table test ( PropertyType varchar(100), PropertyName varchar(100), PropertyValue varchar(100), ) insert into test select 'TestType1','DisplayId','AUTO-TABLE' union all select 'TestType1','DisplayId','ID-OF-THE-QUESTION3' union...


SQL Server 2008 : T-SQL (SS2K8)

Efficient way to load data in a table - Hello guys, I currently have a query comprising of joins across multiple tables to process data for 10 years and...


Reporting Services : Reporting Services

IIF Expression in SSRS to use "Any" or a specific user input value? - I am trying to write an array expression to be one that returns all values if "ANY" is input, or...

Drill down Report...Remove the Expand (+) and Collapse (-) button for some groups - Hi.... I have implemented a Drill down upto 3 levels. First level is Continents... when a Continent is expanded.... Countries in...


Data Warehousing : Analysis Services

Measure Calculation - Here some background: I am using vs2010 multidimensional cube solution. My fact table, FactProductionClaims, consists of contract keys and the claims keys...


Career : Events

The SQL Saturday Thread - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created...


Microsoft Access : Microsoft Access

Database Audit -

This email has been sent to {user_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.
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: webmaster@sqlservercentral.com