Published on

Databases on Premise and Cloud

Authors
  • Name
    Jackson Chen

Database Monitoring and Management

Quest Spotlight

Optimize SQL Server database performance - on-premises or in the cloud https://www.quest.com/spotlight/

Spotlight can keep monitoring events, including long running queries, and many more to help troubleshooting and management of databases.

RedGate

https://www.red-gate.com/

Our solutions make life easier for development, operations, and IT leaders by solving the database challenges in delivering software at speed.

Database Backup

LiteSpeed for SQL Server

https://www.quest.com/products/litespeed-for-sql-server/

Get high-speed, storage-efficient, backup and restore for SQL Server databases – ensure the correct SQL Server data is restored and available as quickly as possible with a wide variety of backup and recovery options.

Partner LiteSpeed with Quest QoreStor and reduce cloud storage costs further with deduplication, compression, encryption, and intelligent Cloud Tiering.

Database Maintenance

https://ola.hallengren.com/

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance scripts. Industry standard and best practices.

SQL Community

https://www.sqlservercentral.com/

Database Vendors and Types

Microsoft SQL Server

https://www.microsoft.com/en-au/sql-server/

  1. Microsoft SQL 2022 build versions https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/build-versions

  2. Microosoft SQL 2019 build versions https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/build-versions

  3. Microsoft SQL 2017 build versions https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2017/build-versions

  4. Microsoft SQL 2016 build versions https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2016/build-versions

  5. Microsoft SQL 2014 build versions https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2014/build-versions

Microsoft SQL on Linux

  1. SQL Server 2022 https://learn.microsoft.com/en-us/troubleshoot/sql/releases/linux/release-history-2022

  2. SQL Server 2019 https://learn.microsoft.com/en-us/troubleshoot/sql/releases/linux/release-history-2019

  3. SQL Server 2017 https://learn.microsoft.com/en-us/troubleshoot/sql/releases/linux/release-history-2017

Postgres

Postgres release version

https://www.postgresql.org/docs/release/

Postgres database documentation

https://www.postgresql.org/docs/

Postgres Books

https://www.postgresql.org/docs/books/

Online Resources

https://www.postgresql.org/docs/online-resources/

MariaDB

https://mariadb.org/

Releases

https://mariadb.org/mariadb/all-releases/

Documentation

https://mariadb.org/documentation/

Books

https://mariadb.org/documentation/#books

MySQL

https://www.mysql.com/

Reference manual

https://dev.mysql.com/doc/refman/8.1/en/

Install and Upgrade

https://dev.mysql.com/doc/refman/8.1/en/installing.html

Server Administration

https://dev.mysql.com/doc/refman/8.1/en/server-administration.html

Optimization

https://dev.mysql.com/doc/refman/8.1/en/optimization.html

Oracle Database

AWS Cloud Database

GCP Cloud Database

Azure Cloud Database