Archive | July, 2010

No Ways, I'll Be Speaking at SQLSaturday #51 in Nashville on August 21st!

SQL Saturday #51, Nashville EditionI’ve never been to Nashville, but I’ll be there soon.

A while back, I submitted a few abstracts to  a couple SQLSaturday presentations around the country. I just picked places I’ve never visited which seem unique, and where I’d like to make a quick vacation of it and spend a few days exploring town before having fun at a SQLSaturday and meeting new people.

Pick Me! Pick Me!

Shock: not a good look for a DBA.

I checked back on the Nashville submitted sessions after a while and saw that there was a great roster  of sessions submitted. This was sort of happy/sad news– it looked like it was shaping up to a great SQLSaturday, but it was looking really competitive.

But look! They picked me to present one of the sessions!

What I’ll be Talking About

I’ll be talking about how DBAs can take advantage of the SQL 2008 performance data collector to easily gather data from DMVs and create custom data collection sets. This is a great tool that lets you take what you learn at a conference and leverage it against many or all of your production servers. This gives you a repository of data to identify trends, show performance improvements, and report on the impact you’re making.

Nashville

So Nashville is kind of awesome. And I was wrong, it’s not all that different from Seattle. I know, because they ALSO want their coffee to taste like it’s from Portland.

Plus, they have a fake Parthenon, complete with marbles. (For some reason I really like replica buildings in incongruous locations.)

Nashvile is also ROLLING in art. There’s the Frist, the Vanderbilt Fine Arts Gallery, and the Van Vechten Art gallery — that last one was constructed as a gymnasium in 1888 and now holds  Rivera, O’Keefe, and Cezannes. Plus lots of little galleries in town, and architecture tours. (I was an art nerd in a prior life.)

Apparently they have a little bit of live music in Nashville, too.

Not to mention bookstores, food, parks, and a chance for my southern accent to sneak back in. And a whole lotta SQL Server thrown in there on the weekend.

Like a pig in mud, I tell you.

Where and When

SQLSaturday #51 will be on August 21st at 120 White Bridge Rd. Nashville, TN 37209.

Things start up at 8:30 am, check out the whole schedule.

And it’s FREE.

Hope to see you theres, make sure to say hi if you can make it. I’ve been told I look just like myself in person. ;)

Comments { 3 }

Having Fun at SQLPASS: Seattle 101

The 2010 SQLPass Summit is coming  up on November 8-11 in Seattle. As a local, I thought I’d write up some suggestions for y’all out of towners regarding things you may not know about eating and places you may not know about going.

The Space Needle: Pointing at the sky since 1962

Check out what I’ve put together at http://littlekendra.com/seattle/

This is also available on the “SQLPass Seattle 101″ tab at the top of my site.

Seattlish Stuff For Youse To Do

  • Notes on getting around
  • Unusual shopping opportunities (to say the least)
  • More coffee and donuts than you can ever eat
  • Healthy stuff  (for after you prove me wrong about the donuts)
  • Live music
  • <shudder> Karaoke
  • Tours and places to feed your Inner Book Nerd
  • Eats

Plus a neighborhood map.

If there’s interest I can map everything out on one of those internetz mapping services. Just let me know.

Got Suggestions?

Send me a comment or a tweet and let’s work them in.

I’m sure I’ve forgotten a few things and will be adding them on, as well.

Something Wrong?

Do tell.

Comments { 0 }

