Visual Studio Codespaces – an online only development environment

Visual Studio Codespaces – formerly known as Visual Studio Online – allows you to create Visual Studio solutions entirely in the cloud across multiple devices.  This development environment is currently in public preview.

Azure DevOps is the new name for Visual Studio Team Services

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.

Documentation regarding Azure DevOps is available at docs.microsoft.com/en-us/azure/devops/.

Azure Data Studio is the new name for SQL Operations Studio

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.

DB-Engines.com ranks hundreds of database management systems

DB-Engines.com publishes lists of database management systems (DBMS) ranked by category, including:

SQL Server and Azure SQL Database Tools and Utilities

Microsoft has made available many free downloadable apps for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse, including:

Azure SQL Database Managed Instances offer greater SQL Server compatibility

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:

Visual Studio Extensions Marketplace

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:

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.

SQL Operations Studio – Preview edition

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.

New functionality can be added to SQL Operations Studio using extensions.

Additional information and downloads can be found at GitHub – SQL Operations Studio.