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 upcoming Activities:
| Special Events coming up... |
| Upoming Events / Activities |
Registration / Information link |
|
5/9/2012
May PSSUG Meeting on 5/9 in Center City Phila
Sharon Dooley and Hilary Cotter (SQL Server MVP) to present.
|
To register, go to http://pssug20120509.eventbrite.com/
|
|
SQL Study Group for 70-433, SQL Server MCTS Developer exam is in progress and has Live Meeting sessions on average ever two weeks.
|
Certifications study group for 70-433 - Click here for more info
Register at http://pssug70433studygroup.eventbrite.com/
|
|
SQL Saturday #121 - Philadelphia
This event will be on June 9th at the Microsoft Malvern office.
Follow this link to the main page at the SQL Saturday #121 site. Registration is open.
|
Individual links for SQL Saturday
** Call for presenters is open **
** Call for Sponsors is open **
(Note: SQL Saturday now has the ability for personal sponsorships for $25 in addition to the company sponsorships)
** Call for Volunteers is open **
|
|
Calendar of events for 2012
2/8 (DeVry University)
3/15 (Microsoft)
4/11 (Microsoft)
4/24 (South Jersey)
5/9 (center city - tentative)
6/9 (SQL Saturday)
7/11 (Microsoft)
7/24 (South Jersey)
8/8 (Microsoft)
9/12 (Microsoft)
10/10 (Microsoft)
10/23 (South Jersey)
11/7 (Microsoft)
12/12 (Microsoft)
|
For those interested in presenting a session or sponsoring a monthly user group meeting, click on the link below.
Go to http://pssugmeetings.eventbrite.com/ to submit an inquiry.
|
| New PSSUG Board for upcoming term (Oct to Oct). |
|
|
President (Vince Napoli)
Vice-President (Joe D'Antoni)
Secretary (Said Salomon)
Treasurer (Bob Colahan)
Board Members at large
(positions open: coordinators for membership, sponsorship, web management)
Board members in total:
Joe D’Antoni
Sharon Dooley
Dave Euwings
Dominic Falso
Mark Fink
Alex Grinberg
Chuck Kruelle
Mark Kromer
Sebastian Meine
Vince Napoli
Said Salomon
Jyotsna Sankuratri
Boris Shvets
Bob Colahan
|
We are always willing to accept new board members if interested in serving. If interested in submitting your name, send an email to Vince.Napoli@pssug.org
Requirement to be able to submit your name is to have attended at least 3 PSSUG meetings in the last 12 months.
|
| |
|
|
|
|
May Phila SQL Server Users Group (PSSUG) Meeting
Location:
excelleRx
1601 Cherry St., Suite 1700
Philadelphia (Center City), PA 19102
(Regional Rail and parking lots available - see end of announcement)
(this is a secure building - you will need to register for this meeting)
Wednesday, May 9th, 5:30 - 8:30pm
Meeting Sponsor is: Antonio Sorbello - Digital Intelligence Systems Corporation (DISYS) (www.DISYS.com) - we specialize in staffing highly skilled IT professionals on a contract, contract to hire, and full-time basis.
Giveaway: We will be giving away a copy of the Best of PASS Summit 2011 to all who attend
Meeting Sessions:
1st Session: Sharon Dooley- Index Design (aka Should my Primary Key always be my clustered index?)
Abstract: This presentation will provide information about the various types of queries and show you which type of indexes are best for each query type. In addition, it will explore why covering indexes are highly beneficial in a SQL Server environment. The presentation assumes that the attendees understand the difference between clustered and non-clustered indexes.
Bio: Sharon has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox Press). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her three cats.
2nd Session: Hilary Cotter - "SQL Server Replication Technologies"
Abstract: Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and troubleshooting techniques.
BIO: Hilary Cotter: 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 been a SQL Server MVP for 11 years now.
Transporation Information:
Region Rail - Septa Suburban Station (approximately 2 blocks away).
Parking:
Parkway Parking Garage (Broad & Race Streets)
150 N. Broad Street
Philadelphia, PA 19102
(215) 569-8400
Gateway Parking Garage (16th & Spring Streets)
1550 Vine Street
Philadelphia, PA 19102
(215) 246-0300
|
|
|
January South Jersey SQL Server Meeting
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035
Tuesday, April 24, 5:30 - 8:30pm
*
*
*
*
Meeting content
---------------------------------------------------------------------
*
*
Meeting Sessions:
Talk 1:
Hilary Cotter:
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 been a SQL Server MVP for 11 years now.
Here is a description of the presenation.
Performance tuning is difficult task. In this presentation SQL Server MVP Hilary Cotter presents tools to help you to get to the root causes of performance problems. He presents common strategies for tuning queries, cleaning up code, handling blocking, deadlocking, and other common performance problems.
Talk 2:
Increasing High Availability and Decreasing Complexity with SQL Server 2012
Description:
In this session I will introduce the new SQL Server High Availability and Disaster Recovery solution (AlwaysOn) in SQL Server 2012. I will demo the setup of an AlwaysOn Availability Group and show how an application can reconnect following a failover. Additionally, I will show how to configure read-only secondaries and demonstrate the use of prioritizing the secondaries for access.
Speaker BIO: William Emmert
Bill is the Technical Director and an SQL Technology Architect in the Philadelphia Microsoft Technology Center (MTC). He has been working at Microsoft for the last 14 years helping customers of all sizes to develop and implement solutions around Microsoft SQL Server and Business Intelligence. Bill has worked in the computer industry for 25 years with experiences in mainframe development, LAN architecture and administration, client server application development, project management, consulting and IT management. He started his career at Microsoft in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, Bill joined the SQL Server development product group as a member of the SQL Server Customer Advisory Team (SQLCAT), and in 2010 worked as a SQL Architect in the New York MTC before taking on his current role in the Philadelphia MTC.
Sponsor: Antonio Sorbello
Robert Half Technology (Mt Laurel office) - we specialize in staffing highly skilled IT professionals on a contract, contract to hire, and full-time basis.
|
|
|
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.
|
|