How to Use SQL Server High Availability with Amazon Web Services

In this article, we look at how we can get AlwaysOn features in SQL Server to work with Amazon AWS Many organizations using SQL Server, make use of cloud services for not only storing active data but also backups. The most preferred options of cloud storage by such organizations are Azure Cloud and Amazon Web Services (AWS). Although, Azure cloud is specifically tailored for SQL Server users, and is a product of Microsoft, AWS has no such specifications. Still, both of these cloud storage...

Read more »

How to Utilize Conditional Events to Present Data in Different Levels of Details

Spreadsheet rows can trigger context-sensitive events by using the "BeforeDoubleClick" event. In this simple exercise we illustrate how to drill-down from an executive report to the data below. This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". The workbook to be used has a number of populated sheets. Please use the one found here for this exercise. The...

Read more »

2 Methods to Create an Appointment Located at the Address of a Contact in Outlook

If you want to create an appointment from a specific contact and use the contact address directly as the appointment location. In this case, you can apply the 2 ways introduced in this article. Sometimes, you may need to schedule an appointment with someone, who is a contact in your Outlook, and use the contact address as the appointment location straightly, business address or home address. For most people, the most familiar method is to manually create an appointment and copy the contact...

Read more »