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

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

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

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

April Meeting

Good Morning Everyone,

This coming Wednesday, 18th of April at 5:30 PM, is our next SOSSUG meeting. We have received a sponsorship from Idera so we will be having a nice dinner. Tentative menu is assorted Deli Sandwiches from Sandwich Express.

Speaker: Jeremiah Peschka’s

Topic: Rules Rules Rules

Computers are governed by the rules of physics: electrons, drive
heads, and disk platters can only move so fast. Understanding how
these rules operate and interact leads to insights into application performance.
Understanding why something might perform a certain way makes it much
easier to understand the tradeoffs of a specific design.
Database systems are built according to those rules: memory is faster
than disk which is faster than the network. Database schemas and
queries are built within the rules of database systems. You will hit
the limitations of these rules. If you know what the rules are and why
they are in place, you'll know when it's time to break them... and how
to succeed.

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 We will be having deli sandwiches
Chapter News
Speaker: Jeremiah Peschka’s
Award Door Prizes or Giveaways
Networking Time

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

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

March Meeting Canceled

Today’s meeting is Canceled due to weather. We received quite a few members canceling. While Salem is not bad many of our members live in the Corvallis, Albany, Lebanon, and Sweet Home area or up in the hills. Next Month we will have Jeremiah Peschka speaking. We have also picked up a sponsor. Idera is sponsoring our May meeting.

February SOSSUG Meeting

Reminder,

February SOSSUG Meeting Tomorrow at 5:30. We will provide Pizza and Drinks. The topic chosen at last month’s meeting is Enterprise Database Administration.

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

Agenda:

Introductions
Chapter News
Enterprise Database Administration and Deployment – PASS Summit Recording. Note that we received our DVD disks from PASS.
We will decide on speakers and topics for the next three months at this meeting. We will also discuss meeting times.
Award Door Prizes or Giveaways
Networking Time

No Meeting For January 2012

We are not having a meeting in January. We will begin having meetings again starting February 21st at 5:30 PM. Look forward to seeing everyone.

Ben