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.
 

Tuesday, November 19, 2013

Next SOSSUG Meeting is in January 15 at noon

Hello all,

Our next SOSSUG meeting is going to be January 15th at noon. More to come later on the details. Have a wonderful holiday season and we shall see you next year.

Ben Pickett

Wednesday, September 18, 2013

SOSSUG Meeting

Friday Sept 20th at 12 -1 is our next meeting. Lunch will be provided.

Ben

Monday, July 15, 2013

July Meeting Wednesday July 17 at 12 Noon – 1PM LUNCH PROVIDED

SOSSUG July Meeting. We are mixing it up a bit and moving to a lunch time meeting.

When: Wednesday July 17 at 12 Noon – 1PM LUNCH PROVIDED
What: Jeremiah Peschka MCITP, MVP - Nobody Got Fired For Buying SQL Server

If you've worried about outgrowing your current database or wasting countless hours moving to the wrong data platform, listen up. There is an overwhelming array of database options on the market, knowing which to pick is difficult. Before jumping in, it's important to have a list of questions to make your decision easier. In this session, we'll cover a set of questions to get your team started in the decision making process.


Where: PH Tech 3993 Fairview Industrial DR SE, Salem Oregon 97302


Tuesday, June 18, 2013

June Meeting - Featured Speaker Kendra Little


Agenda:

Kendra Little will be our featured speaker tomorrow. Come join us for an exciting session on Index Tuning with the Execution Plan Cache.

Index Tuning with the Execution Plan Cache
Can you prove how much your index tuning work is improving performance? Kendra Little will teach you how to use SQL Server's execution plan cache to find, validate, and document performance improvements from index changes.
Bio
Kendra Little helps people make SQL Server faster, more reliable, and easier to manage. She is a Microsoft Certified Master in SQL Server and a Microsoft MVP. Kendra draws free posters about her adventures with databases-- check them out at http://www.brentozar.com/go/posters.

Introductions
Networking Time
Dinner
Chapter News
Speaker Kendra Little Topic: Index Tuning with the Execution Plan Cache

Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com

Our featured Sponsor is:

PH Tech

Meeting Location:

PH Tech
3993 Fairview Industrial Dr. SE
Salem, Oregon 97302

-----------------------------------------------------------------------------------------------------

Ben Pickett
Twitter: @benptweet #SOSSUG




Wednesday, March 20, 2013

March Meeting


Good Morning Everyone,

Our upcoming meeting is today March 20th at 5:30. 

Today's meeting will be a chance to bring you SQL challenges and questions for a round table discussion. Drinks and Pizza will be provided.


Agenda:

Introductions
Networking Time
Dinner
Chapter News
Round Table SQL Server Challenges and Questions
We have a couple of books to give away


Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com

Monday, February 18, 2013

February Meeting



Our upcoming meeting is this coming Wednesday 20th of February at 5:30. Jeremiah Peschka will be back presenting:


Data Warehousing for Dollars a Day

Data warehouses make answering complex questions easy but they have also traditionally been the domain of big companies with specialized departments, hardware, and large budgets. By combining Apache Hadoop and cloud computing we can create a massive data warehouse for a few dollars a day. Join Jeremiah as he covers the techniques used to prototype and deliver a large data warehouse without purchasing a single piece of hardware.

---
Jeremiah Peschka - Founder, Brent Ozar Unlimited
MCITP: SQL Server 2008, MVP
Cloudera Certified Developer for Apache Hadoop

Chapter Leader: Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com

Meeting Location:

PH Tech
3993 Fairview Industrial Dr. SE
Salem, Oregon 97302

Agenda:

Introductions
Dinner
Chapter News
Jeremiah Peschka - Data Warehousing for Dollars a Day
Award Door Prizes or Giveaways
Networking Time






Tuesday, January 15, 2013

January 16th Meeting



Our upcoming meeting tomorrow the 16thof January at 5:30. Red Gate is sponsoring our meeting. We have prizes to give away. We have lots of SQL books and other items. 

Arnie Rowland will be presenting on usage of Red Gate tools as per the group’s request. This will be an exciting event with great food and prizes.

