www.sqlpass.org    Professional Association for SQL Server
 Meeting Archive

October 18th, 2012

Carlos Chacon - Your SQL Server--fair or foul?

Carlos Chacon is an independent consultant specializing in the SQL Server world of data and has experience in many different technology areas. In the database world he has earned his MCSDBA and is a Microsoft Certified Technology Specialist. He has been to 4 continents, is a member of the Richmond SQL Server User Group and can eat his weight in raspberries (not yet proven).  He blogs at http://www.sqldatapartners.com.

September 20th, 2012

John Baute - Performance Point Dashboards

John Baute is consultant with Stone Technologies, a leading system integrator of manufacturing software and industrial automation. John is a MCITP and specializes in developing custom solutions with SQL Server and Microsoft Business Intelligence products in the consumer products industry.

August 16th, 2012

Chris Hylton - SQL, the Good, the Bad, and the Ugly

Chris Hylton is a local consultant, contract developer, and math geek.  In addition to working heavily in the .NET space for the last decade, Chris also has 20 years of experience working with relational database technologies including SQL Server, Oracle, and DB2.  He is the president of the Roanoke Valley SQL Server User Group and is also active in the Roanoke Valley .NET User Group.

July 2012

Cancelled due to venue/speaker availability

June 21st, 2012

Wayne Sheffield - Windowing Functions in SQL Server 2012
Download Presentation
Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at
www.sqlservercentral.com, where he also is active on the forums assisting the community.

May 17th, 2012

Art Lucia - SQL Server Database Sharding

Art Lucia is a Principal Consultant with Excella Consulting and is the Extension Center Director for their Blacksburg office.

April 19th, 2012

Jarom Richardson - Constructing an SSIS Package, Start to Finish

Jarom is a Systems Manager at Ply Gem Windows, a leading manufacturer of the building products industry.  He has been an IT professional for over 10 years and has been working with SQL Server since 2004.  Over the past year he has lead Business Intelligence initiatives at Ply Gem using SSIS, SSAS and SSRS.  He holds a Master of Information Technology degree from Virginia Tech.

March 15th, 2012

Cancelled due to Roanoke Code Camp

February 16th, 2012

Mike Lawton - Take Your Database to the Cloud

Mike Lawton is Manager of Software Engineering for DaProSystems, a Public Safety Software company headquartered in Roanoke, Virginia.  He’s a self-taught, polyglot, “why not” developer with 10 years experience building solutions on the .NET Framework.  His current projects cover the spectrum of desktop (WPF), server (Windows Services, WCF), mobile (Android – Java & Mono), web (ASP.NET MVC), and cloud (Azure).  You can find him on Twitter at https://twitter.com/#!/malawto

January 19th, 2012

Brian Lanham - RedGate SQL Developer Bundle Walk-Thru

December 1st, 2011

Butch Adams - An Introduction to Office 365

Before hanging his shingle as an IT consultant in January 2011, Butch amassed over twenty-five years of Systems Engineering experience in the defense and private sectors. He implemented some of the first PC-based networks for the Navy in the eighties, wrote software for automated electronic test equipment, and has expertise in IT department resuscitations, security remediation and platform migrations.  Butch is Microsoft-certified on Exchange, SQL Server, Windows XP, Vista, 2003 Server, SharePoint and Dynamics SL and GP.  His primary focus is providing start-ups and small businesses with excellent IT solutions that help protect and manage their intellectual property. Butch also provides IT consultative, training and design/installation services.

November 16th, 2011

Butch Adams - Backups

Before hanging his shingle as an IT consultant in January 2011, Butch amassed over twenty-five years of Systems Engineering experience in the defense and private sectors. He implemented some of the first PC-based networks for the Navy in the eighties, wrote software for automated electronic test equipment, and has expertise in IT department resuscitations, security remediation and platform migrations.  Butch is Microsoft-certified on Exchange, SQL Server, Windows XP, Vista, 2003 Server, SharePoint and Dynamics SL and GP.  His primary focus is providing start-ups and small businesses with excellent IT solutions that help protect and manage their intellectual property. Butch also provides IT consultative, training and design/installation services.
Ron Bruintjes - New Features in SQL Server Denali (2012)
Ron is a Developer/Analyst for Medeco Security Locks, a high security lock manufacturer in Salem, VA. He has about 20 years experience with the Progress RDBMS platform, and has been working with SQLServer off and on for the last 3 years.  In his day-to-day tasks is responsible for the corporate ERP system (MXP), and the data analysis tools written against that using the MS SQL Server suite. You can find him on Twitter at
https://twitter.com/#!/ronaldb

October 19, 2011

Paul Edge - Dynamic Table Design

Paul Edge is a local software consultant with experience in SQL Server, SSIS and .NET technologies.  He has created applications for both large and small clients in retail, government, construction, manufacturing, and health services industries.

September 21, 2011

Various (Round Table) - SSMS tips, tricks, walk-thru

August 17, 2011

Wayne Sheffield - Banish RBAR

Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community.

July 20, 2011

Brian Knight - What's New in BI in Denali - Virtual Presentation

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at SQLShare.com. He is the author of a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

June 15, 2011

Joel Cochran - SSIS for real:  A walk through a real world project
Joel is an Expression Blend MVP, an INETA Community Champion, and a Microsoft Certified Technology Specialist (MCTS) in Windows Forms and WPF. He is the founder of BlendSIG, a virtual Special Interest Group focused on Expression Blend and author of "Expression Blend in Action" by Manning Publications. He is also the author of "The Practical MVVM Manifesto" (
http://practicalmvvm.com). He has been developing for Windows since 2003 and is a self-proclaimed "Blend Evangelist". A frequent speaker at User Groups and Code Camps, he enjoys teaching and writing about.NET and other topics. You can find him online at http://www.developingfor.net or on Twitter at http://twitter.com/joelcochran. Joel has served as the Director of Operations for Stonewall Technologies, Inc., an ISV, in Staunton, VA, since 2000.

May 18, 2011

Chris Hylton - Reporting Services, Getting Started

Chris Hylton is a local consultant and software developer.  He has worked with Reporting Services in both SQL Server and Oracle environments as well as deployment and application integration with Windows and Web applications.

April 20, 2011

Wayne Sheffield - Table Variables and Temp Tables, What You Need To Know!

Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community.

February 15, 2011

Jessica M. Moss spoke in February on 'Who Need a Data Warehouse?'

Jessica M. Moss, a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker of Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and has authored technical content for multiple magazines, websites, and the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution". Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences.

You can read about her work on her blog, http://www.jessicammoss.com.

January 15, 2011

Andy Leonard joined us again in January to present on SSIS Design Patterns.
Andy is an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, SQL Server MVP, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs at SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.
You can find more informatoin about Andy at his website
http://andyleonard.net.

December 2, 2010

Our December meeting was a joint effort with RVNUG and RVSPUG on Dec 2nd.
Andy Leonard, a SQL Server MVP from Farmville spoke at the joint meeting.Database Design for DevelopersThis session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.

November 18, 2010

Our first meeting was held on Nov 18th. The meeting was a great success with excellent topics from Paul Edge (FileStream), Brian Lanham (Data Encryption), and Chris Hylton (Spatial data types and SSRS mapping).

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASS

Microsoft

Pragmatic Works

TEKsystems

Red Gate Software

Lotic Factor

Magnolia Technology, Inc.

Apex Systems, Inc.

O'Reilly Media