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

The Voice of the DBA

Deleting Data

This editorial was originally published on Dec 18, 2014. It is being re-published as Steve is on vacation.

Like Tim Berners-Lee, I find the "right to be forgotten" law in Europe to be dangerous. The tremendous growth of data in our world means that searches become increasingly important in order for us to find data. If data is removed from searches, then for all practical purposes, it might cease to exist.

I think that is disturbing. As a data professional, I try to ensure that the quality and integrity of data is maintained. I really to try to avoid ever deleting data (preferring to archive or hide it) in case it's ever needed later. Far, far too often I've had someone ask me to remove something, only to have them ask for it's return a short time later.

I know that this law isn't removing the data. The original sources will still contain the data, but search engines won't return it. On one hand that means that many of us won't ever realize that the data exists. In some sense, this will return us to the very limited, analog search engines of the past, where we depending on indexes compiled on microfiche to find information stored in libraries. On the other hand, perhaps this will give rise to data investigators that will develop their own methods and archives that enable them to offer services where they can find the "forgotten" data.

I can't decide if I think this law is a huge step back, or a correction against some of the overzealous data creation that occurs in the spur of the moment. Certainly data about past events is valuable and important, but the way much of the world uses a search engine, clicking on a link or two and accepting the information as valid, can be misleading. Time will tell if this is a good idea or not, and I'm curious to see how well the law performs.

Steve Jones from SQLServerCentral.com

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

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

Question of the Day

Today's Question (by Steve Jones):

I have this data in the file sscdownload.py:

 from urllib.request import urlopen def GetAndPrintTextFile(url): with urlopen(url) as events: for line in events: print(line.decode('utf-8')) print("Loaded")

At a command REPL for Python, I type this:

 import sscdownload

However, I realize that I made a mistake and I edit the file. In the same REPL, I now do this:

 import sscdownload

What happens?

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

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

Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I make a backup with this code:

 BACKUP DATABASE AuditData TO DISK = 'auditdata.bak' WITH COMPRESSION, CHECKSUM, INIT; GO

I try to restore this with this code:

 RESTORE DATABASE FROM DISK = 'auditdata.bak' WITH REPLACE;

What is the result?

Answer: The restore completes successfully

Explanation:

If a backup is made with checksum, the restore does not need to specify this. However, if you restore with checksum, that needs to be specified in the backup.

Ref: RESTORE - 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

Login failed for user 'mydomain\myservername$'. Reason: Could not find a login matching the name - I upgraded a SQL 2014 to 2017 server. Today I see SQL log filled up with error below : Login failed for...

SQL Server 2017 : SQL Server 2017 - Development

Sql query row value if exists - Dear All, i would like to create the virtual column result with if exist condition. Example : If column1 value is equal to...

Get 2 decimals in my query - SELECT 'Per Category' AS Category, , , , , , , , FROM (SELECT CategoryID, AVG(UnitPrice) as UnitPrice FROM Products GROUP BY...

increase performance for SSIS package with BULK INSERT - I have created a package for our company that takes all the data from a table in our ERP production...

Update table using inner join - SELECT x.pkproductid ,x.supplierbarcodecorrect ,x.Code ,x.pksupplierid from Entertainer.dbo. x left join dbo.supplierpack spk on spk.fkproductid = x.pkProductID and spk.fkSupplierID = x.pkSupplierID The above quer

float error in t-sql scalar function - Hello Everyone, The below code is giving me error: Msg 3623, Level 16, State 1, Line 27 An invalid floating point operation occurred. [code...

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

Intermittent sql_variant problem on COMPATIBILITY_LEVEL >= 120 - I have encountered a reproducible but intermittent problem when working with sql_variant values in SQL 2016. The problem does not...

LEFT JOIN with CASE subquery ? - I am joining several tables together to do get pricing (a column) based on a code value (a column) and a...

SQL Server 2014 : Development - SQL Server 2014

How to roll up quantities > 1? - Hello everyone, I have not worked with rolling up quantities before and I am looking for some help. I need (or would...

Pivot the data - I am wondering if I can get some help here. I am joining 2 tables which brings me the result...

SQL Server 2012 : SQL 2012 - General

SQL Syntax HELP on merging enrollment spans - If object_id('tempdb..#SPAN1') IS NOT NULL DROP TABLE #SPAN1; If object_id('tempdb..#SPAN2') IS NOT NULL DROP TABLE #SPAN2; CREATE table #SPAN1( name VARCHAR(20),...

Recover free space in multi-terabyte db with minimal downtime - We have a multi-terabyte DB that is part of an HA Group, which, due to a lot of archiving now...

SQL Server 2012 : SQL Server 2012 - T-SQL

Need help in real time query tuning scenario in Adventure works - Hi all, I have been working in TSQL for 7 years but till now i have never faced to tune...

delete all apart first first record of episode? - I have a table full of episodes. So for one episode there might be 10 records. I want to delete...

SQL Server 2008 : T-SQL (SS2K8)

Joining large tables to small tables. - Hi I hope this is an easy question to answer. :-) I'm joining a large table to a small table and results...

Data Warehousing : Integration Services

SSIS Dataflow is not throwing any error when there is invalid column in the source flatfile with same datatype - Please help me asap. SSIS Dataflow is not throwing any error when there is invalid column in the source flatfile...

SQL Server 2005 : Administering

SQL Sever Scheduled Jobs - Hi, I'm trying to set up a scheduled job that runs daily and sends out an email to me when a...

two databases...same name...same instance...is it psbl? - just to give bckgrnd about my process...we are inserting data into different environments with the same db...so we need to...

How to change the database server for case sensitive - hi, In my database I created one table and add one column. column name is : column1 .. when i used select query...

SQL Server 2005 : T-SQL (SS2K5)

How to convert INTEGER to TIME - Hello, I have a column which is integer data type and it represents number of seconds. I need to convert it into...

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.