Search results matching tags 'Education' and 'Conferences'

24 Hours of PASS - BA Style

RickHeiges — Tue, 29 Jan 2013 16:04:00 GMT

Tomorrow will mark another chapter in the 24 Hours of PASS series.I am involved once again - this time in a moderator role. The event begins at 8am ET for me. I will be introducing Alberto Ferrari who will be speaking on "Excel 2013 Power Pivot in Action" which is a great self-service BI story.

This 24hop event will be in a different format. 12 hours of Live webcasts followed by 12 hours of on-demand webcasts from the previous 12 hours. All sessions will be available for viewing on Feb 11, 2013. There is also a new hashtag to follow on twitter - #PASS24hop. And there is a new website as well... http://www.24hoursofpass.com/

I am excited about the event tomorrow and hope that you will join me to learn more about Business Analytics and ramp up for the PASS Business Analytic Conference being held in Chicago this April. Check out www.sqlpass.org for more information.

Rick Review: SQLTeach - SQL345 - 10-Mar-2010 - Kimberly Tripp

RickHeiges — Wed, 15 Feb 2012 05:17:00 GMT

SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years. I enjoyed the opportunity to speak at and attend SQLTeach at various times over the years. Since SQLTeach is part of DevTeach, the "feel" of the event is very different from PASS or SQLRally or even a SQL Saturday where SQL is the primary focus. It does however afford an opportunity for me to understand the challenges of those who need to work with SQL either in a direct or indirect manner. SQLTeach / DevTeach records sessions and post them on the web for anyone to consume (login required, but a login may be created for FREE). Here is where I found this video: http://www.devteach.com/DevTeachVideo.aspx?NoVideo=45

The session that I selected to review is by one of my favorite speakers, Kimberly Tripp. In this session, Kimberly once again simplifies a concept that is often treated as black magic. The session is entitled "Optimizing Procedural Code". This demo-heavy session covers many different options that are available to impact optimization. Do you know the various options to force out a cached plan? Is recompiling bad? What else can I control to help optimization?

Check this session out and consider attending the next SQLTeach/DevTeach (especially if you are already in Canada).

Enjoy!

Rick Review: Day 3 Keynote PASS Summit 2011 - Big Data-What's the Big Deal?

RickHeiges — Fri, 10 Feb 2012 13:40:00 GMT

I recently did a Rick Review of the Day 3 Keynote from the 2008 PASS Community Summit that featured Dr. DeWitt speaking on new technology that ended up in the Parallel Data Warehouse (PDW) edition of SQL Server 2008 R2. I decided to also listen again to the Day 3 Keynote from the 2001 PASS Community Summit. While I listened intently to the keynote on Day 3 of this past summit, something seemed to be somewhat familiar. Had I heard some of these concepts before? The keynotes from the most recent PASS Summit may be found here. The theme of PDW and Map/Reduce seem to be similar (at least at a high level) where data is split up into smaller chunks and selected sets of data are then combined to answer the query. Once again, Dr.DeWitt is entertaining as he simplifies a complex topic for the audience. Having access to this recording is great, but being there first hand was even better with a sense of respectful awe in the audience. It is no wonder that the Day 3 Keynote is a favorite of the PASS attendees. If you haven't had the chance yet, I invite you to view the recording and perhaps learn something new.

Rick Review: Day 3 Keynote of the 2008 PASS Community Summit

RickHeiges — Thu, 09 Feb 2012 19:04:00 GMT

Am I stuck in the past? Not really, but I like to blog about the recordings that I have recently watched. There are a lot of recordings out there on the PASS website and other places.

Recently I have had the good fortune of exploring some of the neat technology behind the Parallel Data Warehouse (PDW) in SQL Server 2008 R2. In order to get myself grounded in some of the basics around what PDW was all about, I decided to review the Dr. DeWitt keynote (Day 3) from the 2008 PASS Community Summit. The link to the WMV file is near the bottom of this page. As I watched the recording, I could recall the excitement of learning about this new technology. Whether you were fortunate enough to see this live or not, this recording demonstrates how a very smart person can explain such a new technology in a simple manner. I believe that once you watch this session, you'll want to watch the other keynotes by Dr. DeWitt as well.

