I’m off today, attending the MVP Summit in Washington. Enjoy Serious Hacking.
Author: way0utwest
-
A Week of SQL Server 2019
I’m in Redmond, or Bellevue, or somewhere nearby. Not completely sure where the Microsoft MVP Summit is this week (as I write this). I’ve got travel planned, so I’m sure I’ll figure it out.
In any case, I can’t talk about anything I see this week for now, but I am excited. It’s a week of SQL Server 2019 and future work that’s coming to us at some point. I don’t always get excited about new versions, and SQL Server 2017 wasn’t one, but I’m changing my mind.
I think SQL Server 2019 is going to be a new evolution of the platform, with the Big Data Clusters and K8s support. This is going to change how we deal with data over time.
Don’t ask questions for now, but as soon as I can write about things, I will.
-
Dealing with Failure
This past week was a dichotomy for Coloradans. On Tuesday, it was 60F (15C) for most of the day, with my daughter and I going to volleyball practice in t shirts and shorts. Our phones chimed during practice, noting that schools had been cancelled for Wednesday, in anticipation of a winter storm. Plenty of people laughed about that at the time, and no shortage of parents were annoyed by the premature decision, especially with little wind and rain falling at 7am Wednesday.
That changed with high winds and some snow all over the area. Cars were stuck on roads, first responders overwhelmed, the airport closed, and people stuck in places between home and work. We hunkered down here at the ranch, and while horse care was hard, we survived. Power flickered for me, but I was able to work Wed and Thur without worry. I also have a generator, but we never lots power longer than the 30s it takes to kick in.
Glenn Berry wasn’t quite as lucky, though he came through the storm fine. He did lose power, and wrote about his experiences. Glenn is about 12 miles S of me, and in a rural area. I thought his thoughts on the experience were interesting, and not a lot different from the ones I had recently with another power outage. I don’t mind storing gasoline, and we have multiple generators here because of the horses, but I appreciate Glenn’s thoughts on finding a different way of storing power.
We both realize that disaster can strike and it’s important to think through the issues ahead of time. While I depend on my phone in the event of losing our Internet connection, I could easily lose that as well. The local towers probably run off batteries and in an extended outage, they’d lose power before I would. I have a tractor and can plow out our driveway, but in this case, the county roads were closed Wednesday and Thursday due to the poor conditions and number of cars stranded. Apparently Wed night visibility was inches and cars were being abandoned in the middle of roads. I’d prepared for a few days outage, but if this were still ongoing today, I’d start feeling the pinch from a lack of supplies.
It’s not often we encounter a major disaster at work, but it’s entirely possible that the secondary support plans we have in place won’t work. You might have a supplier for more diesel fuel, but if everyone else needs more, will you still get some? What about issues with a complex process at work? If it fails and you end up rebuilding some ETL flow, do you have the staff or are you expecting a “Brent” to help explain things and do some of the work? I think plenty of us have that dependency, one which we don’t think about until that person is on holiday and we need their expertise.
Disasters come in all sizes, but often they seem to come in the size that is at the limit (or just beyond) our preparations. I suggest that during some down times, take a minute and think about your preparations. Think what could go wrong. Do a little brainstorming and gaming of situations. If your plan has an issue, do you have another idea of what to do? It might be good to at least have thought about the potential issues.
Steve Jones
-
How Long is Too Long?
After SQL Bits this year, there was a discussion on Twitter about the length of the sessions and what attendees would like to see. The event ran 50 minute sessions, and that wasn’t appreciated by some speakers. It’s an odd length, and one that few events use. Even SQL Saturdays often do at least 60 minutes, though often I find larger conferences do 75 or 90 minute lengths. In response to some of the debates about short vs. long sessions, Brent Ozar Unlimited is running a poll as well. I’d encourage you to participate and help shape how conferences structure their schedules.
I’ve somewhat argued against the shorter session for a conference, or really, at SQL Bits, because the short length is disruptive for me. I’ve got sessions I’ve prepared and given elsewhere. Some I’d like to give at Bits and some I’d update and adapt for the event, but cutting down from a 75 minute talk to 45 or 50 minutes is quite a bit of work. I know because I had a session last year that was accepted at multiple events. I had to give this in 30 minute, 60 minute, and 75 minute lengths, which was a challenge. I ended up building the 75 minute version and cutting things out, but it felt like I lost some flow and continuity at the different events. I think this was because it is just hard to practice different lengths and deliver them well.
That’s me, and I’m a speaker. If I want to present, then I need to adapt, so some of my argument is because I would like to avoid some work. I practice sessions many times and work hard to build a smooth flow that attendees follow. Changing lengths means more practice for me. I’ll do it, but I’ll also think about skipping events that use weird times. 60 minutes isn’t too hard to get to from 75 minutes, but I still find myself rushing at the end. I know trying to fit down to 50 minutes would be hard. I definitely see lots of speakers that struggle to get their talk going, and often run out of time, which I think gets worse with shorter time frames.
For the attendee, I have a different view. I actually think that shorter is better. At our SQL in the City Streamed events, we’ve experimented with sessions at 25, 35, 45, and 60 minute lengths. I like the shorter ones, which are more focused, and I do think that we can focus down on a topic more tightly in a 30-45 minute session. Strangely enough, I find the 15-20 minute sessions the hardest to build, often because I feel I have to jump right into the topic and the demos have to be very tight and reliable.
SQL in the City Streamed, however, has no audience. No one to ask a question or slow the session down. Also no feedback to understand if I’m losing people because of a poor explanation. In a live event, I find that my pacing will vary slightly as I take questions or elaborate on a point. The shorter the session, the less time for this, but perhaps that’s fine. Questions can be handled later, or maybe even submitted to speakers who can publish answers on their blog or an event site.
We deal with a lot of complex topics in technology, and I’d agree that many aren’t handled very well in short sessions, but I also think that complex topics aren’t handled well in 90 minutes either. Going to shorter session lengths means more slots during the day, maybe even more networking, and perhaps best of all, more breaks to stand up and move. If I were designing the ideal length, I do like 50 minutes, with a 10 minute break every hour. If a speaker needs more time, then build a 100 minute session and present in two parts, still with a break.
Selfishly, I like longer sessions as a speaker where I can dig into topics and spend more time explaining concepts, demoing solutions, and developing a pace of delivery. As an attendee, I prefer shorter sessions, but I do expect more effort from speakers to be on point, have demos that flow smoothly and quickly, and don’t waste time on items that the audience should be expected to know. However, I’m also a member of the community and I’ll work with whatever decisions conference organizers make. I’d just prefer they stick close to each other with similar session lengths.
Take Brent’s survey, but let me know in the discussion here what you prefer and why? Should you get shorter, more tightly focused sessions? Think about something you’ve seen recently and how it would be if you cut the length down or made it longer. Would the talk have been better or worse?
Steve Jones
The Voice of the DBA Podcast
Listen to the MP3 Audio ( 6.7MB) podcast or subscribe to the feed at iTunes and Libsyn.
