Introduction
Power BI is enriched with many useful visualizations and helps to represent data in various forms. We have explored many use cases of PowerBI in SQLShack articles.
Read more »
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 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
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)
- How to install PostgreSQL on Ubuntu - July 13, 2023
- How to use the CROSSTAB function in PostgreSQL - February 17, 2023
- Learn the PostgreSQL COALESCE command - January 19, 2023
Estimating AWS RDS SQL Server costs
January 23, 2020This article explores estimating the AWS RDS SQL Server cost so that you can plan resources accordingly.
Read more »
Auditing in AWS RDS SQL Server
January 20, 2020This article explores the server and database audit in AWS RDS SQL Server.
Read more »
Import JSON data into SQL Server
January 17, 2020This article explores the process of JSON data import in the SQL Server table using T-SQL and SSIS.
Read more »
Access PostgreSQL databases using the Azure Data Studio extension
January 16, 2020This article installs PostgreSQL on Ubuntu 16.4 operating system and connects the database using Azure Data Studio.
Read more »
Overview of Non-Clustered indexes in SQL Server
January 16, 2020This article gives an introduction of the non-clustered index in SQL Server using examples.
Read more »
An overview of the column level SQL Server encryption
January 14, 2020This article gives an overview of column level SQL Server encryption using examples.
Read more »
Generate data scripts using SSMS and Azure Data Studio
January 13, 2020This article explores different ways to generate data scripts using Azure Data Studio and SQL Server Management Studio.
Read more »
SQL Server Linux installation for Amazon EC2 instance with Red Hat OS
January 9, 2020This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.
Read more »
Encrypting passwords with Python Scripts in SQL Notebooks of Azure Data Studio
January 6, 2020This article explores the Python scripts for encrypting and decrypting passwords in SQL Server using Azure Data Studio SQL Notebooks.
Read more »
Use Python SQL scripts in SQL Notebooks of Azure Data Studio
December 25, 2019This article explores the Python SQL scripts in SQL Notebook of Azure Data Studio.
Read more »
Overview of SQL Server Clustered indexes
December 23, 2019This article targets the beginners and gives an introduction of the clustered index in SQL Server.
Read more »
Database Administration Tool Extension for Windows in Azure Data Studio
December 17, 2019Azure Data Studio provides a modern and productive experience for managing on-premise and cloud-based SQL Server instances. Previously, we discussed many useful features of it, and you can explore these articles in Azure Data Studio category.
Read more »
Installation of SQL Server Linux on Red Hat in Amazon EC2 instances
December 17, 2019This article explores the configuration of the Red hat Amazon EC2 instance for SQL Server installation.
Read more »
Import data from multiple Excel files into SQL Server tables using an SSIS package
December 13, 2019This article explores an SSIS package for importing multiple Excel files data into SQL Server tables.
Read more »
An overview of native differential backups in AWS RDS SQL Server
December 9, 2019This article explores the differential backups in AWS RDS SQL Server using recovery scenarios.
Read more »
An overview of SQL Server data types
December 9, 2019In this article, we will give an overview of various SQL Server data types.
Read more »
Sequence Containers in SSIS packages
December 6, 2019This article explores the Sequence container in SSIS package with examples.
Read more »
An overview of the SQL Server Update Join
December 5, 2019This article explores the SQL Server Update Join statement in T-SQL for SQL Server.
Read more »
Forwarded Records Performance issue in SQL Server
December 5, 2019This article discusses the Forwarded Records and its performance issues for heap tables in SQL Server.
Read more »
SQL Server Schema Compare extension in Azure Data Studio
December 5, 2019This article explores the SQL Server Schema Compare extension in the Azure Data Studio.
Read more »
Overview of SSIS Precedence Constraints
December 3, 2019This article explores the SSIS Precedence Constraints, along with examples and scenarios.
Read more »
An overview of SSIS Pivot and SSIS Unpivot Transformations
November 28, 2019This article explores an SSIS Pivot transformation and SSIS Unpivot transformation for creating Pivot and Unpivot data tables.
Read more »
SQL Table Variable Deferred Compilation in SQL Server 2019
November 25, 2019In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Let’s have a quick recap of the table variable:
Read more »
Overview of SQL Server 2019 General Availability and installation
November 19, 2019Introduction
On November 4th, 2019, during the Ignite conference at Orlando, Microsoft released the General Availability of its flagship product Microsoft SQL Server 2019. SQL 2019 provides various enhancements to its core database engine and offers integration with Big data (Apache Spark, Data Lake), Machine learning, Linux/container compatibility with Kubernetes.
Read more »