Microsoft will end Extended support for SQL Server 2012 on July 12, 2022. Extended Security Updates for SQL Server 2008 will end on July 12, 2022.
Microsoft announced the general availability of SQL Server 2019 on November 4th 2019 at its Ignite conference. There are four editions: Enterprise, Standard, Express, and Developer. Express and Developer editions are free and can be downloaded from microsoft.com/en-us/sql-server/sql-server-downloads.
A list of new features for SQL Server 2019 is also available.
Microsoft announced the release of SQL Server 2019 Community Technology Preview (CTP) 2.0 on September 24th 2018 at its Ignite event. SQL Server 2019 runs on Windows, Linux, and containers and has Apache Spark and Hadoop Distributed File System (HDFS) to help create big data analytics.
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 2008 and 2008 R2 will no longer be supported by Microsoft as of July 9, 2019. Support for Windows Server 2008 and 2008 R2 will end on January 14, 2020. Later support dates are available for customers under the Extended Security Update (ESU) program. One way to do this is to upgrade to Azure.
Microsoft released a full list of products that will no longer be supported in 2019 at support.microsoft.com/en-us/help/4316957/products-reaching-end-of-support-for-2019.
- SQL Server Management Studio (SSMS)
- Azure Data Studio (formerly SQL Operations Studio)
- SQL Server Data Tools (SSDT)
- SQL Server Troubleshooting documentation
- SQL Server PowerShell cmdlets such as Invoke-Sqlcmd
- SQL Server Configuration Manager
- Data Migration Assistant (DMA)
- 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)
- DBCC TRACEON Trace Flags
- Extended Events – replacement for deprecated SQL Server Profiler and SQL Trace
- SQL Server Diagnostic Connection for Database Administrators (DAC)
- mssql-scripter – multi-platform command line tools for SQL Server scripting
- TableDiff utility – a row by row data comparison of two tables
- Diagnostic Connection or Dedicated Administrator Connection (DAC)
- 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 databases.
A list of MSDN blog post articles on SQL Server and JSON can be found at https://blogs.msdn.microsoft.com/sqlserverstorageengine/tag/json/.
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
- PowerShell (replaces PowerShell ISE)
- SQL Server, Azure SQL and SQL Data Warehouse (mssql)
- C# and C/C++
- Azure Marketplace Extensions
- Chrome Debugger
- Oracle Developer Tools for Visual Studio Code
- Go language for Visual Studio Code
- 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
- Visual Studio Code – Coding Pack for Java – Windows and MacOS
- 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.