Firewall Ports You Need to Open for Availability Groups

This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.

How to Easily Grant Permissions to all Databases

This article demonstrates one method to grant READ access to all DBs while still keeping the environment secure & hitting that chord of doing it efficiently.

Time to Set Service Dependencies for SQL Server, it’s Easy

In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.

Simple Method to Add A Network in SQL Configuration Manager

In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server.