Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
2,093 reads
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
If I have Read replica (in Azure SQL MI), can it be used as...
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers