Knight’s 24-Hour Trainer, Microsoft SQL Server 2008 Integration Services – Book Review

As part of a recent job transition, I found myself needing to quickly come up to speed with the basics of SSIS 2008.  In searching out a good tutorial to help me get back up to speed with the current technology, I quickly settled on Knight’s 24 Hour Trainer as a book that would meet my needs for a few different reasons.

  1. I was already familiar with Brian & Devin Knight from, well, everywhere.  Seriously, if you are at all interested in learning SSIS or the SQL Server BI stack, you can’t avoid these guys – not that you’d want too.  From BIDN to SQLServerCentral to PragmaticWorks these two are everywhere and well respected.
  2. The book seemed to cover all the basics of SSIS from A to Z in a thorough manner without overkill.
  3. Training videos are included on DVD for each lesson in the book.
  4. At $30 bucks on Amazon, the price is right.

What this Book is

If you are looking for a basic introduction to SSIS, this is your book.  It will walk you through the steps of installing Microsoft Business Intelligence Development Studio (BIDS) and take you all the way to creating, configuring, and deploying SSIS packages for a data warehouse.  The book touches on most all of the major transformations, sources, and destinations within SSIS.  The book also helps guide you towards best practices and using the correct tool for the correct purpose. 

Along with all of this, the book is able to guide you in a very systematic, structured approach to learning.  If you start at the beginning of the book and work your way through it, you will find that each lesson builds on prior lessons.  Additionally, the projects get more and more complex and involved as you progress.  While this is not a revolutionary learning model, it is well executed in this book and serves its purpose well.

What this Book is NOT

Do not buy this book if you are looking for an all inclusive reference for SSIS.  While it covers most of the major topics for SSIS, it would not serve you well as a development reference book. If you are looking for a solid SSIS reference, you’d be much better served buying a book like Professional Microsoft SQL Server 2008 Integration Services also co-authored by Brian Knight.

Finally, the end

I would highly recommend this book as a quick alternative to a basic  SSIS course.  There are loads of hands on examples, it’s laid out very well, and it does a great job of covering the fundamentals of SSIS.  If you are new to the Microsoft BI stack, looking to quickly study up on SSIS, you will enjoy this great resource.

Like it? Tell others!
  • Facebook
  • del.icio.us
  • Technorati
  • TwitThis
  • Google Bookmarks
  • LinkedIn
  • Live
  • StumbleUpon
  • Digg
  • Identi.ca

Dawn of a new day… BI, SQL Server, SSIS, and me

Clearly from the lack of current content and very inconsistent updates, my vision for this blog has been a bit cloudy as of late. For about the past year (or two), I have really struggled to find both the motivation and time to write anything that would be useful or interesting for others to read. Thus, I have written nothing. In the past 3+ years I have written about my health, reams of stuff about running, swimming, and other fitness pursuits (which I am still pursuing, but not writing about), and various family updates and pictures. These are all very interesting topics to me but, most likely, not useful nor interesting to anyone else. And while these topics kept me writing and improving, they were not really focused on any one area nor were they helping me professionally.

The Turning Point

Recently I read a great blog post by Brent Ozar titled, “Rock Stars, Normal People, and You” which really hit home with me. For those of you who don’t know (if there are any readers left out there), Brent Ozar is a Microsoft SQL Server MCM and MVP, DBA, author, and seemly (only because I haven’t met him) all around great guy. The post was a rewind of where Brent had been, what was wrong with where he was, and what he did to make things better and improve his professional life. A considerable part of the post revolves around his career path, various missteps, and what eventually led him to a successful fit with a company and career, but the undertone of the post – and the part that had the most impact on me – revolved more around his personal accountability for his career. In a nutshell, his theme was if you want a successful, fulfilling career you have to go get it. You have to make it happen. It’s not going to fall in to your lap. No one is going to hand you the perfect job. Most importantly, you need to start now – right now – find something you are passionate about, work hard at it, and success will come your way. The Rock Stars of today were once the Normal People sitting in the next cube over.

I’m not entirely sure why this particular post had such an impact on me. Most likely because it was saying loud and clear what I have been avoiding to say for some time – I am solely responsible for my career and only I can make it either wildly successful or a dismal failure. I can be happy, passionate, and driven about what I do or I can be a mediocre clock puncher, looking forward to the end of the day.

