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 can be reached at: Rajendra.gupta16@gmail.com for any consulting help.
  • MSSQLTips Awards:
  • Author of the Year - 2022 | Author Contender - 2021/2023/2024 | Champion Award (100+ tips) - 2020
Title Category Date
Overview of Azure Options for SQL Server Azure2026-05-19
SQL Server 2025 New Features and Enhancements SQL Server 20252026-05-09
Date Truncation with DATETRUNC() function in SQL Server Dates2026-05-06
SQL CASE Statement in WHERE Clause Examples TSQL2026-05-04
SQL Server 2025 Quick Reference Guide SQL Server 20252026-04-23
AWS Cost Optimization for SQL Server Amazon AWS2026-03-31
SQL Concatenate String using Double Pipe (||) Operator in SQL Server 2025 SQL Server 20252026-02-06
SQL Server 2025 Product() Function Examples SQL Server 20252025-11-24
SQL Declare Variable Code Examples TSQL2025-10-30
Install SQL Server 2025 Standard Developer Edition for Linux on AWS EC2 SQL Server 20252025-10-27
SSMS Copilot to Boost Productivity and Efficiency SQL Server Management Studio2025-09-23
Install SQL Server 2025 Standard Developer Edition SQL Server 20252025-07-31
Alter Table Add Column SQL Server TSQL2025-06-06
SQL RETURN and SQL OUTPUT clause in Stored Procedures Stored Procedures2025-05-28
SQL IS [NOT] DISTINCT FROM predicate in SQL Server 2022 TSQL2025-05-22
Identify Anti-Patterns in SQL Server Queries Performance Tuning2025-03-18
SQL Server Management Studio (SSMS) 21 Changes SQL Server Management Studio2025-02-26
SQL Coalesce Function Examples and Use Cases TSQL2025-02-05
Windows Failover Cluster Node Quarantined Clustering2025-01-12
Python Numpy for Multi-Dimensional Arrays Python2024-12-12
Data Visualization with Python Matplotlib Python2024-11-25
Azure Database for MySQL Flexible Server Administrative Tasks Azure2024-11-04
Explore Pandas in Python to Analyze and Manipulate Tabular Data Python2024-10-15
Implement Azure Database for MySQL Step-by-Step Azure2024-09-13
Azure Managed Instance Download and Restore SQL Server Backup Azure SQL Managed Instance2024-09-06
Microsoft Copilot for Azure SQL Database Management and Development Artificial Intelligence2024-08-30
Download AWS RDS SQL Server Backup Amazon AWS RDS2024-08-15
Get Azure SQL Managed Instance free for 12 months Azure SQL Managed Instance2024-08-09
Get Free Access to Azure SQL Database for a Lifetime Azure SQL Database2024-07-31
Polymorphism in Python Code Examples – Functions, Classes, Inheritance Python2024-07-19
Python Classes for Code Reusability Python2024-06-24
Python Functions for Reducing Code Complexity Python2024-06-12
SQL Server Management Studio 20 New Features and Functionality SQL Server Management Studio2024-05-27
Python Control Flow – if, if else, nested if, for loop and while loop Python2024-05-22
Python String Functions: Concatenate, Split, Replace, Upper, Lower Python2024-05-02
Python Variables and Data Types Python2024-04-11
AI Tools to Generate SQL Queries with Code Reliability Artificial Intelligence2024-03-22
Python Programming Introduction – Install, Jupyter Notebooks, VS Code Python2024-02-28
Limit Data used by Amazon Athena Queries Amazon AWS2023-11-29
Query Amazon CloudTrail Logs using Amazon Athena Amazon AWS2023-11-07
AWS Athena Data Partitioning to Improve Performance and Reduce Cost Amazon AWS2023-10-16
Create a Linked Server from SQL Server to AWS Athena Tables Amazon AWS2023-10-06
AWS Athena Configuration, Querying Data, Create Tables and Views Amazon AWS2023-09-26
Learn SQL Athena – How, Why and Advantages Amazon AWS2023-09-19
Append SQL Table with New Columns and Add New Data Database Design2023-08-08
Go-SqlCmd for Deploying and Using Containers Tools2023-07-26
go-sqlcmd tool for SQL Queries, Scripts and Automation Tools2023-07-06
SQL Round Function Examples TSQL2023-06-14
SQL SUBSTRING Code Examples and Usage TSQL2023-05-10
SQL Certifications Program from Microsoft Certifications2023-04-06
SCHEMABINDING Views in SQL Server Example Views2023-03-30
CREATE VIEW SQL Server Examples with T-SQL and SSMS Views2023-03-07
Capture SQL Deadlocks using Amazon RDS for SQL Server Amazon AWS RDS2022-12-01
AWS CLI to Deploy Amazon RDS SQL Server Instance Amazon AWS RDS2022-11-23
AWS Command Line for Configuration and Management Amazon AWS2022-10-31
Configure and Deploy a new Amazon AWS RDS SQL Server instance Amazon AWS RDS2022-09-21
AWS RDS SQL Server Fully Managed Platform Amazon AWS RDS2022-09-12
Build Graph Node and Edge Tables using Azure Data Studio Azure Data Studio2022-09-02
Review SQL Execution Plan in Azure Data Studio Azure Data Studio2022-08-18
Install Azure Data Studio on RedHat, Ubuntu and SUSE Linux Azure Data Studio2022-08-10
Azure Data Studio Download, Install and Configure Azure Data Studio2022-07-20
How to Restore a SQL Server 2022 Database using AWS S3 Storage SQL Server 20222022-07-05
How to Backup SQL Server 2022 database to AWS S3 Storage SQL Server 20222022-07-01
SQL Server 2022 Backup and Restore to AWS S3 storage SQL Server 20222022-06-30
Azure Data Studio to Manage SQL Server on Windows, Linux and the Cloud Azure Data Studio2022-06-07
Export Data from Azure SQL Database to Azure with Change Data Capture Change Data Capture2022-06-02
Azure Data Studio Query History and Table Designer Azure Data Studio2022-05-18
Azure SQL Database Change Data Capture Configuration and Querying Data Change Data Capture2022-05-02
Configure Azure Cosmos DB Continuous Backups Azure Cosmos DB2022-04-12
Azure Cosmos DB Price Differences for Provisioned or Serverless Azure Cosmos DB2022-04-07
Azure Cosmos DB Backup Options, Retention and Intervals Azure Cosmos DB2022-03-22
Azure Cosmos DB Data Consistency Levels Azure Cosmos DB2022-03-03
Azure Cosmos DB Globally Distributed Databases to Replicate Data Azure Cosmos DB2022-02-22
How to Import Data from Azure SQL Database into Azure Cosmos DB Azure Cosmos DB2022-02-08
Azure Cosmos DB a NoSQL Introduction Azure Cosmos DB2022-01-26
Full Text Search for Azure Cognitive Service and Azure SQL Database Azure SQL Database2021-12-30
Azure Cognitive Search Overview Azure2021-12-28
Move SQL Server System Databases on Linux SQL Server on Linux2021-12-23
Build a Web Scraping Tool using Azure Data Factory Azure Data Factory2021-11-24
Azure SQL Database Ledger Getting Started and Examples Azure SQL Database2021-06-09
Azure SQL Database Ledger Introduction for Data Tampering Protection Azure SQL Database2021-06-08
Query Audit data in Azure SQL Database using Kusto Query Language Azure SQL Database2021-03-16
Azure AD Authentication for Azure SQL Databases Azure SQL Database2021-03-01
CONCAT SQL Function in SQL Server Functions System2021-02-22
Server and Database Level Auditing for Azure SQL databases Azure SQL Database2021-02-11
Azure Blob Storage Data Upload with SSIS Azure2020-12-16
RecordSet Destination in SSIS Integration Services Development2020-12-01
Amazon RDS SQL Server Database Mail Configuration Amazon AWS2020-11-10
SSRS Data Driven Subscription Reporting Services Administration2020-11-03
Install SQL Server 2017 on Oracle VM VirtualBox for Red Hat – Part 2 SQL Server on Linux2019-02-01
How to install SQL Server on RHEL for Oracle VirtualBox – Part 1 SQL Server on Linux2019-01-31
SQL Server Restore Interview Questions DBA Interview Questions2018-12-24
Resumable Online Index Create in SQL Server 2019 SQL Server 20192018-12-21
SQL Server Backup Interview Questions DBA Interview Questions2018-12-14
Installing and Using mssql-cli on Linux for SQL Server Tools2018-11-27
SQL Server 2017 Step By Step Installation Guide SQL Server 20172018-11-07
Overview of SQL Server 2019 Features SQL Server 20192018-10-30
Add SQL Server Agent Management to SQL Operations Studio SQL Operations Studio2018-10-01
Installing Extensions in SQL Operations Studio SQL Operations Studio2018-09-18
Adding User Comments to Reports in SSRS Reporting Services Overview2018-09-07
SQL Server Management Studio 17.x Important Features SQL Server Management Studio2018-08-20
SQL Server 2017 installation on Ubuntu using Docker SQL Server on Linux2018-08-02
Capture SQL Server Management Studio Queries and Telemetry Data SQL Server Management Studio2018-07-19
Pausing SQL Server Services to Stop New Connections Database Administration2018-07-03
No More Service Packs for SQL Server Database Administration2018-06-26
Creating custom insight widgets in SQL Operations Studio SQL Operations Studio2018-06-13
Customizing Dashboards in SQL Operations Studio SQL Operations Studio2018-05-10
Backup and Restore Database Tasks Using SQL Operations Studio SQL Operations Studio2018-04-24
Upgrading MSSQL-cli and new commands Tools2018-03-29
SQL Operations Studio – Query Editor and Source Control SQL Operations Studio2018-03-20
New SQL Operations Studio Installation and Overview SQL Operations Studio2018-03-02
New Interactive Command Line Tool MSSQL-cli for SQL Server Tools2018-02-14
SQL Server Security Vulnerability Assessment Tool in SSMS 17.4 Security2018-02-02
SQL Server 2017 IDENTITY_CACHE feature Identities2018-01-08
Installing SSRS 2017 Reporting Services Installation2018-01-03
Overview of XEvent Profiler in SQL Server Management Studio Extended Events2017-12-20
New Features in SQL Server Management Studio v17 SQL Server Management Studio2017-11-28
SQL Server Management Studio Import Wizard Improvements SQL Server Management Studio2017-11-15
SQL Server 2017 Automatic Query Tuning SQL Server 20172017-10-24
SELECT…INTO Enhancements in SQL Server 2017 TSQL2017-09-28
SQL Server 2017 Transaction Log Backup Improvements SQL Server 20172017-09-13
SQL Server 2017 Differential Backup Changes SQL Server 20172017-09-05
SQL Server 2017 Graph Database Query Examples SQL Server 20172017-08-30
SQL Server 2017 Adaptive Memory Grant Feedback for Stored Procedure Performance Improvements SQL Server 20172017-08-21
SQL Server 2017 Adaptive Query Processing Query Plan Enhancements with Interleaved Execution SQL Server 20172017-08-10
SQL Server 2017 Resumable Online Index Rebuilds SQL Server 20172017-08-04
Execute SSIS Package in Scale Out Mode – SQL Server 2017 Integration Services Configuration Options2017-07-27
SQL Server Restore Database Error in SQL Server Management Studio SQL Server 20172017-06-26
SQL Server 2017 Graph Database Example SQL Server 20172017-06-13
SQL Server 2017 SSIS Scale Out Configuration Integration Services Configuration Options2017-06-06
How to change default backup directory in SQL Server on Linux SQL Server on Linux2017-05-25
SQL Server vNext (SQL Server 2017) SSIS Scale Out Feature Integration Services Configuration Options2017-05-11
How to change SQL Server Collation on Linux SQL Server on Linux2017-04-28
Enable and disable SQL Server traceflags globally for Linux Instances SQL Server on Linux2017-04-06
SQL Server Configuration Manager for Linux SQL Server on Linux2017-03-30
How to change default port for SQL Server on Linux SQL Server on Linux2017-03-06
How to Stop, Start, Enable and Disable SQL Server Services on Linux SQL Server on Linux2017-02-27
DBCC CLONEDATABSE Enhancements in SQL Server 2016 SP1 Performance Tuning2017-02-20
Migrate SQL Server Logins with PowerShell Security2017-01-31
New PowerShell cmdlets to read and write SQL Server tables PowerShell2017-01-06
SQL Server 2016 PowerShell cmdlets for SQL Agent PowerShell2016-12-22
SQL Server 2016 Reporting Services Custom Branding Example Reporting Services Configuration2016-12-08
PowerShell changes and new cmdlets for SQL Server 2016 PowerShell2016-11-17
Drop table from a published SQL Server database Replication2016-11-01
SQL Server 2016 Management Studio Enhancements – Part 2 SQL Server Management Studio2016-10-21
Profiler like templates for Extended Events Sessions in SQL Server Extended Events2016-10-03
SQL Server DBCC CLONEDATABASE Example Performance Tuning2016-09-19
SQL Server 2016 Sample Workload Tools SQL Server 20162016-09-16
SQL Server 2016 Management Studio Enhancements SQL Server Management Studio2016-08-29
SQL Server 2016 Telemetry Extended Event Session Extended Events2016-08-19
Download and Install SQL Server Sample Databases WideWorldImporters SQL Server 20162016-08-02
SQL Server 2016 Trace Flags 1118 and 1117 for Page Allocations SQL Server 20162016-07-14
Understanding database recovery with SQL Server 2016 Extended Events Extended Events2016-07-05
SQL Server 2016 Auditing Improvements SQL Server 20162016-06-24
SQL Server 2016 Parameter Sniffing as a Database Scoped Configuration SQL Server 20162016-05-31
Capture Detailed SQL Server Restore Steps with Extended Events Extended Events2016-05-17
SQL Server Database Scoped Configuration Settings SQL Server 20162016-05-04
SQL Server 2016 Extended Events Detailed Backup Information SQL Server 20162016-04-21
SQL Server 2016 Database Scoped Configuration Options SQL Server 20162016-04-13
SQL Server 2016 RC0 Installation and Configuration Changes SQL Server 20162016-04-07
SQL Azure Geo Replication Configuration and Testing Azure2016-03-25
Configure and Customize SQL Azure Dynamic Data Masking Azure2016-03-17
SQL Server Compress and Decompress Functions Compression2016-02-11
SQL Server 2016 Row Level Security Block and Filter Predicates Example SQL Server 20162016-01-26
Manage Extended Events for SQL Server 2016 Analysis Services in Management Studio Extended Events2016-01-13
SQL Server Transactional Replication Static Row and Column Filters Replication2015-12-02
SQL Server 2016 Database Maintenance Plan Improvements SQL Server 20162015-11-18
Consistency Checks for SSAS SQL Server 20162015-11-09
In Memory OLTP Changes in SQL Server 2016 SQL Server 20162015-11-05
SQL Server replication between different schemas Replication2015-10-27
Including NULL Values in JSON Output in SQL Server 2016 SQL Server 20162015-10-08
SQL Server 2016 Row Level Security Example SQL Server 20162015-09-18
SQL Server 2016 Installation Changes SQL Server 20162015-07-22
SQL Server Database Mirroring Report Database Mirroring2015-07-13
SQL Server Database Mirroring Automatic Page Repair Database Mirroring2015-07-03
Install SQL Server 2012 Using SysPrep Install and Uninstall2012-12-03
Indirect Checkpoints in SQL Server 2012 Recovery Models2012-06-21
Percent_Rank and Cume_Dist functions in SQL Server 2012 Functions System2012-06-12
SQL Server 2012 Analytical Functions – Percentile_Cont and Percentile_Disc Functions System2012-06-01
Attach Sample Database – Adventureworks in SQL Server 2012 Testing2012-05-14
SQL Server Lead and Lag Functions Functions System2012-04-16
Columnstore index feature in SQL Server 2012 Indexing2012-04-02
SQL Server 2012 Functions – First_Value and Last_Value Functions System2012-03-12
Database recovery model change notification report for SQL Server Recovery Models2011-10-21
SQL Agent Error the CmdExec subsystem failed to load SQL Server Agent2011-10-07