A Practical Overview of SQL Server Management Objects (SMO)
Presented by: Wayne Detmer, Ph.D.
SQL2005 presents us with a new version of an old option, instead of SQL-DMO(Distributed Management Objects) we are given updated and broader access to our server with SMO(SQL Management Objects). By using SMO to explore and manage your SQL2005 servers you will gain a deeper understanding of the object model used to manage SQL2005. Backups, checking and documenting your server settings and creating objects on your server are just a few of the things we can do with SMO. Using an ASP page, console app and a windows form we will explore some of the options for managing and documenting your server.
Biography of Wayne F. Detmer, Ph.D.
Wayne Detmer has been working and training in the microcomputer business for over 25 years. In Minneapolis, he started AGNET, a computer training and software development effort for the University of Minnesota Agricultural Extension Service in 1982 with the original IBM PCs. In addition, he and a colleague developed the first accredited two-year degree program for Microcomputer Specialists in 1989 at Northeast Metro Community College.
Dr. Detmer has worked as an IT Director and Database manager in various industries both in Minnesota and California for over 10 years and with SQL Server since its inception. He was a SQL trainer for Quickstart Technologies for three years and has been at IDT in Pasadena for four years where he is currently a Sr SQL Trainer.