Monday, October 13, 2014


Hello all,

This is a Salem Oregon SQL Server User Group Meeting reminder for October 15, 2014. 

Time: 6:00 PM to 7:30 PM
Food: Pizza and soda will be provided
Location:  PHTech
   3993 Fairview Industrial Drive SE
   Salem, OR 97302
Speaker: Vern Rabe

Vern will be presenting The Significance of Choosing the Right Data Types.  The description of the presentation is the following:
It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goal in this presentation is to show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.


Vern Rabe’s Bio:


Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases for 20 years, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and consulting contracts.

Tuesday, September 9, 2014

SOSSUG Meeting is in September 10th at 11:30 PM


Hello all,

This is a Salem Oregon SQL Server User Group Meeting reminder for September 10, 2014. 

Time: 11:30 AM to 1:00 PM
Food: Pizza and soda will be provided
Location:  PHTech
   3993 Fairview Industrial Drive SE
   Salem, OR 97302
Speaker: Paul Turley


Paul Turley’s Bio:


Paul is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 13 other titles from Wrox, Packt & Microsoft Press.

Thursday, August 7, 2014

SOSSUG Meeting is in August 13th at 6:00 PM

Hello all,

This is a Salem Oregon SQL Server User Group Meeting reminder for the evening of August 13, 2014. 

Time: 6:00
Food: Pizza and soda will be provided
Location:  PHTech
   3993 Fairview Industrial Drive SE
   Salem, OR 97302
Speaker: Theresa Iserman


Theresa will be presenting Backup and Recovery Basics.  The description  of the presentation is the following:
As a DBA, two of your most important responsibilities are backing up data and knowing how to recover it. In this presentation, we'll talk about backup types, recovery models and recovery point objectives. I'll demonstrate backing up data and recovering it to a point in time. By the end of the session, you'll know what a copy-only backup is, when to take a tail-log backup and what it means to restore a database with no recovery.

Theresa Iserman Bio:

Theresa Iserman is a DBA based in Hood River, Oregon with over 15 years of experience in the IT industry. She has held roles in Business Intelligence, Web Application Development, and Technical Project Management at companies such as Sybase, Macromedia, and a Boeing subsidiary.  Theresa is passionate about SQL Server and enjoys speaking and participating in the PASS community. When not experimenting with the latest SQL technologies, Theresa enjoys windsurfing and road-biking in the Columbia Gorge.

Wednesday, June 11, 2014

SOSSUG Meeting is in June 11th at noon



Good morning,

This is a Salem Oregon SQL Server User Group Meeting reminder about today’s meeting. 

Time: Noon to 1
Food: Pizza and soda will be provided
Location:  PHTech
   3993 Fairview Industrial Drive SE
   Salem, OR 97302
Speaker: Trent Mera


Trent will discuss wait state analytics and how to find which statements hitting your SQL Server will give you the most benefit when tuned. 
Methods to find bottlenecks at both the server resource and individual statement level will be discussed. 
Native utilities for accomplishing this will be covered first, and then we will take a look at two Dell Software Tools that use these approaches: Spotlight on SQL Server and Performance Analysis for SQL Server.