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,941 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,996 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
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I...
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Forums
Seggregating access within a database to users
For some folks that have gotten used to working in Oracle where a user...
Replication Error on identity Column : Transactional Replication
I have manually deleted data from a subscriber replicated table, and broken replication....
Two fact tables related
Hi all, I have a couple of modelling questions using several star schemas. There...
Ask SSC