This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.
Firewall Ports You Need to Open for Availability Groups
Category: News
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.
Here is an Easy Fix for SQL Service Startup Issues When Using an MSA
Running into startup issues with your services could be a nightmare on some days. Couple those issues with an MSA and you may be balding before long.
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.
How To Resolve User Error in Kerberos Configuration Manager
This article shows a problem with one of my favorite tools – Kerberos Configuration Manager. This tool provides a lot of power in resolving SPN related issues.
Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a security group to grant a bunch of people the same sets of permissions.
Automate Credit Card Audits
In this article, I have shown how to use the power of automation to help identify the risk of having card data stored in the database. Identifying this risk is essential to helping maintain the trust of your clientele and protecting your companies most valuable asset – the data!
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Unconscious Bias
This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.