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

The Change Failure Rate

This editorial was originally published on Jun 3, 2019. It is being re-run as today is a US holiday.

One of the measurements used in DevOps to determine if your team is improving is the change failure rate. This is the number of times that there is a problem with a deployment as a ratio of the total number of deployments. The idea here is to determine the reliability, and to some extent, the risk of deploying changes in your environment.

In the past, I've been very successful with deployments as a DBA or developer. Often I've completed database changes within the change window, with success that allowed our applications to run after changes. That doesn't mean I pressed a button and the deployment worked. On a regular basis, my expertise with SQL was needed to fix a script or re-run a process, or make some other "development change" in the production environment to ensure the entire deployment completed. While still a minority of times, this wasn't an uncommon experience.

Many people have had the same experience, as the State of DevOps report has shown for years. In both the application and database worlds, doing anything other than pressing a button or running a single script is a deployment failure if the steps aren't clearly documented and run to completion without any alteration. Not a catastrophic failure, and certainly one that many of us can recover from, but still a failure from the standpoint of being ready to deploy and having a reliable process.

Quite a few of us have made a career of cleaning up other people's messes in deployments, with our ability to get changes deployed and applications back up and running being a testament to our expertise and skill. That's not a reliable process, especially when an organization is forced to depend on a Steve or a Brent or a Kendra to ensure smooth deployments. That's a recipe for disaster, especially as all of us want to go on holiday, undisturbed by some software "emergency".

I think this is one of the more telling metrics for a strong software development process and a reliable deployment process. If this number isn't extremely high, in the 95-99% range, then our organizations are spending resources, especially time, on items that don't add value. Instead, we ought to invest in moving to a DevOps style process that allows our expertise to be used solving new problems, not cleaning up the mess of the poor development practices of others.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022

Noman072 from SQLServerCentral

Learn how to use bit manipulation functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022's. Learn practical examples and common errors to simplify binary data management.

Technical Article

Find Text in Stored Procedure, Function, View, or Trigger

Additional Articles from SQLServerCentral

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?

Blog Post

From the SQL Server Central Blogs - Visualising SQL Server in Kubernetes

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

The other day I came across an interesting repo on github, KubeDiagrams. What this repo does is generate Kubernetes architecture diagrams from Kubernetes manifest files…nice! Deploying applications to Kubernetes...

Blog Post

From the SQL Server Central Blogs - Picking a Starting Table in Test Data Manager

Steve Jones - SSC Editor from The Voice of the DBA

I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things...

Refactoring Databases cover

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

 

  Question of the Day

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

 

Mixed Backups

I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO 

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)

Precision and Scale II

What is the precision, scale, and length for an int variable?

Answer: 10, 4, 0

