Categories
Databases SQL Server

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.

Categories
Android Apple Apps and Utilities Databases iOS iPhone Windows

Airtable is a cloud based hybrid of spreadsheets and databases

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 devicesMultiple 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.

Categories
Databases Linux SQL Server

SQL Server 2019 Community Technology Preview 2.0 released

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.

Categories
Azure Databases Linux SQL Server Windows

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.

Categories
Apple Databases Linux Windows

PostgreSQL – a powerful open source database

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:

Categories
Amazon.com Azure Databases MySQL Oracle SQL Server

DB-Engines.com ranks hundreds of database management systems

DB-Engines.com publishes lists of database management systems (DBMS) ranked by category, including:

Categories
Apps and Utilities Azure Databases Linux SQL Server

SQL Server and Azure SQL Database Tools and Utilities

Microsoft has made available many free downloadable apps for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse, including:

Categories
Databases SQL Server

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/.

Categories
Azure Cloud Databases SQL Server

Azure SQL Database Managed Instances offer greater SQL Server compatibility

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:

Categories
Azure Databases PowerShell Programming Languages SQL Server Visual Studio

Visual Studio Extensions Marketplace

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:

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.