This article will explore Azure automation for automatic data loading into Azure SQL Databases using the Azure Logic App.
Read more »Rajendra Gupta
Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience.
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure". I published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines.
I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups.
Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020.
Personal Blog: https://www.dbblogger.com
I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure". I published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines.
I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups.
Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020.
Personal Blog: https://www.dbblogger.com
I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Exploring Azure SQL Database Geo-Restore - September 2, 2022
- Deploy a SQL Server container using Azure Kubernetes Services (AKS) - August 31, 2022
- Deploy Azure SQL Elastic Pools for Azure SQL Database - August 23, 2022
Azure Automation: Export Azure SQL Database to Blob Storage in a BACPAC file
May 5, 2021Azure SQL Database supports exporting schema and data in a compressed format BACPAC. We can store this BACPAC file into an Azure storage account. Later, this BACPAC file can help restore the Azure SQL database, and Azure managed SQL instance or on-premises SQL Server.
Read more »
Azure Automation: Create database copies of Azure SQL Database
April 27, 2021This article will explore Azure automation for creating a new Azure SQL Database copy.
Read more »
Azure Automation: Automate Azure SQL Database indexes and statistics maintenance
April 27, 2021Azure SQL Database is a PaaS solution for migrating your on-premises databases to the Azure cloud infrastructure. It is a managed service and Azure manages the infrastructure, database availability, backup restore, and compute resources.
Read more »Lift and Shift SSIS packages using Azure Data Factory V2
April 23, 2021This article will explore the process for Lift and Shift SSIS packages to Azure using Azure Data Factory V2.
Read more »
Azure Automation: Automate Pause and Resume of Azure Analysis Services
April 20, 2021This article explores Azure Automation for the change state of Azure Analysis Services.
Read more »
Direct Query Mode in Power BI for Azure Analysis Services
April 19, 2021In this article, we will explore Direct Query Mode in Power BI for Azure Analysis Services.
Read more »
Azure Analysis Services and Power BI Live connections
April 14, 2021In this article, we will deploy Azure Analysis Services and create a live connection in the Power BI.
Read more »
An overview of Power BI data models
April 12, 2021Power BI is a business analytics solution provided by Microsoft. It helps you to create data visualizations from various data sources. We can import data from these data sources, create a data model, and prepares reports, visuals. These data sources are as below:
Read more »
Capturing deadlocks on AWS RDS SQL Server databases
April 7, 2021This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases.
Read more »
Automatic Pause and Resume of an Azure SQL database
April 2, 2021Azure SQL Database is an Infrastructure-as-a-Service component for migrating your on-premises SQL Server to cloud infrastructure. We always look for performance, cost, and scaling resources while we plan resources in the cloud. Many times, we do not want our databases running 24*7*365. Suppose you have a development or training database. Your developers work during the daytime on the weekdays. If you deploy an Azure SQL Database, you don’t get an option to stop it. You get charged for it whether you use it actively or not.
Read more »
Moving the SSISDB Catalog on a new SQL Server instance
March 30, 2021This article will explore the right way of moving integration services (SSIS) catalog SQL Database to a new instance.
Read more »
Configure long-term backup retention for Azure SQL database
March 25, 2021This article configures a long-term backup retention policy for Azure SQL Database.
Read more »
Create a transactionally consistent copy of Azure SQL database
March 22, 2021In this article, we implement a copy of the Azure SQL database using both Azure Web Portal and Azure CLI.
Read more »
An overview of Azure Cloud Shell
March 18, 2021This articles gives an overview of the Azure Cloud Shell.
Read more »
Fuzzy joins in SQL Server Machine Learning using R scripts
March 16, 2021In this article, we will discuss the Fuzzy joins in the SQL Server Machine Learning using R scripts.
Read more »
Provisioning Azure SQL database using Azure PowerShell
March 10, 2021This article will show how to create an Azure SQL database using Azure PowerShell.
Read more »
Lease Timeouts and Health Checks in SQL Server Always On Availability Groups
March 8, 2021In the 42nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks.
Read more »
SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries
March 1, 2021In this article, we will explore SUBSTRING, PATINDEX and CHARINDEX string functions for SQL queries.
Read more »
Deploy Azure Data Lake Analytics database using the U-SQL scripts
February 23, 2021In this 3rd article of the Azure Data Lake Analytics series, we will explore deploying a database, tables using U-SQL scripts.
Read more »
Join database tables using U-SQL scripts for Azure Data Lake Analytics
February 17, 2021In this article, we will explore joining database tables using U-SQL scripts for Azure Data Lake Analytics.
Read more »
Writing U-SQL scripts using Visual Studio for Azure Data Lake Analytics
February 11, 2021In the 2nd article of the series for Azure Data Lake Analytics, we will use Visual Studio for writing U-SQL scripts.
Read more »
An overview of Azure Data Lake Analytics and U-SQL
February 10, 2021In this article, we explore the Azure Data Lake Analytics and query data using the U-SQL.
Read more »
Session timeouts in SQL Server Always On Availability Groups
February 8, 2021In this 41st article for SQL Server Always On Availability Groups, we will explore the session timeout configurations for AG replicas.
Read more »
Performing minor and major version upgrades for AWS RDS SQL Server
January 29, 2021Usually, database administrators upgrade the SQL Server versions for on-premise infrastructure. The AWS cloud infrastructure for SQL Server supports two flavors for database deployments.
- SQL Server deployed on the AWS EC2 instance
- An AWS managed instance relational database service