Understanding Execution Plans (and what to do with them.)

Understanding Execution Plans provide the basis for Query Performance Tuning
What are the Differences between Estimated and Actual

What Plan Tools to use?

Reading and Making Sense

Key Operators
·         SELECT
·         Table Scan
·         Clustered Index Scan
·         Clustered Index Seek
·         NC Index Scan
·         NC Index Seek
·         RID Lookup
·         Key Lookup
·         Sort
·         JOIN (Loop/Merge/Hash)

Now What?


Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com


Meeting Location:

PH Tech
3993 Fairview Industrial Dr. SE
Salem, Oregon 97302

Agenda:

Introductions
Dinner
Chapter News
Arnie Rowland Red-Gate Tools
Award Door Prizes or Giveaways
Networking Time

-----------------------------------------------------------------------------------------------------

Ben Pickett
Twitter: @benptweet #SOSSUG

Friday, December 14, 2012

December 2012 Meeting


Happy Friday Everyone,

Next Wednesday is our Monthly SOSSUG Chapter Meeting. We are excited to have Vern Rabe as our Speaker. He will be speaking on The Significance of Choosing and Using Data Types. 

Agenda:

Introductions

Dinner

Chapter News

Speaker: Vern Rabe

Title: The Significance of Choosing and Using Data Types

Description:

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.

Award Door Prizes or Giveaways

Networking Time

About Our Speaker:

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 almost 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.


Location:
 


PH Tech
3993 Fairview Industrial Dr. SE
Salem, Oregon 97302
http://goo.gl/maps/NIQyS 



Ben Pickett
Twitter: @benptweet #SOSSUG
http://sossug.com


Up and Coming Meetings and Speakers:

January

Arnie Rowland will be speaking on Understanding Query Execution Plans and RedGate's Source Control


February

Jeremiah Peschka Will be Speaking on a yet to be determined topic.


Tuesday, November 20, 2012

November Meeting

Tomorrow would be our regularly scheduled Monthly meeting. This month we will not have a meeting because of the proximity of the meeting to Thanksgiving. December 19th we will have speaker Vern Rabe. January 16th we will have Arnie Rowland speaking on Redgate Tools Specifically SQL Source Control. Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com

Wednesday, October 17, 2012

SOSSUG Canceled for October

Good Afternoon Everyone, Our speaker has canceled due to an emergency. We are going to cancel the meeting for tonight. I apologize for the inconvenience. Our speaker sends his apologies. Thank you all. Next month we will have high quality and relevant content with Updates on SQL PASS 2012. Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com

Tuesday, October 16, 2012

October Meeting

Good Afternoon Everyone, Our upcoming meeting tomorrow the 16th of October. Red Gate is again sponsoring our meeting. Arnie Rowland will be presenting on usage of Red Gate’s SQL Source Control. THIS will be an exciting event with great food and prizes. Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com Our featured Sponsor is: Redgate Meeting Location: PH Tech 3993 Fairview Industrial Dr. SE Salem, Oregon 97302 Agenda: Introductions Dinner Chapter News Arnie Rowland Red-Gate Tools Award Door Prizes or Giveaways Networking Time

Tuesday, September 18, 2012

September Meeting

Good Afternoon Everyone, Our upcoming meeting tomorrow the 19th of September. Red Gate is sponsoring our meeting. There are lots of prizes and everyone will get something for attending. We have lots of SQL books, t-shirts, thumb drives, and lots of swag to raffle off. Arnie Rowland will be presenting on usage of Red Gate tools as per the group’s request. This will be an exciting event with great food and prizes. Ben Pickett Twitter: @benptweet # SOSSUG http://sossug.com Our featured Sponsor is: Red Gate Meeting Location: PH Tech 3993 Fairview Industrial Dr. SE Salem, Oregon 97302 Agenda: Introductions Dinner Chapter News Arnie Rowland Red-Gate Tools Award Door Prizes or Giveaways Networking Time ----------------------------------------------------------------------------------------------------- Ben Pickett Twitter: @benptweet #SOSSUG http://sossug.com

Tuesday, August 14, 2012

