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)
6,314 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
5,393 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,036 reads
Blogs
Goal Progress–November 2020
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
Azure Synapse Analytics is GA!
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
5 Things You Should Know About Azure SQL
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Forums
Get data from last line and merge into data stream before removing
This script reads thru a file and removes the last line, but before it...
Firewall access for Availability Group listeners
Hello experts, I have a noob question as I never feel like I understand...
conversion of excel formula to case statement in tsql
Hi all, need your help on conversion of excel formula into case statement. i...
Ask SSC