Tag sqlpass

The First Ever Log Reader Awards

Starting today, and ending on Friday, October 16th, you can submit a blog post, or series of blog posts, to the 2009 Log Reader Awards.

What is it?

You’re probably asking yourself “What’s a Log Reader Award?” Well, dear reader, a Log Reader Award is an award created by bloggers (myself, Andy Warren, and Brent Ozar) to recognize other bloggers for their excellence in writing across a number of metrics including style and technical knowledge. (Ability to recognize an Oxford comma is a plus, but not required.) We realize that it’s important to recognize people of all skill levels and that what makes a great introduction to a topic is not the same thing that makes up a deep dive into a single feature of SQL Server.

To make this easier, there are multiple categories: Book Review, Business Intelligence, CLR, New Blog (less than one year old, at least one post a month), Professional Development, Series (Multiple Posts), Server Management & Automation, T-SQL, and Unusual (it’s great, you love it, but it doesn’t belong in a previous category).

How does it work?

Well, you go to the submission form and enter your details. On October 17th, we take your list of submissions and review them. Keep in mind, though, that we’re only going to review the last two posts you submit. This is how we’re going to stop you from voting Chicago style. Only posts that you’ve written between October 15th, 2008 and October 16th, 2009 are eligible. You can’t submit your doctoral thesis on relational design that you wrote 15 years ago. We’re looking for current articles from active bloggers.

Your RSS subscription will look like this

Your RSS subscription will look like this

What do you get?

The satisfaction of a job well done.

No, seriously, what’s the reward?

In addition to the satisfaction of a job well done, you will also receive the praise and admiration of your peers. We’re working on ways for award recipients to show off that they are an amazing blogger. Oh, and we’ll be announcing the winner at PASS. In front of people. So it won’t just be me telling the coat check crew about you… everyone will get to know how great you are!

Random Thoughts for Enjoying the PASS Summit

Have as many mobile devices with connectivity available as possible.
Have a camera ready and charged.
Charge everything every night. Even if it’s at 95% charge: charge it.
Pick sessions that challenge you.
Pick sessions you know nothing about.
Make back up plans for sessions you want to see, just in case.
Don’t make plans.
Be flexible.
Don’t trust the wi-fi.
Pack light.
Don’t be afraid to ask vendors for swag.
Drink water.
Walk everywhere.
Wear good socks.
Plan to be tired.
Take a backup.
Carry a pen and paper.
Carry a pencil.
Carry business cards.
Don’t carry books – they’re heavy.
Plan on 5 nines of uptime – you can sleep during the maintenance window.
Caffeine is your friend.
Drink water.
Be open to conversation.
Don’t be afraid to start a conversation.
Introduce yourself to everyone.
Don’t loiter – stand and talk instead.
Slide decks are downloadable; conversations aren’t.
Carry snacks.
See the city.
Take time to breathe.
Take time to sit.
Don’t be afraid.
Learn.

I started this in the comments on Colin Stasiuk’s post – 4 Weeks Away from the PASS Summit and thought I would continue it here.

PASS Board of Directors Elections

Well, it’s election season at PASS. The fun part is that I’m running this year. That’s right, yours truly is running for the PASS Board of Directors.

So, here’s how it works: elections go from October 12th through October 20th. During that time you can vote. Up until that time… you can’t.

I have ideas about PASS. A lot of ideas. If you want to know about my ideas, check out the amazing video I made (I’ll be posting it later today) or feel free to get in touch. I do actually want to hear your thoughts, hear what you have to say, and be challenged to do a great job as a member of this great community that we’re all a part of.

You Can Virtualize Anything!

That’s right. Here at PASS we’re working on ways to virtualize everything. Not only can we virtualize away your web server and SQL Server, but now we’ve found a way to virtualize your user group!

We’re pleased to announce that PASS has several new Virtual Chapters dedicated to providing you with the finest quality SQL Server content made with the freshest virtual ingredients available on the market today.

So, what is a Virtual Chapter? Well, once upon a time these things were called SIGs. Then someone decided that these were more than just special interest groups (SIG, get it?). Now we have Virtual Chapters. Same great taste, now with 1/3 the calories!

Spread the world, tell people you know about the Virtual Chapters . This is a fantastic program and a great way for you to get access to SQL Server learning when you can’t make it to a user group or just feel like getting your learn on during the day.

Free and Cheap Stuff!

