This is the 9th article in the series of SQL Server Always On Availability Groups.
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)
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 »
Visual Studio Code (VS Code) integration with Git Source Control
July 22, 2020This article explores Visual Studio Code integration with Git Source Control.
Read more »
Visual Studio Code (VS Code) for SQL Server development
July 16, 2020In the previous article, Getting started with Visual Studio Code (VS Code), we took a detailed overview of the popular code editor. It supports various programming languages t-SQL, Python, PHP, AWS CLI, PowerShell, etc. We need to use extensions in the VS code to work with these languages. For example, if we open the T-SQL script, it recommends you for the below extension.
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 »
Launch a static website using AWS S3 buckets
July 15, 2020This article explores the AWS S3 bucket to configure a static website.
Read more »
Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups
July 14, 2020This article explores the configuration of Windows failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups.
Read more »
Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups
July 13, 2020In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In the article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016, we configured three virtual machines with their networking configurations.
Read more »
A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016
July 13, 2020In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration.
Read more »
Working with Git components in Azure Data Studio
July 9, 2020This article gives an insight into the terms in the Git repository of Azure Data Studio. In the previous articles, we learned the following things:
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 »
Integrating Azure Data Studio with Git and GitHub
July 3, 2020In the last article, Source Control using Git in Azure Data Studio (ADS), we explored the following topics:
- The requirement of Source control for SQL scripts
- Git installation on Windows
- Integrate Git in Azure Data Studio
- Create Git repository, add SQL scripts, modify files, commit into source control
- View different versions using the Git timelines
In this article, we will take a step forward and integrate Git installed locally on the GitHub.
Read more »
Explore the SQL query Hint OPTION (FAST N)
July 2, 2020In this article, we will introduce SQL queries hint and will analyze the OPTION(Fast ‘N’) hint in detail.
Read more »
Explore SQL Server Index Properties in SSMS
July 2, 2020This article gives you an insight into SQL Server Index properties in SSMS.
Read more »
Source Control using Git in Azure Data Studio (ADS)
July 2, 2020Azure Data Studio is a tool for both developers and database administrators with exciting features. You can install ADS on both Windows and Linux platforms. You can go through various Azure Data Studio articles on SQLShack to be comfortable with the tool and its features.
Read more »
The SQL Server Assessment Extension for Azure Data Studio
June 30, 2020Azure Data Studio extensions enable adding new functionality for development and administrative tasks. It is an open-source functionality and allows Microsoft as well as third party extensions using Marketplace. We explored a few useful extensions in the Azure Data Studio category of articles.
Read more »
Different ways to search for objects in SQL databases
June 29, 2020This article explores various ways to search for database objects in SQL database such as tables, stored procedures, functions, and views.
Read more »
AWS Launch Wizard for quick SQL Server Always On deployments
June 29, 2020SQL Server Always On is a high-availability and disaster recovery solution. We can use multiple secondary replicas for configuring database backups, redirect read requests to offload primary instance load.
Read more »
An overview of Logon triggers in SQL Server
June 19, 2020This article gives you an overview of Logon triggers in SQL Server and its usage to control SQL Server authentication.
Read more »
Deploying an AWS RDS SQL Server using the AWS CLI
June 19, 2020This article deploys a new AWS RDS SQL Server using the AWS CLI command: create-db-instance.
Read more »
How to rollback using explicit SQL Server transactions
June 17, 2020In this article, we will explore the process of rollback an explicit SQL Server transaction. We will also explore the difference between explicit and implicit transactions.
Read more »
Automatically Start/Stop an AWS RDS SQL Server using AWS Lambda functions
June 12, 2020This article gives you an overview of the AWS Lambda function to automatically start and stop AWS RDS SQL Server.
Read more »