Twitter Analysis on PASS Summit 2013 – Part 1

Two of the most important times in the year as upcoming and existing SQL Server Community speakers are the submission day for PASS Summit and the Summit days (or shall we say “week”?).

I am one of community speakers – nervous, anxious and excited all at the same time about session abstracts and the opportunity to speak in front of other passionate SQL Server professionals. PASS Summit is more than just a conference for most of us – it’s a gathering for #SQLFamily; we share knowledge, we have fun and we bring back lots of good memories as well as new learning.

April 3, 2013 9 PM is the big deadline for Community speakers. Using Analytics for Twitter I was able to gather some information on how busy the community was today – discussing SQL PASS and PASS Summit itself. Without further ado, here are the charts.

Let me see!

Analysis based on today’s date up to 9:15 PM (April 3, 2013)


Analysis based on location the past week.


Tone analysis the past week

Note: The time play tone analysis has been replaced with Line Chart instead for easier viewing on the website.

If you are interested in tone / sentiment analysis on social network, below is a good session that cannot be missed at PASS BA Conference on April 10 – 12, 2013. Hope to see you there!

Social Text, Sentiment, and Tone Analysis by Ruben Pertusa Lopez  Paco Gonzalez


Wrap Up

Using Analytics For Twitter add-in, we can analyze the buzz around Community Speaker submission for PASS Summit 2013. The submission ended on April 3, 2013 at 9 PM (PST).

I am certain that the conversation about abstract submission will continue for at least another week. Topics discussed will include wishing good luck to other speakers, encouragement, selection announcement, the rules, the system (time out issues), deadline and many others.

I’ll post another article with some more Analytics for Twitter in about a week to follow this up.


Further Reading

Analytics For Twitter on Technet

Analytics For Twitter Download by Extended Results

Social Text, Sentiment, and Tone Analysis session at PASS BA Conference, 2013

Now What? by Colin Stasiuk


My 2012 US Tour with #SQLFamily

My Pacific North West US tour earlier this month officially concluded on 11 Nov 2012. I am very honoured and grateful that I met new friends, caught up with old friends and delivered 4 presentations too. The greatest thing about this trip is the community and networking, especially at SQL Saturday 172 in Portland, PASS Summit 2012 in Seattle, and SQL Saturday 166 in Olympia.  The sessions delivered in these two SQL Saturday events were superb and attendees were so eager in learning.

Last year, I was just a book-worm (or a session worm?) where I went to every single session slot, as I had two very specific aims; i.e. learning SSAS performance tuning and finding out more about SQL Server 2012. I achieved what I wanted and was really happy to find a gateway to learning. I met lots of new people during the sessions too.

This year, I decided to take a different approach. Throughout 2012, I have talked to people from other parts of the world via twitter, LinkedIn and emails. So, it was important during PASS Summit 2012 for me to meet them, and to thank them in person for sharing their thoughts and opinions. The result is, throughout my US trip, I met more people, from different parts of Australia, United States (outside of Seattle), United Kingdom, Germany, Portugal, Spain, Mexico, Denmark, Slovenia, Philippines, Netherland, Norway, Brazil, New Zealand, to name a few.

One thing that I realise is that we are a family, #SQLFamily; we are diverse in knowledge, expertise and other aspects of life, but we are one that we share passion in knowledge sharing and learning. So, I am proud to be part of #SQLFamily and that every time I am around my #SQLFamily, I feel home.

As an Alumni Mentor for the First Timers group at PASS Summit 2012, I sent a few tips. One of them was that everyone’s experience for PASS Summit would be unique. You are entitled to have different experience from your peers. The most important thing is that you are having a good time and learning. I had a blast! So, I’d like to thank the sponsors, organisers, volunteers, speakers and #SQLFamily in making PASS Summit 2012 happen.  The feedback that I have received from other speakers, my First Timers group and attendees have been nothing but positive. So, once again, many thanks.

How do you rate your PASS Summit 2012 experience? Share your thoughts here and let PASS know!

Last but not least, I would also like to extend my thank you to SQL Saturday 172 and SQL Saturday 166 organisers, sponsors, volunteers and attendees.


Highlights from PASS Summit 2012

