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

PASS Summit Evals – Plan Cache Querying

This past year, I spoke at the PASS Summit for the second time. The first time was a couple years ago and it was not the best presentation that I had ever given.  This year, though, things went a little bit differently.

Originally, I was slotted for a single session, but after someone dropped out was offered the opportunity to speak at a second session. Over the next two blog posts, I’m going to share the evaluations that I received from the event. They definitely sucked less than the first time I spoke at PASS.

My first session at the summit was Discovering the Plan Cache:

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.

Overall Ratings

From a high level, the ratings are pretty good.  All were above 4’s and seem to convey that I have an idea of what I am doing.  Unfortunately, the rating scale doesn’t help me understand what I need to change to go from 4’s to 5’s.

How would you rate the Speaker’s presentation skills? 4.36
How would you rate the Speaker’s knowledge of the subject? 4.71
How would you rate the accuracy of the session title, description and experience level to the actual session? 4.75
How would you rate the quality of the presentation materials? 4.54
Did you learn what you expected to learn? 4.46

Commentary

Fortunately, people left comments.  I like comments – they can be related to and I thank everyone that left them.

Did you learn what you expected to learn?

  • Too much information to take in. – Yeah, I do that often.  The balance between enough and too much is often difficult.
  • Well focused
  • Awesome content and speaker. – Thanks
  • Learned what i wanted
  • Best session I’ve been to so far. – And thanks for this one.

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

  • Very accurate name – Yup, it is.

What will you take away from this session?

  • Most impressive talk at pass this year
  • Not much. I will need to re watch the DVD to absorb it all.    
  • Everything! I cant wait to get back to work and apply the knowledge learned.   
  • This course was awesome, lots to learn!   
  • I’ll go to the Microsoft site to check what’s possible with XML execution plans.   
  • A lot of good information that I can apply to my prod environment.   
  • How to use the plan cache to resolve issues in the environment I help support. A big feature is to get the execution plan from the cache.   
  • Explains real world examples for quickly identifying the worst problem.
  • Great session!   

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

  • Slow down on the examples. – I need to work on this some.  The Minnesotan in me wants to talk fast.
  • This was awesome!   
  • Nothing.   
  • Good presentation. Made topic very interesting – I think in any of the presentation I’ve attended. It is good to get audience participation as it keeps them more alert and get more from class. – This is one of my goals for the next year.  I’d like to pull people into the presentations more without losing the level or volume of information provided.

Summary

I’m glad so many people found the session interesting and informative.  Querying the plan cache can be a lot of fun and a good way to scale up your tuning practices.  If you watch the video 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