Reflections on SQL PASS Summit 2010

Attending Orycon immediately following SQL PASS Summit was not exactly the best thing for me to do especially since I managed to lose my voice part way though SQL PASS and still haven’t managed to fully recover from the damage despite taking both Monday and today as vacation days from work.
SQL PASS Summit was very educational, and I wish I had the time to personally document all that I learned. However, thanks to my bout with illness, I do not have the time to write all that I should. Fortunately for the rest of us, many SQL PASS Summit attendees already blogged about the highlights and they write much more coherently than I do.
Here is a brief list of the live blogging of SQL PASS Summit events, classes, keynotes and suchlike (in the order I stumbled upon them, rather than in any order of priority or importance)

• SQL Belle’s blog on the Women in Technology Luncheon at SQL PASS Summit, PASS Summit Day 1 keynote and classes she attended, her discoveries on the day prior to the start of PASS Summit (aka Day -1).
  
• Jen of MidnightDBA’s blog includes the PASS Virtual Vendors Area, Pass Day 3: Keynote Live Blog, Pass Day 2: WIT Luncheon, Pass Day 2: Keynote live Blog, Pass Day 1: Keynote Live Blog, and of course video of the MidnightDBA groupies PASS Meetup.
  
• Brent Ozar blogged about Keynote day #1
  
• Strate SQL blogged about Dr. David DeWitt’s amazing keynote about SQL Query Optimization on the 3rd day of SQL Pass. The blog page also includes the links I forgot to write down for the URLs Dr. DeWitt mentioned during his talk.
  
• Grant Fritchey on Keynote Day #1 (part 1, part 2, part 3) , Keynote Day 2, Keynote day 3.
  
• SQL Rockstar, aka Thomas LaRock, blogged on what he did last week, the first keynote, and the Women in Technology Luncheon.
  
• Replays of the Live streaming video of the keynotes from SQLPass site: Day 1, Day 2, Day 3, and WIT Luncheon.

Various neat things were announced at SQL PASS Summit, including

• New path to obtaining the Microsoft Certified Master (MCM) certification for SQL Server 2008.
  • Brent Ozar wrote a summary of the changes for those who want a quick bulleted list of the changes rather than the full program description.
    
  •  Paul Randal and Glen Berry also blogged on the MCM announcement.
    
  • Many posted the all-important link to the MCM readiness videos, which is required viewing for all MCM candidates.
• SQL Server Denali Community Technology Preview was released, and all attendees received a CD containing SQL Server Denali CTP1. Brent Ozar was one of the first to post a blog about Denali and its high availability features.
  
• SQL Server Tools code named “Juneau” – SSMS BI functionality now available in BIDs.
  
• SQL Server 2008 R2 Parallel Data Warehouse
  
• Microsoft “Atlanta” (online service providing proactive alerts for SQL server 2008+). Official site here. Brent Ozar expresses his concerns about Atlanta in a blog he posted within minutes of Atlanta being announced (fast blogger!).
  
• Project Crescent – web-based reporting tool

Random photos from SQL PASS Summit 2010. Generally speaking, the photos were taken outside the hours of the classes at social events because we ALL were actually paying attention to the speakers rather than snapping photos. The following are photo albums posted by various attendees.

• Lucid 77’s photostream with sqlpasspics tag
  
• Brent Ozar’s photostream
  
• The “official” flickr “SQLPass” tag series of photos

Wednesday was SQLKilt day. Many of the male attendees showed up wearing kilts in support of the PASS WIT (Women In Technology):

• Lucid 77’s photostream

Stuff from other evening happenings

• SQL Chicken’s inside view of the SQL Server Central Party on Monday evening

SQL Karaoke:

• SQL Chicken’s live streaming iPhone video set from SQL Karaoke, including “11/10/10 9:48 PM singing”, “11/10/10 11:18 PM” (the Elvis song singing guy is actually quite good), and of course “11/10/10 10:47 PM”,  proving yet again that Karaoke is singing better left in the shower.

I got to sit next to Brent Ozar in a panel at SQL Pass. He snapped my picture as I was trying to peek into his birthday gift bag:

(hyperlink to original of photo)  He tagged it “Celebrity  Sighting at #sqlpass and tweeted my photo to everyone. I guess I’m a Celebrity now. Wowza.

Girls Need Good Mentors

Although frequently in elementary schools, girls are ahead of the boys in math, Why is it that by the time they go to junior high school or high school so many girls shy away from or even declare they hate math? I suspect that to some degree what pushes them away from mathematics is what I'd call "bad role models". That is, they meet various older women who are anxious about math and they copy the behavior of those women.

Who are these role models? Females in their family and teachers. Most elementary school teachers are female - in fact, in the elementary school I attended, the only male teacher there was the gym teacher (this may have changed over the years.). Just for fun, I googled something similar to "Gender profile of teachers" and got back a number of interesting articles. One from Florida was a 2003 report showing approx 90% female elementary and approx 60% female secondary teachers. Boston.com talked about Massachusetts schools becoming desperate to recruit male teachers to provide role models for boys since so few men teach these days.

