Message Handling Can Affect Your Availability Group Replicas in SQL Server

The state of databases participating in Always On are prone to change due to message handling. A sudden failover might interrupt a large transaction happening in the database that participates in Always On. This will result in a lengthy undo process and database status would be ‘Not Synchronizing’. Error message but no user action needed If your availability group is having hundreds of databases and heavy workload runs on the availability group, a sudden failover will change the status of...

Read more »

Is It Necessary to Encrypt Your Backup Data?

When it comes to securing data, encryption will occur to our mind in the first place. Now, other than the original data, some are considering whether it is necessary to encrypt the backup date. This article will discuss about this in detail. Encryption is a process to protect your data via a secret password, pass phrase or other types of encryption keys. In this way, you could prevent the encrypted data from being accessible by those who don’t know the correct encryption key. Hence, such...

Read more »

How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails

If you would like to send all worksheets in an Excel workbook as separate Outlook emails, you can use the method introduced in this article. It can guide you to realize it in bulk without troublesomely sending one by one. In my previous post “2 Quick Methods to Send an Excel Worksheet as an Outlook Email”, you can learn two ways to send one Excel worksheet as email. If you wish to batch send all worksheets in one workbook as individual emails, using either of the two means mentioned in...

Read more »