If you landed on this page you’re probably interested in starting to learn SQL Server, congrats! We believe SQL Server and Access are an unbeatable combination. Scroll down to see a great collection of posts on SQL Server.
Here is a list of essential posts to get you started on your journey:
- First things first: Look at my video on optimizing Access with SQL Server
- Use SQL Server Native Client 18.0 for the best performance
- Migration guide to SQL Server
- Using SQL Server Native Client 18.0 to speed things up
- Download SQL Server Migration Assistant For Access v7.11 and easily upload your Access database to any version of SQL Server
- Tips for designing SQL Server tables for Microsoft Access
- Tips for optimizing Access with SQL over a WAN
- Great links to help you get started with SQL Server
- Learn all about DSN less tables in my four part series
- Create temporary tables in Access with SQL Data
- Stored Procedure guide for Microsoft Access
- Tap into the power of ADODB and send commands straight to SQL Server with EasyADODB
- Insert a record and retrieve it’s Key
- There are many more posts on SQL Server, click here to see them all
- See the latest issues with Access
I look forward to hearing back from you on how this website has helped you on your quest to using SQL Server.