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,050 reads
Collect CPU % for a time period and alert if Average CPU usage is high
2019-01-14 (first published: 2019-01-08)
1,761 reads
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,095 reads
2018-11-29 (first published: 2018-11-23)
447 reads
2018-11-15 (first published: 2018-11-08)
1,570 reads
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,823 reads
Create the code to detect and repair non trusted foreign keys
2018-11-13 (first published: 2018-09-27)
687 reads
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
1,222 reads
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
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Not sure if this is a tech mistake I've made or a lack of...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers