Tag: Professional Development

Exam: 70-448 SQL 2008 BI Dev and Maintenance

In conjunction with my professional development plan, on June 1st I took the 70-448 exam: SQL Server 2008 Business Intelligence Development and Maintenance, which I passed. Hazzah!

With most of my SQL Server career involving SSIS and SSRS, I  felt comfortable in those areas. I have only done a little bit of SSAS, so I knew that was where my prep needed focus. I ended up using the Microsoft Press Self-Paced Training Kit as my main preparation tool. I read pretty much all of it, making sure to learn more about SSIS and SSRS tools and techniques I had not played with. For the SSAS areas, I also performed all of the hands on practice exercises. This helped a lot in making up for not having a lot of SSAS experience. Overall, I found this book to be a very good prep tool and would recommend it to others who are looking to take the 70-448 exam. Also, I found the exam had really good balance between SSIS, SSRS, and SSAS. I had heard from colleagues that the 2005 version was not as well balanced.

In passing the exam (by a much better margin than I expected), I accomplished my main goal for taking it: measuring how much I have learned in the BI space. And I picked up a new MCTS cert in the process. Not a bad day.

Now that this exam, and the prep for it, are behind me, I am digging deeper into SQL 2008 R2. I just set up my Windows 7 laptop to dual boot Server 2008 R2. I set up Hyper V and have a VM with SQL Server 2008 R2 installed and configured. Looking forward to digging in. A Sharepoint colleague also sent me the link to the 2010 Information Worker Demonstration and Evaluation Virtual Machine (RTM). I will be using that to play with the new SSRS features of R2 that related to Sharepoint 2010.

Mmmmmmmm….more learning…mmmmmmmm

No Presenting, Please

When I walked into class on the first day of Acting II at the University of New Hampshire, the chalk board at the front of the room was empty except for three words: “No acting, please.” Yeah. This was an acting class. At first, this made no sense to me, but soon it was crystal clear. Our teacher, David Kaye, taught us if you are truly connected to your character and the scene, then “acting” gets in the way. The key is to be so open to your character that you don’t need to act. If your character is terrified, and you are fully committed to what you are doing, then you ARE terrified. This is achieved through researching the material/character/setting and rehearsal: homework. I didn’t know it at the time, but I learned a great deal about presenting in that room.

When I present, I try to keep a conversational tone. I don’t want to talk at my audience. I want to connect with them. If I’ve done my homework and know the material, if I have rehearsed, then I can focus on sharing the material instead of reading it from my slides. Rehearsal also helps you stay comfortable and avoid speaking too fast due to nerves (done that one). It can be hard, but it is totally worth it when your audience sees how relaxed you are and how much fun you are having. This audience comment from an evaluation of a presentation I did shows that this effort makes a difference:

Good presentation skills – like the "breezy" style

Keeping things relaxed also allows me to pepper in some humor here and there. That can help a lot, too. Sitting through overtly serious, monotone presentations can be painful. I don’t want to do that to anyone. Now, for me, planned humor is a real challenge. I did Improvised Comedy in college and it was perfect for me. I can’t tell jokes to save my life; I would be horrid on Last Comic Standing. But, what I can do is come up with one liners off the cuff. That works for me. But whatever works for you, be it funny images in your slide deck or a well timed rubber chicken, try to work some humor into your presentations if you can. It can pay off, as this audience comment shows:

Good sense of humor!!   Very nice presentation.

Another aspect of the “No acting, please” lesson has to do with honesty. If you really commit to your character, then you show the audience that you believe in what you are doing and they are far more likely to come along for the ride. In terms of presenting, for me that means being open about what I know and what I don’t know. Nothing wrecks credibility like making sh!t up. When I don’t know the answer to a question, I am honest about that. But I don’t just say “I don’t know” and move on. If I don’t know, then I make the effort to point them in the right direction or have them contact me afterward so I can try to track down their answer. This helps a lot, in my opinion, as this audience comment shows:

Let us know what he did and did not know about the subject!

Whether I am presenting at clients or at a user group, etc, I try to keep keep the above in mind. The feedback I have gotten from clients has been great. My presentations at the Minnesota chapter of PASS have gone over really well, too, both averaging 4.4 our of 5 on the audience evaluations. This success is not because I have presented humteen million times or because I wear bright yellow pants, but rather because I have a strategy that works for me.

My advice to new presenters is to find a strategy that works for you. If any of the above work for you, do it. If bright yellow pants work for you, wear them. If it helps you to picture your audience in their Fruit of the Looms, go for it (but, take my word for it: don’t stare). Whatever you need to do to keep things relaxed and fun, bring it.  Share what you have to say like you are showing something really cool to a friend. Above all though, don’t force it. No presenting, please.

My PASS Summit Submissions

Alrighty then. For the first time in my career, I tossed up some submissions for the PASS Summit. Both are topics I have a passion for and I would absolutely LOVE that chance to present either one…or…dare I say…both? Well, here they are. Here’s looking at you, PASS.

Empowering Your Users With Report Models

Who really knows your data better: You or the marketing manager that spends a lot of time tracking sales from yesterday, last week, etc? How much quicker could that marketing manager get the information she needs if she could create her own reports? With the power of Report Models, she could do just that without having to write a single SQL statement. This presentation will discuss how to create, maintain and secure SSRS Report Models. It will also show some tips and tricks learned through real-world experience implementing and supporting report models for clients.

Where Do You Want To Go Tomorrow?

You dress differently for a wedding than you do for baseball game, right? …Right? Even with mundane, everyday tasks like getting dressed, your future destination has an impact on your current behavior. Whether you realize it or not, even the simple act of getting dressed in the morning involves a little planning. Doesn’t your professional future deserve some planning, too? This presentation will discuss the power of Professional Development Plans and the building of your very own brand through blogging, presenting and effective use of social media like Twitter. I will show you how you can use all of the above to take ownership of your future and turn your job into a career.