SOSSUG Meeting is in October 15th at 6:00 PM

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.

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.

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.

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.