SQLSaturday #332 Pre-Con Registration

Pre-Cons will be held on 10/24/2014 from 9AM - 5PM - Lunch will be provided

Update 10/06/2014 - Pre-Cons will be held at Dakota County Technical College in Rosemount, MN.  All registered attendees will receive venue information via email.

Update 10/11/2014 - If you have registered for a pre-con, you should have received a confirmation email as well as an email with details regarding the venue.  If you have not seen these emails yet, please contact us at sqlsaturday332@sqlsaturday.com ASAP.  We want to make sure everyone has the most current information!!

After reviewing the sessions below, select the one session you would like to attend from the drop down list.  You will then be redirected to our PayPal payment site.  You may either pay with a PayPal account or chose to pay with a major credit card.  To pay by check, please email us at sqlsaturday332@sqlsaturday.com

Please send any questions regarding the sessions or payments to: sqlsaturday332@sqlsaturday.com



Argenis Fernandez - SurveyMonkey - @DBArgenis

A Day of SQL Server Internals and Data Recovery

Take a deep dive into SQL Server internals and data recovery and learn how to handle a wide variety of data loss and corruption scenarios!

During the first part of the session, we will review some of the Internals of how SQL Server stores data on persistent storage. Then, we will cover how to be prepared for, prevent, and recover data lost due to deletion or corruption.

This is only a partial list of what we will go over:

  • Built-in functionality in SQL Server for preventing and detecting corruption that you may not even know about.

  • How to identify a specific transaction in the transaction log and recover data lost from that transaction.

  • Categories of corruption and how to manage recovery differently for each one.

Don't come empty handed. Bring your laptop and we'll practice geeking out on internals and recovering corrupt databases together.

About Argenis

Argenis Fernandez is a SQL Server MVP and Senior Database Engineer for SurveyMonkey based in Redmond, WA. He has worked with SQL Server for over 15 years and enjoys large SQL Server farms, high-end OLTP databases, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Prior to SurveyMonkey, Argenis previously worked at Ultimate Software, Coinstar/Redbox and Microsoft Consulting Services. He holds the MCM: SQL Server 2008 certification, and also founded the Security VC for PASS.


David Klee - Heraflux Technologies - @kleegeek

Virtualization for SQL Server DBAs

Microsoft MVP, VMware vExpert, and SQL Server performance expert David Klee leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with a strong emphasis on SQL Server performance.

Intended Audience

The intended audience of this course is information workers (both business and IT-centric) involved with architecting a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.

Course Topics

The following topics will be addressed during the course:

  •  Virtualization and Infrastructure Fundamentals
  •  Private Cloud Concepts

  •  The SQL Server Virtual Machine

  •  Security, Networking, Support, and Licensing

  •  High Availability and Disaster Recovery

  •  Performance Investigation and Tuning of the Entire Stack

Course Objectives

Upon completion of this course, attendees will be able to:

  •  Understand key virtualization and cloud concepts
  •  Determine the optimal infrastructure configuration for best performance

  •  Construct a SQL Server virtual machine template with best practices for agility and performance

  •  Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement

  •  Identify and remediate common virtualized SQL Server performance killers

  •  Understand proper virtualized capacity management techniques for long term management


Attendees with the following experiences will benefit the most from this course:

  •  Basic familiarity with the core components of a server
  •  SQL Server installation and configuration

  •  Exposure to SQL Server performance metric measurement and identification

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with virtualized SQL Server in their own environments.

About David

David Klee, VMware vExpert, is a SQL Server performance and virtualization expert.  With over seventeen years of IT experience, David spends his days handling performance and HA/DR architecture of physical and virtualized mission critical SQL Servers as the Founder and Chief Architect for Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis. When not geeking out on database and infrastructure technologies, David enjoys anything with a motor and is an aspiring amateur photographer. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.

