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

The Technical Debt Anchor

I ran across an article on the 7 types of tech debt that can cripple your business, which is a great title. It certainly is one that might scare a lot of CTOs/CIOs/tech management. I am sure that much of the IT management gets concerned on a regular basis with how quickly their staff can evolve their software to meet new business needs.

The first two items have to do with data, which is understandable. Data is the core of how many organizations operate and move forward, and if you don't have the ability to easily work with data in a flexible way, you can struggle. Many of us technical people know this, but I find many non-data-professional staffers don't get this and are often unwilling to work at improving the situation. They things to just be magically better without changing how they do their jobs.

Many of us data professionals know that data quality is crucial. Many others assume we have quality data. Both of us need to understand that some of our data is suspect, but most of us is pretty good. Don't get drawn into a black/white argument that our data is amazing or horrible. No matter what we do, there will be errors, so account for that. At the same time, do some testing, some evaluation, and double-check yourself.

We also need to ensure some level of performance from our data stores (databases, data lakes, etc.). Too often we see queries start to slow down and blame the DBAs. We ask them for better performance without being willing to press on developers (or vendors) to improve the performance of their code. Don't just expect to build bigger machines, make sure you train staff to write better queries and help DBAs learn how to better index systems. We're a team, so let's work as a team on our performance issues.

There are a few AI-related items and a couple of DevOps items as well. All tech debt is a problem; it just depends on how much you have as to how big a problem it is for your systems. However, the seventh item is cultural debt. AI is part of this, as staff can have job-threatening views of AI, but that's really a lack of trust. Management has to build trust with staff and ensure they are cared for if management expects staff to be accountable for code. Workers have to drive themselves forward, as a part of the technology revolution is that change is a given. Don't expect to do the same job you've done for years. Learn to use new tools and learn to use them effectively in your position.

At the same time, management has to value employees and be clear about what's expected or workers. Be fair with employees and value their efforts. Working together is what will drive your organization forward.

Steve Jones - SSC Editor

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

 
  Featured Contents
Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode

Tony Davis from SQLServerCentral.com

In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved

External Article

SQL Server Developer Standard Edition: A Gift to Developers!

Additional Articles from SimpleTalk

Starting in SQL Server 2025, a new edition is available for installation: SQL Server Developer Standard Edition. This article dives into this edition, the problems it solves, and why it is a great addition for development teams that use SQL Server!

Blog Post

From the SQL Server Central Blogs - From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences

Klaus Aschenbrenner from Klaus Aschenbrenner

After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling to a country where everyone speaks a language I mostly understand – but with a different accent...

Blog Post

From the SQL Server Central Blogs - Database Concurrency: MVCC in PostgreSQL vs Row Versioning in SQL Server

Rohit Garg from MSSQLFUN

What is Concurrency in Databases? Concurrency control ensures that multiple transactions can occur simultaneously without leading to data inconsistency. Two popular concurrency control mechanisms are: MVCC in PostgreSQL PostgreSQL...

Microsoft Power BI Quickstart Guide cover

Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, 3rd Edition

Site Owners from SQLServerCentral

Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.

 

  Question of the Day

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

 

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED() 

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)

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

Answer: The the table is frequently truncated and reloaded

Explanation: The recommendation for heaps is when tables are frequently truncated and reloaded, such as for staging tables. Ref: When to use a heap - https://learn.microsoft.com/en-us/sql/relational-databases/indexes/heaps-tables-without-clustered-indexes?view=sql-server-ver16#when-to-use-a-heap

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 - Development and T-SQL
Getting year part out of a string that represents a date - Hi, I have a requirement to fetch the year from an imported .csv  file that can hold any kind of date , in any format as delivered to use by municipalities that manage to get their own ideas of the template they need to use. Basically the date can have many formats , like  YYYY-MM-DD […]
Dropping a PK constraint. - I will have to test this next week, but will not have a chance before Friday. My question is, if I backup table data, drop a PK to add it back as an identity PK, will the foreign keys referencing the PK still be in tact? The new PK (now with identity) will keep the […]
SQL Server 2019 - Administration
disable remote access - If I configure remote access to 0 on my servers, am I right in saying that the only things that would be affected are any linked servers && log shipping jobs. Thank you.
Creating Maintenance plan to run annually - What is the best way to set the schedule of a maintenance plan or a SQL Agent job to run annually. We need to move data to an archive database for a table end of each year for the oldest year. I have the scripts all ready but the scheduling is the issue. For this […]
SQL Server 2019 - Development
Is there a way to implement ROWS between logic? - Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow for a rolling sum calculation.  This is very useful.  I would like to do the same for PERCENT_RANK but this function does not have this option available.  Suppose there are 100 daily records and I want to calculate the PERCENT_RANK on […]
skipping the second line in a spreadsheet being read by ssis - hi, my new user provided a new multi tab (sales, customer etc. not what i really wanted either) excel spreadsheet for ingestion by our sales warehouse etl.   Its second line is his erp's column names.   The first line is somewhat close to what i asked for in column names.   for the moment im looking the […]
Editorials
Multiple Monitoring Tools - Comments posted to this topic are about the item Multiple Monitoring Tools
SQL Server 2025 Excitement - Comments posted to this topic are about the item SQL Server 2025 Excitement
Patching the Patch - Comments posted to this topic are about the item Patching the Patch
Events
Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden - The LA Data Platform User Group had a necessary speaker cancellation for the group meeting on 18 June 2025.  They fired a flare asking for a replacement speaker and I responded.  And so I'm giving the presentation that's in the title of this post. I had to limit the size of the abstract and so […]
Article Discussions by Author
How to Choose the Right Tool for MS SQL to PostgreSQL Migration - Comments posted to this topic are about the item How to Choose the Right Tool for MS SQL to PostgreSQL Migration
Inside the Walls of Azure SQL MI - Comments posted to this topic are about the item Inside the Walls of Azure SQL MI
SQL Server 2022 - Development
XML_COMPRESSION for existing tables - We are in the process of upgrading to SQL Server 2022 and would like to make use of the XML compression feature it offers, as we have a handful of tables that store considerable amounts of XML data. I suspect the answer is "no", but is there a way to enable XML compression on an […]
SQL - Conditional merge join - I want to add a condition in the joining columns part of the merge statement like this : Merge dbo.tblDest as target using (select ...) as source on target.EmpID =  source.EmpID and target.AwardID = source.AwardID  --this second condition I want to add only if the source.AwardID is not null. How to do that pls advise. […]
Tracking changing prices and recalculating inventory value - I'm trying to figure out a how to do average costing over time in T-SQL... I'll use up ingredient inventory over time, and every six weeks buy more.  So the "leftover" ingredients would be valued at [Weight Remaining] * [Per Kg Price]. Then when I buy new inventory, the new total value would be [Weight […]
 

 

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]

 

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