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, Oct 18 2017

Backing up and Restoring your SSRS Environment with PowerShell and Reporting Services Tools!

Language: English
Event Type: In-Person


Event Time : Wed, Oct 18 2017 14:30 - 16:30 Pacific Daylight Time


5000 Abbey Way SE

Lacey, Washington

October meeting.


The meeting will be held in Society Room in Cebula Hall (Engineering), which is noted as building 22 on this map:  https://www.stmartin.edu/sites/default/files/smu-files/public-safety/smu-2d-map.pdf.  Please make sure you park in the open parking out near Pacific Avenue, which is a short walk to the meeting location.

Featured Presentation

Backing up and Restoring your SSRS Environment with PowerShell and Reporting Services Tools!

Speaker: Michael Wall, Senior DBA Great Western Malting

Summary: In November 2016, the SSRS team at Microsoft released 28 new PowerShell commands for working with SSRS. During this presentation, we will cover downloading the current set of tools, installing them, and an overview of all of the tools including my personal favorites! Using these tools, you can easily backup a whole SSRS site and then just as easily restore it onto another site. We will review the necessary commands along with their somewhat confusing syntax. Since these tools use the SSRS API, most of them will work all the way back to SSRS 2008R2 and can be used to make your life administering SSRS much easier.

About Michael: Michael Wall has been a Database Administrator since he was asked if he wanted to be one after successfully managing the Y2K upgrade project on over fifty UNIX servers. Immediately thrust into a major Oracle upgrade project, he has since then managed multiple challenges and now is the sole DBA for a global food processing company responsible for both SQL Server and Ingres databases. He has presented at multiple PASS User Groups and at SQL Saturdays and is in the leadership group for Oregon SQL. He has been on the planning team for a number of SQL Saturdays and plans to keep helping as much as he can!


Supplementary Materials

The following event attachments are available to you:


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