That’s right, free and/or cheap stuff. Right now you’re probably saying to yourself “ZOMG! He’s got free stuff!”

Free Stuff!

So, what do I know about that’s free?

Data Cleansing with SSIS – Eric Veerman is going to be talking all about data cleansing. You know, getting all of the crud and nastiness out of your incoming data. You know, the data where people have extra spaces in their name because your CRM system treats that as a different person and sales people can steal commissions if it’s a “new” customer.

SQL Lunch: Historical DMV Information Thomas LeBlanc is giving this presentation. Here’s what he has to say about it: DMV are great to find information about performance without running a trace. But there information is lost once the SQL Server service is restarted. After finding some useful scripts online (Thanks SQL Server community!!!), I decided to schedule a job to run the night before to store Index Usage, Least Used Indexes, SP Usage, Missing Index and Expensive CPU Usage. We will review the scripts and historical data captured.

CBusPASS – the Columbus, OH PASS Chapter – is meeting tomorrow, September 10th, at 6:30PM. Joe Webb will be giving his presentation Locking and Blocking Made Simple: A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Some of the 24 Hours of PASS Sessions are now online for viewing. Check them out and get your learn on!

Cheap Stuff

Remember how I posted about getting to PASS on the cheap? Or how about that interview I did with Thomas LaRock about getting to PASS on the cheap?

Well, thanks to some some great volunteers we now have a forum for the Summit! The point of the forum is to help you save money bu sharing a room with another attendee, a ride, or to coordinate social get togethers. We really want you to come to the PASS Summit and have fun. I really do. Really.

Getting to PASS on the Cheap

The PASS Summit is coming up in a few months and I bet you’re worried about attending. It costs money; I totally understand that. But there are a lot of ways to go for cheap.

  1. Be a speaker – oh, that deadline has come and gone
  2. Be a chapter leader – hrmm… not too many of those, let’s try another one
  3. SPONSORS! – You didn’t think you could get a sponsor for a conference?

Here’s what I mean by a sponsor: Ask your employer to sponsor your trip to the PASS Summit. They aren’t paying for it, they’re sponsoring you.

What You Do For Your Sponsor

You’re asking someone to spend what might initially appear to be a large chunk of money on you.

Wrong.

You’re asking your sponsor to make an investment in your career. But, in addition to this, you’re telling your sponsor that by sending you to the PASS Summit that you are going to be investing back in the company. By sending you to the PASS Summit, they are investing roughly $3,000 on training for you, give or take a few pennies. Sounds like a lot, right? Well, not really. Because, if you think about it, at the PASS Summit you are getting three days of training from the best and the brightest that the SQL Server community and Microsoft have to offer. Nowhere else are you going to have the chance to learn from so many great minds. This opportunity alone would normally cost you an ungodly sum of money. Now, ask yourself: How many people are on my team who could benefit from this knowledge? How many people are on other teams in my organization who could benefit from this knowledge? Let’s say there are 8, including you. What’s 8 x $3,000? $24,000. That’s a lot of money. There’s no way your company could possibly afford to send 8 people to the PASS Summit (bear with me, I’m going somewhere).

Act now and you can get $24,000 worth of training for only $3,000

Act now and you can get $24,000 worth of training for only $3,000

I said something about you investing back in the company, here’s where that comes into play. Take a look at the list of Program Sessions and Spotlight Sessions. There’s a lot in there to learn. More importantly, there’s a lot in there that could benefit your company and your co-workers. Here’s what you do: pick out a two sessions that you want to attend. Write down the title and a quick summary of the abstract but summarize the abstract in a way that shows the value it will add to your current role. Now pick four more sessions that could help your co-workers do their jobs better. Or, if you’re a consultant, you can also pick sessions that can help increase your bill rate (e.g. pick SSIS or BI or DBA sessions if you’re primarily a T-SQL developer). The key here is to show how these sessions are increasing your value to the organization as well as how you can act as a force multiplier for your organization. Remember those force multipliers in old school video games that quadrupled your damage? You want to be that. But helpful instead of destructive. When you show this list of sessions to your boss, be ready to pull out the Ron Popeil schtick.

That’s right, boss! For one easy payment of $3,000 you get $24,000 of value!

