Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Prompt
The Voice of the DBA
 

The State of DevOps Report for 2019

It seems like just a few weeks ago that I went over the 2018 results with Gene Kim. That was an exciting few weeks for me, running over the report in prep and then having the opportunity to host a webinar with Gene Kim. Exciting times, but it's been almost a year and the 2019 report is out. You can download the 2019 Accelerate: State of DevOps Report from the DORA site and read it yourself, but I found a couple interesting things in the report.

As expected, companies adopting DevOps are outperforming those that don't, at least in the metrics measured. In fact, it appears that the high performers continue to outperform low performers in two major ways: speed and stability. What's interesting, and as was pointed out by Kendra, is that these aren't on the same scale, meaning there isn't a trade-off between the two metrics.

You can move fast and achieve higher stability. In fact, moving fast can lead to higher stability if you are learning and growing from your efforts to build and deploy software. This includes the database, though that's not called out in this year's report. Instead, the report talks about ways to achieve speed and stability.

One of those is tools, and more importantly, easy to use tools. Staff will turnover or change positions. Knowledge can be hard to share in busy environments, so tooling is important. Bespoke, bought, homegrown, open-source, it's important that the tooling is easy to understand and that it performs at some job in an efficient manner.

There are other items in the report, but one thing I think we often ignore is that sticking with your old process and people doesn't mean you'll fail. You clearly have some people and process in place that works, as you're in business now.

However.

Both speed and stability help you work more efficiently. They help you compete better against others, and should ensure you reach your goals sooner. Speed increases value for customers, which in turn should help you improve how your organization functions. Stability makes both customers and staff happy. One thing the report points out: productivity has a positive impact on workers. They deal with stress better and burnout less.

Hopefully helping with more creativity in solving problems, more engagement with customers' success, and less turnover. DevOps is better for your software, and your staff.

Steve Jones - SSC Editor

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

Redgate University
 
 Featured Contents

Optimize Your SQL by Reformulating the Spec

jacobsp from SQLServerCentral

As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.

Goodbye to the Microsoft Professional Program

Additional Articles from SimpleTalk

Kathi Kellenberger addresses the retirement of the Microsoft Professional Program in the latest SImple Talk Editorial. Stop by and let her know your thoughts.

Neglecting to Use, or Misusing, the RETURN Keyword (BP016)

Additional Articles from Redgate

Phil Factor demonstrates the correct use of the RETURN keyword in stored procedures or batches, to pass back a non-zero RETURN code to the calling process, informing it of the error. He also explains some of its misuses.

From the SQL Server Central Blogs - How I Troubleshoot SQL Server Execution Plans

Bert Wagner from Bert Wagner

Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....

From the SQL Server Central Blogs - Local Database CI Builds with Jenkins in a Container

Steve Jones - SSC Editor from The Voice of the DBA

In two previous posts, I’ve showed how to configure Jenkins in a container as well as how to add the SQL Change Automation plugin. This post looks at an...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Configure Polybase

I want to enable my SQL Server instance to use the Polybase connection to Hadoop. What option needs to be configured?  

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Formatting the date

If I have this code:

>>> import time
>>> myString = '02/08/2019'
>>> myDatetime = time.strptime(myString,"format_string")

What is the correct way to enter the format_string for a date in August using numbers?

Answer: %d/%m/%Y

