This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database.
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
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 »
Azure Automation: Publish LinkedIn posts and tweets automatically using Azure Logic Apps
May 25, 2021This article implements Azure Automation logic for automatically publishing a LinkedIn post and Twitter’s Tweet using the simplified Azure Logic App.
Read more »
Azure Automation: Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage
May 17, 2021This article uses Azure Automation techniques to import data into Azure SQL Database from Azure Storage container.
Read more »
Azure Automation: Analyzing Twitter sentiments using Azure Logic Apps
May 14, 2021This article configures Azure Automation for Analyzing Twitter sentiments using Azure Logic Apps and stores them into Azure SQL Database.
Read more »
Azure Automation: Auto-scaling Azure SQL database with Azure Logic Apps
May 12, 2021Azure SQL Database supports DTU-based and vCores based purchasing models for deploying your databases in the Azure managed service.
Read more »
Azure Automation: Building approval-based automated workflows using Azure Logic Apps
May 11, 2021In the Azure Automation article, Azure Automation: Automate data loading from email attachments using Azure Logic Apps, we did the following tasks:
Read more »