1 Facts and statistics collected together for reference or analysis.
1.1 The quantities, characters, or symbols on which operations are performed by a computer, which may be stored and transmitted in the form of electrical signals and recorded on magnetic, optical, or mechanical recording media.
1.2 Philosophy Things known or assumed as facts, making the basis of reasoning or calculation.
I originally wanted to write an article regarding GDPR from a SQL Server DBA aspect, but there are already some very good ones out there from Richard Macaskill and even one from Microsoft. What I decided to write about was data; or more specifically, our understanding or attitude towards it. As Data Professionals, we all have a firm grasp of what data is and how we use it, or at least we should if we want to perform our work correctly. However earlier this year a scandal has erupted over Facebook storing user data, and an analytics company called Cambridge Analytica who allegedly harvested that data from Facebook. There are allegations that this information was used to possibly influence political elections, such as the EU Referendum and 2016 US Presidential Election.
This is quite startling when you consider it: exploited data, through voter profiling and “fake news”, can now help determine the result of political elections. Who is to blame in this? Facebook? CEO Mark Zuckerberg stated that they relied on CA to delete the data themselves, which is quite alarming. Ultimately is it our fault, or us as Facebook users for putting too much of our data onto social media as a whole? Are we not thinking about what we are freely giving up?
Jen Stirrup, a data strategist, gave an interview to the BBC about the value and use of the data we freely give up, but we don’t expect to be manipulated, not just by Facebook, but by any person or company who controls or stores data. Ms Stirrup also states that there is a lack of transparency about companies such as Facebook about what they are exactly doing with our personal data. This I where I feel it is down to both sides, us and the data collectors that really don't understand the data they have or why we are giving it away too freely.
Regardless of whether it is structured or unstructured, big or small, what device it came from, who or where it is stored, it is interesting to gauge out attitude to something that dominates our world like never before yet it most of it lives in a virtual state. I read in a great presentation from Rimma Nehme, that 90% of the data existing today was created in the last two years. Quite a surprising statistic.
Nearly every day I see on my LinkedIn feed horror stories about how people are preparing (or not) themselves in readiness for GDPR, which is where companies can now be heavily fined if they don't handle personal data with appropriate care and due dilligence. In the UK, I have noticed that some shops are asking for my email address, so they can email me my receipt (it’s greener they say), but I tend not to hand it over as I am not sure what they plan to do with my email address afterwards. Will it be deleted? Obviously GDPR will cover this, but I still have my doubts.
But are companies doing enough to protect our data? It seems be be every week there is news of some large corporation or government institution that has suffered a data breach. I feel it is one reason why I think GDPR is going to cause issues for many companies because they don’t understand what data they hold and they don’t protect it enough, and they don’t know to designate different types of data. The layperson in the street just doesn’t have a grasp of data in the modern world, yet is responsible for creating much of it.
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
Redgate is joining forces with DevOps Research and Assessment (DORA) and Google Cloud to support the pursuit of DevOps excellence. The research aim is to better understand the DevOps landscape, and to surface new findings that provide guidance for improvement in resource management, productivity, and quality of technology delivery teams. To have your say and be part of the research, simply take the survey - there are even some great prizes up for grabs!
SSMS is a good management tool, but it’s not a good development tool. When you’re writing some simple queries, it’s fine. When you’re writing code with lots of branching, dynamic SQL, temp tables, error handling, and so on… Not so much. Here are some tips Erik darling has put together after a couple years of wrangling the Blitz scripts in the First Responder Kit. More »
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
(by Steve Jones):
If I run an unattended installation for SQL Server and use the /Q or /QS parameters, what parameter must be included?
If the /Q or /QS parameters are used for a quiet installation, the /IAcceptSQLServerLicenseTerms parameter must be included.
Ref: Planning a SQL Server Installation - click here
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.