SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

DevOps Isn't Perfect

I saw a post recently from Grant Fritchey, Help Me, Help You, Deliver DevOps. In it, Grant shows that DevOps isn't making developers do everything, it isn't just giving developers more responsibility, and it isn't developers handling some of the operational staff responsibilities. It's about getting development and operations to work together. Hence, DevOps, not DEVops, or Dev    ops.

In the post, Grant also links to some fundamental failures from companies that supposedly have adopted DevOps processes. Companies like Gitlab and Amazon. There are plenty more examples, which certainly make some people question whether DevOps is better than other methods of building and deploying software.  How are the VSTS issues different from the Knight Capital debacle?

In some sense, they aren't. In many cases, we've had a software issue that affected customers. People were upset, services weren't delivered, and it's entirely possible that revenue was lost. However, one of the things that I think differentiates DevOps is that developers and operational staff can troubleshoot and determine a root cause much quicker. Since the entire commit, build, test, release pipeline is instrumented and documented, your staff can quickly determine what new items might have caused an issue. If it's not a new item, they can also quickly determine if that's the case.

However, once you've placed your system in production, DevOps doesn't ensure that your HA (High Availability) or DR (Disaster Recovery) preparations are adequate. Those are still the responsibility of your Ops staff, but by using DevOps, and storing configuration as code and provisioning your systems in all environments the same, hopefully you've taken advantage of this to actually ensure you have tested some HA or DR features in an environment outside of production.

However, DevOps isn't prescriptive advice. DevOps isn't a particular process or a tool that you use or install. DevOps is about learning and improving over time. For different companies, this means you'll be at a different stage in your DevOps maturity than other companies. Some have complete deployment processes, but limited instrumentation and monitoring in production. Some have tons of data and deploy code perfectly, but no HA. Some have great HA, but poor deployment processes.

DevOps is about constant improvement and advancement to make your software development (Dev) and deployment (Dev and Ops) and monitoring/management (Ops) better over time. This might not prevent human error, or even code bugs, but DevOps should mean you make fewer mistakes, less often, and learn from them to avoid repeating those issues.

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.7MB) 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 Clone

NEW SQL Clone - version 1 now available!

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free.

Featured Contents


Enable Trace Flags in SQL Server

Steve Jones from SQLServerCentral.com

Learn how to enable trace flags to change the behavior of your SQL Server instance. More »


Deployment Automation for SQL Server Integration Services (SSIS)

Additional Articles from SimpleTalk

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects. More »


From the SQLServerCentral Blogs - SQL Server Fixed Role Permissions

Jason Brimhall from SQLServerCentral Blogs

Roles and Permissions Some of my recent articles have been focused on permissions and security. There is good reason for that – security... More »


From the SQLServerCentral Blogs - Dots, Skills, and SQL Clone: A Contest from Redgate

Steve Jones from SQLServerCentral Blogs

Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean... More »

Question of the Day

Today's Question (by Steve Jones):

What keyboard shortcut can be used in SSMS 2016 to hide the results pane in the query editor?

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: Management Studio (SSMS).

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


Securing SQL Server - Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the largest and most complex SQL Server installations in the world. This edition includes new chapters on Analysis Services, Reporting Services, and Storage Area Network Security.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What is the U-SQL SQL.MAP datatype used for?

Answer: pairs of values in array form


The SQL.MAP datatype is an array that stores pairs of values.

Ref: Stairway to U-SQL Level 13: SQL.MAP - http://www.sqlservercentral.com/articles/U-SQL/153306/

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

Need to know what I should install for my SQL - Hi! I am trying to configure a SQL server for production. it is going to be stand alone server, could you...

Production SSRS Report Issue - Hi All, Two days back we migrated one database from one server location to another server location, But now when we...

Report server Issue - Hi All, In Our production the client is generating the report from one server to another, but it shows the below...

File Share Witness in Multiple Clusters - Morning All, Can a single File Share Witness (about 10GB in size) be used to provide quorum for multiple clusters. I have...

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

Logical OR comparison between two queries hangs - Hi, Faced an interesting problem. Following is the Query am using. SELECT 1 WHERE( ((SELECT count(1) FROM View1 WHERE field1 = 'Y') > 0) OR ((SELECT count(1)...

Encapsulating complex logic without using a scalar UDF - I have business logic for date comparisons that go beyond the typical DATEDIFF functionality.  For example, when determining the number...

SQL Server 2014 : Administration - SQL Server 2014

Unable to fetch result from linked server - Hi Experts, In our production server, we are using one query to fetch the result from linked server, using one particular...

Refresh table data from Prod to UAT - Hello Folks, What is the best approach to refresh UAT table from Production. Tables have foreign key constraints and identity keys....

DB restore stucks after recovery step - Hi, trying to restore my db for testing https://www.sqlservercentral.com/Forums/1862799/checkdb-Multiple-IAM-pages-for-object I splitted the restore process into 2 steps, i restore full with...

SQL Server 2012 : SQL 2012 - General

Availability Groups Removed & Readded Database Problem :exclamation: - I had a bit of a server meltdown this morning that necessitated me removing one database from my availability group...

SQL Server 2012 : SQL Server 2012 - T-SQL

get info from a variable of a huge set of databases with same schema and table name???? - Hi, Can you please help with with this query? I need to set two columns as result: db_name and sum...

SQL Server 2008 : SQL Server 2008 - General

Clustered scan vs Non-clustered Seek with lookup - Hi I think the answer to this question will be "it depends" but i'm interested to know what the variables might...

SQL Server 2008 : T-SQL (SS2K8)

'Spell check' a string-valued field - Hello all, We have a field in a table that's a string-valued field. In this field are (mainly) what I'll call...

SQL Server 2008 : Working with Oracle

Oracle's OLEDB Provider VS Microsoft OLEDB Provider for Oracle in SSIS - It has been a couple of years since I worked with Oracle within SSIS and I seem to recall having...

SQL Server 2008 : SQL Server Newbies

How does a SQL Script Execute - I have a project that I have inherited and the previous caretaker has made a SQL Query that should be...

I can't get Modify (Maintenance Plans) to do anything. - In SSMS, when I highlight a maintenance plan that I successfully created, right click, and then select Modify, nothing happens....

SQL Server 2008 : SQL Server 2008 Administration

T-sql Replication info - I have a publisher with 300+ articles being pushed (1-way trans). The db has way more tables than that, but...

Reporting Services : Reporting Services

Report with multiple parameters. - My report creates a patient list of radiology patients and has a parameter for ExamType, Location, Ordering MD, and Dictating...

Data Warehousing : Integration Services

More "ACE" driver frustrations. Large Integers loading as exponentials - Ok... well I just made a topic and I never appeared, that's really really annoying... I'm going to cut this shorter...

Data Warehousing : Analysis Services

Creating Date & time table help - I two tables one is master and other one is detail, its not structured yet, Please see sample data Master Table: Ticket_Num    ...

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