Himalayan SQL Server User Group is a team of Professionals in Microsoft SQL Servers working together with an objective to become a solution provider in SQL Server through forums and SQL Chapter members. Our goal is to  produce more skilled and trained manpower in SQL Server, produce and promote MVP, launch social campaigns to create awareness of Microsoft related product and provide solution for software related problems to each individuals and corporate according to their needs.

We are a non-profit trading group working to help the community through the expertise of its members.

 

About the presentation

 

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.

LinkedIn: http://np.linkedin.com/in/shreekhanal

Using BIML as an SSIS Design Patterns Engine (Duration 60 minutes)

=====================================================

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.

Objectives:
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
.

Program Details

Date:      29th September, 2012

Time:     1:45:00 P.M

Venue:   Citizens Bank International Limited, Sharda Sadan Kamaladi, Kathmandu, Nepal

Please register immediately at http://sqlpassnepal.org/Meetings/Himalayan-SQL-Server-User-Group-Monthly-Meetin-(2).aspx

Or mail to ug@sqlpassnepal.org

Welcome to the Himalayan SQL Server Users Group

PASSChapterLogo100.jpg 

 

 

sql_ca_sm.gif

Swag sponsor