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.

2021 Awards   

2020 Awards   

2018 Awards      

2017 Awards      

2016 Awards      

2015 Awards   

Amazon AWSConfigure SQL Server Database Mail on Amazon RDS
Amazon AWSIntroduction to AWS RDS SQL Server Features
Amazon AWSSteps to Quickly Configure an AWS RDS SQL Server instance
AzureAn Overview of Azure Cognitive Search Service
AzureAzure AD Authentication for Azure SQL Databases
AzureAzure Blob Storage Data Upload with SSIS
AzureAzure SQL Database Ledger Getting Started and Examples
AzureConfigure and Customize SQL Azure Dynamic Data Masking
AzureCreate Index for Full Text Search using Azure Cognitive Service and Azure SQL Database
AzureIntroduction to Azure SQL Database Ledger for Data Tampering Protection
AzureQuery Audit data in Azure SQL Database using Kusto Query Language (KQL)
AzureServer and Database Level Auditing for Azure SQL databases
AzureSQL Azure Geo Replication Configuration and Testing
Azure Cosmos DBAzure Cosmos DB Consistency Levels - Strong, Bounded Staleness, Session, Consistent Prefix and Eventual
Azure Cosmos DBAzure Cosmos DB Continuous Backups Step By Step
Azure Cosmos DBAzure Cosmos DB Periodic Backup
Azure Cosmos DBIntroduction to Azure Cosmos DB a NoSQL Database for Documents and JSON
Azure Cosmos DBLearn about Azure Cosmos DB Globally Distributed Databases
Azure Cosmos DBMigrating SQL Data into Azure Cosmos DB
Azure Cosmos DBPrice Differences for Azure Cosmos DB Provisioned or Serverless Throughput Cost
Azure Data FactoryAzure Data Factory for Web Scraping
Azure Data StudioAzure Data Studio (ADS) - Download, Installation and Configuration
Azure Data StudioAzure Data Studio Introduction
Azure Data StudioGetting Started with Query History and Table Designer in Azure Data Studio
Azure Data StudioGuide to Build Graph Node and Edge Tables with Azure Data Studio
Azure Data StudioInstall Azure Data Studio on Linux systems
Azure Data StudioQuery Plan Viewer in Azure Data Studio
Change Data CaptureConfigure and Query Change Data Capture (CDC) data for Azure SQL Database
Change Data CaptureHow to export incremental data from Azure SQL Database to Azure using Change Data Capture (CDC)
ClusteringWhat's the Quarantine state in Windows Failover Clusters
CompressionSQL Server Compress and Decompress Functions
Database AdministrationNo More Service Packs for SQL Server
Database AdministrationPausing SQL Server Services to Stop New Connections
Database MirroringSQL Server Database Mirroring Automatic Page Repair
Database MirroringSQL Server Database Mirroring Report
Extended EventsCapture Detailed SQL Server Restore Steps with Extended Events
Extended EventsManage Extended Events for SQL Server 2016 Analysis Services in Management Studio
Extended EventsOverview of XEvent Profiler in SQL Server Management Studio
Extended EventsProfiler equivalent templates for Extended Events Sessions in SQL Server 2016
Extended EventsSQL Server 2016 Telemetry Extended Event Session
Extended EventsUnderstanding database recovery with SQL Server 2016 Extended Events
Functions SystemCONCAT and CONCAT_WS function in SQL Server
Functions SystemPercent_Rank and Cume_Dist functions in SQL Server 2012
Functions SystemSQL Server 2012 Analytical Functions - Percentile_Cont and Percentile_Disc
Functions SystemSQL Server 2012 Functions - First_Value and Last_Value
Functions SystemSQL Server Lead and Lag Functions
IdentitiesSQL Server 2017 IDENTITY_CACHE feature
IndexingColumnstore index feature in SQL Server 2012
Install and UninstallInstall SQL Server 2012 Using SysPrep
Integration Services Configuration OptionsExecute SSIS Package in Scale Out Mode - SQL Server 2017
Integration Services Configuration OptionsSQL Server 2017 SSIS Scale Out Configuration
Integration Services Configuration OptionsSQL Server vNext (SQL Server 2017) SSIS Scale Out Feature
Integration Services DevelopmentExplore RecordSet Destination in SSIS Package
Performance TuningDBCC CLONEDATABSE Enhancements in SQL Server 2016 SP1
Performance TuningSQL Server DBCC CLONEDATABASE Example
PowerShellNew PowerShell cmdlets to read and write SQL Server tables
PowerShellPowerShell changes and new cmdlets for SQL Server 2016
PowerShellSQL Server 2016 PowerShell cmdlets for SQL Agent
Professional Development Interview Questions DBASQL Server Backup Interview Questions
Professional Development Interview Questions DBASQL Server Restore Interview Questions
Recovery ModelsDatabase recovery model change notification report for SQL Server
Recovery ModelsIndirect Checkpoints in SQL Server 2012
ReplicationDrop table from a published SQL Server database
ReplicationSQL Server replication between different schemas
ReplicationSQL Server Transactional Replication Static Row and Column Filters
Reporting Services AdministrationReporting Services Subscriptions in SQL Server 2019
Reporting Services ConfigurationSQL Server 2016 Reporting Services Custom Branding Example
Reporting Services InstallationInstalling SQL Server Reporting Services 2017
Reporting Services OverviewAdding User Comments to Reports in SQL Server Reporting Services
SecurityMigrate SQL Server Logins with PowerShell
SecuritySQL Server Security Vulnerability Assessment Tool in SSMS 17.4
SQL Operations StudioAdd SQL Server Agent Management to SQL Operations Studio
SQL Operations StudioBackup and Restore Database Tasks Using SQL Operations Studio
SQL Operations StudioCreating custom insight widgets in SQL Operations Studio
SQL Operations StudioCustomizing Dashboards in SQL Operations Studio
SQL Operations StudioInstalling Extensions in SQL Operations Studio
SQL Operations StudioNew SQL Operations Studio Installation and Overview
SQL Operations StudioSQL Operations Studio - Query Editor and Source Control
SQL Server 2016Consistency Checks for SQL Server Analysis Services
SQL Server 2016Download and Install SQL Server 2016 Sample Databases WideWorldImporters and WideWorldImportersDW
SQL Server 2016In Memory OLTP Changes in SQL Server 2016
SQL Server 2016Including NULL Values in JSON Output in SQL Server 2016
SQL Server 2016SQL Server 2016 Auditing Improvements
SQL Server 2016SQL Server 2016 Database Maintenance Plan Improvements
SQL Server 2016SQL Server 2016 Database Scoped Configuration Options
SQL Server 2016SQL Server 2016 Database Scoped Configurations for MAXDOP, Procedure Cache and Cross Database Queries
SQL Server 2016SQL Server 2016 Extended Events Detailed Backup Information
SQL Server 2016SQL Server 2016 Installation Changes
SQL Server 2016SQL Server 2016 Parameter Sniffing as a Database Scoped Configuration
SQL Server 2016SQL Server 2016 RC0 Installation and Configuration Changes
SQL Server 2016SQL Server 2016 Row Level Security Block and Filter Predicates Example
SQL Server 2016SQL Server 2016 Row Level Security Example
SQL Server 2016SQL Server 2016 Sample Workload Tools
SQL Server 2016SQL Server 2016 Trace Flags 1118 and 1117 for Page Allocations
SQL Server 2017SQL Server 2017 Adaptive Memory Grant Feedback for Stored Procedure Performance Improvements
SQL Server 2017SQL Server 2017 Adaptive Query Processing Query Plan Enhancements with Interleaved Execution
SQL Server 2017SQL Server 2017 Automatic Query Tuning
SQL Server 2017SQL Server 2017 Differential Backup Changes
SQL Server 2017SQL Server 2017 Graph Database Example
SQL Server 2017SQL Server 2017 Graph Database Query Examples
SQL Server 2017SQL Server 2017 Restore Database Error in SSMS
SQL Server 2017SQL Server 2017 Resumable Online Index Rebuilds
SQL Server 2017SQL Server 2017 Step By Step Installation Guide
SQL Server 2017SQL Server 2017 Transaction Log Backup Improvements
SQL Server 2019Overview of SQL Server 2019 Features
SQL Server 2019Resumable Online Index Create in SQL Server 2019
SQL Server 2022SQL Server 2022 Restore a database from AWS S3 bucket - Part 3
SQL Server 2022SQL Server 2022: Backup and Restore database to AWS S3 bucket - Part 1
SQL Server 2022SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2
SQL Server AgentSQL Agent Error the CmdExec subsystem failed to load
SQL Server Management StudioNew Features in SQL Server Management Studio v17
SQL Server Management StudioSQL Server 2016 Management Studio Enhancements
SQL Server Management StudioSQL Server 2016 Management Studio Enhancements - Part 2
SQL Server Management StudioSQL Server Management Studio 17.x Important Features
SQL Server Management StudioSQL Server Management Studio Import Wizard Improvements
SQL Server Management StudioSQL Server Management Studio Output Option for Object Explorer Queries and Telemetry Data
SQL Server on LinuxHow to change default backup directory in SQL Server on Linux
SQL Server on LinuxHow to change default port for SQL Server on Linux
SQL Server on LinuxHow to change SQL Server Collation on Linux
SQL Server on LinuxHow to enable and disable SQL Server traceflags globally for Linux Instances
SQL Server on LinuxHow to install SQL Server on RHEL for Oracle VirtualBox - Part 1
SQL Server on LinuxHow to Move SQL Server System Databases to a different directory on Linux
SQL Server on LinuxHow to Stop, Start, Enable and Disable SQL Server Services on Linux
SQL Server on LinuxInstallation of SQL Server 2017 on Oracle VM VirtualBox for Red Hat - Part 2
SQL Server on LinuxSQL Server 2017 installation on Ubuntu using Docker
SQL Server on LinuxSQL Server Configuration Manager for Linux
Stored ProceduresSQL Server RETURN and OUTPUT Clause in Stored Procedures
TestingAttach Sample Database - Adventureworks in SQL Server 2012
ToolsInstalling and Using mssql-cli on Linux for SQL Server
ToolsNew Interactive Command Line Tool MSSQL-cli for SQL Server
ToolsUpgrading MSSQL-cli and new commands
TSQLSELECT...INTO Enhancements in SQL Server 2017
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (25)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (47)
CloudApache Spark (3)
CloudAzure (188)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (36)
CloudCloud Strategy (12)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (75)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (22)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (190)
Database AdministrationDatabase Configurations (18)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (11)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (73)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (123)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (129)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (10)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (13)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (70)
Database DevelopmentDates (49)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (69)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (77)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (40)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (48)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (28)
Database DevelopmentSynonyms (5)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (320)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (12)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (132)
Power PlatformPower BI Charts (45)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (23)
Professional DevelopmentProfessional Development Interview Questions Developer (9)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (32)
SecuritySecurity (196)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (16)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (93)
ToolsSQL Server Management Studio (77)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (33)