@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 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...

My opinion, you are going to need a tool to do that. Offhand, I am not sure what tool can handle it, but anything that supports WMI should be able...

I agree with Jeff - if the code is complex or confusing, it should have comments around those bits explaining the logic. Now, if the code is confusing to someone...

Just to add to what Phil said - that SHOULDN'T exist in the real world. I have run across some things that make me scratch my head like storing numeric...

The steps I am aware of are:

1 - find the bottleneck - is it the Lake, is it the network, is it the internet, is it the power BI processing,...

To add to what Jonathan said - do you understand the code? If person A is supporting it now and understands the code and they are leaving and you are...

First comment on this, I think you will get more/better results on a PostgreSQL form than a SQL Server forum. That being said, PostgreSQL has documentation on authentication. Have you...

First thing I'd check is "what changed?". If it worked prior to a certain date and suddenly stopped working, something changed. Step 1 is to figure out what changed and...