If looking to improve the general health of your Vault SQL Server implementation, improve performance, or automate backups, this course is for you. It’s geared towards Vault administrators looking to improve maintenance in their SQL Server environments using SQL Server Maintenance Plans. As maintenance plans are not something that is installed or implemented with out of the box solutions from Autodesk or Microsoft, we will provide a suggested solution for use with SQL Server. We will cover the basics of implementing a SQL Server maintenance plan to keep Autodesk Vault SQL Server Databases running at their most optimum levels, hourly, daily, weekly, monthly and beyond. Users will have a base maintenance plan to get started and will walk away with the knowledge to modify that plan to suit their own unique environments. This session features Vault Professional, Vault Basic, and Vault Workgroup.
- Understand what a maintenance plan is and why they are needed
- Create a maintenance plan that can be utilized in any environment
- Know at a high level the intricacies of the maintenance plan (understanding/options)
- Adjust the maintenance plan as needed for each business unit/organization (customization)
Over 25 years of relational database experience in Microsoft SQL Server and Oracle. Proficient in Database performance and tuning, backup and restore, replication and various and other areas or Database support and administration. This knowledge allows me to be better able to support my customers in their Vault Rollouts, upgrades, maintenance, troubleshooting, and migrations. My experience spans multiple industries from manufacturing to advertising to finance. Regardless of my title, Customer Service especially as it pertains to the Database, has been my passion. Being part of the Autodesk team as a DSS supporting Vault allows me to continue following that road.
I've been with Autodesk Enterprise Priority support for 4 years specializing in the Vault product. I'm also versed in C#/.NET development, Python, as well as MS SQL Server. I've been providing enterprise software support, training, and implementation for over 15 years. Further, I serve as Designated Support Specialist on a number of Automotive and Manufacturing accounts with Enterprise Priority Support.