SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

DR Planning

Data professionals know that protecting and ensuring our data is safe is one of our primary jobs. Many of us worry that if we were unable to recover a database, our job might be jeopardy, which makes sense. If we lose data, an organization might make the decision that we aren't trustworthy enough to manage a database system. This leads many of us to plan and prepare for different types of disasters, with procedures and systems in place to ensure that we can quickly get things running after an issue.

Natural disasters, or other large scale disruptions of business sometimes exceed the plans we've put into place. Fortunately they're rare, but I ran across an article that talks about a few items that we might not consider when making plans. Even if you can fail your database over with an Availability Group running in another location, there are still some points you might want to think about.

Perhaps the biggest one for me is that testing is not optional. I've seen some amazing plans put into place, but never tested because no one wanted to disrupt ongoing business activities. Testing is really critical, perhaps because of the second more important item I see cause issues: failback. This isn't always as simple as we'd like, even with some of the amazing work that Microsoft has done with SQL Server. We want to ensure that we do know that if something happens to our primary systems and we move them, we can come back. After all, these are the primary systems for a reason.

While other items such as making DR planning something your organization cares about can matter, I think the viability of this depends on how likely these disasters are. If you're in a seasonal hurricane path, or some other disaster, you likely need to have better plans than if you're in a stable region. Not that you can avoid any plans, but most of the time a disaster is a rare event and it's really IT's job to ensure that systems are resilient.

I do think it is worth noting that regulatory compliance isn't optional. While your auditor might have sympathy if they are likewise affected by the disaster, that sympathy dissipates over time. A disaster next month might not factor into an audit review in 20 months. More laws are on the books and more are coming than most of us have dealt with in the past. Design your system and process to be compliant, even in a disaster.

Lastly, the people side of business can't be emphasized enough. While some of us might be expected to shoulder a greater workload during a disaster, keep in mind that we would still need support outside of work, perhaps even a replacement worker to handle some of our work tasks or even help with personal items. The longer our lives are disrupted, the less likely we are to work as hard, or remain focused. Part of any plan should be how can our organization help support those that are struggling themselves. After all, the effects of a localized disaster on business could get compounded if staff stops coming to work.

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 ( 4.5MB) 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 Monitor

How SQL Server monitoring benefits your whole organization

SQL Server monitoring doesn’t just benefit your DBAs. In this new guide from Redgate, we take you through the different ways a robust monitoring solution has a positive impact across your organization, from your development teams to IT management, and from finance to your C-suite. Download your free copy now

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

Featured Contents


A Tiny Trauma

Mike Tanner from SQLServerCentral.com

Unexpected issue with a hidden calculation on TinyInt More »


Better Code Reviews with GIT

Additional Articles from SimpleTalk

As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git. More »


Complimentary access to Gartner’s 2018 Market Guide for Data Masking from Redgate

According to Gartner, "security and risk management leaders should use data masking to desensitize or protect sensitive data to address threats and compliance requirements." Gartner further adds, "by 2021, the global enterprise use of data masking (DM) or similar de-identification techniques will increase to 40%, an increase from 15% in 2017." Redgate is acknowledged as a representative vendor for data masking. Redgate are offering complimentary access to the report. More »


From the SQLServerCentral Blogs - Read-only tables

Kenneth Fisher from SQLServerCentral Blogs

Sometimes you need a table that is read only. You don’t want anyone to be able to write to it... More »


From the SQLServerCentral Blogs - Easy Permissions Audit

Jason Brimhall from SQLServerCentral Blogs

Something I have written about more than a handful of times is the need to audit. When people think about... More »

Question of the Day

Today's Question (by Steve Jones):

How many indexes must a memory optimized table have?

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: Memory Optimized Tables.

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


Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

Prepare for Microsoft Exam 70-774 and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.  Get your copy today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I use this code to set a value for a key in my session context:

EXEC sys.sp_set_session_context @key = N'SupplierKey', @value = 7

Now I want to change this value from a string to a numeric. What happens when I run this code?

EXEC sys.sp_set_session_context @key = N'SupplierKey', @value = N'Acme'

Answer: The statement succeeds


The session context value parameter is a sql_variant, so this works with a number of data types. Changing from a string to a numeric or back works fine.

Ref: sp_set_session_context - click here

» Discuss this question and answer on the forums

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

auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases - Hello everyone I am looking to generate a restoration script for hundreds of databases with their backup Full and log file...

SQL Server 2017 : SQL Server 2017 - Development

Question about instalation - Hi, I installed the development copy of SQL Server on my Surface Pro (I have the latest one), and I installed...

split data in equal halves - Hi, I have source data as below. How can i split the data into equal halves and get the other half...

Cause of arithmetic overflow error? - What is causing this error in the following code: Msg 8115, Level 16, State 8, Procedure sp_calcArea, Line 10 [Batch Start...

SQL Server 2016 : SQL Server 2016 - Administration

HA VS DR - What is the difference between high availability  and disaster recovery ? Also  proxy and credentials

upgrade to 2016 causing performance problems - Hi all Experts, We have strange problem (at least for our case), we have database in 2012 which was restored...

Large Suspect Database - Hello, I have a large (~1.5TB) database that is in suspect mode.  Long story short we had some I/O issues...

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

CASE with LEN Evaluation - I'm struggling with this bit of code within a case Statement: CASE     WHEN (LEN(())) = 1 AND = '0' THEN '99991231'    ...

Split column values using delimiter and insert them into referenced table - Hello, I am copying few million rows from Table1 into Table2 via INSERT INTO...SELECT. Caveat is that 1 column(Column5) in Table1...

Sort already comma separated list - Hi I have values like this in a column which basically is the exact same thing if sorted . ORM;

SQL Server 2014 : Administration - SQL Server 2014

Agent Job Long Running - Sorry a bit new to how blocking works so forgive me if I sound stupid. We have an agent job that...

ODBC Driver 17 for SQL Server - Linked Server failure - I have a problem where my linked server works for about 12 minutes and then fails.  Sorry I do not...

Need Help with Views - SQL Server 2014 enterprise edition 64 bit Windows server 2012 R2 Standard Edition 64 Bit Database A  TableA Create Table TableA ( Varchar(10) NOT...

SQL Server 2014 : Development - SQL Server 2014

Case When Between issue - I have a list of suppliers and their next review date. The date is always on a Monday but there...

Find individual column mismatch between source and target - Hi All, Source table: CREATE TABLE EMP_CLIENT(  ID INT     NOT NULL,  NAME VARCHAR (20)  NOT NULL,  AGE INT     NOT NULL,  ADDRESS CHAR (25) ,  SALARY DECIMAL (18, 2),  ...

Merge Multiple Rows into a logic - Good Day, Please find below my requirement : --SOURCE TABLE CREATE TABLE .(      (20) NULL,      (20) NULL,      (40) NULL,    &nb

SQL Server 2012 : SQL 2012 - General

Sql Server 2012 Database Mirroring - I am running sql server standard 2012 with SP3. I am thinking about setting up database mirroring to a report server. The...

Reporting Services : Reporting Services

SSRS 2008 Tablix bold just one row? - Is there a way, in SSRS to have just one row on a table (Tablix) highlighted if that one row...

Record count in dataset is different that excel exported record count. - All, I've got a query as an embedded data set in a report on SSRS2012. When I run the SQL...

SQL Server 2005 : SS2K5 Replication

THE PROCESS COULD NOT CONNECT TO A SUBSCRIBER - I am receiving the following error when I try to replicate from SQL SERVER 2005 to ORACLE THE PROCESS...

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