January #Meme15 Round-Up

Logo for meme15 The second round of #meme15 finished up last week and it’s time to see who participated.  In total, there were fifteen people that participated in the event.  If I’ve missed anyone, just leave a comment here and I’ll update this post.

As a refresher, #meme15 is dedicated to discussing and sharing tips and tricks for blogging and using social media.  This can be from a personal or professional standpoint.  The intent is that through these posts by myself and others will provide some insight into how to succeed in these areas. This month’s writing assignment was:

  • Why should average Jane or Joe professional consider using twitter?
  • What benefit have you seen in your career because of twitter?

Here we go with all of the posts, in pretty much the order I read them:

Take some time and read through what the bloggers here have had to say about twitter.  If you aren’t on it yet, it’s definitely time to get in on the fun and start growing your career.  If you are, take a look to see if there are other ways you can leverage twitter in your career.

Posted in Professional Development, Social Networking, SQLServerSyndication | Tagged , , | 2 Comments

Re-blog – January 20 – January 26

BookWelcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have some free time or interest, check out the links below from years past to see what you may have missed.  The posts to check out this week are:

Enjoy.

Posted in SQL Server, SQLServerSyndication | Tagged , | Leave a comment

Nooner Viewing Summary

Over the last few weeks, I’ve been watching SQL Server videos and webcasts.  My primary motivator in doing this is to help myself prepare for re-taking the SQL Server MCM Lab exam

After watching a few presentations, I thought it would be good to take some time to share the ones that I find most useful and interesting.  Instead of cramming my blog with a hundred webcast reviews, I’ll be posting the nooner webcast at noon every day and summarizing them here on Fridays.

Hope you enjoy this information.


Investigating parallelism and the CXPACKET wait type

This session, from SQL Bits 8, is presented by Christian Bolton (Blog | @christianbolton).  In it, he breaks down parallelism and explains how it all fits together within execution plans.  My primary take away from this session was how different coding choices can affect whether or not parallelism will be utilized, such as inserting into a table variable.

Consolidating data collection with SQLDIAG and analysing it all with SQLNexus

Another session by Christian Bolton and also from SQL Bits, this time though it is SQL Bits 7.  In this session, Christian goes through the SQLDIAG and SQLNexus tools and explain how and where they fit in with troubleshooting and performance monitoring.  I’ve wondered about these tools for a while and after this session, I’m definitely raising the priority to start using them.

Inside SQL Server Latches

At the 2010 PASS Summit, Bob Ward (Blog | @bobwardms) presented an amazing session on latching within SQL Server.  There isn’t enough information out in the world about how latching works and what it is.  This session fills that gap by leaps and bounds.  After watching it twice now, I know I need to watch it again.  Really deep and amazing information.

Understanding XQuery

Another presentation from the 2010 PASS Summit, this time it is from Dejan Sarka (Blog | @DejanSarka).  In this session, Dejan goes through the basics of XQuery and XML and walks through some simple example of querying and using FLWOR.  If you are a DBA that isn’t familiar with using XQuery, its time to learn and this session will provide a good start.

Locking

The last session for this week is Paul Randal’s (Blog | @PaulRandal) Locking session from the MCM Readiness Videos.  I’ve watched this webcast more than a few times.  It walks through how locking works within SQL Server and the block and deadlocking that can occur because of it.  The information in this session may seem fairly basic, but it’s fundamental to how SQL Server works and worth looking at again and again.

Posted in SQL Server, SQLServerSyndication | Tagged , , | 1 Comment

Re-blog – January 13 – January 19

BookWelcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have some free time or interest, check out the links below from years past to see what you may have missed.  The posts to check out this week are:

Enjoy.

Posted in SQL Server, SQLServerSyndication | Tagged , | Leave a comment

The Value of Twitter #meme15

Logo for meme15

Last week, I posted this month’s question for #meme15.  As was mentioned in that post, the aim of these posts by myself and, hopefully, others will provide some insight into how to succeed in social networking areas.

The questions for this month are:

  • Why should average Jane or Joe professional consider using twitter?
  • What benefit have you seen in your career because of twitter?

Value to the Average Jane/Joe

Twitter is an interesting beast.  To the outsider, it’s 140-character messages about the food we are eating, what we are wearing, and the latest Barbie fashions.  But when you peel back the and look under the surface, twitter is much, much more than that.

