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
640 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
13,569 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,252 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
18,200 reads
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...
CPU Usage was running very high than normal. Identified the top query, so removing...
Is the a way in SSIS to add a comma to the end of...
I've had this problem rear its head before but not in some time. There's...
Ask SSC