This article explores the partial backup SQL Database strategy in SQL Server and its usages for read-only filegroups.
Read more »
Rajendra Gupta
As an MCSA certified and Microsoft Certified Trainer in Gurgaon, India, with 13 years of experience, Rajendra works for a variety of large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation. He is the author of hundreds of authoritative articles on SQL Server, Azure, MySQL, Linux, Power BI, Performance tuning, AWS/Amazon RDS, Git, and related technologies that have been viewed by over 10m readers to date.
He is 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 his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
He is 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 his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server - September 16, 2021
- Azure Alerts for creating, modifying and deleting Azure SQL Databases - September 13, 2021
- Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold - September 10, 2021
Data Import from Amazon S3 SSIS bucket using an integration service (SSIS) package
October 28, 2019This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.
Read more »
Methods to avoid the SQL divide by zero error
October 21, 2019This article explores the SQL divide by zero error and various methods for eliminating this.
Read more »
SET QUOTED_IDENTIFIER settings in SQL Server
October 17, 2019In this article, we will explore QUOTED_IDENTIFIER behavior, default value, and comparison with a different value. Set options at connection level control query behavior in SQL Server. The query might behave differently with different set options and their values.
Read more »
An overview of the SQL table variable
October 16, 2019This article explores the SQL Table variables and their usage using different examples.
Read more »
SQL Lag function overview and examples
October 15, 2019In the article SQL Server Lead function overview and examples, we explored Lead function for performing computational operations on data. This article gives an overview of the SQL Lag function and its comparison with the SQL Lead function.
Read more »
Multi-AZ Configuration for AWS RDS SQL Server
October 10, 2019Amazon provides AWS RDS SQL Server as a managed relational database service. You can deploy databases instantly without worrying about underlying hardware platform, license cost, managing data centers. AWS RDS database instances are highly available. It provides a failover mechanism using the Mult-AZ deployments.
Read more »
A Walkthrough of SQL Schema
October 9, 2019This article gives an overview of SQL Schema and its usage in SQL Server.
Read more »
Overview of SQL Server Aliases
October 7, 2019This article gives an overview of SQL Server Alias and its usage for connecting with SQL Server.
Read more »
Enforce SSL connections in AWS RDS SQL Server
October 7, 2019This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.
Read more »
Pseudo-Simple SQL Server Recovery Model
October 7, 2019This article gives an overview of the Pseudo Simple SQL Server Recovery Model. It also explores the conditions in which the database behaves in Pseudo mode.
Read more »
Encrypted Backup and Restore in AWS RDS SQL Server
October 4, 2019In the article, Recover Data in AWS RDS SQL Server, we explored the process of native backup and restoration for the AWS RDS SQL Server database. It involves the following steps:
Read more »
Piecemeal Database Restores in SQL Server
October 3, 2019This article explores the piecemeal database restore SQL Server feature and its benefits to minimize the database restoration.
Read more »
SQL Server PRINT and SQL Server RAISERROR statements
October 2, 2019This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.
Read more »
Recover Data in AWS RDS SQL Server
September 27, 2019This article explores the process to recover data in AWS RDS SQL Server and its recent enhancements.
Read more »
An Overview of Instant File Initialization in SQL Server
September 25, 2019This article gives an overview of Instant File Initialization and its benefits for SQL Server database creation, restoration and file growth.
Read more »
T-SQL RegEx commands in SQL Server
September 17, 2019This article explores T-SQL RegEx commands in SQL Server for performing data search using various conditions.
Read more »
Row Sampling Transformations and Percentage Sampling Transformations in SSIS packages
September 11, 2019This article explores Row Sampling Transformations in SSIS and Percentage Sampling Transformations in SSIS packages
Read more »
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 »