| A community of more than 1,600,000 database professionals and growing |
| | Data Privacy and Security: The Implications of GDPR Today we have a guest editorial from Phil Factor as Steve is out of the office. It really is about time that all of us who are working on data tightened up on security. Since I started working in IT, standards of protection of data have fallen significantly. Because we as an industry haven’t cared enough, there has been growing international pressure on creating legislation to compel us to take security seriously. In a years’ time, companies operating in Europe, wherever they are based, will face huge fines for offenses against basic human rights for privacy that are poorly understood by many. I apologise for talking about European Legislation for a moment, but there is a reason. The European Convention on Human Rights (ECHR) speaks of a right to respect for one's "private and family life, home and correspondence". The General Data Protection Regulation (GDPR) is soon, in a year’s time, to become law in all EU countries, including the UK. The regulation also applies immediately to organisations based outside the European Union if they collect or process personal data of EU residents. We’re not just talking about potentially embarrassing medical records here. No, personal data includes anything like a name, a home address, purchasing habits, a photo, an email address, bank details, posts on social networking websites, or a computer’s IP address. To use this personal information will require explicit consent, which can be subsequently withdrawn. It can only be retained for a period of time. Organisations can’t shrug and say that they delegate the processing of personal information to a third-party. If they use and benefit from the data, they are responsible. They have to show that access to such data is prevented by design. We have to prepare now before it becomes enforceable in May next year. Many existing IT systems will have to be re-engineered before next year. Organisations over a certain size whose main activities involve processing operations, and that are operating in Europe will have to appoint Data Protection Officers to ensure that the organisation complies with the legislation. These people will need to be data experts with experience in security and a lot of knowledge about the protection of data, able to sure that IT systems protect data ‘by design and by default’. The mood in the USA towards personal privacy is rather different, favouring as it does the rights of the state, as defined in the Patriot Act. However, because of the long-standing international agreements of Safe Harbour and more recently Privacy Shield, the GDPR affects all businesses processing personal data who trade with Europe. The EU has the most progressive laws on data protection, and will determine the data standards of a globalised market, so it looks inevitable that the international standards for handling personal data will derive from the GDPR. Yes, the ramifications of GDPR could easily affect your work. Phil Factor from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial. |
| | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
|
|
|
| | | David Poole from SQLServerCentral.com You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game. More » |
| Additional Articles from SimpleTalk It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it. More » |
| Additional Articles from Redgate At the end of 2016, Redgate interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools, and also to find out what lessons he learned during the process - the highlights make for interesting reading. Read the interview write-up. More » |
| Dharmendra Keshari from SQLServerCentral Blogs In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how... More » |
| hamish.watson8 from SQLServerCentral Blogs In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in... More » |
|
|
| | Today's Question (by Steve Jones): I have a server with 16 CPUs seen by SQL Server 2016. This server has 4 NUMA nodes, each having 4 CPUs inside. I want to set processor affinity to just the CPUs in the first and last NUMA node. What command do I use? |
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: Administration. 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'm working in R, but I can't remember how a function works. How can I get help quickly within a language editor for a function such as sqrt? Answer: type "help(sqrt)" Explanation: The help function, with the name of a function as a parameter, will return help. Ref: help - 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. Transaction Log Growing - Hi Everybody, I have a question concerning Backup. I have a partition which is growing (D:\) more and more. - *.mdf and *.ldf... How to pivot the row? - DECLARE @Temp Table (ID int, Make varchar(2), Model varchar(2), ModelYear int, FuelType varchar(15), cylinder varchar(3) ) DECLARE @KmRange bigint = 30000 insert... What can cause a failure in SQL Server, when a prior admin's account is deleted? - We had a prior DBA that had his AD account showing up as the owner on a multitude of SQL... HA/DR solutions - The company I work for is pretty small and currently we have 20+ DBs running on 2008r2 and 2012. DB... Dynamic Statement with Cursor loop, help - Hi , I am trying to build a dynamic query which will create a select. I am trying to use a... Best practice for alerting via 3rd party tool - Hi all, New in my environment. We use Nagios to log in and monitor our DB servers, but from what I've... DB size grown from 180 GB to 340GB in 3 months. Wants to bring back to 200GB DB size. - Hi, The SQL Server version 2012. It's Live Server with 50+ users and other process. Issue: DB size grown from 180 GB to... To Delete / Truncate / Drop & Create - Good Morning All, Can I Have some opinions please. Have 2 large tables I need to 'clean', 1 with 265263333 rows and one... What's the best SQL Server Transaction Log Analyser? - I'd like to get a SQL Server Transaction Log Analyser. I'm mainly interested in being able to work through some... SSIS ForEach Loop Container recursion question - I have a weird one today. Because my destination system can only accept files of a certain size, I need... Oh double hop, you're so fun ... Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - I've fought this issue so many times over the years and perhaps I'm old and rusty, but I'm having a... DATEDIFF using integer keys - I've always wondered why you can't use datediff with two dates that are in int format. When I run select datediff(day,... Heap vs Clustered Wildcard Search - I am working on converting a heap table to a clustered table by adding a primary key to the identity... Help On Calculating Aging - create Difficult Grouping problem - Hello there, I have the following derived table extract below :- Database mail issue - Attachment file is invalid - - Hi All, I have an issue with database mail SQL QUERY Rows where TotalScore=@TotalScore in the range of value by using group by Date and Time - Dear Expert, I am seeking your help . here is the scenario , please see the Figure -1 I have 3 parameters .1.... Grief importing date from Excel 2010 to SQL Server 2012, SSIS, Derived column task. - Hello, First of all, I'm an SSIS Noob, and not great with Excel either, someone else created and imported the data... How does one select EVERY Nth row from a table? - Hi Friends, I want to retrive each nth row from a table in sql server 2000. Example: if i give n as 5 then 5,10,15,20,.............. 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... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|