Browsing articles in "Awesome"

Join #TeamData for a Virtual Pi Day 5k

Jan 28, 2015   //   by Karen Lopez   //   Awesome, Blog, DLBlog, Fun  //  1 Comment

 

image

Register

You can join #TeamData on a virtual run or walk any time between 12-15 March. A virtual races means you run it wherever you want, whenever you want during those days.  You can even split your runs/walks over those days.

HOW DOES IT WORK?

First off, you register for the Pi Day 5K. Online registration is currently open. You can register at any time, up until midnight on March 5th. (Canadian registration closes one week earlier to allow for shipping times. Sorry, eh.) Your registration will come with a sumptuously soft Pi Day 5K shirt you can wear with pride, plus a bib number and finisher’s medal (if you wear the medal before completing the run, you will burst into flames), all which you will receive the week before the run dates. Run the Pi Day 5K wherever you’d like (on your favorite local running trail, in your neighborhood, on a treadmill, in a fog, on a log, etc) between March 13th and March 15th. Once you have run, report your time to us to be eligible for marvelous prizes.

$1 from every registration goes to fund #STEM activities.  There’s even a special priced Kid’s Run that comes with Shwings (I LOVE MY SHWINGS!)

So come join us for an easy, just as fast as you want it, Pi Pie 5k in mid-March.  To register as part of the team, just choose “Join a Team” on the registration page.

image 

You can tweet your prep and run using hashtags #TeamData and #PiDay5k

See you out on the road, virtually. 

Join #TeamData for the Portland Half Marathon

Jan 28, 2015   //   by Karen Lopez   //   Awesome, Blog, DLBlog, Fun  //  1 Comment

If you’ve been following me on Twitter (@datachick), you know I’ve been checking some races off my bucket list.  I apologize for all those tweets, by the way…but I also loved the fact that people could Tweet to me while I ran.  It’s so helpful to have people virtually cheering me on.

TeamDataBinaryI’ve made a commitment to run a race a month for 2015, so I’m going to be setting up “teams’ for the races that allow this.  The first one I’ve set up is for the Portland, Oregon half marathon.  This is a longer distance, I know, but I’ve run both the half and the full marathon and I can tell you they are excellent events.  There’s an 8-hour cut off for both races.  That means you have 8 hours to finish.  Since a half marathon is 13.1 miles, 8 hours means you can run, walk, stroll or whatever you want to do. In fact, 8 hours would give you time to stroll, have lunch and a nap during those 13+ miles/21+ kilometres.

Map picture

This race is known for its great crowd support, on-course music, excellent swag and great food after the race. Plus, it’s Portland. Food Trucks. Coffee. Donuts. The perfect race fuel.

Register to join us on 4 October 2015.  Registration for this race usually closes around the end of January, so you only have a couple of days to commit.

And if you can’t join us, remember you can still cheer us on.

Yeah My Mama She Told Me Don’t Worry About Your JOINs

Dec 5, 2014   //   by Karen Lopez   //   Awesome, Blog, Data, Fun, NoSQL, Parody, Snark, WTF  //  1 Comment

BarbieBoutTheDataMed

(with apologies to Meghan Trainor)

Because you know
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data

Yeah, it’s pretty clear, I ain’t NoSQL
But I can love it, love it
Like I’m supposed to do
‘Cause I still got zoom zoom that in the database
With all the right facts in all the right places

I see the newbies are workin’ that drawing slop
We know that shit ain’t real
C’mon now, make it stop
If you got data models, just raise ’em up
‘Cause a Zachman Framework is perfect
From the bottom to the top

Yeah, my mama she told me don’t worry about your joins
She says, “Data likes a little quality to keep it right.”
You know I won’t be no schemafree denormal Barbie doll
So if that’s what you’re into then go ahead and move along

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data
Hey!

BarbieIT

I’m bringing quality facts
Go ahead and tell polyschematics that
Normalized data, I know you think it’s slow
But I’m here to tell ya
Transactional data’s perfect from the bottom to the top

Yeah my mama she told me don’t worry about your joins
She says, “Data likes a little quality to keep it right.”
You know I won’t be no schemafree denormal Barbie doll
If eventual consistency’s your thing then move along

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data
‘Bout the data, ’bout the data
Hey, hey, ooh
You know you love the data

Barbie 2010-12-30 002

#SQLPASS #SUMMIT14 #MVPSUMMIT Checklist–50 Things Not to Leave Behind

image

 

