How to install PostgreSQL on Ubuntu
July 13, 2023This article covers the different methods to install Postgres on Ubuntu.
Search Results for: performance
Different methods for monitoring MongoDB databases
June 14, 2023This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases.
Understanding the Scalability in Oracle Database
March 9, 2023When an application grows the associated database grows automatically. It needs to be scaled to a larger machine or server and overall configuration needs to be increased to handle the application and database performance requirement.
Learn SQL: Insert multiple rows commands
March 6, 2023This article explains the different approaches used to insert multiple rows into SQL Server tables.
MySQL Cluster in simple words
February 23, 2023This article provides an overview of MySQL Cluster in a simple understandable manner suitable for both database beginners and professionals.
SQL Cheat Sheet for Newbies
February 21, 2023In this SQL cheat sheet, we’ll look at sample SQL queries that can help you learn basic T-SQL queries as quickly as possible.
How to use the CROSSTAB function in PostgreSQL
February 17, 2023This article will explore the use of the CROSSTAB function in PostgreSQL.
SQL Practice: Common Questions and Answers for the final round interviews
January 26, 2023In this article, we are going to make a SQL practice exercise that will help to prepare for the final round of technical interviews of the SQL jobs.
Getting started with SQL LIMIT clause
January 13, 2023Today, I am going to explain how to use the SQL LIMIT clause to limit output values. We all know RDBMS systems are one of the popular ways to store, protect, access, and analyze data in a structured way. We can store enormous sizes of data and then further can access them with the help […]
5 Best Practices for writing SQL queries
December 30, 2022In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions […]
Understanding the difference between SQL and MySQL
December 26, 2022This article will explain the difference between SQL and MySQL. Many people get confused between several database terms like SQL, MySQL, SQL Server, or other SQL-related phrases. If you are a database professional, then you should be aware of the difference between SQL and MySQL or other phrases which have SQL words included like PostgreSQL, […]
SQL Server Tutorial
December 23, 2022This article is a SQL Server Tutorial. If you want to learn how to install and start with SQL Server from 0, this is the place to start. We will teach you to install SQL Server, start your first queries, and explain the basics to start with SQL Server Integration Services (SSIS), SQL Server Reporting […]
The difference between WHERE and HAVING clause in SQL
December 16, 2022This article aims to explain the WHERE, GROUP By, and HAVING clauses in detail. Also, we will see the difference between WHERE and HAVING with examples.
Understanding business continuity solutions for Azure SQL PaaS services
December 7, 2022This article will explain various business continuity options available for Azure SQL PaaS services (SQL databases and SQL managed instances). Today we will learn about several options so that you can choose a suitable business continuity solution for your SQL databases provisioned in the Azure cloud.
Control Retention of items using TTL in Azure Cosmos DB
November 30, 2022This article will provide a detailed walkthrough for retaining items in Cosmos DB for different durations and on different levels.
Using parameterized queries to avoid SQL injection
November 18, 2022In this article, we will explain what the SQL injection attack is, why it could be hazardous, and how to defend our SQL database from this attack using parameterized queries and some third-party tools.
How to configure Continuous backup for Azure Cosmos DB account
November 14, 2022This article will explore Continuous backup and steps to configure it for a new Azure Cosmos DB account or an existing Cosmos DB account. Azure Cosmos DB is a fully managed and highly secure, NoSQL database service on the Azure cloud that is designed for modern-day application development. It automatically runs backup for its databases […]
Getting started with MySQL on AWS: Costs, Setup, and Deployment options
November 11, 2022This article will show the basics of hosting MySQL databases in Amazon Web Services (AWS).
SQL Subtract dates
November 7, 2022In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I will add some theory to understand the syntax of the DATEDIFF function which is the base of this article.
How to identify suitable SKUs for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM
October 28, 2022The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM. Every database might have different resource requirements, and we need to choose the correct DB sizing based on the current workloads.
Managing schema in Azure Database for PostgreSQL using pgAdmin
October 25, 2022In this article, we will learn how to use the features of pgAdmin for tasks like schema comparison and schema management.
Changing the location of FILESTREAM data files in SQL Database
October 14, 2022This article explains different ways to change the location of the FILESTREAM data files. The FILESTREAM feature was introduced in SQL Server 2008 version. We can efficiently store the BLOBs in the SQL database using FILESTERAM.
Querying data from Azure Database for PostgreSQL using psql
October 3, 2022In this article, we will learn how to query the data as well as database objects hosted in an instance of Azure Database for PostgreSQL using psql and export the results of the query to a file.
SQL Partition overview
September 26, 2022Introduction In SQL Server there are several kinds of SQL partitions. However, in general, we can say that a partition is a way to divide a table (sometimes a view) into smaller pieces for performance purposes. In this article, we will explain what partition does mean for a table partition and SSAS. We will also […]
Integrating Azure Data Explorer cluster with Azure Synapse
September 19, 2022This article will show how to create an Azure Data Explorer cluster, and then configure it to be used with the Azure Synapse Analytics instance.