Rajendra Gupta

Rajendra Gupta is a Consultant DBA with 14+ years of extensive experience in database administration including large critical OLAP, OLTP, Reporting and SharePoint databases.

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: [email protected] for any consulting help.

2023 Awards MSSQLTips award

2022 Awards MSSQLTips award

2021 Awards MSSQLTips award

2020 Awards MSSQLTips award

2018 Awards MSSQLTips award

2017 Awards MSSQLTips award

2016 Awards MSSQLTips award

2015 Awards MSSQLTips award

Category	Tip Title
Amazon AWS	AWS Athena Partitioning to Improve Query Performance and Cost Reduction
Amazon AWS	AWS Command Line Interface Utility for Configuration and Management
Amazon AWS	Configure SQL Server Database Mail on Amazon RDS
Amazon AWS	Limit Data Scanning and Excess Query Plans in Amazon Athena
Amazon AWS	Query Amazon CloudTrail Logs using Amazon Athena for AWS Account Auditing
Amazon AWS	SQL Athena Introduction - How it works, Use Cases and Advantages
Amazon AWS	SQL Server Linked Server to Access Amazon Athena Tables
Amazon AWS	Working with AWS Athena - Configuration, Query Data, Create Tables and Views
Amazon AWS RDS	AWS CLI Syntax and Examples to Create Amazon RDS SQL Server Instance
Amazon AWS RDS	Introduction to AWS RDS SQL Server Features
Amazon AWS RDS	Monitor SQL Deadlocks in Amazon RDS for SQL Server
Amazon AWS RDS	Steps to Quickly Configure an AWS RDS SQL Server instance
Artificial Intelligence	Exploring AI Tools for Writing SQL Queries - Are they reliable?
Azure	An Overview of Azure Cognitive Search Service
Azure	Azure Blob Storage Data Upload with SSIS
Azure	Configure and Customize SQL Azure Dynamic Data Masking
Azure	SQL Azure Geo Replication Configuration and Testing
Azure Cosmos DB	Azure Cosmos DB Consistency Levels - Strong, Bounded Staleness, Session, Consistent Prefix and Eventual
Azure Cosmos DB	Azure Cosmos DB Continuous Backups Step By Step
Azure Cosmos DB	Azure Cosmos DB Periodic Backup
Azure Cosmos DB	Introduction to Azure Cosmos DB a NoSQL Database for Documents and JSON
Azure Cosmos DB	Learn about Azure Cosmos DB Globally Distributed Databases
Azure Cosmos DB	Migrating SQL Data into Azure Cosmos DB
Azure Cosmos DB	Price Differences for Azure Cosmos DB Provisioned or Serverless Throughput Cost
Azure Data Factory	Azure Data Factory for Web Scraping
Azure Data Studio	Azure Data Studio (ADS) - Download, Installation and Configuration
Azure Data Studio	Azure Data Studio Introduction
Azure Data Studio	Getting Started with Query History and Table Designer in Azure Data Studio
Azure Data Studio	Guide to Build Graph Node and Edge Tables with Azure Data Studio
Azure Data Studio	Install Azure Data Studio on Linux systems
Azure Data Studio	Query Plan Viewer in Azure Data Studio
Azure SQL Database	Azure AD Authentication for Azure SQL Databases
Azure SQL Database	Azure SQL Database Ledger Getting Started and Examples
Azure SQL Database	Create Index for Full Text Search using Azure Cognitive Service and Azure SQL Database
Azure SQL Database	Introduction to Azure SQL Database Ledger for Data Tampering Protection
Azure SQL Database	Query Audit data in Azure SQL Database using Kusto Query Language (KQL)
Azure SQL Database	Server and Database Level Auditing for Azure SQL databases
Change Data Capture	Configure and Query Change Data Capture (CDC) data for Azure SQL Database
Change Data Capture	How to export incremental data from Azure SQL Database to Azure using Change Data Capture (CDC)
Clustering	What's the Quarantine state in Windows Failover Clusters
Compression	SQL Server Compress and Decompress Functions
Database Administration	No More Service Packs for SQL Server
Database Administration	Pausing SQL Server Services to Stop New Connections
Database Design	Append Columns to SQL Server Table and Add Data to the Table
Database Mirroring	SQL Server Database Mirroring Automatic Page Repair
Database Mirroring	SQL Server Database Mirroring Report
Extended Events	Capture Detailed SQL Server Restore Steps with Extended Events
Extended Events	Manage Extended Events for SQL Server 2016 Analysis Services in Management Studio
Extended Events	Overview of XEvent Profiler in SQL Server Management Studio
Extended Events	Profiler equivalent templates for Extended Events Sessions in SQL Server 2016
Extended Events	SQL Server 2016 Telemetry Extended Event Session
Extended Events	Understanding database recovery with SQL Server 2016 Extended Events
Functions System	CONCAT and CONCAT_WS function in SQL Server
Functions System	Percent_Rank and Cume_Dist functions in SQL Server 2012
Functions System	SQL Server 2012 Analytical Functions - Percentile_Cont and Percentile_Disc
Functions System	SQL Server 2012 Functions - First_Value and Last_Value
Functions System	SQL Server Lead and Lag Functions
Identities	SQL Server 2017 IDENTITY_CACHE feature
Indexing	Columnstore index feature in SQL Server 2012
Install and Uninstall	Install SQL Server 2012 Using SysPrep
Integration Services Configuration Options	Execute SSIS Package in Scale Out Mode - SQL Server 2017
Integration Services Configuration Options	SQL Server 2017 SSIS Scale Out Configuration
Integration Services Configuration Options	SQL Server vNext (SQL Server 2017) SSIS Scale Out Feature
Integration Services Development	Explore RecordSet Destination in SSIS Package
Monitoring	Fast and Efficient Way to Monitor and Solve SQL Server Performance Issues
Performance Tuning	DBCC CLONEDATABSE Enhancements in SQL Server 2016 SP1
Performance Tuning	SQL Server DBCC CLONEDATABASE Example
PowerShell	New PowerShell cmdlets to read and write SQL Server tables
PowerShell	PowerShell changes and new cmdlets for SQL Server 2016
PowerShell	SQL Server 2016 PowerShell cmdlets for SQL Agent
Professional Development Certifications	Microsoft SQL Certifications Program Changes
Professional Development Interview Questions DBA	SQL Server Backup Interview Questions
Professional Development Interview Questions DBA	SQL Server Restore Interview Questions
Python	Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code
Python	Python Variables and Data Types
Recovery Models	Database recovery model change notification report for SQL Server
Recovery Models	Indirect Checkpoints in SQL Server 2012
Replication	Drop table from a published SQL Server database
Replication	SQL Server replication between different schemas
Replication	SQL Server Transactional Replication Static Row and Column Filters
Reporting Services Administration	Reporting Services Subscriptions in SQL Server 2019
Reporting Services Configuration	SQL Server 2016 Reporting Services Custom Branding Example
Reporting Services Installation	Installing SQL Server Reporting Services 2017
Reporting Services Overview	Adding User Comments to Reports in SQL Server Reporting Services
Security	Migrate SQL Server Logins with PowerShell
Security	SQL Server Security Vulnerability Assessment Tool in SSMS 17.4
SQL Operations Studio	Add SQL Server Agent Management to SQL Operations Studio
SQL Operations Studio	Backup and Restore Database Tasks Using SQL Operations Studio
SQL Operations Studio	Creating custom insight widgets in SQL Operations Studio
SQL Operations Studio	Customizing Dashboards in SQL Operations Studio
SQL Operations Studio	Installing Extensions in SQL Operations Studio
SQL Operations Studio	New SQL Operations Studio Installation and Overview
SQL Operations Studio	SQL Operations Studio - Query Editor and Source Control
SQL Server 2016	Consistency Checks for SQL Server Analysis Services
SQL Server 2016	Download and Install SQL Server 2016 Sample Databases WideWorldImporters and WideWorldImportersDW
SQL Server 2016	In Memory OLTP Changes in SQL Server 2016
SQL Server 2016	Including NULL Values in JSON Output in SQL Server 2016
SQL Server 2016	SQL Server 2016 Auditing Improvements
SQL Server 2016	SQL Server 2016 Database Maintenance Plan Improvements
SQL Server 2016	SQL Server 2016 Database Scoped Configuration Options
SQL Server 2016	SQL Server 2016 Database Scoped Configurations for MAXDOP, Procedure Cache and Cross Database Queries
SQL Server 2016	SQL Server 2016 Extended Events Detailed Backup Information
SQL Server 2016	SQL Server 2016 Installation Changes
SQL Server 2016	SQL Server 2016 Parameter Sniffing as a Database Scoped Configuration
SQL Server 2016	SQL Server 2016 RC0 Installation and Configuration Changes
SQL Server 2016	SQL Server 2016 Row Level Security Block and Filter Predicates Example
SQL Server 2016	SQL Server 2016 Row Level Security Example
SQL Server 2016	SQL Server 2016 Sample Workload Tools
SQL Server 2016	SQL Server 2016 Trace Flags 1118 and 1117 for Page Allocations
SQL Server 2017	SQL Server 2017 Adaptive Memory Grant Feedback for Stored Procedure Performance Improvements
SQL Server 2017	SQL Server 2017 Adaptive Query Processing Query Plan Enhancements with Interleaved Execution
SQL Server 2017	SQL Server 2017 Automatic Query Tuning
SQL Server 2017	SQL Server 2017 Differential Backup Changes
SQL Server 2017	SQL Server 2017 Graph Database Example
SQL Server 2017	SQL Server 2017 Graph Database Query Examples
SQL Server 2017	SQL Server 2017 Restore Database Error in SSMS
SQL Server 2017	SQL Server 2017 Resumable Online Index Rebuilds
SQL Server 2017	SQL Server 2017 Step By Step Installation Guide
SQL Server 2017	SQL Server 2017 Transaction Log Backup Improvements
SQL Server 2019	Overview of SQL Server 2019 Features
SQL Server 2019	Resumable Online Index Create in SQL Server 2019
SQL Server 2022	SQL Server 2022 Restore a database from AWS S3 bucket - Part 3
SQL Server 2022	SQL Server 2022: Backup and Restore database to AWS S3 bucket - Part 1
SQL Server 2022	SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2
SQL Server Agent	SQL Agent Error the CmdExec subsystem failed to load
SQL Server Management Studio	New Features in SQL Server Management Studio v17
SQL Server Management Studio	SQL Server 2016 Management Studio Enhancements
SQL Server Management Studio	SQL Server 2016 Management Studio Enhancements - Part 2
SQL Server Management Studio	SQL Server Management Studio 17.x Important Features
SQL Server Management Studio	SQL Server Management Studio Import Wizard Improvements
SQL Server Management Studio	SQL Server Management Studio Output Option for Object Explorer Queries and Telemetry Data
SQL Server on Linux	How to change default backup directory in SQL Server on Linux
SQL Server on Linux	How to change default port for SQL Server on Linux
SQL Server on Linux	How to change SQL Server Collation on Linux
SQL Server on Linux	How to enable and disable SQL Server traceflags globally for Linux Instances
SQL Server on Linux	How to install SQL Server on RHEL for Oracle VirtualBox - Part 1
SQL Server on Linux	How to Move SQL Server System Databases to a different directory on Linux
SQL Server on Linux	How to Stop, Start, Enable and Disable SQL Server Services on Linux
SQL Server on Linux	Installation of SQL Server 2017 on Oracle VM VirtualBox for Red Hat - Part 2
SQL Server on Linux	SQL Server 2017 installation on Ubuntu using Docker
SQL Server on Linux	SQL Server Configuration Manager for Linux
Stored Procedures	SQL Server RETURN and OUTPUT Clause in Stored Procedures
Testing	Attach Sample Database - Adventureworks in SQL Server 2012
Tools	Deploy Containers with Go-SqlCmd
Tools	Installing and Using mssql-cli on Linux for SQL Server
Tools	New Command Line Tool go-sqlcmd for SQL Server
Tools	New Interactive Command Line Tool MSSQL-cli for SQL Server
Tools	Upgrading MSSQL-cli and new commands
TSQL	SELECT...INTO Enhancements in SQL Server 2017
TSQL	SQL CASE Statement in Where Clause to Filter Based on a Condition or Expression
TSQL	SQL Declare Variable to Define and Use Variables in SQL Server code
TSQL	SQL Round Function to Round Numbers Up or Down
TSQL	SQL SUBSTRING Function Code Examples
Views	Benefits and Limitations of SCHEMABINDING Views in SQL Server
Views	CREATE VIEW SQL Server Tutorial

