I just wanted to take a quick moment to let everyone know that yesterday I received the great news that I will be speaking about PowerShell at the 2010 PASS Summit! Here’s what my session will be: The Dirty Dozen: PowerShell Scripts for the Busy DBA You’ve heard it said, “If you have to do it twice, automate it.” That’s great advice and PowerShell provides a simple but extremely powerful way to do it. PowerShell is the future of Windows scripting. Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool. Speaker: Aaron Nelson Senior Database Administrator I owe a huge thanks to everyone who helped me make this a reality and I’ll write a post thanking many of them when I get some time. del.icio.us Tags: PASS Summit 2010,SQL Server,PowerShell
July, 2010:
Early July 2010 PASS VC Presentations
Loops, Lookups and Splits: SSIS Beyond the Basics Managing Teams Why Should I use Stored Procedures? _____________________________________________________________ Loops, Lookups and Splits: SSIS Beyond the Basics July 13th 9:00 PM EDT (GMT -4) Presenter: Tim Mitchell In this session, we’ll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the SSIS looping containers, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008. Tim Mitchell Tim Mitchell is a Microsoft SQL Server consultant, developer, and speaker. He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, and reporting. He has earned numerous certifications and holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP. Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. See his full profile and blog at www.timmitchell.net. How do I view the presentation? Attendee URL: Live Meeting link _____________________________________________________________ Managing Teams July 13th 1:00 PM EDT (GMT -4) / 10:00 AM PDT (GMT -7) Presenter: Andy Leonard Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams. Andy Leonard Andy is an Architect with Molina Medicaid Solutions, SQL Server database and Integration Services developer, SQL Server MVP, PASS Regional Mentor, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs for SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008. Click here to join the Live Meeting. _____________________________________________________________ Why Should I use Stored Procedures? July 14th 12:00 PM MDT (GMT -6) Presenter: Jack Corbett With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored procedures for Data Access, I personally disagree. This will be a professional and polite open discussion starting with why I believe stored procedures are the best way to access data in SQL Server. Alternate view points welcome. Jack Corbett Professional who has worked with SQL Server for 10 yrs (6.5-2008) and experience in .NET development as well. Author of several articles for SQLServerCentral and video author for SQLShare.com. Speaker at several SQLSaturday’s and Florida User Groups. Co-President of OPASS. Lover of all things SQL except Analysis Services and MDX. Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=7FKD56&role=attend _____________________________________________________________ del.icio.us Tags: AppDev,DBA,PASS,Professional Development