Daily Coping 28 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

Today’s tip is to if you can’t change it, change the way you think about it.

I’ve been working on growing SQL Saturday back to a series of events that make the world better for data professionals. My business partners and I started this idea, grew it, and gave it to the PASS organization. When they failed, I got the new owners to donate it back to the community and it runs as a 501.c.3 US chartable foundation.

At the beginning of 2022, I was hoping for 10 events. Early in the year, I wasn’t confident about this. As of a couple months ago, I was confident in 10 and possibly more. Now, we’ve got 8 on the schedule and 4 completed. A couple more might come about.

There are two things happening now that I can’t change. One is that a few people are upset about SQL Saturday, mostly because of the mismanagement by the PASS organization. I’m working to change minds, but I also know I can’t get upset by their emotions and feelings. All I can do is show that I run the franchise differently and hopefully get them to realize that.

The second thing is that a few people are still nervous about events. That is understandable, and I have worked to remember that my view of the world isn’t more or less valid than theirs, and I need to work with them. I have learned to accept their decision not to run events if they are concerned.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 28 Jul 2022

The Azure Carrot

Microsoft wants more people to move their database workloads to Azure. They are constantly adding new features, capabilities, even tools to help people move databases to some part of Azure. It’s working well, as the latest quarterly report shows tremendous growth in Azure revenue. We don’t know precisely how SQL Server or Azure SQL databases impact this, but I certainly see more and more customers moving relational workloads to the cloud. Some to Azure, some to other providers.

In an effort to entice people, Microsoft has a promotion that they were running in March, which was asking SQL Server 2012 customers to move to Azure and save with free extended security updates. They reiterated the promotion on July 12, when SQL Server 2012 went out of support. They calculate savings and promote benefits, which might be tangible and desirable to some of you. After all, not having a supported platform isn’t an option for some people.

I don’t know how I feel about this. While we recently had a security update for SQL Server 2012, I know that it’s an older platform and at this point, it’s 10 years past RTM. It is probably time to upgrade to a newer version, which should be 2019 if you can’t wait and SQL Server 2022 if you can wait until the end of the year. I can’t imagine that your workload from 2012 won’t run on 2019, but it’s possible there are some issues.

I’ve run older versions of SQL Server that weren’t supported and often didn’t worry. I knew what worked and what didn’t, and after a few years, it was unlikely that anything in the product would break. However, that was in an environment that was not regulated or certified, which wasn’t always the case. I have worked in places where we would upgrade whenever we got to the end of mainstream support as we weren’t interested in paying for extended support.

I also think that while SQL Server is very mature, and it’s possible that you don’t need new features, you do want a platform that is secure. That means you do want support and fast action if an exploit becomes published. There is also the case that we often want developers working on modern platforms, both because they can take advantage of better language constructs, but also because this helps retention. Try hiring for an all SQL Server 2012 environment v a SQL Server 2019 one. You might find people, but a lot of the talented ones would prefer to work on a modern platform, not a decade old one.

If you are running SQL Server 2012 (or 2008x) and considering the cloud, check out the promotion. It might help you make a decision on whether to upgrade locally or move to Azure.

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Tagged | 2 Comments

Daily Coping 27 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

Today’s tip is to let go of something small bothering you and focus on something going well.

Most things that don’t go well in my life are small things. I am very blessed and I try to remember that on a frequent basis.

One small thing that’s bugged me lately is the struggle to get to a number of projects around the house and ranch that keep getting delayed. My wife has no shortage of things to do, and I have a number of projects that I want to finish, especially before winter.

An example is replacing a couple of posts that have broken and are (barely) holding up a gate. Started to dig out out, but paused since I wanted to cement both replacement posts in, and bad weather stopped me. I couldn’t get back to the work the next week, with too many things during the day and a few commitments at night that got in the way.

It’s hard, dirty work and just running out there for 15 minutes isn’t easy to do. I could go back to my desk in dirty jeans, but I’d prefer not to. As a result, this post is semi-replaced for over a week. Being out of town last weekend didn’t help. I started walking out there this weekend, but then it started raining. Just my luck.

I had a small medical procedure this week and I can’t exert myself for a week. So the posts are sitting there for now, while I heal. I’ve let this bug me, but really, I shouldn’t think this way. I should be pleased that I did get one post partially dug out, and I took a bit of time when I got home this weekend to do some chores for me daughter, who wasn’t feeling well. I did get things done, and this isn’t critical. The gate is rarely used, and I have gotten some more important things finished.

Ranch chores are going well. I need to remember that, even as I know there are other things yet to do on the list.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 27 Jul 2022

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.

Posted in Blog | Tagged , , , | 2 Comments