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,873 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
6,400 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,038 reads
Blogs
Azure SQL Managed Instance Versions
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
A summary of new features in Azure SQL Database
It has been some time since I last wrote about Azure SQL Database. Although...
Daily Coping 23 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
about the concern about sp_updatestats
Do I still need to run sp_updatestats if I execute DBCC DBREINDEX(tablename) for tables...
SQL Server 2019 Distributed Availability Groups
Hello. I am looking into setting up a Distributed Availability Group between 2 availability...
Server Roles and Permissions
Hi guys Setting up a new SQL Server on Azure (Managed Instance). I have...
Ask SSC