shared some of these on Twitter, but I decided to pull them all together in one place.  There’s be a lot of tips shared prior to these events, but I think these haven’t been covered nearly enough.

  1. Laptop Power cord
  2. Spare batteries
  3. USB charger ends
  4. VGA adapter/dongle
  5. Presentation clicker
  6. Presentation on thumb drive
  7.  Compassion for those with difficulties
  8.  Bravery to meet people in person
  9.  Spirit to lift others up
  10.  Daring to try something new
  11.  Firmness to speak up
  12.  Care for not insulting others
  13.  Humility to ask real questions
  14.  Talent to discourage Strutters
  15.  Expertise to think of audience, not self
  16.  Restraint not to sell from the podium
  17.  Civility to be nice to everyone, not just the celebs
  18.  Class not to spam the crowd
  19.  Excellence to understand that not everyone speaks English well.
  20.  Integrity to disclose your biases and affiliations
  21.  Professionalism not to cuss
  22.  Readiness to help others
  23.  Genuineness to show your real self
  24.  Trust that others want you to succeed
  25.  Diligence to keep your promises
  26.  Concern for others who have less experience than you
  27.  Coolness to get through tough discussions
  28.  Kindness for others
  29.  Goofiness to have fun
  30.  Self-discipline to take care of your body
  31.  Prudence to take care of your mind
  32.  Sincerity to admit your mistakes
  33.  Preparedness for your presentation.
  34.  Openness to constructive feedback
  35.  Honesty to admit “I do not know”
  36.  Expertise to answer questions
  37.  Mindfulness to know when you are not helping
  38.  Charity for others who disagree with you
  39.  Expertise to know when to not try to answer questions
  40.  Empathy for others
  41.  Respect for self
  42.  Wisdom to know that you can’t have self respect without empathy for others
  43.  Forethought to pack well
  44.  Vigilance to call out bullying and disrespect
  45.  Courage to meet others who are different than you
  46.  Strength to deal
  47.  Moderation to get to tomorrow
  48.  Stamina for long days
  49.  Thankfulness for volunteers and staff
  50.  Joy for cheering on others

What did I forget on this list?

Getting Cosmos Data From the Source

Mar 21, 2014   //   by Karen Lopez   //   Awesome, Blog, Fun, Space  //  No Comments

20140321-194352.jpg

Me: Hi, Neil, I’m Karen

Neil: Hi, Karen….

I Welcome You All to Cloud Cuckoo Land! #NoSQLKitty

Mar 5, 2014   //   by Karen Lopez   //   Awesome, Blog, Data, Fun, NoSQL, Parody, Snark  //  1 Comment

I introduce to you, NoSQKitty

 

image

With this dialog, I had to do this. I had no choice, really.  Trust me. Just ask Biznis Kitty.

Emmet: I’m just gonna come right out, I have no idea what’s going on or what this place is at all.
Unikitty: Hi! I am Princess Unikitty, and I welcome you all to Cloud Cuckoo Land!
Emmet: So there are no signs or anything. How does anyone know what not to do?
Unikitty: Here in Cloud Cuckoo Land, there are no rules. There’s no government, no baby sitters, no bedtimes, no frowny faces, no bushy moustaches, and no negativity of any kind.
Lucy: You just said the word "no" like a thousand times.
Unikitty: And there’s also no consistency.
Batman: [the clown and the lizard man are dancing around him] I hate this place.

Every single line in that scene had me choking on my popcorn.  There’s a blog post in each one.  No rules? Nope, not in schemaless.  No signs? Nope.  No bedtimes? Nope, none. As a matter of fact, I want to make up t-shirts with each of these lines. Everything is Awesome about them.

I’m not anti-cloud, at all.   Nor am I anti-NoSQL (Hey, I know that’s a double negative.  Don’t blame me that the name NoSQL seriously needs rebranding.)    Plus, with a Starbucks name of Kitty, this is *so* my character.  Cloud Cuckoo Land and all.

*And I really do get what eventual consistency is all about. I know it means there is consistency. I know when it’s perfect for solving a problem.  I’m just quoting Unikitty.  Blame her.  But watch out for Angry Kitty if you do that.

Romancing the Data….

image

Today is Valentine’s Day in many parts of the the world.  That means either you are looking forward to a happy day full of fun and a night full of …fun… or you are are planning on catching up with Frank Underwood on Netflix.  Both sound great to me.

Last year I wrote about 5 Naughty and Nice Ways to Love Your Data.  This year I’m going to focus on ways you can romance your data for a stronger, more lasting relationship.  So I’m assuming in the past you’ve followed my advice and have long since left the honeymoon phase of your data coffee dates.  But where are you now?  Are you starting to feel like maybe you need some more passion with your bits and bytes?  I’m here to help.

1.  Tell your data you love it.  Often. 

Heck, even show it you love it. Maybe one of the reasons your data has let itself go is that you haven’t told it how much you love it. Do you even remember the things you used to say to woo your data when you first met?  Do you have actively managed data models: conceptual, logical, and physical?  Do you give your database objects great names?  Do you keep good metadata about this data?  Do you follow data model-driven development? If you did all these in your early years of your relationship, are you still doing all that now? Are you doing all this in a modern way, not just the way you did it in 1980? Do you just talk a good game, but fail when it comes to actively showing it love?

