Videos

Search all of our videos below:

  • Meetings
Expand All | Collapse All
  • 1. Access with SQL Server Academy - part 2 - November, 2019
     

    Intermediate discussion:
    - Link views back to Access
    - SQL Server Security
    - Configuring SQL Server Surface Exposure
    - SQL Server vs. Domain Security, which one is more secure?
    - Your questions answered during the Q&A with Juan Soto

  • 2. SQL Server's Path Toward an Intelligent Database - October, 2019
     

    SQL Server 2019 introduces ground-breaking query performance enhancements under the Intelligent Query Processing family.

    These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data!

    Pedro Lopes is a Program Manager in the Database Systems Group, based in Redmond, WA, USA.

    He has over 19 years of industry experience and has been with Microsoft for over 9 years, where he is currently responsible for Program Management of database engine features for SQL Server and Azure SQL, with special focus on the Relational Engine (Query Processor, Programmability, Performance).

  • 3. Access with SQL Server Academy - part 1 - September, 2019
     

    Our new season of Access with SQL Server User group meetings started September 10th 2019 and we reran our Access with SQL Server Academy! Join Juan in October and November for Intermediate and Advanced Topics on Access with SQL Server. It's the perfect opportunity to "jump in" based on your current skill level. Sign up today to be on the mailing list: https://bit.ly/AUGSQL

  • 4. How to secure the data on your Access & SQL Server application - August, 2019
     

    More and more databases are stored in cloud, on servers that we don’t control or own. People have started asking how they can protect the data at all times. We will discuss about techniques that we can leverage within Access applications connecting to SQL Server/Azure database without leaking sensitive data, and provide a clean separation between those who has access to data and those who has access to the server administration.

    Please be advised that the presenter, Ben Clothier (multiple Access MVP) is deaf. What you will hear is the voice of the interpreter. Thank you for your understanding.

  • 5. Using OASIS-SVN and git for Access source code control - July, 2019
     

    Wondered how to use git with Access? In this talk with a lots of demonstrations, we will learn how to effectively use git as a source code control and use its capabilities to provide a solid history of changes for easy review and management. We will use OASIS-SVN and TortoiseGit to help make the job easier and talk briefly about how git should be used.

    Please be advised that the presenter, Ben Clothier (multiple Access MVP) is deaf. What you will hear is the voice of the interpreter. Thank you for your understanding.

  • 6. Analyzing Access application performance using ODBC SQL tracing - June, 2019
     

    We will learn how to troubleshoot slow Access forms / reports with a remote SQL Server backend by using the ODBC SQL to collect the actual queries Access is sending to SQL Server and review those queries to identify the culprit for poor performance. We will also cover some optimization strategies to help improve the responsiveness of the forms.

    Please be advised that the presenter, Ben Clothier (multiple Access MVP) is deaf. What you will hear is the voice of the interpreter. Thank you for your understanding.

  • 7. How to convert Access Database from 32 Bit to 64 Bit - May, 2019
     

    Susan Pyne, Senior Access Developer at IT Impact Inc, talked us through the steps we need to take to successfully modify our Access VBA code to run in both 64 bit or 32 bit Access. She also covered the benefits of moving to a 64 bit environment.

    AUG 64 Bit Conversion - PDF presentation

  • 8. MVP Summit and the latest news about Access - April, 2019
     

  • 9. Using ADO asynchronously in Access - March, 2019
     
  • 10. Encryption of Data in SQL Server - February 2019
     

  • 11. Access with SQL Server Academy - Part III - January, 2019
     

  • 12. Access with SQL Server Academy - Part II - December 2018
     

  • 13. Linked Table Manager with Michal Bar from Microsoft - November, 2018
     

  • 14. Access with SQL Server Academy - Part I - September, 2018
     
  • 15. Discussion: How would you improve the Access, IDE? - February, 2018
     

  • 16. Learn new ways to apply Access to the modern Microsoft ecosystem - October, 2017
     

  • 17. Form Spawning - Creating copies of forms in memory - April, 2017
     

  • 18. WORLD EXCLUSIVE with Michal Bar, Microsoft Access Program Manager at Microsoft! - March, 2017
     

  • 19. Meet the authors of "Effective SQL: 61 Specific Ways to Write Better SQL" - February 2017
     

  • 20. Introduction to Access with SQL Server - January 2017
     

  • 21. Where is Access heading? What changes are coming? - December 2016
     

  • 22. The Evolution and Future of Access (feat. interview with Luke Chung from FMS Software) - October 2016
     

  • 23. Avoid Number Conflicts With SQL Sequences - September 2016
     

  • 24. Access and SQL Server FileTable - May 2016
     

  • 25. Town Hall Meeting - March 2016
     

  • 26. Access and SQL – Your .NET Internet Data Hub - February 2016
     

  • 27. Architecture of Access with SQL Server Solutions - January 2016
     

  • 28. SQL Server with Access & Power BI - December 2015
     

  • 29. Incorporating Windows Security into Access with SQL Server apps - November 2015
     

  • 30. Techniques for identifying slow queries and optimizing them - October 2015
     

  • 31. Stored Procedure, Pass Through Query or ADODB? When do you use either in Access? - September 2015
     

  • 32. SQL Server Migration Assistant - March 2015
     

    In March's meeting, presented by Juan Soto Microsoft Access MVP, we tackled how to install SSMA, configured it’s use, how to do an upload to SQL Server and how to leverage SSMA in subsequent migrations.

  • 33. How to upgrade an Access application to use a SQL Server backend - February 2015
     

  • 34. SQL Server Security - January 2015
     

  • 35. Power and Simplicity using Tables for Dates and Numbers - December 2014
     

  • 36. Using SQL Server data sets and stored procedures to create dashboards in Microsoft Access - November 2014
     

  • 37. Working with XML data efficiently - October 2014
     

    Ben Clothier, Access MVP and co-founder of the AccessUserGroups.org, presented the meeting discussing working with XML data with an SQL Server backend.

  • 38. Using Stored Procedures in Access - September 2014
     

  • 39. Introduction to Full-Text Searching in SQL Server 2012 - July 2014
     

  • 40. Synchronizing SQL Server Databases Across Continents - May 2014