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

http://sossug.com

Good Morning Everyone,

We will NOT be having a meeting for May. Next month we will have Kendra Little as a speaker.

Ben 

April Meeting

Good Afternoon Everyone,

Tomorrow's meeting is canceled due to scheduling difficulties. See you next month.

Thanks,

Ben

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

February Meeting

Good Morning Everyone

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

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.