Thanks

Thanks Grant,

Is it possible to schedule update stats using azure automation. Do you have a doc/scripts to do so?

Many thanks!

I see min requirements for polybase is .net v 4.5 and for sql server is 4.6 and for ssms is 4.6.1. Should I install net framework 4.6.1 before starting sql...

Thanks Drew.

Its not throwing any errors. I'm not getting the sql/domain user permissions, only public role permissions are extracted. Thanks!

I'm aware that with the following roles the user is not able to modify jobs unless the user owns the jobs or the user has SA rights.

My requirement is...

Thanks Jeff. Do you think SSIS is a possible solution?

Thanks. Also, BCP or BULK INSERT? which is quicker and/or resource efficient?

Thanks Luis. Is there a better option instead of BCP for bulk load from OLTP to Azure SQL datawarehouse.

SSIS?

Thanks!

For bulk load from OLTP to Azure SQL datawarehouse, is this tool helpful or any other option?

Thanks!

Planning to archive data from on-prem to Hadoop/Azure Blob Storage/Azure SQL datawarehouse.

Thanks!

Thank Phil. If we don't want scale-out feature, should I go with standard edition of SQL?

Thanks

https://msdn.microsoft.com/en-us/library/ms143393.aspx

SQL Server 2016 Support for SQL Server 2005

This section discusses SQL Server 2016 support for SQL Server 2005. In SQL Server 2016, you will be able to do the following:

•Attach...