Day Zero of PASS (Pre-conference seminar with Kim Tripp)

This week, I’m blogging and tweeting from the PASS Community Summit in Seattle, Washington. The week of the Summit is always a great, exciting, and busy time for me. I absolutely love the technical eduction and networking opportunities afforded to the attendees.

This year, I’ve decided to tweet regularly throughout the week in an effort to 1) share with those following the #sqlpass hash tag over Twitter and 2) preserve my notes for me to review later on. You can follow my tweets directly via Twitter.

Here’s a list of yesterday’s tweets. Most of the day was spent in Kimberly L Tripp’s pre-conference seminar on Indexing. Excellent information and presentation!

And last night, I served as one of six contestants in the Quiz Bowl. Grant Fritchey and I were a team. Kevin Kline and Brent Ozar were a team. And Kimberly Tripp and Paul Randal teamed up as well.  Guess who won.

Yesterday’s tweets:

  • @sqlagentman from my perspective it was a blast! Would do gladly do it again.about 10 hours ago from TweetDeck in reply to sqlagentman
  • @sqlandy is giving the PASS log reader awards at # sqlpass welcome reception.about 13 hours ago from TweetDeck
  • Is at the #sqlpass welcome reception.about 14 hours ago from Ping.fm
  • SQL server MVP Deep Dives book http://twitpic.com/o2tek at #sqlpass. Book sighing later this week.about 14 hours ago from TweetDeck
  • @buckwoody lol! Now I understand why he asked me.about 14 hours ago from TweetDeck in reply to buckwoody
  • Saw the printed copy of the Sql Server MVP Deep Dives book at the #sqlpass book store. Proceeds go to War Child charity. Buy one today.about 14 hours ago from TweetDeck
  • Heading to the #sqlpass quiz bowl, filling in for @buckwoody on the condition that none of my answers need be right.about 14 hours ago from TweetDeck
  • Amazed to see this at the #sqlpass lunch today. http://twitpic.com/o2qnmabout 15 hours ago from TweetDeck
  • @drsql was @sqlagentman kidding me? Said it was like “Let’s make a deal”? I’ve already changed into a costume for the #sqlpass quiz bowl :)about 15 hours ago from TweetDeck in reply to drsql
  • RT @SQLRockstar: @peschkaj there are snacks at the welcome reception #sqlpassabout 15 hours ago from TweetDeck
  • Heard that over 700 abstracts were received by #sqlpass for a limited number of sessions. Can’t believe I got selected for 2. Humbled!about 15 hours ago from TweetDeck
  • Speakers at #sqlpass are being recorded (audio & screen). Session recordings will be available for sell 125USD.about 15 hours ago from TweetDeck
  • RT @BrentO: #SQLPASS speakers need to check into room 605 (the ready room) one hour before each presentation.about 15 hours ago from TweetDeck
  • Douglas McDowell is doing a good job subbing for Linda Rab in the speaker orientation.about 15 hours ago from TweetDeck
  • Is sitting in the Speaker Orientation meeting at #sqlpass. I’m surrounded by the who’s who of the SQL world.about 15 hours ago from TweetDeck
  • If @brento gets any more stickers, he’ll need to buy a bigger laptop; do they make 27 inch macs?about 15 hours ago from TweetDeck
  • @t_burger I agree! Having @paulrandal monitoring email/tweets during @KimberlyLTripp’s session was a great value add! #ktprecon #sqlpassabout 16 hours ago from TweetDeck in reply to t_burger
  • Search for “Bart Duncan missing” to see his queries for missing indexes. #ktprecon #sqlpassabout 16 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass Craig Freedman’s blog on index_operational_stats http://bit.ly/BVcIVabout 16 hours ago from TweetDeck
  • @marcbeacom great to meet you earlier today! Hope we get a chance to catch up more.about 16 hours ago from TweetDeck in reply to marcbeacom
  • Note to self: any plan that includes do something and wait to see if anyone complains is probably not good. #sqlpass #ktpreconabout 16 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass Whitepaper comparing heaps and clustered indexes http://bit.ly/HPonNabout 16 hours ago from TweetDeck
  • OH “SQL Server will let you create as many useless indexes as you like” #ktprecon #sqlpassabout 16 hours ago from TweetDeck
  • @mrdenny I don’t see anyone in here with blue hair. Are you in the room?about 16 hours ago from TweetDeck in reply to mrdenny
  • OH “Check out SQLSkills site for White Papers on Indexed Views. They should be one of your top 3-4 favorite features.” #ktprecon # sqlpassabout 16 hours ago from TweetDeck
  • For inner joins there is no benefit to putting search criteria in the join/from clause, so keep it in where clause. #ktprecon #sqlpassabout 16 hours ago from TweetDeck
  • Got back to #ktprecon just in time to realize that I missed some great stuff. She talking join strategies now. #sqlpass.about 16 hours ago from TweetDeck
  • OH “set, set, squish is way better than set, set, squish, sort” ~ @kimberlyLTripp in #ktprecon at #sqlpass.about 16 hours ago from TweetDeck
  • RT @bradmcgehee: #SQLPASS Speakers: Don’t forget to attend speaker’s meeting at 5PM in room 606-607.about 16 hours ago from TweetDeck
  • Spent some time with Christoph & Jeremiah this afternoon. I love the sidebar conversations at #sqlpass. It’s all about people.about 16 hours ago from TweetDeck
  • @t_burger thanks Teresa! I can’t believe I missed the entire afternoon of @Kimberlyltripp’s session! Have to review @paulrandal’s tweets.about 16 hours ago from TweetDeck in reply to t_burger
  • Haven’t made it back to #ktprecon. Just had great conversation with @buckwoody. Now talking with another friend, Christoph. I love #sqlpassabout 18 hours ago from Ping.fm
  • @JohnZFields will let you know if I turn this into a blog post.about 20 hours ago from TweetDeck in reply to JohnZFields
  • @JohnZFields will also prevent covering nonclustered indexes forcing key lookups or table scans. #sqlpass #ktpreconabout 20 hours ago from TweetDeck in reply to JohnZFields
  • OH “if stats were perfectly accurate, they’d be as large as your data.” ~ @KimberlyLTripp in #sqlpass #ktpreconabout 20 hours ago from TweetDeck
  • @JohnZFields Bunch of reasons. More data returned than needed, esp in lots of joins. Can’t tune indexes #sqlpass #ktprecon. May blog moreabout 20 hours ago from TweetDeck in reply to JohnZFields
  • Isolate columns in your WHERE clause so that SQL server can seek rather than scan. I mention this too in my session. #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • Don’t use SELECT * in queries!!! #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • Got to watch out for DTA. It’ll tell you to create a bunch of new indexes rather than adjusting the current ones. #ktprecon #sqlpassabout 21 hours ago from TweetDeck
  • Index intersection will be discussed this afternoon in #ktprecon at #sqlpass. SQL server using > 1 index to cover a query.about 21 hours ago from TweetDeck
  • OH “clustered index scans are full table scans” ~ @kimberlyltripp #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • You really need to know where your IOs are coming from – leaf or root node – makes a big diiference. #ktprecon #sqlpassabout 21 hours ago from TweetDeck
  • @bradmcgehee it was a tough call for me this morning choosing between Insiders session and #ktprecon. Happy to be here. #sqlpassabout 21 hours ago from TweetDeck in reply to bradmcgehee
  • @kimberlyltripp makes SQL server internals understandable. Mark of someone who knows her stuff. #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass Demo scripts (and companion content for the internals book chapter) are at http://bit.ly/42zJ4cabout 21 hours ago from TweetDeck
  • @mdefehr by the end of #sqlpass, you’ll wish there were about 16 of you so you could see it all, plus get a little sleep at some point.about 21 hours ago from TweetDeck in reply to mdefehr
  • @mike_walsh I know the feeling. Been self employed for 15 yrs and try very hard to keep it local or rdp to clients. Some travel required thoabout 21 hours ago from TweetDeck in reply to mike_walsh
  • RT @PaulRandal: #ktprecon #sqlpass Do page splits ever roll back? No: script to prove it: http://bit.ly/2IgMM3about 21 hours ago from TweetDeck
  • Live from #ktprecon at #sqlpass. http://twitpic.com/o13umabout 21 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass How expensive are page splits in terms of transaction log? http://bit.ly/MqUgUabout 21 hours ago from TweetDeck
  • @paulrandal has a blog post on just how expensive page splits are search the SQLSkills site for it. #sqlpassabout 21 hours ago from TweetDeck
  • Loves that the #sqlpass booth has a running Twitter search on #sqlpass hash tag.about 21 hours ago from TweetDeck
  • @paulrandal I think it’s a city ordinance in Seattle that coffee decanters should never be empty for more than 5 minutes. #sqlpassabout 22 hours ago from TweetDeck in reply to PaulRandal
  • @kimberlyltripp is explaining b-tree structures and indexes at #sqlpass #ktpreconabout 22 hours ago from TweetDeck
  • RT @DamonRipper: Just got to meet and chat with@joewebb during break time #sqlpass. <– pleasure was all mine.about 22 hours ago from TweetDeck
  • RT @ManningBooks: Are you at #SQLPASS? Pick up a copy of SQL Server MVP Deep Dives and get it signed at the launch http://bit.ly/30QWor #sqlabout 22 hours ago from TweetDeck
  • Stomach is growling. Looking at the guy beside me and shaking my head; hopefully he’ll think it’s his stomach. Learned that from Bro Jon.about 22 hours ago from TweetDeck
  • Note to self: be early to breakfast & snacks; they go fast at #sqlpass.about 22 hours ago from TweetDeck
  • OH “the more narrow your queries are, the more you can tune them and the better they are.” ~ @kimberlyltripp at #sqlpass #ktpreconabout 22 hours ago from TweetDeck
  • Want to follow what’s going on at #sqlpass? Do a search and follow the #sqlpass hash tag. Lots of good info there.about 22 hours ago from TweetDeck
  • @buckwoody is back in #ktprecon at #sqlpassabout 22 hours ago from TweetDeck in reply to buckwoody
  • RT @PaulRandal: #ktprecon #sqlpass Ola Hallengren’s *wonderful* db maintenance script: http://bit.ly/3R5OUvabout 23 hours ago from TweetDeck
  • Go to @paulrandal’s blog, go to example scripts, and follow the link to Ola’s maintenance scripts. #sqlpass #ktprecon <- excellent stuff!about 23 hours ago from TweetDeck
  • @kimberlyltripp just answered a question with “it depends” hahahahaha! #sqlpass #ktpreconabout 23 hours ago from TweetDeck
  • @SQLChicken @paulrandal is monitoring the #sqlpass and #ktprecon hash tags.about 23 hours ago from TweetDeck in reply to SQLChicken
  • @SQLChicken here’s a link thatat help http://bit.ly/2CkTY7about 23 hours ago from TweetDeck in reply to SQLChicken
  • Wonder where the in-room coffee is in the precons?!? I need some but don’t want to leave to find it. Definition of quandry. #sqlpassabout 23 hours ago from TweetDeck
  • Wonder where the in-room coffee is in the precons?!? I need some but don’t want to leave to find it. Definition of quandry.about 23 hours ago from TweetDeck
  • Thinks Kimberly Tripp’s indexing session is should be “required reading” for DBAs. #sqlpass #ktpreconabout 23 hours ago from TweetDeck
  • @paulrandal is there a hash tag for this session? #sqlpassabout 23 hours ago from TweetDeck
  • @buckwoody just walked into Kim Tripp’s session grinning. Wonder what he’s up to. #sqlpassabout 23 hours ago from TweetDeck
  • OH You can all name your monsters ~ Kimberly Tripp #sqlpass.about 24 hours ago from TweetDeck
  • Wishes that every table in the room had a power strip. #sqlpass.about 24 hours ago from TweetDeck
  • @PaulRandal is tweeting while Kimberly is speaking. Cool.about 24 hours ago from TweetDeck in reply to PaulRandal
  • Is sitting in Kimberly Tripp & Paul Randal’s session on indexing. #sqlpass. Preparing my brain to drink from a firehose.about 24 hours ago from TweetDeck

Advertisements

2 Responses to Day Zero of PASS (Pre-conference seminar with Kim Tripp)

  1. Pingback: uberVU - social comments

  2. Pingback: Dew Drop – November 4, 2009 | Alvin Ashcraft's Morning Dew

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s