How can you possibly deliver this much value? Well, you take copious notes. Take notes in such detail that you could give the presentation. If you don’t think you can do that, talk to the presenter and get their slide deck. Most presenters are more than happy to give you a copy of their slides. Plus, I’m pretty sure they have to make the slides publicly available if they want to present at the PASS Summit. Why are you taking so many notes? Because you’re going to make presentations when you return from the PASS Summit! That’s right, you are going to bring the PASS Summit to your company. You’re going to go to the PASS Summit so you can come back to work and teach everything you learned to your co-workers. Remember how I mentioned that you were investing back in the company? This is how. You’re going to cram your brain with knowledge at the PASS Summit. You’re going to distill that knowledge for when you get back to the office. Then you’re going to deliver training that is specifically tailored to your organization.

What Your Sponsor Does For You

They write you a check. Seriously, though, this knowledge thing you’re doing isn’t free. Someone has to write a check. By the same token, if you’re sending yourself to the PASS Summit on your own nickel you’re going to attend sessions that you’re interested in. If someone else is sending you, the topic turns to “investment”.

Your sponsor makes an agreement with you: They will pay for airfare, hotel, and the Summit registration costs (hopefully all three, although registration is fine too). In exchange you do everything we talked about above. Their side of things is, frankly, pretty easy: find a couple of grand laying around that they can invest in your career. Money doesn’t grow on trees, but three grand is pretty easy to find.

Keep pushing, you'll get smarter

Keep pushing, you'll get smarter


Sample Letter

Need some ideas on how to put this letter together? I’ve done the basic homework on this one. This sample letter is, in fact, the letter that I’ve sent to my employer asking them to give me money in exchange for my smarts. It also includes the sessions that I want to attend as well as the sessions that I think might be of some use to my co-workers.

Why give away my secret sauce?

  1. It’s not secret
  2. I want you to go to the PASS Summit
  3. I really want you to go to the PASS Summit

Seriously, I want to see as many new faces at the PASS Summit as I can. I want to meet people and learn from them. I want to make new friends. And, frankly, I want you to have a chance to experience everything that the PASS Summit has to offer: sessions, networking, food, vendor swag, all of it. I put the letter together with the help of a few community people because we want to see you at the PASS Summit. The kicker: I don’t get a single cent if you got to the PASS Summit. I just want you to go and have as much fun as I had.

Here’s the Sample PASS Summit ROI document. This is very similar to the document that I sent to my employer.

What if my Sponsor Won’t Cover XYZ?

Let’s say that your sponsor will only cover the registration for the PASS Summit. What are you going to do? There are a lot of ways to get to the Summit for cheap. More importantly, there are a lot of ways that you can stay at the Summit for next to nothing. For the purpose of this example, I’m going to assume you’re arriving on Monday, November 2nd, and flying out on Friday, November 6th. It’s a bit hectic, I know, but it saves on the hotel.

Let’s take a look at flights, first.

Flying to Seattle

Point of Origin Cost
Columbus, OH $194
Chicago, IL (any airport) $309
New York, NY $258
Atlanta, GA $242
Milwaukee, WI $197
Los Angeles, CA $179
Denver, CO $159
Dallas, TX $257
Tampa, FL $238
Ljubljana, Slovenia $1936

I just looked these up on Expedia. So, it’s pretty easy to see that you could get to the PASS Summit for about 300 bucks, max via airplane. Less if you ride a horse. Or maybe more. I don’t know how much travel by horse costs. Point is, you can travel for pretty cheap.

NOM NOM NOM

What about food while you’re at the Summit? Well, I survived last year largely by eating the food provided by the catering folks and then buttering up vendors and getting invited to fancy dinners. It sounds gross, but it’s true: if you butter up vendors you can get invited to dinner. Even if you don’t butter up the vendors, you can still get invited to dinner. Even then, you can still eat for incredibly cheap in Seattle. There are a number of great local restaurants within an easy walk of the convention center. As long as you’re willing to eat breakfast and lunch at the convention center, you could probably get a way with spending no more than $15 a day on food. So that’s 4 days at $15 a day, roughly, which works out to $60.

$300 + $60 = $360, in case you’re keeping track at home.

But Where Will I Sleep?

Park bench? Well, unless you enjoy the homeless chic look of Derelicte and freezing to death on a bench, you probably want something better than a park bench. This is where cheap hotels and your network come into play.

