Browsing articles from "December, 2011"

PASS Members: Take 2 Minutes to Vote and Do it Right Now

Dec 9, 2011   //   by Karen Lopez   //   Blog, Need Your Help  //  No Comments

SNAGHTML5ed5790This isn’t a normal plea to get you to vote.  This is a plea to have you show that you care about all the things that PASS does actually are worth doing.

Sure, you might think you do not know the candidates well enough to choose.  Sure, you might think your vote doesn’t count.  Or that it doesn’t matter.  But you’d be wrong about all that.

  • There are plenty of resources to find out more about the candidates and they are collected in one place. There are bios, statements and a forum.  If you need to find out more, you can do it there.
  • Your vote does count.  Nuff said.
  • Your vote does matter.  It matters to the candidates who have already spent a great deal of time to submit applications, to be interviewed and to go through the voting process.  I’m not running in this election, but I know how tough it is to put myself forward for an election like this.  It’s worse that reading speaker evaluations.  It’s worse than a TSA grope.  It’s worse than flying.  It’s much worse than spending 2 minutes voting. 

The least we can do as beneficiaries of all the great things that volunteers do, both Board members and minions, is to take the time to vote.  Not only do you get to pick three people to represent you on the Board, you get to show PASS  that what they do actually matters.

I participate in many volunteer-driven organizations.  It’s sad when only 1% of members can take the time to vote.  We should have thousands of people voting.  Voting closes 20 December, but there’s no reason at all to wait.

2 minutes.  Show them it matters. Go do it now.

I’m Speaking at #SQLSat104 Colorado Springs 7 January 2012

Dec 9, 2011   //   by Karen Lopez   //   Blog, Events, Fun, Speaking  //  No Comments


I’ll be leading a discussion on Database Design Contentious Issues on 7 January in Colorado Springs.  This event is FREE, and there’s a $10 charge if you’d like to have lunch.  A full day of learning and networking all provided due to the support of vendors in the SQL Server community.  How awesome is that?

Database Design Contentious Issues

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.

Session Level: Intermediate

This session is part debate, part therapy and part rant.  It’s my most popular presentation and I’d love to see you there.   This presentation also involves physical activity and hands on stuff.  A perfect afternoon slot for this, too.

Women in Technology

I’m also participating in the Women in Technology table at lunch with Meredith Ryan-Smith (Web | Twitter), Rebecca Mitchell (Web | Twitter) and Thomas LaRock (Web | Twitter).

More Fun Than Should be Legal

There’s a whole lot of great stuff packed into this SQLSaturday. Did you know that there will be professional resume writers there to take a look at your resume and give you feedback?  Or that there will be laser tag, bowling and miniature golf? There’s even a #SQLSki event planned.

On the Friday before, there are even 3 pre-cons scheduled:

1. “Scaling SQL Server” (Glenn Berry) 
2. “Data Warehouse Dimensional Design and Architecture Planning” (Erik Veerman)
3. “What’s In Your Utility Belt?” (Chris Shaw and TJay Belt)

These cost only $100 — a great deal for a day of training.

The Schedule

Track Starts Session Title Speaker
BI 8:30 AM Introduction to Data Warehousing Marc Beacom
BI 8:30 AM Kama Sutra of SSIS: A guide to loving ETL Bill Fellows
BI 9:30 AM *GASP* Real-time user defined sets in SSAS Josh Fennessy
BI 9:30 AM Dimenional Modeling 101 Thomas LeBlanc
BI 11:00 AM ETL as MDM Michael Sexton
BI 11:00 AM Using Columnstore Indexes in SQL Server 2012 Carlos Bossy
BI 1:30 PM SQL Report Builder for Business Intelligence David Eichner
BI 1:30 PM Predictive Analytics – You Can, Too! Troy Ketsdever
BI 2:30 PM Reporting DBs behind Virtual IP’s John Halunen
BI 2:30 PM Devs are from Mars, Report Servers are from Venus Doug Lane
BI 4:00 PM Eating the Elephant: SQL Server Table Partitioning Michael Fal
BI 4:00 PM PowerPivot for Excel William E Pearson III
DBA 8:30 AM The Periodic Table of Dynamic Management Objects Tim Ford
DBA 9:30 AM 7 Ways to Fix Bad Parameter Sniffing Grant Fritchey
DBA 11:00 AM AlwaysOn – Finally, A usable ‘mirror’! Jim Murphy
DBA 1:30 PM Discovering the Plan Cache Jason Strate
DBA 2:30 PM Performance Issue Archetypes Joe Sack
DBA 4:00 PM Database Design Contentious Issues Karen Lopez
DBA / DEV 8:30 AM To the Cloud and Back Again! Ted Malone
DBA / DEV 8:30 AM PowerShell for the Reluctant DBA / Developer Jason Horner
DBA / DEV 9:30 AM Development Mise en Place Keith Tate
DBA / DEV 9:30 AM SQL Azure: Future-Proofing Your SQL Career Chris Randall
DBA / DEV 11:00 AM Your own Private Cloud for SQL Ben DeBow
DBA / DEV 11:00 AM Edge Case Testing for the Database Professional Vicky Harp
DBA / DEV 1:30 PM Backup Basics – Know your options Meredith Ryan-Smith
DBA / DEV 1:30 PM PBM and you! Tom Norman
DBA / DEV 2:30 PM Choose Your Own Adventure: Performance Tuning Thomas LaRock
DBA / DEV 2:30 PM 10 Things That Every DBA Should Know! John Morehouse
DBA / DEV 4:00 PM PowerShell and VBScript for the DBA Mark Halstead
DBA / DEV 4:00 PM But it worked great in Dev! Perfomance for Devs Randy Knight

Isn’t that a great line up of speakers and content?  Why wouldn’t you want to be there?

Join us for a fun day of socializing, networking and fun.

I’m [still] a Rockstar Bloggerista

Dec 1, 2011   //   by Karen Lopez   //   Blog, Professional Development  //  2 Comments

The awesome Thomas LaRock (blog | @sqlrockstar ) has updated his Rockstar Blogger rankings and…I’m still on the list.  It was about this time last year when I first made the cut.   If you recall, I’m in the bottom group, TempDB:

The tempdb group has the bloggers that I want to recognize for doing good work. However, they are also the group of bloggers that could most easily fall off and never been seen again, just like a temp table. There is no line separating names in this group, because they are all equally eligible for promotion or relegation back into my general RSS feeds.

Read more:

I didn’t changes groups and I didn’t drop off, even though my blogging hasn’t been as strong as it was in the past.  And I didn’t move up the list, even though I’ve shared all kinds of great Canadian rock star knowledge with Tom.  Will dig up some Stompin’ Tom Connors and some more Nickelback for him to try to improve my score for the next ranking event.  Speaking of that, maybe I should send him some Rankin tunes, too. 

Anyway, one of my goals for the next few months is to do a better job of blogging and engaging the community so that I might perhaps build a buffer zone between me and the temp table that is below the TempDB group. 

I recommend you read and follow the bloggers on the Rockstar list.  They produce the best work out there.


Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to by Email