Rick Review: SQLBits7: Consolidating Data Collection with SQLDIAG and SQLNexus

RickHeiges — Fri, 06 Jan 2012 02:54:00 GMT

I ran across this recording about 3 months ago. It is a recording that is open to everyone. It was recorded at SQLBits 7 with Christian Bolton as the speaker for a session entitled: "Consolidating data collection with SQLDIAG and analysing it all with SQLNexus". I found it very informative and hope that you will too.

SQLBits is a UK based conference that occurs twice a year and I can't wait to attend one personally from the stories that I have heard. They record the sessions and make each one available for FREE access - AMAZING! You can find this session at the following URL: http://sqlbits.com/Sessions/Event7/Consolidating_data_collection_with_SQLDIAG_and_analysing_it_all_with_SQLNexus. The imbedded video has both a video of the speaker speaking to the audience as well as a full screen capture of the presentation to make the replay even more vivid.

Christian walks through the basics of using SQLDIAG for Data Collection initially. He then turns his attention to SQLNEXUS as a tool to analyze the data collected in SQLDIAG. He goes through how to configure SQLDIAG to collect the necessary data (perfmon and SQLTrace data) with the SQLDIAG process in order to discover the items needed for further analysis. If you need to perform a relatively quick analysis of a server, check this video out to discover your "pain points" for a particualr server.

After viewing this webcast, I am positive that you will find that using SQLDIAG along with SQLNEXUS will make your job easier.

PASS Summit 2011 - What you can expect at the Conference - Summary

RickHeiges — Mon, 19 Sep 2011 13:30:00 GMT

As I finish up preparing for the Sep 20 (@1pm ET) webcast, I thought a final blog post may be appropriate in order to quickly reference many of the areas that I have touched upon. Naturally, much of this information is geared towards First Timers, but Alumni are welcome to join in the webcast as well and are encouraged to help spread even more tips/tricks around to all who attend.

PASS Summit 2011 - What you can expect at the Conference - Part 8

RickHeiges — Mon, 19 Sep 2011 11:30:00 GMT

In this post, Logistics centered around how to get to downtown from the airport (SEA - commonly referred to as SEA-TAC for Seattle - Tacoma).

As you would expect, the Seattle airport is almost always busy. Some airports have periods where almost no activitiy is going on. That is rare here. Signage is good throughout the airport on how to get to Baggage CLaim and Ground Transportation. If your flight comes into the "N" or "S" satellite terminals, you will need to take at least one train to the main terminal.

Denny Cherry has a recorded webcast that does a great job on going over all of the options on getting to downtown. You can find it here. He will go into more detail than I will about transit and after hours as well.

Rental Cars are available at SEA-TAC, but I believe that if you are truly coming for the summit that it will be a huge waste of money. One thing to note is that there are several rental car companies that require a shuttle to get to and makes it a little more difficult to return but are cheaper. If you do rent a car, you will need to park it somewhere. The convention center parking is convenient, but not cheap. Hotels also charge $20 - $30 per night. There are severall rental car locations downtown. If you truly need to rent a car to get somewhere for a day or perhaps to explore the scenery before/after the Summit, I'd recommend planning accordingly.

Taxi Cabs and Town Cars are also readily available. Fares (with a tip) will run about $45-$55. If you share a cab with two other people, the cost isn't that bad. The benefit of course is that you get taken directly to your hotel and do not need to wait until the shuttle is full before leaving.

Shuttle Express also offers a Shuttle service (which is sometimes a bus) to downtown hotels. Costs for using this service runs about $15 and you can also purchase a round trip ticket at a discount. I've used tis service on several occassions. On occassion, you may have to wait until a shuttle is full enough to go.