I also found a report that backed up my theory about female teachers passing math anxieties on to their female students. The report also stated that for some reason the boys were not influenced by the math-phobic teachers)

How did my interest in math and science survive the bad influence of the math-phobic teachers / role models? I was fortunate that both my parents were math / science teachers and they continuously reinforced not only the value of knowing math and science but also the fun (can you say "home chemistry experiments"?) of it all.

What can we do for those who don't have good math/science female role models in their lives? What else can we do to help influence the young girls to encourage them to pursue technical professions? Where are the highly technical females hiding?

One good place to not only find strong female role models but also something that appeals to youngsters is in Japanese Anime. Unlike American cartoons - where the smart and competent characters are portrayed using negative stereotypes -- thick glasses, ugly, terrible in sports -- Anime heroines are beautiful and amazingly competent in everything from sports to music to academics. Best of all, they are astoundingly competent with computers.

Here's a brief list of anime with strong female leads (character name when I can think of it in parens) :

• Serial Experimanets Lain (Lain)
• Suzumiya Haruhi no Yuuustu (Nagato Yuki)
• Rideback
• Mission E (*not* the 1st series, 'Code E,' but the second series called "Mission E")
• Black Lagoon (Revy)
• Ghost in the Shell (Kusanagi Motoko)
• Pumpkin Scissors (Alice)

(I’ll add more as I think of them. )
I’d also recommend David Weber’s Honor Harrington series as something for young ladies to read in their spare time.

Alice Costume (from “Alice: Madness Returns” Game)

I just completed sewing the Alice costume I need for various events:

• I’m Alice in Orycon’s Opening Ceremonies skit “Alice in Oryconland”
• I’m Alice at the Greater Portland Area Costumer’s Guild Orycon Party where the theme is “Alice in Slumberland”
• Halloween

I chose to do the Alice from the “Alice: Madness Returns” game because I had sufficient leftover fabric in appropriate colors to make it. (we will NOT discuss the size of my stash. The fabric reproduces on its own – REALLY).

Front and Back Pictures. I digitized and embroidered the symbols on the apron. The skull was a $1.19 decoration I found at a grocery store.

Win2K Book Purse

Given that I have advertised myself as both a SQL Server person and a seamstress, I think it’s about time that I show the project I most recently completed.
 This purse was made using scrap upholstery fabrics and the cover of “Inside Microsoft Windows 2000, Third Edition,” which has served its purpose and is now destined to live its second life as a purse.
The idea of making a purse from a book is not my original idea – I met a lady at an American Sewing Guild (ASG) meeting who had one. The instructions for making your own book purse can quickly be found using a simple web search, so I won’t bother looking up the link.
The main changes I made to the “standard” version of the purse are:

• I didn’t measure anything with a ruler – I simply wrapped the fabric around the book pages and pinned it to fit, then sewed it together
• The clasp is one of those turn-buckle clasps that you attach by putting a hole through the book cover where you want it to be.
• The strap leading to the clasp and the outer side gussets were made from leftover raincoat fabric.
• I glued it together using Aleene’s Tacky Glue (craft glue), stuffed the soon to be discarded pages inside, placed it on the floor and covered it with a large tote bag full of books (I think the full tote bag weighs about 40 pounds) while waiting for the glue to dry.

I plan to bring this to SQL PASS Summit. It may become a door prize for one of the WIT presentations if they decide that it’s “worthy”.
* Note: I will leave the CD from the book inside the purse as a “bonus gift”. 

SQL Pass Chalk Talk

In Mid-November, I’ll be debuting at my first professional presentation at the SQL PASS Summit in Seattle, WA. During the last SQL PASS  Women In Technology (WIT) Virtual Chapter meeting (we meet monthly via telephone), Meredith Ryan-Smith asked for volunteers to be panelists with her at the Chalk Talk she would be leading. I volunteered hoping that I would have some useful tidbits to contribute to the 40-minute session entitled "Energizing the Next Generation: Encouraging and Inspiring Young Women to Choose Tech Careers,”  which is scheduled for Noon on Tuesday 9 November.

If you look at the statistics from recent years, fewer women are choosing technical careers than ever before. We’re hoping that through this Chalk Talk, we can steer more women toward choosing technical careers.

As the date of the SQL PASS Summit approaches, I’ll be posting some of my thoughts on this topic, so stay tuned!

Lady Runa dressed as Ada Lovelace, a lovely lady who was also one of the first computer programmers.

Working from Home Two Days a Week

