Burnout can certainly creep up, and I try to really get away from the computer on the weekends. Working this am because I took off a little early yesterday to...

I'll keep adding to this over time. I know there are features that are unintuitive.

Feel free to post questions for what you want to know how to do. I need...

If you assume you only have 5 instances max on a machine, then I think assigning ports to those instances and allowning that range through makes senes. I though 50000+...

database names can be the same. These are only namespaced inside the instance.

The browser running on UDP 1434 (https://docs.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service?view=sql-server-ver15) is what the source instance would connect to on the target instance and get the port.

Outbound traffic usually isn't too much of...

We are struggling to find places to go to camp. A lot of the places are still closed, but we're hoping some will start to open in June. Did book...

But when working from home, it doesn't seem right to take a sick day, even if you're sick. With so much uncertainty still ahead of us, I'd rather...

The marketing and SEO do matter. Engagement is a part of what is needed and mobile has been a constant request over the years. This also affects search results from...

there are some dbccs for checking data type changes. I forget which one, but it addresses a change after 2000. A little busy now, but I'll try to look later.

Otherwise,...

This should work, but a few things I'd do to improve this:

--  Delete in batches with progress put into table

-- Table for holding progress
CREATE TABLE progress
(
...

A firewall is about access from endpoints, which may or may not help here. Inside->traffic often isn't limited, which is a hassle.

There are protections built in, but many don't use...

OPENROWSET works with limitations

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features

Usually you need a couple of scripts. One to do the blocking, one to simulated the blocked.

The easy way for the first script is have  aproc that has a WAITFOR...

You could build the SQL statement in PoSh by manipulating the strings that make it up. Or you could use parameters and a proc, changing the parameters that you send...

I mostly agree with what Brian wrote. I am wary of denormalizing, and I do it when multiple places need the data and/or performance is an issue. Trading space for...