Monitoring database growth is a key factor in planning a server's resource. Use this script and create easy to understand database growth report Why You Need to Monitor Database Growth If you are a SQL Database administrator and if you are not...
Read more »Follow these simple steps along with the script to set up and receive a simple and single email whenever a failover happens in your AlwaysOn Availability Group. AlwaysOn Availability Group in SQL Server AlwaysOn Availability Group was released...
Read more »In this article we look at the key functions of transaction logs in SQL Server Transaction Log, as the name suggests, keeps a log of all the transactions that are taking place; along with the database modifications it’s making each day. It is...
Read more »