I’m Going to be a Rock Star (Some Day)

The good news is that I am personally at a great point in my career and I am looking to move things to the next level. While Brent’s post spoke to me, it has really been over the past couple of months that I came to the realization that the career path I was headed down was not for me, not where my passion was, and not what I saw myself doing long term. You see, I started my career on the tech side of IT – doing the work, learning the technology, interacting with my peers – and I loved it. Loved it so much in fact that I thought the best thing for me was to step in to management and help run the teams that build stuff. Seems like the next step, right? And, in fact, this was good for a while and I did well. I was successful. I started a brand new team, positively impacted IT processes, and generally made things some better. However, while I was continuing to be successful as a supervisor – I was failing to figure out how to take things to the next level, how to go from doing a good job and getting things done to being instrumental and a true leader within the organization.

So What to Do?

After some personal reflection and a few very candid, yet positive, discussions with my manager I came to the realization that my passion is not in managing – my interests and passions lie in doing and building and finding creative solutions to tough technical problems. All the stuff I have been tasking my team to do is really the stuff I want to do myself. Coincidently, the team I have been managing has been looking for a senior level developer. With my manager’s approval, as of April 12th I am no longer the Supervisor of the Business Intelligence team; I am now a Sr. Systems Developer in Business Intelligence. Finally, I work for a company I believe in (www.capella.edu), I have manager that seems to have faith in me and my skills, and I really believe that I have a lot to offer – both to my company and the SQL Server community as a whole. I have a wealth of knowledge and experience in business intelligence and I have a hunger to learn more and become better at what I do. Oh yeah, and I know how lucky I am.

Next Steps

I feel like I have a world of possibilities ahead of me and that’s great, but I also realize that I need to focus and have a plan. I also know enough to know that I have a lot to learn. With that, I have a few things in mind…

  • Network – leverage the great local SQL Server community to help expand my knowledge and have resources to call on when I need help.
  • Learn – read, read, and read more.
  • Challenge Myself – I need to take on the tough tasks, work through them, and grow from the challenge
  • Write – pass along the things I learn to others. I need to remember that even though I don’t know everything, there are others out there that know even less than me and may benefit from what I have to say.

I know this isn’t really a detailed plan, but it’s a start. I’ll add more detail as I figure it out…

Like it? Tell others!
  • Facebook
  • del.icio.us
  • Technorati
  • TwitThis
  • Google Bookmarks
  • LinkedIn
  • Live
  • StumbleUpon
  • Digg
  • Identi.ca

New look… Same great taste.

Blogs are funny things. At times, writing and documenting my life on this website has seemed really important. I wanted people to read it, to like it, to really want to see the next post – the next installment of my life. However, in looking back, most of what I’ve written has been really trivial, here are some examples:

Another great workout today. 6 miles on the treadmill – tempo run. 2 miles easy (9:23 pace), 3 miles short tempo (7:47 pace), and 1 mile easy (9:2 pace) for a total of 6 miles. (link) – September 28, 2007

Being that yesterday was a rest day, today kicked off the actual workouts for my triathlon aspirations. My first workout was a swim workout and, while I have been swimming on and off for a while, it was a challenging and satisfying workout. Here are the details… link – December 10, 2008

I’m using this post to simply test windows live writer and see if I like using this to write and publish my blog content. So far, this is a great little tool.
I’ll keep working with it to see if it is going to be worthwhile. link – August 22, 2007

And on and on it goes… Aaron worked out… Aaron ran… Aaron Swam… Not very enlightening. Not even a very honest or open look in to my life. With that, there are a few posts that are very meaningful to me and important to the story of my life, like this one:

…the doctors were ready to fill me in on what was wrong with me, why I was feeling so lousy and what we needed to do to make things better. What they found was not good. When the Surgeon did my Gallbladder surgery he must have accidentally nicked my Abdominal Aortic Artery, so for the last week I had been bleeding into my belly. They called my condition a “Psudeo-Anurism”, meaning I was bleeding into my belly, but it was in a confined area; this is what was keeping me from bleeding to death. They rushed me (by Ambulance, code 3) to St. Joe’s hospital in St. Paul and I was in surgery less than an hour later. link – March 8, 2006

