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

A Backup Change

Backups are a fundamental skill for most DBAs, and hopefully, for most technology professionals. For developers, I'd hope that most of you use some sort of version control, and that you back up your VCS database. I actually had someone ask why we needed to back up the VCS if we had the code on our machines. Certainly the local code on your system, or in your database, provides you some level of redundancy, but all the branches, all the code from other developers, you really want a real backup. For git, this is a simple file level backup.

I recently got a letter from Crashplan, who I've been using for a few years as a backup provider. Apparently they are exiting the home backup market, choosing to focus on businesses. I chose them since it was an economical provider, with good ratings, that let me back up multiple machines. I've been happy with them, tested a restores of a few files, but never needed the service. Now, I need a new solution. I keep two copies at home, but what about a fire or disaster? I want an offsite backup.

One of the things I've wanted with a backup solution is a hands off process. While I've managed to use cloud sync software and VCS reports to move most work stuff from one machine to others, there are pictures and other data that I don't want to lose. I've also got computers for my wife and kids that I'd like to have backed up. The Crashplan subscription for 5 computers worked great for me.

It doesn't seem there are a lot of providers out there for families. Most focus on businesses or the individual, which is fine. Backblaze seems like the next best choice, and at $50/yr/computer, perhaps that's a fair price. I've considered using Amazon Glacier and CloudBerry software, but that feels like I'm giving myself another management job to track. Though, maybe with PoSh available cross platform, I could just build a set of scripts to let each computer notify me if there are issues. I'm still trying to decide what makes sense.

Backup is important, and it's becoming a more cumbersome job over time. As my family generates more pictures and video, I get more concerned about backup. Especially the cost. The same problems and challenges I face as a DBA, though often with a slightly bigger budget. However, the challenge of balancing a budget with the requirements to meet some RPO is the same.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

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


How might classification and better documentation improve data safety?

SQL Atlas is the latest prototype to come from the Redgate Foundry - find out more about what the tool does and try out the interactive demo for yourself. Try the free prototype

Featured Contents


Moving Dynamic Data Masked Data to New Locations

Steve Jones from SQLServerCentral.com

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement. More »


Free eBook: Fundamentals of SQL Server 2012 Replication

Press Release from Redgate

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege. More »


Protecting SQL Server from Ransomware

Additional Articles from MSSQLTips.com

The problem of ransomware seems to be increasing. Major organizations are being hit and their servers are being affected. K. Brian Kelley explains some of the basic things you can do to reduce your expose to ransomeware. More »


From the SQLServerCentral Blogs - Toolbox - IO, IO, Why are You So Slow?

Andy Galbraith from SQLServerCentral Blogs

This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts)... More »


From the SQLServerCentral Blogs - CALCULATE and FILTER: A Love Story?

Koen Verbeeck from SQLServerCentral Blogs

There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going... More »

Question of the Day

Today's Question (by Steve Jones):

I have a simple matrix of values that represent some data. The data looks like this:

> m

     [,1] [,2] [,3] [,4] [,5]
[1,]    1    1    1    1    1
[2,]    1    2    2    2    1
[3,]    1    2    5    5    1
[4,]    1    2    5    5    1
[5,]    1    1    1    1    1

I'd like to get a quick visualization of this. If I run the image(m) function, what type of image to I get?

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.


SQL Server T-SQL Recipes

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I want to create a large database in the year 2017, but I don't want to calculate a number of bytes. What are the options for the scale of numeric values in the MAXSIZE parameter? Meaning, as an example, can I use 10KB as a value instead of choosing 10240?

Answer: The KB, MB, GB, and TB abbreviations can be used.


As of now (2017), only the KB, MB, GB, and TB abbreviations can be used.

Ref: CREATE DATABASE - click here

» Discuss this question and answer on the forums

Featured Script

SQL Agent jobs that run SSIS packages

TD Knight from SQLServerCentral.com

I was recently tasked with moving / ugrading SSIS packages from one server to another and I was instructed "to only move the packages that are executed by jobs".

This script joins three tables; sysjobs, sysjobsteps, and sysssispackages. It produces a list showing package name, job name, package folder name, and the job command. It is written for packages stored in msdb, but could easily be adapted for an SSIS package store. Additional columns could also be added.

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

Installed edition - All, We have a license for Standard. I installed the developer edition thinking that it was the same install so I could...

msdb data file shrinkfile - Large Database - Hi , The msdb data file on a prod db server  is 6 GB, Though I truncated the large tables  when...

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

Creating View, but also need to Declare, use a Procedure to call within the view? - Hello, I have a select that used declare, and now I need to make that select a view, and I...

Convert Teradata CASE to t-SQL CASE with CAST and an Operator - Hello, I've got a Teradata Case statement, and I'm trying to convert it to a T-SQL Case statement, and I...

ssrs 2016 pivot capability over tabular models - Hi, my tabular model has survey data with various dims including interviewer (employee), form, study, case #, questions etc.  And the core...

Convert this SQL Agent Job Step to Powershell - Hi Everyone Is there a way to convert this SQL Agent Job Step to Powershell? it's being executed with Type OperatingSystem(CmdExec) if...

difficult (for me) query to count available items - I have a difficult sql calculation to make, and I dont't find the answer. Can someone help me? I have a...

SQL Server 2014 : Development - SQL Server 2014

Help with query... - Hi, I've 2 entities, opportunities and properties, with certain fields and that can have features. I'd like to get: 1. All properties for...

SQL Server 2012 : SQL 2012 - General

Getting access deni when running a package - Hello, I have created a package to copy some files from a directory D:\FicheirosZipadosDiarios' I am getting an error saying that the...

Running total with reset condition - hi all, i would like a running total with a restart after a certain limit.  Let set the condition to be...

Can't connect to SQL Server via IP - Have SQL Server installed on a Windows 7 machine which is being used as a server (not my idea).  Company...

SQL Server 2012 : SQL Server 2012 - T-SQL

comma separated values - I have a table which contains values like FarmID + commodity. Example would be  ID      Commodity 1          Apple 1          Pear 1          Strawberry 2          Onion 2          Carrots 2          Or

Problem with parameterized query - Hi All, I have a problem with a parameterized query. I need to pass the conditions as following exec sp_executesql N'select * from companies...

Copy records from one DB to another - Hi all! I have this pretty simple table: CREATE TABLE .(      NULL,      NULL,      NULL,      NULL,      NULL,      ...

Eliminate cursor with while loop inside it - Good morning, I am trying to migrate transactions (charges/payments) from a old application to a new one. The new application works as...

SQL Server 2008 : T-SQL (SS2K8)

Query returns 122 million records in 9 hours - We have a very silly weekly process to to do the Full Load of 5 year data in to Qlikview Application...

SQL Server 2008 : Working with Oracle

PL_SQL compares with T_SQL - I think this is a place I can ask this question, because most  people here may know both PL_SQL and...

SQL Server 2008 : SQL Server Newbies

Suspect production database - Good Morning Experts, We have a production database that has gone into suspect state. What are the step-by-step process to fix...

Reporting Services : Reporting Services

This may be due to a connection failure, timeout or low disk condition within the database - Hi All, I am getting this error whenever I try to run a report through report server. It appears to be...

Data Warehousing : Integration Services

Problem Debugging Script Task - Hi. We have a strange problem when trying to debug a script task in SSIS 2012. Here's the scenario - my...

This email has been sent to {user_email}. 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com