The PSSUG Live Meeting WorkShop is a bi-monthly online meeting to take a deaper dive into a specific topic area.   The workshops will be focusing on certification exam prep for both SQL Server and Business Intelligence.   They are free and open for anyone to attend.    Contact Said.Salomon@pssug.org if you have questions on the workshops.

If study material is recommended, please acquire the material to be able to better follow the sessions.      

Certification study group for 70-433 Microsoft® SQL Server® 2008 Database Development.   Study group to start 11/21/2011.

 

Note: Once you have registered once, you are active for the study group for the life of the group. You will not need to re-register for each meeting.

 

 

Send a message to pssug.workshops@gmail.com if there is a issue with connecting to the study group for a session.

 

 

Note: Meeting is via Live Meeting, and possibly a location to be identified later. Registered individuals will be sent the live meeting connection information after registration.

 

 

Topic Date
Data types, tables, Views 11/21/2011
Indexes, constraints, partitioning 12/5/2011
Store Procedures, Function, Triggers 12/19/2011
CLR, Transactions 1/16/2012
Select, Insert, Update, Delete, Aggregate 1/30/2012
Join, Union, Merge part1 TBA
Join, Union, Merge part2 TBA
Subqueries TBA
CTE TBA
Advanced Functions TBA
Execution plans TBA
DBMail TBA
Full Text Search TBA
using PowerShell with SQL TBA
Service Broker TBA
CDC TBA
XML part 1 TBA
XML part 2 TBA
Performance and Tunning TBA
Cram for the Exam TBA

 

 

Facilitators wanted:

Alex Grinberg and Said Salomon are the full time facilitators for the study group. We are looking for additional instructors for the workshops to cover a lesson or two; if you would like to be a PSSUG Workshop instructor please contact me at:

pssug.workshops@gmail.com

Join us in the PSSUG workshops as we review the MCTS 70-433 exam material over the next 6+ months. The workshop series will be doing a certification study group to prepare people to take the MCTS certification exam for 70-433.

We will be using the MCTS 70-433 Self-Paced training kit (book) from Microsoft Press. Go to the following link for a possible location to purchase the study material: http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-433/dp/0735626391

 

 

 

70-448 Study Group - BI

http://pssug70448studygroup.eventbrite.com/

 

 

 Schedule is tentative:

Date

SSIS - May 2011  

Implementing an SSIS Solution    

5/2/11

6:00-9:00 PM

Configuring, Deploying, and Maintaining SSIS

5/16/11

6:00-9:00 PM

Administering, Securing, and Executing SSIS Packages

Note: Due to Memorial Day holiday, the session is pushed back to Wednesday

Wed, 6/1/2011

6:00-9:00 PM

 

SSAS - June / July 2011  
 

Implementing an SSAS Solution

6/13/11 

6:00-9:00 PM

 

Configuring, Deploying, and Maintaining SSAS

6/27/11

6:00-9:00 PM

Managing SSAS Storage, Processing, and Deployment

7/11/11

6:15-9:00pm

Administering and Securing SSAS

8/8/2011

6:15- 9:00pm

Data Mining (cancelled due to complications with huricane Irene) 

8/29/2011

6:15pm-9:00pm

SSRS - Sept 2011  

Developing SSRS Reports / Extending SSRS Reports

9/12/11

6:00-9:00 PM

 Scheduling and Securing SSRS reports / Configuring, Deploying, and Maintaining SSRS

9/19/11

6:15-9:00 PM

   

NOTE: Additional sessions will be added as needed, schedule is subject to change. 

 

 

 

 

 

70-432 Study Group - SQL Server Admin

http://pssug70432studygroup.eventbrite.com/ .

 

Topic

Date

Installing and Configuring SQL Server 2008

1/31/11 6:00 PM

Maintaining SQL Server Instances

2/21/11 6:00 PM

Maintaining a SQL Server Database

2/28/11 6:00 PM

Managing SQL Server Security part 1

3/14/11 6:00 PM

Managing SQL Server Security part 2

3/28/11 6:00 PM

Performing Data Management Tasks part 1

4/11/11 6:30 PM

Performing Data Management Tasks part 2

4/25/11 6:30 PM

Monitoring and Troubleshooting SQL Server

5/9/11 6:30 PM

Optimizing SQL Server Performance

5/23/11 6:30 PM

Implementing High Availability part 1

6/6/11 6:30 PM

Implementing High Availability part 2

6/20 6:30 PM

Cram for the Exam (review all)

6/29 6:30 PM

 

 

 

Contact pssug.workshops@gmail.com with any questions around the study group.

Material to be covered by PSSUG Workshop (MCTS 70-432 - Microsoft SQL Server 2008 Implementation and Maintenance)

We are looking for additional instructor for the workshops; if you would like to be a PSSUG Workshop instructor please contact me at:

 

Join us in the PSSUG workshops as we review the MCTS 70-432 exam material over the next 6 months. The workshop series will be doing a certification study group to prepare people to take the MCTS certification exam for 70-432. If interested, please Register at