Use PowerShell to Get the Most out of SQL Server
PowerShell is the new scripting environment from Microsoft for managing server environments. Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before. Whether you need to access data or manage SQL Server, PowerShell makes it possible. This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.
Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He’s spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last four years. He’s President of the Ohio North SQL Server User’s Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx. http://www.bradmcgehee.com/2010/09/interview-with-sql-server-mvp-allen-white/
Bringing Source Control into SQL Development Environments –Part 2, Tools and Demos
Source Control is a requirement for team development where it is necessary to coordinate and maintain one or more consistent data environments. In the past, source control has not been easy with databases due to the nature of the interrelationships between the database code (DDL) and the current data state. Source control makes it easier to know what is in a database, better expose inappropriate inclusions, and improves coordination with testing environments. In this session, we will explore the concepts and processes of adopting a robust source control regimen into a SQL Server environment.
Arnie is a Data Architect, Consultant and Trainer specializing in developer/development issues related to SQL Server. Clients include Fortune 100 enterprises, large scale NGOs, as well as domestic and foreign governments. In addition to facilitating the Oregon SQL –developers user group, he is a SQL Server MVP, a senior moderator for the Microsoft MSDN SQL Server Forums, member of the Microsoft TechNet Wiki Community Council, and co-founder of Portland Code Camp.