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,646 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
7,688 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,054 reads
Blogs
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Microsoft Build event announcements
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Forums
Starting on Monday
Comments posted to this topic are about the item Starting on Monday
Charindex values of a substring inside a long sentence
I need to gather the starting position of the keyword "sql" from a sql...
BUILDING AN INVENTORY OF SQL SERVERS in Active Directory
We need to scan our entire network to build the list of all machines...
Ask SSC