SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Editorial: Do We Understand Data?

Today we have a guest editorial as Steve is at a conference.


1 Facts and statistics collected together for reference or analysis.

  1. 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.

Example sentences

  1. 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.

Scott Crosby from SQLServerCentral.com

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

SQL Provision

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

SQL Compare

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

Featured Contents


NonClustered Index Structure

Mayank Shukla from SQLServerCentral.com

Learn how the clustered index keys affect the non clustered index structure. More »


The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.

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! More »


Quick Tips For Debugging Large Stored Procedures

Additional Articles from Brent Ozar Unlimited Blog

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 »


From the SQLServerCentral Blogs - You know everything about GROUP BY. Do you?

Daniel Janik from SQLServerCentral Blogs

SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in... More »


From the SQLServerCentral Blogs - Hands off dbatools updates

Steve Jones from SQLServerCentral Blogs

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and... More »

Question of the Day

Today's Question (by Steve Jones):

I am creating a new Service Broker queue. I want to ensure that all messages are retained until the conversation is ended. What setting should I change?

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: Service Broker (SSSB).

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


The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

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

Yesterday's Question (by Steve Jones):

If I run an unattended installation for SQL Server and use the /Q or /QS parameters, what parameter must be included?

Answer: /IAcceptSQLServerLicenseTerms


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

» 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 - Development

Why Normalization is not good - Under what circumstances Normalization is disadvantageous to database?Can someone explain with a neat example?

If today is Monday show Friday to Sunday - Hi Guys,  I am using the below to show data relating to yesterdays date, It works great but on a Monday...

Error Processing Cube from SSIS package run as a SQL Job - Hi, I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I tried CU4 before...

SQL Server 2016 : SQL Server 2016 - Administration

NBU - dbbackex job error - Hello all, First of all let me clarify that I've entered the DBA world not too long ago and inherited a...

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

insert into: ignore identity column's value - Hi, is there any Chance to get this working? CREATE TABLE .(   IDENTITY(1,1) NOT NULL,   (10) NULL, ) Now insert something with...

YTD running balance including missing months - Hi All, I am trying to get the  YTD Account Balances for a financial statement. There are accounts which does not...

SQL Server 2014 : Administration - SQL Server 2014

Transforming a AG node to Standalone in DR environment - As part of DR exercise, we have replicated one of the AlwaysOn configured SQL 2014 servers to Azure DR environment....

Troubleshooting MEMORY ALLOCATION EXT wait type - I am getting this wait type on my DB Server, please let me know the reason y it caused and...

SQL Server 2014 : Development - SQL Server 2014

Group by not working as desired... -

Trying to select both "paths" through data - I'm working with one of the developers, he has an application which logs the "path" taken by a process.  The...

SQL Server 2012 : SQL 2012 - General

SSRS Exporting Data to EXCEL does not work when Query returns 187326 Rows - The report appears fine ( Takes 1.27 minutes for the data to appear )  That is fine. But the user needs the...

SQL Agent Job not providing full failure message for SSIS Packages - Good Morning, We are having an issue with 2012 SQL Servers not reporting why a job has failed, this is happening...

SQL Server 2012 : SQL Server 2012 - T-SQL

GUIDs as clustered index - Hi All, Looking for some suggestions. Currently, In our system we have GUIDs are primary keys and as the database...

SQL Server 2008 : SQL Server 2008 - General

KB4057113 Installation Issue - sqlsupport.msi - Ok, I'm trying to install this security patch.  When I first started trying, it kept saying I can't files... I...

Read-only schema allows write - Once again, I thought I understood permissions, and once again, turns out I don't know jack. I have a view on...

Deleted SQL Agent Job Sending Failed Notifications - Hi All, 2008 R2 instance. We frequently copy databases for new DBs as it's a lot less work to get clients...

SQL Server 2008 : SQL Server Newbies

detect if previous record is higher or lower ? - In it's simplest form if I had a table that stored a persons name, date that the record was entered,...

Reporting Services : Reporting Services

Calculate dynamic columns - Hello team, On Sql Server Report Builder, I'de like to know how to calculate dynamic columns or how to deal with...

Data Warehousing : Integration Services

Object variables, ADO Recordsets, & decrypting column - Ihope someone can help me out. My C# skills are nill, so I need a lot ofinformation. A bit of background:...

This email has been sent to {user_email}. 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