XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and power to offer.
Your Quick Introduction to Extended Events in Analysis Services
Month: December 2020
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.
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.