Explanation: The precision of an int is 10, the length is 5, and the scale is 0. Ref: Precision, scale, and length - https://learn.microsoft.com/en-us/sql/t-sql/data-types/precision-scale-and-length-transact-sql?view=sql-server-ver16

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 - Development
Execution Timeout Expired Error while executing an SQL query - Following error comes while executing an SQL query. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This happens after 30 seconds, even though I have set the Command Timeout property to 300 seconds. Here’s what I’ve already verified: The connection is working fine. I've […]
SQL Server 2019 - Development
IF then Else statement not exiting - I have an always on availability group of 3 servers (1 primary and 1 secondary (both on primary site) and the other secondary on DR site, as the only read-only secondary). A scheduled job runs every day that should only execute the tsql if the server is the primary derived from the 'sys.dm_hadr_availability_replica_states',  here's my […]
SQL Azure - Administration
Replication from SQL Managed Instance to RDS - Is transactional replication from SQL MI to RDS SQL server supported. There isn't any documentation available from Microsoft. There are a few articles about replicating from Onprem SQL server to RDS or Azure SQL DB to RDS, I couldn't find anything for SQL Managed Instance. If not replication, are there any other options available for […]
Microsoft's comparison to Azure DB vs Managed Instance - I'm migrating to the cloud from SQL Server 2016 to the cloud. On the list of differences between Azure DB and a Managed Instance, there are several features listed, such as DBCC, and DML Triggers where they say that Azure DB has "Yes, most". How can anyone find this as an acceptable answer. Any idea […]
Storage Cost - What will be the storage cost 1 Managed Disk – S15; 256 GB HDD in Azure for DISK it costs around $11.33 per month in addition to that I want to know exact cost for 100IOPs for S15. Also it would be great one can share cost for E15 too.    
General Cloud Computing Questions
what is the difference between these two queries - Please I am struggling to understand the difference between these two queries. It behaves differently as output google bigquery query 1 UPDATE dde-demo-d001.sap_crm.document_flow_root_bods SET case_guid = ICT.case_guid FROM dde-demo-d001.sap_crm.document_flow_root_bods DFR INNER JOIN dde-demo-d001.sap_crm.inferred_case_transactions ICT ON DFR.transaction_header_guid = ICT.transaction_header_guid WHERE DFR.case_guid IS NULL; query 2 UPDATE dde-demo-d001.sap_crm.document_flow_root_bods DFR SET case_guid = ICT.case_guid FROM (SELECT transaction_header_guid,case_guid FROM […]
Text search emails and other json items - Problably SQL Server is not the best solution What would you use for searching lots of emails / jsons on specific terms? We're trying to provide a solution to business to allow to search if a specific mail is sent Like subject contains X sent around interval. Body contains Y
Integration Services
"External table is not in the expected format" - Good Afternoon. I have been manually running an SSIS package on an adhoc basis, which populates an Excel file from a SQL Server Table. There is no apparent issue with the package, but often I get the following error: "External table is not in the expected format" And it resolves when I Shut Down and […]
Backups
Hyper-V VM / Google Drive syncing issue - Hi everyone, I have a server running **Windows Server 2022**, named **"DATA SERVER"**. This server has two drives: **C and D**. What I Did: 1. **Enabled Hyper-V** and created a virtual machine (VM) called **"DATA VM"**. 2. Used **Disk2VHD.exe** to create **VHDX files** of the host machine's **C and D drives** and attached them to […]
SQL Server 2022 - Administration
Error when running sql server backup routine job - Guys, I am facing problems when running a backup routine JOB in SQL Server, when trying to run the JOB, it returns an error. When checking the JOB history, this message appears: Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. […]
error when trying to change replication settings - We have three servers that use SQL replication; PROD, BI, and PARTS. We have one database that replicates from PARTS to PROD and we have a around five databases that replication from BI to various Azure servers. We used to have a database called IRES that replicated from PROD to Azure - but we deleted […]
SQL Server 2022 - Development
Solution to a problem without using a CURSOR - Hi there to all SQL gurus So, here is the scenario. I have a #temp table in one of my SQL stored procedures which has only 2 columns, say Customer ID and Profile ID, and it has the below data Customer ID          Profile ID 100001              […]
Prepare Sum of Bill Amount Having two different status with fast performance - 1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL, [PARENTID] [nvarchar](10) NULL, [ACID] [nvarchar](10) NULL, [MEMBERID] [nvarchar](10) NOT NULL, [MEMNAME] [nvarchar](70) NULL, [PRINTNAME] [nvarchar](50) NULL, [GENDER] [nchar](10) NULL, [ADDRESS] [varchar](30) NULL, [DOB] [varchar](20) NULL, [PROV] [int] NULL, [GROUP] [nchar](2) NULL, [USERID] [nvarchar](15) NULL, [DISTRICT] [int] NULL, [PWD] [nvarchar](100) NOT NULL, […]
sql server not responding - SQL server became slow before I ran exec sp_updatestats
what happens to ssis and ssrs whenb we migrate to sql saas - Hi we know (or believe)  ssas saas gets stood up separately when a company migrates to sql saas. But what happens to ssis and ssrs?  from what i remember there is no such thing as ssis in azure.   And the recommendation on sssrs is to move all those objects to pbi as paginated reports.  we […]
 

 

RSS FeedTwitter

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

 

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