Late June 2010 PASS VC Presentations
ETL with PowerShell
June 22nd 9:00 PM EDT (GMT -4)
Presenter: Chad Miller
In this session we will look at performing common data loading tasks with PowerShell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.
Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows PowerShell since 2007. In his spare time he is the Project Coordinator/Developer of PowerShell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa PowerShell User Group and is also a frequent speaker at SQL Server users groups, SQL Saturdays and Code Camps.
How do I view the presentation?
Attendee URL: Live Meeting link
How SQL Server Indexes Work
June 23rd 12:00 PM EDT (GMT -4)
Presenter: Sharon F. Dooley
There are many useful presentations about indexes. Most of these concentrate on tricks and techniques. This presentation will provide the background knowledge of index architectures so that you can understand why techniques work and select the appropriate indexing strategies for your databases. Topics covered include page splits/fragmentation, disk accesses required for different index types, covering indexes and optimization.
Sharon Dooley (MCP, former SQL Server MVP) has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her cats.
Reporting Services for the DBA
June 23rd 12:00 PM CDT (GMT -5)
Presenter: Ef Romero
Reporting Services for the DBA: Using Reporting Services to monitor and affect changes to SQL Server.
Ef Romero is a Senior Consultant at Hitachi Consulting where he specializes in business intelligence development with SQL Server. His work with SQL Server is concentrated in ETL, data warehouse development, database optimization, and reporting. He received his bachelor’s and master’s degrees, both in pure mathematics, from UTEP and has worked as a mathematician and BI developer for the past four years. He is a collaborator on the recently published book SQL Server Reporting Services Recipes: for Designing Expert Reports.
Attendee URL: Join the meeting