When you understand twitter in a professional light, you find that you are transported to a strange universe where stalking your peers is a good thing.  With twitter, you can follow anyone that is already using it.  Making people such as Denny Cherry (Blog | @MrDenny), Thomas LaRock (Blog | @SQLRockstar), Brent Ozar (Blog | @BrentO), or, even, Paul Randal (Blog | @PaulRandal) your pseudo-coworkers.

Let’s be clear, this doesn’t mean that they’ll show up at your desk and do your work for you.  But they are “virtually” hanging out at the twitter “water-cooler” sharing their days and will, at times, lend a hand to solving problems you may be facing.  Even more, many people in the SQL Server community use the #sqlhelp (more info) hash tag to ask questions and offer assistance to each other.

The number of people in the SQL Server community that use twitter is extremely vibrant.  And these connections are easy to make.  There are no judgments about who you are, what you do, or what you look like.  The community is about the conversations that we have.

This bring us to the last point on value that the average Jane/Joe can find through twitter.  With twitter, we are never “going it alone”.  You may work in an environment where you are the only DBA or developer, but with twitter there is always someone to turn to.  Or if you there are other DBAs and developers, you may have the minority view point in a discussion.  Twitter provides that outlet necessary to find others to relate to or to validate your position.  And while you may not find what your view points are correct, we are there to help you out.

Career Benefits

As I’ve thought about career benefits that I’ve had through twitter, I realized that it could easily fill pages and pages to highlight the places where twitter provided me value.  Instead, I’m going to highlight a few places that have stuck out to me:

  • It helped me connect with the Program Committee for the 2009 PASS Summit.  By getting to know the members of the committee, it helped them know who the person submitting the sessions was. Which I believe helped me speak at the summit for the first time.
  • I was recognized, at the summit, by some community members that I look up to.  Even getting recognized and told that I didn’t look like my profile picture.  But I was recognized.  The benefit here was really that I was making an impact through my use of twitter and reaching people.
  • Since I started using twitter, the number of readers for my blog has grown tremendously.  From a dozen or so views a day a few years back to the record breaking 3,000 views I had last week.
  • The network of professionals that I can tap into has grown from just the few people that I work with between my customers to a global network.  Some of the people from this growing network were even invited to my wedding last summer.

In many ways, twitter has impacted my career and it can impact yours as well.  Take it for a spin and put some effort into it, the investment in your time my be a big payoff in your career and maybe a position that matches all of your dreams.

Posted in Professional Development, Social Networking, SQLServerSyndication | Tagged , , | Leave a comment

Re-blog – January 6 – January 12

BookWelcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have some free time or interest, check out the links below from years past to see what you may have missed.  The posts to check out this week are:

Enjoy.

Posted in SQL Server, SQLServerSyndication | Tagged , | Leave a comment

January #Meme15 Assignment

Logo for meme15

Last month, a number of us got together to share how we use social networks to enhance our careers and professional development.  For lack of a better name, these blog posts will be called #meme15.  The last assignment looked at blogging and why people started and why they continue.  For an idea of what people talked about last month, check out the round-up for the assignment.

Before we get to the assignment for this month, let’s go over a few guidelines for this:

  • Answer the question(s) with as much or as little detail as you wish.  Try to stay true to the heart of the question, but answering where it connects to you.
  • Watch for the new assignment about 8th, or the Monday after the 8th if it falls on a weekend.
  • Post your answer on the 15th, or the Monday after the 15th if it falls on a weekend.
  • Include the #meme15 logo your post (courtesy of Matt Velic (Blog | @mvelic))
  • Comment on the assignment blog post or trackback to it

#Meme15 Assignment #2

The second writing assignment for #meme15 will be to talk about twitter. The post should answer one of the following or both:

  1. Why should average Jane or Joe professional consider using twitter?
  2. What benefit have you seen in your career because of twitter?

You’ve got a week, happy writing.

Other SQL Community Memes

If you aren’t already participating, there are already a few going on in the community #TSQLTuesday, #MemeMonday, and Un-SQL Friday.  Watch for those for opportunities to blog without having to come up with your own topic.  Beyond having a easy topic choice, they also provide a window for more people to see what you have to say.

Posted in Social Networking, SQLServerSyndication | Tagged , | 14 Comments

Re-blog – December 30 – January 5

BookWelcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have some free time or interest, check out the links below from years past to see what you may have missed.  The posts to check out this week are:

Enjoy.

Posted in SQL Server, SQLServerSyndication | Tagged , | Leave a comment

31 Days of SSIS in a PDF

31 Days of SSIS

At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts into a single document.  I never got around to distributing it.  No real good reasons.

