This article explores Row Sampling Transformations in SSIS and Percentage Sampling Transformations in SSIS packages
Read more »Rajendra Gupta
Rajendra Gupta
Rajendra has 8+ years of experience in database administration having a passion for database performance optimization, monitoring, and high availability and disaster recovery technologies, learning new things, new features.
While working as a Senior consultant DBA for big customers and having certified with MCSA SQL 2012, he likes to share knowledge on various blogs.
He can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
While working as a Senior consultant DBA for big customers and having certified with MCSA SQL 2012, he likes to share knowledge on various blogs.
He can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Row Sampling Transformations and Percentage Sampling Transformations in SSIS packages - September 11, 2019
- Character Map Transformations in SSIS packages - September 11, 2019
- Overview of SQL LOWER and SQL UPPER functions - September 10, 2019
Character Map Transformations in SSIS packages
September 11, 2019This article explores the Character Map Transformation in SSIS package with available configurations.
Read more »
Overview of SQL LOWER and SQL UPPER functions
September 10, 2019This article gives an overview of SQL UPPER function and SQL LOWER function to convert the character case as uppercase and lowercase respectively.
Read more »
Upgrading to a new SQL Server edition
September 9, 2019This article gives an overview of different editions in SQL Server and also explains the process to upgrade SQL Server editions.
Read more »
Overview of the SQL DELETE Column from an existing table operation
September 6, 2019In this article, we will explore the process of SQL Delete column from an existing table. We will also understand the impact of removing a column with defined constraints and objects on it.
Read more »
Using a CHECKPOINT in SSIS packages to restart package execution
September 5, 2019In the article, SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server, we talked about the CHECKPOINT process for SQL Server databases. This article is about CHECKPOINT in SSIS package.
Read more »
An overview of Error Handling in SSIS packages
September 5, 2019This article explains the process of configuring Error handling in SSIS package.
Read more »
Term Extraction Transformation in SSIS
September 2, 2019This article explores the Term extraction transformation in SSIS and its usage scenario.
Read more »
Different ways to SQL delete duplicate rows from a SQL Table
August 30, 2019This article explains the process of performing SQL delete activity for duplicate rows from a SQL table.
Read more »
An Overview of the LOOKUP TRANSFORMATION in SSIS
August 29, 2019We will explore Lookup Transformation in SSIS in this article for incremental data loading in SQL Server.
Read more »
SET NOCOUNT ON statement usage and performance benefits in SQL Server
August 26, 2019Have you ever noticed SET NOCOUNT ON statement in T-SQL statements or stored procedures in SQL Server? I have seen developers not using this set statement due to not knowing it.
Read more »
Overview of SSIS Package Logging
August 23, 2019This article gives an overview of the different methods of SQL Server SSIS Package Logging.
Read more »
SSIS Multicast Transformation overview
August 22, 2019This article explores the SSIS Multicast Transformation for creating different logical copies of source data.
Read more »
SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server
August 22, 2019Database administrators should be aware of the internal SQL Server processes such as the dirty pages, SQL Server CHECKPOINT, Lazy writer process. This is a very common question that you might come across in SQL DBA technical interviews as well on all levels such as beginner, intermediate and expert level.
Read more »
KILL SPID command in SQL Server
August 21, 2019This article gives an overview of the KILL SPID command and how to monitor the rollback progress.
Read more »
SSIS Conditional Split Transformation overview
August 16, 2019This article explores the SSIS Conditional Split Transform task to split data into multiple destinations based on the specified conditions.
Read more »
Overview of the Shrink TempDB database in SQL Server
August 15, 2019This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server
Read more »
Calculate SQL Percentile using the PERCENT_RANK function in SQL Server
August 15, 2019This article explores the SQL Server PERCENT_RANK analytical function to calculate SQL Percentile and its usage with various examples.
Read more »
SQL Server Statistics and how to perform Update Statistics in SQL
August 13, 2019This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.
Read more »
Monitoring SQL Server deadlocks using the system_health extended event
August 12, 2019Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases. Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, waits, and SQL Server deadlocks. You might face frequent deadlocks issues, and they have a direct impact on the application performance.
Read more »
Windows Failover Cluster Quorum Modes in SQL Server Always On Availability Groups
August 8, 2019This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups.
Read more »
SQL STUFF function overview
July 31, 2019This article gives an overview of the SQL STUFF function with various examples.
Read more »
FOR XML PATH clause in SQL Server
July 30, 2019As SQL professionals, we often have to deal with XML data in our databases. This article will help you walk through several examples of using ‘FOR XML PATH’ clause in SQL Server.
Read more »
Max Worker Threads for SQL Server Always on Availability Group databases
July 26, 2019This article gives an overview of the Max Worker Threads for the SQL Server Always On Availability Group databases.
Read more »
Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server
July 26, 2019I have seen that SQL developers use varchar(max) data while designing the tables or temporary tables. We might not be sure about the data length, or we want to eliminate the string or binary truncation error.
Read more »