You are here:   Presentations > 2012
Register   |  Login

Presentations from 2012 SQL User Group Meetings



  • SQL Server 2012 High Availbility   - Art Rask(Microsoft Technology Architect)

Al NoelMonday,  November 26th, 2012 at 7:00 PM

SQL Server 2012 includes significant new features for high availability (HA) and disaster recovery (DR) scenarios.  SQL 2012 “AlwaysOn” technologies include improved Failover Clustering and the new Availability Groups feature.  These enable more flexible and robust HA/DR architectures in both single- and multi-site scenarios.  This talk will review these new capabilities, demo some basic scenarios, and discuss typical deployment architectures.

Art Rask is a software and database architect with 20 years of experience in the industry, mostly spent developing on the Microsoft platform. Art worked in the solution provider community in the 1990’s, and joined Microsoft in 2000, working in Microsoft Consulting Services for nine years. He is now a Technology Architect at the Microsoft Technology Center in Reston, VA focused on the MS data and business intelligence platforms.

Al NoelMonday,  Ocober 22th, 2012 at 7:00 PM

Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool.This session will not walk through installation of the tool, but will instead describe the different visualizations provided and how to use each one..

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence.  Jessica's expertise includes dimensional modeling, ETLs, semantic modeling, report design, and helping customers across industries successfully implement and enhance their business intelligence solutions.  Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored four technical books.


Al NoelMonday,  September 24th, 2012 at 7:00 PM

This presentation discusses a number of proven practices used to create, maintain, monitor and decommission SQL Server instances supporting true mission critical applications. It is based upon several years of providing 24x7 support to a US Federal government law enforcement agency who has several SQL Server instances that have very high availability requirements. It does not discuss the various technical means of providing high availability such as database mirroring, failover clustering, log shipping or SQL Server 2012 AlwaysOn. This presentation discusses the techniques, policies and tools used by a team of production SQL Server DBA’s who have been able to delight a truly demanding customer with an important mission.

Al Noel is a Principal Consultant with Microsoft Consulting Services (MCS) and has worked for Microsoft for 13 years. Al has been working with SQL Server approximately 15 years. He has worked in IT 32 years having been a developer at NSA, a data center manager in Europe, a data center manager at the Pentagon, a development lead with a small system integrator and a Visiting Scientist at the AI Lab at MIT. 


  • Building the Fastest SQL Servers -  Brent Ozar (SQL Server MCM )

Monday,  August 27th, 2012 at 7:00 PM

SQL Server speed boils down to how fast we can get data in and out of storage.  Sooner or later, we're going to run out of memory to cache.  In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries.  I'll show you how to test your own servers and compare them to servers I've worked with in the field.


    Define common SQL Server use patterns
    Understand the right hardware for each pattern
    Recognize the server designs from Microsoft and hardware partners that we can reuse
    Learn how to test our own hardware

Brent specializes in performance tuning for SQL Server, VMware and storage.  He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP.  He likes travel, Jeeps, Apple gear, jokes and writing about himself in the third person.

  • Designing an SSIS Framework -  Andy Leonard (Linchpin People)

Monday,  July 23rd, 2012 at 7:00 PM

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.


3. An introduction to Design Patterns-based development.

2. Real-world demonstrations of applying patterns-based design to data integration requirements.

1. Increase data integration solution quality, increase maintenance and management efficiency, learn a process to deliver repeatable, stable, and audit-able data integration solutions.

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.

  • Virtualization for SQL DBAs -  Joey D'Antoni (Comcast)

Monday,  June 25th, 2012 at 7:00 PM

Want to know about VMWare and what it means for your databases? This session will go through the hardware and terminology around this technology. Learn how to optimize your SQL Servers for VMs and what to tell your storage engineers.

Joey D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Comcast. He holds a BS in Computer Information Systems from Louisiana Tech University, and a MBA from North Carolina State University. He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays.

Resources from NoVA SQL—Virtualization for DBAs

  • Aviation Disasters - And IT Lessons From Them -  Mike Walsh (Straight Path Solutions)

Monday,  May 21st, 2012 at 7:00 PM

What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; even if a freak accident occurs, training and preparation can make all the difference - it's the same for us! In this session we’ll have a group discussion through a few actual aviation disasters and see what skills, attitudes and thought processes led to them. We'll look at some success stories and see what was different. We'll see how these attitudes and decisions impact us at work and talk about how to identify them in ourselves and our teams. Then we'll figure out how to prevent them in our day jobs.

Mike is an experienced SQL Server professional and has worked with SQL Server for over 12 years. He has performed the duties of DBA, Developer, Architect and Performance Lead but always leans on his DBA experience. Mike is a partner in the exciting SQL Community focused venture called Linchpin People - He is also an independent consultant through his Straight Path Solutions consultancy. He was recognized as an MVP by Microsoft in April of 2011 for his SQL Server community involvement. 

  • Bringing Together SSIS, MDS and DQS -  Kevin Goff (SQL Server MVP)

Monday,  Apr. 23rd, 2012 at 7:00 PM

In this session, I'll cover three major new features in SQL Server 2012.  First, I'll cover the new Column Store index and how it can dramatically increase performance in data warehousing scenarios. Second, I'll cover the new T-SQL language features in SQL Server 2012. Finally, I'll show some of the new features in SQL Server Integration Services. Microsoft "hit a home run" with many new features in SQL 2012, and this presentation will definitely raise your interest level in upgrading to SQL Server 2012.

Kevin S. Goff ( is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events
in the Mid-Atlantic region.  

  • What's new in SQL Server/SSIS 2012 -  Jon Tupitza (Microsoft)

Monday,  Feb. 27th, 2012 at 7:00 PM

Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance, and is an important part of the SQL Server 2012 release: This session revolves around a demo which brings together our EIM functionality in SQL Server 2012 and which tells our Credible, Consistent Data story. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.

1. Describe the differences between the EIM products.
2. Explain how the EIM products integrate together.
3. Telling the EIM story to your customers.

Jon Tupitza is a Senior Consultant at Microsoft where he specializes in delivering Business Intelligence (BI) solutions that leverage Microsoft SQL Server and SharePoint technologies. He has over 13 years’ experience in delivered both online transaction processing (OLTP) and online analytical processing (OLAP) systems, as well as with the physical configuration, implementation and administrative support of Microsoft database management systems. Jon began working with Microsoft SQL Server 6.5, and is currently a member of Microsoft’s internal OneTAP Mentor program for SQL Server 2012.