WIT Luncheon – PASS Summit 2012 by Sarah Strate

PASS 2012 Day 1 – Interviews and Keynote

PASS 2012 Day 2 – Keynote and Session Recording (Query Tuning Mastery with Adam Machanic)

PASS 2012 Day 3 – Interviews and Session recording (Working with Claims and SQL Server BI Technologies with Adam Saxton) 

PASS Global Community Video

PASS 2012 Keynote and Mobile BI Announcement by Marco Russo

PASS 2012 Announcements by James Serra




PASS Summit 2012 Lightning Talk Session

Firstly, I’d like to thank everyone who voted for my “TRY CATCH in a Nutshell” Lightning Talk session for PASS Summit 2012. I am very honoured and thrilled to be selected.

I’d like to congratulate all the selected speakers and I’m very excited to meet you all at the Summit.

Lastly, I hope you’d be able to join SQL Family in PASS Summit this year. It’s not too late to register!


PASS Summit 2012 - Nov 6th - 9th 2012


24 Hours of PASS Summit 2012 Preview

How awesome is it to be able to watch 24 out of the 190+ upcoming PASS Summit 2012 sessions from your own home?

Very awesome! I’m excited about the 24 Hours of PASS Summit Preview.  It’s 24 consecutive hours of great sessions for SQL Server Professionals delivered by outstanding speakers in the SQL Community around the world, and best of all FREE!

I am also thrilled to be a moderator for Session 22, with Peter Myers on Big Data Analytics with PowerPivot and Power View.

The tracks in 24 Hours of PASS event include

This event starts on 20 September 2012 at 12:00 GMT. So, be sure you check the schedule in your time zone.

Below is a list that I’ve created for Australia Easterm Standard Time (AEST). Also see more info here:


** 20 Sep 2012 GMT **

Session 01 (BIA) – Starts at 12:00 GMT (Thu, 20 Sep 2012 at 22:00 AEST)
Choosing the Right Reporting Platform 
Presenter: Brian Knight, Devin Knight

Session 02 (DBA) – Starts at 13:00 GMT (Thu, 20 Sep 2012 at 23:00 AEST)
Best Practices for Upgrading to SQL Server 2012 
Presenter:Robert Davis

Session 03 (AppDev) – Starts at 14:00 GMT (Fri, 21 Sep 2012 at Midnight AEST)
Three Ways to Identify Slow Running Queries 
Presenter: Grant Fritchey

Session 04 (AppDev) – Starts at 15:00 GMT (Fri, 21 Sep 2012 at 01:00 AEST)
Fasten Your Seatbelt – Troubleshooting the Most Difficult SQL Server Problems 
Presenter: Klaus Aschenbrenner

Session 05 (CLD) – Starts at 16:00 GMT (Fri, 21 Sep 2012 at 02:00 AEST)
SQL Server Private Cloud != Azure 
Presenter: Allan Hirt, Ben DeBow

Session 06 (AppDev) – Starts at 17:00 GMT (Fri, 21 Sep 2012 at 03:00 AEST)
What are the Largest SQL Server Projects in the World? 
Presenter: Kevin Cox

Session 07 (AppDev) – Starts at 18:00 GMT (Fri, 21 Sep 2012 at 04:00 AEST)
Practical Demos of Text Mining and Data Mining using SQL Server 2012 
Presenter: Mark Tabladillo

Session 08 (DBA) – Starts at 19:00 GMT (Fri, 21 Sep 2012 at 05:00 AEST)
PowerShell 101 for the SQL Server DBA 
Presenter: Allen White

Session 09 (BID) – Starts at 20:00 GMT (Fri, 21 Sep 2012 at 06:00 AEST)
Mobile Business Intelligence 
Presenter: Jen Underwood

Session 10 (BID) – Starts at 21:00 GMT (Fri, 21 Sep 2012 at 07:00 AEST)
Slow MDX Queries: The Case of the Empty Tuples 
Presenter: Stacia Misner

Session 11 (DBA) – Starts at 22:00 GMT (Fri, 21 Sep 2012 at 08:00 AEST)
Using SQL Server 2012 Always On 
Presenter: Denny Cherry

