SQL Server Worker Thread Alert
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
867 reads
Edward Pochinski
The Pesky Windows Power Plan Oh My
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
343 reads
Add new Databases to a AG Setup with PowerShell
Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.
2017-09-12 (first published: 2017-09-07)
267 reads
PowerShell 3rd Party tool Memory Alert
Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.
2017-04-25 (first published: 2017-04-13)
434 reads
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
321 reads
TDE Decryption Timer Script
Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.
2017-01-24 (first published: 2017-01-18)
357 reads
Open Transaction Alarm to Log to the Event log
If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.
2016-04-22 (first published: 2016-03-30)
608 reads
Transaction Log VLF Alarm
This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.
2016-03-17 (first published: 2016-03-02)
825 reads
Orphaned login report for all databases
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,001 reads
SQLPS Meets the DMV's
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
367 reads
Blogs
Reviewing 2019 Career Goals
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
ASF 029: Tomaz Kastrun interview
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Forums
Hu?ng d?n cách làm d?i lý ki?m ti?n t? don thu?n trên 188bet chi ti?t nh?t
Hi?n nay, do s? v?ng m?nh chóng vánh c?a hình th?c cá cu?c online...
Automatic Redaction of PII
Comments posted to this topic are about the item Automatic Redaction of PII
Find Strings Containing Hex Range
I have a table with a varchar field. It contains a number of characters...
Ask SSC