SQL Server Restart or Cluster Failover Notification
How to create an automatic SQL restart or failover notification.
2018-06-22 (first published: 2015-12-10)
7,944 reads
Lori Brown
- Interests: SQL Server, Running, Swimming, Biking
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
2015-10-13
8,007 reads
Monitor Database and Log Growth
Most DBA's would like to be notified when automatic database file growth occurs. This script will log file growth. It will not log file shrink but could be easily modifed to do so.Script does the following: 1. create tables to store server list, current & historical file sizes and actual growth for each database file […]
2005-11-29 (first published: 2005-07-21)
2,060 reads
Blogs
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Daily Coping 27 Sep 2022
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Forums
SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
SQL Master Data Services 2019 - Website keeps prompting for login
I have two SQL 2019 servers running Master Data Services which are continually prompting...
Add more columns to output
$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...
Ask SSC