1 DBA's Professional Blog
Syndication Feed for Database Masters
Every Database has a DBO or database owner set. Sometimes the owner is invalid, while most of the time the DBO is perfectly normal. It is easy to ignore whether a valid DBO is set or not. And then something breaks and you have to validate it. This article addresses the easy fix to validate the DBO.
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!
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.
In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server.
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.
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
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.
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we can decode those names and reveal what the names really mean.
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM reports working properly within Report Manager (via SSRS), the reports would fail in CRM.
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.