Category: PASS

PASSMN June Meeting: What’s New In SSRS 2008 R2

I have been lax in promoting my local SQL users group, so here goes. Oh, by the way, it’s Lara’s fault that I am a SQL Server consultant. Thanks Lara!

June PASSMN Meeting & Newsletter
Sponsored by Magenic

There will be books, shirts and other swag at the end of the meeting!

Location:    8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
Date:     June 15th, 2010
Time:    3:00 – 5:30

Please click here for meeting details and to RSVP.

Registration has changed with the move from our previous hosting site and you will be required to log into http://www.sqlpass.org in order to register for our events. If you have any issues with this, please contact support@mnssug.org.

What’s New in SQL Server 2008 R2 Reporting Services

Lara Rubbelke (Twitter | Blog), Microsoft

Amp up your Reporting Services with the many great enhancements in SQL Server 2008 R2. Lara will take you on a tour of all that is new in R2 including collaboration features, new visualizations, rendering enhancements, and new data sources. After this session you will wonder why they call R2 an "interim" release!

Questions for presenters?
If you have any questions you would like our presenter to answer in the meeting, feel free to submit them ahead of time to support@mnssug.org or to any of the board members before the meeting. All question askers will be kept anonymous.

Other News
•       Live Meeting
   o    Beginning in 2010 meeting, you will now be able to join monthly meetings virtually through Live Meeting. This is a great opportunity to stay connected that has been provided to us by PASS.
•       SQL Azure Presentation
   o   Presented by Mike Benkovich at Twin Cities Cloud Computing User Group (TCCCUG)
   o   July 8th, 2010
   o   Click Here for more information
•       PASS Summit 2010
   o    Registration for PASS Summit 2010 is now open. Register for only $1,395 until June 30. Tap into your 2009 or 2010 training budgets to take advantage of the low rate for PASS Summit.

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.