There is also a fairly new Light Rail service to downtown which costs about $3. There is a stop (Westlake) which is about 2 blocks from the Sheraton. This is Pine between 4th and 5th. Walk up Pine to 6th. Turn Right - Sheraton is one block ahead. The Light Rail service does NOT run 24 hours per day. This option may not be available depending upon you departure time. Denny does a great job discussing this in his webcast.

If you are planning to spend some additional time in Seattle before or after the confeence, check out the PASS Summit "Explore Seattle" webpage located here.

See you in Seattle!

PASS Summit 2011 - What you can expect at the Conference - Part 7

RickHeiges — Fri, 16 Sep 2011 16:30:00 GMT

I really don't think that you can get the full flavor of the Summit unless you delve into Social Networking. There are multiple vehicles for social networking. Twitter, Facebook, Foursquare, LinkedIn, and Yelp are all tools in the Social Networking Toolbox. At the Summit, the best one of these is Twitter. With twitter, yo can eavesdrop on conversations, get tips in real time, and find out where people are hanging out at.

Here is a YouTube video that is pretty good about Twitter. There are other ones out there as well.

I recommend that you use a twitter client like TweetDeck on your PC and also on your smart phone. The interface makes it easier to use than the plain vanilla web page. In your twitter client, you can create custom "feeds" to target a particular word or idea. You can have multiple comuns on your client with many of these "feeds" that you follow. These words that you target are often referred to as hashtags. Here are some common hashtags to follow:

#sqlpass
#sqlhelp
#firsttimers
#sqlkilt
#sqlkaraoke
#24hop
#sqlrally
#sqlsat

Once you start using twitter, you''ll understand more of what all this means. Brent Ozar has put together a great primer on twitter that may be found here. Closing thoughts on Twitter:

You don't have to create an account to get value out of it. You can just follow some of the hashtags listed above - especially #sqlpass
Get on twitter and try it out before you get to the summit
Follow #sqlhelp and learn a LOT about where you can find great resources for SQL Server.
make up your own hashtags like #JustSayin or #KilroyWashere or #whatever
When choosing a "handle", consider incorporating "SQL" as part of it. Members of the SQL Community are more apt to follow you and value your tweets if they know you are a SQL Server Professional.

Another application (targeted for mobile devices) that can be valuable is FourSquare. FourSquare also integrates with Twiiter and FaceBook. It works best with smart phones with GPS enabled. Essentially, you check-in to a location such as a restaurant , bar, Conference Center, etc. As part of the "check-in" process, you can add a "shout" to your check-in that may be tweeted and/or set to update your FaceBook status. This is optional, but it can help with networking. Check out FourSquare.

The third social networking property that holds value is LinkedIn. There are many discussion groups affiliated with PASS. It is a great way to connect with other SQL Professionals once you get home.

There is also a PASS YouTube Channel. Check out the videos from last year's summit! Of course, PASS is also on FaceBook. Another social networking tool that you may find useful is YELP. It is particualrly good at helping to find a good restaurant near by.

Flickr - Many folks who are shutterbugs or just want to share photos do so via Flickr and the #sqlpass or #PASS2011 hashtags. I look forward to seeing a lot of pictures from everyone this year.

Bottom Line: Get on Twitter Now! Follow #sqlpass and #sqlhelp. Get involved in the conversation.

PASS Summit 2011 - What you can expect at the Conference - Part 6

RickHeiges — Fri, 16 Sep 2011 13:30:00 GMT

Now that I have covered just about all of the "official" Summit activities, it is time for a blog post about "After Hours" activities.

There is a webpage that lists some of the activities that we are currently aware of. You can find that page here.

Monday Night Networking Dinner - Last year, Andy Warren and Steve Jones started a Netowrking Dinner (Food / Drink is your own responsibility). It will be Monday Evening at Lowell's. More information is available on the link provided above.Follow general #sqlpass on twitter to see what's going on.

