January 16th Meeting

Good Afternoon Everyone,

Our upcoming meeting tomorrow the 16^thof 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

http://sossug.com

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.

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

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

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

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

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