A big huzzah to my company. In the interest of being green, saving the planet, or making employees happy, Management has decided that they will allow all employees to sign up to work from home up to two days a week. They even let us pick the days – since traffic is worst at the end of the week, I picked Thursdays and Fridays. Of course when picking those days I completely forgot that everything is craziest on those two days, so I wind up working during the time I would normally have spent commuting.
There are several advantages of working from home:

• When work time starts you instantly beam from home to “work'”
• When work time is over *poof* you’re home.
• If you forget something on the kitchen table, it’s a quick dash across the house to get it.
• Lunch can be something NOT cold and NOT microwaved
• You can catch up on undone housework at lunchtime
• Your second monitor can be a 43” television – perfect for those WebEx conferences
• All calls can be on speakerphone so you don’t hurt your neck holding the phone to your ear
• You can finish getting dressed while the computer boots up and logs onto the company network
• The dress code is whatever you feel like putting on
• If someone wants to talk to you, they have to call – which means you only have to listen to one conversation at a time.
• You know exactly whose germs are on the things in the bathroom and in the kitchen.
• No one hovers near your desk expecting you to pause what you’re doing to answer their “quick question” (which always turns into an hour long discussion and a major issue)
• Lunchtime goat therapy sessions
• Since your wireless is “in range” all over your property, you can work outside when the weather is nice
• Nobody can accidentally take your lunch
• The microwave doesn’t contain “mystery splatters”
• The fridge is NOT scary
• You can sleep minutes longer in the morning
• You don't have to waste a vacation day sitting at home awaiting the repair man - you can work while your house is being fixed.

Unfortunately, working from home is not all fun and happiness. There are some disadvantages, too:

• EVERYONE is constantly IM’ing you and they get mad when you don’t respond instantly (because you’re answering someone else’s questions at the moment or are on the phone or lost that window under the ten other IM conversations you currently have going)
• They get mad that they can’t talk to you because you’re already on phone with someone else
• Undone housework haunts you – you see and sometimes smell the mess that you should’ve cleaned earlier
• If you want to talk to someone you can’t just hover near their cubicle door until they notice you – when telecommuting, you have to call them and hope they aren’t screening your calls
• You always have to make the coffee
• If you spill something on the floor, you actually have to clean it up yourself rather than “let the janitor do it”.
• Bird droppings on the keyboard when working outside under a tree (note to self: ALWAYS check what is above you before sitting down outside)
• People call you outside of work hours asking you to “do a few little things” since you can easily connect to the office
• The VPN connection times out in the middle of meetings or the internet has a hiccup when you’re helping a customer
• Your spouse expects that you’ll have time to run errands, shop for food, and prepare dinner in all your “spare” time because you aren’t driving a half hour each way
• Collaboration among people is a bit more challenging since every group gathering requires a conference call

All in all, I think the advantages of telecommuting outweigh the disadvantages. I don’t think I’ll give it up just yet. Anyone have other commentary on telecommuting?

Annual Closet Clean Out Day

Every year in early autumn I purge my closet to remove the items I no longer wear. I started this system several years ago when I read about a method that helps you keep track of which items you actually wear, and which ones you don’t touch at all. I did refine the system slightly from its original version, and I believe I’ve been successful in reducing closet (and dresser) clutter.
The original system is quite simple. It works best to start at the beginning of a season – I picked Fall because that’s when I first learned about the system, but you can start at any time.

• For each item hung on a coat hanger, reverse the hanger so that the hook points out instead of into the closet.
• Switch the hanger back to normal (with hook pointing into closet) as you wear (and launder) each item. This way, in a very short time, you will clearly see which items are your favorites – they’re the first to have the hangers turned – and which are items you tend to avoid.
• At the end of a year cycle, any items still hanging on a reversed hanger are candidates for purging.

Since I have a fair amount of clothing folded on shelves and in my dresser, I added a method for tracking the use of those folded items –  a safety pin stuck through the washing instructions tag – which is easily removed just before wearing the item.
At the end of each season, I evaluate the items marked for potential purging by checking which ones still have safety pins in their tags or hang on reversed hangers. I then evaluate the purge candidates using a few simple rules:

• If the item is clearly one that is specific to a different season (I’m certainly NOT going to wear a turtleneck sweater in summer), it is not considered for purging – yet.
• Specialty items such as interview jackets, formal gowns and the like are evaluated as to whether or not they are still considered stylish and worth hanging onto.
• For the rest of the purge candidates, I ask myself why I didn’t wear it. Was the weather this past season ever appropriate for it? Does it actually fit? Do I like it? And finally,can it be restyled into something that I would wear?

This past weekend, I purged about a dozen tops and dresses that I refused to wear because I didn’t like the color, styling or fit. Four other items that were marked for purging escaped this season’s purge because I recognized that I could alter them to make them work for me – two dresses were shortened to knee length (they originally fell to an unflattering length in the middle of my calf), a too-short mini-dress was shortened to t-shirt length and taken in at the sides to provide some shaping, and a t-shirt was chopped down from oversized XXL to a nice baby-doll style.