Olympia Area SQL Server User Group

Welcome to the website for the Olympia Area SQL Server User Group (OASSUG) in Thurston County, Washington. Our meetings feature excellent presentations plus the opportunity to network with SQL Server professionals.


Next Meeting: Wed, Apr 16 2014

April: SSIS - manage concurrent processing using SQL Server Broker

Language: English
Event Type: In-Person


Event Time : Wed, Apr 16 2014 14:30 - 16:30 Pacific Daylight Time


Room 153, DSHS, Point Plaza East
310 Israel Road SE
Tumwater, Washington

Olympia Area SQL Server User group meeting

Featured Presentation

SSIS - manage concurrent processing using SQL Server Broker

Speaker: Piotr Palka, ITS 5 Department of Corrections, WA

Summary: In this session we will do a case study for a typical situation in industries like telecommunication or healthcare. We have a stream of multiple relatively small files incoming from external system and we need to load them to SQL Server database in near-real-time. Typical examples are CDR billing files, HL7 diagnostic results or medical claims. In this session we will cover how we can use WMI event watchers to monitor for incoming files and we examine option for managing worker treads loading the files. We will look into SQL Server broker queues, conversations between treads and activation to achieve robust solution.

About Piotr: Piotr Palka has been working with high volume data processing systems since 1999. Piotr implemented and maintained multiple systems for telecommunication companies, including call records processing, billing and customer relationship management and operation support systems. Now he is lead data warehouse developer for Washington State Department of Corrections. He regularly delivers technical presentations at Olympia, WA, PASS chapter.



PASS 2019 Discount Code Discount code for the Olympia Area SQL Server User Group is:


Call for Speakers

Peter Palka is trying to put together a 6 month calendar of speakers and topics. Peter would like to start having two presentations per meeting. One topic could be a short 15 minute presentation and then the other could be a 60-90 minute topic. 

 If you have done something you think is noteworthy that others could benefit from, Peter would like to hear from you. He is willing to help you turn any ideas you have into a presentation. OASSUG is a user group, provided and supported by local area SQL Server users.

  Remember you don’t have to do a full-blown 90 minute presentation; even just a short presentation would be a great way to support our local SQL Server user group.



Back to Top