Posts by Jason Brimhall
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 MoreSource Control – The Best GUI For Productivity
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!
The post Source Control – The Best GUI For Productivity first appeared on SQL RNNR.
Read MoreTime 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 MoreSimple 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 MoreHow 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 MoreData Platform MVP 2020
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
- It’s an Honor: Microsoft MVP July 1, 2019
- How to be an MVP Book November 28, 2018
- My Book Contributions November 30, 2018
- T-SQL Tuesday #102: Giving Back May 8, 2018
- What is the Merit of the Job? December 29, 2019
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.
Related Posts:
- Note to Self June 11, 2019
- Passion, Challenges, and SQL February 12, 2019
- Making Databases Personal April 9, 2019
- Puzzles and Daily Trivia May 14, 2019
- The Gift of the SPN December 10, 2019
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:
- Find Index Create Date December 25, 2019
- Incorrect Syntax – What? November 17, 2017
- Audit Index Changes December 26, 2019
- Mass Backup All Sessions May 23, 2019
- SSRS Subscription Schedules – Enhanced May 25, 2017
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:
- SHUTDOWN SQL Server December 3, 2018
- Failed to Create the Audit File December 31, 2017
- Audit Domain Group and User Permissions December 29, 2017
- Cannot Open Backup Device January 1, 2020
- The Gift of the SPN December 10, 2019
Where is that Mask?
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.
Related Posts:
- Encrypting a Database Never Finishes December 20, 2018
- Parse Dynamics AX Context Info January 30, 2017
- Capture Index Maintenance Operations December 20, 2017
- Common Tempdb Trace Flags – Back to Basics January 5, 2018
- Synonyms in SQL Server – Good and Bad December 14, 2018