About OASSUG

The Olympia Area SQL Server User Group (OASSUG) is a charter member of PASS. PASS is the Professional Association for SQL Server & Business Intelligence. PASS was founded by Microsoft® and CA® to provide users of SQL Server a community, peer networking and to build a body of expertise to help educate millions of SQL Server users around the world.

The Mission of Pass and it chapters worldwide is

To provide an effective forum for SQL Server & BI Education
To facilitate member networking & enable the free exchange of information
To work directly with Microsoft to influence the direction of SQL Server & BI Products & Services
To build and grow the SQL Server & BI Community
To publish high quality technical materials (Journal/Online Newsletter)
To build the largest archive of high quality SQL Server & BI reference material for member use in the world

To accomplish this mission we search for, and have present topics that user group would like to hear about: 2005 analysis services & business intelligence, analysis services, Archiving, automation of administration/maintenance, BPV, Business Intelligence (?) (OLAP), C# procs and functions, Calling from a com object (SSIS vs DTS), certification, create/modify maintenance plan, cross database security models, data base administration, data mining, data warehouse, database mirroring, database recovery, db portioning, Disaster recovery, DM Views, Documentation, DOT.NET integration, DTS to SSIS migration, Hands on writing DTS & SSIS packages, high availability indexing, Integration services, LINQ, Migration to Report Services 2005, More on specific issues: submit an issue, give it to a pro then walk through the solution, more on sql server 2005, MOSS 2007: Development Uses & Documentation resources, Moving dbs from SQL 2000 to SQL 2008, new sql code for sql server 2005, OLAP, Optimizing queries, indexes and clusters (getting sql server to use the correct index), Partitioning, Performance tuning, Query Optimization Tools and Performance evaluations, Reading excel and flat files, Replication, reporting services including report model, Security (developers, DBA, etc.), SharePoint & reporting services, SQL 2008, sql agent, SQL performance – parallelism, SQL query performance (table hints, set theory, cursors & coalesce, temp tables) - When and when not to…, SQL Server 6.5 compatibility with SQL Server 2005, SQL Server and 64 Best Practices, SQL Server and Visual SourceSafe or Source Control, SQL Server in a Virtual environment, SQL Server Programming, SSIS, SSMA for Access, SSMA for Oracle, Stored procedure usage, Tracing ERL modeling tools, t-sql optimization, US DB Pro Edition, What can we hope to see in Katmai?, What effect will Longhorn have?, What training have you found useful?, XML topics / processing.

We continue to solicit feedback concerning topics for future meetings. If you have a topic from these subject areas, or one that is not listed, and would like to share your experiences, please let Greg or Cooki (emails below) know so that we can try to arrange for a presentation in the future.

Our Chapter chairperon is Greg Larsen. Greg works for the Department of Health, for the State of Washington.

Our Correspondence person is Cooki Perkins. Cooki works for the Department of Social and Health Services, for the State of Washington.

Our Webmaster person is Joe Barton. Joe also works for the Department of Social and Health Services.

Would you like to know more about the OASSUG, Contact us at OASSUG.ORG