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.

2023 Awards   MSSQLTips award

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 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
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 (24)
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 (77)
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 (44)
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 (171)
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 (88)
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 (341)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
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)










get free sql tips
agree to terms