Viewing 15 posts - 1,621 through 1,635 (of 22,202 total)
... we get companies that require NOLOCK in every query (and yeah, run across this one many times now).
Seriously? An official, company-wide mandate to DB coders to use this?...
September 8, 2020 at 1:13 pm
John,
Lots of employers will still sponsor training. However, it's not like it used to be. But even the old days weren't what we remember. I worked for a consulting firm...
August 30, 2020 at 11:41 am
Eric, first, thanks for the kind words. Second, while I'm not unemployed currently (and fingers crossed, "currently" lasts another 10 years), I do feel your pain. I'm also 57 and...
August 30, 2020 at 11:38 am
A couple of things. First, you don't need both. If you set the compatibility mode to 110, you get the legacy cardinality estimation engine. No need to also set that....
August 26, 2020 at 10:48 am
Good luck on it.
One point, document the time you spend on building & maintaining monitoring. Time absolutely is money. It's time you could be spending elsewhere on much more important...
August 26, 2020 at 10:27 am
Ah, cool.
No, I'm not aware of any way you can do anything with data within the VMs other than what is normally provided. You'd have to move to RDS to...
August 25, 2020 at 2:53 pm
To "get around licensing"?
No. You either have a licensed instance installed on a VM, or, you use the AWS RDS SQL Server instance, and the cost of RDS includes the...
August 25, 2020 at 11:34 am
If that's all you want, set up an Agent job that polls the servers to see if they're online or not. It won't be much work. You can store the...
August 25, 2020 at 11:30 am
I answered this over on stackexchange too. I'd use AZCopy to move the backups up to Azure Blob Storage, specifically where your VM has defined it's storage. Then, it's just...
August 25, 2020 at 11:20 am
Oh great point. Check for triggers. Secret little turkeys will get you every time.
August 24, 2020 at 2:56 pm
Agreed. Please post the execution plan. It's just not possible to say what's going on without it.
August 24, 2020 at 12:45 pm
Out of the box, by default, Redgate SQL Data Compare will find tables with the same name to compare, as you noted. However, you can map tables with completely different...
August 24, 2020 at 12:43 pm
Without seeing the full structures, it's hard to say for certain. As was already stated, a normal view would not in any way affect this. Only the materialized/indexed views will....
August 24, 2020 at 12:35 pm
In theory, it really is as simple as getting the production server back online, wait for the logs to get moved over, and then fail over back to production. The...
August 21, 2020 at 5:02 pm
Imagine the lady in Poltergeist: ALL ARE WELCOME!
Come on in. The water is fine. This is just the local water cooler (bubbler/fountain/whatever your local vernacular is for a...
August 21, 2020 at 1:11 pm
Viewing 15 posts - 1,621 through 1,635 (of 22,202 total)