From the Article:

The goal is repeatable, reliable software deployments, with releases, or at least deployments, being an everyday occurrence, not a big event.

I have to strongly disagree... the goal is...

@Grasshopper's solution does not work for negative numbers, so here's his version that does work for negative numbers:

create function dbo.RoundToEven(@num numeric(38,19)) returns decimal(19,2)
begin
return case
  ...

Good Lord!  I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop.  The results...

Thanks for the post about SQL 2022, Jeff. I've reached out to my team and mentioned that we need to fix all the problems we're currently having with SQL...

Yes. ...

The only difference I see between that code and mine is CONVERT rather than CAST ... I didn't realize CAST had that "big overhead".  (Presumably using LEFT rather than...

IF the MMDDYYYY formatted string date is guaranteed to always be 8 characters, the following works (most of the posted code doesn't consider the inclusion of the ".txt") according to...

• This reply was modified 2 years, 5 months ago by Jeff Moden. Reason: Missed Scott Pletcher's code and added credit to him there

Deleted.  Made a mistake and didn't check before I posted. 🙁

Here's a quick question for you because we have to enforce such things where I work... do you want the conversion to fail if the date contains less than 8...

From the article:

A few of them are in this post, though he's written a book with 450 pieces of advice.

My first thought when I read that was when they replaced...

All,

I'm new to Powershell so this could be a simple error.

I'm using a SQL agent job to backup a database to a UNC path and then rename it.

The...

I see a lot of focus here on not reindexing at all - mostly because no one can prove that reindexing improves performance.  I am not sure how that...

I have to second Michael's recommendation yet again.  Stop doing index maintenance on your RowStore indexes until you can prove some significant performance benefit.  Use the time to do Statistics...

Good Lord!  I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop.  The results are REALLY...

Since you're not using SQL Server (based on the INT4 datatypes you used), it may be that the RDBMS you're using doesn't allow CTEs (Common Table Expressions),...