2019-04-16 (first published: 2019-04-12)
1,775 reads
Scripts
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
346 reads
DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,302 reads
2019-02-27 (first published: 2019-02-20)
319 reads
Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
840 reads
Files with larger disk consumption
This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
2019-01-15 (first published: 2019-01-08)
624 reads
Alert DBA - High SQL Server CPU Usage
Collect CPU % for a time period and alert if Average CPU usage is high
2019-01-14 (first published: 2019-01-08)
837 reads
Quick SQL connection and process details with current SQL - Version2
Quick check SQL connection and process details with current SQL text
2018-12-06 (first published: 2018-11-27)
712 reads
2018-11-30 (first published: 2017-04-01)
736 reads
2018-11-29 (first published: 2018-11-23)
362 reads
Blogs
A Memory-Optimized Roundup – T-SQL Tuesday #117
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
How do you debug your spark-dotnet app in visual studio?
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
More PowerShell Remoting coverage in dbatools
By Cludio-Silva
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...
Forums
Sql 2014 sp3 - extra stats created
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC