DBO – Your Easy Homework Cheat Sheet Is Here

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.

The post DBO – Your Easy Homework Cheat Sheet Is Here first appeared on SQL RNNR.

Read More

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.

The post Time to Set Service Dependencies for SQL Server, it’s Easy first appeared on SQL RNNR.

Read More

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.

The post Simple Method to Add A Network in SQL Configuration Manager first appeared on SQL RNNR.

Read More

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.

The post How To Resolve User Error in Kerberos Configuration Manager first appeared on SQL RNNR.

Read More

Decoded Statistics Names and More

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. 

Related Posts:

Read More

CRM Data Source Connection Error

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.

Related Posts:

Read More

When Too Much is Not a Good Thing

Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way too much access.

Read More