I know I can use other options.
But for some jobs I do need the maintenance plans, since it is a out of box feature, it should work. and Microsoft should...

Thank you.
I use  standard edition of SQL server 2017 on windows 2016.
So I guess I can only use the Basic availability group. Above you described also applies to...

Did y

Agree on that.
This is not a query, it is a stored procedure that has a date parameter that has a default value null

Ok, thanks

Is that because better performance? Thanks

Thanks,
oh it returns not true, then 0 record. Thanks,

So below either one should work,
where  sg.storedDate > =isnull(@dateStored,'1900-01-01') 
or
Where sg.storeDate>=isnull(@dateStored, sg.storeDate)

Correct?

We don't have this issue with SQL server 2014 with OLEDB oracle source or destination.
Login is using the oracle login.

No. thanks,  we have hundreds of SSIS packages using Oracle OLEDB driver. which is supposed to work better than ODBC.
32 bits is for Visual studio, 64 bits is for...

I installed both 32 bits ODAC and 64 bits.
I run it from Visual studio 2017 data tool, so it is using 32 bits. We are using Oracle OLEDB data...

I used ODAC client for oracle 12c. It was ODAC 11 previously.
It was working before I upgraded from SQL server 2014 to 2017.

I found out the reason is SSRS 2017 no longer works with Oracle 11 client. SSRS 2014 still works with it.

So I installed Oracle 12c drivers, then the...

I checked it is there.

Does the report subscription can push the excel file to a sharepoint document library?

We here use sharepoint a lot, we want this document to be pushed to sharepoint...