2017 Calendar (PASSMN Meetings)

  • PASSMN Meeting: Understanding XML Query (Rick Bielawski)

    4:00-4:10 Kickoff

    Abstract: If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session. After this session I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.

    About Rick: Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQL Saturday events.

    5:25-5:35 Closing
  • PASSMN Meeting: Keeping Track of History – Temporal Tables in SQL Server (Steve Hughes)

    4:00-4:10 Kickoff

    Abstract: Microsoft introduced temporal tables in SQL Server 2016. Whether you manage history in a separate table or wish you could revert back to the correct version when users make a mistake, you will find that temporal tables are a simple implementation to support those needs. We will look at these and other scenarios then walk through the creation, querying, and management of temporal tables.

    About Steve: Steve is a Principal Consultant Lead at Pragmatic Works. He is currently responsible for guiding the Principal Consultant team and working with other areas in the organization to build out our data and analytics offerings. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored three books and delivered many presentations on SQL Server and data architecture. He also provides insights from the field on his blog at http://www.dataonwheels.com

    5:25-5:35 Closing
  • PASSMN Meeting: Azure Analysis Services and Agile Data Development (Ross McNeely and David Winegar)

    4:00-4:10 Kickoff

    Abstract: Join Ross McNeely and David Winegar from Tail Wind as they present on Azure Analysis Services and Agile Data Development. Ross will review how and where Azure Analysis Services fits into your company’s data capabilities. A quick demo on how to spin up Azure Analysis Services, and how to build and deploy a Tabular model from SQL Server Data Tools (SSDT) to Azure. David will cover an agile hybrid approach to delivering data solutions rigorously, inexpensively, and quickly. Almost everyone has two data environments but they often need 3 or 4 environments to keep up with requests, while keeping costs down. David will start by laying out SQL Server and SSIS strategies/capabilities to show you how an Agile hybrid model will help deliver solid data solutions.

    About Ross: Ross is a Tail Wind Principal Consultant in Data Management, and the Practice Manager of Business Intelligence. He works with external vendors, customers, and partners to integrate disperse data sources. Throughout most of his 15-year career he has been specializing in Information Management, and implementing solutions for Information Strategy, Information Asset Management, Enterprise Data Management, and Business Intelligence.

    About David: David is a Solutions Architect for Data and the Cloud, with Tail Wind. He has been delivering SQL Server and BI solutions for the better part of two decades and has been working with the cloud for the past 5 years. His passion for SQL Server and the Cloud stem from his love, some might say OCD-ness, of the efficiency, scalability and cost savings able to found by utilizing the synergies of both platforms.

    5:25-5:35 Closing
  • PASSMN Meeting: Understanding XML Query (Rick Bielawski)

    4:00-4:10 Kickoff

    Abstract: If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session. After this session I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.

    About Rick: Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQL Saturday events.

    5:25-5:35 Closing
  • PASSMN Meeting: Azure SQL Database Elastic Boogie (Mark Vaillancourt)

    4:00-4:10 Kickoff

    Abstract: Azure SQL Database provides fantastic scalability and flexibility for your data tier. You can scale it up with ease when you need more power and scale it down again when load returns to normal. With the pay as you go model, you pay for each database based on performance characteristics. But when you have a scaled out architecture of hundreds, thousands, or tens of thousands of databases, how can you keep costs from spiraling out of control? How can you query across all of those databases? How can you MANAGE so many databases? How can you write your application to make the right decisions about where to put which data? This session will introduce you to four key pieces of this overall story: Elastic Database Pools, Elastic Query, Elastic Database Jobs, and the Elastic Database Tools .Net library. With these tools, you take your Azure SQL Database data tier to the next level of scale and manageability.

    About Mark: Mark is a Data Solution Architect for Microsoft and a former Data Platform MVP. He has been speaking on Microsoft data technologies at conferences and user groups for a decade. With a background in Theater and Improvised Comedy, Mark makes sure his presentations are informative AND fun.

    5:25-5:35 Closing
  • PASSMN Meeting: Moving Your BI Solutions to Azure (Dave DuVarney)

    4:00-4:10 Kickoff

    Abstract: As companies start to embrace cloud based technologies, IT organizations will need to understand the available solution capabilities. Microsoft Azure is full of tools that improve data movement, storage, analysis and consumption. Some traditional on-premise concepts still apply and others do not. In this session, we will look at real world customer examples embracing Azure and provide insights into how organizations can start planning their move to the cloud.

    About Dave: Dave DuVarney is President and Co-Founder of Talavant. Dave has delivered numerous business intelligence projects in both a technical and functional leadership role. Dave's latest technical focus has been on leveraging Microsoft Azure to support Business Intelligence need. Along with technical delivery, Dave has assisted clients in establishing Data Warehousing and Business Intelligence initiatives. This includes working with executive stakeholders to define objectives, assisting in the identification of team roles and implementing development best practices using Agile Scrum. Dave is currently training for his 4th marathon and hopes to not blow out a hip or calf muscle along the way.

    5:25-5:35 Closing
  • PASSMN Meeting: SQL Server DBA Quiz Show (Eric Zierdt)

    4:00-4:10 Kickoff

    Abstract: You are invited to be a participant on the SQL Server DBA Quiz Show; this interactive session will test your knowledge of SQL Server. We will be using an online tool to allow you to submit your answers to questions via a mobile device or laptop. If you have ever played trivia in a bar or restaurant you'll be familiar with the setup for this.

    This session promises to be fast paced and fun and hopefully you will even learn something. This session will also be of value to people who need to interview or be interviewed for SQL Server positions as the questions may be the type of things you might hear in an interview.

    About Eric: Eric is the SQL Server Architect for Boston Scientific, a self-proclaimed Level 70 Database Slayer, he enjoys development, performance tuning, and troubleshooting SQL Server.

    5:25-5:35 Closing

© 2015 PASSMN All rights reserved.