August Meeting is Canceled

Good Morning Everyone, Our upcoming meeting Wednesday 15th of August is Canceled. Next month we have Arnie Rowland presenting on usage of Red Gate tools. This will be an exciting event with great food and prizes. Ben Pickett Twitter: @benptweet #SOSSUG http://sossug.com

Wednesday, July 18, 2012

July Meeting

Salem Oregon SQL Server User Group (SOSSUG) Reminder… Tomorrow!!! July 18th 2012 at 5:30 PM. Speaker: Jeremiah Peschka presents A Developer's Guide to Fixing Dangerous Queries. SQL Server does a good job of working with whatever garbage we throw at it, but sometimes a helping hand is needed to smooth things out. You may have meant well when you wrote that sloppy SQL, but that predicate lurking under the surface is poisoning your performance. This session will expose your worst habits, anti-patterns, and bad practices. By the time we're done, your T-SQL will be on the path to making things right again. This talk will be therapeutic for anyone from a junior DBA to a senior developer. Tuning these awful queries doesn't have to be a black art - SQL Server provides you with all the information you need to understand what a query is doing. In this session we'll walk through execution plan basics and other built-in tools to make tuning queries easier. Biography: Jeremiah Peschka @peschkaj helps developers, DBAs, and engineers build faster, robust, and scalable solutions; Microsoft SQL Server is frequently a part of that solution, but other databases are also. He has worked as a database and emerging technology expert at Quest Software researching new trends and technologies around data storage. Before that Jeremiah worked across many industries as a system administrator, developer, and DBA, and has been involved in all aspects of application development and deployment. Meeting Location: PH Tech 3993 Fairview Industrial Dr. SE Salem, Oregon 97302 Agenda: Introductions Dinner: TBD Chapter News Speaker: Jeremiah Peschka Award Door Prizes or Giveaways Networking Time

Wednesday, May 23, 2012

June Meeting

Good Afternoon Everyone, Our featured Speaker for our June, 20th meeting is Kendra Little. Demystifying Benchmarking: How to Measure SQL Server Performance Ever wanted to measure how much work a given SQL Server instance can do? Benchmarks allow you to measure and compare base performance between instances. In this session, Kendra Little will introduce you to a free benchmarking tool and demonstrate how to run a TPC-C benchmark against SQL Server. Kendra will provide a quick-start guide to get you going fast, and show you how to use benchmarking data to justify big changes in your environment. Bio: Kendra Little is all about data, communication, and creativity. Kendra nerds out on SQL Server full time as a founder of Brent Ozar PLF, LLC, a boutique consulting company. She is a Microsoft Certified Master in SQL Server 2008 and a Microsoft MVP. When she's not blogging, speaking, or performance tuning with clients, Kendra draws cartoon posters about SQL Server-- check them out at http://BrentOzar.com/go/posters. Meeting Location: PH Tech 3993 Fairview Industrial Dr. SE Salem, Oregon 97302 Agenda: Introductions Dinner We will be having deli sandwiches Chapter News Speaker: Kendra Little Award Door Prizes or Giveaways Networking Time ----------------------------------------------------------------------------------------------------- Ben Pickett Twitter: @benptweet #SOSSUG http://sossug.com

Tuesday, May 15, 2012

May Meeting Update

Good Afternoon Everyone, Our featured sponsor this month is Idera. I have a bunch of Swag from Idera to raffle off. We are going to feature Lightning talks for our May SOSSUG meeting on Wednesday the 16. These are short talks that should last less than 5 minutes. We would like as many people involved as possible. Pick a SQL topic or issue of your choice and bring it. We have four people lined up to do Lightning Talks but all are welcome. Next Month we will have Kindra Little speaking. She is a Certified Master in SQL Server http://BrentOzar.com. Meeting Location: PH Tech 3993 Fairview Industrial Dr. SE Salem, Oregon 97302 Agenda: Introductions Dinner TBD It will be nice. Chapter News Group Chosen Presentation Award Door Prizes or Giveaways Networking Time Ben Pickett Twitter: @benptweet #SOSSUG http://sossug.com