Tag: travel

  • Notes on SQL Saturday New Jersey 2022

    I was honored to attend the first SQL Saturday in New Jersey last weekend. I consulted with and helped the organizers get the event going and executed. I made a few notes and got some pictures, some of which I’ve added to the SQL Saturday Instagram account.

    I’ve broken this down into a few areas, no particular order, but those things that occurred to me.

    Travel

    Lots of travel concerns and questions in July 2022. A fellow speaker had a flight delayed hours and arrived late at night a couple days before the event. Another had planned to leave late Sat and had two flights cancelled that night and one the next morning. Hopefully they made it the next day.

    I fly United, and both Denver and Newark are hubs. My flight left on time and arrived early on Friday. Everything was smooth. The return was similar, slightly late leaving, but made it back on time.

    Getting around the Newark area, in Iselin and other towns was mostly with rides for me. I got a taxi in from the airport, which was slightly pricey. A fuel surcharge added. I used Uber to get from my hotel to the event, and then a speaker gave me a ride to the airport Sat night. All in all, this was a smooth trip for me.

    No upgrades, but hub->hub flights usually have lots of people with more status than me. I did grab a shot as we got to NJ, with NYC in the distant background. I love flying into some cities, and the NJ/NY area is one.

    20220722_112040

    Note: I didn’t check a bag, and recommend you avoid that if you can for the current times.

    Speaker Dinner

    Many events do a speaker event the night before. It’s not required, and I don’t think any events should feel they need to pay for dinner. That being said, it’s nice, and we all met at the Kona Grill, which was a nice mix of a variety of foods, including sushi.

    We had a great dinner and good conversation on all sorts of topics. Afterwards, a few of us went to get ice cream.

    20220722_212704

    The group shot:

    sqlsatnj_icecream_a

    Event Setup

    This SQL Saturday was hosted by Microsoft at their Iselin office. As expected, at 7am on a Saturday, the parking lot was deserted. The organizers were there setting up. One thing every event usually needs is coolers and drinks.

    20220723_071156

    We started coffee brewing, but it was slow. Eventually we determined that the circuit on the table above couldn’t support the load of multiple pots. Fortunately, we moved a few to other spots.

    Signs matter, so I took the job of setting up signs around the parking lots of direct people to the office. This is a large, 10 story building, and MS only has part of one floor.

    20220723_073512

    I set up signs into the lots and then one in front of the building. I also taped a few on doors and walls.

    20220723_073043

    I took a few pictures so I’d remember where the 7 or 8 signs were. These were generic SQL Saturday signs, from previous events. Always good to not put a year or location on these and save them. I remembered this job because even at 730a is was getting hot. When I took them down at 3pm, it was really hot. Probably 95F/35C.

    The rooms were mostly set up as these are conference rooms that MS uses and there were projectors, seats, and plugs.

    The speaker room had a few nice gifts for speakers. Not necessary, but appreciated. We each got a shirt of dry fit material

    20220723_071343

    Also a soft cooler we can use in the hot summer

    20220723_071347

    Sessions and Attendance

    There were 4 rooms and a variety of different sessions. This is a smaller office, and attendance was limited to around 120. It seemed we had just over 100 people from the check-ins and there was no shortage of people walking around.

    The were 4 or 5 vendors set up along the main hallway and plenty of engagement from attendees. It’s always good to see people interacting as vendors pay for a lot of the events and they usually have good solutions.

    20220723_081912

    Lunch was sandwiches and sweet treats. Most of the food was eaten, except the sweets. There were a lot of them and I saw a few people take them away. There were three vendor sessions: Microsoft, Solarwinds, and AWS. All were well attended.

    20220723_124850

    In the morning, I was preparing and talking with a few people. My session was before lunch, and it was well attended. About 40 people talking DevOps with me and we had some good discussions and questions.

    After lunch I had a math class. Risk models in nuclear power and finance. The slide brought me back to University. This was presented by Dr. Yajuan Li, local professor, and while the nuclear power drew me in (I worked at a plant), but this was mostly about taking some models and applying them to determining which approach one would take towards a problem.

    20220723_133856

    I’m not sure I completely get the approach, but I get the idea. This uses the Monte Carlo simulations to help a business decide what risk level they have based on their approach.

    The last session for me was about finding a new job. Ray Kim (a friend), presented this one, and it’s a good one. I think a good portion of why people come to SQL Saturday is to grow their career. Often by learning new technical skills (or getting inspired to learn). However, the soft skills, the resumes, the interviews, networking, etc. are important.

    20220723_150201

    Ray has taken his recent experiences in finding a job and produced a nice presentation to help you. He’s done this a few times and is presenting in Seattle in November. Worth an hour of your time to watch this one.

    Keynotes

    After a brief opening from Jean Joseph, and a couple minutes of my promoting SQL Saturday, Linda Zhang of Microsoft had the opening keynote.

    20220723_090611

    She took a neat approach of talking about the history of SQL Server. She asked if people remember new features from old versions of SQL Server (2000, 2005, 2008, etc.) with a slide listing a few recent additions.

    20220723_091136

    She gave out prizes to people who answered, and it was a fun engaging way to open the day.

    The end of the day had Jamie Fox of Microsoft and Ed Pollack thanking people and drawing names from tickets for prizes. This was a lot of fun, as it always is with people winning a variety of things from the sponsors. One the parts of SQL Saturday that makes me smile a lot.

    20220723_161618

    I sat and watched with Jean. We enjoyed the day, and I was very happy to be able to hang out with him. He’s quite the community person, having run two events this year. A virtual SQL Saturday in French for Haiti and now New Jersey. He also runs Future Data Driven, coming in September.

    A little photobomb from his son on the right.

    20220723_161822

    I miss these events, and I’m looking forward to a few more this year. Hopefully we’ll see SQL Saturday continue to grow in 2023 as well and come back to more cities and get data professionals together to grow our careers and skills.

  • A Big Year on the Road

    Someone asked me recently about my travels this year, and I listed out the trips I’ve taken. So far, I’ve been to these airports on trips away from home:

    • LHR
    • SYR
    • LAS
    • ORD
    • RNO
    • LAX
    • JAX
    • LHR
    • BRU
    • AMS
    • AUS
    • AUS (2nd trip)

    Today I’m in Austin for for the second week in a row, this time visiting the Redgate office space.

    Still to come this year, that I know of, are these:

    • EWR
    • SEA
    • LAX
    • HNL
    • LHR
    • SYR
    • YYC
    • MCO
    • MCI
    • SEA

    There are a couple other possibilities,. including 1 or 2 more LHR trips. I’ll also likely get another LAX and AUS trip in somewhere to visit Redgate offices.

    I don’t know if this will be the biggest year of travel for me. In 2019, I flew 144k miles in the air. My current total from this query of data I keep:

    SELECT top 10
      YEAR(u.Transaction_Date) AS FlightYear
      , SUM(u.PQM)
      , SUM(u.miles)
      FROM dbo.United AS u
      WHERE u.Activity_Type = 'Airline'
      GROUP BY YEAR (u.Transaction_Date)

    is 118k, but this is with a lot of bonus miles. I’ll need to parse out some of the bonus stuff to figure out how much I fly, but I wouldn’t be surprised if I end up with around 100k miles this year.

    Unfortunately, the downloads from the airlines don’t separate out bonus miles, so I think I need a little data modeling adjustment to figure out my trips.

    With things reopening, this feels like a big year, and I am looking forward to all of these trips.

  • Halfway through the craziness

    Awhile back I wrote about my crazy schedule. I’m about halfway through. The last couple months have been:

    • London (SQL Bits)
    • Syracuse (daughter visit)
    • Las Vegas (volleyball)
    • Chicago (volleyball)
    • Los Angeles (work)
    • Reno (volleyball)
    • Cambridge/Brussels (work/Techorama)
    • ankle surgery
    • Amsterdam/Lingen (Datagrillen)

    I’m on that last trip now, with the speaker dinner tonight for DataGrillen. From here I have:

    • Fort Robinson, NE ( camping vacation)
    • Austin (VS Live)
    • Austin (work, separate trip)
    • Indian Creek (camping vacation)

    All in June. Then a break before:

    • New Jersey (SQL Saturday)
    • Baton Rouge (SQL Saturday)
    • Redmond (VS Live)
    • Los Angeles (tentative)
    • Hawaii (vacation)

    That gets me through the summer. September will have some travel back to the UK and perhaps elsewhere, but Sept and Oct are fuzzy.

    It’s a crazy life at times, but at the same time, it’s an amazing one. I’m having fun, I love getting to experience new place and culture with my wife, see friend and meet new people at events, and keep busy.

    Tough at times, but overall, it’s my choice and I am managing my career with my boss. I’m also enjoying 2022.

  • Gone Again

    I’m off again. By the time this publishes, I should be in Amsterdam (hopefully). I’m traveling to DataGrillen, but because I had surgery and in a boot, I’m moving slowly.

    This week is traveling to DataGrillen and back, hopefully without any issues.

    Back to normal blogging next week.