Viewing 15 posts - 496 through 510 (of 2,051 total)
Is on-premise. Tried the Attunity Connectors but can't find how to use expressions (SQL command from variable) for incremental updates.
October 17, 2019 at 3:21 pm
Have a look at the ExtendedEventsWorkloadListener ofย WorkloadTools
The tool is designed to replay or analyse a workload from system A to system B using Extended Events.
It has a...
October 17, 2019 at 1:41 pm
Doesn't seem to make a difference. I'll have to try it in a proper testing environment
October 17, 2019 at 8:37 am
Oracle driver oddities: create table as select * @from_dblink 1 minute. SSIS select * + rowcount: 80 minutes with Oracle Oledb ๐
October 16, 2019 at 12:22 pm
A couple of years ago you needed to install VMWare guest tools to install better drivers for virtualization. Otherwise it would fall back to the much slower cpu-virtualization
Don't know if...
October 15, 2019 at 2:39 pm
I don't have experience with it, but it seems you can move resources between subscriptions.
https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources
October 2, 2019 at 3:07 pm
Service account of instance has access to the share?
May 28, 2019 at 2:20 pm
I would rather see the minimum limits gone (minimum 4 core licenses per virtual machine).
May 20, 2019 at 3:43 pm
When permitted by the vendor, we upgrade test to the latest available. The next version is probably there when testing is over in some scenario's
May 13, 2019 at 3:44 pm
Do you have the full ODAC installed or the xcopy only?
I always install the 64-bit odac first and later on the 32-bit (for visual studio) in a different home
April 24, 2019 at 12:14 pm
If you have a support contract you can send the dump to MS. Perhaps you hit an unknow bug.
Try to get a testbest and verify your backup/restores.
April 19, 2019 at 8:02 am
As it had no patching, you should patch it to the latest cumulative pack.
April 18, 2019 at 8:11 am
You should surely be concerned.
Is the instance up to date (CU 14?)
April 15, 2019 at 1:22 pm
You could join a date-table with your information.
pseudocode:
select mydate,sum(rate) total
from datetable
inner join ratetable
on datetable.datekey>=ratetable.startdate
and dataetable.datekey<=ratetable.enddate
group by mydate
Didn't try...
March 22, 2019 at 8:25 am
Awesome article. Starting to comprehend failover clusters.
March 20, 2019 at 4:21 am
Viewing 15 posts - 496 through 510 (of 2,051 total)