T-SQL Tuesday #14: Resolutions

T-SQL Tuesday 14

T-SQL Tuesday 14, hosted by Jen McCown

Resolutions… For a long time, I thought 1600 x 1200 to be the ideal, but with the proliferation of widescreen—oh…wait…not that kind of Resolution? Sorry. My bad.

It’s that time again: the monthly blog party known as T-SQL Tuesday. This month is #14, hosted by the deservedly newly-minted Microsoft MVP Jen McCown (blog | @MidnightDBA). The topic this time around is “Resolutions,” originally, “techie resolutions have you been pondering, and why.”

In my 2011 “Goals” post, I talked about one of the things I need to do this year: something about my career direction. I’ll take this opportunity to elaborate a little bit on what that means for me this year. The part about needing to pick one of two directions still applies, but the work that I need to do for each of those is pretty different.

If I stay a DBA…

If I stay a DBA, what I need to work on the most can be summed up fairly simply: Catch up.

Since I work with SQL 2000 almost exclusively these days, there are a lot of current bits of technology that I need to spend time working on and learning:

  • DMVs
  • Policy-Based Management
  • T-SQL advancements (Actually using Try/Catch, TVPs, etc)
  • PowerShell

That’s just a few things that I can pull off the top of my head; I know there are more that I should know and be able to use at this point. Not having the opportunity to use these features day-to-day doesn’t exactly help me learn and keep these skills sharp 😉

If I want to be one of the cool kid DBAs on Twitter, 2011 is a year in which I have to do a lot of work on these topics.

Less BI-Curious and more BI-…uhh…Pro?

The other choice I have is to do awesome Business Intelligence work. I’m still turned on by a lot of these technologies and the power that they can put into the hands of business users at all levels of an organization. A change in direction at my current job to a more BI-focused role has yet to fully materialize, and as for right now I’m still somewhat impatiently watching that carrot out there.

Whether I do it in my current position or choose to take something new, changing direction to full-time BI work comes with its own set of topics that will need lots of attention from me:

  • Improve dimensional modeling skills (I do some of this already)
  • Actually learn how to do work with SSAS
  • PowerPivot
  • Get better at talking to non-geeks!

There are lots more topics than those three here, too. However, BI in and of itself is a pretty wide field, so the specific topics that would need attention would be dictated by the flavor of BI work that I was doing and my involvement on such a team.

Actually making this stuff happen

Like all resolutions, this is, of course, the hard part. Making this happen isn’t going to be easy for me, either, but the rewards should be very well worth the effort required. Unfortunately, since knowing is half the battle, and I don’t have that taken care of yet, the near-term has the potential to be pretty rough.

At the absolute bare minimum, I resolve to do my best to take care of “knowing” in the first quarter of the year.

(Also, I’m sorry about that screen resolution thing at the beginning; couldn’t help myself)

Looking Ahead to 2011

For as much as I write tasks/to-do items down, am unhappy when I don’t get things done on-time, and really enjoy learning and doing new things, lists of Goals sure rub me the wrong way!

2011 Task

Just don't call them "goals"

I’ve always been that way and I haven’t been able to figure out what my deal is. At first, I thought it was the idea of someone else dictating to me what I should do, but I feel this way when I cook up “goals” for myself, too. It’s not being adverse to work, because when it’s fun, it doesn’t matter. Fortunately, just about everything related to IT that isn’t writing .NET code is fun to me, so it’s not that, either.

If nothing else, I at least understand that I’m in the minority here, and can play along at work (err, “play along” sounds a lot more negative than I mean it to be) and understand that Goals make the world go ‘round. I’ll fill out the tool, put them on my Task list for myself (maybe even put “Goals” in the name), and everyone will be happy at the end of the day.

At any rate, since this can’t be a “goals” post ( 😉 ), it’s just going to be some random mumblings about where I want to go next year.

2011: The last full year

OK, I don’t really think the world is going to end in 2012, because No-one expects the Spanish Inquisition! and Mathew 24:36. You’re right, that was dumb. Let me try again.

2011: I pick a direction and [maybe] stick to it

The biggest thing coming up next year for me is career-related.

The whole reason I switched from being a Sysadmin to this DBA thing is because of Business Intelligence. I’m doing the plain-Jane DBA partly because it was there and partly because I saw it as a way to get my foot in the door of “real” data land. For the most part, that has worked out quite well, and, as it turns out, I like doing this full-time, too!

What this means is I need to decide which way I want to go with my life: Do I want to stay a full-time DBA or do what I can to follow what SQLChicken (blog | @SQLChicken) has done, and switch over to full-time BI work (he actually reminded me the other night that Pragmatic Works is hiring, but I said that the travel wouldn’t work for me. On the other hand, if I could drive or fly a little airplane around TN, then we’d need to talk 😀 )? There’s the potential for a heavy BI opportunity at my current job, but I don’t yet know how that is going to play out. It might be a good way to test the waters a bit, but I won’t know that for at least a month or two.

Regardless of how that goes, I need to get some new things going on job-wise soon, because I’m so over SQL 2000, I don’t even know what to say about it.

Other Data Stuff

SQL-related travel is something that we should be doing more of. Neither one of us has a very good (ie, all but nonexistent) travel budget at work, so we have to foot the bill for this on our own. Yes, we know.

