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

Database DevOps Metrics

The DORA organization is dedicated to helping others build software better and faster, at a higher quality, and in a way that is more efficient. They continue to compile and publish the Accelerate State of DevOps report every year, which is a fascinating read.

As a part of the report, they have identified four key metrics that identify high performing organizations in terms of software. These are divided into two areas: throughput and stability. Throughput measures are change lead time and deployment frequency. Stability measures are the change fail percentage and failed deployment recovery time.

For a long time, as I chatted with various people doing database work, it seemed that most people deployed relatively infrequently. They might deploy a couple times a week for software changes, but database changes were often less than once a week. There have always been people moving faster or slower, but that felt like the pace for a majority of people. These days, in the 2024-2025 timeframe, many people seem to be able to deploy database changes every week, often multiple times a week.

Lots of people have moved to more throughput, with more frequent deployments and less change lead time. Most of us can't get more work out of people, so if we deploy more often, their completed work gets released quicker. Those two metrics make some sense, and I think those are good measures, but not goals. What I find is that people often need to make changes quicker either to respond to changing needs of their organization or to fix bugs they've introduced. I wonder what the ratio is of the former to the latter? I suspect it might be less than one.

The stability metrics are often high for most people I speak with about deployments. I don't see a lot of failures at deployment time as code usually compiles and deploys. It's often a day (or week) later that someone notices the code doesn't do what they expect. Is that a deployment failure? I think not. What's the MTTR if it's fixed an hour after report? An hour or a day plus an hour? I don't know how these metrics apply to databases, especially if data gets mangled and has to be corrected manually over hours/days/weeks. Is that in the MTTR? Can you even track it?

Metrics are good ways to measure you progress or health, as long as the metric doesn't become the goal. I've run into a lot of customers using these metrics to measure their development, and it does help most for a period of time. Whether this continues to help them improve often depends on whether they keep focusing on their goals of delivering better quality software faster.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Create Raw Zone Tables using Generative AI: Data Engineering with Fabric

John Miner from SQLServerCentral

In this next article we look at how to use Generative AI to build tables.

External Article

Scales & Measurements

Additional Articles from SimpleTalk

If you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put data directly into a database; we have to encode it and represent it in a format which a machine can handle.

Blog Post

From the SQL Server Central Blogs - Marketing Analyst: The Data-Driven Superhero Your Company Needs

Tracy McKibben from RealSQLGuy - Helping You To Become A SQL Hero

Want to blend your love of marketing with the power of data? Becoming a marketing analyst is the way to go. This job is all about measuring how well campaigns actually work, understanding...

Blog Post

From the SQL Server Central Blogs - Can You See Table Valued Parameters in Extended Events?

Grant Fritchey from The Scary DBA

I live for questions and this was an interesting one. Can you see Table Valued Parameters that have been passed in to Extended Events? I literally have no idea....

T-SQL Fundamentals

T-SQL Fundamentals

Additional Articles from SQLServerCentral

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

 

  Question of the Day

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

 

Replacing a NULL II

What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; 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)

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server.

Can I do this?

Answer: No, this doesn't work with local loopback addresses

Explanation: You can store database files on an SMB file share, but not with a loopback address. Both \\127.0.0.1 and \\localhost are not support. Ref: SMB File Share - https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-with-smb-fileshare-as-a-storage-option?view=sql-server-ver16#installation-considerations

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
Log Shipping Not Able to Restore Log Files in Secondary - I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I have restored the database in the follow storage layout on the SQL Server 2017 machine: D:\Data\.mdf L:\Logs\.ldf When I execute the restore job and it skips all log backups. I ran restore verifyonly for the log backups […]
SQL Server 2016 - Development and T-SQL
SSIS - ADO Source Datetime Issue - I'm using an ADO Net Source to extract data and running into an issue with timestamps changing before reaching the destination. I can log directly into the source system and see a value should be 2025-03-01 00:03:14 but SSIS is brining it back as 2025-03-01 01:03:14. I put a data viewer on it so this […]
Where to see how a Partition schema and function is defined - Please see the below. The dependencies of a table(the table depends on) shows Partition function and partition scheme. However I cant seem to find how and where this function is defined? I can see only user defined functions? Please guide on this
SQL 2012 - General
DbaTools With Powershell - Omit The Id Column on CSV Export? - I am learning DbaTools in Powershell, and my current project is exporting a CSV file. I've managed to get the code to work; however, there are situations in which I will need to omit the Identity column when exporting.  Is there a way to do this programmatically in DbaTools, so that the CSV file won't […]
SQL Server 2019 - Development
Move Files SSIS Task - Hi I have a task in my SSIS package that moves files from source folder to destination folder.  It works if there are no duplicate files being processed.  That is, suppose fileABC.txt is found in both source and destination folder then something went wrong in the processing from earlier SSIS tasks so I want to […]
String or Binary Truncation Error Strange Behavior (SQL 2019) - Forgot I posted a similar issue back in 2020, String or Binary Truncation Error Strange Behavior, but here we are again, 5 years later with a somewhat similar issue. Here is the message from SQL Server: String or binary data would be truncated in table 'dbo.BAT_Test', column 'NewCode'. Truncated value: ''. Basically, a stored procedure […]
Cummulative Total - Hi I have below query and i want Cummulative Total . Total should be reset on change of Account SELECT ROW_NUMBER() OVER (PARTITION BY Account ORDER BY A."Account") AS "Row No", A."Account" AS "Account",(A."Debit") AS "Debit", (A."Credit") AS "Credit" From Master A Thanks
SQL Azure - Administration
Migrating mission critical database from SQL on Prem to Azure SQL - We are migrating our environments to Azure, it will be a mix of SQL managed instances and Azure SQL instances depending on the different system requirements. We offer realtime service to out clients and need to have minimal downtime hen we make the shift. The first database will be migrated to AzureSQL. Our on prem […]
Transactional Replication from Read replica - If I have Read replica (in Azure SQL MI), can it be used as a Publisher in transactional replication setup. I understand that Replication creates objects some objects in Publisher db, can we use listener name with applicationintent setting anywhere for it use Secondary instead of Primary. AWS DMS works similar to how transactional replication […]
Azure Data Factory
Is there a way to determine an Azure Data Factory Trigger's "next run time"? - Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a scheduled trigger will run next. Is similar functionality available in ADF?
Anything that is NOT about SQL!
Fantasy Football 2025 - The thread for the league in 2025. Players from last year have priority.
SQLServerCentral.com Website Issues
Everyone is a Newbie? - Everyone seems to be a Newbie with zero points today! Browser = Chrome
SQL Server 2022 - Administration
SQL availability group and file server role answering from the same name - Hello, I'm tasked with setting up a 2 node server cluster that will host a MS SQL availability group. I have the servers setup and the AG looks to be working well. However, there is also a requirement to hang a share off of one of the drives. I'm not crazy about this requirement, but […]
Installing SQL FCI Instance certificates - SQL FCI Instance certificates I have a client who has a requirement for certificates bound to the instance in a FCI environment. I have create the certificate and installed on both nodes, but I get a cluster error when failing over. The environment setup Node1 Node2 FCI Instance name\SQLInstance   Have set the FCI and […]
SQL Server 2022 - Development
SSIS how to manage source control with multiple packages / projects - We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams.  I thought this was the proper way to go.  The problem is managing this when I am in the middle of developing one of those solutions.  What I usually do is just make a copy of the folder the solution […]
 

 

RSS FeedTwitter

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
[email protected]

 

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