Rajendra Gupta

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.

linkedin  twitter 

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   MSSQLTips award

2017 Awards   MSSQLTips award   MSSQLTips award

2016 Awards   MSSQLTips award   MSSQLTips award

2015 Awards   MSSQLTips award

Category Tip Title
Amazon AWS AWS CLI Syntax and Examples to Create Amazon RDS SQL Server Instance
Amazon AWS AWS Command Line Interface Utility for Configuration and Management
Amazon AWS Configure SQL Server Database Mail on Amazon RDS
Amazon AWS Introduction to AWS RDS SQL Server Features
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 Steps to Quickly Configure an AWS RDS SQL Server instance
Amazon AWS RDS Monitor SQL Deadlocks in Amazon RDS for SQL Server
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 Installing and Using mssql-cli on Linux 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 SUBSTRING Function Code Examples
Views Benefits and Limitations of SCHEMABINDING Views in SQL Server
Views CREATE VIEW SQL Server Tutorial
No Records Found
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 (25)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (51)
Cloud Apache Spark (9)
Cloud Azure (147)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (14)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (26)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (2)
Cloud Azure Synapse Analytics (39)
Cloud Cloud Strategy (20)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Amazon AWS RDS (1)
Database Administration Availability Groups (79)
Database Administration Backup (78)
Database Administration Central Management Servers (10)
Database Administration Clustering (74)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (199)
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 (27)
Database Administration Google Cloud (5)
Database Administration Hardware (14)
Database Administration High Availability (3)
Database Administration Indexing (87)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (41)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (117)
Database Administration Other Database Platforms (85)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (124)
Database Administration Policy Based Management (29)
Database Administration PowerShell (130)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (4)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (1)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (22)
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 (54)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (41)
Database Development Artificial Intelligence (1)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (3)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (2)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (77)
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 (72)
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 (41)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (73)
Database Development Query Optimization (14)
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 (10)
Database Development Temporal Tables (13)
Database Development Testing (31)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (366)
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 (148)
Power Platform Power BI Charts (51)
Power Platform Power BI Formatting (16)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (14)
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 (50)
Professional Development Professional Development Community (16)
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 (11)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (20)
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 (196)
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 (93)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (33)










get free sql tips
agree to terms