Hi Adam,

Nice piece of work. I had started on my own and then thought, I bet someone who is better at code than I has done this already.

Enjoy the kudos...

Big thanks Kees,

You nailed that explanation,

Tks JK

Mainly use SSMS to write SQL code, but have had a look at VSCode and it looks like it might be a runner.

JK

Soooo disappointed, STEVE!! How could you do that??

A small point, referred to above, there are 53 weeks in a financial year, to catch the few days at each end. Thanks for the article though. Good topic and...

Ah that's what I was missing ... the question was how many left in table, NOT how many deleted, Doh!

What am I missing here ??

Will "delete from ABC_CTE where id = 1;" not just delete the one record where id = 1 ??

JK

Thanks for that Ali, a useful article for those of us in the Retail space, which we do not see enough of. No criticism of your article, but I note...

Good points Steve, I think MS struggle with Focus and therefore Resource Allocation and also that they are Business motivated and therefore lack the passion that other more focused companies...

Many thanks for this really useful piece of code. Have been doing this with SSIS Profile task, but this is much more handy. JK

Here is a link to a good discussion on that subject. Seems SMO passes a value back from the Restore at least that the code is using to test for...

That's what I'm talkin' about ...

Off the top of my head, that looks like it is looking for a Service Principle Name ?? What Security contaxt are you using to connect to the remote...

I agree with the points being made in the previous posts, but I still think this was an excellent article. It was clear and concise, without being distracted by...