Microsoft has released SQL Server 2022 in November 2022. New features include Ledger, which preserves historical data and provides tamper evidence.
Tag Archives: SQL Server
PASS Data Community Summit 2021
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.
SQL Server 2012 extended support ends July 12th 2022
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.
SQL Server 2019 generally available on November 4th 2019
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.
More information is available at microsoft.com/sql-server/sql-server-2019 and the Tech Community site.
SQL Server 2019 Community Technology Preview 2.0 released
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.
SQL Server 2008 in list of products no longer supported by Microsoft in 2019
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.
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/or Azure Synapse Analytics (formerly Azure SQL Data Warehouse), including:
- 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 most of these SQL tools and utilities can be found at the SQL tools overview and command prompt utilities pages.
Using JSON data in SQL Server
Microsoft offers many resources for SQL Server developers to work with JSON (JavaScript Object Notation) data, including Transact-SQL (T-SQL) functions and online documentation.
A list of MSDN blog post articles on SQL Server and JSON can be found at https://blogs.msdn.microsoft.com/sqlserverstorageengine/tag/json/.