Just wanted to point out some downsides to server hosted too. First there are licensing costs as you need to license a new OS (similar to the VM approach BUT...

My guess about it "worked previously but doesn't now" is that it is a combination of things. First, changes to the client machines (office updates, OS updates, GPO's being applied...

Just want to add that you MAY need or want to discuss with your IT dept as well. Hosting stuff locally on a "take home" machine (work laptop for example)...

Offhand, I've not tried this but my 2 cents are below:

SSIS - if you don't have the database master key, then any and all encrypted data is possibly going to...

I am 99.99999% sure that the problem is NOT in the report, but with Excel.

IF Excel sees the value as a date, it will do its best to parse it...

My first step would be to read the docs on a restore. You can change the file locations for the MDF and LDF when you restore. link - https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-2016

Now, that...

I think the problem you are seeing is because you are sorting on the group (just guessing here). If you sort the tablix instead of the row groups, it will...

Just a thought here from reading the XML, but any chance you have a trigger on CREATE_JOB_LOG that writes to the second DB (Logs_Epass)? or I may be reading the...

One thought, which Jeff implied, on performance improvement would be to pre-calculate the data. What I mean is rather than calculating the data on demand, do a nightly (or hourly)...

We collect these statistics on a weekly basis. This way we persist runtime history for all monitored instances.

This comes in handy when provisioning for growth or planning migrations.

Devs and...

To add to what everyone else said, I would not be surprised if it isn't 2 isolated databases involved. What is MORE likely is that a view on database A...

Not essentially a "speed it up" thing, but could you refresh a test instance and run that on the test instance? I am wondering if MAYBE the slowness is due...

That screenshot is TINY, but if I am reading it right, you are missing the functions. Have you installed the required modules and are you using the correct powershell version...

I agree with Frederico_fonsca here - OPENQUERY is going to give you the best performance as the query runs fully on the remote side. IF you are doing it in...

Just to add to what Ant-Green is saying - if you expose your SQL instance to the internet (ie not behind a firewall), someone is going to try to get...