South Jersey SQL Special Interest Group (SIG) is a dedicated group of SQL Server professionals in the South Jersey area specializing in DBA, Database Development, and Business Intelligence topics.  The South Jersey SQL SIG meet once a quarter at the Haddon Heights Public Library.    These meetings are in addition to the normal PSSUG meetings and workshops.    Any questions or interested in getting involved, contact the SIG at sqlsouthjersey@gmail.com or joining the SJ Linked-in subgroup of PSSUG.  

   SJ

 

Meeting Location:  

Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035
Map:  http://www.mapquest.com/maps?address=608+Station+Ave&city=Haddon+Heights&state=NJ&zipcode=08035&country=US

 

Overview of upcoming Activities:

Event Registration / Information link
SJ SQL January Meeting on Tuesday 1/28/2014 at Haddon Heights Library at 5:30

Registration and Details at https://www.eventbrite.com/e/sj-pssug-tuesday-jan-28th-meeting-tickets-10154511417

PRESENTATIONS:

Service Broker brings messaging into the database. It is the technology behind Database Mail, Event Notifications and Query Notifications. Service Broker allows for asynchronous stored procedure execution, and loosely coupled applications. For the DB architect this means scalability and reliability at the same time. In this presentation Hilary Cotter, explains how to scale your applications using Service Broker, and how to use Query Notifications to cache your data to minimize the hits to the database. While Service Broker is a very powerful technology it is also very much a black box and difficult to troubleshoot. Hilary also presents a methodology for troubleshooting and debugging Service Broker technologies.

Web Synchronization is a merge replication technology which allows you to synchronize SQL Server with handhelds, tablets and laptops over the internet offering high security and high performance. In this presentation Hilary Cotter demonstrates how to set web synchronization up, how to monitor and troubleshoot it and how to optimize it. Hilary recently scaled a web synchronization topology to 4000 subscribers.

PRESENTER

Hilary Cotter is a 20 year IT veteran who has been a SQL Server MVP since 2001. He specializes in HA technologies and performance tuning. He is based in NJ.

SPONSOR

ACC Accounting Solutions, Inc is niche full-service software consulting firm providing business consulting, software support services as well as NASBA certified continuing professional education (CPE) training. Sage enterprise-level software (Sage 100/MAS90/200) and a host of business intelligence services and software (FRX, Management Reporter, Forecaster…) are our primary product offerings. As with all business software each solution is dependent on the database connection and the data it contains. ACC is actively seeking a full time data technician who is comfortable and well versed with object oriented relational databases to join our technical staff. Any interested candidates should be comfortable with data mapping, integrations, import/exporting of data as well as creation of “sandbox” environments. Any experience with Crystal Reports would be a plus. We are centrally located in the Cherry Tree Corporate Center, 535 Route 38 in Cherry Hill NJ and the position offered is Full-time, permanent with benefits.

If interested in this opening, please contact Sean Atkins at satkins@4acc.com.

 SJ SQL April Meeting on Tuesday 4/22/2014 at Haddon Heights Library at 5:30  Registration and Details to come
 SJ SQL July Meeting on Monday 7/21/2014 at Haddon Heights Library at 5:30  Registration and Details to come
 SJ SQL October Meeting on Tuesday 10/28/2014 at Haddon Heights Library at 5:30  Registration and Details to come