Friday Sept 20th at 12 -1 is our next meeting. Lunch will be provided.
Ben
Wednesday, September 18, 2013
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
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?
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.
PH Tech
3993 Fairview Industrial Dr. SESalem, Oregon 97302
http://goo.gl/maps/NIQyS
Ben Pickett
Twitter: @benptweet #SOSSUGhttp://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.
Subscribe to:
Posts (Atom)