PostgreSQL High Availability Options
This tip provides a high-level overview of the PostgreSQL High Availability options and their similarities with SQL Server.
Edwin M. Sarmiento is the Managing Director of 15C, a consulting and training company that specializes on designing, implementing and supporting SQL Server infrastructures. He is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology but has interests in music, professional and organizational development, and leadership and management matters when not working with databases. Edwin lives up to his primary mission statement: "To help people and organizations grow and develop their full potential."
- MSSQLTips Awards: Champion Award (100+ tips) - 2017 | Author of the Year Contender - 2020, 2017
SQL Server Query Store for Query Performance History
Learn how to use SQL Server Query Store to obtain the performance history of application queries and determine what needs to be tuned.
Identify CPU Intensive SQL Queries from Implicit Conversions
Learn how to use the SQL Server Query Store to find CPU-intensive queries and how you can use Query Store to resolve these issues.
Identify CPU Intensive SQL Queries with SQL Server Query Store
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
Troubleshoot SQL Server Always On Availability Groups with AGDiag
Learn how to use the AGDiag tool to troubleshoot and analyze SQL Server Always On Availability Group issues.
Troubleshoot SQL Always On Availability Groups with SQL LogScout
Learn about SQL LogScout which is a log analysis tool to help troubleshoot SQL Server errors by using the available log files on the system.
Add Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster
Part 3 of SQL Server 2022 on a Windows Server 2022 Failover Cluster series where we walk through the steps to add additional nodes to the cluster.
Install SQL Server 2022 on Windows Server 2022 Failover Cluster WSFC
This article covers all the steps to install SQL Server 2022 on top of an existing Windows Server 2022 Failover Cluster (WSFC).
PowerShell Commands to Administer Virtual Machines on Amazon AWS
Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.
Windows Server 2022 Failover Cluster Step by Step for SQL Server 2022
Build a Windows Failover Cluster using Windows 2022 and SQL Server 2022 in this step-by-step series.
AWS Tools for PowerShell to Administer Virtual Machines
This article covers PowerShell commands to administer virtual machines on Amazon AWS.
SQL Server Best Practices Check to Assess your SQL Servers
See how to install and run the SQL Server Best Practices Check with Azure Data Studio to get an assessment for all SQL Server instances and databases.
SQL Server Contained Availability Groups Configuration
Learn how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.
Microsoft Assessment and Planning Toolkit to Inventory SQL Servers
Learn how to use the Microsoft Assessment and Planning (MAP) Toolkit to take inventory of SQL Server instances and databases across the network.
Migrate SQL Server Databases to Different Active Directory Domain
In this third article we continue building Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain.
Distributed Availability Groups to Migrate SQL Server Databases – Part 2
In this article we continue building Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain.
Distributed Availability Groups to Migrate SQL Server Databases – Part 1
In this article we look at how to use Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain.
Perform Maintenance on SQL Server Availability Groups
Learn how to perform maintenance on the replicas of the primary SQL Server Availability Group when using Distributed Availability Groups.
Distributed Availability Groups for SQL Server Disaster Recovery
Learn how to configure a Distributed Availability Group when the replicas in the primary Availability Group are failover clustered instances.
Read-Scale Always On Availability Group to Offloading Reporting
In this article we look at how to leverage existing Read-Scale Availability Groups for disaster recovery to offload reporting and analytics workloads.
SQL Server Read-Scale Always On Availability Groups
Learn how to use SQL Server Read-scale Availability Groups to replace Database Mirroring as a disaster recovery strategy.
SQL Server 2019 Cluster Setup Adding a Node
In part 4 of this series on SQL Server 2019 Clustering on Windows 2019 we walk through the steps of adding nodes to the cluster.
Clustering SQL Server 2019 Step by Step
In this part of the series we look at the steps to install SQL Server 2019 on a pre-configured Windows Server 2019 Failover Cluster.
SQL Server 2019 Installation on Windows Server 2019 Failover Cluster
This article walks through how to configure Windows Server 2019 failover cluster according to Microsoft best practices in preparation for installing SQL Server 2019.