Data Modernization has become important nowadays. Organizations are looking into options to migrate their on-premises database to a cloud and some other heterogeneous databases. In this article, we will see the strategy and options to migrate the Oracle database to the Azure SQL database. We will be leveraging the SSMA tool for migrating the database.
Read more »Azure
Overview of the SQL Median function
January 4, 2023In this article, we will learn how to implement the median functionality and wrap it into a SQL median function
Read more »Python serverless functions to query Azure SQL DB
December 19, 2022This article will show how to get data from Azure SQL in the Serverless Python app.
Read more »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.
Read more »Implementing Row-Level Security in Azure Synapse Serverless SQL pools using TSQL
December 5, 2022Row Level Security is a very key requirement for most database or data lake applications. Most of the databases are having natively build row-level security but Synapse serverless SQL pool doesn’t support this inbuilt functionality. In this article, we will see how to implement it.
Read more »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.
Read more »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 on separate Azure blob storage at regular intervals without affecting the performance, availability, and provisioned resource units (RUs) to ensure data protection from a data recovery standpoint which can be needed in case of data corruption, deletion, or wrongly data updates.
Read more »ODBC drivers for Azure SQL
November 9, 2022Introduction
In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from one table in Azure to SQL Server on-premises using SSIS.
Read more »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.
Read more »Enable Global Distribution to replicate data across regions in Azure Cosmos DB
November 2, 2022This article will explain about Global Distribution feature of Azure Cosmos DB and how to enable it to distribute data across regions. Azure Cosmos DB is developed to address modern application requirements in this digital era. There are different requirements to run web-based or online internet-facing applications smoothly. You need to cater enormous amount of data that can generate with very high velocity and this will cause huge numbers of read and write operations on the database. Your database needs to be responsive and quickly show the updated details for other customers. You might also need to address autoscale which will be used to address unpredictable workload during any discount offer, or festive seasons. These modern days applications must also develop in a way so that if you need to add another location to expand your business to the different regions so you don’t need to do many changes and it could be easily adjusted to expand the application for other regions.
Read more »Access Azure Cosmos DB using Data Explorer
November 1, 2022This article will explore an overview of Data explorer and how to access and manage Azure Cosmos DB using Data Explorer. Azure Cosmos DB is a fully managed, highly secure, and globally distributed NoSQL database that is designed for new-age modern application development. As this is fully managed so you don’t need administrators to manage its maintenance, patching, upgrades, capacity, and space management, auto-scaling in case of workload increase, etc. It is suitable for modern digital applications like online portals based on video streaming, gaming, Internet of things applications, online retail websites, etc.
Read more »Getting started with procedures in Azure Database for PostgreSQL
October 26, 2022In this article, we will learn how to work with procedures in Azure Database for PostgreSQL.
Read more »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.
Read more »Copy data from AWS RDS SQL Server to Azure SQL Database
October 21, 2022This blog will share with you a way to copy data from an AWS RDS SQL Server database to an Azure SQL database.
Read more »Rename on-premises SQL Server database and Azure SQL database
October 18, 2022This article explores how to rename Azure SQL Database and on-premises SQL instance database.
Read more »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 »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.
Read more »Ingesting data into Azure Synapse Data Explorer Pool
September 16, 2022In this article, we will learn how to configure a newly created Data Explorer pool in Azure Synapse followed by data ingestion into the same pool.
Read more »Getting started with Azure SQL Managed Instance
September 14, 2022Introduction
In the previous article, Getting started with Azure SQL, we learned the basics to create an Azure SQL database.
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 »Getting started with Data Explorer pools in Azure Synapse
September 5, 2022In this article, we will learn how to set up and configure Azure Data Explorer based data processing capability on Azure Synapse.
Read more »Exploring Azure SQL Database Geo-Restore
September 2, 2022This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.
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 »