In this article, we will learn how to use the features of pgAdmin for tasks like schema comparison and schema management.
Read more »Technologies
Reporting data from Azure Database for PostgreSQL using Power BI
October 12, 2022In this article, we will learn how to use Power BI to source data from an instance of Azure Database for PostgreSQL, transform this data and load it into Power BI for reporting.
Read more »Data Modeling with ERD features in pgAdmin
October 11, 2022In this article, we will learn how to use the ERD Project feature of pgAdmin to work with an instance of Azure Database for PostgreSQL for data modeling.
Read more »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.
Read more »Introduction to basic psql commands
September 30, 2022In this article, we will take a basic walkthrough of the psql environment and learn the commands to get acquainted with this tool.
Read more »Copy SQL Databases between Windows 10 and CentOS using the SQL Server import-export wizard
September 21, 2022In this article, we will learn how we can backup and restore the SQL Database in CentOS. This article is the third article on the topic Manage SQL Server on CentOS. In my previous article, we learned how to copy data SQL database between windows 10 and CentOS Linux using SQL Server management studio.
Read more »Manage SQL Databases in CentOS: Backup and Restore SQL Database
September 12, 2022In this article, we will learn how we can backup and restore the SQL Database in CentOS. This article is the second article on the topic Manage SQL Server on CentOS. In my previous article, Install SQL Server on CentOS, we learned how we could install and create a SQL Database in CentOS.
Read more »Understanding Azure Cosmos DB backup options
September 9, 2022This article will explore backup options available in the Azure Cosmos DB service. Backups are very important to safeguard our data in case of data corruption, data deletion, system failure, or any unforeseen circumstances like DR. We have planned, configured, and managed it for our on-prem databases whether it is SQL Server, Oracle, DB2, or system files on various machines. DBAs and Infrastructure admins have ensured to keep a backup of all these systems to safeguard their data. Similarly, we must also secure our data hosted in a cloud environment for any services whether it is Azure VMs, Azure SQL, Cosmos Db accounts, or any other services. Today we will talk about backup options available to secure cosmos DB databases and their contents.
Read more »How to configure periodic backup for an Azure Cosmos DB account
September 7, 2022This article will talk about the periodic backup policy of the Azure Cosmos DB service offered by Azure cloud. I have already explained the backup options available for Cosmos DB in my last article. I would recommend you read it by accessing the attached link “Understanding Azure Cosmos DB backups” to understand the backup policies of Azure Cosmos DB. Today, I am going to explain one of the backup options Periodic backup, and steps about how to configure it for a cosmos DB account.
Read more »Deploy a SQL Server container using Azure Kubernetes Services (AKS)
August 31, 2022This article deploys a SQL Server container using Azure Kubernetes Services (AKS).
Read more »Manage SQL Databases in CentOS: Install SQL Server on CentOS
August 24, 2022In this article, we will understand how we can manage a SQL Database in CentOS 8.0. This article is the first article on the topic Manage SQL Server on CentOS.
Read more »Getting started with PostgreSQL on Docker
August 12, 2022In this article, we will learn how to get started using PostgreSQL on Docker. PostgreSQL is one of the most popular open-source databases that is being used by a lot of developers. It is highly stable and has a large community that maintains and supports the database development lifecycle. PostgreSQL can be installed on any operating system like Windows, macOS, and Linux. With the rise in containerization technologies, PostgreSQL can now also be installed using Docker.
Read more »Understanding the OPENQUERY function in SQL Server
June 24, 2022In this article, we are going to learn about the OPENQUERY function. It is used to run an ad-hoc distributed query on the remote data source using the linked server. There are various ways to query the remote data source. You can read this article, Querying remote data sources in SQL Server, to learn more about querying the remote data source. It is also used to execute pass-through queries to run INSERT, UPDATE and DELETE statements on the tables of the database configured in the linked server.
Read more »Learn PostgreSQL: Install PostgreSQL on CentOS Linux
June 21, 2022In this article, we are going to learn how we can install PostgreSQL on CentOS. Just like Ubuntu and Redgate, CentOS is a Linux distribution and is used by many organizations. I have written an article, How to install PostgreSQL on Windows that covers the step-by-step installation process of the PostgreSQL on windows 10.
Read more »Using psql tool with Azure Database for PostgreSQL
May 27, 2022In this article, we will learn how to connect the pSQL tool with Azure Database for PostgreSQL.
Read more »Understanding and creating Azure Cosmos DB accounts
May 25, 2022This article will explore an overview of Azure Cosmos DB, we will also discuss how to create Cosmos DB along with its uses on why we need to choose Cosmos DB.
Read more »Reporting data from Azure Cosmos DB using Power BI
May 6, 2022In this article, we will learn how to report data from Azure Cosmos DB using Power BI which is one of the most popular reporting tools in the industry.
Read more »Learn PostgreSQL: Managing PostgreSQL databases
May 5, 2022In this article, we will be learning how we can manage the PostgreSQL database. I am covering the following topics.
Read more »Drop temp tables in PostgreSQL
March 22, 2022In this article, we are going to learn how we can drop the temp table in PostgreSQL. The temp table is used to store data temporarily. Suppose you want to format or manipulate the data using aggregate and string functions. So instead of processing and formatting the data in the base table, it is preferred to populate data from the base table and store it in a temporary table. You can process and format the data stored in a temporary table. The syntax to create a temporary table and regular table are the same. You can add indexes, constraints, statistics to the temporary tables. In this article, we are going to learn the following topics:
Read more »Create SSRS reports for PostgreSQL using SSDT 2017
March 7, 2022In this article, we are going to learn how we can create an SSRS report to populate the data from PostgreSQL 13 using SSDT 2017.
Read more »Connect Azure SQL Database using Python from Ubuntu
March 4, 2022Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure Data Studio, or applications for query data.
Read more »Learn PostgreSQL: How to create a table in PostgreSQL
February 8, 2022In this article, we will learn how to create a table in PostgreSQL. I am going to explain the following topics:
Read more »Working with views in Azure Database for PostgreSQL
February 4, 2022In this article, we will learn the basics of working with views in the Azure Database for PostgreSQL.
Read more »Configure ODBC drivers for Azure Database for PostgreSQL
January 24, 2022This article helps you learn how to configure an ODBC driver to connect the Azure Database for PostgreSQL. In my previous article, Configure ODBC drivers for PostgreSQL, you learned the step-by-step process to download, install and configure the ODBC driver for PostgreSQL. We also learned the process of creating a DSN used to connect PostgreSQL and populate data from it.
Read more »Deploying Azure Container Instances using YAML
January 21, 2022The Azure Container Instances provides a flexible solution for implementing container-based images in Azure infrastructure quickly. It does not require building the virtual machine, installing applications like Microsoft SQL Server, or configuring the software. You can choose the container images from the libraries and build solutions. You can use non-persisted(default) and persisted storage to avoid losing container data if your container status changes to Stopped and restarted.
Read more »