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)
5,406 reads
Scripts
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)
1,104 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)
1,804 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)
1,009 reads
2018-11-30 (first published: 2017-04-01)
1,164 reads
2018-11-29 (first published: 2018-11-23)
481 reads
2018-11-15 (first published: 2018-11-08)
1,619 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)
6,185 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,284 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,185 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers