Articles in this Newsletter March 08, 2019

You Asked for Peer Session Leaders

Don't miss out on this great opportunity to learn from individuals like you, who are in the industry and tackle the same challenges day-in and day-out as you do. Exchange industry best practices, hear tips on how to optimize your workflow from your colleagues, and get immersed in all things Andar.

The General Conference Agenda contains a detailed list of guest speakers. Visit the Speakers webpage on the conference website to read more about them. We're adding speaker photos and bios by the day — check back regularly for updates.

Book Your Hotel Room Before the Deadline

Book your hotel room at a discounted group rate of $149 per night USD (plus taxes) to enjoy the comfort and convenience of being in the same building and arriving from your bedroom to your session in less than five minutes. In addition to newly renovated guestrooms, the hotel has eight restaurants, a wellness spa, a tropical pool, and two hot tubs in a gorgeous patio. Plus, enjoy complimentary WiFi, no resort fees and free parking for hotel guests!

Register by Friday, March 22, 2019, to reserve your room at the current group rate.

Reservations can be made by visiting this link or directly with the Rosen Centre Hotel by calling their toll-free number 1-800-204-7234 or locally at 407-996-9842. Request the group rate for the 2019 Andar Software Users Group Conference.

The guestroom discounted group rate of $149/night will be honoured from April 10, 2019 to April 21, 2019 (based on room availability.) That gives you a few days before and after the conference to enjoy all that Orlando has to offer!

Ride up and down the miles of fun that make up the International Drive Resort Area. You will receive two (2) I-RIDE Trolley tickets complimentary per guestroom.

Very important! There are three ROSEN Hotels in Orlando, two of which are located on International Drive — each adjacent to the Orange County Convention Center. This meeting is being held at Rosen Centre Hotel on International Drive.

Why You Should Regularly Backup your SQL Database

It's 2019, and the average UW Andar database is <50 gigabytes and can be backed up in 20 minutes or less! An SQL backup can be done in SQL or a by a backup program that has an SQL agent. Take the next five minutes to get a quick refresher of different backup options and assess whether you (and your SQL database) are on the right track.

Virtual Servers
Many organizations now use virtual servers, and the backup is accomplished via a VM snapshot. ANDAR & SQL don’t know a backup has been done if an SQL agent wasn't used. Because of this, there's an option in Andar to turn off the backup warning.

Incremental Backups
To “save time” some organizations will do an incremental SQL backup. Increments are like links in a chain, and if one increment is missing or corrupt, you will not be able to restore the database with integrity. Incremental backups should be avoided and do not count towards Andar’s seven-day warning limit.

Log File Shipping
Some organizations have sophisticated database backups using replication or Log file shipping where each transaction is copied to another remote server across the country or even in another country.

Ultimately, the frequency of backups is really up to you. The spectrum ranges from no backups to 15-minute backups. Each comes with a price, and it's often said, "You can pay now or pay later."

Until you test an actual restoration of your database, you’ll never be 100% sure you have a proper backup -- don't risk learning that after a disaster strikes! And remember, always take your backup to a secure off-site location to guard against fire, theft or flood.

Quote of the Week

"You can make any human activity into meditation simply by being completely with it and doing it just to do it."

Alan W. Watts

Table of Contents

Archive by Year