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...
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/
Introduction to the PostgreSQL tutorial to create a user In this article, we will show a PostgreSQL tutorial to create a user using PgAdmin and PL/PgSQL. Requirements PgAdmin installed. In this e...
https://www.sqlshack.com/postgresql-tutorial-to-create-a-user/
This article will provide an understanding of different ways to use substring in MySQL. Introduction MySQL is an open-source relational database management system. It is a widely used relational ...
https://www.sqlshack.com/mysql-substring-uses-with-examples/
This article will show PostgreSQL Data Types with various examples. Data Types are an important part of a database. It represents values associated with it. Choosing the right data type for a tab...
https://www.sqlshack.com/an-introduction-to-postgresql-data-types-with-examples/
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework. Introduction Unit testing is a testing technique that allows us...
https://www.sqlshack.com/sql-unit-testing-reference-guide-for-beginners/