Understanding PostgreSQL SUBSTRING function PostgreSQL is an open-source, object-oriented relational database system with reliability, performance, and robustness. It supports SQL (relational) and JSON (non-relational) queries.PostgreSQL’s popular features include Multi-Version Concurrency Control (MVCC), point-in-time recovery, granular access controls, tablespaces, and asynchronous replication. Data refactoring is a common requirement in data mining operations. Data stored in a table requires transformations based […]
https://www.sqlshack.com/under....standing-postgresql-

How to create and query the Python PostgreSQL database This article is all about creating and querying Python PostgreSQL database in a simple and easy way. Additionally, the readers of this article are going to learn to set up the environment before they can create and query the PostgreSQL database in Python. This article is suitable for both beginners and professionals who are keen […]
https://www.sqlshack.com/how-t....o-create-and-query-t

Different ways to identify and change compatibility levels in SQL Server Compatibility level in SQL Server refers to a database property that determines the syntax and behavior of the database, allowing it to be compatible with earlier versions of SQL Server. Each version of SQL Server introduces new features, improvements, and changes to the query optimizer, which may affect how queries are executed and how results […]
https://www.sqlshack.com/diffe....rent-ways-to-identif

An overview of SQL Server monitoring tools This article explains some of the popular SQL Server monitoring tools and techniques. Database monitoring: a quick reminder Database monitoring is a set of tools and techniques used to create and maintain an application infrastructure that is highly available and performs at high speed. It helps track the resource consumption, such as the amount of […]
https://www.sqlshack.com/an-ov....erview-of-sql-server

Table Inheritance in Azure Database for PostgreSQL In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL. Introduction A database ecosystem is formed of various types of database objects like tables, views, procedures, schemas, etc. Often database objects like tables and views have interdependencies where the definition of a view depends on […]
https://www.sqlshack.com/table....-inheritance-in-azur