Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.
SQL Horizons Online – Europe/Middle East/Africa
Date: Thursday, August 1, 2013
Time: 2:00 pm – 3:00 pm (Mountain Time)
Featured Presentation: Dive into the Query Optimizer – Undocumented Insight
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Benjamin Nevarez is a database professional based in Los Angeles, California and author of Inside the SQL Server Query Optimizer, published by Red Gate books. He has more than 15 years of experience with relational databases and has been working with SQL Server since version 6.5. Benjamin holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Summit and SQL Server Connections. He blogs at http://www.benjaminnevarez.com and can be reached by e-mail at admin at benjaminnevarez dot com or on twitter at @BenjaminNevarez.
BAVC Virtual Chapter Meeting
Date: Thursday, August 8, 2013
Time: 9:00 am – 10:00 am (Mountain Time)
Featured Presentation: Drab to Dynamite! Managed Self-Service BI Using Real-World Data
Not every business has perfectly structured data. But with managed self-service business intelligence, you can now create rich, powerful analytics solutions that let you glean and share business insights from that data. This walk-through session will begin with actual small business data in Excel format and add data from Windows Azure to expand your analytics possibilities and show how to integrate data from SQL or other sources. PowerPivot will take the stage next, joining the data and enhancing it with calculated fields and KPIs. We’ll step through Power View to produce beautiful visualizations and deep exploration functionality. We’ll finish by sharing our solution, publishing it to SharePoint (using both PowerPivot Gallery and Excel Web Services) and via PowerPoint. Whether you’re an IT pro or business user and whatever your data’s structure, after this session, you’ll have the start-to-finish instruction manual to take any data set from drab to DYNAMITE!
Sandy Rivas is a Program Manager for Power View in the SQL Server Business Intelligence / Visual Analytics team at Microsoft. A 14+ year Microsoft veteran, Sandy has helped to ship 6 versions of Microsoft Office, working closely with a wide variety of Office products such as Access, Excel and SharePoint to name a few. Her primary focus was on driving globalization and world-readiness into the Office products. Her real-world use of Excel, PowerPivot and Power View for reporting product statistics division wide, is what fueled her passion for business intelligence and data visualization, driving her to become a Program Manager for Power View.
HASSUG & H-BI Monthly Meeting
Date: Thursday, August 13, 2013
Time: 10:30 am – 1:30 pm (Mountain Time)
11:40-12:45 General presentation (Topic 1)
12:45-1:15 Lunch\Networking Raffle #1
1:15-2:20 BI themed presentation (Topic 2)
2:20-2:30 Recap Announcements Raffle #2
Nashville SQL Server User Group (NashSQL)
Date: Thursday, August 23, 2013
Time: 10:30 am – 12:00 pm (Mountain Time)
Featured Presentation: Big Data || Hadoop
Aaron Crouch is the Business Intelligence Practice Lead for Aptera. Upon graduating from Purdue University, Aaron immediately began working on Data Warehouses and Business Intelligence (BI) implementations. Throughout his career, Aaron has strategically planned, designed, and developed BI solutions for multiple Fortune 500 companies both in the United States and abroad. His work spans the fields of retail, education, healthcare, and automotive vertical markets, and he has also acquired multiple Microsoft certifications. With over 10 years of experience, Aaron is proficient with both Microsoft as well as LINUX, UNIX, and Oracle tool sets.