In this 33rd article of SQL Server Always On Availability Group series, we will use extended events to monitor the availability group.
Read more »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)
- Monitor SQL Server Always On Availability groups using extended events - October 20, 2020
- Develop your extensions for Azure Data Studio - October 20, 2020
- Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups - October 14, 2020
Develop your extensions for Azure Data Studio
October 20, 2020Azure Data Studio (ADS) is a popular cross-platform (Windows, Linux) tool for database professionals. It provides various useful features such as T-SQL editor, Visualizations, insights, Peek definitions, Notebooks, Git integration, extensions and more. Extensions add new functionality in the ADS. Microsoft provides several useful extensions. We have already covered few useful extensions in the Azure Data Studio category on SQLShack.
Read more »
Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups
October 14, 2020In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances.
Read more »
Make the most of secondary replicas in SQL Server Always On Availability Groups
October 13, 2020In this 31st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads.
Read more »
Column-level SQL Server encryption with SQL Server Always On Availability Groups
October 12, 2020It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups.
Read more »
Install SQL Server Express on Windows Server 2016 using docker containers
October 9, 2020In this article, we will install the SQL Server Express edition on Windows Server 2016 using a SQL Server Docker container.
Read more »
SQL Server Always On Availability Groups for SQL Server Linux instances
October 6, 2020In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances.
Read more »![user database [LinuxAGSQL]](https://s33046.pcdn.co/wp-content/uploads/2020/10/user-database-linuxagsql-624x475.png)
Restore a SQL database from Windows SQL Server to SQL Server Linux instance
October 5, 2020Database professionals get the standard requirement for SQL database restores from production to non-production instances. As you know, SQL Server runs on the Linux and Windows operating systems starting from SQL Server 2016. Suppose you are exploring the SQL Server Linux instance features and configurations.
Read more »
Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups
September 29, 2020In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.
Read more »
Explore failover types in SQL Server Always On Availability Groups
September 29, 2020In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.
Read more »
Suppress successful login and backups messages from the error log for SQL databases
September 28, 2020In this article, we will explore the method to suppress successful login and backups messages in the error log for SQL databases.
Read more »
Explore branches in Git Source Control
September 28, 2020In this 5th article of the Source Control series, we will explore the concept of branches in a Git source control and GitHub repositories.
Read more »
Explore Manual Snapshots in AWS RDS SQL Server
September 23, 2020In this article, we explore the use of manual snapshots in AWS RDS SQL Server.
Read more »
Suspend and Resume Data Movement in SQL Server Always On Availability Groups
September 23, 2020In this 26th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.
Read more »
Configure SQL Server Reporting Services databases in SQL Server Always On Availability Groups
September 22, 2020This is the 25th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases.
Read more »
Refresh SQL Server Always On Availability Group databases using DBATools PowerShell
September 21, 2020In the 20th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. In this article, we will use the DBATools commands for this purpose.
Read more »
Impact of dropping a login in the active directory tied to SQL Server Always On Availability Groups
September 17, 2020This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23rd article in the SQL Server Always On Availability Group.
Read more »
Backup SQL databases on the AWS S3 bucket using Windows PowerShell
September 16, 2020In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket.
Read more »
Backup compression in TDE enabled databases in SQL Server Always On Availability Groups
September 16, 2020In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database.
Read more »
Exploring AG dashboards for monitoring SQL Server Always On Availability Groups
September 11, 2020In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes.
Read more »
Restore an existing availability group database participating in SQL Server Always On Availability Groups
September 8, 2020In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database.
Read more »
Deploy MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 7, 2020In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group.
Read more »
Explore Cross-database MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 4, 2020In the 18th part of the SQL Server Always On Availability Group series, we will discuss the cross-database MSDTC support in an availability group.
Read more »
Configuring SQL Server replication for distribution databases in SQL Server Always On Availability Groups
September 1, 2020In this 17h article of the SQL Server Always On Availability Group series, we are going to explore the SQL Server replication for the distribution database in the availability group.
Read more »
Configure SQL Server replication for a database in SQL Server Always On Availability Groups
August 31, 2020This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs.
Read more »