PASS Data Community Summit 2021 is a free online event for Microsoft data platform professionals that runs November 8 – 12, 2021. Register online at passdatacommunitysummit.com.
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)
- Azure SQL Documentation
- SQL Server Data Tools (SSDT)
- SQL Server ODBC Driver
- Transaction Log Architecture and Management
- 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 (download available)
- 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. 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
- Link feature for Azure SQL Managed Instance
- SQL Managed Instance How-to series
- Azure SQL Managed Instance scripts and tools at GitHub