Session 12 (PD) – Starts at 23:00 GMT (Fri, 21 Sep 2012 at 09:00 AEST)
Leadership – Winning Influence in IT Teams 
Presenter: Kevin Kline

** 21 Sep 2012 GMT **

Session 13 (BIA) – Starts at 00:00 GMT (Fri, 21 Sep 2012 at 10:00 AEST)
BI Architecture With SQL 2012 & SharePoint 2010 
Presenter: Rod Colledge

Session 14 (DBA) – Starts at 01:00 GMT (Fri, 21 Sep 2012 at 11:00 AEST)
DBCC, Statistics, and You 
Presenter: Erin Stellato

Session 15 (BIA) – Starts at 02:00 GMT (Fri, 21 Sep 2012 at Noon AEST)
SSIS Design Patterns for Fun and Profit 
Presenter: Jessica Moss, Michelle Ufford

Session 16 (AppDev) – Starts at 03:00 GMT (Fri, 21 Sep 2012 at 13:00 AEST)
Characteristics of a Great Relational Database 
Presenter: Louis Davidson

Session 17 (BIA) – Starts at 04:00 GMT (Fri, 21 Sep 2012 at 14:00 AEST)
What’s All the Buzz about Hadoop and Hive? 
Presenter: Cindy Gross

Session 18 (AppDev) – Starts at 05:00 GMT (Fri, 21 Sep 2012 at 15:00 AEST)
Taking SQL Server Into the Beyond Relational Realm 
Presenter: Michael Rys

Session 19 (BIA) – Starts at 06:00 GMT (Fri, 21 Sep 2012 at 16:00 AEST)
Agile Data Warehousing with SQL Server 2012 
Presenter: Davide Mauri

Session 20 (AppDev) – Starts at 07:00 GMT (Fri, 21 Sep 2012 at 17:00 AEST)
Digging Into the Plan Cache 
Presenter: Jason Strate

Session 21 (BIA) – Starts at 08:00 GMT (Fri, 21 Sep 2012 at 18:00 AEST)
Introduction to Microsoft’s Big Data Platform and Hadoop Primer 
Presenter: Denny Lee

Session 22 (BID) – Starts at 09:00 GMT (Fri, 21 Sep 2012 at 19:00 AEST)
Big Data Analytics with PowerPivot and Power View 
Presenter: Peter Myers

Session 23 (CLD) – Starts at 10:00 GMT (Fri, 21 Sep 2012 at 20:00 AEST)
Best Practices and Lessons Learned Using SSIS for Large Scale Azure Data Movement 
Presenter: Steven Howard

Session 24 (PD) – Starts at 11:00 GMT (Fri, 21 Sep 2012 at 21:00 AEST)
Mentoring for Professional Development 
Presenter: Andy Warren


Also, check out what the PASS Director, Rob Farley has to say about the upcoming 24 Hours of PASS 

See you there!


PASS Summit 2012 - Nov 6th - 9th 2012

First Timer Experience at PASS Summit 2011

PASS Summit 2011 is my first ever SQL Server oriented conference .  It provides me with wealth of knowledge about the areas that I am interested in. It also helps me to contribute back to the community as well as networking.


Arriving in Seattle for the very first time, I did not know what to expect.  Seattle residents are very friendly and the weather was much better than expected. The PASS Summit was superb and in general, I could not be more pleased.  While the experience and memory is still fresh in mind, I thought I should write down a few things for me to remember next year and share these with the other First Timers next year.


