Blog
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.
Related Posts:
- Owner is Missing in the GUI – An Easy Fix December 31, 2021
- Unicode, Emojis and Databases Oh My! January 5, 2020
- 3 Important Queries for Testing Your Availability Group… October 12, 2021
- Where is that Mask? December 28, 2019
- CRM Data Source Connection Error January 23, 2020
Source 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.
Related Posts:
- Mass Backup All Sessions May 23, 2019
- Top 3 Database Life Hacks February 12, 2020
- Public Role Permissions – Back to Basics June 17, 2019
- How to Easily Grant Permissions to all Databases December 29, 2020
- CRM Data Source Connection Error January 23, 2020
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.
Related Posts:
- Here is an Easy Fix for SQL Service Startup Issues… December 28, 2020
- CRM Data Source Connection Error January 23, 2020
- SHUTDOWN SQL Server December 3, 2018
- Single User Mode – Back to Basics May 31, 2018
- Changing Default Logs Directory – Back to Basics January 4, 2018
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.
Related Posts:
- How To Resolve User Error in Kerberos Configuration Manager December 26, 2020
- Configuration Manager is Corrupt December 17, 2019
- CRM Data Source Connection Error January 23, 2020
- The Gift of the SPN December 10, 2019
- Changing Default Logs Directory – Back to Basics January 4, 2018
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.
Related Posts:
- The Gift of the SPN December 10, 2019
- CRM Data Source Connection Error January 23, 2020
- Collation Conflict with Extended Events March 12, 2020
- Configuration Manager is Corrupt December 17, 2019
- Ad Hoc Queries Disabled December 20, 2019
Data 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
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed with Alerts appeared first on Wayne Sheffield.
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
Using Google Chrome with SSRS
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome with SSRS appeared first on Wayne Sheffield.