Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Group info
Recent pages and files
Meeting 2009/07/14 - SSIS 2008 (Peter Myers), Mirroring (Glenn Berry)    

 

Presentation 1

SQL Server Integration Services 2008 

presented by Peter Myers

 

About the Presenter

Peter Myers has nine years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server. Specializing in developing custom data-focused applications and reporting solutions, he provides architecting, development, implementation and support services at all tiers of a multi-tier application. He has a broad business background supported by a bachelor degree in applied economics, and he extends this with MCITP, MCSD, MCDBA, MCSE and MCT certifications. Currently he provides mentoring and technical training internationally, and focuses on delivering training for the SQL Server database engine, Integration Services (DTS), Analysis Services, Reporting Services, ASP.NET and .NET programming (C# and VB.NET). In 2005 Peter authored and presented the "Microsoft SQL Server 2005 Business Intelligence" workshop Australia-wide for Microsoft which showcased the SQL Server 2005 Business Intelligence platform. In 2006 he authored the "Jumpstart to Microsoft Business Intelligence" two day workshop. Peter enjoys sharing his enthusiasm for Microsoft technologies by presenting at SQL Server user group meetings and technical events, including TechEd, VSLive and the SQL Server 2005 Launch.

 

About the Presentation

SSIS 2008

Data Profiling in 2008
● Slowly Changing Dimension Transformation
● Fuzzy Lookup
● Using SSIS as a SSRS data source

 

Peter Myers Presentation Materials

 

Presentation 2

Using SQL Server 2008 Database Mirroring to Become a Super Hero!

presented by Glenn Berry

 

About the Presenter

Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. He is also an Adjunct Faculty member at University of Denver - University College, where he has been teaching since 2000.  Glenn will be presenting at this year's SQL PASS summit in November:  http://summit2009.sqlpass.org/Agenda/ProgramSessions.aspx.

 

About the Presentation

Database mirroring is a valuable technology that can be used to minimize or avoid downtime due to hardware failures, with less complexity than fail-over clustering. It can also be used for other innovative uses, such as easily migrating from SQL Server 2005 to SQL Server 2008 with a sub-minute outage. Database mirroring can be used during normal scheduled maintenance for rolling updates to minimize downtime. Database mirroring works very well for migrating very large databases from one SAN to another with minimal downtime. This session will cover all of these scenarios, with practical techniques, scripts and tips to help you take advantage of database mirroring. 

 

Presentation Goals

Demonstrate how to implement database mirroring in a high volume OLTP environment. 

Show tip and tricks to make deployment and management easier.

Show techniques for maximizing database mirroring performance. 

 

Glenn Berry Presentation Materials

 

Tuesday, July 14, 2009   

5:30 – 6:00  Food, Refreshments, Networking and Socializing

6:00 – 6:15  User Group Business (Q/A, Upcoming Presentations, Job Announcements, etc.)
6:15 – 7:00  Presentation 1 - SSAS Data Mining - Peter Myers
7:00 – 7:45  Presentation 2 - Database Mirroring - Glenn Berry

7:45 – 8:00  Wrap Up

 
Food and beverages will be served at around 5:30pm (thanks Christie from TekSystems!)


Available via Live Meeting:

Webcast via Live Meeting - Instructions

 

Please join us in these in-depth discussions!


Paul Paiva and Kate Totten
Co-Presidents of Boulder SQL Server User's Group
bssug1@gmail.com

 

Version: 
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google