SQL Shack - articles about database auditing, server performance, data recovery, and more

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â€...

https://www.sqlshack.com/understanding-postgresql-substring-function/

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

https://www.sqlshack.com/how-to-create-and-query-the-python-postgresql-database/

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

https://www.sqlshack.com/different-ways-to-identify-and-change-compatibility-levels-in-sql-server/

In this article, we will learn how to set up an Oracle instance, create sample data and understand the use of the substring function. Introduction Structured data is hosted typically in relationa...

https://www.sqlshack.com/oracle-substring-function-overview-with-examples/

This article will explain backup storage redundancy for Azure Cosmos DB. Backups are a critical feature to keep copies of our data to ensure data protection and recoverability in case of any acci...

https://www.sqlshack.com/configure-backup-storage-redundancy-for-azure-cosmos-db-account/

The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server. Introduction The performance tuning ai...

https://www.sqlshack.com/sql-performance-tuning-tips-for-newbies/

Today we will learn about the SQL IN operator. The RDBMS systems are very popular today in terms of data storage, data security, and data analysis. SQL stands for Structured Query Language which ...

https://www.sqlshack.com/understanding-the-sql-in-operator-with-examples/

This article will provide an understanding of identifying duplicate values in SQL. Introduction SQL Server is one of the most widely used databases at the current time. Many huge organizations ha...

https://www.sqlshack.com/finding-duplicates-in-sql/

Today, we will learn the difference between SQL SELECT UNIQUE and SELECT DISTINCT in this article. As we all know that SQL is a query language that is used to access, create, delete, and modify d...

https://www.sqlshack.com/difference-between-sql-select-unique-and-select-distinct/

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

https://www.sqlshack.com/an-overview-of-sql-server-monitoring-tools/