What to bring:

  1. At least a coat / jacket. Although the weather was quite kind in early October 2011, it could be quite chilly inside the rooms at the Washington Trade Centre.  If you do not wish to cart around your coat/jacket, there is usually a cloak room.
  2. Bring a pen. Most people have Laptop or tablet PC, which is easier to take notes. However there are times where you need to write something down quickly to give to people or if your Laptop / tablet PC is out of juice, you can still use the traditional pen and paper.
  3. Laptop / tablet PC. At the Washington Trade Centre where the PASS Summit 2011 was held, there was free Wi-Fi. So it’s always a good idea to bring  your own Laptop / tablet PC; especially to keep up to date with the PASS Summit events.  However, there were a few sets of laptops provided around the Trade Centre for your convenience; so hopefully they would do this again next year.
  4. Bring your ID. At the time of registration prior to Day 1 of the conference, you would need to present a photo ID (e.g. Passport), then they give out a bag pack containing schedules, PASS booklets, promoter booklets, a pen and a blank notebook. They also give out the name tag, which you will require at all times in the Summit.
  5. If you like your water, bring your own bottle. I find that after a while, it can be costly to buy a few bottles of water to last you the whole day. Luckily the Trade Centre provides plenty of drinking water fountain near the rest rooms so you can top up your own bottle.
  6. Pack your exercise outfit.  Just because you’re in a summit, it does not mean you can keep fit. Seattle is a lovely city and has a few parks. Going for a jog or just a long walk around the city in the morning would definitely keep your mind fresh for the whole day at the Summit. Plus there is a SQL Run group that you can join at the Summit.
  7. Bring business cards and carry them with you everywhere. As PASS Summit is a good opportunity to network, carrying your business cards everywhere with you is essential. Also, if you see my tip number 2 (Bring a pen), if you get given a business card, don’t forget to write a little something on their business card so it can remind you of who they are and what to follow up with them on. Trust me on this! After getting 20 business cards in a space of a day, you won’t remember everything!
  8. Think about what you would like to achieve at the Summit. This includes preparation before you arrive at the Summit.  There are 170+ sessions, so I would strongly recommend of going through the sessions at least a few weeks before so you know what’s on offer and so that you can prioritise which sessions you would like to attend.
  9. Use the Schedule Builder and add the session to your phone’s calendar. This makes it easier to find out what your planned next session is.  Some sessions may be cancelled, so always keep your schedule/calendar up to date in the morning.
  10. Write down all your technical questions. PASS Summit gives you a great opportunity to ask all technical questions and best practices either at the Expert Pods, SQL Server Clinic, Microsoft Product Pavilion or at the sessions.
  11. Enough cash / budget to buy the DVD (and the Pre-Con DVD if you are keen). The price for the DVD is generally significantly cheaper to buy before the end of the Summit than after.  Plus, if you are like me, I have so many sessions that I would like to attend but they run at the same time, so having access to DVD means that I can watch the missed sessions or have a refresher for those that I have attended.
  12. Friendliness and positivism. Trust me on this, you will enjoy the Summit a lot more if you bring these two factors.


Things to consider:

  1. If you bring someone with you who are not attending the PASS Summit, please think twice. The Summit is quite full on – breakfast to dinner events are available. If you are thinking of attending most of the events at the Summit, your companion may not have time to spend with you outside the Summit.
  2. If you are thinking of sight-seeing in Seattle, please plan a couple of days outside the Summit. Again, if you are thinking of attending most of the events at the Summit, you would hardly have a chance to explore Seattle. (I am guilty of this)
  3. Transportation to the accommodation – if you are from outside of Seattle and arriving at the airport, visit SoundTransit.Org for more information on catching the light rail to the city (Seattle Sheraton was the preferred accommodation provider and was beyond excellent in service!).  Alternatively you can pre-book your shuttle transport to the hotel, or just rock up at the shuttle depot in the airport.
  4. Always have extra room in your luggage for items that you will bring back from the summit.  You may even win big prizes to carry home with you!
  5. If you are first timers, join Big Brother / Sister group and make sure you pre-arrange meeting up time. I have joined up a group in which I unfortunately missed out on the meeting.
  6. If you are from overseas, data plan may be costly. For PASS Summit 2011, Sheraton provides free WiFi at the lobby.  There is also free WiFi at the conference in Washington State Centre.
  7. Complete evaluation form after the session. Your feedback is important.  Remember, PASS Summit is by the community and for the community.



By the way, I co-presented “Important Trace Flags that Every DBA should Know” with Victor Isakov at PASS. The presentation went really well.  Both Victor and I are really looking forward to receiving feedbacks and hopefully to return to PASS Summit next year.  So if you attended the session or have watched the session on the DVD (due to be out in mid November 2011), please feel free to leave a constructive feedback. I hope to present more regularly at PASS.


Hope to see you next year (November 6 – 9, 2012) in Seattle!