Chicago SQL Server Users Group Meeting February 2019

Event Information

Share this event

Date and Time

Location

Location

Microsoft Technology Center

200 East Randolph Drive, Suite 200

Chicago, IL 60601

View Map

Event description

Description

Topic: Optimizing Microsoft Access with SQL Server

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.

Speaker Bio: Juan Soto is a frequent speaker at SQLSaturdays.com and prolific author of articles at the official Microsoft Access blog, including being the only Access developer to be profiled on the site. He’s also the founder of AccessUserGroups.org, a worldwide organization of user groups that meet virtually online to discuss Access topics each month in multiple languages and countries. When he’s not presenting he’s managing one of the largest practices of Access consulting in the world at AccessExperts.com

Share with friends

Date and Time

Location

Microsoft Technology Center

200 East Randolph Drive, Suite 200

Chicago, IL 60601

View Map

Save This Event

Event Saved