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

Cloud Safe

I saw a question recently from an individual that was trying to decide if it made sense to move their databases to the cloud. In this case, management wanted to move, but the technical staff had concerns about Disaster Recovery in the cloud. These are very valid concerns for any system, as technical staff is often responsible for data, regardless of who decides on the architecture of a system.

The concerns got me thinking a bit. Is the cloud safer for DR? It's certainly an "it depends" question, especially as the "cloud" isn't necessarily the same thing for each of us. Some of us would use IaaS, with VMs in the cloud. Others might choose PaaS, with RDS or Azure SQL Database as a platform. Still others might want something like Managed SQL Instances, which is like IaaS+, or maybe PaaS#. I'm not completely sure how to classify this.

In any case, your choice of cloud architecture can mean better or worse DR. The closer you are to IaaS, the more that you still have the same responsibilities that you might have inside your own data center. The difference is that hardware replacements or options are often quicker to procure, though perhaps with limited choice.

If you choose PaaS, then you have different DR capabilities and responsibilities. Your vendor might handle some aspects of DR and remove the need for you to worry about hardware, or regular backups, but you might need to worry about other items. Your vendor might give you PIT recovery, but you might not want a database replacement in a busy system, especially if you've processed a few thousand transactions since someone ran that UPDATE without a WHERE batch. In that case, perhaps you want to ensure you can restore your database elsewhere, or you have other options.

Many of us know that managing systems is complex work. Not every environment can be handled in the same way, and we often implement exceptions in both technology and staff knowledge. Ensuring your application and environment can recovery from a DR situation often requires detailed knowledge of both requirements and capabilities of the environment. While I'm not afraid of migrating to the cloud, I'd want to be sure I was prepared to answer questions from management if there are issues. After all, they're going to look to me, not some vendor, for answers.

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 ( 3.4MB) 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.

SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Database DevOps

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents


Restore a Database with CDC Enabled

Ganapathi varma Chekuri from SQLServerCentral.com

In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue. More »


Updating an expired SQL Server TDE certificate

Additional Articles from MSSQLTips.com

Simon Liew explains how to generate a new TDE certificate to replace the previous, and also looks at the steps needed if the database is in an Availability Group. More »


How to monitor the impact of patching on SQL Server performance

In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate. More »


From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 88 – Pulse Chart)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Pulse Chart Custom Visual. The Pulse Chart can easily display... More »


From the SQLServerCentral Blogs - Power BI Screen Reader Accessibility

meaganl from SQLServerCentral Blogs

I recently wrote a post on the BlueGranite blog called Improving Screen Reader Accessibility in Power BI Reports. It contains... More »

Question of the Day

Today's Question (by Steve Jones):

On SQL Server 2016, what type of data type can I pass into SET CONTEXT_INFO?

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: context_info().

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


T-SQL Querying (Developer Reference)

Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I added this data to my table:

INSERT dbo.Customer
    CustomerName ,
    statusid ,
('Acme', 1, COMPRESS('The number one source for all those road runner capturing schemes')) 

How do I get the description back in its original text?

Answer: SELECT CAST(DECOMPRESS(c.CompressedDescription) AS VARCHAR(MAX)) FROM dbo.Customer AS c WHERE c.CustomerName = 'Acme';


The reverse of the COMPRESS() function is the DECOMPRESS function. This needs to be cast back to the original datatype to get the data.

Ref: DECOMPRESS() - click here

» Discuss this question and answer on the forums

Featured Script

String Search

Patrick Slesicki from SQLServerCentral.com

For SQL Server versions 2012 and later.

Select the database to use.

Input a value for @MyString that you want to search for.

Select options for datatype and wildcard use.


If results are returned, the content of the column SQLCommand sould be copied and pasted into a new query window and executed for the final results.

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

Multiple DB's to central location - If i have lets say 5 databases all around 2-5 GB and 30 tables on 5 different servers (SQL 2012...

SQL Server 2016 : SQL Server 2016 - Administration

Data Copy for reporting purposes - Hi! @ present we have a reporting server which is for internal and external users..they run regular reports. - we keep the...

Password policy for system logins - Hi, I would like to hear your opinion on password policy for system accounts.  (not the service accounts) For our staff members...

Save off and put back stats in production - First, I apologize if this is a duplicate post.  I searched the forums and did not find what I was...

sp_DatabaseRestore - Hi, I'm just curious if others use sp_DatabaseRestore from Brent Ozar's First Responder's Kit. If so, are you having any issues...

Access users can't use SQL 2016 (?) - I'm migrating several Access backends from SQL Server 2005 to SQL Server 2016. I have successfully gotten the ODBC connections...

ToolBox missing for Maintenance task - This morning I logged into SSMS SQL2016 to edit a maintenance plan. I would add a cleanup task. But I noticed...

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

Querying against a multi-ID/Value table - I've got a parameter table that I need to get counts from. The table contains a multidimensional set of ID's/Values....

Performance improvement following a disable indexes, shrink, enable indexes - but why? - I'm stumped and need the assistance of the wider community to understand what is going on. The database in question has...

SQL Server 2014 : Administration - SQL Server 2014

Trying to copy sql backups to AWS S3 - Hello - We have weekly full and daily diff backups scheduled (created via a maintenance plan). The backups are created on a...

SQL Server 2012 : SQL 2012 - General

Grouping dates and IDs together - I have what at first (and second and fifth) glance appears to be an impossible task. I have to take...

SQL Server 2012 : SQL Server 2012 - T-SQL

SqlException :- incorrect syntax near the keyword as,incorrect syntax near t2 - Hi All, I'm trying to run this code in my asp.net app below  but getting error  SqlException :- incorrect syntax near the keyword as,incorrect...

Query - Performance between dates - Im running a query and it has numerous linked tables. I have entered a date parameter of one week (28/01/2018...

SQL Server 2008 : SQL Server 2008 - General

Summing Sales Data - Hi If I run the script below I get the following output. South - 50 - 50...

SQL Server 2008 : Working with Oracle

Oracle RAC - SQL Server equivalent?? - Anybody used Oracle RAC ?? Are there any benefits - Is there similar options in SQL Server ? Cheers guys -------------------------------------------------------------------------------- Justin Hostettler-Davies www.databaseexpertise.com

Reporting Services : Reporting Services

Combine columns under category group - Pie chart - Hi, I have a pie chart thats taking data from one of the dataset. My dataset has around 7 columns. Columns-A,B,C,D,E,F,G In...

#Error when converting HH:MM:SS to seconds using expression - Greetings!! I have the following expression that is returning a #Error, and I'm stumped on what to try next. Any help...

Data Warehousing : Integration Services

Package variables reference environment variables? - I have a package where network file paths are set up as package parameters, and these parameters are referenced in...

SQLServerCentral.com : SQLServerCentral.com Website Issues

Why can't I paste SQL code into a post??? - I've just spent 20 minutes preparing a new post in the SQL 2008 forum. It took me that long to...

SQL Server 2005 : Business Intelligence

Last date time of the report run - Hi, Again its me. Is there any global variable in SSRS which will store the last time when the report ran?...

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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com