Given it is RTM, I would at least expect that the installer works or notifies about the requirements

Wanted to try the new shiny SQL Server 2019. Install failed midway because some dependancy. System config checker is allright.

Detailed results:
  Feature:    ...

I hope CLOG.RecvdDate is not a string

WHERE CLOG.RecvdDate >=DATEADD(DAY,-1,convert(date,getdate())) and CLOG.RecvdDate<convert(date,getdate()))

I'll will try splitting it up.

The bottleneck is currently ssis or the sql destination. The source can deliver the data very vast (network spike) and then waits for ssis or...

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)

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....

Eirikur Eiriksson, sorry to hear about your crystall ball. I hope it cristallizes again. Perhaps with the hourglass bbq of Steve.

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...

Provider cannot be found. It may not be properly installed-> Is the oracle driver installed on the sql server and/or the client?

Knocking on wood, just updated to vs 2019 16.3.6 and got the "variables" showing again

• This reply was modified 6 years, 1 months ago by Jo Pattyn.

To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?

Not really TFS, but about automating: DBAtools has a wonderful library of powershell-scripts regarding sql server

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...

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...

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...