SAVE $150 and support PASSMN by registering with our PASS Summit 2016 Discount Code >> LC15TNJ3 <<

2016 Calendar (PASSMN Meetings)

  • PASSMN Meeting: Kicking and Screaming: Replacing Profiler with Extended Events (Erin Stellato)

    4:00-4:10 Kickoff

    Abstract: There have been three new releases of SQL Server since the introduction of Extended Events in SQL Server 2008, and DBAs and developers alike *still* prefer Profiler. Friends, it's time to move on. If you've tried Extended Events and struggled, or if you've been thinking about it but just aren't sure where to begin, then come to this session. Using your existing knowledge and experience, we bridge the gap between Profiler and Extended Events through a series of demos, starting with the Profiler UI you know and love, and ending with an understanding of how to leverage functionality in the Extended Events UI for data analysis. By the end of this session, you'll know how to use Extended Events in place of Profiler to continue the tasks you've been doing for years--and more. Whether you attend kicking and screaming, with resignation because you've finally given up, or with boundless enthusiasm for Extended Events, you'll learn practical techniques you can put to use immediately.

    About Erin: Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 13 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, is on the board of the Ohio North SQL Server User Group, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

    5:25-5:40 Dell Software
    5:40-5:50 Closing
  • PASSMN Meeting: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud (Paul Timmerman)

    4:00-4:10 Kickoff

    Abstract: For years it seemed that the only message SQL Server professionals were hearing was "to the Cloud.... you must get to the Cloud!". However, if you work in a highly regulated industry, or one simply averse to change, this likely was not an option for you. The good news is, Microsoft heard your feedback and has been busy incorporating Cloud connectivity, compatibility, and functionality into the box product.

    Come spend the hour with me and you'll learn how to leverage the power of the Cloud with your on-premises SQL Server install. We'll cover backup and restore options with Windows Azure Storage, using Windows Azure VMs for high availability, how to store your data files in Windows Azure Storage, and more. We'll start with SQL Server 2012 and work our way up to the most recently released bits for SQL Server 2016. You can have the best of both worlds with a SQL Server Hybrid Cloud strategy!

    About Paul: Paul Timmerman is a Microsoft Data Platform MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and is currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQL Saturday conferences.

    5:25-5:35 Closing
  • PASSMN Meeting: Azure SQL Data Warehouse Overview (Jason Strate)

    4:00-4:10 Kickoff

    Abstract: Microsoft recently announced the SQL Data Warehouse Platform as a Service (PaaS) feature for Microsoft Azure. This platform provides an on-demand Massively Parallel Processing (MPP) platform for build data warehouses that can handle from 10s of TBs of data up to PBs. This session will provide an overview of SQL Data Warehouse with a discussion on the value that Massively Parallel Processing (MPP) brings to your data warehouse and why the cloud may be the best platform for your solution. In this session, we'll also dig into the capabilities of SQL Data Warehouse and compare those to other offerings.

    • Scale from terabytes to petabytes
    • Save on costs through on-demand scale
    • Take advantage of architecture designed for scalable performance
    • Gain a cloud integrated data warehouse solution

    About Jason: Jason Strate is a data platform architect and administrator. He has been working with Microsoft SQL Server for more fifteen years. His experiences include designing and implementing transactional and data warehousing solutions on Microsoft Data Platform technologies, including SQL Server and Parallel Data Warehouse. A recipient of the Microsoft Most Valuable Professional award for Data Platform (formerly SQL Server) since 2009, he also has achieved the Microsoft Certified Master for SQL Server certification.

    5:25-5:35 Closing
  • PASSMN Meeting: A Bigger Boat: Data Visualization Lessons From the Movie Theater (Mark Vaillancourt)

    4:00-4:10 Kickoff

    Abstract: When Chief Brody first sees the shark in Jaws, he carefully backs away from the stern of the Orca and quietly, but certainly, tells Quint, "You're gonna need a bigger boat." That one line, combined with a terrific delivery by Roy Sheider, packs a great deal of contextual information into six words.

    Making efficient use of space to convey meaning is a vital part of good Data Visualization.

    In this session, we will discuss the fundamentals of human visual perception, including the important distinction between Pre-Attentive and Attentive Processing. We will use examples from feature films like Jaws, Alien, and Sneakers to show important aspects of visual analysis around Color, Form, Position, and Motion. We will then put these concepts into practice via demos in Excel and Power BI. By the end of this session, you will have a solid understanding of the importance of data visualization and how to use it to enable better decisions.

    About Mark: Mark Vaillancourt is a SQL Server MVP and a Business Intelligence Consultant for Tail Wind Technologies, a Microsoft partner based in Minnetonka, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.

    5:25-5:35 Closing

© 2015 PASSMN All rights reserved.