This was an important time in my life and I am so glad that I have it documented here and I can look back to this point in my life as a reminder of where I have been, what I have gone through, and why it is so important that I keep moving forward in a positive way. Everything can be taken away. This is a lesson that took me a long time to learn, but one that I’ll never forget…

So, on to the new…

As I said, when I look at the posts I have made (almost 300 at this point!) I think they reflect one part of my life, but maybe not the part that should be reflected. While I guess it’s ok that this blog shows how far I’ve run (or haven’t run), or how many hours I’ve logged in the pool, or how much I weigh – I think I can do more. I mean really, no one cares about this crap and – most importantly – in 10 years I won’t care about it either. If I’m going to take the time to write, shouldn’t it be meaningful?

So, with that, I am making a commitment to improve the quality, depth, and content of my blog posts. I’m going to write about things that are important to me – not what I think might be important to others…

Aaron

Like it? Tell others!
  • Facebook
  • del.icio.us
  • Technorati
  • TwitThis
  • Google Bookmarks
  • LinkedIn
  • Live
  • StumbleUpon
  • Digg
  • Identi.ca

Things went swimmingly…

Being that yesterday was a rest day, today kicked off the actual workouts for my triathlon aspirations. My first workout was a swim workout and, while I have been swimming on and off for a while, it was a challenging and satisfying workout. Here are the details:

WARM UP:
200 Swim – 200 Kick – 200 Pull

MAIN SET:
4 x 300 @ below 70% with :30 rest

Concentrate on being relaxed in the water and getting the “feel” of your stroke. Speed is not important here. Your stroke count should be even every lap of every repeat.

COOL DOWN:
200 easy swim, continuous

Overall, not a bad workout – 2000 yards. It said it was supposed to take 45 minutes, it actually took a little less than that.

Tomorrow brings and hour and 15 minutes on the bike. We’ll see how that goes…

Bye for now…

Aaron

Like it? Tell others!
  • Facebook
  • del.icio.us
  • Technorati
  • TwitThis
  • Google Bookmarks
  • LinkedIn
  • Live
  • StumbleUpon
  • Digg
  • Identi.ca

I’ll Tri Anything…

Sorry it has been so long since I’ve updated. I’ll try to keep everyone up to date a little better from now on, but we’ll see how it goes – I’m not making any promises of daily (or even weekly) posts. I’ll do the best I can!

Today started the first week of a 39 week triathlon training program that I’m using to get in shape for next spring/summer and the triathlon season. Hopefully if everything goes as planned, I’ll update my training here, once a week.

If you are interested, you can look at the training plan here. Monday’s (like today) are a day off – great way to start! Tomorrow is a swim day.

In the end, there are a few little nagging details I need to work out before I have an actual race. For example, I don’t have a bike suitable for a triathlon. I have a bike, actually a really good bike, but it’s one of those “comfort” style bikes. Great for hauling the kids around in the bike trailer and pedaling around the local parks, but I think the 2 inch wide tires and 30 pounds of bike would slow me down a bit in a triathlon. So, with that, if you have – or know anyone that has – a good road bike they’d like to lend me for next spring and summer let me know!

Another detail I need to figure out is what races I’m going to do. I’d like to do the North Mankato triathlon in June, but other than that I’m pretty open to anything within a couple hours drive of the Twin Cities. Any advice is welcome – if you’ve raced somewhere and had a good (or bad) experience, let me know!

I’m totally new to the whole triathlon experience and I’m looking forward to everything it has to offer. From what I can tell so far, this training program will get me in great shape and the constant change of pace will be nice. After only doing running for the last 3 years, getting something different in the mix will be fun!

I’m sure I’ll have more questions and comments as this moves forward. I’ll post them here and I look forward to sharing them with all of you!

Keep running, swimming, and biking!

Aaron

Like it? Tell others!
  • Facebook
  • del.icio.us
  • Technorati
  • TwitThis
  • Google Bookmarks
  • LinkedIn
  • Live
  • StumbleUpon
  • Digg
  • Identi.ca