| A community of more than 1,600,000 database professionals and growing |
| | The Value of Your Personal Data Years ago I read Being Digital by Nicholas Negroponte of MIT. In the book, he relates a story about crossing the border from the US into Canada and a Border Patrol agent asking the value of his laptop. He said millions, not because of the hardware, but because of the data. I thought that was interesting, and I somewhat agree. The data I have on my machines, or really now, in cloud services, is more valuable than the hardware. The hardware is barely worth anything to me, including the time it takes to reinstall my applications, because I really treat my laptop as a piece of cattle. I could drop it, render it completely unusable and I'd be back up, running, and productive with new hardware in less than 4 hours. Then I saw this article on ransoming data for iCloud users, where the request is for US$75,000. This is for Apple itself and not individuals, but what if it were for each user? What would I pay to avoid losing all the data on my mobile device? It certainly wouldn't be $75,000 despite the fact I think some of the data I have is precious. I love the pictures and video of my family most of all, but if I lost some of them, maybe all of the digital storage, would I just pay a ransom? Probably not. What about all the code in a VCS for my company? Would we pay a ransom for that? Likely we would, though perhaps not. We might think about reconstructing the code, especially if we were a small company. Ultimately I think there isn't a lot of money to be made with individuals' data. Too many of us older folks remember when we did lose physical objects and they were just gone. The idea of losing things is painful, but not inconceivable. For younger people, it seems that much of the data we produce and consume is transient and isn't necessarily that valuable to us. My kids love Snapchat for the ability to create and lose memories. I dislike it for the same reason. Much of the data we personally have can be backed up, and possibly recreated if it isn't. Many of our digital records have the characteristic that while we may have a copy, often some business or organization has another copy. Requesting new data is easy, and while it might cost some time and money, it may be preferable to the idea of paying a ransom, and potentially having to continue to pay again in the future with some virus still on our systems. I don't quite know what to think about ransomware and how this might evolve. I suspect that this will always be a problem in some way, just as hardware failures will likely plague us forever. The only solution I have is to create backups regularly that contain versions, and can be restored to separate, clean devices. I've gotten away from my own personal offline backups, mostly because of data size, but I do continue to try and keep at least 2 or 3 backups going to different locations and with different services because my data is at least that important. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial. |
| | Write, format, and refactor SQL effortlessly with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial. |
|
|
|
| | | 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 » |
| Press Release from Redgate In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool. More » |
| Additional Articles from Redgate Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script. More » |
| Andy Warren from SQLServerCentral Blogs Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and... More » |
| Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Network Navigator Power BI Custom Visual. You may find the... More » |
|
|
| | Today's Question (by Steve Jones): What two ways can I assign the value true to a variable in R? Assume I'm doing so with the variable x. |
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: R Language. 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 | Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| |
| | Jonathan Roberts from SQLServerCentral.com I just wrote this function just for the fun of it. It uses the sieve of Eratosthenes algorithm to find ranges of prime numbers and is a really fast method to generate lists of primes. It also uses a dynamic inline tally table which is a modification of this http://www.sqlservercentral.com/articles/T-SQL/67899/ by Lynn Pettis To get a list of primes between 1,000 and 10,000 just run the SQL statement: SELECT * FROM dbo.DynamicPrimes(10000, 1000) To find the count of primes between 2 and 100,000 just run: SELECT COUNT(*) CountPrimes FROM dbo.DynamicPrimes(100000, 2) etcetera... 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. Multi-Site Cluster SQL Server 2016 AlwaysON Infrastructure - Hello, I have two production site. I want to design a new SQL Server 2016 AlwaysOn Cluster for two production... Implied Authentication error in Log? - Hello everyone. I just performed an in-place upgrade for a client from SQL Server 2008 R2 to 2016 (Enterprise Ed). Everything... Tempdb allocation and Tempdb filling up - Hi, I have an odd situation. We have hosted our SQL servers on AWS (Amazon Cloud), and we have some overnight jobs... Archiving or Moving Data - Our database size is around 100GB and 50GB is occupied by a table having column datatype varbinary (max) holding documents. can... Auto Update Statistics - Hi I would like to understand when Statistics will automatically update? From what I read, it is based on modification of the... server name and network server name not the same - I'm trying to setup replication on Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Jun 9 2015 12:06:16 Copyright (c) Microsoft Corporation Standard Edition... Improving performance using partitioning - Hi All, I have a few related tables that are becoming big in size and row count. The Header table has a... Selecting all text between a distinct path - Hi, Im trying to get all the text between the third backslash and fourth backslash based on a select query - can anyone... SQL 2008R2 to SQL 2014 Upgrade - Hi guys, I am planning to upgrade my SQL Server 2008r2 to SQL 2014. As a developer I want to know... SQL Server | Architecture design - - Hi Experts, I have couple of basic queries regarding the way SQL Server is designed/works: 1) Schemas in SS is bit different from... There is insufficient system memory in resource pool 'default' to run this query. - Dear MVPs I am trying to run a script containing 500000 update statements similar to the one below: UPDATE dbo.MEMOPOOL_DATA SET... Parse numbers from Column - I have a sql table that stores weight in one column. How would I go about extracting lbs and ozs... Removing Reverse Duplicates - Hi all, I've been racking my brain all afternoon with this one. In their wisdom, the developers of this database many... how to limit table row and display remaining data in next column in sql - My table data. id clientname contactperson addr1 addr2 1 Jhon Mujeeb alld alld 2 J Alternating Cursors? - Hi All, In short: trying to check the existence of indexes across all DBs, and input into a table if not... Is there a way to bring parameter back in a drop down selection? - Just curious, how many people here would need this function ? Like a drop down you can select which parameter (profile)... Dynamic Page Number in report body - I've been finding a way to display Page number in in body of the report. But I still haven't found... I am not getting COLUMN TITLES in every page ( Why is that ) - I used VS 2015 to develop the report..... See the 2 attachments which shows my tablix properties IMAGE1 = Tablix properties IMAGE2 = Actual report... EXCEL HELL!!! - Please see the attached spreadsheet and please understand that when it comes to SSIS, I don't even qualify as an... Testing T-SQL with Unit Testing Framework - Result Sets - Show how to write a test in the Unit Testing Framework from MS that calls a stored procedure and checks... |
|
| 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] |
|
|