This article explains the internals of the Ghost cleanup task for SQL Server Databases.
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)
- Learn the PostgreSQL COALESCE command - January 19, 2023
- Use of the RESTORE FILELISTONLY command in SQL Server - December 21, 2022
- How to add or subtract dates in SQL Server - December 15, 2022
MSDB SQL Database Maintenance and Cleanup
October 4, 2021This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA.
Read more »
DTU and vCore based models for Azure SQL Databases
September 27, 2021Azure SQL Database is a popular choice for migrating your database from on-premises to cloud infrastructure. It enables you to move to a fully managed Platform as a Service (PaaS) with desired performance and cost-effectiveness.
Read more »
Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance
September 22, 2021This article uses Azure policies to check compliance of Azure SQL Databases against the backup retention period.
Read more »
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 »