www.sqlpass.org    Professional Association for SQL Server

Welcome to the Performance Virtual Chapter

Source: http://www.flickr.com/photos/adamkr/4595762893/We focus on Performance Tuning with regards to SQL Server, attached storage area networks, database design, and IP network. 

The Performance Virtual Chapter Mission Statement: Empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ETEvery month there is a drawing for a $50 Amazon gift card sponsored by Confio.  To be eligible, you just need to attend our monthly webcast.  A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.

You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

 February 2012 Presentation
Add to Calendar
Filegroups: Putting The Pieces TogetheriCal
by Jes Borland
February 23, 2012 at 2:00 PM EST
 
Abstract
 
Every DBA must know how to create and maintain filegroups because they affect performance, maintenance, and security of your data. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them, move objects to them, perform maintenance, and walk through piecemeal restores.
 
 
Bio
Jes Schultz Borland is a Technical Consultant at Blue Door Consulting in Oshkosh, WI. She holds an AAS - Programmer/Analyst degree. She has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, Director of Communication for MADPASS, and Director of Social Media for the PASS WIT virtual chapter. She's a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid tweeter, blogger and runner.

 View Presentation

Sponsored by Confio

 

 

 March 2012 Presentation
Eating the Elephant: SQL Server Table Partitioning
by Mike Fal
March 22, 2012 at 2:00 PM EST
 

Abstract

Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions. 

 

Bio
Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience along with some brief excursions into Oracle and Netezza. He has worked in several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.

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

 PASSChapterLogo100.jpg

 

 

 Contact the Performance VC




Send