SQL Server sees the cloned database as a user database, meaning that you can treat it as one, including backup and restore - Steve Jones explains.

Displaying Backup or Restore Progress

by Additional Articles

SQLServerCentral

Backup and restore

Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.

AlwaysON Availability Group and Jobs Part 2

by Leo Peysakhovich

SQLServerCentral.com

Availability Group (AG)

This article will provide the actual implementation of the control mechanism.

What do you do when you have a repetitive task to do?

by Ben Kubicek

SQLServerCentral.com

Editorial

When faced with repetitive tasks how do you go about doing them in a focused timely manner?

Performance Myths: Table variables are always in-memory

by Additional Articles

SQLServerCentral

Performance

Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.

AlwaysON Availability Group and Jobs Part 1

by Leo Peysakhovich

SQLServerCentral.com

Availability Group (AG)

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.

So, you didn’t get the job; maybe it is YOUR fault.

by Rodney Hess

SQLServerCentral.com

employement

Why I am now motivated to brand myself.

SQL Data Mask: now featuring configurable masks

by Additional Articles

Redgate

data masking

SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.