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.
More information is available at microsoft.com/sql-server/sql-server-2019.
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)
- 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