| A community of more than 1,600,000 database professionals and growing |
| | What Data is Really Needed? The GDPR took effect in May of this year, at least with regards to enforcement. A few days after the May 25 date, a German court ruled against ICANN, the company that registers domain names on the Internet and manages the global WHOIS database. The case revolves around the information collected when you register a domain. ICANN wants multiple contacts, which they've required for decades. However, a company in Germany that is a partner, argued that the additional technical and administrative contacts were not required for fulfilling the business that both ICANN and EPAG (the German registrar) are engaged in. ICANN Is appealing the ruling, citing the need for clarification of what this means with regard to the law. This is interesting to me, because a) it concerns data, and b) there is an interesting argument here to be made about what data is needed for a business purpose. I could see this being argued successfully either way, and not just in court. As a domain holder, does the registrar really need multiple different sets of personal information from me? Arguably, this is a convenience for them, one that is based on tradition. However, one could argue the other way. It is a little scary that a court, with no expertise in some industry (Internet domain registration, in this case), will decide if there is an actual business need. After all, can a lawyer or judge really understand what data a business needs in their daily activities? Maybe, maybe not, but I do think this forces businesses to actually stop and think about what data they collect, have a justification, and document that. That's a good thing, because often I find business people just asking to collect data without any idea what they'll do with the information. I also find technical people collecting data, not maliciously, but often to anticipate what might be asked of a system, or because they want to avoid rework and just decide to collect everything they can. Data is precious, and while I don't want to put many limits on what data businesses can collect, I also don't want to them be able to collect anything, not disclose what they've collected, and not secure it properly. Having some limits, or at least forcing them to consider the risk of holding old, useless data, is likely a good thing for all of us. 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.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 | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control. Try it free |
| |
|
|
| | | Adam Aspin from SQLServerCentral.com On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how. More » |
| Additional Articles from SimpleTalk Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses the ways that data manages to migrate around the organisation and the challenges found in protecting that data. More » |
| Phil Factor looks at SQL Prompt code analysis; column alias violations and the right way to alias More » |
| Bert Wagner from SQLServerCentral Blogs Watch this week’s post on YouTube One of the things that the SQL Server query optimizer does is determine how to... More » |
| Matthew McGiffen from SQLServerCentral Blogs When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s... More » |
|
|
| | Today's Question (by Steve Jones): I have this code to create a table and add an index. CREATE TABLE dbo.PurchaseOrder ( PurchaseOrderKey INT IDENTITY(1, 1) NOT NULL CONSTRAINT PurchaseOrderPK PRIMARY KEY , PONumber VARCHAR(100) , CustomerName VARCHAR(100) , PODate DATETIME , PODetails XML ); GO CREATE PRIMARY XML INDEX PurchaseOrderXML ON dbo.PurchaseOrder (PODetails); GO I now run this: ALTER TABLE dbo.PurchaseOrder DROP CONSTRAINT PurchaseOrderPK GO 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: Alter table. 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 have a data frame in R that I am using to track my travel for the year. The data looks like this: > travel Passenger FlightDate Destination Miles Dollars 1 Steve 20180225 LHR 11789 1100 2 Steve 20180512 LHR 10989 1500 3 Steve 20180620 LHR 11789 1800 4 Steve 20180830 LHR 11789 1100 5 Steve 20181015 LHR 9678 2700 6 Steve 20181212 LHR 10520 1500 7 Steve 20180810 MSY 2427 440 8 Steve 20180225 OSL 1502 210 9 Steve 20180225 DCA 1475 310 I want to convert this from a wide format to a long format that I will use to plot my consumption of both distance and cost. I plan on trying to get this format of data: Passenger Destination variable value 1 Steve LHR Miles 11789 2 Steve LHR Miles 10989 3 Steve LHR Miles 11789 4 Steve LHR Miles 11789 5 Steve LHR Miles 9678 6 Steve LHR Miles 10520 7 Steve MSY Miles 2427 8 Steve OSL Miles 1502 9 Steve DCA Miles 1475 10 Steve LHR Dollars 1100 11 Steve LHR Dollars 1500 12 Steve LHR Dollars 1800 13 Steve LHR Dollars 1100 14 Steve LHR Dollars 2700 15 Steve LHR Dollars 1500 16 Steve MSY Dollars 440 17 Steve OSL Dollars 210 18 Steve DCA Dollars 310 What function should I use? Answer: melt(travel, id.vars = c("Passenger","Destination"), measure.vars = c("Miles","Dollars")) Explanation: The data is currently in a wide format, with multiple measures of values listed in columns. To shorten this to a long format, we use the melt() function, specifying which values are to be retained and repeated, and which values are to be combined into a column. Ref: Melt() - click here Reshaping data - 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. How much RAM required to server - How much RAM required to server having 15-20 Million records, on which insert and update operations are executed. How to calculate... SSMS failing to install on windows 10 - Ssms keeps hanging on the isolated VS step and fails with error 80070643 Can we replace Union ALL with single join - I have two tables tab1 and tab2. Column CDCode on Tab2 table joins with two columns (credit and debit) on... SQL Like ( not beginning with ) - Hi , I am trying to do a pattern search and my query is generic and it uses LIKE . The requirement... SQL Server 2016 syntax error - Hi All, We are in process to upgrade our SQL Server database from SQL Server 2008 to SQL Server 2016. The... Ideas on Passing filename from script task to data flow task. - Hi Team, I have a Script task(VB code),I have the output as filename to pick the most recent file from my... Invalid Metadata/Precision error - I'm writing a query and getting this error. I've written other queries on the same database but not his specific... Joins clarification - Let's say I have Table A and Table B. Table A can join onto Table B because both tables have a... Developer vs Standard edition - Hi Experts, I had a argument with my manager today and please correct me if i am wrong.We have SQL Developer... Find space used by image columns - By default, Image data (and some other types) are written to PRIMARY. Is there any way to find out how... Omit selected fields from the GROUP BY clause - Hello, Is it possible for me to omit fields that are in the select statement from the group by clause at... Count the amount of times values appear in the database - Hello, I have a table of "jobs" which I need to export to an online accounting software. What I need to... 2 identical plans - different performance when query run on different servers - Hi - This is a very odd behaviour and the opposite of what you may expect. I have a stored procedure that... Huge number of tables - Hi all, I've inherited a situation where we have a business critical system with gigantic number of tables, 240,000 - yes, nearly... Row with Non-Zero Value - I have the following table and want to find the row with non-zero value for revenue and quantity for each... Combine the functionality of IN and LIKE in a WHERE clause - I would like to be able to combine the functionality of IN and LIKE in a WHERE clause. Although the... How to imbed an image into an email sent by dbmail - Hello all and thank you in advance for your time and expertise. I am sending out customer statements in email using... PostBackUrl - Page not loading following image select - Hello, This is not my area of expertise so please excuse me if this question is already answered and / or missing... stored procedure not receiving null value from parameter in SSRS 2008 R2 report - I have a question on how to pass a parameter equalling NULL to a stored procedure linked to my SSRS... 0000 (4 zeros) turn into 0 (1 zero) when exported to .csv file - Database table field is Varchar(4), value is 0000 (4 zeros) exporting it to .csv file via Flat File Destination/Flat File... |
|
| 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 |
|
|