Explanation: The strptime() method from the time module needs to know the format of the string to properly place the character. The day format is #d. Month is %m. Year is %Y. Ref:

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 - Administration
Cannot generate sspi context (sql server) - Hi,   Can't login to this SQL Server using Management Studio remotely - but can when RDPed to the server itself?
SQL Server 2017 - Development
Azcopy usinf sql sp - Hello Experts, I am working on SP that sends my csv file from on prem machine to Azure blob container. I am using lastest Azcopy v10. DECLARE @Program varchar(200) = '"C:\AzCopy.exe"' DECLARE @Source varchar(max) = 'E:\Backup\abc.txt' DECLARE @Destination varchar(max) = 'https://myaccount.blob.core.windows.net/' DECLARE @DestKey varchar(max) = 'secret key' DECLARE @Options varchar(max) = '/S /XO /XN /Y […]
SQL Server 2016 - Administration
SQL Server Agent stops unexpectedly - Buffer Overflow - Our SQL Agent has been randomly crashing for the last month and a half. The last time it crashed we had procmon running on the server monitoring SQLAGENT.EXE and prior to it shutting down there was a bunch of Buffer Overflow events, see screen shot attached. There was a probably a 1000 of these all […]
Performance related question - This (performance) is the area time to time I struggle with. Couple of days ago, we had an issue where all of a sudden, an application started running slow. I was told to look into it from a SQL Server side and I couldn't find anything (atleast from what I know) because all the available […]
Basic Avaialbility without active Directory - Hi , I am trying to configure Basic Allwayson in SQL 2016 Standard edition using the below ebsite https://www.sqlpassion.at/archive/2016/01/11/how-to-create-a-sql-server-availability-group-without-an-active-directory-domain/ I did below things. Firewalls off in both nodes SQL-1 & Sql-2 I created DNS Suffix in both servers as Testing.com Remote registry and Remote administration is enabled in both nodes. i enabled Failover clustering In powershell […]
issue with sql connectivity - Hi Experts, This is more of a generic question on sql connectivity. Under what circumstances, users will not be able to connect to sql server instance. The services are up and running though. Firewall is open. TELNET is working and still users are complaining that there app's are unable to connect to sql server. What […]
SQL Server 2016 - Development and T-SQL
SQL Lite Data Types VS T-SQL Data Types - I am having trouble running this SQL Lite on my T-SQL. I changed the NUMBER to NUMERIC n Decimal in SQL Server. Still i am getting this error. What would be the equivalent data type in SQL Server. All of the other SQL Lite code are running on my SQL Server Express, except this: DROP […]
SQL Server 2012 - T-SQL
Trying to insert from table 1 with missing index to table 2 with index - Table 1 is missing an index that was supposed to be in place when the table was created that is set to unique. The table has an identity column. I have created the table 2 new with the index in place and is empty. (Table 1 and 2 are the same structure except table 1 […]
Insert into Select with Conditions - Hello, I think my requirement is fairly straight forward, but cant seem to get the syntax right or find a solution. Im, trying to do a Insert into Select , that will allow duplicates only if a field value in a row is null. hope that makes sense. - thanks Greg
SQL Server 2008 - General
Relations of system tables, Sys.dm_exec_connections?sys.dm_exec_sessions and ... - What are the relations among Sys.dm_exec_connections? sys.dm_exec_sessions and sys.dm_exec_requests and what are the relations among Sys.dm_exec_connections? sys.dm_exec_sessions ?sys.dm_exec_requests and sys.sysprocesses ? I check it on MSDN,but not clear the explanation yet, could you please help me to make a detailed explanation ? thanks
SQL Server 2008 Performance Tuning
Huge speed difference with clause "If exists" - I have a fairly simple stored procedure that checks to see if a value is present in a view. It's horribly slow when it's executed one way, and reasonably quick another way. i don't understand why there is such a difference. Here they are: Slow: if exists (select 1 From BotCBO.vwClovekStrings_PrZk Where ClovekString = '[gmelin]') […]
Data Transformation Services (DTS)
dtexec delay validation true - I have a SSIS package that loads a flat file.  It runs fine on my laptop but on my virtual machine I have to set DelayValidation to true otherwise it looks like it loads the data then removes it from the final table.  On the virtual machine if I run the package from the Visual […]
Integration Services
Package complete but a task is still running, not getting all of the data - Ok, so using SSIS (Visual Studio 2015) and running a single package from the IDE. Now there is no event logging etc. The message come up at the bottom of the screen to say its completed.  Everything looks complete. I open up the data flow task and strange things appear. As in the picture below […]
Possible double hop issue - SSIS Package / SSIS Catalogue - Wanted to check if anyone else was able to resolve this and how they did it. In a nutshell we have a package stored in SSIS catalogue on Server – S1 which reads files from Server – S2 ( NAS share) and then the  package stored in SSIS catalogue is executed via a C# app […]
SQLServerCentral.com Website Issues
Search box returns error when clicked -
 

 

RSS FeedTwitter

This email has been sent to {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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -