No problem Edward!

And Jeffrey thanks for pointing out to look at the Execution plan.

I knew CHOOSE would become a CASE, but I never knew it was that visible!

The CHOOSE function will select the 3rd (CatID value of the only row in dbo.Categories) value of the rest of the CHOOSE function parameters. But there is no 3rd value,...

The customer I got hired by uses automated deployments now with flyway (desktop) from AzDo pipelines, for over a  year now, with success.

My migrations / implementation journey is available on...

Cool stairway series, thanks Erin!

Last year there was a survey on the use a VCS for you database development:

• 20% of the SQLCentral audience does not yet use a version...

The context of the QoD was a code review of an SP which is used in running .Net software, without propper NULL handling indeed.

An Integer in .NET can't be assigned...

Sorry folks, but the QoD submission some how went wrong.

This was the original explanation

TL;DR; Put a ISNULL around the SUM to ensure a numeric value is always provided, even in...

In a DTQP setup it is key to work as closely with production-(alike)-data as possible. This can be achieved with clones (or containers), there are several vendor but...

• This reply was modified 2 years, 7 months ago by Tonie Huizer. Reason: rephrased the migration part

Despite that you haven't studied the article yet, this is an interesting question Jeff.

And no, this was not covered in the article in-depth, because it involves the basics of git...

• This reply was modified 2 years, 7 months ago by Tonie Huizer.

The fear of reliance on tools is completely normal, tools do their thing (until they break ;-)) but only to support the process of the team.

The process, that's something that...

DEVOPS is a buzzword !!!!!

Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO !

...

Multiple projects / teams working on a...

• This reply was modified 2 years, 10 months ago by Tonie Huizer. Reason: forgot Boards
• This reply was modified 2 years, 10 months ago by Tonie Huizer.

The only thing the AintTim is asking imho is:

Why does the validation of a non existing column in the existing table, dbo.WS_setup (assuming it's a table), works if there is...

• This reply was modified 2 years, 10 months ago by Tonie Huizer. Reason: typo

Thanks Mike!

To my knowledge it's true what you say. Backups without "copy only" flag can mess up your backup chain:

“Copy Only backup is an independent backup and it does not...

Diskpart for the VHD handling works fine indeed, you wouldn't need the Hyper-V modules then.

But what I'm referring to is does your module make use of the Volume Shadow Service?

So,...

Wow Sander that's pretty nice, I wasn't aware of all the effort you put in that library, it looks really complete.

I will definitely try it out.

What do you use as...