Microsoft’s Azure portal and SQL Server Management Studio (SSMS) just received some new updates that include support for loading 20+ data stores both on-premise and in the cloud to provide a more integrated experience.
Updates to the Azure portal include quick load to help integrate SQL Data Warehouses with Azure Data Factory (ADF) and a new task panel for easy navigation. Other new features include the following:
Rich data store support: built-in support for 20+ data stores on-premises and in the cloud. Easy to set up: intuitive wizard with no scripting required. Secure and compliant: data is transferred over HTTPS or ExpressRoute and the global service presence ensures your data never leaves the geographical boundary. Unparalleled performance by using PolyBase: using PolyBase is the most efficient way to move data into Azure SQL Data Warehouse. To load from Azure Blob Storage, ADF uses PolyBase directly. To load from data stores other than Azure Blob Storage, ADF uses the staging blob feature to convert your source data into PolyBase compatible format, and then use PolyBase to load into SQL DW.
The new features houses more than integrated tweaks. Customers can also get bit more granular with the new troubleshooting addition that enables self-diagnoses of SQL Data Warehouse. Monitoring is another tool in the shed of newer tricks found in the query drill down blade.
“You can now conveniently view the number of concurrency slots that your queries are consuming along with its resource class. This enables you to manage your workload.”
Lastly, issues that were springing up across SQL Management Studio (SSMS) have been addressed with the following tweaks.
Execute the Generate Scripts wizard for database users and user defined functions View your logical server name within the table properties of your database Drop your database simply through the Object Explorer Leverage templates for stored procedures and scalar-valued functions
Microsoft’s program manager of SQL engineering Kevin Ngo encourages customers to visit the Azure Portal page to being fiddling with the updates.