I was using this script to check disk space on individual servers for quite some time. And now since I started to use registered servers for MS SQL, I thought of a little modification to the script.
2018-11-09 (first published: 2018-10-24)
1,131 reads
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
529 reads
2018-11-05 (first published: 2018-10-22)
862 reads
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
2,859 reads
2018-10-29 (first published: 2018-10-19)
1,349 reads
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
988 reads
2018-10-24 (first published: 2018-10-15)
893 reads
2018-10-12 (first published: 2018-10-04)
1,121 reads
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
552 reads
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
493 reads
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
I am not understanding why this command completes "successfully" and it seems correct to...
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Which of these indexes is superseded by another?
See possible answers