T-SQL Tuesday #014 – Resolutions

January’s T-SQL Tuesday is brought to us by Jen McCown (Blog|Twitter).  This is great timing because she was just named a Microsoft MVP -congratulations Jen!  For this month’s topic, Jen has asked the question “what techie resolutions have you been pondering, and why?”

As I mentioned in my recap of 2010 goals, I’m not a big believer in making New Year’s resolutions, and even if I do make them I don’t obsess and worry about them as the year progresses.  So when I first read Jen’s topic for this T-SQL Tuesday, my first thought was “Great, I don’t do resolutions, now what?”  Fortunately, it didn’t take long to figure out how to proceed.

With a little reflection, it occurred to me that I don’t make New Year’s resolutions because changes in my life happen often enough that some (or all) resolutions become irrelevant.  Also, Jen asked about techie resolutions, rather than resolutions in general.

So all I needed to do was come up with one or more techie resolutions that I’ll want to pursue even if I encounter (or initiate) some changes this year.  This turned out to be quite easy.  With some thought, I realized that I had already been planning to increase my skills in the following three technologies during 2011.

  1. Powershell – Thanks to sessions I attended and discussions I had with Aaron Nelson (Blog|Twitter) and Allen White (Blog|Twitter) last year, I’ve done some little helper scripts in Powershell and want to turn up my game here in 2011.  I know enough now to have a feel for the capabilities.  Thus, I increasingly encounter situations that could be addressed with Powershell, but they’re more advanced than my current level.  So it’s time to increase my skills here.  I think a good way to proceed would be to take some of my Windows .bat batch files that already work fine and replace them with Powershell scripts.  This way, I don’t have to worry about time constraints in the way that I would if trying to use Powershell to create new solutions.
  2. BI Stack in SQL Server – In other words, SSIS (Integration Services), SSAS (Analysis Services), and SSRS (Reporting Services).  I work in business intelligence, but we roll our own solutions.  Last year I began wondering if these three components in SQL Server might be worth some consideration.  So I attended sessions and seminars in 2010 to learn more about them.  As with Powershell above, I’m hoping this year I can take an existing solution and try implementing it with one or more of SSIS, SSAS and SSRS.
  3. Get back in the Open Source saddle – Until a several years ago, I worked in a mixed Linux/Windows shop.  Our plan was to gradually retire Windows and move everything to Linux.  I mostly worked with Linux, Java, Apache, MySQL, PostgreSQL, Bash, Perl… It was a great time for me, because these were the technologies that excited me so much that I left doctoral study (I was working on my PhD in accounting) to become a software developer.  I was so, so very happy.  Until suddenly one day, we had a leadership change, and the word went forth that we were moving everything to Windows and Microsoft components.  Overnight (see, this is the reason I don’t make resolutions) I was immersed in increasing my skills in .NET, C# and SQL Server.  The good thing is that I enjoyed this experience, but the bad thing is I’ve let my knowledge with Linux and those other open source components get rusty.  I need to remedy that, and it will be difficult because, unlike the first two items, this won’t fit in the things I do at work.  Thus, I’ll be on my own here, which makes the motivation a bit more difficult.  Note that I don’t want to stop working with SQL Server.  It’s just that once upon a time I was working daily with SQL Server as well as one or two other database platforms.  I want to be able to do that again.

So would I pursue these three interests regardless of what does or doesn’t happen in my work life this year?  Yes, I definitely would.  However, there’s an interesting thought that didn’t occur to me until discussing this post’s topic on twitter with Erin Stellato (Blog|Twitter) last week.  As you’ve seen, I listed three items above.  To be honest, it’s a somewhat ambitious list to fit into my schedule this year.  What if I had to pick just one of these?  Well, if I had to choose something just on its own merit, then there isn’t an easy answer.  I could only make this choice in the light of some stated objective or goal.  So that’s something that I’m now rolling around in my mind.

With that, I’m looking forward to reading all the other contributions to this month’s T-SQL Tuesday and seeing what others have resolved to do this year.  Thank you very much to Jen McCown for hosting T-SQL Tuesday #14, and thanks again to Adam Machanic (Blog|Twitter) for coming up with this monthly event!

About Noel McKinney

Noel McKinney is the administrator of noelmckinney.com
This entry was posted in T-SQL Tuesday and tagged , . Bookmark the permalink.

6 Responses to T-SQL Tuesday #014 – Resolutions

  1. Looks like we’re all going to put time into PowerShell this year. Have you picked up a copy of Learn Windows PowerShell in a Month of Lunches? I’ve just begun, I plan on finishing it in two months, since I have several other resolutions this year!

    Good luck with your learning this year!

    • Hi Shannon, I haven’t picked up that book yet, probably because I work through lunch 🙂

      Thanks for your comment, I just read your post and you have quite an ambitious list… Good luck with the cert exams and the other items on your list, it should be an exciting year!

  2. Erin Stellato says:

    You have good goals, I like them. My challenge is keeping focus because every month, it seems, I find something new worth learning about. The key to that is to make the goal relevant to something in life/work – make it useful. So if you are able to extend PoSh to have it add value to what you’re already doing, it’s easier to meet that goal. Same with BI (if you find a project for which it’s applicable). The Open Source may be more difficult, as you’ve noted. Regardless, you are farther along than most of the US 🙂 You have the goals and you’ve written them down. Sharing them with a community helps you see them through better, I think!


    • Sharing with the community is a big help, but I’m not someone who gets overly concerned about how others view me. So I’m not so sure how far along I am, because I won’t sweat it if these resolutions fall by the wayside 🙂 The big revelation for me in writing this post was when it occurred to me that of these three items, the one I most wanted to do was the one that most likely to fall by the wayside.

  3. Pingback: SQL Awesomesauce » Blog Archive » T-SQL Tuesday #014 Roundup

  4. Pingback: T-SQL Tuesday #015 – Automation in SQL Server | Noel NOT NULL;

Comments are closed.