The PowerShell Cookbook for the DBA
The best DBAs work hard so that they don’t have to, well, work hard. In this session, we’ll discuss how you can use the PowerShell cmdlets and snap-ins to create scripts that automate the more mundane tasks in your role as a DBA or developer. We’ll create scripts that check the status of SQLAgent jobs, verify the configuration of your servers, and retrieve information from your SQL Server database. You can even store your results in a database table if you’d like. This session is mostly demos with only a few PowerPoint slides to get us started.
WebbTech Solutions, LLC
Chief Operating Manager
Since its inception, Joe Webb has served as Chief Operating Manager for WebbTech Solutions, a Nashville-based consulting company. He has over 15 years of industry experience and has consulted extensively with companies in the areas of business process analysis and improvements, database design and architecture, software development, and technical training. In addition to helping his consulting clients, Joe enjoys writing and speaking at technical conferences. He has spoken at conferences in Europe and the North America and has authored or co-authored three books including “SQL Server MVP Deep Dives”, “The Rational Guide To: SQL Server Notification Services”, and “The Rational Guide To: IT Consulting”. Joe served for six years on the Board of Directors for the Professional Association for SQL Server (PASS), an international user group with 30,000 members worldwide. Joe culminated his tenure on the board by serving as the Executive Vice President of Finance for the organization. Joe also volunteers his time by serving on the MBA Advisory Board for Auburn University and the Computer Science Advisory Committee for Nashville State Community College. Joe received a Bachelors Degree in Electrical Engineering (BSEE) and a Masters in Business Administration (MBA), both from Auburn University. He has also earned Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solution Developer (MCSD), Microsoft Certified Systems Engineer (MCSE), and Microsoft Certified Trainer (MCT) accreditations as well as other non-Microsoft certifications such as the Linux Professional Institute Level I (LPIC-1). Joe is a six time recipient of the prestigious Microsoft MVP Award for demonstrating a willingness to share his expertise with the SQL Server Community.
Register Now for PASS Summit 2010!