Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
PASS Summit 2025 is fast approaching
The Voice of the DBA
 

DevOps is DevOps

DevOps can mean a lot of things, but I find in practice that this results in a team using Continuous Integration and Continuous Deployment/Delivery using automation to check and evaluate your software in some way. This should result in quicker delivery of updates and changes to customers, better agility, and higher quality of code.

That last one only comes if you use testing and try to ensure your code is well-written. It's easy to just use DevOps to throw out more poorly written code that doesn't perform well.

Recently, I went to a presentation on Fabric CI/CD, looking to see if I could learn something about how you might handle Fabric in a DevOps software development flow. What I came away with was the idea that DevOps is really just DevOps. In this case, Azure DevOps was being used to orchestrate the CI/CD flow, and it looked the same way I had set up a flow for a relational database.

There are differences, such as the need to have multiple Fabric workspaces and a need to understand how the code is stored and managed in Git, but the idea is the same. We use a build step to verify that any code changes can be successfully compiled and that those changes can be deployed to a new location. A workspace instead of a database, which means the code doing the work is slightly different, but the process is the same.

Testing? You want tests to verify that the code does what is expected. A lot of people skip testing with data, but I'd argue it's as important in Power BI or SQL Server as it is in C#. We ought to include tests, not because we don't know how to write code, but because others might maintain/extend/refactor our code, and we want their changes to pass our tests. Again, the details are different, but including a step to run tests is the same.

Using a flow to approve and deploy changes between environments? This is no different, and having an automated process reduces the effort, time, and risk of mistakes. This is again the same, though the details are different specifics because the code is different. Deploying a semantic model is different than pushing out a new .exe or running database changes, but the idea of an automated deployment is the same.

We, as an industry, have learned over time how to better move code through a software development life cycle. The ideas work for data-based projects as well, and we ought to be learning and adapting these to ensure we can be just as agile as application software developers.

Steve Jones - SSC Editor

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

PASS Summit 2025 is fast approaching
 
 Featured Contents
SQLServerCentral Article

Docker Advice for SQL Server in Production

Vincent92 from SQLServerCentral

Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server remains the gold standard. However, there are still certain scenarios—or even specific environments—where deploying SQL Server in containerized setups using the Docker engine becomes necessary. In this article, I will offer practical tips based on my hands-on […]

External Article

Managing Underused Indexes in SQL Server Availability Groups – Part 2

Additional Articles from MSSQLTips.com

Knowing the usage from all workloads is definitely better than focusing on only the primary or a single secondary. But what if I want to make more informed decisions, incorporating row counts, size, and index columns into this output?

Blog Post

From the SQL Server Central Blogs - SQL Server is Slow, part 3 of 4

Kevin3NF from Dallas DBAs

In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...

Blog Post

From the SQL Server Central Blogs - Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)

aen from Anthony Nocentino Blog

Update for SQL Server 2025:
This post and the GitHub repo have been updated for SQL Server 2025 RC1 and Ubuntu 24.04.
New in SQL Server 2025: You no longer need...

The Phoenix Project

The Phoenix Project

Additional Articles from SQLServerCentral

In this newly updated and expanded edition of the bestselling The Phoenix Project, co-author Gene Kim includes a new afterword and a deeper delve into the Three Ways as described in The DevOps Handbook.

 

 Question of the Day

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

 

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

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)

Strange String Splits

When I run this code, how many rows are returned?

DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食'
DECLARE @s NVARCHAR(1) = N'食'
SELECT value
FROM STRING_SPLIT(@meals, @s)
GO

Answer: 4

Explanation: This splits fine, but returns 4 rows as there is a separator at the end, which returns an extra row. The empty string after the separator is treated as a plain string (''). Ref: String_split() - https://learn.microsoft.com/en-us/sql/t-sql/functions/string-split-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 2019 - Development
Collation errors...what is best way to deal with it? - Hi I have a SP that occasionally get this error: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. The query is close to 1000 lines long so I have no idea where this is without examining each line.  Is there a way to set the collation in the SP […]
Was the index created or not? - Hi everyone I am getting an error when I create the index but I don't get any errors when I save and run the SP.  Does this mean the index was created or not?  Is there a way to verify?  The index is on a temp table. Thank you
Some query values change when query is run but not others. Why? - Hi everyone I have a 1000 line SQL query that is too long to put here so I will explain the basic logic and what the issue is. The query processes stock market data and produces a daily metric for each symbol.  There are close to 4000 symbols that get the metric created daily. I […]
using different credentials when debugging ssis - hi, now and then i want one connection in my ssis pkgs to use different creds from others.   It comes down to my admin vs my regular id.   And that basically i'm somewhat limited when i run vs under my admin acct.   Is there a way to do this?
Integration Services
SSIS Package is reporting successful however is short 80-100k records - Good morning all, I have been running into a very random weird issue that I am hoping someone has experienced and can stop my head from spinning. We have 4 environments we run about 150 flows that connect to Oracle to pull data into 4 different SQL Servers. Let's called them Dev1, Dev2, Test and […]
Editorials
We Should Demand Better - Comments posted to this topic are about the item We Should Demand Better
Article Discussions by Author
Estimated Rows - Comments posted to this topic are about the item Estimated Rows
Identify Unused Tables in SQL Server and Azure SQL - Comments posted to this topic are about the item Identify Unused Tables in SQL Server and Azure SQL
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques - Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
T-SQL Fundamentals - Comments posted to this topic are about the item T-SQL Fundamentals
Murach's SQL Server 2022 for developers - Comments posted to this topic are about the item Murach's SQL Server 2022 for developers
AlwaysON health check alerts - Comments posted to this topic are about the item AlwaysON health check alerts
Bat and SQL script to generate DB user permissions for all Databases in SQL server - Comments posted to this topic are about the item Bat and SQL script to generate DB user permissions for all Databases in SQL server
PWDCompare - Comments posted to this topic are about the item PWDCompare
SQL Server 2022 - Development
Parameter sniffing issue with different minutes as opposed to using midnight - Hej, I'm not facing this issue but as I was working another parameter sniffing issue I came to think about this and if it might cause an issue? So I'm more looking for your experience in the past and more an answer of kind "Nah, you'r good" or "You should definitely go with rounding to […]
 

 

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

 

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