oPASS

1
oPASS

• Aug 7, 2007

2
Sponsors
3
Agenda

• Introductions
• oPASS Business Announcements
• Thats The Spot!
• Plans for Oct Dec meeting, schedule for next
  year
  
• SQLSaturday
• Celko on SQL
• PASS membership and PASS Summit
• Member spot light Mike Antonovich
• Bylaws

4
Agenda

• Sponsor Speak
• Leveat Ruse of Consultis (tonights sponsor)
• Round table and a small puzzle
• Guest Speaker Kendal Van Dyke of Channel
  Intelligence on XML in SQL 2005
  
• Prizes and final discussion
• Adjourn to Applebees!

5
Thats The Spot!

• Adding some fun to the meeting tonight!
• Amy Lester, former Developer and IT person now a
  self employed Massage Therapist focusing on
  corporate accounts
  
• Were going to do a drawing for who gets the 5
  min chair massage while Amy discusses her
  business
  
• And then.were going to raffle off a one hour
  office visit by Amy!

6
Meeting Plans

• Oct 7
• Featured speaker is Bill Graziano of SQLTeam.com
  (visiting from Kansas City) on What I Wish
  Developers Knew (Sponsored by End to End
  Training)
• ApexSQL demo by Dan Wolford (which means Apex
  will pay for the pizza)
  

7
Meeting Plans

• Dec 21
• Featured speaker is Brian Knight, author and SQL
  Server MVP on The Twelve Days of SSIS
  
• Looking for a volunteer for a product demo

8
2008 Meeting Plans

• Continue bi-monthly, reassess for 2009?
• Should we consider launching a South Orlando
  Chapter?
  
• Try to mix local and big name speakers
• Depends on budget!
• Some product demos but only if they either just
  demo the product or deliver real content

9
2008 Meeting Plans

• Meeting Dates
• Feb 12
• Apr 8
• Jun 10
• Aug 12
• Oct 14
• Dec 9
• SQL Saturday
• Nov 8

10
SQLSaturday

• Call for speakers is open, 16 sessions submitted
  so far, our goal is 30
  
• Special guest speaker will be Joe Celko!
• We need volunteers to assist with registration
  and food
  
• And we need your help with encouraging
  registration, sponsorship, and local speakers!
  
• www.sqlsaturday.com
• Free speaking class courtesy of End to End Tng

11
Celko on SQL

• Advanced seminar for those who want to use the
  SQL language to its full potential
  
• 249/per person, group discounts available
• Outline
• Thinking in sets and not in sequences -- the
  right mindset
  
• Why IDENTITY does not work
• ISO-11179 data element naming rules
• Designing encoding schemes -- scales and
  measurements
  
• CASE expressions
• The OLAP functions and OVER() clause on
  aggregates
  
• Nested sets for hierarchies

12
PASS Membership

• All oPASS members are eligible for the free PASS
  membership and can get the premium membership for
  60/year, a 60 discount
  
• PASS Summit is Sep 18-21 in Denver
• Register early for next year to get best rate

13
Member Spotlight

• Mike Antonovich, main man at Orange County Public
  schools (and not here this because he is getting
  his daughter set up for college!)
  
• Started with FoxPro and migrated to SQL Server
• Active in the original oPASS and the new launch
  this year
  
• Read the interview at the site
• http//www.opass.org/content/showcontent.aspx?cont
  entid229

14
Bylaws

• Needed to be an official PASS chapter
• Were not a legal entity so we can keep this
  simple and change later if needed
  
• http//www.opass.org/content/showcontent.aspx?cont
  entid230
  
• Vote!

15
Now a word from our Sponsor!

• Leveat Ruse of Consultis!
• www.consultis.com

16
Round Table

• Has anyone loaded the SQL 2008 beta?
• Anyone sticking with SQL 7 or SQL 2000? Who will
  upgrade immediately to SQL 2008 and why?
  
• Anyone using Notification Services which seems to
  be disappearing in SQL 2008?
  

17
TSQL Puzzle

• Our employer has a raffle going to celebrate
  some big event. Each employee will get one
  entry in the raffle for each four hours of
  vacation time left and two tickets for each hour
  of sick time remaining. We want to
• Insure that each person can only win once
• We try to make it reasonably random as best we
  can using TSQL
  
• Make sure that having more vacation/sick time
  does equate to more chances to win

18
TSQL Puzzle

• Use Adventureworks
• Go
• Select contactid, vacationhours, sickleavehours
  from humanresources.employee

19
Our featured presentation!

• Kendal Van Dyke

20
Final Discussion?

• Questions or comments?
• Anyone who has time join us at Applebees
• Everyone buys their own!