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)
4,821 reads
Lori Brown
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
2015-10-13
2,889 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,001 reads
Blogs
A Memory-Optimized Roundup – T-SQL Tuesday #117
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
How do you debug your spark-dotnet app in visual studio?
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
More PowerShell Remoting coverage in dbatools
By Cludio-Silva
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...
Forums
Sql 2014 sp3 - extra stats created
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC