Description
Many AutoCAD software add-ins are limited in their reach to the computer on which they were installed. When a need arises to reach out and tap enterprise resources such as Microsoft SQL Server data, a few strategic lines of code is all that’s needed to pull that data in from SQL Server or push data out to SQL Server. Learning those few lines of code is a good start, but we can do so much more if we take more than 10 minutes. So we’ll use every minute of this class to do so much more. Stored Procedures—perhaps you've heard of them but haven't used them. Scalar Functions—they can be good and they can be bad. Views? Indexes? They can all be yours if you attend this 90-minute instructional demonstration.
Key Learnings
- Learn how to incorporate SQL Server into your .NET add-ins
- Learn how to link AutoCAD entities to SQL server records
- Learn how to improve performance using Stored Procedures, Scalar Functions, Views, and Indexes
- Learn how to benchmark to determine where to fine-tune SQL Server
Speaker
- JWJerry WintersJerry Winters has taught at nearly every U.S.-based Autodesk University over the past 17 years primarily on topics of AutoCAD software customization using Microsoft Visual Basic for Applications (VBA) and VB.NET. He brings a unique blend of education and entertainment as he tackles what would otherwise be a dry topic. And while he reserves the week before Thanksgiving for meeting with and enjoying the company of his Autodesk friends, the rest of the year is spent with his beautiful wife of 26 years and his 9 (yes, that's 9) children in rural Lake Point, Utah, where they are occasionally found singing at community events and senior centers.
Video Player is loading.
No transcript