In this episode, I'm taking you on a journey to explore my first deployment of SQL Server as a backend, using just the database engine which was called MSDE (in the old days). This engine was packaged with MS Access, and then later became what you all know as SQL Server Express. It took just one deployment of a MSDE/SQL Server backend to show me the tight integration work that was done to make MS Access integrate seamlessly with SQL Server for companies that were scaling past the JET/ACE environment. I was really impressed when I saw that my client's app, with almost no changes to the front end, would work just as it had before, but faster and with more stability. After converting their data and connecting with ODBC linked tables, I couldn't believe how good it was!
Related Videos:
How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend
You are watching this video now!
How to Install and Use SQL Express
• How to Install and Use...
How to Design Tables in SQL Express for Use with MS Access
• How to Design Tables i...
For developers looking for a new role, check out and sign up:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.com/posts/how-to-...
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a KZitem Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
#msaccess #dataengineering #azuresql
Негізгі бет How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend
Пікірлер: 33