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

The Voice of the DBA

The Employee Target

We hear regularly about consumer backlash from data breaches. There are usually legal repercussions, and often hard dollars (euros, yen, etc.) being spent on things like identity protection or credit monitoring. In addition, in the last couple of years, there are plenty of people that try to limit, or cease, doing business with organizations that lose their data. That isn't always possible, especially when the government is the one getting hacked, but more and more people are taking an active stance against poor internet security by organizations.

It's not anything that I think will happen soon, but I bet it will happen. Airbus had a breach that lost employee data. I wonder when we'll start to see employees initiating lawsuits or other actions against their employers. My suspicion is that this will happen with former employees first, but with the GDPR, current employees in the EU might feel emboldened, and with good reason. Employers have a lot of data about us, and that ought to be well protected.

There have been hacks to lower a stock price, or affect a company. Why not hacks to attack employees? I wouldn't have thought of this until I talked with a forensic analyst about other possible second order attacks. Could there be individuals that might seek to attack IT staff through personal information and blackmail or otherwise extort them to copy data? What about partners and spouses of employees at big companies? I don't worry about Redgate as a target, but what if you work for Google/Apple/Microsoft/Facebook? We already had a potential sleeper employee at Twitter.

Unfortunately, I see no depths to which criminals might sink. Across the last decade there have been stories of actions that I never would have contemplated. While I hope my fears are unfounded, I worry that sensitive data about employees might be on the radar for some nefarious individuals.

Steve Jones from SQLServerCentral.com

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

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

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents

Persisting Storage in Containers

Steve Jones from SQLServerCentral.com

Learn how you can persist data beyond the lifetime of a container. More »

The Conflict Between Data Protection and DevOps

There are demands on your business. Demands to keep ahead of your competition. Demands to be compliant with one or many data protection regulations. And demands to minimise stress on resources like disc space and time. These demands are conflicting and can lead to the database becoming a bottleneck. Steve Jones shows us how to resolve the conflict in this article. More »

What is the Best Value for Fill Factor in SQL Server

Additional Articles from MSSQLTips.com

Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight. More »

Introduction to SQL Server Security — Part 2

Additional Articles from SimpleTalk

In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups. More »

From the SQLServerCentral Blogs - Generating Insert Statements

Martin Catherall from SQLServerCentral Blogs

G’day, I been asked a few times lately the best way to generate INSERT statements. I’d always replied to use SSMS. I know... More »

From the SQLServerCentral Blogs - Interview Trick Questions

Jason Brimhall from SQLServerCentral Blogs

Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want... More »

Question of the Day

Today's Question (by Steve Jones):

I have the Buffer Pool Extension enabled and set on my instance. Currently I have a 58GB setting for max server memory and a 500GB file set for BPE. I want to decrease this to 250. Which of these statements do I run?

ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION OFF
ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'F:\memory.BPE', SIZE = 250GB)
ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION (FILENAME = 'F:\memory.BPE', SIZE = 250GB)
ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON
Restart the instance

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: Buffer Pool Extensions (BPE).

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

Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

Prepare for Microsoft Exam 70-774 and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Get your copy today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

On SQL Server 2017, I have a brand new database with no objects. I run this code:

 CREATE PROCEDURE dbo.GetOne AS SELECT 1 GO CREATE PROCEDURE dbo.GetOne;2 AS SELECT 2 GO

How do I execute a stored procedure and get a result of 2?

Answer: EXEC dbo.GetOne;2

Explanation:

There is an older feature of CREATE PROCEDURE that allows you to create versions of stored procedures. You do this with a semicolon and a number after the name. You do the same thing when you execute the procedure

Note this feature is in maintenance mode (deprecated), and should not be used.

Ref: CREATE PROCEDURE - 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 - Administration

SSRS Load Balancing, Listeners and Licenses - I hope someone can verify this for me. We're about to upgrade to 2017 and we're addressing an old question that...

SQL Server 2017 : SQL Server 2017 - Development

How do combine row sets (create a Sku table from product / attribute combinations) - A store sells products. Products have attributes grouped into types. (Ex. Product 'shirt' has size and color, so a sku...

value based on sequence for each detail - I am using SQL Datawarehouse for my database Find the V,T,C in sequence for a given detail group by Shipment_id order...

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

DB design thoughts - This is more of a question around DB design as opposed to DML so hopefully I'm in the correct place. I...

Group by companyid with Latest date - Hi Team, Can you please help me on this below query. create table #test ( companyid int, companyname varchar(100), actiondate datetime ) insert into...

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

SQL Server 2012 : SQL 2012 - General

????RHUL???RHUL??? - ??|??:695640122?RHUL??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??

????RSAMD???RSAMD??? - ??|??:695640122?RSAMD??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,?

????RCM???RCM??? - ??|??:695640122?RCM??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,

????UCL???UCL??? - ??|??:695640122?UCL??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,

????UAL???UAL??? - ??|??:695640122?UAL??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,

?????????????? - ??|??:695640122?????” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,?

Login Failed for user Domain\User - I have a .net web app on development machine. It is WIndows 10 with .Net Framework 4.7, SQL Server 2012...

SQL Server 2012 : SQL Server 2012 - T-SQL

Transfer a text file from one server to another server - Is there any way to transfer a text file from one server to another server using powershellscript. Please help .

SQL Server 2008 : SQL Server 2008 - General

mapping back - i have table as below: country code australia 55555 australia 55555 australia checklater ukraine 33333 ukraine checklater ukraine checklater ukraine 33333 america 22222 i would like to map back the same country and replace the code...

Programming : XML

Importing an XML file into a sql table - Edit to make things more understandable, I wish to import my XML file into an sql table. The XML has a...

Data Warehousing : Integration Services

SSIS 2017 connection to Access .accdb file - Sorry, I'm an SSIS noob. I've connected to .MDB files in the past using the Jet 4.0 connector, and it...

Data Warehousing : Strategies and Ideas

Modelling multi language datawarehouse - Hello I need your help. I work for a survey company and I am responsible for creating its architecture and modeling a...

SQL Server 2005 : SQL Server 2005 General Discussion

Linked AS400 stopped working - We have a linked AS400, connected through OLEDB (IBMDASQL). Up until last Thursday it was working fine. We are now...

Career : Events

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.