Be mindful of advice. Give an ear to those offering it. Just be mindful, there is no need to accept the advice, but it is wise to at least listen.
T-SQL Advice For Young, Old, and even Eccentric
Tag: Security
3 Important Queries for Testing Your Availability Group Endpoints
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the event the validation test fails.
How to Easily Grant Permissions to all Databases
This article demonstrates one method to grant READ access to all DBs while still keeping the environment secure & hitting that chord of doing it efficiently.
Here is an Easy Fix for SQL Service Startup Issues When Using an MSA
Running into startup issues with your services could be a nightmare on some days. Couple those issues with an MSA and you may be balding before long.
Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a security group to grant a bunch of people the same sets of permissions.
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
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.
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.
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.
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.