| A community of more than 1,600,000 database professionals and growing |
| | Treat All Sensitive Data as Important We know that not all the data in our company is important. We have databases that contain orders or inventory or schedules, often much of which isn't easily or directly related to an individual. At least, it's not if you have a normalized database. If you use SQL Server to emulate Excel spreadsheets, it's possible that most of the rows of information in your system contain sensitive data. In some systems, there is definitely some data that is sensitive and needs more care than other data. We know this, and with legislation like the GDPR, we must protect this data. We also need to ensure we know where this data is, and having a good data catalog is important. This is something that few of us have, though I expect this to be a more regular part of our job as data professionals. SQL Server is building data classification into the product, which I am happy to see. When data is sensitive, we need to treat it carefully, even if we don't like the content of the data. Recently there was a data breach from B&Q, a home improvement retailer in the UK, where 70,000 names were lost. These weren't customers, but rather people that had been caught stealing from the stores. Perhaps this was an honest mistake, on a data store with poor security. Perhaps no one thought this data needed security because these were criminals, or suspected criminals. Even if these were individuals that might be prosecuted by the company, their data still deserves the same protection as any other person's data. I don't know what the fallout will be from this breach, and certainly most people would have little sympathy for criminals, but who knows just how accurate the data might be. I certainly think this is a situation where there is a high likelihood of legal action against the company if the proper GDPR notifications were not followed. Wouldn't that insult to injury? People caught or suspected of theft suing you because you leaked their personal information. I could certainly see management getting extra upset and terminating someone that forgot to secure these systems. 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.4MB) 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 | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your 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 |
|
|
|
| | | With the introduction of GDPR in 2018, new data privacy acts appearing around the globe and a striking rise in high-profile data breaches, data masking is a popular topic from IT floor to the board room. Gartner released their 2018 Market Guide for Data Masking covering their analysis, recommendations, and representative vendors – including Redgate. To find out more, get your complimentary copy of the report from Redgate. More » |
| Additional Articles from SimpleTalk Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there. More » |
| Gavin Draper from SQLServerCentral Blogs Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a... More » |
| SQLRUs from SQLServerCentral Blogs In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes... More » |
|
|
| | Today's Question (by Steve Jones): I have created this table in SQL Server 2017. CREATE TABLE dbo.SalesOrderHeader ( OrderKey TINYINT IDENTITY(1, 1) , CustomerName VARCHAR(30) ) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO I now have completed testing, so I do this: DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0) GO If I run this code, what value is returned for IDENT_CURRENT() and what value is added for the OrderKey for the row with Azure? SELECT IDENT_CURRENT('dbo.SalesOrderHeader') GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Azure') SELECT * FROM dbo.SalesOrderHeader AS soh GO |
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: IDENTITY Property. 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 | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a list in Python that looks like this: >>> a = ["I", "would", "like", "to", "go", "to", "Australia"] I want to get all of these words into a single sentence. What is the best way to do this? Answer: ' '.join(a) Explanation: The join method with a space will take each element in the list passed in and put them together with the space between each into a string. Ref: join - 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. BCP usage - Hi All, I am trying to one bcp command I am not able to execute it correctly. I have created below table: CREATE... Trying to setup DAC for SQL 2017 - Following Brent's Ozar's advice - I'm setting up the DAC login connector our sandbox. While attempting to connect via like this <CommandLine>sqlcmd... is it possible to define a role that allows members of that role to add other mebers to that role? - Hi, I have an (simplified) application with the roles 'roleAdmin' and 'roleUser'. Members of the roleAdmin should be able to add... Diskspace requirement for 1M records - Hello Team, I have a requirement where I need to see how much space is used per each record for each... Security roles - All, Firstly I'm not necessarily asking for a complete answer. I'm happy to be pointed in the right direction to solve... powershell email for missing backups - I have this script I have been trying to edit from microsoft's site. I only want to receive notification for... Thousands of Successful Logins - We are seeing user accounts with tens thousands of successful logins per day. These are SSMS users. This strikes me... SSIS packages slow BCP processing - We are using SSIS packages to just do a data transform and map from one table to another. Within SQL Profiler... Easy way to replicate SSRS Multi-Select Parameter from SSRS in TSQL? - When attempting to diagnose issues with SSRS Reports, I often run into an issue where there is a multi-select parameter... SSIS Can't set foreign keys to NULL in an update - Hi, I'm trying to recreate a stored procedure within SSIS . Basically what I'm trying to do is to pass through variables... Trying to export data into csv file using bcp stored procedure - Can someone please help me with explaining why I am getting the error shown in the attached file? Thank You in... heat map as sql function or proc - Does anyone have a good heat map function or proc that takes three params. TheValue, MinOfAllValues, and MaxOfAllValues. It return... Failed to initialize sqlcmd library with error number -2147467259 - Hi all, I have the following problem: I have a three node cluster with three sql instances. All are SQL Server 2014... The specified @job_name (job_name) does not exist - I just upgraded from SQL Server 2008 to SQL Server 2014. I am receiving a push from a data warehouse... Sub queries In access - i want to join two queries so i can take the count of one query and divided by another query... SQL backup to ACCDB - Hi All, Currently i have an access front end with links to SQL tables. We now have a need to save... Using Dynamic SQL to create a list - Hi, the brief is to: use sql to pull a distinct list of values together and then to validate a set... Page setup for reporting - setting header and footer page margins - Hi, Not sure if this is the correct place to post so apologies if not (please let me know which sub... "Text was truncated or one or more characters had no match in the target code page.". - This error somehow for some reason makes me so deeply sad that i cannot even think where i should start... 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 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 |
|
|