So, if you want all of it in one place.  Here it is… 31 Days of SSIS

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, SSIS | Tagged , , , , | Leave a comment

PASS Summit Eval – Extended Events

As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I spoke.  The first session went great, but the second was even better. 

The second session was as the last time slot on the last day and I didn’t expect to see anyone in the room.  I had made a couple bets that there would be 10 or so people in the room.  I was wrong, dead wrong.  The room was packed and the official count was 122 people in attendance.

The second session was Extended Events, Work Smarter Not Harder:

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

Overall Ratings

As with the last session, the ratings for this session were pretty good.  All of them were above 4.5; which means @dancem0m buys me a free lunch at Fogo de ChaoI should tell her that.  In all seriousness, though, I like where the scores landed, I think the practicing and experience in presenting is paying off.

How would you rate the Speaker’s presentation skills? 4.66
How would you rate the Speaker’s knowledge of the subject? 4.80
How would you rate the accuracy of the session title, description and experience level to the actual session? 4.77
How would you rate the quality of the presentation materials? 4.58
Did you learn what you expected to learn? 4.72

Commentary

Of course, I like comments.  They help provide some context for the scores.  And the comments from this session were pretty good.

Did you learn what you expected to learn?

  • Great job – Thanks
  • Great session by Jason. Excellent presentation – Thank you!
  • Not sure
  • Yes I
  • Think it was a little more advanced starting out but eventually made sense

How would you rate the accuracy of the session title, description and experience level to the actual session?

  • Spot on!

How would you rate the quality of the presentation materials?

  • Should’ve been a spotlight session – Oh, the demos I could have done with 15 more minutes.
  • Could have been much longer
  • He didn’t have all his demo scripts but this was a minor detail – Yeah, one of them was missing.  Found it afterwards – somehow got dropped from the project.
  • Really found the demos helpful
  • Awesome xml to file folder comparison
  • nice slides, I liked the puppy w/rose – Hehe, so do I.
  • graphs were really helpful
  • Good example of transaction log shrinking
  • Truly superb
  • like the consultant perspective – Glad to hear this one.  Sometimes I wonder if this works well. 

How would you rate the Speaker’s presentation skills?

  • Talks too fast sometime – As I mentioned before, I do this.  I blame Minnesota and a topic that really excites me.
  • Speaker tended to speak rapidly and disjointed (meaning tended to digress rapidly on and off topic). Needs a more paced and focused approach. – I do tend to do this.  May be worth while to bring back the crib notes I used to keep on the podium.
  • A little too many jokes which took away from the overall – Yeah, there were more than usual.  Not sure where they all came from either.  In my defense, I had a great time.
  • Quality
  • Engaging
  • very confident speaker, great humor – And then there’s the other side of the coin.

What will you take away from this session?

  • Ability to use XEvents in my environment.
  • Just as with Jason’s experience, I now have something I can use right away.
  • Love the out of the box stuff and examples.
  • Will start working on extended events immediately!
  • Makes monitoring much more easier
  • good stuff
  • good info
  • What I need to get started in use of XE
  • The need to push organizing harder to move from sql2000/2005 to sql2008r2
  • external events are a viewable and accessible troubleshooting tool
  • Something to study so I can use it later
  • everything
  • I will implement this on Monday
  • Deadlocks are part of the black box trace
  • homework to review the x events
  • cool things to try
  • that I really need to start utilizing xevents n shorten troubleshooting processes
  • buy the SAN admin lunch and a beer
  • I’ll have another hard look at extended events
  • more testing, look at implementing this immediately!
  • Use extended events!
  • Super awesome ammunition for arguments

What would you change to improve the overall quality of this session

  • nothing. Excellent session with tons of practical examples
    should start with very simple demo/example. Talk at first lost me took awhile to figure out what was talking about and how it could be useful
  • great presentation
  • very neat. can’t wait to try it. You are odd
  • do a demo first! Had no idea what he was talking about for the first 15 minutes – I’ve done this in the past, the trick is finding the right demo.  May need to give this another shot.
  • Don’t know!
  • All good.. well done as always

Summary

It’s extremely gratifying to see all of the positive feedback.  And the criticisms above are justified, they are definitely areas that I try to work on.  The jokes part – it’s all about balance and very tricky.  If you haven’t looked at Extended Events, take a look at the session on the Summit DVDs, let me know what you think. Thanks again to every one that attended.

Posted in Conference, PASS, Presentation, SQL Server, SQLServerSyndication | Tagged , , , , | Leave a comment