SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Tougher Privacy Laws

I am all for tougher privacy laws, especially for companies that have not followed basic security practices for securing data. There is a proposal from US Senator Ron Wyden that would increase penalties and give more rights to consumers. Consumers could opt out of data sharing and executives could be fined or jailed. The penalties are stiff, and I think it's not likely to pass, and more practically, many of the penalties might not actually get enforced.

In the US we don't have much in the way of rights over our own data as humans. Companies, for the most part, have complete control over the data they collect about us and can re-use, sell, share, etc. that data in any way they wish. There are some laws concerning notifications of data loss, and some penalties in California's recent law, but for most of the country, consumers are at the mercy of organizations. I'd like that to change, and I don't think doing so would hurt most businesses. Aggregators and data only companies might struggle, but I'd like to see less of those companies in business.

Stronger penalties might stimulate change and better practices, but only if we fine or jail those that limit security efforts. Most technical people try to implement security but are often prevented or limited from making many changes when there is pressure to keep moving forward. Certainly some technical people don't take security seriously, but I'd like to see employees absolved of responsibility if they show that they have asked for time or resources for security, but those aren't granted. I'd also like to see some way for management at all levels to prove they have actually requested and funded security efforts, not just remain ignorant of the lack of security. Too many layers of management muddy the waters and often prevent those that are responsible for pushing other work over security from being held accountable. We need more accountability at all levels for poor security.

Likely there is a limited amount of structure that government can provide. Developers and infrastructure groups need to build and configure secure systems. Some funding needs to be available for security work, along with the time to do better. Management needs to make security a priority It's a group effort and while I hope we can get there, I'm not terribly confident things will improve soon.

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

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
SQL In The City

SQL in the City Streamed

The theme for December 2018's SQL in the City Streamed is Your Journey to Compliant Database DevOps. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate. Find out more and register for free

GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

Featured Contents

 

T-SQL Decommenter Part IV

Toby Ovod-Everett from SQLServerCentral.com

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version. More »


 

Adopting Compliant Database DevOps at PASS

To help meet the requirements of the GDPR, PASS teamed up with Redgate to implement Compliant Database DevOps. This benchmark process has streamlined PASS’ database development pipeline, and strengthened their ability to uphold data privacy regulations such as the GDPR. More »


 

Meeting Preparation for SQL Server Projects

Additional Articles from MSSQLTips.com

Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more. More »


 

From the SQLServerCentral Blogs - What is the SQL Server Trustworthy database property?

Justin Figg from SQLServerCentral Blogs

I ran across an interesting property set in a SQL Server database for a customer, the property is called “Trustworthy”. ... More »


 

From the SQLServerCentral Blogs - Dealing with multiple AD accounts

Kenneth Fisher from SQLServerCentral Blogs

To help promote the seperation of duties one of the things my company has done is to divide our permissions... More »

Question of the Day

Today's Question (by Steve Jones):

What's the shortest variable name?

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: T-SQL.

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

Microsoft SQL Server 2017 on Linux

This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have this code in Python:

 ctr = range(2, 5) for i in ctr: print(i) 

What does this return?

Answer: 2,3,4 on separate lines

Explanation:

The RANGE() function in Python takes three arguments. The first is the starting number, inclusive. The second is the ending number, exclusive. The third is the step count, or difference in each number in the range.

Ref: Range() - click here


» Discuss this question and answer on the forums

Featured Script

EmbeddedSplit8K

Carlo Romagnano from SQLServerCentral.com

SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd ddd [12345]  ee [abcde] ee ','[',']') --returns 12345 and abcde
SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd ddd #12345#  ee #abcde# ee ','#','#') --returns 12345 and abcde
SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd ddd (12345)  ee abcde( ee ','(',')') --returns 12345

More »

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

Arithmetic Overflow when comparing working select items - Hello, I have a working query that gives me the data I'm looking for. SELECT DISTINCT CAST(COALESCE(LEFT(o.Part_Family_Code,2),0) AS decimal (10,2)) AS...

High memory utilization on SQL Server - Hello Gurus, I had emailed earlier  but didn't get any response and googled but didn't get enough info: We have a prod...


SQL Server 2017 : SQL Server 2017 - Development

Help Loading data from Access DB File to SQL Server using SSIS -

Entity-Attribute-Value is evil ? how to avoid... - Hi all consider the following scenario:I have a FILE table with known attributes (size, creation date, ...)The user needs to add...

Relation table - Hi  I have a table that may reference multiple objects (by integer ID) each stored in a different table  there are...

Inserting a new row into a table using a cursor - Hi all, I need help.  I hope someone can provide some info. I have provided the SQL code below. Please note on...

CASE Statement - I'm trying to add a new  column to some code I have, and I am completely stumped. I was wondering if...


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

Stored Proc fails as Exec but the SQL that makes it up runs fine - Hi All, I have a stored proc that when I run the SQL hard coding the parameter values it runs fine...

How to run procedure from remote server without linked server - Hello, I need to run a t-sql batch that will run a stored procedure procedure at a remote server. But i don't...

Inner joins - Hi all. Our current version is 2008 and we are going to migrate it to 2016 or 2017. In many stored procedures,...


SQL Server 2014 : Administration - SQL Server 2014

Deleted tables - release space - HI, We deleted a bunch of tables (moved them to cheaper storage SAN) and now when I run 'DBCC SHRINKFILE (N'mcr_dc_new_Data'...

one sec vs 40 minutes - I copied database from prod (sql 2008) to test (sql 2014) , changed compatibility mode to 120, re-index and updated stats when...


SQL Server 2014 : Development - SQL Server 2014

poor performing report query against table without a PK - The table is practically a heap because its' clustered index is on a column that allows NULLs, and there are...


SQL Server 2012 : SQL 2012 - General

Send email alert without SMTS server - Hello,  We have few jobs configured for autogrowth, memory and cpu spike, blockage as per the client requirement. But, we don't...

What can be the benefits of copy_only backup - Dear Folks, I want to understand what could be the benefits of copy_only backup except independent with the existing log chain

Rebuilding Indexes - How do you determine how often you need to rebuild your indexes?


SQL Server 2012 : SQL Server 2012 - T-SQL

String split help - I have data like this in a table col1 , col2, col3 A,2, this is a short string no need to split B,3,...


SQL Server 2008 : T-SQL (SS2K8)

Slow SQL Script - Hi there,  I want to select some information from a few tables and it is very slow that causes timeout. Kindly refer...


Reporting Services : SSRS 2016

SSRS 2016 permissions issue - Hi all I've got a bit of a conundrum. I need to be able to allow people to create subscriptions on reports...


Data Warehousing : Integration Services

Help me with using Table values CLR function in OLE DB command in data flow task - HI All,   I am struggling to use table value CLR function in OLE DB command in data flow task. I am...

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