Photo Walk - Pat Wright and Tim Ford started this tradition several years ago. Essentially, Pat / Tim coordinate a place / time to start on a tour of Seattle. Bring your camera andprepare to have a great time discovering Seattle.Follow #photowalk on twitter to obtain more information.

SQL Kilt Day - It will be Thursday this year. Several years ago, three SQL Community leaders decided to wear kilts one day. Many more joined in last year (even some vendors). I don't havve an exact count, but I suspect that thee were at least 50 people wearing kilts last year. I suspect that number will be over 100 this year. Wearing a kilt on #sqlkilt day will definitely bring you some attention. :-)

SQL Run - Running is a favorite fitness activity of quite a few members of the SQL Community. Would you like to run with some others who are attending the conference? Follow #SQLRun on twitter to find out when/where to meet up for a run.

SQL Karaoke - What happens when you mix an open mic, SQL Professionals, and some libation together? SQL Karaoke at a Dive Bar. See the Link above for more information on locatoin. This year it will be on Wednesday Evening and now enjoys a limited sponsorship by NEC and Genesis Hosting Solutions. Follow #SQLKaraoke for more information - especially on Wednesday.

SSC / Redgate Party - SQL Server Central and RedGate will be hosting another party right after the Welcome Reception on Tuesday night. More info may be found here.

Other Vendor Parties - Many other Vendors will also host parties or other get togethers. Be sure to visit all of the vendors in the Exhibit Hall. I encourage you to visit all of the vendors and perhaps score an invite to an "after hours" event.

There is more, but I don't know about it yet. Denny Cherry has put together a website that lists "after hours" events that he is aware of.

PASS Summit 2011 - What you can expect at the Conference - Part 5

RickHeiges — Fri, 16 Sep 2011 11:30:00 GMT

One of the most valuable parts of the entire Summit experience is the networking that goes on. In this post, I will go over some of the opportunities for you to network with others. Once again, this post will not focus on "after hours" activities which will come later.

Badge and Ribbons - Once you get to the Summit and pick up your materials, you will have a badge. The badge will have the following information on it:

Nick Name
Full Name
Company Name
Where you are from
Twitter Handle

You will also receive at least one ribbon (Alumni or First Timer). You may notice that some people have more than one ribbon. These ribbons identify how a person contributes to the SQL Community. Be curious. When you see a person with more than one ribbon, ask them about it. It is a great way to start a conversation. These people are very interested in meeting YOU.

Don Gabor - We have asked Don Gabor to once again run a 2 hour Networking Workshop on Tuesday. It is inexpensive ($70) and a great way to invest in yourself to make the most of the Summit. You can go online and modify your registration add this mini-pre-con or sign up onsite. Don will also be leading a special Speed Networking Session during the First Timer Orientation. I want to particularly encourage First Timers to take advantage of this session based on feedback from former First Timers.

Big Brothers / Big Sisters - There is also a Big Brothers / Big Sisters orientation program. It is not too late to sign-up. We match a willing and eager Alumni with a small grooup of First Timers via email. The Big Brother/Sister will then contact the First Timers prior to coming to the summit to answer any questions or to simply "break the ice" before actually getting to Seattle. If you are a First Timer, I encourage you to take advantage of this program. If you are an Alumni and would like to help out some First Timers, your help will be appreciated by the First Timers and the entire PASS organization. Visit here to sign-up.

Other places to Network at the Summit:

Welcome Reception (Tue Evening)
Expo Hall Reception (Wed Evening)
Attendee Party (Thu Evening)
Breakfasts
Lunches - especially Chapter, WIT and Birds of a Feather
Expert Pods
Before the Keynotes
At the PASS Booth
Anywhere!

Remember that only you can make the most of your Summit Experience. I have outlined a number of opportunities where you can network with others who are doing the same thing. Go Forth and Network!