My advice is actually going to be the opposite of a lot of others here - I wouldn't add any columns to the table or change the structure. The reason...

Just my 2 cents - shrinking any database is not a good idea. The DB grew to that size for a reason, and tempdb grew likely due to queries being...

Quick google, it looks like failback isn't something that happens with AG's. It is something you can set up, but it's not a setting in the AG. So when the...

I could be mistaken, but I think it depends on the configuration. I am hoping this is your test system and not live and if so, I'd say try it...

If you want a NICE tool for signing powershell scripts, I recommend this one:

https://www.idera.com/productssolutions/freetools/powershellplus/

Idera Powershell Plus. FREE tool which is always a huge plus, and it works really nice for...

To play devil's advocate, all of the applications I develop I design with a "quick drop" to SQL. What I mean by quick drop is that the application opens a...

My opinion - setting the execution policy to bypass is a bad idea on a desktop and a horrible idea on a server. Sign your script instead.

The reason it is...

I agree with Grant, I just wanted to add in another potential cause is drivers. For example, if you update your network drivers and you have your database storage on...

Just was looking at that really long single line SQL and was trying to make it more pretty and there is some goofy stuff happening in your query. I see...

My opinion - that REALLY depends on the company. For example, if you have a license for SQL Prompt, I would recommend grabbing that.

But as a bare minimum, for a...

It is not likely you are going to find someone who will download a random zip file from someone to help with something like this. A better solution is to...

True... Could you have the page break in as an expression that depends on how many rows are in the main report? What I mean is if the main report...

Offhand I am not certain, but is it possible in the parent report (the one that will contain the sub-report) to put a page break before the sub-report?

I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it...

My opinion - a developer shouldn't need to run a trace. That's a thing a DBA should be doing. If the developer needs a trace run, the DBA should initiate...