Learning that Presenting is Worth Doing (T-SQL Tuesday #008: Gettin’ Schooled)

This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach? What are you learning or teaching?”

T-SQL Tuesday #008: Gettin’ Schooled

Learning: If it’s Not Fun, You’re Doing It Wrong

Like many people, I’m an active learner. I learn by doing something– writing something down helps me remember it, discussing it with someone helps more, and applying the information to solve a problem really cements it.  If I’m learning something by reading or hearing which is related to something I’ve been able to use actively, then it’s easier for me.

Essentially, I think learning is a lot like playing a game. It can be frustrating when you’re first getting down the basic rules to play at first, but once you know what you’re doing you can much more easily learn variations on the game, learn similar games, teach others to play, and even make up your own rules.

After the initial struggle of grappling with something, learning should be fun. If it’s not fun, you’re either doing it wrong, or you’re working in the wrong subject.

Language Games

Wittgenstein's Duck Rabbit

In college I read Ludvig Wittgenstein‘s Philosophical Investigations after a few years of intense, deep study. It was like jumping into a lake in a hot, hot summer and splashing around– of all the things I’ve read, I have some of my happiest memories of the Investigations.

Wittgenstein basically talks about language games. The Investigations are written as a series of aphorisms and drawings, and many of them relate back and forth to each other. They’re fun.

And they’re more than fun: they’re meaningful. Maybe the most important thing I learned from the Investigations is that you can discuss a serious subject very deeply, and very thoroughly, in a playful way. You can draw pictures of duck-bunnies. You can make it so people read between the lines, because certain things are hard, or impossible, to explain directly.

Teaching: For Me, It’s Often About Asking Questions

For the most part I’ve found the best teachers have fun with their subject and have an open mind. They get excited to talk about their subject, like to describe the topic in a new way, and they’re even happy when they find they’re incorrect because they’ve learned something new.

I like teaching a lot. For a while I even thought it was what I’d do with my life. The style of teaching I personally prefer is extremely participatory. I like to know a lot about what I’m teaching, but I like even more to teach about something with people who challenge the subject, are interested in learning more themselves, are empowered to talk about it, and think about it differently than I do. I love discussions. Where I went to college, in most of the discussions the teachers didn’t necessarily talk very much— a lot about teaching is just asking the right questions, listening well, and having good timing.

Why I’ve Never Been Much for Presenting

I loved the dialogue style of learning I had in college so much that after I decided to go into technology, I never thought much about giving presentations unless I had an immediate need to train some co-workers. It’s not that I don’t like to talk, trust me, I talk plenty. It’s just that presentations are so one-way for most of the time that I didn’t really consider it my thing, or very interesting.

Over the past few years I’ve given some talks at work, mostly brownbags on getting started with SQL, how to start using query plans, how to do basic troubleshooting.  How to get started with reporting services. In each case I just saw a need and set something up and didn’t think a lot about it. I had fun giving the talks, but they were more of a means to an end than anything else.

Maybe just all the lectures and competition in grad school burned me out on presenting for a while. I’m not really into arguing for my own theories, I’m really just interested in exploring fun things.

Oh Look, I Changed My Mind

When Presenting, Always Remember Not To Curl Your Fingers

I guess I started thinking differently about presenting around the time that calls for SQL PASS abstracts went out this year. I really like attending sessions at SQL PASS and I found that writing an abstract and thinking about a presentation challenged me in interesting ways. I had to think about what I had to say, and also about what I’d like to learn more about in a deep way.  I liked writing the abstracts, but afterwards I did find that I wasn’t so thrilled about the idea of giving them at PASS. And honestly, that was kind of exciting in itself, because I was already thinking about ways I could come up with more interesting talk, and starting to think those through.

Somewhere around that time, Jeremiah Peschka gave a talk which we’ll just call “I CAN HAZ CAREER”. I don’t usually attend professional development talks, but I had some time and figured it’d be interesting. And it was— it not only made me think about long term ideas that I usually neglect, but I also thought the presentation was very interesting as it featured very little text.

I’m used to being heavily dosed with bullet points and demos during presentations, and yes, not really having to listen very hard. You know how it is, you read the slide and then you just let your mind wander ’cause you know what’s coming. But it turns out, it doesn’t have to be that way.

So lately, I’m starting to try to figure out  how to give a  talk that I really enjoy. And which hopefully is also interesting to listen to.

So We’ll See how This Goes

I’ll be doing a presentation on how to be a DBA working in a wacky, amazing Agile development environment on Thursday, August 12th at 6:30PM EST/ 3:30PM PST. You can view the presentation online- I’d particularly love questions, feedback and suggestions.

Comments { 5 }

Why To Do Some of the Grunt Work, Even If You Don't Have To

Part of this past week I’ve spent doing a new SQL Server 2008 R2  installation and configuration on a Windows 2008 R2 cluster. I  haven’t done an install end-to-end in quite a while– I have teammates who take care of it while following our installation checklist document.

I started doing the install and configuration myself because I want to create fresh unattended install files, which I will later turn into slipstream drops. (For more on my love of slipstream installs, see the post here.) I will also be branching the install document soon to create a new version for SQL 2008 R2. Although the install for R2 isn’t very different, many of the paths used for copying files and a few scripts change, so  it’s less confusing in a separate document. In preparation for branching the file, I thought it would be good to give the 2008 install document itself a spring cleaning to clear up anything misleading.

Oh, Wouldya Look at That…

Cleanup on Aisle 7

This was an interesting experience. Although everything technically worked, some cleanup was needed on Aisle Seven.

The checklist is in a Word document so it can be filled out and saved in a history folder on SharePoint each time it used. In a recent past life this was all in a wiki, however. The wiki-to-SharePoint conversion was a shared project on a tight timeline and a lot of copy’n'paste was needed, so some of the fOrMatTing waS nOT wHat YoU’D eXpecT  <WEIRD WIKITAG HERE>

Some steps were in a slightly strange order, so you were over here in PowerShell, now over here in SQL, now back to PowerShell, now  reboot! Reboot! Reboot!  Now check out your page file. Run another PowerShell script! Hey did you forget about the other nodes in the cluster, this step finally mentions them– let’s go back and do all those again on the other node, hmm?

I also found that lo and behold, there were some steps I’d kinda forgotten about. Sure, I know this stuff, I’m not a complete goofy panda a trained professional. I have lots of experience!  But that’s sort of the problem. I have lots of experience and while I can synthesize gobs and gobs of it into a cohesive picture, there’s certain details I end up forgetting if I don’t work with them for a very long time.

And yes, GOBS is the technical unit for DBA experience. It’s like how large volumes of data appear in WADS.

What I’m Sayin

I re-learned that it’s important to occasionally revisit and improve things you already know how to do.  Especially if you’ve delegated these tasks to others, you may not understand them as clearly as you’d like to think. Maybe you’ve learned things recently that allow you to streamline the tasks and make them easier, too.

But most importantly, it’s key to understand the full details of your environment’s configuration. Knowing how something is set up will save a ton of time when you need to troubleshoot it. Besides time being money, it’s YOUR time, and that’s what you want more of, right?

Comments { 0 }