Viewing 15 posts - 1,636 through 1,650 (of 22,219 total)
Let's be clear, opinions all stink and this is very much my opinion.
You're going too broad. SSAS, SSRS, SSIS, data warehousing and Azure (which, all by itself, ENORMOUS topic) is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 10, 2020 at 12:39 pm
A day late, but testing, as always, is going to be your bestest buddy. I'm not aware of any fundamental issues in the move from 2014 to 2019. You're already...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 9, 2020 at 1:17 pm
The key difference between openquery and a linked server query is where the query processing occurs. In a linked query, all the processing occurs locally. In an openquery, the processing...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 9, 2020 at 12:40 pm
... 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?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 25, 2020 at 11:20 am
Oh great point. Check for triggers. Secret little turkeys will get you every time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2020 at 12:43 pm
Viewing 15 posts - 1,636 through 1,650 (of 22,219 total)