Taking a quick look on expedia (search in Seattle and narrow down the search to “Downtown Seattle”), there are multiple hotels within walking distance of the convention center starting at $80 a night. If you split that with a friend, you’re down to $40 a night. That’s only $160 for all four days that we’re talking about for our hypothetical trip to the PASS Summit. Keep in mind when you’re reviewing your hotel choices that you’re going to be spending about 30 minutes standing up and awake in your room over the entire course of the Summit. The rest of the time you are probably going to be in a session or at some kind of event. The hotel doesn’t need 200 cable channels, a whirlpool, HBO, “magic fingers” or anything like that. Bed + walls = win.

So, now we’re looking at a total price of $300 + $60 + $160 = $520.

Here are some pricing comparisons if you don’t believe me (all prices exclude tax and whatever exorbitant “hotel fee” the city government has decided to levy on us):

Hotel Price per Night With Roommate
Sheraton (Conference hotel) $199 $99.50
The Roosevelt $116 $58
Red Lion Hotel $161 $80.50
Grand Hyatt Seattle $191.00 $95.50

SRSLY?!

That’s right, if you can get your company to foot the bill for the PASS Summit registration, the total cost for you could be as low as $520 if you’re careful about things. With 2 months left until the Summit, that’s a very small amount of money that you need to save between now and then. Don’t get coffee every day, stop renting movies, don’t get another tattoo, stop going out to lunch, do something. There are a lot of ways to save yourself $520 between now and september. Remember, you don’t have to pay for the hotel until you check out, but you do have to find the cash for your airfare.

Round Up

There you have it! If you work with your employer to bring value back from the PASS Summit it becomes a lot easier to justify your attendance. Becoming the trainer not only makes you more valuable through your ability to train your co-workers, but it also increases your ability to communicate clearly and fluently as well as think on your feet. If you think creatively, you can easily find ways to save money at the PASS Summit and make it possible to attend on the cheap. So, remember to ask your employer for money and offer to make a deal and work things out however you can. You never know, they just might give you a big pile of money.

Rate This!

There are a few people out there in the community who speak. You know who you are, I’ve been to your talks.

Sometimes, at a user group meeting there are forms to fill out where you circle a number and hand in the form and potentially win a prize like a license to Red Gate SQL Prompt or a copy of ReSharper. But what happens when people don’t fill them out. Or they come up with a particularly insightful comment after the fact like “ZOMG, your presentation totally saved my ass today! There was so much useful information in your presentation and I was able to use it and fix my production explosion!” Or, heaven forfend, the feedback forms are lost in someone’s car or they get recycled or whatever.

Enter speakerrate.com. I’ve known about speakerrate.com for a while now, but for some reason it’s always slipped my mind. At devLink I told Kevin Kline about it and he immediately added it to his presentation slides.

So, what’s the value? Well, it makes it a bit easier for people to rate at their convenience. Maybe I’m feeling rushed, maybe I’m in a bad mood, maybe I want to think about what the speaker said for a while before I leave a lasting mark on their speaking record. Maybe I want everyone to know that I got absolutely nothing out of this so called advanced presentation. You can do all of those things.

The point is that you’re contributing, for better or for worse, to the long term reputation of a speaker. Everyone can see what you have to say and everyone can see how the audiences respond to the speaker. All in all, everyone wins.

What does this mean for speakers?

