Get Free Tips
MSSQLTips.com

Author: Rajendra Gupta

Home » Archives for Rajendra Gupta

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: Rajendra.gupta16@gmail.com for any consulting help.

  • MSSQLTips Awards:
  • Author of the Year - 2022 | Author Contender - 2021/2023/2024 | Champion Award (100+ tips) - 2020

TitleCategoryDate
SQL CASE Statement in WHERE Clause ExamplesTSQL2025-10-03
SSMS Copilot to Boost Productivity and EfficiencySQL Server Management Studio2025-09-23
Install SQL Server 2025 Standard Developer EditionSQL Server 20252025-07-31
SQL Server 2025 New FeaturesSQL Server 20252025-07-09
Alter Table Add Column SQL ServerTSQL2025-06-06
SQL RETURN and SQL OUTPUT clause in Stored ProceduresStored Procedures2025-05-28
SQL IS [NOT] DISTINCT FROM predicate in SQL Server 2022TSQL2025-05-22
Date Truncation with DATETRUNC() function in SQL ServerDates2025-04-10
Identify Anti-Patterns in SQL Server QueriesPerformance Tuning2025-03-18
SQL Server Management Studio (SSMS) 21 ChangesSQL Server Management Studio2025-02-26
SQL Coalesce Function Examples and Use CasesTSQL2025-02-05
Overview of Azure Options for SQL ServerAzure2025-01-16
Windows Failover Cluster Node QuarantinedClustering2025-01-12
SQL Declare Variable Code ExamplesTSQL2024-12-30
Python Numpy for Multi-Dimensional ArraysPython2024-12-12
Data Visualization with Python MatplotlibPython2024-11-25
Azure Database for MySQL Flexible Server Administrative TasksAzure2024-11-04
Explore Pandas in Python to Analyze and Manipulate Tabular DataPython2024-10-15
Implement Azure Database for MySQL Step-by-StepAzure2024-09-13
Azure Managed Instance Download and Restore SQL Server BackupAzure SQL Managed Instance2024-09-06
Microsoft Copilot for Azure SQL Database Management and DevelopmentArtificial Intelligence2024-08-30
Download AWS RDS SQL Server BackupAmazon AWS RDS2024-08-15
Get Azure SQL Managed Instance free for 12 monthsAzure SQL Managed Instance2024-08-09
Get Free Access to Azure SQL Database for a LifetimeAzure SQL Database2024-07-31
Polymorphism in Python Code Examples – Functions, Classes, InheritancePython2024-07-19
Python Classes for Code ReusabilityPython2024-06-24
Python Functions for Reducing Code ComplexityPython2024-06-12
SQL Server Management Studio 20 New Features and FunctionalitySQL Server Management Studio2024-05-27
Python Control Flow – if, if else, nested if, for loop and while loopPython2024-05-22
Python String Functions: Concatenate, Split, Replace, Upper, LowerPython2024-05-02
Python Variables and Data TypesPython2024-04-11
AI Tools to Generate SQL Queries with Code ReliabilityArtificial Intelligence2024-03-22
Python Programming Introduction – Install, Jupyter Notebooks, VS CodePython2024-02-28
Limit Data used by Amazon Athena QueriesAmazon AWS2023-11-29
Query Amazon CloudTrail Logs using Amazon AthenaAmazon AWS2023-11-07
AWS Athena Data Partitioning to Improve Performance and Reduce CostAmazon AWS2023-10-16
Create a Linked Server from SQL Server to AWS Athena TablesAmazon AWS2023-10-06
AWS Athena Configuration, Querying Data, Create Tables and ViewsAmazon AWS2023-09-26
Learn SQL Athena – How, Why and AdvantagesAmazon AWS2023-09-19
Append SQL Table with New Columns and Add New DataDatabase Design2023-08-08
Go-SqlCmd for Deploying and Using ContainersTools2023-07-26
go-sqlcmd tool for SQL Queries, Scripts and AutomationTools2023-07-06
SQL Round Function ExamplesTSQL2023-06-14
SQL SUBSTRING Code Examples and UsageTSQL2023-05-10
SQL Certifications Program from MicrosoftProfessional Development Certifications2023-04-06
SCHEMABINDING Views in SQL Server ExampleViews2023-03-30
CREATE VIEW SQL Server Examples with T-SQL and SSMSViews2023-03-07
Capture SQL Deadlocks using Amazon RDS for SQL ServerAmazon AWS RDS2022-12-01
AWS CLI to Deploy Amazon RDS SQL Server InstanceAmazon AWS RDS2022-11-23
AWS Command Line for Configuration and ManagementAmazon AWS2022-10-31
Configure and Deploy a new Amazon AWS RDS SQL Server instanceAmazon AWS RDS2022-09-21
AWS RDS SQL Server Fully Managed PlatformAmazon AWS RDS2022-09-12
Build Graph Node and Edge Tables using Azure Data StudioAzure Data Studio2022-09-02
Review SQL Execution Plan in Azure Data StudioAzure Data Studio2022-08-18
Install Azure Data Studio on RedHat, Ubuntu and SUSE LinuxAzure Data Studio2022-08-10
Azure Data Studio Download, Install and ConfigureAzure Data Studio2022-07-20
How to Restore a SQL Server 2022 Database using AWS S3 StorageSQL Server 20222022-07-05
How to Backup SQL Server 2022 database to AWS S3 StorageSQL Server 20222022-07-01
SQL Server 2022 Backup and Restore to AWS S3 storageSQL Server 20222022-06-30
Azure Data Studio to Manage SQL Server on Windows, Linux and the CloudAzure Data Studio2022-06-07
Export Data from Azure SQL Database to Azure with Change Data CaptureChange Data Capture2022-06-02
Azure Data Studio Query History and Table DesignerAzure Data Studio2022-05-18
Azure SQL Database Change Data Capture Configuration and Querying DataChange Data Capture2022-05-02
Configure Azure Cosmos DB Continuous BackupsAzure Cosmos DB2022-04-12
Azure Cosmos DB Price Differences for Provisioned or ServerlessAzure Cosmos DB2022-04-07
Azure Cosmos DB Backup Options, Retention and IntervalsAzure Cosmos DB2022-03-22
Azure Cosmos DB Data Consistency LevelsAzure Cosmos DB2022-03-03
Azure Cosmos DB Globally Distributed Databases to Replicate DataAzure Cosmos DB2022-02-22
How to Import Data from Azure SQL Database into Azure Cosmos DBAzure Cosmos DB2022-02-08
Azure Cosmos DB a NoSQL IntroductionAzure Cosmos DB2022-01-26
Full Text Search for Azure Cognitive Service and Azure SQL DatabaseAzure SQL Database2021-12-30
Azure Cognitive Search OverviewAzure2021-12-28
Move SQL Server System Databases on LinuxSQL Server on Linux2021-12-23
Build a Web Scraping Tool using Azure Data FactoryAzure Data Factory2021-11-24
Azure SQL Database Ledger Getting Started and ExamplesAzure SQL Database2021-06-09
Azure SQL Database Ledger Introduction for Data Tampering ProtectionAzure SQL Database2021-06-08
Query Audit data in Azure SQL Database using Kusto Query LanguageAzure SQL Database2021-03-16
Azure AD Authentication for Azure SQL DatabasesAzure SQL Database2021-03-01
CONCAT SQL Function in SQL ServerFunctions System2021-02-22
Server and Database Level Auditing for Azure SQL databasesAzure SQL Database2021-02-11
Azure Blob Storage Data Upload with SSISAzure2020-12-16
RecordSet Destination in SSISIntegration Services Development2020-12-01
Amazon RDS SQL Server Database Mail ConfigurationAmazon AWS2020-11-10
SSRS Data Driven SubscriptionReporting Services Administration2020-11-03
Install SQL Server 2017 on Oracle VM VirtualBox for Red Hat – Part 2SQL Server on Linux2019-02-01
How to install SQL Server on RHEL for Oracle VirtualBox – Part 1SQL Server on Linux2019-01-31
SQL Server Restore Interview QuestionsProfessional Development Interview Questions DBA2018-12-24
Resumable Online Index Create in SQL Server 2019SQL Server 20192018-12-21
SQL Server Backup Interview QuestionsProfessional Development Interview Questions DBA2018-12-14
Installing and Using mssql-cli on Linux for SQL ServerTools2018-11-27
SQL Server 2017 Step By Step Installation GuideSQL Server 20172018-11-07
Overview of SQL Server 2019 FeaturesSQL Server 20192018-10-30
Add SQL Server Agent Management to SQL Operations StudioSQL Operations Studio2018-10-01
Installing Extensions in SQL Operations StudioSQL Operations Studio2018-09-18
Adding User Comments to Reports in SSRSReporting Services Overview2018-09-07
SQL Server Management Studio 17.x Important FeaturesSQL Server Management Studio2018-08-20
SQL Server 2017 installation on Ubuntu using DockerSQL Server on Linux2018-08-02
Capture SQL Server Management Studio Queries and Telemetry DataSQL Server Management Studio2018-07-19
Pausing SQL Server Services to Stop New ConnectionsDatabase Administration2018-07-03
No More Service Packs for SQL ServerDatabase Administration2018-06-26
Creating custom insight widgets in SQL Operations StudioSQL Operations Studio2018-06-13
Customizing Dashboards in SQL Operations StudioSQL Operations Studio2018-05-10
Backup and Restore Database Tasks Using SQL Operations StudioSQL Operations Studio2018-04-24
Upgrading MSSQL-cli and new commandsTools2018-03-29
SQL Operations Studio – Query Editor and Source ControlSQL Operations Studio2018-03-20
New SQL Operations Studio Installation and OverviewSQL Operations Studio2018-03-02
New Interactive Command Line Tool MSSQL-cli for SQL ServerTools2018-02-14
SQL Server Security Vulnerability Assessment Tool in SSMS 17.4Security2018-02-02
SQL Server 2017 IDENTITY_CACHE featureIdentities2018-01-08
Installing SSRS 2017Reporting Services Installation2018-01-03
Overview of XEvent Profiler in SQL Server Management StudioExtended Events2017-12-20
New Features in SQL Server Management Studio v17SQL Server Management Studio2017-11-28
SQL Server Management Studio Import Wizard ImprovementsSQL Server Management Studio2017-11-15
SQL Server 2017 Automatic Query TuningSQL Server 20172017-10-24
SELECT…INTO Enhancements in SQL Server 2017TSQL2017-09-28
SQL Server 2017 Transaction Log Backup ImprovementsSQL Server 20172017-09-13
SQL Server 2017 Differential Backup ChangesSQL Server 20172017-09-05
SQL Server 2017 Graph Database Query ExamplesSQL Server 20172017-08-30
SQL Server 2017 Adaptive Memory Grant Feedback for Stored Procedure Performance ImprovementsSQL Server 20172017-08-21
SQL Server 2017 Adaptive Query Processing Query Plan Enhancements with Interleaved ExecutionSQL Server 20172017-08-10
SQL Server 2017 Resumable Online Index RebuildsSQL Server 20172017-08-04
Execute SSIS Package in Scale Out Mode – SQL Server 2017Integration Services Configuration Options2017-07-27
SQL Server Restore Database Error in SQL Server Management StudioSQL Server 20172017-06-26
SQL Server 2017 Graph Database ExampleSQL Server 20172017-06-13
SQL Server 2017 SSIS Scale Out ConfigurationIntegration Services Configuration Options2017-06-06
How to change default backup directory in SQL Server on LinuxSQL Server on Linux2017-05-25
SQL Server vNext (SQL Server 2017) SSIS Scale Out FeatureIntegration Services Configuration Options2017-05-11
How to change SQL Server Collation on LinuxSQL Server on Linux2017-04-28
Enable and disable SQL Server traceflags globally for Linux InstancesSQL Server on Linux2017-04-06
SQL Server Configuration Manager for LinuxSQL Server on Linux2017-03-30
How to change default port for SQL Server on LinuxSQL Server on Linux2017-03-06
How to Stop, Start, Enable and Disable SQL Server Services on LinuxSQL Server on Linux2017-02-27
DBCC CLONEDATABSE Enhancements in SQL Server 2016 SP1Performance Tuning2017-02-20
Migrate SQL Server Logins with PowerShellSecurity2017-01-31
New PowerShell cmdlets to read and write SQL Server tablesPowerShell2017-01-06
SQL Server 2016 PowerShell cmdlets for SQL AgentPowerShell2016-12-22
SQL Server 2016 Reporting Services Custom Branding ExampleReporting Services Configuration2016-12-08
PowerShell changes and new cmdlets for SQL Server 2016PowerShell2016-11-17
Drop table from a published SQL Server databaseReplication2016-11-01
SQL Server 2016 Management Studio Enhancements – Part 2SQL Server Management Studio2016-10-21
Profiler like templates for Extended Events Sessions in SQL ServerExtended Events2016-10-03
SQL Server DBCC CLONEDATABASE ExamplePerformance Tuning2016-09-19
SQL Server 2016 Sample Workload ToolsSQL Server 20162016-09-16
SQL Server 2016 Management Studio EnhancementsSQL Server Management Studio2016-08-29
SQL Server 2016 Telemetry Extended Event SessionExtended Events2016-08-19
Download and Install SQL Server Sample Databases WideWorldImportersSQL Server 20162016-08-02
SQL Server 2016 Trace Flags 1118 and 1117 for Page AllocationsSQL Server 20162016-07-14
Understanding database recovery with SQL Server 2016 Extended EventsExtended Events2016-07-05
SQL Server 2016 Auditing ImprovementsSQL Server 20162016-06-24
SQL Server 2016 Parameter Sniffing as a Database Scoped ConfigurationSQL Server 20162016-05-31
Capture Detailed SQL Server Restore Steps with Extended EventsExtended Events2016-05-17
SQL Server Database Scoped Configuration SettingsSQL Server 20162016-05-04
SQL Server 2016 Extended Events Detailed Backup InformationSQL Server 20162016-04-21
SQL Server 2016 Database Scoped Configuration OptionsSQL Server 20162016-04-13
SQL Server 2016 RC0 Installation and Configuration ChangesSQL Server 20162016-04-07
SQL Azure Geo Replication Configuration and TestingAzure2016-03-25
Configure and Customize SQL Azure Dynamic Data MaskingAzure2016-03-17
SQL Server Compress and Decompress FunctionsCompression2016-02-11
SQL Server 2016 Row Level Security Block and Filter Predicates ExampleSQL Server 20162016-01-26
Manage Extended Events for SQL Server 2016 Analysis Services in Management StudioExtended Events2016-01-13
SQL Server Transactional Replication Static Row and Column FiltersReplication2015-12-02
SQL Server 2016 Database Maintenance Plan ImprovementsSQL Server 20162015-11-18
Consistency Checks for SSASSQL Server 20162015-11-09
In Memory OLTP Changes in SQL Server 2016SQL Server 20162015-11-05
SQL Server replication between different schemasReplication2015-10-27
Including NULL Values in JSON Output in SQL Server 2016SQL Server 20162015-10-08
SQL Server 2016 Row Level Security ExampleSQL Server 20162015-09-18
SQL Server 2016 Installation ChangesSQL Server 20162015-07-22
SQL Server Database Mirroring ReportDatabase Mirroring2015-07-13
SQL Server Database Mirroring Automatic Page RepairDatabase Mirroring2015-07-03
Install SQL Server 2012 Using SysPrepInstall and Uninstall2012-12-03
Indirect Checkpoints in SQL Server 2012Recovery Models2012-06-21
Percent_Rank and Cume_Dist functions in SQL Server 2012Functions System2012-06-12
SQL Server 2012 Analytical Functions – Percentile_Cont and Percentile_DiscFunctions System2012-06-01
Attach Sample Database – Adventureworks in SQL Server 2012Testing2012-05-14
SQL Server Lead and Lag FunctionsFunctions System2012-04-16
Columnstore index feature in SQL Server 2012Indexing2012-04-02
SQL Server 2012 Functions – First_Value and Last_ValueFunctions System2012-03-12
Database recovery model change notification report for SQL ServerRecovery Models2011-10-21
SQL Agent Error the CmdExec subsystem failed to loadSQL Server Agent2011-10-07

Categories

Recent Articles

  • AWS Machine Learning Engineer Certification (MLA-C01)

  • Extract Text using Regular Expressions with SQL Server 2025 Function REGEXP_INSTR

  • SQL Server CROSS APPLY and OUTER APPLY Helpful Examples

  • AWS Certified AI Practitioner Certification (AIF-C01) Exam Guide

  • Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide