SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Selling Automation to Ops

This editorial was originally published on Jan 12, 2015. It is being republished as Steve is traveling.

The DevOps movement isn't new in some companies. It's the same coordination and teamwork that has existed for a long time between the development and operations staffs. Developers take advantage of the skills in Operations to get standardized environments for their work, and let the Ops people manage (and track) changes. Operations people talk to developers about the challenges and issues faced in production, and the let the developers build applications that can easily be deployed. The sharing of information ensures each group knows what the other faces, and the regular contact builds bonds and respect between employees. Neither wants to let the other down or make someone else's job any harder than it needs to be.

However that's not the case in many companies where developers view Operational staff as complainers that slow the process down. Operations staff see developers as wild and irresponsible, tossing code into production that they don't need to support and haven't tested. Both of these views are correct in that each side sees a reality in the process that makes their job more difficult.

Ultimately I believe it's up to developers to change things. Those of us that build the software need to respect the problems that instability causes and learn to help ensure that our changes can be deployed smoothly. The development side of an organization has more skill in tracking changes in version control, in managing the movement of those changes among environments, and in programming systems. We should be working to help push that knowledge through to Operations personnel that become responsible for our applications.

That means we need to build scripts and tools to migrate our changes and give them to Operations. I'd recommend that we learn how to automate the configuration of our development systems, as well as script our changes. Most modern platforms allow us to programmatically make changes, so let's do that. Then let's take a few hours and show Operations people how to use these scripts, and let them setup and change our development environments. It will be slow at first, but they'll learn to make changes faster, but also bring stability to every environment from development to QA to production, and can ensure we have the same configurations everywhere. We'll have one less thing to manage, and our changes will get deployed faster, but also more consistently.

Ultimately we all want the same thing. Better software delivered to customers faster.

Steve Jones from SQLServerCentral.com

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

ADVERTISEMENT
SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

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

 

Using Redgate API to compare data in the same table

Ben Kubicek from SQLServerCentral.com

I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it. More »


 

Configuring a MySQL Database on Amazon RDS

Additional Articles from Database Journal

Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database. More »


 

Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt

This article is all about using a SQL Prompt snippet to create and run a test harness on a batch of SQL code, to provide performance data. Behind the scenes, the snippet creates and starts an Extended Events event session, inserts and runs the text of the batch of SQL you’ve selected in SSMS, and uses XQuery on the XML event data, to return it in digestible, tabular form. More »


 

From the SQLServerCentral Blogs - Data Factory V2 Activity Dependencies are a Logical AND

meaganl from SQLServerCentral Blogs

Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as... More »


 

From the SQLServerCentral Blogs - how to embed a PowerBI report into HTML code

Eduardo Pivaral from SQLServerCentral Blogs

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the... More »

Question of the Day

Today's Question (by Steve Jones):

I have this table:

 CREATE TABLE UserConfig ( UserConfigKey INT IDENTITY(1,1) NOT NULL CONSTRAINT UserConfigPK PRIMARY KEY , UserID INT , IsActive BIT SPARSE , IsSubscriber BIT SPARSE , DefaultQuantity INT SPARSE , Options XML COLUMN_SET FOR ALL_SPARSE_COLUMNS ) GO 

I want to insert a new row and use this statement:

 INSERT dbo.UserConfig ( UserID , Options ) VALUES (8, '<IsActive>3</IsActive><IsSubscriber>0</IsSubscriber><DefaultQuantity>99</DefaultQuantity>') GO 

What happens?

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: Column Sets.

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

ADVERTISEMENT

Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2

Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services.

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have this code:

 DECLARE @SomeVar VARCHAR(2000) = 'Wolfedschlegedsteinhausenbergerdorffwelchevoralternwarengewissenhaftschaferswessenschafewarenwohlgepflegeundsorgrbsetkldsdfsssdffd' SELECT QUOTENAME(@SomeVar,'{') 

What is returned?

Notes: 

  • the string length is 130 characters
  • the answers have some of the middle of the string removed. This is for publication. Assume the entire string would be in the middle of any other characters

Answer: NULL

Explanation:

The string is 130 characters, which is too long for a SQL Server identifier. Therefore a NULL is returned.

Ref: QUOTENAME - 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 - Development

EBCDIC file is getting loaded with all special characters in my table - Hi, I have an EBCDIC file and I am trying to load it using SSIS. I created a flat file connection manager,...

Forecast monthly values over time - I've been reading through the many "forecast" keyword articles and forum posts here to see if I can find anything...

Init-cap the characters in SQL server - Hi Sir, How to Init-cap the characters in SQL server in SQL query without creating any function? create table abc (Month_Name nvarchar(10)) [code...


SQL Server 2016 : SQL Server 2016 - Administration

Recovery of database - How can we check the corruption of database with out running dbcc check db


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

Querying records on multiple XML Node elements - So I've been trying to solve my problem for a few days now with the help of the famous XMLTable...

Finding recent date from two tables - Hi All, I have a table design like below. What is the best to identify most recent date from StartDate and...


SQL Server 2014 : Development - SQL Server 2014

Convert int field into date and format issue - Hi All, I'm hoping to get your advice on this. I'm trying to take an int field, AccountingPeriod, value, convert it to a...

Sorting by a column when the name is derived via a CASE statement - Hi everyone I have created the following SQL statement which works fine. However, it would definitely be beneficial if I could...

looping through all databases to find dependencies (cursor) - I want to have a go-to query that finds all dependencies of an object, across all databases (without requiring any permanent object like a...

Identifying field value corresponding to MAX of another field value - Hey All, I'm hoping to get your expertise on this. I'm trying to populate a temp table as part of a...


SQL Server 2012 : SQL 2012 - General

Running SSIS Package in scheduled job - Hi, I'm trying to run SSIS package stored on my local PC through SQL Server Agent job , and it always fails. When...


SQL Server 2012 : SQL Server 2012 - T-SQL

Talking about SARG - So this is partially theoretical and partially based on a real situation with NDA applied. Since I can't name columns,...

Anyone see a problem with this? - I asked a developer to write a simple query against this table of mine.  He looked at me and said...

What's wrong with my table? - Some guy at the company I'm creating a database for tells me my table needs to be redone or he...

Query slow. Help improve? - Hey all.  I have a contract building a database for a company that bills other companies, and I wrote what...

HOW TO GET FIRST DATE - Dear all, I have data like:      NAME                             SPONSOR_NAME     DATE_OF_CALL        A                                    FI


SQL Server 2008 : T-SQL (SS2K8)

Convert Local Time to UTC - Is there a good way to convert a local time to UTC time? I expected to find some sort of...


Programming : General

Is this query correct ? - I dont understand the red marked part in my book.  Is this query correct ? book is using live e , live m...


Data Warehousing : Integration Services

Read Length of first Row and Header Row Delimiter through SSIS Script Task - Hi Guys, I have two questions. I am automating the process through SSIS to load the .txt file into SQL...


SQLServerCentral.com : SQLServerCentral.com Website Issues

Feature request, please... - Not sure if the forum software will do this, but if it can, PLEASE add a "ignore topic" option. Yes, this...

This email has been sent to newsletter@newslettercollector.com. 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