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

Liable for Data Loss

When I first installed Windows 7, I was thrilled. Finally, Microsoft had slimmed down and improved the OS performance rather than continuing to bloat it larger. After Vista, Windows 7 was a welcome change. Windows 8 was different, but for me as a desktop user, it wasn't much different. I moved to Windows 10 as a beta user and thought it performed well. A little slower than 7, but overall a good move. I was glad to get the upgrade notice on a second machine, but it was annoying. Trying to easily delay or avoid the change in the middle of some travel was hard. I certainly could sympathize with the users that complained they didn't want the upgrade and couldn't easily avoid it. I'm glad Microsoft changed this process a bit.

There were people that accidentally, or felt forced, to upgrade. Among those, some of them lost data and decided to sue Microsoft. Let's leave aside the Windows upgrade process, Microsoft's decision, and the merits of this particular case. Those are separate issues from the one I want to discuss, which is the liability for data loss. At the core of the lawsuit, the time and information that people have lost is an issue that few of us have had to deal with in our careers. At least, most of us haven't had to worry we are liable for the issues our software might cause.

Are we moving to a place where a person, or more likely a company, is going to be held liable for the data loss from upgrades or patches? There is the ability of customers to initiate legal actions, but strong EULAs and prior legal decisions seem to indicate that much of the liability resides with customers and vendors aren't at fault. Is that a good thing? I'm not sure, but I do think that as data becomes more important and is used to justify decisions or drive business actions, there will be a push to ensure that anyone performing data changes with their software during patches and upgrades is liable for issues.

I'm surprised we haven't seen more of accountability from software firms to date, but I think much of the legal issues have been settled without much fanfare and strong non disclosure agreements. I'm not sure this is the best solution for anyone, as to force some improvement and better quality for software, we need to take better care of our data. I don't want us to move slower with software development or deployment, but I do want quality to improve.

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 ( MB) 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 Prompt

Could your SQL coding be more efficient?

Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips.

SQL Source Control

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.

Featured Contents

 

The connection to the primary replica is not active. Error: 35250

Ganapathi varma Chekuri from SQLServerCentral.com

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. More »


 

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More »


 

Performance Myths : Clustered vs. Non-Clustered Indexes

Additional Articles from SQLPerformance.com

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key. More »


 

From the SQLServerCentral Blogs - The Binomial Formula with T-SQL and R

Mala Mahadevan from SQLServerCentral Blogs

In a previous post I explained the basics of probability. In this post I will use some of those principles to... More »


 

From the SQLServerCentral Blogs - Don’t Duck On Responsibilities

CYates from SQLServerCentral Blogs

Being a data professional you assume a certain amount of responsibility. It often requires having the right attitude and an... More »

Question of the Day

Today's Question (by Aditya Rathour):

How many archived SQL Server Agent error logs does SQL Server maintain by default?

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.

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

Professional Microsoft SQL Server 2014 Integration Services

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I write a window function query, such as this:

 SELECT firstname, lastname, team, MAX([points scored]) OVER (PARTITION BY team ORDER BY minutes) FROM dbo.[NBA_Playoffs_All-time_Player_Stats]; 

In the window, what is the default partition size for the window in the query?

Answer: RANGE UNBOUNDED PRECEDING AND CURRENT ROW

Explanation:

The default partition when an ORDER BY is included in the OVER() clause but not Range/Rows item is RANGE UNBOUNDED PRECEDING AND CURRENT ROW.

Ref: OVER Clause - click here

Understanding the OVER Clause - http://www.sqlservercentral.com/articles/Over+Clause/132079/


» Discuss this question and answer on the forums

Featured Script

Rename Database

Darren Thompson from SQLServerCentral.com

Needed a way to rename databases on the fly.

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 2014 : Administration - SQL Server 2014

creating objects in master or msdb database - Hi all, I am creating a simple job that does the following 1) create a table xxx that record the current jobs and their created...


SQL Server 2012 : SQL 2012 - General

SQL 2012 SSIS unexpected termination - When I run SSIS package through Agent, I get  "Unexpected Termination".  Has anybody faced this issue before? It does seem...


SQL Server 2008 : SQL Server 2008 - General

Override Columns in Insert and Update - I hope someone can give me suggestions on how to handle this situation of triggers.  An application will be inserting and updating...

This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected].
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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected]