Viewing 15 posts - 496 through 510 (of 2,062 total)
Thanks for the recommendation. In progress of tuning the fetchsize from 50000 (semi-halt at 140 million records) to 10000. 500000 crashes the driver (unexpected termination)
November 8, 2019 at 9:04 am
I surely like the trend of cross-platform, opensource course of MS. There is also some cool stuff showing dependencies in Azure with log analytics. Regarding VS2019 they've added some profiling....
November 2, 2019 at 10:12 am
Eirikur Eiriksson, sorry to hear about your crystall ball. I hope it cristallizes again. Perhaps with the hourglass bbq of Steve.
October 31, 2019 at 4:53 pm
We use SSIS a lot for our ETL. Recommended is VS2017 + data tools , VS 2019 is extremely buggy at the moment.
Pro's:
Flowchart, logging, catalog, almost no code required but...
October 31, 2019 at 4:48 pm
Provider cannot be found. It may not be properly installed-> Is the oracle driver installed on the sql server and/or the client?
October 31, 2019 at 4:38 pm
Knocking on wood, just updated to vs 2019 16.3.6 and got the "variables" showing again
October 29, 2019 at 4:04 pm
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
October 29, 2019 at 3:54 pm
Not really TFS, but about automating: DBAtools has a wonderful library of powershell-scripts regarding sql server
October 29, 2019 at 3:45 pm
I'm also curious. I would expect a slight increase of load. More frequent logshipping = smaller logs, more frequent copying and apply(?). Same bandwidth use overall. Impact for the provider...
October 25, 2019 at 2:14 pm
We have a report on failed subscriptions that is mailed mid-day. If we don't get the mail something is also wrong. In addition a report with commands to retry subscriptions...
October 17, 2019 at 3:35 pm
Why I worry less about fragmentation: there are so many different layers between sql server and the hardware storage if you are running virtualized or with SAN-storage.
Statistics are more important...
October 17, 2019 at 3:28 pm
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
Viewing 15 posts - 496 through 510 (of 2,062 total)