SQL Administration
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 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 MoreDecoded 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
Ad Hoc Queries Disabled
This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:
- Linked Servers and Stats October 17, 2017
- How Long is That Event Taking November 20, 2018
- Maintenance Plan Owner – Back to Basics December 13, 2018
- Implicit Conversion Fail May 31, 2019
- Common Tempdb Trace Flags – Back to Basics January 5, 2018
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.
Related Posts:
- Public Role Permissions – Back to Basics June 17, 2019
- Who needs data access? Not You! December 12, 2019
- SQL Server Permissions – Database Roles March 2, 2017
- SQL Server Fixed Role Permissions March 6, 2017
- SQL Server User Already Exists – Back to Basics January 24, 2018
Who needs data access? Not You!
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:
- SQL Server User Already Exists – Back to Basics January 24, 2018
- Extended Events Permissions December 25, 2017
- Synonyms in SQL Server – Good and Bad December 14, 2018
- Last Restore of a Database – Back to Basics December 19, 2016
- Lost that SQL Server Access? May 30, 2018