1 DBA's Professional Blog
Source control is quintessential to a productive development environment. A well maintained and organized source control system is akin to having known-good database backups. Having the right tools to interface with source control is just as important!
Stability and reporting go hand in hand. You cannot truly have stability without reporting. Take the time to share the stability successes with the business. Let them revel in the successes you have brought to the enterprise data footprint.
No matter how you name it, “hairball”, “spaghetti code”, “tech debt” or “DIY code”, the result is the same – you are dealing with legacy code that nobody wants to update or maintain.
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.
This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Validating your server setup is an integral component of your duties as a SQL Server DBA. When performing those validations, it is possible to run into an intriguing difference in reported port values.
The trick here is to find a way to search thousands of files quickly and filter easily the bad from the good. Sounds like an opportunity for an automation or script.
One tries to climb the ladder of success but at the cost of being an approachable human being. Nice people don’t need to finish last.
I am humbled to be among so many great professionals and honored at the same time for having been chosen.