I380 Corridor PASS Chapter

  Eastern Iowa's SQL Server User Group
  Cedar Rapids • Iowa City

EventDisplay

Meeting Details

Tuesday,

August

13

380 PASS August 2019 - Optimizing Microsoft Access with SQL Server

  • In-Person @ 201 S Clinton St, Iowa City, Iowa (map)
  • Tue, Aug 13 2019
    17:30 - 19:30 Central Daylight Time
  • Language: English

Featured Presentation:

Optimizing Microsoft Access with SQL Server

Juan Soto, Senior Access Developer IT Impact Inc.

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.

About Juan:
I'm the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I'm also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids