Tag passsummit

Submitting a Winning Abstract at PASS

For those who couldn’t make today’s presentation, or those who could but want to hear Tim Ford and Buck Woody trashing Wisconsin, I’m pleased to share with you both the slides and the recording of today’s presentation. Or rather, two recordings.

The Powerpoint

The Presentation

Submitting a session to the PASS Summit really isn’t terrifying. What’s terrifying is being accepted and being faced with the prospect of speaking… I kid, I kid. There’s nothing terrifying about it. You put together an abstract, revise it a few times, and then submit it. When you submit an abstract you’ll want to put together a list of objectives – problems that you’re going to solve for the attendees.

Well, that’s about all there is to that. If you have questions, post them in the comments. I can’t tell you what PASS is looking for because, well, I don’t know. It’s based on a number of different things and depends, in part, on your abstract itself. So, write some abstracts, give them a once over, and submit them to PASS.

Want some more ideas about writing abstracts? Look no further than Brent Ozar’s blog post How to Get Readers to Pay Attention.

Want to know more about public speaking? I would suggest Confessions of a Public Speaker.

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.

Why are you going to the PASS Summit?

Colin Stasiuk asked a great question: Why are you going to the PASS Summit? But, more importantly, Colin hits on the all important question: how do you decide which sessions to attend?

This is going to be my second PASS Summit, so I’m not an expert on picking sessions, but I have an idea based on what worked well last year. Last year, I had an exhaustive list of sessions picked out. Then, when I arrived at the Summit I marked them all on my program, which I promptly lost. Brent was kind enough to give me his program. I drew stick people on it. I also didn’t attend a lot of the sessions I was planning on attending.

  1. I grossly underestimated my own abilities and ended up leaving sessions because I thought I could gain a lot. Don’t underestimate yourself. Challenge yourself. Pick sessions that you think there’s no way you can understand them. I attended Jimmy May’s presentation on Disk Partition Alignment with Brent. I thought I would be completely lost. Then I realized that a lot of the low-level disk information bore at least a passing similarity to inode structures in the ext2/ext3 family of file systems on Linux systems. Once I translated that knowledge I was able to follow along, roughly, and be challenged in my thinking.
  2. A lot of very smart, really great people gave me suggestions on sessions to attend. The friends I made at PASS helped me find sessions that would better fit what I wanted to learn about. They were right.

What am I going to different this year to make sure that I get the most out of the Summit? How can you do the same?

  1. Ask someone who has the job you want. Say you’re a database developer and you want to be a database architect. Find one. Ask them which sessions you might benefit from. Better yet, ask them “I want your job. Which of these sessions will help me get there?”
  2. Pick something you don’t know anything about and attend it. If you want to learn about something, learn through a trial by fire. But, like I said earlier, don’t underestimate yourself. If you know even the slightest bit about SSRS, an introduction to Report Builder 2 is probably going to bore you. Take a gamble and go to an intermediate session.
  3. Make a back up list. Make a list of sessions that sound like they would be very valuable to advancing your career path interesting. Pick things that sound cool. Pick features you haven’t played with. Learn some Business Intelligence mojo.

Honestly, I’m going to do all three of these things. There’s a lot that I want to learn. I know people who are already there. I’m going to pick their brains for how to get there. Just remember that you’re going to the Summit not just to learn, but to interact with your peers. Make sure you socialize, too. I still think I learned more sitting on the floor talking to Brent Ozar, Donald Farmer, and a few other people than I would have if I had gone to whichever session I originally planned to attend.

PASS Summit 2008 Thursday and Friday Recap

Thursday

After the Thursday’s keynote, I spent some time talking with Brent and meeting various vendors and conference attendees. It’s been good to have a little bit of time to relax, I’ve found.

After lunch, I attended Paul Nielsen’s and Louis Davidson’s presentation on smart database design. If they present on this topic, I definitely suggest that you attend it. In addition to being a hilarious presentation given by two exceptionally smart men, I took a lot away from it. One of the biggest things is the universal answer to almost any question: ‘It depends.’ There isn’t a magic solution. Throughout the presentation, Louis and Paul provided a lot of tools and rationale to use to make the decisions when a hard and fast answer isn’t immediately available. This was the best luck I had with sessions all day.

In the afternoon, I attended a SQLCAT session on Large Scale Relational Data Warehouse Learnings. There was some great material presented. Unfortunately, the bulk of it went over my head and I left the session about halfway through it.

In the day’s final session, I attended a Session on Integrated Business Intelligence Solutions. I learned a bit about building cubes with BIDS, but for the most part this was an introduction to report builder. I left early and was greeted by a book from Louis Davidson. I went to the SQL Server Heroes Unite event, but I left early because, frankly, I was exhausted from all of the learning, networking, and socializing.

Friday

Friday morning’s keynote by David Dewitt was amazing. He clearly explained the technology behind Gemini will work on a more technical level. Normally this would be a difficult subject to comprehend, but David made great use of his slides to clearly explain the core concepts in a clear manner.

I, once again, missed the morning session while I spent time socializing and getting to know my friends.

When the conference started, I had originally planned to spend my time on the Application Development track. However, after the first day I realized that the most important thing that I would get out of the summit was to expand my knowledge and get out of my comfort area and learn more about different aspects of SQL Server. With this in mind, I attended Donald Farmer’s session on Integrating Predictive Analysis Throughout the Data Lifecycle. Brent Ozar did a great job of summarizing Donald’s presentation. One of the most interesting things that Donald showed was how to use an existing corpus of data to perform form validation based on trends in the existing data to determine if data is valid within statistical norms.

