Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Overview PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store …

  SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a …

  This article introduces how to build a MySQL on Linux quickly. This’s often used to build a temporary MySQL for testing. In short, we only need …

  MariaDB support different type of compression before 10.3.x . Most of them need external packages (lz4,lzo,lzma,bzip2,snappy) to be installed before using them . Default …

Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides the following business value: Improves …

Introduction A principal component of a protected system is accountability. One way to ensure accountability is to examine events on the system. Many events that …

Error: When the database is upgraded to version 10.2.0.4 or 10.2.0.5, the Enterprise Manager configuration ends with an error and fails to start manually. Reason: …

  For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in …

  We explained how to get the create script of all objects belonging to the database in the article titled “How To Get Script of …

  I mentioned that we can not get the script of the partitioned tables by right clicking on the SSMS and using the Script To …