MSSQL 2019 References

MSSQL 2019 References.md

New Features in MSSQL 2019

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15

Restore a database backup to MSSQL2019

https://docs.microsoft.com/en-us/sql/big-data-cluster/data-ingestion-restore-database?view=sqlallproducts-allversions

Setting up MSSQL2019 with AD support

https://docs.microsoft.com/en-us/sql/big-data-cluster/deploy-active-directory?view=sqlallproducts-allversions

Deploy with High Availability

https://docs.microsoft.com/en-us/sql/big-data-cluster/deployment-high-availability?view=sqlallproducts-allversions

Setup the data pool (Sharding capability for your database)

https://docs.microsoft.com/en-us/sql/big-data-cluster/data-ingestion-restore-database?view=sql-server-ver15#configure-data-pool-and-hdfs-access https://github.com/microsoft/sql-server-samples/blob/master/samples/features/sql-big-data-cluster/data-pool/data-ingestion-sql.sql

Tools Installation (azdata, azure-data-studio)

https://docs.microsoft.com/en-us/sql/big-data-cluster/deploy-big-data-tools?view=sql-server-ver15

Azdata reference:

https://docs.microsoft.com/en-us/sql/big-data-cluster/reference-azdata?view=sql-server-ver15

How to deploy an app on SQL Server Big Data Clusters

https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-cluster-create-apps?view=sqlallproducts-allversions

How to run spark Jobs on MSSQL

https://docs.microsoft.com/en-us/sql/big-data-cluster/spark-submit-job?view=sqlallproducts-allversions

Single pane of glass to manage all your database instances: (Azure Arc (Preview))

https://azure.microsoft.com/en-us/services/azure-arc/#contact-us)