No Records Found

CategoryGroup	Category (articles)
Analysis Services	Analysis Services Administration (33)
Analysis Services	Analysis Services Development (95)
Analysis Services	Analysis Services Dimensions (16)
Analysis Services	Analysis Services Measure Groups (7)
Analysis Services	Analysis Services Performance (14)
Analysis Services	Analysis Services Security (7)
Analysis Services	Analysis Services Tutorials (6)
Business Intelligence	Artificial Intelligence (23)
Business Intelligence	Big Data (25)
Business Intelligence	Data Science (3)
Business Intelligence	Data Warehousing (7)
Business Intelligence	Import and Export (81)
Business Intelligence	R Language (11)
Business Intelligence	Snowflake (29)
Cloud	Amazon AWS (38)
Cloud	Amazon AWS RDS (21)
Cloud	Azure (149)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (15)
Cloud	Azure Functions (7)
Cloud	Azure SQL Database (51)
Cloud	Azure SQL Managed Instance (5)
Cloud	Cloud Strategy (25)
Cloud	Google Cloud (10)
Cloud Analytics	Apache Spark (13)
Cloud Analytics	Azure Data Factory (73)
Cloud Analytics	Azure Databricks (39)
Cloud Analytics	Azure Integration Services (14)
Cloud Analytics	Azure Synapse Analytics (41)
Cloud Analytics	Microsoft Fabric (17)
Data Quality	Data Cleansing for Validation (4)
Data Quality	Data Quality Services (10)
Data Quality	Master Data Services (41)
Database Administration	Central Management Servers (10)
Database Administration	Comparison Data and Objects (14)
Database Administration	Database Administration (208)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Scripts (35)
Database Administration	System Databases (31)
Database Configuration	Compression (22)
Database Configuration	Database Configurations (19)
Database Configuration	Database Mail (18)
Database Configuration	FILESTREAM (9)
Database Configuration	Full Text Search (21)
Database Configuration	In Memory OLTP (32)
Database Configuration	Linked Servers (18)
Database Configuration	Policy Based Management (29)
Database Configuration	Recovery Models (4)
Database Configuration	Resource Governor (5)
Database Configuration	SQL Server Configurations (75)
Database Design	Constraints (20)
Database Design	Data Types (22)
Database Design	Database Design (92)
Database Design	Identities (17)
Database Design	JOIN Tables (23)
Database Design	Synonyms (5)
Database Design	Table Valued Parameters (4)
Database Design	Temp Tables (15)
Database Design	Temporal Tables (13)
Database Design	User Defined Type UDT (3)
Database Design	Views (17)
Database Development	Application Development (46)
Database Development	Common Runtime Language (13)
Database Development	Debugging (4)
Database Development	DevOps (36)
Database Development	Entity Framework (13)
Database Development	Language Integrated Query LINQ (7)
Database Development	Paging (5)
Database Development	Referential Integrity (5)
Database Development	Service Broker (11)
Database Development	Testing (32)
Database Development	XML (14)
Database Maintenance	Database Console Commands DBCCs (25)
Database Maintenance	Fragmentation and Index Maintenance (28)
Database Maintenance	Maintenance (34)
Disaster Recovery / High Availability	Availability Groups (79)
Disaster Recovery / High Availability	Backup (81)
Disaster Recovery / High Availability	Clustering (77)
Disaster Recovery / High Availability	Database Mirroring (33)
Disaster Recovery / High Availability	Disaster Recovery (23)
Disaster Recovery / High Availability	High Availability (3)
Disaster Recovery / High Availability	Log Shipping (18)
Disaster Recovery / High Availability	Replication (78)
Disaster Recovery / High Availability	Restore (42)
Functions	Dates (56)
Functions	Functions System (99)
Functions	Functions User Defined UDF (41)
Infrastructure	Contained Databases (4)
Infrastructure	Containers (12)
Infrastructure	Hardware (14)
Infrastructure	Spatial Data Storage (9)
Infrastructure	Virtualization (25)
Integration Services Admin	Integration Services Administration (10)
Integration Services Admin	Integration Services Best Practices (12)
Integration Services Admin	Integration Services Configuration Options (22)
Integration Services Admin	Integration Services Performance (12)
Integration Services Admin	Integration Services Security (7)
Integration Services Admin	Integration Services Upgrade (4)
Integration Services Development	Data Transformation Services (6)
Integration Services Development	Integration Services Analysis Services Tasks (5)
Integration Services Development	Integration Services Connection Managers (5)
Integration Services Development	Integration Services Control Flow Transformations (14)
Integration Services Development	Integration Services Data Flow Transformations (19)
Integration Services Development	Integration Services Development (116)
Integration Services Development	Integration Services Error Handling (8)
Integration Services Development	Integration Services Excel (14)
Integration Services Development	Integration Services Execute Package Options (8)
Integration Services Development	Integration Services Oracle (4)
Microsoft Office	Microsoft Access Integration (8)
Microsoft Office	Microsoft Excel Integration (45)
Microsoft Office	Microsoft Flow (1)
Other RDBMS	Other Database Platforms (16)
Other RDBMS	PostgreSQL (11)
Other RDBMS	SQL Server and Oracle Comparison (29)
Other RDBMS	SQL Server on Linux (78)
Other RDBMS	SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance	Dynamic Management Views and Functions (34)
Performance	Error Logs (11)
Performance	Extended Events (22)
Performance	Indexing (94)
Performance	Locking and Blocking (43)
Performance	Monitoring (110)
Performance	Partitioning (17)
Performance	Performance Data Warehouse (4)
Performance	Performance Tuning (124)
Performance	Profiler and Trace (20)
Performance	Query Optimization (15)
Performance	Query Plans (20)
Performance	Query Store (7)
Power Platform	Power Apps (20)
Power Platform	Power BI (172)
Power Platform	Power BI Charts (57)
Power Platform	Power BI Formatting (17)
Professional Development	Professional Development Branding (16)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (20)
Professional Development	Professional Development Certifications (62)
Professional Development	Professional Development Community (16)
Professional Development	Professional Development Interview Questions BI (18)
Professional Development	Professional Development Interview Questions DBA (23)
Professional Development	Professional Development Interview Questions Developer (9)
Professional Development	Professional Development Interviewing (39)
Professional Development	Professional Development Job Search (24)
Professional Development	Professional Development Management (14)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Python	Python (89)
Reporting Services Admin	Reporting Services Administration (21)
Reporting Services Admin	Reporting Services Best Practices (6)
Reporting Services Admin	Reporting Services Configuration (10)
Reporting Services Admin	Reporting Services Installation (10)
Reporting Services Admin	Reporting Services Migration (5)
Reporting Services Admin	Reporting Services Monitoring (5)
Reporting Services Admin	Reporting Services Network Load Balancing (4)
Reporting Services Admin	Reporting Services Performance (6)
Reporting Services Admin	Reporting Services Security (8)
Reporting Services Development	Reporting Services Analysis Services (4)
Reporting Services Development	Reporting Services Charts (25)
Reporting Services Development	Reporting Services Data Sources (10)
Reporting Services Development	Reporting Services Development (67)
Reporting Services Development	Reporting Services Dynamic Reports (11)
Reporting Services Development	Reporting Services Formatting (26)
Reporting Services Development	Reporting Services KPI (5)
Reporting Services Development	Reporting Services Overview (5)
Reporting Services Development	Reporting Services Parameters (15)
Reporting Services Development	Reporting Services Report Builder (9)
Security	Auditing and Compliance (47)
Security	Encryption (35)
Security	Security (199)
Security	SQL Injection (5)
Security	Surface Area Configuration Manager (4)
SharePoint	SharePoint (131)
SharePoint	SharePoint Administration (46)
SharePoint	SharePoint Configuration (27)
SharePoint	Sharepoint Design (46)
SharePoint	SharePoint Document Management (20)
SQL Coding	Change Data Capture (16)
SQL Coding	Common Table Expressions (4)
SQL Coding	Dynamic SQL (7)
SQL Coding	Error Handling (11)
SQL Coding	Stored Procedures (30)
SQL Coding	Transactions (9)
SQL Coding	Triggers (44)
SQL Coding	TSQL (342)
Tools	Azure Data Studio (18)
Tools	PowerShell (131)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (95)
Tools	SQL Server Management Objects SMO (3)
Tools	SQL Server Management Studio (78)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (9)
Tools	Tools (35)
Versions	Deprecated Features (6)
Versions	Express Edition (16)
Versions	Install and Uninstall (33)
Versions	Licensing (4)
Versions	SQL Server 2016 (96)
Versions	SQL Server 2017 (44)
Versions	SQL Server 2019 (20)
Versions	SQL Server 2022 (21)
Versions	Upgrades and Migrations (55)