Himalayan SQL Server User Group Monthly Meeting Sessions 29th September, 2012
The community event will be focused on the following topics
Using BIML as an SSIS Design Patterns Engine (Duration 60 minutes)
SQL Server 2008 Database Internals (Duration 75 minutes)
Abstract: Do you already wanted to know how SQL Server 2008/2012 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008/2012 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyse the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last present of performance from your new database solution.
Presenter: Shree Prasad Khanal
Shree Khanal is a Database Architect, Speaker and trainer. Shree has worked with SQL Server for more than 8+ years and specialises in Data and business intelligence. He founded the Himalayan SQL Server User Group (www.sqlpassnepal.org) based in Kathmandu, Nepal.
Abstract: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
1. Demonstrate how to generate multiple SSIS incremental load packages with a single click.
2. Demonstrate the power of repeatable patterns-based development.
3. Demonstrate the flexibility Biml brings to data integration development.
Presenter: Andy Leonard
Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.
Dashboard Design: Making Reports Pop (Duration 75 minutes)
Abstract: Create a highly visual reporting experience in SharePoint with SQL Server Reporting Services integrated with SharePoint 2010. In this session, you'll learn how to use BI report design elements such as sparklines, KPI indicators, gauges, and maps to make important business information jump off the screen and get users’ attention. You'll see how to create highly interactive reports with dynamic drill-down, drill-through, and super reports that morph as users interact with the data. And we'll build an interactive dashboard using PerformancePoint/Insights and Reporting Services together.
Presenter: PAUL TURLEY
Paul Turley is a Mentor for SolidQ and a SQL Server MVP. He has been architecting, managing, and developing applications and Business Intelligence solutions for large and small businesses since 1992. His expertise includes project lifecycle management, database modelling and design, application development and user interface design using ASP.NET, and enterprise BI solutions. He teaches, develops training courseware, speaks at industry conferences, and has authored and co-authored several technical books. He has presented at PASS Summit since 2004.
Paul is an MSDN forum moderator for SSRS, has been an MCSD since 1996, and maintains certifications in software architecture and development, database administration (MCDBA), and project management methodologies (MSF & IT Project+.) He also holds the current MCTS and MCITP certifications for SQL Server BI.
Policy-Based Management in a Nutshell (Duration 60 minutes)==============================================
Abstract: We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature!
Presenter: Jorge Segarra
Jorge Segarra is a Sr. DBA Consultant for Pragmatic Works in Jacksonville, Florida and a SQL Server MVP. In addition to being a member of the Jacksonville SQL User Group he is also a former PASS Regional Mentor for the U.S. Greater Southeast region. Jorge has also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“ as well as "SQL Server 2012 Bible" from Wrox/Wiley. He was also a Redgate Exceptional DBA of the Year 2010 Finalist.
Date: 29th September, 2012
Time: 1:50:00 P.M
Venue: LABA 6th Floor Ranabhatt Complex Anamnagar-32, Kathmandu +977 1 4102721, 4102722
Please register immediately at http://sqlpassnepal.org/Meetings/Himalayan-SQL-Server-User-Group-Monthly-Meetin-(2).aspx
Or mail to firstname.lastname@example.org
Event start: 9/29/2012 1:30:00 PM
No data found