Microsoft Build has been changed to an online only event this year, and runs from May 19 to May 21, 2020 starting at 8 AM Pacific Time. Registration for this online educational event is free at register.build.microsoft.com.
Microsoft and Oracle both released announcements on their recent agreement to connect Azure and Oracle Cloud services. This will allow users to connect to both using a unified single sign-on experience.
More information on this service is available at www.oracle.com/cloud/oci-azure.html.
Visual Studio Team Services (VSTS) has been renamed to Azure DevOps as of September 2018. Microsoft offers guidance on conversion from Team Foundation Server (TFS) to Azure DevOps Services. Features within VSTS have been given new Azure DevOp names as well.
User settings can be changed by logging into app.vsaex.visualstudio.com.
Microsoft announced the September 2018 release of Azure Data Studio, formerly known as SQL Operations Studio (preview version). Azure Data Studio is a new open source desktop environment for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse data that runs on Windows, macOS, and Linux.
- SQL Server Management Studio (SSMS)
- Azure Data Studio (formerly SQL Operations Studio)
- SQL Server Data Tools (SSDT)
- SQL Server documentation at GitHub
- Database Engine Tuning Advisor and dta utility – analyzes a workload or SQL script and recommends data server structures to improve performance
- mssql-cli – a command-line tool for querying SQL Server on Windows, macOS, or Linux
- SqlCmd utility and Microsoft Command Line Utilities
- Database Console Commands (DBCC)
- SQL Server Diagnostic Connection for Database Administrators (DAC)
- mssql-scripter – multi-platform command line tools for SQL Server scripting
- Trace Flags
- TableDiff utility – a row by row data comparison of two tables
- SqlLogShip – a command line tool for log shipping operations
- SqlLocalDB – a command line tool for SQL Server Express LocalDB
- SqlPackage – a command-line tool for importing and exporting databases and snapshots from SQL Server or Azure SQL databases
- mssql-conf – configure SQL Server on Linux
- RML Utilities for SQL Server – a set of tools and processes to run load tests
- Database Experimentation Assistant (DEA) – an A/B testing solution for SQL Server upgrades
- Distributed Replay – replay a workload like SQL Server Profiler but from multiple computers for SQL Server or Azure SQL databasesA list of most of these SQL tools and utilities can be found at the SQL tools overview and command prompt utilities pages.
Microsoft has made Azure SQL Database Managed Instances available in Preview mode. These instances offer much greater compatibility with traditional SQL Server when compared with Azure SQL databases.
A free Azure account can be created at azure.microsoft.com/free.
More documentation can be found at:
- Azure SQL Database Managed Instances – General Information
- Choosing a cloud SQL Server option
- Create an Azure SQL Database Managed Instance in the Azure portal
- Migrate SQL Server to Azure SQL Database Managed Instance online or offline
- Connect an application to an Azure SQL Database Managed Instance
- T-SQL differences between SQL Server and Azure SQL Database Managed Instances
- Azure SQL Managed Instances – Feedback Forum
Extensions for the Microsoft Visual Studio suite of products can be found at marketplace.visualstudio.com. Extensions add support for languages not included in Visual Studio, aid in IDE development, or perform a specific task.
Some current popular extensions are:
- Developer Analytics Tools
- SQL Server, Azure SQL and SQL Data Warehouse (mssql)
- Deploy to Azure
- PostgreSQL for Visual Studio Code
- Visual Studio IntelliCode (productivity features for Python and Java)
- Visual Studio Live Share
- Visual Studio Pull Requests
- Visual Studio Code Remote for WSL, SSH and Docker containers
- Java Language Support (Red Hat)
- All Microsoft Visual Studio Extensions
Extensions can be free, preview, or paid. Paid extensions are often charged per user per month. Preview extensions are eventually converted to paid extensions. Extensions are either written by Microsoft, third party vendors, or individual developers.
More information can be found at code.visualstudio.com/docs/extensions/overview.
Microsoft has announced the Preview release of SQL Operations Studio, a free database development and operations tool for SQL Server and Azure SQL Data Warehouse.
This tool allows users to performing routine database tasks without using SQL Server Management Studio. Command-line tools such as Bash, PowerShell, sqlcmd, bcp, and ssh can be run in the Integrated Terminal window. Customizable dashboards can be created for performance monitoring.
This preview version can be downloaded from https://docs.microsoft.com/en-us/sql/sql-operations-studio/download. Versions include Windows, macOS, and Linux.
A document of common questions and answers can be found at https://docs.microsoft.com/en-us/sql/sql-operations-studio/faq.
Additional information and downloads can be found at GitHub – SQL Operations Studio.
The Professional Association for SQL Server (PASS) will have a live stream of events held at the Seattle PASS Summit 2017 conference on November 1st, starting at 08:10 AM Pacific Daylight Time.
PASS Summit is a conference devoted to SQL Server, Azure, and other Microsoft data technologies.