This article uses Azure policies to check compliance of Azure SQL Databases against the backup retention period.
Read more »Rajendra Gupta
As an MCSA certified and Microsoft Certified Trainer in Gurgaon, India, with 13 years of experience, Rajendra works for a variety of large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation. He is the author of hundreds of authoritative articles on SQL Server, Azure, MySQL, Linux, Power BI, Performance tuning, AWS/Amazon RDS, Git, and related technologies that have been viewed by over 10m readers to date.
He is 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 his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
He is 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 his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance - September 22, 2021
- Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server - September 16, 2021
- Azure Alerts for creating, modifying and deleting Azure SQL Databases - September 13, 2021
Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server
September 16, 2021This article explores the Azure built-in policies and implements them to check and fix Azure SQL Database and Azure SQL Server compliance.
Read more »
Azure Alerts for creating, modifying and deleting Azure SQL Databases
September 13, 2021This article will explore the Azure alerts configuration to audit Azure SQL Database creation, modification, and deletion activities.
Read more »
Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold
September 10, 2021This article will explore Azure automation for scaling up Azure SQL Databases based on the CPU usage threshold.
Read more »
Auto Update SQL Server Statistics Asynchronous configuration for Azure SQL Database
September 7, 2021This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »
Grant, With Grant, Revoke and Deny statements in SQL Server and Azure SQL Database
September 6, 2021This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database.
Read more »
6 Reasons why you can’t have DevOps without Test Automation
August 31, 2021This article explores the integration and requirements of DevOps with Test Automation.
Read more »
How to install SQL Server on Linux hosted on Windows Server 2019
August 30, 2021This article explores Windows Subsystem for Linux (WSL) to run the Linux operating system on Windows OS and configure SQL Server on Linux.
Read more »
Persist sampling rate for automatic SQL Server statistics updates
August 27, 2021This article explores Persist sampling rate feature for automatic SQL Server statistics update.
Read more »
How to change an Azure SQL Database Collation
August 24, 2021This article explores the Azure SQL Database Collation configuration and how to change it while importing the database from a BACPAC file.
Read more »
Configure the Max Degree of Parallelism (MAXDOP) in Azure SQL Database
August 20, 2021This article explores the Maximum Degree Of Parallelism (MAXDOP) for the Azure SQL Database.
Read more »
Relationships and comparisons between SQL Server TempDB and Model databases
August 17, 2021This article explores relationships and comparisons between SQL Server TempDB and Model databases in a unique way.
Read more »
Deploy SQL Server on Azure VM using Jupyter notebooks in Azure Data Studio
August 16, 2021This article will deploy SQL Server on Azure VM using a Jupyter notebook in Azure Data Studio.
Read more »
Deploy SQL Server on Azure VM using the Azure Portal
August 11, 2021This article guides you for deploying your first SQL Server on Azure VM using the Azure portal.
Read more »
Deploying Azure SQL Database using Azure Data Studio
August 10, 2021This article guides you to create a Jupyter notebook for Azure SQL Database deployment using Azure Data Studio.
Read more »
Access Azure SQL Database from On-premises SQL Server instance
August 4, 2021This article explores OPENROWSET, OPENDATASOURCE and Linked Server to connect Azure SQL Database from on-premises SQL Server.
Read more »
Safeguard your Azure SQL Database to prevent unexpected changes
July 30, 2021This article explores locks to prevent unexpected changes in Azure SQL Database resources.
Read more »
DDL triggers in Azure SQL Database
July 28, 2021This article explores database DDL triggers for auditing Data Definition Language (DDL) on Azure SQL Database.
Read more »
Azure SQL Database Maintenance Window
July 7, 2021Azure SQL Database and SQL Managed instance are Microsoft offerings for PaaS SQL Server in cloud infrastructure. In the case of a traditional on-premises SQL Server, at certain times, we require database system downtime to perform specific operations such as hardware upgrades, OS and SQL Server patching. In a critical production database system, it is challenging to get downtime and schedule these activities.
Read more »
Restore Transparent Data Encryption (TDE) enabled Azure SQL Database
June 30, 2021This article will restore a Transparent Data Encrypted Azure SQL Database into an on-premise SQL Server. Further, we will also create a copy of the Azure database on the same server.
Read more »
TDE customer-managed keys in Azure SQL Database
June 24, 2021Azure SQL Database is a Platform-as-a-Service (PaaS) solution that offers managed database service. Azure DB provides many features such as automatic database tuning, vulnerability assessment, automated patching, performance tuning, alerts. It provides a 99.995% availability SLA for the Zone redundant database in the business-critical service tier.
Read more »
Query Store Hints in Azure SQL Database
June 22, 2021This article explores the recently announced preview feature of Azure SQL Database – Query Store Hints.
Read more »
Azure Automation: Azure Logic Apps for face recognition and insert its data into Azure SQL Database
June 15, 2021Today, we will implement an Azure Logic App for face recognition and insert its data into an Azure SQL database.
Read more »
Azure Automation: Translate documents into different languages using Cognitive Services with Azure Logic Apps
June 9, 2021Suppose you write a technical blog in the English language for your website. You have good followers in a country where the primary language is not English. You want to translate the document content in their native language for a wider reach.
Read more »
Azure Automation: Export Azure SQL database data to CSV files using Azure Logic Apps
June 1, 2021This article uses Azure automation techniques for sending query results as a CSV file attachment in Azure SQL Database by using Azure logic apps.
Read more »