Tag: SQL Saturday

  • Slides and Code for SQL Saturday Jacksonville – Architecting Zero Downtime Deployments

    The code from my talk today at SQL Saturday Jacksonville is available in GitHub in a repo: Zero Downtime

    There is a description in the readme, but you can open the DBClient folder and the VS solution for ZeroDowntime in there in VS 2019 and run it.

    The SQL Code is numbered in order in the SQL folder.

    If you have questions, please feel free to contact me or submit an issue on GitHub. Please feel free to use this presentation at your own employer or usergroup.

  • Traveling to SQL Saturday Jacksonville 2023

    I’m heading to SQL Saturday Jacksonville 2023 today, speaking tomorrow. After not making any of their events, I went in 2022 and am back for their 15th event this year. I’m excited to go, though this will be quick trip. Some personal commitments have me going this afternoon and coming back Monday. This was supposed to be a Thur-Tues vacation + work, but it isn’t. Sad smile

    I’m delivering a session on Zero Downtime Deployments, but there’s a bunch of great content scheduled. If you’re nearby, I urge you to register and attend.

  • 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.

  • Speaking at SQL Saturday LA

    SQL Saturday is coming back in-person to Los Angeles. I’ve been to this event a few times, and was sad when the pandemic pushed it virtual. However, 2022 is the year to restart.

    I’m speaking, and my flights are booked. If you will be in LA and want to come learn about data, databases, DevOps, and more at Loyola Marymount on Aug 13, register and come on down.

    There are still a few speaking slots, so if you want to present, submit here: https://sessionize.com/inperson-2022-data-sql-saturday-la/

    Register for SQL Saturday Los Angeles 2022 today.