Chicago SQL Server User Group


Welcome to Chi-SSUG!

Please click here for general group information.  Also follow us on twitter at @ChiSQL or our hashtag #ChiSQL.  We look forward to seeing you at our next meeting!

Next Meeting: Thu, Feb 21 2019

Chicago SQL Server February 2019 Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None

Meeting Topic: Optimizing Microsoft Access with SQL Server

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 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, 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


UTC : Thu, Feb 21 2019 11:30 - 13:30
Event Time : Thu, Feb 21 2019 05:30 - 07:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Thu, Feb 21 2019 11:30 - 13:30


200 E Randolph Dr
Chicago, Illinois

Direction: None


Back to Top