| A community of more than 1,600,000 database professionals and growing |
| | | Does Speed Compromise Quality? One of the parts of DevOps that is often hyped is the speed and frequency of releases. Starting with Flickr and their 10 deployments a day, to Etsy deploying 50 times a day, we've seen companies showcasing their deployment frequency. Amazon has reported they deploy code every 11.7 seconds on average. That seems crazy, but with so many applications and lots of developers, not to mention each change being smaller, perhaps it's not completely crazy. With the forum upgrade here at SQLServerCentral, we had two developers (with occasional other sets of eyes reviewing code changes), and while we were bug fixing, we deployed multiple times per day. Is that a good idea? Does a rapid set of changes mean that quality is lower and more bugs are released? It certainly can. In fact, if you're a development shop that struggles with releases and code quality, producing software faster is not going to help you. In fact, if management pressures you to adopt DevOps, and deliver code faster without culture change, without implementing automated testing, including for your database code, and using automated scripts, tools, or something to deploy software, then you are going to get more bugs out faster. You'll still get to change direction quicker if you find you're building the wrong software, but you'll still end up becoming more inefficient because of bugs (And technical debt). There's a fantastic video (long) about refactoring code in two minutes. A bit of an oxymoron since the presentation is nearly two hours long, but the video is from a real project. However, their approach is that good unit testing allows them to refactor code, to change things, without introducing bugs. That's a big part of the #DevOps philosophy. I always note in my DevOps presentations that if you can't implement unit testing, meaning you won't bother, then you don't get much benefit from CI, CD, or any DevOps ideas. Tests protect you from yourself (and others). In many of the DevOps reports, companies that release faster report fewer bugs and less downtime. Since Amazon has increased their speed, they have 75% fewer outages across the last decade, 90% fewer time down, and many, many fewer deployments causing issues. Turbotax made over 100 production changes during tax season and increased their conversion rates. The State of DevOps reports bear this out (2016 here). Thousands of responses show that speed doesn't cause more bugs. Because they work differently. If your management won't let you change the way you work, if you don't implement automated unit tests (and other types of tests), if you don't take advantage of version control, if you don't ensure every change is scripted, then you won't work differently, and speed will bring bugs. You can do better. Your company can do better. Will they? Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.2MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | 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. |
| | | | Library of articles for DevOps, DLM, & Continuous Delivery Discover best practices and processes for more agile methods of database delivery. Find out how automating the build, test and deployment of database changes reduces risk and speeds up the delivery cycle. Read more on Simple Talk. |
|
|
|
| | | | | Stan Kulp from SQLServerCentral.com This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table. More » |
| | To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More » |
| | Additional Articles from MSSQLTips.com In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps. More » |
| | Rob Sewell from SQLServerCentral Blogs In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the... More » |
|
|
| | | Today's Question (by Steve Jones): In order to use SSL with your SSRS instance, what mode should Reporting Services be installed in? |
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: Reporting Services (SSRS). 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 | | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): How often is the entire Azure SQL Data Warehouse backed up? Not snapshots, which are incremental, but the entire warehouse.
Answer: Every 24 hours Explanation: At the time of this question, the Azure SQL Data Warehouse (ASDW) was backed up each 24 hours. Ref: SQL Data Warehouse (Under Geo-redundant Backups) - 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 Disk Latency - Hi Folks, we have a curious situation that I can only partially explain. A SAN that hosts a large highly-transactional database reports... Query to backup the databases on a SQL instance using a config table - Hi Folks, I am looking for a script that would help me take the backup of different types e.g (Full, Diff... SQL Server upgrade 2012 to 2014 cleanly - how? - My test server is running SQL Server 2012 SP3 on Windows Server 2008R2 SP1. I’m practicing an upgrade to SQL... Getting first Saturday of February for any year - Hi, I've got the following code down but it's currently returning the first Monday of February for every year whereas I... Improving performance using partitioning - Hi All, I have a few related tables that are becoming big in size and row count. The Header table has a... Selecting all text between a distinct path - Hi, Im trying to get all the text between the third backslash and fourth backslash based on a select query - can anyone... SQL 2008R2 to SQL 2014 Upgrade - Hi guys, I am planning to upgrade my SQL Server 2008r2 to SQL 2014. As a developer I want to know... Help in finding actual days and hours difference!!! - Hello All, Mass associations without looping? - Basically I have a table T1 with people, and another table T2 with their contact mechanisms say their phone numbers... Retrieving Maximum and Minimum Timestamp of a certain day from a set of timestamps - Hello everyone, I'm new on these forums and hopefully this topic is at the right place. I have a rather annoying problem,... Parse numbers from Column - I have a sql table that stores weight in one column. How would I go about extracting lbs and ozs... how to limit table row and display remaining data in next column in sql - My table data. id clientname contactperson addr1 addr2 1 Jhon Mujeeb alld alld 2 J Running Total - I have the following dataset: CREATE TABLE #mytable ( PartNum varchar(50), DueDate datetime, RequirementFlag tinyint, Quantity decimal(22,8)) INSERT INTO #mytable (PartNum, DueDate, RequirementFlag, Quantity) SELECT '00-5472',20/03/2017,1,-261.00000000 UNION... redesigning table to accommodate new data types - i have a table in which there is column called Marks of type int. This is used to save the... DBCC CHECKDB error! - Following error I am getting when I ran DBCC CHECKDB('databasename') WITH NO-INFOMSGS Msg 8939, Level 16, State 98, Line 1 Table... Everyone has access - I've deleted out all the users and groups from report server and even went as far as deleting them all... Dynamic Page Number in report body - I've been finding a way to display Page number in in body of the report. But I still haven't found... Execute Process Task - Python Script - I'm having the following error when executing a python script manually via VS. Error: In Executing "python.exe"... SSIS Package runs fast through SQL Agent first time only - We had a consultant come in to try to help us speed up our processes. Every time we implement a... EXCEL HELL!!! - Please see the attached spreadsheet and please understand that when it comes to SSIS, I don't even qualify as an... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
