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 disclosed a potential vulnerability in the Azure Cosmos DB Jupyter Notebook feature. The issue was resolved and no customer data was accessed. The Cybersecurity and Infrastructure Security Agency (CISA) also released a statement regarding this database issue.
Oracle Database 21c has been released with several new features. This includes Blockchain tables, which is a new type of table that only allows insert operations. Other enhancements include a new JSON data type and new SQL Function JSON_TRANSFORM. Oracle has also updated its Database Administrator’s Guide and JSON Developer’s Guide for this database version.
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.
Airtable is a cloud database that allows users to design databases in a spreadsheet-like format. It allows collaboration with multiple users and can be accessed from MacOS, Windows, iOS, and Android devices. Multiple templates are available to download including calendars, project management, etc.
Airtable can be accessed for free for databases smaller than 1200 records. Paid versions with additional features are 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.
PostgreSQL is a free open source object-relational database system that is widely used. It is available as a free download for Windows, MacOS, Linux and other operating systems.
More information is available at:
- 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.