In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.
Read more »
Installation, setup and configuration
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 »
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 »
An overview of distributed SQL Server Always On Availability Groups
August 21, 2020This is the 12th article in the series of SQL Server Always On Availability Groups.
Read more »
Getting started with the AWS SAM CLI
August 17, 2020In this article, we will learn the concept of the AWS SAM CLI. This is a part of the three-article series “Develop and Deploy Serverless Applications with AWS SAM CLI”. SAM, abbreviated for Serverless Application Model is a framework provided by Amazon Web Services, which can be leveraged to build applications on the local machine and deploy those to the AWS Lambdas directly.
Read more »
Configure a SQL Server Always On Availability Group on the domain-independent Failover Cluster
August 13, 2020This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.
Read more »
Database-level health detection in SQL Server Always On Availability Groups
July 30, 2020This is the 8th article in the series for SQL Server Always On Availability Groups.
Read more »
Add or remove a node from SQL Server Always On Availability Groups using T-SQL scripts
July 29, 2020This is the 7th article in the series of SQL Server Always on Availability Groups.
Read more »
Configure Managed Service Accounts for SQL Server Always On Availability Groups
July 24, 2020This article is a 6th article in the series for SQL Server Always On Availability Groups. It covers the configuration of the group managed service account (gMSA) for SQL Services.
Read more »
Add a new node into existing SQL Server Always On Availability Groups
July 23, 2020This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups.
Read more »
Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups
July 15, 2020In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations.
Read more »
Getting started with Visual Studio Code (VS Code)
July 8, 2020Visual Studio Code is a popular text editor or code editor to write queries and codes for developers. It is popularly known as VS code. It can highlight and format the code for quick development and understanding purposes.
Read more »
How to configure an iSCSI initiator on Windows Server 2016
July 7, 2020In this article, I am going to explain how we can configure the iSCSI initiator and use it to connect to the iSCSI virtual disk on the target server.
Read more »
Learn to avoid an identity jump issue (IDENTITY_CACHE) with the help of Trace Command (-T272)
July 1, 2020In this article, we will examine the Identity Cache feature and the identity jump issue. Sometimes we see that identity jumps by some specific or random value in the auto-incremental columns, which is known as the identity jump issue. Usually, it occurs when the SQL Server instance is being forced to restart. This skipped gap is particularly depending on the data type of the column, and most of the time, it is possible that column type can be INT, BIGINT, or Numeric.
Read more »
Installing and configuring a iSCSI Target Server on Windows Server 2016
June 30, 2020In this article, I am going to explain how we can install and configure the iSCSI Target Server Role on Windows Server 2016. iSCSI stands for Internet Small Computer System Interface and iSCSI Target Server allows you to boot multiple computers from a single operating system (OS) image.
Read more »
How to install MySQL database server 8.0.19 on Windows 10
March 19, 2020In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.
Read more »
How to install MySQL on Ubuntu
March 10, 2020In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.
Read more »
How to install SQL Server 2012 express edition
March 9, 2020In this article, I am going to explain how we can install SQL Server 2012 express edition using the SQL Server installation center. Additionally, I will also explain how we can use the SQL Server installation configuration file to perform an unattended (silent) installation. First, download the SQL Server express edition from this location. Once the installation file is downloaded, let us begin the installation process.
Read more »
How to configure SQL Server Log Shipping
March 5, 2020SQL Server Log shipping provides a DR (disaster recovery) solution for the SQL Server databases and it can be configured at the database level. In a specific time-gap, SQL Server Transaction Log backup will be taken and copied to the destination site and will be restored. This complete activity or solution will be done by SQL Server job and each step is configured by the user. The learner may confront the difficulties in a couple of steps or while troubleshooting but for the experienced user, it is too easy to set up and handle the SQL Server log shipping set up errors.
Read more »
Database Mail configuration in SQL Server Express edition
January 21, 2020In this article, I am going to explain step by step process to perform Database Mail configuration in SQL Server Express edition using the T-SQL script. As we know, SQL Server Express edition does not provide the SQL Server Agent Services; hence we cannot perform Database Mail configuration or SQL Jobs or maintenance plans using SQL Server Management Studio. To configure the Database Mail feature in the SQL Server Express edition, we must use CLR integration or using stored procedures within the MSDB database.
Read more »
Configuring SQL Server Express edition as SQL witness server in Database Mirroring
January 20, 2020In this article, I am going to explain how we can use the SQL Server Express edition for the SQL witness server of the database mirroring setup. Database mirroring is a cost-effective and easy to configure high availability solution. Unfortunately, this feature has been deprecated, but still, some organizations use database mirroring as a high availability solution.
Read more »
How to install SQL Server 2017 Express edition
January 20, 2020In this article, I am going to explain how to install the SQL Server Express edition. We will download the SQL Server 2017 Express edition and perform the custom installation. Before we dive-in into the installation and configuration process, let me introduce you to the SQL Server Express edition.
Read more »