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.

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	Quickly Deploy SQL Server on Linux using AWS Launch Wizard
Amazon AWS	Simplify and Automate the Migration of Your Applications with AWS Migration Hub Orchestrator
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
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 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
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	Append Columns to SQL Server Table and Add Data to the Table
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 (31)
Analysis Services	Analysis Services Development (94)
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 Tools (1)
Analysis Services	Analysis Services Tutorials (6)
Analysis Services	Cortana (5)
Analysis Services	Performance Point (4)
Business Intelligence	Big Data (24)
Business Intelligence	Data Warehousing (6)
Cloud	Amazon AWS (40)
Cloud	Amazon AWS RDS (21)
Cloud	Apache Spark (10)
Cloud	Azure (146)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (15)
Cloud	Azure Data Factory (69)
Cloud	Azure Databricks (37)
Cloud	Azure Integration Services (14)
Cloud	Azure SQL Database (49)
Cloud	Azure SQL Managed Instance (3)
Cloud	Azure Synapse Analytics (41)
Cloud	Cloud Strategy (22)
Cloud	Google Cloud (9)
Cloud	Microsoft Fabric (9)
Data Quality	Data Quality Services (9)
Data Quality	Master Data Services (41)
Database Administration	Availability Groups (79)
Database Administration	Backup (80)
Database Administration	Central Management Servers (10)
Database Administration	Clustering (75)
Database Administration	Comparison Data and Objects (14)
Database Administration	Compression (22)
Database Administration	Contained Databases (4)
Database Administration	Containers (12)
Database Administration	Database Administration (203)
Database Administration	Database Configurations (19)
Database Administration	Database Console Commands DBCCs (25)
Database Administration	Database Mail (18)
Database Administration	Database Mirroring (33)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Deprecated Features (5)
Database Administration	DevOps (36)
Database Administration	Disaster Recovery (23)
Database Administration	Error Logs (11)
Database Administration	Express Edition (16)
Database Administration	Extended Events (22)
Database Administration	FILESTREAM (9)
Database Administration	Fragmentation and Index Maintenance (28)
Database Administration	Hardware (15)
Database Administration	High Availability (3)
Database Administration	Indexing (92)
Database Administration	Install and Uninstall (32)
Database Administration	Licensing (4)
Database Administration	Linked Servers (18)
Database Administration	Locking and Blocking (43)
Database Administration	Log Shipping (18)
Database Administration	Maintenance (34)
Database Administration	Monitoring (112)
Database Administration	Other Database Platforms (82)
Database Administration	Partitioning (17)
Database Administration	Performance Data Warehouse (4)
Database Administration	Performance Tuning (133)
Database Administration	Policy Based Management (29)
Database Administration	PowerShell (131)
Database Administration	Profiler and Trace (20)
Database Administration	Query Store (7)
Database Administration	Recovery Models (4)
Database Administration	Referential Integrity (5)
Database Administration	Replication (75)
Database Administration	Resource Governor (5)
Database Administration	Restore (42)
Database Administration	Snowflake (24)
Database Administration	SQL Server 2016 (96)
Database Administration	SQL Server 2017 (44)
Database Administration	SQL Server 2019 (20)
Database Administration	SQL Server 2022 (21)
Database Administration	SQL Server Configurations (75)
Database Administration	SQL Server on Linux (76)
Database Administration	StreamInsight (2)
Database Administration	System Databases (31)
Database Administration	Upgrades and Migrations (55)
Database Administration	Virtualization (25)
Database Administration	Windows Internal Database (1)
Database Development	Application Development (43)
Database Development	Artificial Intelligence (13)
Database Development	Azure Functions (7)
Database Development	Change Data Capture (15)
Database Development	Common Runtime Language (13)
Database Development	Common Table Expressions (4)
Database Development	Constraints (20)
Database Development	Data Cleansing for Validation (4)
Database Development	Data Science (3)
Database Development	Data Types (18)
Database Development	Database Design (80)
Database Development	Dates (54)
Database Development	Debugging (4)
Database Development	Dynamic Management Views and Functions (33)
Database Development	Dynamic SQL (7)
Database Development	Entity Framework (13)
Database Development	Error Handling (10)
Database Development	Full Text Search (21)
Database Development	Functions System (74)
Database Development	Functions User Defined UDF (41)
Database Development	Identities (17)
Database Development	Import and Export (77)
Database Development	In Memory OLTP (32)
Database Development	JOIN Tables (21)
Database Development	Language Integrated Query LINQ (7)
Database Development	Microsoft Access Integration (8)
Database Development	Microsoft Excel Integration (44)
Database Development	Microsoft Flow (1)
Database Development	Paging (5)
Database Development	Python (80)
Database Development	Query Optimization (15)
Database Development	Query Plans (20)
Database Development	R Language (11)
Database Development	Scripts (35)
Database Development	Service Broker (11)
Database Development	Spatial Data Storage (9)
Database Development	SQL Injection (5)
Database Development	SQL Server Management Objects SMO (3)
Database Development	Stored Procedures (29)
Database Development	Synonyms (5)
Database Development	Table Valued Parameters (4)
Database Development	Temp Tables (9)
Database Development	Temporal Tables (13)
Database Development	Testing (32)
Database Development	Transactions (9)
Database Development	Triggers (44)
Database Development	TSQL (386)
Database Development	User Defined Type UDT (3)
Database Development	Views (16)
Database Development	XML (14)
Integration Services	Data Transformation Services (5)
Integration Services	Integration Services Administration (10)
Integration Services	Integration Services Analysis Services Tasks (5)
Integration Services	Integration Services Best Practices (12)
Integration Services	Integration Services Configuration Options (22)
Integration Services	Integration Services Connection Managers (5)
Integration Services	Integration Services Control Flow Transformations (14)
Integration Services	Integration Services Data Flow Transformations (19)
Integration Services	Integration Services Development (110)
Integration Services	Integration Services Email (3)
Integration Services	Integration Services Error Handling (8)
Integration Services	Integration Services Excel (14)
Integration Services	Integration Services Execute Package Options (8)
Integration Services	Integration Services Import and Export Wizard (2)
Integration Services	Integration Services NULL Management (4)
Integration Services	Integration Services Oracle (4)
Integration Services	Integration Services Performance (12)
Integration Services	Integration Services Security (7)
Integration Services	Integration Services Upgrade (4)
Power Platform	Power Apps (20)
Power Platform	Power BI (162)
Power Platform	Power BI Charts (56)
Power Platform	Power BI Formatting (17)
Professional Development	Professional Development Books (3)
Professional Development	Professional Development Branding (16)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (16)
Professional Development	Professional Development Career Transition (4)
Professional Development	Professional Development Certifications (57)
Professional Development	Professional Development Community (15)
Professional Development	Professional Development Conferences (2)
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 (18)
Professional Development	Professional Development Management (14)
Professional Development	Professional Development Recruiters (6)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Reporting Services	Reporting Services Administration (21)
Reporting Services	Reporting Services Analysis Services (4)
Reporting Services	Reporting Services Best Practices (6)
Reporting Services	Reporting Services Charts (25)
Reporting Services	Reporting Services Configuration (10)
Reporting Services	Reporting Services Custom Report (2)
Reporting Services	Reporting Services Dashboard (1)
Reporting Services	Reporting Services Data Sources (10)
Reporting Services	Reporting Services Development (38)
Reporting Services	Reporting Services Drill Through (4)
Reporting Services	Reporting Services Dynamic Reports (11)
Reporting Services	Reporting Services Filtering (3)
Reporting Services	Reporting Services Formatting (26)
Reporting Services	Reporting Services Functions (5)
Reporting Services	Reporting Services Images (2)
Reporting Services	Reporting Services Installation (9)
Reporting Services	Reporting Services KPI (5)
Reporting Services	Reporting Services Maps (4)
Reporting Services	Reporting Services Migration (5)
Reporting Services	Reporting Services Monitoring (5)
Reporting Services	Reporting Services Network Load Balancing (4)
Reporting Services	Reporting Services Overview (5)
Reporting Services	Reporting Services Parameters (15)
Reporting Services	Reporting Services Performance (6)
Reporting Services	Reporting Services Report Builder (9)
Reporting Services	Reporting Services Report Models (1)
Reporting Services	Reporting Services Security (8)
Reporting Services	Reporting Services SharePoint (1)
Reporting Services	Reporting Services Subreports (4)
Reporting Services	Reporting Services Tutorials (1)
Security	Auditing and Compliance (46)
Security	Encryption (35)
Security	Security (197)
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)
Tools	Azure Data Studio (17)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (94)
Tools	SQL Server Management Studio (78)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (9)
Tools	Tools (36)