Interestingly enough, it makes some aspects of speaking a lot easier. When you’re talking to a user group leader you can give them a link to your SpeakerRate.com page (mine is http://speakerrate.com/peschkaj). This makes it easy for user group leaders and speaker selection committees see what they’re in for. Likewise, it keeps your record public.

It’s even easier to get feedback. Rather than collecting the forms, waiting for someone to process the new email addresses and maybe go through the comments for their own purpose before typing them up and emailing them to you, you can simply put a link at the end of your presentation and ask the audience to visit the site and rate your talk. Sure, it takes a little bit more time but you can also always tell them the honest truth: your boss is going to shove you in a box and shake it up real good unless you have great ratings.

Most important to me is that it’s a constant stream of feedback on how I’m doing as a speaker. I learned that I took a lot of my knowledge for granted. Now I know what I need to do the next time I give this presentation and I’m going to make sure that I do a much better job. Why? Because one of the audience members said that they didn’t understand some concepts that I mentioned without an explanation. I can now tailor the presentation to include more background material or take out some advanced material. The point is that without the feedback, I wouldn’t have known about these comments and I might have continued to give this presentation with too little background information and too much advanced information.

Note I have not been paid for this, I just think it’s a cool idea

AppDev Virtual Chapter and CBusPASS Round Up

A special thanks to Grant Fritchey and Kevin Kline for their recent presentations.

Understanding Execution Plans

Grant Fritchey's Fists of Fury - putting execution plans in their place

Grant Fritchey's Fists of Fury - putting execution plans in their place

Grant Fritchey gave a phenomenal presentation covering more than just the plain basics about execution plans. Rather than focus on the wealth of potential operators that SQL Server can show in an execution plan, Grant focused on reading actual execution plans and showing the most common operations and what they mean. In addition to covering some ideal scenarios, Grant also discussed potential performance bottlenecks, how to investigate these potential bottlenecks, and what to do when they become an actual problem.

Unfortunately, due to technical mishaps (Grant and I both forgetting to start the presentation recording) there is no recording.

FEAR NOT! There will be a repeat of this presentation in October when Grant will be presenting virtually for the CBusPASS group.

End to End Performance Tuning

Kevin Kline happily donated his evening, skipped part of the DevLink keynote and drove me back to my hotel in order to present remotely for CBusPASS. Kevin outlined a performance tuning methodology that works universally across SQL Server 2005 and 2008. Kevin’s presentation, despite some technical hiccups, covered some great ground and reminded me that it’s alwasy best to start at the most basic level (error logs in both Windows and SQL Server) and move through the general layers of the OS, database, and then application while slowly narrowing down towards the specific problem and a working solution.

Bonus Fact: Kevin is red-green color blind.

Who Wants Free Learning?

I want free learning. Lots and lots of free learning. Why? Because nobody else is going to pay for it in these troubling economic times.

You might now be wondering “How can I get some free learning?” Well, I’ll tell you how: The Internets.

By using the internets you have access to a ton of free training. Crazy Helpful people just write up blog posts and give presentations via LiveMeeting out of nothing more than kindness so that you can get your learn on for free.

Understanding Execution Plans On Tuesday, August 11th at 1pm EST Grant Fritchey will be sharing some of his execution plan knowledge with everyone! This is a LiveMeeting and audio will be provided via the computer, not your telephone, so bring headphones to work if you want to listen in.

Quest Connect 2009 Brent has a great article up on his upcoming speaking engagement at Quest Connect, which will also feature Tim Ford and Tom LaRock. Brent was also kind enough to include links to multiple other sources of free training.

24 Hours of PASS Starting at midnight GMT on September 2nd, there will be 24 hours of PASS presentations available for the world to see. Check out the list of sessions and speakers. This is a great free event, don’t miss this opportunity to learn from some incredibly sharp people. Ready for the best part? The speakers will be available to take your questions while you watch the presentation. So go ahead and register. You can learn while you eat corn flakes.

It’s Always About You

I’m in the process of finishing up a presentation for the Central Ohio .NET Developers Group, and this got me to thinking about how I structure my presentations. Luckily, right around the time I was musing on this subject I ran across Jeff Atwood’s article Who Needs Talent When You Have Intensity? (which lead to Users shouldn’t think about YOU).

I’ve long held the opinion that a good presentation is one that is immediately useful in your day to day work. After reading Jeff’s post, and Kathy Sierra’s post that Jeff linked to, I’m revising my opinion.

A great presentation helps the audience do their job better.

Thinking back over the presentations that I’ve given in the past, the ones that I’ve felt were the most successful, and the ones where people have given me the best reviews, have been the ones where I’ve gotten out of the way and talked about how to do a better job rather than how I did my job well.

One thing that I have long held is that it’s okay to say “I don’t know” but only when you follow it with “talk to me afterward and we’ll figure out how.” Ultimately, when presenting, it’s the presenter’s job to help the audience learn the subject matter. If the presenter doesn’t know, that’s okay. But, it’s important to make sure that the audience is given an avenue to find the answer – either through an email follow up, a follow up later that day, or follow up by the next day of class.

My final thought is that Kathy Sierra hits it right on the head: “Too many learning experiences and books leave the learner feeling impressed as hell with the instructor/author, but… stupid.” The learning process is about the student, not about the teacher. When I think back to the past few presentations that I’ve attended, the presenters haven’t included themselves more than a few times. On the rare occasions when a presenter has said “I”, it has been in the context of “I made this mistake a lot until I got the hang of this. Here’s how you can avoid this and why”. When they include themselves, presenters aren’t talking about how great they are: they’re exposing when they made mistakes and how everyone else can learn without having to repeat that mistake.

In the end, the only thing that matters is that the audience is learning.

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 401 items have been purified.