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)
1,760 reads
Scripts
Quick SQL connection and process details with current SQL - Version2
Quick check SQL connection and process details with current SQL text
2018-12-19 (first published: 2018-11-27)
970 reads
2018-11-30 (first published: 2017-04-01)
1,094 reads
2018-11-29 (first published: 2018-11-23)
447 reads
2018-11-15 (first published: 2018-11-08)
1,568 reads
Automatically Failover (Enable or Disable) Jobs Based on HADR Role
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
5,807 reads
Detect and Repair Non Trusted Foreign Keys
Create the code to detect and repair non trusted foreign keys
2018-11-13 (first published: 2018-09-27)
686 reads
String Replace in Stored Procedures with Powershell
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
1,221 reads
Disk Space Check
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,147 reads
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)
566 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts
Bat and SQL script to generate DB user permissions for all Databases in SQL server
Comments posted to this topic are about the item Bat and SQL script to...