We’re losing three good people as of the end of the year, but I thought now would be a good time to mention their names and add a comment or two from me:
I appreciate all that each of you did and the things you did for PASS. I know it was hard work and not everyone saw all that work, but you’ve moved things forward and I hope the rest of us can continue that work. Thanks!
Started the day at 6:30 at Top Pot with a meeting about SQLSaturday over coffee and it really ended up being a discussion about chapters as much as anything. Jack Corbett, Kendal Van Dyke, Rob Hatton, Pam Shaw, Patrick Leblanc, Tim Mitchell, Greg Larsen, and Stuart Ainsworth joined me. I love their passion for community! I see them as the next generation of leaders – get to know them!
8:40 am
Bill Graziano doing the keynote, started by thanking Greg Low and Pat Wright for their contributions to PASS for serving on the Board for the past two years. Then they did a great slide presentation with music showing pictures of Kevin Kline, then brought him up on stage to say thanks, brought Wayne Synder out to give him a thank you award. Very emotional Wayne starts talking about a picture of Kevin of sleeping – hard to describe, Wayne crying with emotion – kudos to Wayne for showing what he feels about how much Kevin has done over the years (Kevin served on the original board back in 1999 and continuously since then). Then reviewed existing board members and the new ones, then the new Executive Committee (Rushabh, Bill, Rick H).
European Conference April 21-23, 2020 in Neuss Germany, PASS Summit in Seattle next year, Nov 8-11, early bird rate is $995 through Dec 2009. Talked about the location of 2011 conference not set yet. Showed a picture of PASS HQ staff.
8:50 am
Patrick Ortiz from Dell. Rough start, presentation about SQL in the Enterprise, DR, etc. Honestly not very good so stopped taking notes. Sorry Dell.
9:18 am
David DeWitt, Technical Fellow, Data and Storage.32 years as Computer Sci professor, joined MS in March 2008, runs Jim Gray Systems Lab. Very engaging, joked about the server fans spinning up yesterday. Talking about growth/speed trends, seek times not getting much faster compared to other factors, need a lot more drives to keep CPU’s busy, SSD’s the big hope for changing that. This is really a presentation that’s worthy of a keynote – interesting, technical, no sales pitch, recognizes we get the base concepts already. Right now we try to avoid random IO, expensive. Memory is in Peoria, 200 cycles to access compared to 20 for L2 cache. Green stuff is bad (gotta be here, it’s the stall on the chart he is showing). Talking about column store vs row store, advantages to column store are only retrieving data needed to put into cache. Stopped writing to pay attention!
Missed a planned meeting due to bad scheduling, keynote went later than I thought it did. My fault, annoying!
Went back to the hotel to drop off my bag, back to the convention center for more networking, then off to a lunch meeting, then back for some more chat before a 2 pm meeting and another at 2:30, then spent some time wandering, looked in on Buck Woody’s session which seemed to go very well, then started working on preliminary dinner plans, meeting people at 6 pm and go from there. Finally headed back to the hotel, it’s funny that the conference just quietly ends, seems like there should be a closing ceremony!
So it’s dinner tonight, then a board meeting in the morning, one more meeting after that, then some time to relax before heading to the airport about 7p for a 10:30 flight that puts me back in Orlando at 9am Saturday – doesn’t seem like it should take long.
It’s been a good week, think I hit my goal of meeting 50 new people but it started to blur, definitely did better than in previous years. Looking forward to getting the event DVD’s so I can enjoy the technical side of the content back home. Things went very smoothly, PASS HQ did a great job this year!
Up at 5am today, worked for a while, then down to breakfast at 6am with Brent, Colin, Denny (and wife!), Tom, and Tim. Good conversation, good food, expensive breakfast (at the Sheraton). Then over to the convention center to see what was going on, had coffee with Kendal, Patrick Leblanc, Greg Larsen, and then up for an informal meeting with the sql bloggers we could gather, just trying to start a dialog about how we can communicate better with them. Very early on that, but interesting. Then wandering around the main room chatting with a few people, enjoying the time
Rushabh Mehta, VP of PASS, started off talking about finances. Financials are available on the site, login, go to governance page. Mentioned again that attendance this year was only down 9%, pretty good given the economy. Encouraged participation in PASS at chapters, volunteering, speaking. Talked about how many volunteers make PASS happen, had all the volunteers present stand – guessing it was 75-100 people.
Wayne Snyder, President. Started by saying the board serves the members. Recognized outstanding volunteers:
I love Wayne keynotes, Wayne does Wayne very well!
9:00 am
Back to Rushabh, 7th year we have the Women in Technology luncheon (how to get more women engaged in tech). MVP’s wrote SQL Server MVP Deep Dives, royalties to charity. Q&A today with the PASS Board today at 4:30 pm. Party tonight at Gameworks tonight, sponsored by Microsoft. Tom Casey will answer questions on Twitter, @ms_sql_server.
9:06 am
Tom Casey, GM, Business Intelligence. Comments on PASS; 2 dedicated BI tracks, 41 sessions on BI last year, 50 this year, 20% selected BI as focus last year, more than 30% this year. Long intro.
Talked about empowering users, the spread of info throughout the business. Powerpivot for Excel and Sharepoint (used to be Gemini) (2010).
Amir Netz – Demo of Powerpivot, 100 million rows in Excel on a laptop.Seems fast. Has Analysis Services running in process, compresses data. 20g of data, compressed to 133 mb. Underlying data in reports can be exposed as data feed, consumed by PPivot (not screen scrape). Has RelatedTable function to do lookup, returns table, SUMX aggregates table. Automatically finds some relationships. Showing new feature called Slicers in Excel, click fields and chart object shows up, but they seem to align and size well. Data can be uploaded to Sharepoint, live preview of Excel view of that data in Sharepoint. Now going to 2nd machine, Win7 touch screen. Accessed doc via Sharepoint, then running server side. Can use gestures to navigate (assuming you have the touch screen!). Harder to read demo, just a camera on it instead of direct from PC. Another demo, mildly confusing, reports in Sharepoint. Nice visual way to go back/scroll through report for various time periods (good demo there).
10:00 am
Back to some report demos. November CTP coming soon and Office 2010 beta as well. New resource center, www.microsoft.com/technet/bicenter. End of keynote.
From there I met Brent Ozar for coffee and a long chat, great fun, the first time we’ve had a chance to talk at length. Worth the time if you can corner him!
Had lunch in the main hall, wasn’t as much fun today with no birds of a feather, but did get a chance to get some feedback on business cards. In general people like the half size moo cards initially, but then worry that they’ll lose them. What can you do?!
I had another meeting scheduled for after lunch that was rescheduled, so went back to the hotel for a break and to work a little, back over to the convention center about 3 pm to network, then head to the Q&A session at 4 pm. It was the first time that I know of that the Board took open questions and I think it went well, Joe Webb moderating. Attendance lower than I hoped, but lots of good discussion. As you might imagine we were a little nervous going in – imagine an open forum where anything can be asked in any way and knowing that if you goof on the response, there’s the twitter sound bite of the day! In general you win at these type of forums by being direct, honest, thoughtful, and non-defensive. Can’t answer all the questions, or please everyone, but you can engage them to understand their concern. I thought the attendees treated us very fairly and tried just as hard to engage us. I’m really hoping this will become a yearly tradition.
After that, around 6:30, we left to get ready for the MS sponsored party at Gameworks. First class, tons of food, three hour pass to the games, free drinks too. Eventually we headed out for a sit down dinner and wound up at Changs, too tired to go further. So far not doing well on my quest for ‘Seattle’ food, but having fun anyway.
Called it a day about 10 pm as I write these closing notes, have a meeting early tomorrow!
Brent posted it first and I’m going to borrow his list to post here:
Best Business Intelligence Blog Post: Winner: Chris Webb for Implementing SSRS Drilldowns (Blog – RSS) Runner-Up: Michelle Ufford for Using Variables in SSIS (Blog – RSS – @SQLFool) Best New Blog: Winner (Tie): Aaron Alton for The Hobt (Blog – RSS – @AaronTheHobt) Michelle Ufford for SQLFool (Blog – RSS – @SQLFool) Runner-Up: Jorge Segarra for SQLChicken (Blog – RSS – @SQLChicken) Best Professional Development Blog Post: Winner: Kendal Van Dyke for Off-Hours Work Guide for Managers (Blog – RSS – @SQLDBA) Runner-Up: Sean McCown for Landing That Job (Blog – RSS – @MidnightDBA) Best T-SQL Blog Post: Winner: Aaron Bertrand for Stored Procedures Best Practices Checklist (Blog – RSS – @AaronBertrand) Runner-Up: Grant Fritchey for Unpacking the View (Blog – RSS – @GFritchey) Best Unusual Blog Post: Winner: Alex Kuznetsov for Reproducing Deadlocks with One Table (Blog – RSS) Runner-Up: John Magnabosco for Encrypting Large Values (Blog – RSS)
Best Business Intelligence Blog Post:
Best New Blog:
Best Professional Development Blog Post:
Best T-SQL Blog Post:
Best Unusual Blog Post:
See the full post from Brent at http://www.brentozar.com/archive/2009/11/pass-log-reader-award-winners/.
I have to say it was fun to have the contest, but grueling to grade. Very easy for them all to run together. We used a simple system where we each (me, Jeremiah, Brent) scored each entry, then we added those up and took the high scores in each category. The challenge was the scoring. Many were very good, so separating great from good is hard, and of course subjective. I think we learned some lessons and we’ll definitely do the contest again, but we definitely haven’t learned ALL the lessons yet either.
A few general comments from my own scoring run:
We’ll get more news about the contest for next year out by the end of the year after some time to reflect, but it’s a good guess that it will be similar, we may tweak the categories, and we’ll try to add a reader vote to it. In terms of strategy, that means:
I’d also say that it’s pretty incredible the information that gets shared in blogs, and it clearly has a positive impact on both the SQL community and on the writer. Thank you to all who entered for trying the content, and just for sharing as often as you do!
Up early again, started my day at the Convention Center for breakfast. Light breakfast, drinking water, never seem to drink enough during the day. Ran into old friend David Koth on the way, did a lot of hand shaking on the way through the seating area to finding a table. Interesting experience, I know a few people from my many times here, yet I still know so few. Then off to the keynote, talking with Brian Moran, Douglas, Kevin Kline on the way up, running into Chuck Heintzelman up front, then checking in at the blogger table (Steve Jones, Grant Fritchey, Tony Davis, Brent Ozar, more), wishing I was back there instead of sitting up front – blogger envy I guess!
About 8am
Wayne Snyder was first up at the keynote, and had a great slide showing the registration numbers, overall attendance down about 9% from last year (our highest year so far), really good given how some conferences have fared this year. He said that 43% of attendees are here for the first time (which interestingly matches the percentage of first time attendees at the networking seminar yesterday). 75 chapters in 2007, now at 200 chapters. Interesting map showing where attendees are from world wide, just guessing at the numbers I’d say 500 or or attendees from outside the US. Great explanation that virtual chapters are focused based instead of regular chapters which are location based. Notes on the 24 hours of PASS; 3500 attendees, 50,000 registrations. Announced the relaunch of the SQL Server Standard as online only, first issue now available, paying $500 per article. Open session with the Board of Directors on Wednesday from 4:30 to 6:15, come ask questions! Wayne also showed a liver Twitter feed showing #sqlpass, Steve Jones managed to get a tweet up mentioning that Wayne had mentioned SSC (I can just see everyone next year with a tweet ready to send if that comes up again!).
Next was Bob Muglia, President, Server and Tools Business at Microsoft. He was the program manager when MS announced the deal with Ashton Tate that launched SQL Server in 1988. Mentioned doing first demos for press showing SQL on OS2. MS was desktop focused at that point. Says that SQL Server can solve 99% of problems, but that there are some that SQL still doesn’t handle well (super huge db for example). Server rack on stage running IBM hardware, running 192 processors. Shows a workload on 64 processors, enabled 128 processors watch the CPU usage drop by about 50%, then they add more load back to 90%, changes to 192 processors, processor usage down to about 75%. Nice demo of the idea. Says adding a processor adds about 1.6 capacity. Talked about the growing capacity of machines, trend of virtualization, sees it growing in the database arena.
Demo: Edwin Yuen, Senior Product Manager, demonstrates live migration on HyperV on Win 2008 R2. Using Virtual Machine Manager shows machine running SQL, then starts a demo app that runs a workload. In VMM, right click, click on Migrate. It picks best available host. then moves the process while the workload was running – no change in the demo output, appears seamless and easy.
Note: photographer down front taking pictures, so if you seem one of me with my laptop on my lap, I’m writing this and not doing email!
Bob talked about cloud definition, and the idea that there are public and private clouds. Sees it as a natural progression for some things to move to the cloud (Azure is the MS public cloud). Becomes a decision about where best to host for a given problem. Challenge is to evolve our existing skill sets to solve problems using new options. Said thank you for the all the feedback they get about the product.
About 8:50 am
Introduced Ted Kummert. Talked about how exciting it was to speak at the PASS Summit each year, some of the things that were on the horizon last year, all due within 6-9 months. SQL 2008 R2 due in first half of 2010. Sees it as a significant release. MS rented out Gameworks on Wed night for conference attendees. Five years go they had platform vision; all tiers, all data, data lifecycle, progress made, time to involve – information instead of data, users more at the center of vision. Mentioned service pack uninstall supported, few vulnerabilities discovered within SQL. Announcing Fasttrack v2 with three new reference configurations. SQL will now scale to 256 logical processors on Win 2008 R2.
Priti Desai, VP of IT, First American Title. One of largest escrow/title in the US, 1200 offices. 10 terabytes data spanning 200 servers. 7000 concurrent users, 50k batches per second. Upgraded to SQL 2008, big features were partitioning and compression [fans spinning up on demo hardware – don’t know if that was in the plan!]. Had been using a third party backup, switching to use in the box backup. Results of upgrade; had one weekend to do upgrade, mentioned using SQLCAT as sounding board. [On Twitter everyone trying to guess how much heat the server is throwing off to spins the fans into turbo mode]
Priti Desai, VP of IT, First American Title. One of largest escrow/title in the US, 1200 offices. 10 terabytes data spanning 200 servers. 7000 concurrent users, 50k batches per second. Upgraded to SQL 2008, big features were partitioning and compression [fans spinning up on demo hardware – don’t know if that was in the plan!]. Had been using a third party backup, switching to use in the box backup. Results of upgrade; had one weekend to do upgrade, mentioned using SQLCAT as sounding board.
[On Twitter everyone trying to guess how much heat the server is throwing off to spins the fans into turbo mode]
Dan Jones, Principal Group Manager SQL Server Manageability. Demo hanging up on Step 1. Back on track! [Twitter abuzz with comments on the demo glitch!]Connecting to R2 instance, runs validation upfront, all green. Connected to control point, step 1 complete. Now to collect utilization data. Demo not exciting so far. Switched to one that has history accrued, nice dashboard – shows storage usage, under utilized instance, drills down, finds dbs not using much of spaced allocated (and could then reallocate). Can now generate a dacpac – unit of deployment from developer to DBA. System will generate alter scripts from package. Interesting, they did make it see easy compared to doing a compare and creating the scripts.
Back to Ted. Able to publish data feeds using reports as a source. More work on PHP and JDBC drivers.
Pablo Castro. Using Entity Framework with VS 2010, imported dacpac. Created a diagram (projection) of a couple key tables. Separating domain model from storage concerns is key point. [Down to 28 mins of power, wireless off now, trying to make it through – wish I was at the blogger table]. Definitely a dev person demo now, wondering how it plays to audience. Persistence Ignorance! Setting access to data in code with SetEntitySetAccessRule – that’s on top of SQL security I guess? Thinking DBA’s are looking for coffee right now. Shows URL access to data. Shift to Sharepoint 2010, every list exposed for data access via URL.
About 9:45
Stream Insight is for high volume event streams, will be in R2, integrated with VS. Master data services, scale out data warehousing in R2.
Amir Netz(sp?). Master data, shows data issues – wait, problem not there! Connecting to scale out data warehouse, 20 notes with 16 processors, 336 processors. Using Powershell to load data, 60 million rows, splits out work automatically, showing about 2.1 TB/hour speed. 60 billion rows in 10 tb warehouse. Change to Report Builder v3 connecting as SA..wow. Doing a group by against 60 bil rows, splits across all processors, to return 7 rows – very fast. Of course, that’s serious hardware behind it! Building a report using existing report as source. RB definitely nicer than earlier releases, supports maps in reports.
Talking about Azure briefly. [Watching camera guy wander around – we should have a camera on the camera guy, and really low on power. Hoping I don’t have to switch to pen and paper!]
About 10:06
Wait, one more demo, missed the name. Azure demo. Running a standard group by on Azure, works ok. Shows option to sync to Azure from SQL db. Create an agent, definitely looks like replication, handles merge conflicts. Not showing up on Azure. Web demo works based on data. Now trying to apply a dacpac to Azure. Changes connection string from earlier demo, seems to work.
New editions, Datacenter for up to 256 processors unlimited virtualization, and Parallel Data Warehouse. Expecting to continue deliver releases 24-36 months. Azure available as public CTP. Nothing on future releases yet. End of keynote.
I was headed for coffee when I ran into my friend Simon, so we had coffee (well, he had tea) and sat to chat for a while. Don Gabor came by and I introduced him, and just watched in a bit of awe as the master of small talk did his thing. Good way to start the day though.
From there I headed to the Birds of a Feather lunch, where about 50 MVP’s hosted talks over lunch about a variety of subjects. Mine was about how and why to participate in the SQL community and was thrilled to have 8 people join me (at a table that seats 10 mind you, we used one seat for bags) and had a really good discussion. Some points I'll share here:
Next was a 2 hour session at the PASS area answering questions. Only had a few, more it was people I knew stopping by, chatting about Twitter, bingo, SQLSaturday, the open discussion with the Board tomorrow, and more. I’ll probably do another shift there later in the week.
Out of order: heard a lot of great comments about the networking seminar today, glad it was well received, and seems to be actually working. Had someone come over to meet me as a result of that, and he admitted it was still hard, but he was moving out of his comfort zone. Cool! Another said it was the first year at PASS without someone from work attending, but felt it was the most fun – the combination of being solo plus the head start from the seminar had her meeting a lot people and having a lot of fun.
I had a meeting after that, then finally caught up with Steve Jones for coffee, catching up a little, and then back to the hotel for an hour to finish writing this and catch up on email, then going back out for dinner.
Its almost 9pm eastern now, and I haven’t had dinner yet. Easy to forget/downplay how the time zone change causes pain. I’m always glad I attended, but I wish for east coast once in a while!
Started the day with a long walk, then off to Top Pot doughnuts for coffee with Don Gabor, Jack Corbett, and Tim Mitchell. Greg Larsen stopped in for a while too. Fun to sit and talk with Don, he of course doesn’t know anything about our world, so it’s interesting to hear the questions as he tries to understand the someone complex world of technology, community, relationships that we live in, and to hear how that matches or not other groups he works with.
Then back to the hotel to check email and grab some stuff, then to the chapter leader meeting. Greg Low lead the meeting and it was nicely informal, just a circle of chairs with about 40 people present. Some good discussion, here are a few points:
From there I had a Board meeting, welcoming our two new members Brian and Jeremiah, and just reviewing our calendar for the week. Big things are the open board discussion with the attendees on Wed, and then a full board meeting on Fri to set assignments for the next year.
As soon as that was done I went to make sure Don Gabor was all set on the one hour session for volunteers. All was ready, so a 30 minute break to catch up on things. Had about 40 attend and it was fun, the way training should be. Don really engages people, has some nice tricks for doing it and some short but useful exercises around remembering names. Don just amazed me on names, he could name 80% of the 40 people in the room after just doing handshake introductions. I have a LOT of work to do, and it reminded me how valuable it can be to see someone show you what good really is. Everyone participated, no problems at all, good reviews at the end. I think most were very pleasantly surprised, not sure going in what to expect.
An hour break then before the 2 hour networking seminar. Bigger crowd, about 70 in the room, and of them half – yes, half – were first time PASS Summit attendees. Confirms for me that this is the right direction, if we can get first timers off to a strong start, they’ll come back! I did a short intro, and then again Don just took charge and immediately got everyone going, lots of participation. I had to leave early to prep for the reception and didn’t want to leave!
My part in the opening night reception was to announce the log reader winners (I’ll get you a link to that soon) and there was no prep time, my fault on that. Had a wireless mike which I’m used to, but had to deliver the message on stage – which is ok – but no experience with the stage lights blinding me, not used to being unable to see people. Muddled through, and made a note that I need to practice that before I do anything more complicated than read a list! Then we had the quiz bowl which went well, and then off to the SSC party. Saw a few more old friends, had planned to go to dinner afterward but just too tired, headed back to the hotel about 9:30 to call it a night.
Long day, but a good day, and thrilled that the seminars Don did went so well. Looking forward to tomorrow.
Flew out of Orlando direct to Seattle, leaving at 8:30 and arriving about 1130 am Seattle time. Nice flight, no problems! Waited at the airport for Mike Wells and Bonnie, fellow Florida user group leaders, and then took a limo in to the Sheraton. First time on the limo, found it costs the same as a town car - $45 per trip. Limo seats more, but still same size trunk, so space constrained – could probably put 4 in a limo vs 3 in a town car. Ran into a few PASS people along the way, including Andy Leonard and Karla from Pensacola.
Spent the next next couple hours working in my room, then headed over to the Convention Center to see what was going on. PASS HQ was in busy mode, getting the final stuff done for the 4 pm open of check-in and registration. We tend to take that for granted, but for them it’s a period of high stress, making sure all is ready so that everything goes smoothly. Happy crew though, stress and all!
Went up to check in, we’ve got a big monitor up with the #sqlpass Twitter feed. Probably fixed by now it was showing time since last post as something like “-42000 seconds”, mildly amusing! Got my bag and tshirt, ended up staying there for about an hour of networking as all the early arrivals came in. At 5:30 met up with some people for a networking dinner, walked down to the market and eventually to Pike Place Bar and Grill, decent food, and a long dinner. About 15 people total at the dinner, nice low key discussion, lots of fun.
Then it was back to the hotel for coffee and more discussion, more networking as there were a lot of attendees in the lounge. Finally called it a day about 10 pm. I’ll try to post more details the rest of the week, funny how it gets busy and the event hasn’t really started yet!
Posted yesterday at http://www.sqlpass.org/Community/PASSBlog/articleType/ArticleView/articleId/118.aspx, Rushabh Mehta is the incoming President, Bill Graziano is the VP Finance, and Rick Heiges is the VP of Marketing.
Congratulations to all!
If you’re going to spend 3-5 days in Seattle at the PASS Summit it’s worth sampling the local food rather than sticking with the ‘safe’ chain choices. I enjoy Diners, Drive-In’s, and Dives on the Food Network, so I grabbed the list of restaurants they had featured from Seattle. Haven’t tried any of them, but hoping to try at least one on my next trip. Been to one of these, or have another you think I should try? Post a comment!
Voula's Offshore Cafe 658 NE. Northlake Way Seattle, WA 98105 Tel: (206) 634-0183 Website: www.voulasoffshore.com
Mike's Chili Parlor 1447 N.W. Ballard Way Seattle, WA 98107 Tel: (206) 782-2808
Bizzarro Italian Cafe 1307 N 46th Street Seattle, WA 98103 Tel: (206) 632-7277 Website: www.bizzarroitaliancafe.com
Slim's Last Chance 5606 1st Avenue S Seattle, WA, 98108 (206) 762-7900 Website: www.slimslastchance.com
Georgia's Greek Restaurant & Deli 323 NW 85th Street Seattle, WA 98117 Tel: (206)783-1228 Website: www.georgiasgreekrestaurant.com
Pam's Kitchen 5000 University Way NE Seattle, WA 98105 (206) 696-7010 Website: www.pams-kitchen.com
Was browsing on a break and found this, http://www.seattle.com/dining/. Of them I’ve been to Palomino (good) and Ruths Chris (good), neither is cheap. Food for thought!
Ran across this, http://daypasswireless.com/, lets you rent an aircard plus service. Don’t know if it’s too late for those of you travelling to the PASS Summit, but an interesting idea. Rates are not bad.
I’ve been reading Aaron’s blog for a while, he’s prolific and consistently interesting – and definitely a technical focus. He’s been publishing a weekly “Connect Digest” of all the stuff going on at MS Connect (for bugs & suggestions) and lately he’s had a great run on bad habits to kick (SQL habits that is). The latter is absolutely worth reading and good to see someone thinking about what works and what doesn’t.
I know, I should have put more in the title. Crazy Egg is a web page traffic analysis tool that focuses on visualization. You sign up for an account (starting at $10/month), add a line of code to the page you want to monitor (or your master page), and then configure a page to watch. As it accrues data you can go into the dashboard and visualize the results as your actual page with the number of clicks/percentage overlaid. It’s a really easy way to understand what parts of the page are being clicked.
It reminds me, again, that it’s not enough to just capture data, you have to be able to report on it meaningfully. A great report just instantly explains the story the data is telling, “ok” reports answer the question but make you work a lot harder to understand the story. Sometimes it’s a line graph or a funnel, but sometimes you need something more specialized.
Technically this works and I like the visualization, but I’m not sure yet that I can derive the kind of value that it feels like it delivers. Not their fault, I’m the one who has to decide what behavior I like/don’t like and come up with a UI change to try to get to the goal. I think it might be pretty interesting for bloggers who want to do better but don’t want to really get immersed in traffic analysis.
Let me know if you try it, would be interested to hear if it helped.
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If you’re there about the same time and want to share a ride in, email me. I’m staying at the Sheraton only because that’s where the Board stays, otherwise I’ve always preferred a hotel a few blocks away, I like the 3-4 block to/from “work” every day to unwind. Maybe I’ll just walk around the block to accomplish the same!
Don Gabor is coming in Sunday afternoon and we’re planning to have dinner and chat, and if you’re in Seattle and want to join us, drop me an email. Not sure where dinner will be, but someplace between the Sheraton and the water front. In between I’ll check in with PASS HQ and see how things are going, and probably just see who I run into.
On Monday I’ll be in the volunteer session in the afternoon and then in Don’s networking seminar from 4:30-6:30. Then it’s off to the opening reception, and then the SSC party, where Steve makes me pay $30 to get in!
Tuesday, Wednesday, and Thursday I’ll be present for the keynote (rarely the best part of the day in my view), and I’m going to go to a few sessions, with a focus on seeing speakers that I have not seen before. I’m going to try to be there for lunch on Tues & Wed to network and facilitate networking. The food is ok, but usually I’m ready for a walk and something besides convention center food – we’ll see. Thursday having lunch with a friend. I’ve left evenings open so far, I’ll probably hit the expo Tuesday night, and other than that will see what else comes up.
Tuesday at lunch I'll be hosting one of the Birds of a Feather (BOF) sessions titled 'When and How to Participate in the SQL Server Community'. I hope you'll join me for lunch and discussion!
Friday I have a board meeting in the morning, and then fly out at a fairly horrible 10:30 pm on Delta to eventually make it back to Orlando at 9 am the next morning. Long flight, long week!
Want to talk blogs, SQL, woodworking, PASS, SQLSaturday, mentoring, careers, family, business? Or pretty much anything else other than politics? I won’t be too hard to find, very often it’ll be at the top of the escalator on the session floor or at the coffee shop on the third floor, or somewhere in between. Email me, or try me on Twitter @SQLAndy – though be warned I’m new to Twitter and could easily get it wrong. I’m going to set a goal of meeting 50 people that I don’t know. Is that a impossible, or too easy? Don’t know, but it’s a start.
Funny how tools can surprise you. I’ve had in mind to set up a sub-group and invite all the SQLSaturday #21 attendees, encourage post event networking. I’ve imported contacts before and it worked well, so went to do it today for a subgroup and as far as I can tell, you can’t. I wanted to both invite and pre-approve, that way they don’t queue waiting on me to get back to them. Couldn’t see a way to do it, ended up just inviting them to the oPASS list. Maybe not the worst idea anyway, but liked the idea of having a really targeted group.
Part of that is I had planned to do the same for the networking seminar at PASS, we may have to go with a separate group rather than a subgroup. Anyone have ideas?
