SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Syncing your calendars

I have a desktop computer, a laptop, and a iPhone.  I frequently add meetings to my Outlook calender on my desktop computer, but sometimes enter them on my laptop.  And I frequently use my iPhone to alert me about upcoming meetings.  These leads to a major problem in keeping all three in sync.  Well, the best solution I have found to keep them synced is by using Google Calendar Sync (download).  Install this on both your desktop and your laptop (making sure to choose the 2-way sync), and then follow the steps from Setting up Google Sync with your iOS device.  From then on, the calendars in Outlook on your desktop, Outlook on your laptop, your iPhone, and Gmail will all be in sync.  So no matter which one you use to enter a meeting, all the others will be updated in seconds.  Of course, this requires you to have a Gmail account, but they are free and you can continue to use your current email account and just use the Gmail account for your calendar.

Some other notes about this solution:

  • You can always go to your Google calendar if your desktop and laptop are not available
  • A cool thing about Google Calendar is it will add a map link to addresses that you have listed in appointments
  • Note that this is syncing my personal Outlook calendar.  My business Outlook calendars are already synced because they use Microsoft Exchange and therefore each have their own calendar that is available under “My Calendars”
  • There is a bug where appointments don’t get synced if they were created before you installed the Google Calendar Sync (you must delete and recreate them)
  • Go to your contacts on Gmail and enter birthdates so they show up on the calendar
  • On Google Calendar, add the US Holidays calendar (see How to Add Public Holidays To Google Calendar).  Also add the “Contacts’ birthdays and events” calendar
  • To add holidays to Outlook, see Add National Holidays in Outlook Calendar
  • Contact’s birthdays or US holidays don’t get copied from Google calendar to your Outlook calendar unless while in Google calendar you choose “copy to my calendar” for each item and set to repeat yearly (a pain!)

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...