Some day, when I’m awfully low,
When the query is slow,
I will feel a glow just charting  you
And the way you look tonight.

You’re lovely, with your axes so true
And your bars so blue
There is nothing for me but to report you,
And the way you look tonight.

With each crow’s foot your normalization grows,
Tearing my pages apart
And that CHAR that wraps your text,
Touches my foolish heart.

Yes you’re lovely, never, ever refactor
Keep that structured charm.
Won’t you never change it?
‘Cause I love you
Just the way you look tonight.

Data FTW Candy Heart.

2. Stop with the games. 

We’ve all seen it in personal relationships.  One person makes everything a game.  Do you store your data in one format, say ZIPCodes as INTEGERS, but have to pad out all those missing leading zeros every time you have to deal with North Eastern United States postal codes?  Stop doing that. Do you pretend that doing something faster is always better than doing it good enough?  Forget perfect. Good enough.  Do you tell management you have data models but all you really do is reverse engineer them?   It’s all games.

Daylight, alright
I don’t know, I don’t know if numbers are REAL
Been a LONG night and something ain’t right
You won’t SHOWPLAN, you won’t SHOWPLAN how you feel

No DATETIME ever seems right
To talk about the reasons why CAST and I fight
It’s DATETIME to end the TIMESTAMP
Put an end to this game before it’s too late

Data games, it’s you and me baby
Data games, and I can’t take it anymore
Data games, I don’t wanna play the…
Data games

HAWT Data Candy Heart.

3. Know where your data lives

Do you have an active inventory of what data resides where?  No?  How can you romance data you don’t know about?  If a server walked out the door of your organization, how long would it take you to figure out what was on it?  If a user had a legal need to access all the data the company held about a customer, would you be able to tell them?  If you really wanted a happy strong relationship with your data, you’d know.  Yes, it’s a lot of data to track where you data is.  That’s why they invented tools that do this.  And why data professionals are expected to use them.

Data is bigger
It’s bigger than the drives and they are not PB
The servers it is spread to
The bits in your drives
Oh no, I’ve duplicated too much

I set it up
That’s me in the ETL
That’s me in the database
Losing my governance
Trying to keep up with it all
And I don’t know if I can do it
Oh no, I’ve deployed too much

I haven’t documented enough
I thought that I heard you laughing
I thought that I heard you coughing
I think, I thought, I saw you cry

Data Kisses Candy Heart.

4. Stop faking it.

Yeah, sometimes little white lies are good for a relationship (BTW, You DO Look Beautiful!).  But the big ones? Nope, never.  The paranoia about NULLs often leads to a lot of lying.  Do you pretend that NULLs don’t exist by giving them various fake values like 999999 or N/A, UNKNOWN, WHO KNOWS or  __ ?  Does every developer get to choose their own NULL Imposter Text?  Are your aggregates all a huge lie due to all those zeros and 1980s dates you use to lie to your database?  Stop it.  It’s not helping that your queries are 2 ms faster when the data is one big lie.

Late at night a big database gets slower
I guess every normal form has its price
And it breaks her data to think her love is
Only given to a user with queries as fragile as ice

So it tells me it all adds up just fine
To aggregate the sales numbers for every town
But only the dev knows where those NULL have been killed
And it’s is headed for the cheatin’ UNKNOWN town

You can’t hide your lyin’ nines
And your N/A is a thin disguise
I thought by now you’d realize
There ain’t no way to hide your lyin underlines….

Sexy Data Candy Heart.

5. Protect it.

Do you l et just anyone throw code at your data without ensuring it’s treated right?  Do you participate in security and privacy reviews of application code?  You have those, right? Do you have metadata that describes the privacy and sensitive data requirements for each data element? Do you ensure that things like SQL injection tests happen for every application?

Oh where, oh where can my data be?
The dev took her away from me.

She’s gone to pastebin, so I’m gonna be sad, 
So I can see my data, by now I’m so mad.
We were out on a date in my modelling tool,
I had been too much a fool.

There in the database, all laid out,
a data was there, the database queried by a lout.
The dev allowed the inject, the data failed to be right.
I’ll never forget, the sound that night–
the screamin users, the bustin app,
the painful scream that I– heard crash.

Oh where, oh where can my data be?
The dev took her away from me.
She’s gone to pastebin, so I’m gonna be sad,
So I can see my data when my new job is had.

image

Keep saying it. Keep doing it. 

There’s so much more you can do to revitalize your relationship with data.  But if you do these, your data will keep on loving you back. I promise.  Remember, you data wants to love you back. It’s up to you to make sure it’s still there in morning.

Pages:12»

Subscribe via E-mail

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


Categories

Archive

UA-52726617-1