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
826 reads
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
2019-12-10
15,684 reads
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
5,415 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
19,789 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
By James Serra
Microsoft has a ton of data platform-related products, but there are certain areas where...
We have this ad hoc query that is a recurring block leader, blocking dozens...
I am working with Microsoft SQL Server MANAGMENT STUDIO 18 and i Have 2...
My company has decided that in-place upgrading to SQL Server 2019 for test environments...
Ask SSC