David speaks at a number of national and regional technology related events. The numerous events include the SQL PASS Summit, VMware Partner Exchange, numerous SQL Saturday events, VMware User Groups, SQL PASS virtual chapter webinars, and many SQL Server User Groups.


Jason Strate - Pragmatic Works - @stratesql

Adam Jorgensen - Pragmatic Works - @AJbigdata

Architecting the Modern Data Warehouse

Today's modern data warehouse opens a wealth of possibilities for the value it brings to the business.  It is more than facts and measures, but the ability to empower users with data and to build analytics solutions that predict future outcomes.  But before all that can happen, you'll need to architect the data warehouse.

In this full day session, we'll examine the problems and solutions facing the modern data warehouse.  We'll look at how to balance data loading and computing processes with the needs for the platform.  Looking at how to work with both structured and unstructured data and when to continue to leverage relational databases versus file-base solutions, such as Hadoop.  From on-premise to appliance to cloud solutions, this session will examine how to select the right fit for the right solution. We’ll also discuss how to augment these solutions with Big Data and Cloud technologies including automating those (and giving you the scripts to do so J ) and adding common analytic data sources such as social media.

By the end of the day, you will understand what is possible in the modern data warehouse and how to architect solutions that fit your specific needs.

About Jason

Jason Strate is Solution Architect with Pragmatic Works. He has been working with SQL Server for more fifteen years. His experiences include architecting 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 SQL Server since 2009, he also has achieved the Microsoft Certified Master for SQL Server certification.

Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Conferences include the PASS Summit, TechEd North America, SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and many PASS user group meetings. Jason is an active blogger and author with a focus on SQL Server and related technologies.

About Adam

Adam is an award winning and globally recognized leader with success in growth focused data organizations. His current focus is on helping clients build a data culture where they are identifying, analyzing and driving their business opportunities through proper analytic solutions.  Adam's current focus is directing strategic and operational aspects of Pragmatic Works and serving the community as the Executive Vice President and Director of PASS, the world’s largest organization of data professionals. Both organizations drive for professionals to new and powerful ways to be better at what they do through a data driven lens.  He brings deep experience combining data platforms, business intelligence, big data solutions and cloud architectures into real world solutions for companies around the world.


Mark Vaillancourt - Digineer - @markvsql

Microsoft Excel: The Business Intelligence Platform For The Masses

From gathering and shaping source data through data modelling and visualizations, it is staggering how much you can accomplish in Excel. This Pre-Con will walk you through creating an interesting and powerful BI solution in Microsoft Excel 2013. Whether you are a business user or a technical developer, you will get good value from attending.

1. Power Query  

Using Power Query to gather source data from various sources both on-premise and in the cloud.  

Use various transformations on the Ribbon

Travel back and forth through time via Query Steps

The basics of Power Query Formula Language (M)

2. Modelling Data With Power Pivot

Importing Data from various sources

Linking Tables to data residing directly in Excel sheets

The importance of Date Tables

Best Practices

3. DAX 101

Introduce DAX syntax beginning with Calculated Columns including the mighty Related function

The basics of the Calculated Fields (Measures)

Row context/filter context

The power of the CALCULATE function


4. Power Pivot/DAX Design Patterns

Solving real-word problems with Power Pivot

Many to Many relationships

Parent-Child Hierarchies



5. Excel Pivot Tables/Charts

Connecting Excel to data sources like SSAS Cubes, Tabular Models, and the internal Power Pivot model

Pivot Table basics

Filtering methods and Slicers

Conditional formatting

Pivot Charts


6. Power View

The basic visualizations (Bars, Columns, Matrix, etc)

Advanced visualizations (Multiples, Cards, Scatter/Bubble Charts, etc 

Filtering views or the entire report

Design tips to take great advantage of Power View's capabilities

About Mark

Mark is a SQL Server MVP and a Business Intelligence Enterprise Consultant for Digineer, a Microsoft partner based in Plymouth, 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.

Subpages (1): SoldOut