 | A community of more than 1,600,000 database professionals and growing |
| | 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.comJoin 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. 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 |  | 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 |
|  | 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 |
|
|
|
| |  | Adam Aspin from SQLServerCentral.com This short article shows a simple example of how to generate completely random sample output from a Dataset More » |
 | 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 » |
 | 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 » |
 | 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 » |
 | 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 » |
 | 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 » |
|
|
| | 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 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. Jobs running indefinitely - Hi, I have an sql server 2017 enterprise and sometimes (not always), when it runs a job (the jobs he... 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... 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 ... 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.... 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 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... 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... 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... 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... Measure Calculation - Here some background: I am using vs2010 multidimensional cube solution. My fact table, FactProductionClaims, consists of contract keys and the claims keys... 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... Database Audit - |
|
| 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. 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 |
|
|