| A community of more than 1,600,000 database professionals and growing |
| | 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.comJoin 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. 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 | | 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. |
| | 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. |
|
|
|
| | | 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 » |
| 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 » |
| 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 » |
| 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 » |
| 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 » |
|
|
| | 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. |
|
|
| |
| 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 |
|
|
| | Database Pros Who Need Your Help |
| |
| 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] |
|
|
|