Optimizing Microsoft Access with SQL Server IndyPass – 5/21/19
Join me on Tuesday May 21st 2019 as I present Optimizing Access with SQL Server to the great folks at IndyPass. I’ll be discussing all the great tips and techniques we use with clients around the world. Pizza will be served as well.
Abstract:
SQL Server DBA’s are often asked to take over a Microsoft Access application that has become mission-critical, the conversation usually goes like “You’re a DBA and Access is a database, so take over this system and upgrade it to SQL Server…”, but simply moving the data over may not guarantee better performance and can even make matters worse.
The reality is Access can be much faster with SQL Server, allowing many more users, improving stability and safeguarding your data over a regular Access database. In this session, Juan Soto, the only Access MVP in Illinois, will discuss how to avoid pitfalls with performance, the proper method to designing tables for Access and how to leverage stored procedures and views with pass-through queries.
Agenda:
5:30 – Professional Networking/Registration and Food
6:00 – Announcements
6:15 – Featured Presentation
7:30 – Prize Drawings
Location:
Virtusa
1401 North Meridian St.
Indianapolis, IN 46202
You can register here: (As of May 16th the presentation details are not posted but I am confirmed)