Rajendra Gupta

Author
Recent Posts

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 published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines.

I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups.

Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020.

Personal Blog: https://www.dbblogger.com
I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com

View all posts by Rajendra Gupta

Latest posts by Rajendra Gupta (see all)

Database level roles in Azure SQL Database - April 12, 2022
Fixed Server Roles in Azure SQL Database Server - April 6, 2022
SQL Server Dedicated Administrator Connections for Azure SQL Database - March 29, 2022

SQL data classification – Add sensitivity classification in SQL Server 2019

October 31, 2018 by Rajendra Gupta

SQL Server 2019 offers powerful new features to help in safeguarding your data and complying with various privacy regulations, which we’ll be covering in this article

SQL truncate enhancement: Silent Data truncation in SQL Server 2019

October 31, 2018 by Rajendra Gupta

In this article, we’ll take a look into SQL truncate improvement in SQL Server 2019.

Data inserts and updates are a normal and regular task for the developers and database administrators as well as from the application. The source of the data can be in multiple forms as if direct insert using T-SQL, stored procedures, functions, data import from flat files, SSIS packages etc.

Enhanced PolyBase SQL 2019 – External tables for Oracle DB

October 24, 2018 by Rajendra Gupta

In the previous article of the series, we took an overview of PolyBase in SQL Server 2017. We also learned about the Azure Data Studio and SQL Server 2019 preview extension to explore SQL Server 2019 features.

Enhanced PolyBase SQL 2019 – Installation and basic overview

October 24, 2018 by Rajendra Gupta

SQL Server 2019 is recently launched in the ignite 2018 event by Microsoft. We can get an overview of SQL 2019 preview version and learn how to install it on Windows environment by following up the article SQL Server 2019 overview and installation.

SQL Server 2019 – New DMF sys.dm_db_page_info

October 22, 2018 by Rajendra Gupta

Microsoft released preview of SQL Server 2019 recently in Ignite 2018. With every release of SQL Server is enriched with new dynamic management view and functions along with enhancements to existing features.

In this article, we will view the newly introduced dynamic management function (DMF) sys.dm_db_page_info and explore the different scenarios around it.

SQL Server 2019 overview and installation

October 15, 2018 by Rajendra Gupta

On September 24^th, 2018, Microsoft launched SQL Server 2019 preview version (SQL Server vNext 2.0) in the ignite 2018 event. As you know, SQL Server 2017 is still being adopted by the organizations, we are now ready with this preview version.

How to create a Word Cloud generator in Power BI Desktop

October 11, 2018 by Rajendra Gupta

In this article, we’ll look at how to create a Word cloud generator in Power BI Desktop, including importing data, customization and more.

In my last article, Power BI Desktop Interactive chord diagrams, we learned about customized visualizations in Power BI Desktop. These visualizations are free to install and we can use them with our data set and customize charts as per our requirements.

Power BI Desktop Pulse Charts

October 9, 2018 by Rajendra Gupta

In my last article, Power BI Desktop Interactive chord diagrams, we underscored that Microsoft Power BI desktop has a rich set of customized visualization features. These visualizations can help to produce convert data to information in an efficient manner to an easy to understand format. We can freely download them from Microsoft AppSource

Power BI Desktop Interactive chord diagrams

September 28, 2018 by Rajendra Gupta

Power BI desktop helps to create interactive reports and dashboards from a high and complex volume of the data. The Power BI desktop is an integrated tool where we can get the data from different sources.

SQL Server Data Import using Azure Data Studio

September 18, 2018 by Rajendra Gupta

Azure Data Studio is a new GUI based tool that works on Windows, Mac OS and Linux operating systems. It connects to SQL Server, Azure database, and SQL DW.

How to create and configure the Tree Map Chart in SQL Server 2016 Reporting Services

October 28, 2016 by Rajendra Gupta

In the previous article, in this series, How to create and configure a Sunburst chart in SQL Server 2016 Reporting Services, we have explored new chart types in SQL Server 2016; the Sunburst chart and the Tree Map chart, that are used to display hierarchical data. The Sunburst chart is a way of presenting relational datasets together in a compact form. The Tree Map Chart is also a way of showing hierarchical data.

In this article, we are going to show how to create a Tree Map chart and its comparison with the Sunburst chart.

How to create and configure a Sunburst chart in SQL Server 2016 Reporting Services

October 12, 2016 by Rajendra Gupta

Microsoft SQL Server 2016 introduces several significant new features, and enhances some existing ones in reporting services. We have summarised these new features in the previous article. We’ve also explored how to configure the SQL Server Mobile reports in my earlier article.

How to compare query execution plans in SQL Server 2016

September 15, 2016 by Rajendra Gupta

SQL Server 2016 provides great enhancement capability features for troubleshooting purposes. Some of the important features are:

How to create and configure SQL Server mobile reports

September 2, 2016 by Rajendra Gupta

Microsoft has recently launched SQL Server 2016 with lots of new features like row level security, always encrypted, stretch database, PolyBase, R Services, hybrid cloud capabilities, Dynamic Data Masking, query store, etc. There is a rich set of business intelligence, security features, and high availability solutions.

Peer to peer replication

February 18, 2016 by Rajendra Gupta

Nowadays many customers are spread globally and need to manage the requirement for users to connect from/to any location, perform an activity (insert, update, delete), and the databases should be kept synchronized across multiple sites.

Database snapshot in SQL Server

January 28, 2016 by Rajendra Gupta

Database snapshot is a great feature that offers virtual read only consistent database copy. When we create the database snapshot in the live operational database, it takes a database point in time static view and Rollback all uncommitted transactions in the snapshot database so we will not be having any inconsistent data that is yet to be committed. Database snapshot always exists on the Source database server.

Contained databases in SQL Server

January 12, 2016 by Rajendra Gupta

As we know there are two types of authentication available in SQL Server Windows authentication and SQL authentication. In Windows authentication we use Active directory authentication to connect with SQL Server which makes the most secure authentication method as it can have complexity, group policy configured at AD level applied to all domain servers while in SQL Authentication SQL users are created inside SQL and provided required permissions. The Permissions includes server wide and database wide. The logins can have certain permissions at the database level might be read or write etc.