We couldn’t swing PASS this year, and that wasn’t any fun. I’ve got SQL Rally on the calendar, but that still remains to be seen. It would be much easier for us to pull off, plus can easily be driven to (we’re done flying Part 121 ops for right now, thanks to the TSA). There are some SQL Saturdays that aren’t terrible to get to, and those are, of course, good events in their own right.

The biggest problem we have with travel these days (and this goes for all travel, not just SQL travel) at the moment is the dogs, since we haven’t been able to figure out what to do with them since moving down here. Taking them along is almost impossible (lodging at destination), and Boarding them at a place that doesn’t just leave them in crates all day gets real expensive real fast. We could get an RV, I guess, but we’d quickly become that couple at events, hahahaha. Still working on this.

Next year, I want to do more experimentation/exploration/goofy stuff with SQL Server at home. I’ve got a couple instances running now, but I’d like to branch into playing with pre-release stuff. This would be easier with a hardware budget, but I’m pushing that envelope as it is, already. Part of what’s holding me back in this department right now, is the simple fact that I don’t really know what to do with myself if I don’t have big DBs with a lot of users hitting them really making things work. Basically, I don’t function well when I don’t have a problem to solve :-)…I’m going to work on either fixing that next year or figure out a way around it.

Big Bookmark, Skinny Book

I'm going to have bookmark problems

I’m going to try to read more next year. I have no idea how I’m going to pull this off, because I read stupidly slow, so it takes me forever to get through anything. I’ve cleaned up my backlog of SQLServerCentral dailies so they’re not so overwhelming, and cutting my losses on some older SQL books that I haven’t made it through. I don’t think I can do anything about my blog feeds, because so many of you guys out there write good and useful content (unlike me).

I hope to get a quick win on the book front by reading Tom LaRock’s (blog | @SQLRockstar) book, since it’s thinner than pretty much everything else I have around here. In fact, it might be a little too thin (see pic). I’m hoping that a quick win there will help me build some momentum. Maybe I’ll magically be able to read faster, too.

Other/Misc

The first other topic is this Blog. I need to spend more time and effort on it, especially when it comes to writing good technical content. So far, I haven’t done a good job at that. That’s partially due to my job situation, but I could be doing more anyway. I hate setting arbitrary numerical goals, but I think I’m going to do it here: 26 posts. That’s an average of one every two weeks, and I should be able to pull that off. I’m not going to get overly detailed and say that “20 of them need to have good technical content”, I’m only going to go for an overall number.

I used to bicycle a fair amount. It hasn’t been the same since I was in college, where I put 30-35 miles a week on the bike just going to class & work. Back then I did a fair amount of mountain biking, too (which is what I’m really in it for), and spent a couple years running races in the Indiana statewide series, DINO. The last few years have been really lacking in that department, both causing and exacerbated by me being fat.

Next year, going to fix that & spend more time on the bike. I’ve already started to do some work on the trainer, and when it warms up, I’m going to move it to the road around the house. We live almost as far away from good bike trails as we did in IN, but I’m going to make an effort to not let that be in my way as much as it has been in the past.

This talk of biking has made me realize that I’m going to need some form of case or other padding for my new phone. The one time I went on a trail this year saw me doing an awesome, completely unintentional half backflip on the bike. I wound up flat on my back, still clipped into the pedals, holding the bicycle up in the air above me. The problem is that I carry my phone in my Camelbak; although the old Samsung i760 lived through that without a problem, I’m pretty sure the Focus would be broken in half. Soooo, need to do something about that.

My Non-Y2K-Compliant Logbook

My Non-Y2K-Compliant Logbook

The final thing for next year is flying. I got my Logbook out recently and thumbed through it. There’s some good stuff in there. The last time I flew was February 2005. I don’t even have the tail number of the airplane or the hours of the last two flights. Just have the landings (2 for one, 1 for the other). I know they were both in one/some of the Skyhawks at Lafayette Aviation, Tammy was with me for one of them, and I had to wait to take off on the single landing one because the visibility was crap**.

Anyway, since then, I’ve waffled back-and-forth between missing flying and being OK with how things are, because flying is freakin’ expensive. But, with the TSA thing and me more and more wanting to get back into it, I want to start flying again next year if I can find the money for it. This does mean that I am supposed to work on my Instrument rating (so I can fly in the clouds, basically), because I promised myself that a number of years ago. So… there’s the last thing for next year: Get Instrument Ticket if I can find the room in the budget.

There we are. 2011. Please don’t hold me to this stuff, because, you know, they’re not goals; just stuff I want to get done 😀

**That one was actually sorta fun, because it was late in the afternoon and the visibility was crap due to a fairly dense haze layer. We finally took off (oh hey, this is the one with Tammy. This means she was only with me for one landing. Hahaha, stay tuned for awesome stories.), flew around the pattern, annnnd then turned final, which happened to be directly into the sun. Bam, couldn’t see anything. I mean, seriously, in-flight visibility was maybe 1/2 mile, and I was on a mile final. I grumped about this to the controller as I flew runway heading, knowing that it would eventually show up ahead, and he was all, “Yeah, the last guy said it was pretty bad.” Yeah, thanks for the heads-up, pal.