Wanted to throw my hat into the ring on this - I have done both. In-place upgrades and migration upgrades. My biggest factor in deciding the method is "how many...

No can do in SQL Server according to the docs: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Those state we have 1024 columns max in a table.

You'll need to break it up into multiple tables; probably want...

As a random thought, are you fully patched on both SSRS and SQL Server?

Also, when you uninstalled Standard, did you reboot after the uninstalls? And did you reboot after the...

I could be dumb, but this really sounds like a homework/assignment style question. That being said, if I asked something like this, my first question would be "what does the...

I suppose that is a good point Jeff. In this specific scenario where the OP is trying to write the file to the server itself, having the data flow from...

One nice thing is that with email notifications, things show up how you would expect. The other fun thing is it happens outside of the code block too:

those above...

Oh I agree with you here Jeff. When things are set up properly, xp_cmdshell can be secure, but I find that a lot of times, it is used and abused....

@steve-2 Jones - replace the _ with a space and you'll see what's happening.

If there are no jobs (maintenance plans are still jobs) or scheduled tasks, then I'd say something must be happening on the Azure side of things that is backing it...

My opinion - don't. Firstly, SQLCMD mode is a client side thing (ie part of SSMS) not a server side thing (ie not part of SQL Server Engine) so SQLCMD...

My question would be do you need to use replication for this?

What I mean is could you modify the stored procedure that updates the primary to ALSO update the secondary...

If I understand correctly, could you do something like this:

SELECT [T1].* -- or could do [T2].*, not certain which table row you are trying to show, you...

• This reply was modified 2 years, 2 months ago by Mr. Brian Gale.

Thanks for the links Frederico_fonseca - unfortunately it is not a docker thing. In my case it looks like it is a vulnerability scan and it is just driving me...

Thanks for the tip! I'll send a question out to the IT team as I would LOVE to have that fixed... although I am a bit concerned that changing it...

Another thing to point out - your data looks to be inconsistent:

A DB 130 9/1/2023
A DB 120 10/1/2023

why did "DB" shrink by 10 MB that day/month?

But in...