| A community of more than 1,600,000 database professionals and growing |
| | 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.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | 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 |
| | 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 |
|
|
|
| | | Ben Kubicek from SQLServerCentral.com I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it. More » |
| 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 » |
| 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 » |
| 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 » |
| 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 » |
|
|
| | 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. 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... Recovery of database - How can we check the corruption of database with out running dbcc check db 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... 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... 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... 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 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... 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... 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... 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 [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|