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

Requiring Technical Debt Payments

I was working with a customer recently that is trying to improve their processes. This was a large company, over 100,000 employees, though most of them aren't in the technology area. However, across many divisions and groups, there are a lot of developers and operations personnel who have tended to work in silos, managing their own applications and systems in disparate ways.

In other words, doing software development the way most companies do it.

I had been working with one group to streamline and standardize some of their software practices to implement more of a DevOps flow to smoothly build, operate, and update their systems. They've had some success and other groups noticed that this set of teams is very efficient. They aren't DevOps like a lot of the articles you read. They still have development and operations, but the groups work closely to ensure efficiency.

They started to get requests to onboard other teams into their flow as the management of this group has been advertising their sucess. Other groups want to implement Continuous Integration, get database unit testing and static code analysis setup, implement gates for approval, and more. The Operations team manages most of this and is happy to help other groups.

But

They require some things to be in place, some of which are cleaning up technical debt. Not all debt, but certain things that create additional risk or instability. Before they onboard anyone, they don't want to take on a codebase that is difficult to manage. A lot of this debt isn't difficult, but they want some good coding practices implemented. They require integrated security or a waiver from InfoSec. They want explicit index names, not system-generated ones. They want permissions granted to roles, not users. Not big things, but little items that make a system less maintainable and understandable.

The same things a lot of us let creep into our codebase over time.

On one hand, I thought this is an idea that will slow adoption and allow many groups to continue to operate inefficiently. They won't clean up code. On the other hand, this might be the lever that helps create a better run environment across the organization. This might help them smooth their upgrade cycles, let staff change between projects, and more importantly, reduce the overhead of communication and work between teams.

I don't know how this will work over time, but I am interested to see what happens.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Using the FP-Growth Algorithm to Mine Useful Patterns in Data

Daniel Calbimonte from SQLServerCentral

This article looks at using the FP-Growth algorithm from Python to mine data in SQL Server.

External Article

How to Use the New PRODUCT() Function in SQL Server 2025

Additional Articles from SimpleTalk

Introduced in SQL Server 2025 CTP 1.3, the PRODUCT() function acts similarly to SUM(), but multiplies values rather than adds them. It is an aggregate function in SQL Server and therefore operates on a data set, rather than on scalar values.

Blog Post

From the SQL Server Central Blogs - Get required permissions for DMVs

Randolph West from Born SQL with Randolph West

Part of my job at work is to update Transact-SQL reference content. System dynamic management views (DMVs) have permissions that are managed in the SQL Server Database Engine source...

Blog Post

From the SQL Server Central Blogs - Why DBAs Still Need to Know the Foundations of SQL Server

SQLEspresso from SQLEspresso

Over the years, I’ll admit, SQL Server has come a long way in making life easier for database administrators and with each version it keeps getting better and better....

Architecting Power BI Solutions in Microsoft Fabric

Steve Jones - SSC Editor from SQLServerCentral

Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.

 

 Question of the Day

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

 

Change Tracking Data Retention Options

If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);
What are the possible choices for xxx?

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)

Copying Production Schema

If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?

Answer: You can only copy or not copy query store data and/or stats info

Explanation: There are flags to not copy statistics info or not copy query store data. All schema objects are copied. Ref: DBCC CLONEDATABASE - https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-clonedatabase-transact-sql?view=sql-server-ver17

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 2016 - Administration
Object owner question - Hello, Currently all of our tables e.t.c are owned by dbo. In one of our databases I need to move the tables to a different owner to prevent an ownership chain. What I'm a bit unsure about is the best type of account to use for the table owner. I think 'user without login' is […]
SQL Server 2016 - Development and T-SQL
Encryption or Certificate - Trying to NOT put hardcoded password in Proc - We have a few stored procs where we need to a dos command "net use" EXEC master..xp_cmdshell 'NET USE \\\ /USER:<domain\username>    /PERSISTENT:yes'   I am trying to figure out a way to retrieve a password stored somewhere that is obfuscated from nefarious people, via encryption or any other way really, So that […]
SQL Server 2019 - Development
Next dates - CREATE TABLE ADMITS ( ID_NUM INT varchar(15) null ,provider_id varchar(15) null ,provider_name varchar(36) null ,ADMIT_DATE DATE NULL ,DISCHARGE_DATE DATE NULL ,swpa_description varchar(max) null ,date_dispensed DATE NULL ,drug_name varchar(max) null ,discharge_to_dispensed int ) INSERT INTO ADMITS (ID_NUM,provider_id,provider_name, ADMIT_DATE, DISCHARGE_DATE,swpa_description,date_dispensed,discharge_to_dispensed) VALUES ('008012773','006467','WHITE DEER RUN LLC', '2024-02-06', '2024-02-11','Residential Detox, Rehab, HWH (non hosp)','2024-02-22','GABAPENTIN, 300 MG ORAL CAPSULE',11) ,('008012773','006467','WHITE […]
SQL Azure - Development
How to resolve issue of custom Audit log table containing incorrect data? - We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that are associated with the parent record. […]
Amazon AWS and other cloud vendors
Moving a database from AWS RDS Custom to RDS Standard - Having real fun with this. It isn't possible to set the option group, to enable the AWS SQL backup routines, because you can't execute the CloudShell command to assign an options group (aws rds modify-db-instance), in RDS Custom. I can't restore an RDS Custom snapshot, because that will just create another RDS Custom, and I […]
SSRS 2016
ssrs subscription file share - I am trying to create a subscription that posts to a one drive directory.  I reset my password through microsoft and then copied that password when setting up the file share subscription.  When the subscription executes I get 'a logon error occurred when attempting to access the file share.  the user account or password is […]
Integration Services
OLE DB Provider SQLNCLI11.1 Is Not Registered - I am not sure if there are components I need to install on my local PC or on our server, so I am hoping for some help. I have Visual Studio 2019 installed.  For a few years, I have been creating SSIS packages for a Microsoft SQL Server 2016 (SP1) - 13.0.4001.0 (X64).  I had […]
Editorials
Data Sovereignty in the Cloud - Comments posted to this topic are about the item Data Sovereignty in the Cloud
Ghostworkers - Comments posted to this topic are about the item Ghostworkers
MySQL
MySQL 5.6 not writing any logs - We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of errors. The below is a snippet from the ‘my.ini’ file:     # Commented lines aren’t included [mysqld] […]
Article Discussions by Author
What is Delayed Durability in SQL Server — And Should You Turn It On? - Comments posted to this topic are about the item What is Delayed Durability in SQL Server — And Should You Turn It On?
Which MAXDOP? - Comments posted to this topic are about the item Which MAXDOP?
Fetch fields like email address from multiple records into single cell - Comments posted to this topic are about the item Fetch fields like email address from multiple records into single cell
SQL Server 2022 - Administration
SSL certificate to connect Google Looker Studio to on-prem SQL Server - We have been asked to connect Google's Looker Studio to an on-prem instance of SQL Server 2022. Our instance has "Force Encryption" enabled, and uses a private domain CA certificate. In the connection string dialog for Looker Studio, there is an "Enable SSL" checkbox and an option to upload a Microsoft SQL Server SSL Configuration […]
SQL Server 2022 - Development
where did my topic on a new ssms 21 bug go - Hi should i repost my latest ssms 21 bug, the one in which sql agent now doesnt show property details on steps in the gui but does show them when the job is scripted?   It disappeared a couple of hrs ago because it was under eval.
 

 

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

 

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