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 with SQL Server 2012 and is the successor of database mirroring. You can set it up in your SQL Server environment for high availability or disaster recovery. For High Availability the group has to be set in synchronous mode and for disaster recovery the...
Read more »
The custom sort in Excel is a very useful feature. In this article, we will talk about how to automatically update custom sort in a range by using the Excel VBA.
When you use the custom sort, you will find that this is an amazing feature in Excel. However, if you use this feature frequently, you may also find a problem. You will sort in a range with certain data and information. When you add additional data and information into the range, the order in the range will not change...
Read more »
Data theft can be minimised by disabling various menu and right-click features in Excel. We discuss below how to do this using VBA.
It is assumed the reader has the Excel Developer ribbon displayed, and is familiar with the VBA Editor.
The User Interface
Build a worksheet with two buttons and a little data.
This sheet will have its ribbon displayed, and all the right_click functionality that Excel affords.
The sheet is available here.
The VBA Code
There are a variety of...
Read more »