Later in the afternoon, while loitering around in the hallway with a few others, Donald Farmer came along and said hello to us. Within a few minutes we were interactively mining his sample data on Titanic survivors. This emphasizes how easy it is to use these new tools to mine and analyze the data on the fly to produce a better, or different, understanding of the body of data.

The final session of the data was Louis Davidson’s talk on Why Normalization Matters. Louis is just as engaging of a presenter on his own as he was with Paul Nielsen. While there was some review here, the important thing wasn’t the material in the presentation. The important thing was the understanding and the explanation that Louis brought to the material. Ultimately, the main point that Louis made was that if you think about table design carefully and intelligently, it’s very easy to design tables and the relationships between them. The main reason that many databases are not in third or fourth normal form isn’t that it’s difficult it’s that people try to take shortcuts designing or extending a database. Of course, the only way to do things right is to practice.

Everything else

The 2008 PASS Summit was my first conference and was a great experience for me. I got to meet a lot of great people, volunteer and provide help for an organization that I enjoy being a part of, and learn more than I ever thought I would learn in a week about parts of SQL Server that I never thought I would have a chance to look into.

Social networking made this all easier. By using twitter, I was able to keep in touch with all of my friends, get tips on sessions to attend, and coordinate attending sessions together. TJay Belt posted a great blog summarizing how we were able to use twitter during the conference to keep in touch, network, coordinate, help each other out, and socialize.

PASS was a great experience, it gave me an additional dimension to my understanding of my own skills and of SQL Server as an entire family of products and something more than just a relational database engine.

Live Blogging PASS Keynote (#sqlpass)

Liveblogging the PASS Summit 2008 final day keynote. Refresh this page for news. Or, better yet, visit Brent Ozar’s coverage for additional info.

10:04 Parallel optimization is hard. Very hard. There’s a lot going on when the data is distributed across multiple nodes. Gray Systems Lab is working with DATAllegro to solve these problems. There are a great number of challenges that are up ahead. Big things are coming (har har har).

10:02 Partition skew is a concern when fragments/nodes don’t end up containing the same number of rows. How does this get solved? You can use range partitioning or you can change the hash function you’re using to partition the table.

9:57 Table repartitioning makes it possible to shuffle rows around so that all of Bob’s order rows are on the same server as Bob’s customer data rows. Joins can happen locally once you do this, even though you have a giant lump of data spread across a huge number of nodes.

9:50 This is very interesting stuff and I would encourage anyone interested to get a hold of the video of the keynote. I’m trying to keep up with all of this and blogging is getting in the way. Blogging will resume when the subject changes.

9:35 He’s now explaining how this would all work in a real system, not just in theory. The magic is that the software makes this all transparent outside of the database. There are no indexes, sadly, but queries take less time because they are distributed. Brent Ozar has a good overview of what’s going on from an engine perspective. Check it out.

9:30 Hash partitioning explained now. This is great… he’s explaining how it works and what’s wrong with it.

9:23 Horizontal partitioning is up now. This is some really really cool stuff… Round Robin partitioning is up now, also very cool. The problem is that you can’t tell where a row lives.

He’s showing all of this with animated slides. There’s very little to try to comprehend – he’s just showing it.

9:20 There’s a picture of a cluster of VAX machines. Oh, VAX.

9:16 Shared Memory (everything is shared in one machine) doesn’t scale up very well, the hardware doesn’t scale up very well up at all.

Share Disk is where nodes of commodity hardware uses local storage. There’s still limited scaleability here, too.

Shared Nothing is where you have commodity hardware with dedicated disk and memory. Everything is connected via commodity hardware. This can scale as long as you have money to buy commodity hardware. This is how the big boys do it.

9:15 Apparently, eBay has two 2 petabyte systems and one 5 petabyte systems. That’s a lot of data! He’s describing how the basic forms of scaling work.

9:10 The reason we need to know about this is because this is the theory behind the new DATAllegro products that are coming out next year. The point of doing linear speed up and linear scale up is to add hardware resources incrementally (10% more data? 10% more resources)

9:06 David Dewitt, a technical fellow with Microsoft and Ph.D. holder, is coming on stage now for the last keynote. He gets Alice Cooper as welcome music. He’s going to be talking about parallel DBs for scaleability.

9:00 Patrick is continuing to show different hardware that could be used and why you’d want to use it to meet your needs. This is a review of a white paper that’s available through Dell. Basically, add more servers to the query layer to meet load and distribute the data from the processing layer. Once you get more load in the processing layer… add more servers.

8:55 The first speaker is Patrick Otriz – Solutions Architect with Dell. What Dell doesn’t do is application development – Patrick’s job is to drive consistency around what Dell does – meet Service Level Agreements and establish business continuity plans. He’s describing the full stack and the problems that people will be facing at the hardware level.

8:48 SQL Heroes Contest winners are going to be announced. This was to create a project on codeplex using SQL Server. There has been an effort to get community sample applications that run along side the Microsoft sample databases – the SQL Heroes Contest. 60% of the submissions were from outside of the United States. Didn’t have time to type all of them out before the list was off the screen, hopefully the list will be published somewhere. (thanks to Adam Machanic, they’re Extended Events Manager, SSISUnit, CDC Helper, and QPee tools by Jason Massie!)

8:44 Bill Graziano came out riding on a tricycle. Early bird discount is $995 if you register before December 31st, act now! The summit will be in Seattle, Nov 3-6 in 2009.

PASS is looking for content either through videocasts (PASSTips) showing off new features or through technical articles.

Three new board members have been elected:

  • Douglas McDowell
  • Lynda Rab
  • Andy Warren

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