FILEMAKER SERVER 12

1. FILEMAKER SERVER 12 Jason FiskeBusiness Account ManagerFileMaker, Inc. Mark Richman President & CEOSkeleton Key Master the essentials of FileMaker 12

2. Technical Information • Audio BroadcastYou can listen to today’s presentation through your computer speakers. Technical Issues with CitrixCall: (888) 259-8414 Question & AnswerWe will be taking questions following the presentation, please enter your question in the Citrix Control Panel

3. How to ask a question • Go to the Control Panel, click on the “Questions” section to reveal the Questions section and enter your question and send.

4. FileMaker Training Series • Master the essentials of FileMaker 12 • 13 self-paced training modules • Official curriculum from FileMaker, Inc. • 800+ page manual plus demo files, exercises and videos • FileMaker 12 best practices • Dedicated FileMaker Go module • Use as study materials for FileMaker 12 Certification exam • New low price: $39.99 – printed book and DVD $19.99 – download only

5. FileMaker Training Series • Modules • Using FileMaker Pro • Working with Fields • Data Modeling • Working with Layouts • Calculation Functions • Scripts • Reporting • Security • Intermediated & Advanced Techniques • FileMaker Server • Connectivity • Web Publishing • FileMaker Go

6. Who should use the FileMaker Training Series? • People who want a solid grounding in key development principles • FileMaker experts who want to fill any gaps in their knowledge • Users who are comfortable with FileMaker Pro and want to advance their skills • Those wanting to become FileMaker 12 Certified Developers

7. Mark Richman President & CEOSkeleton Key

8. Who is Mark Richman? • President& CEO of Skeleton Key • + Business Alliance Platinum Member Company • + Authorized Trainer for 10 - 12 • + Certified Developer for 8 -12 • + Developer Conference Speaker 2010 - 2012 • + Developer Conference Excellence Award Winner 2011 • + Developer Conference Mad Dog PR Award Winner 2012 • + Solution Architect • + Business Partner • + Employer • + Husband (for 9 years as of this Thursday) • + Father (of 4, all boys, all 7 and under) • = One Pretty Busy Guy

9. Today’s Agenda • Which one do I need? • FileMaker Server (FMS) vs. FileMaker Server Advanced (FMSA) • What’s new in FMS12? • Read this before you install … • Configuration Tips • Backups & Progressive Backups • Server-side scripts • Q&A • Resources

10. Which one do I need?

11. Which one do I need? (cont.)

12. What’s new in FMS12? • Faster WAN Performance • Larger packets and fewer of them • 64-bit • More RAM for caching • Improved writing routines reduces disk access • Separate processes = stability + performance • Database hosting • Backups • Scripts & Plug-ins • ODBC • Remote containers • Interactive content • External storage • Speedier and safer backups • Hard links • Progressive ‘backups between backups’

13. Read this before you install…

14. Read this before you install… (cont.)

15. Configuration Tips Demo

16. Configuration Tips Summary • Use a static IP • Required • Configure and test email notification • Enabled • Tested • Warnings & Errors for awhile; Errors only in the long run • Set and manage the Admin Console login • Set it at deployment • Change it periodically • Consider External Authentication • To Auto-Start or not to Auto-Start? That is the question! • Disabled? Requires administration • Enabled? Know the risks • What about that Database Cache setting? • Don't overthink it • Your mileage may vary

17. Backups & Progressive Backups Demo

18. Backups & Progressive Backups Summary • What to backup • All, by folder or by database • Where to put it • First, local to the FileMaker Server itself • If possible, to a separate drive/volume than the live databases • When to run it • Frequently – hard links make that less expensive • Natural fits (e.g., 7 days a week, 24 hours a day) • Options • Verify: Off-hours • Clones: Always • Safety Nets • Email Notification • Off the server and out of the building • Restoring • An untested backup is about as good as no backup at all

19. Server-Side Scripts Demo

20. Server-Side Scripts Summary • Scheduled like a regular Backup • Script Types • FileMaker Script • Subset of supported commands • Remember – the server can do some things MUCH faster than a client • System-level Script • e.g., zip, move, copy, rename, and even manipulate FMS! • Script 'Sandwich' • System-level Script + FileMaker Script + System-level Script • Account • To access the database • To run the system-level script • Options • Script Parameter • Time limit & Abort

21. Q&A

22. FileMaker Resources • Purchase the FileMaker Training Series • http://store.filemaker.com • Find a FileMaker Authorized Trainer • http://www.filemaker.com/support/training/authorized_trainers.html • Watch more FileMaker Web Seminars • http://www.filemaker.com/support/webinars • Downloads • FileMaker Server 12 Getting Started Guide • How To: Replicating an External Authentication Environment for Development • How To: Offload Processes and Reports to the Server • FileMaker Security How To Guide – The Key to Securing Your Apps

23. Other Resources • Additional Downloads • FileMaker Server 12 Narratives • Contact Skeleton Key • http://www.SkeletonKey.com • mark@skeletonkey.com • Upcoming Skeleton Key Training • The Path to Certfication, Classroom training, November 26th – 30th • FileMaker Server 101 Web training, November 14th & Dec 12th • Developing for Maximum WAN Performance Web training, November 28th