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)
5,882 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
4,536 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,032 reads
Blogs
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Running SQL Server in Google Cloud Platform
By Daniel Janik
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...
More ADLS Gen2 enhancements
By James-Serra
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...
Forums
Copy Azure SQL DB App data to Azure Synapse
Hello, I am looking for the best way to copy change data from my...
Enable normal user to execute a sys stored procedure
I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the...
Enable user to execute a sys stored procedure
I am struggling to enable a user to be able to execute a system...
Ask SSC