www.sqlpass.org    Professional Association for SQL Server
 Banner

 

Philadelphia SQL Server User Group (PSSUG)
The Philadelphia SQL Server User Group (PSSUG) is a community of SQL Server database professionals, specializing in DBA, Database Development, and Business Intelligence topics. We meet monthly in different locations throughout the Greater Philadelphia and South Jersey area. PSSUG is an Official PASS Chapter. We welcome you to join our group email list by sending an email to pssug-subscribe@yahoogroups.com or joining the PSSUG group on www.Linkedin.com or click on the icons below.   By doing so, you will receive information on group meeting, group activities, and member contributions.  
 
                

 

 Overview of Activities

Overview of upcoming Activities:

 

Upoming Events / Activities Registration / Information link

4/22

PSSUG online certification workshop 

 

Certification study group to start in 2nd half of April.  This will be a live meeting format.  First three dates will be 4/22, 4/29, and 5/13.   Registration info at http://pssug70462studygroup.eventbrite.com/ Eventbrite - PSSUG 70-662 Certification study group

5/8/2013

May PSSUG meeting on May 8th at Microsoft

 

 Go to pssug20130508.eventbrite.com for details and to register.  Eventbrite - May 2013 Phila SQL Server Users Group Meeting

 

6/1/2013

SQL Saturday on Saturday, 6/1 at Micosoft

 

 Go to http://www.sqlsaturday.com/200/eventhome.aspx for info and registration. 
 
Calendar of events for 1st half of 2013
1/9     PSSUG (Microsoft)
1/22   SJ SQL (Haddon Heights, NJ) 
2/13   PSSUG & PBIUG (Microsoft)  *** dual meeting with PBIUG ***
3/13   PSSUG (Center City)
4/10   PSSUG (Microsoft)
4/23   PBIUG (Bala Cynyd)
4/23   SJ SQL (Haddon Heights, NJ) 
5/8     PSSUG (Microsoft)
6/1     (SQL Saturday #200 at Microsoft) - no monthly meeting in June.
 
 
Certification online Workshop
4/22, 4/29, and 5/13
 
 
 
 

 

 

 

 
 May 2013 PSSUG Meeting

May Phila SQL Server Users Group (PSSUG) Meeting
 

Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
Wednesday, May 8th, 5:30 - 8:30pm    

 
 

 
Meeting Agenda:

  
Short Session - The SQL Clinc

 
- As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting.  If you have a problem that you would like to be solved, bring ias much detail as possible.  For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
  
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
 
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
 
- if you need help with indexing, bring
 
- the query itself.
 
- a problem description and requirements (does not need to be written down, but would be helpful)
 
 
 
First Session - Joe D'Antoni 
 
Topic:  Using Compression to Improve Database Performance

Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
 
 Bio:  Joe D'Antoni is a frequent speaker at SQL Saturday events. He is a SQL Server Architect at Comcast in West Chester, Pennsylvania with 10+ years of experience working on a wide variety of database platforms. His specialties include DR, HA and Virtualization
 
  

 

Keynote Session - Hilary Cotter 
 
Topic:   Stress testing SQL Server
 
How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, SQL Server MVP Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine what your bottlenecks are and how high you can ramp up your workload.


 Session Level: Advanced


 Bio: SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has worked on some of the largest and challenging SQL Server topologies in the world. He has been a SQL Server MVP for 12 years now
 
 
 
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.