Speaker Idol

My first attempt at a little AI art, Made with Open AI Dall E 2.

This was a write-up I did for my company to explain what Speaker Idol was and how it could be used to get more speakers for our internal training at the company. Since I was writing it up for internal use, I would also go ahead and make a blog post.

Speaker Idol is a concept/idea that allows a group to gather more speakers for future events.  If you are at a meetup and you are trying to fill your speaking roster for the year, this gives you a method to do that.  It also helps to grow your speakers and help new speakers get started.  The goals of Speaker Idol are simple. 

  1. Give a new speaker the chance to speak in a safe, supportive environment, and with minimum preparation time.  This removes the barrier to entry for new speakers. 
  2. Grow the speaker pool you have available to you as an organizer of events. Whether that’s a user group/meetup/conference.  
  3. Teach new speakers with constructive feedback about how to improve the session. 

This is not a new idea, I do not take ownership of coming up with this idea. I used this successfully in a few user groups I’ve run and have continued to use it.  It is another tool that community individuals can use to grow the community around them.  

What is a Speaker Idol presentation? 

Put simply it’s a full presentation where you only present one portion of it.  

New speakers tend to have a big idea! Perhaps something like “RDBMS Internals”.  This is a little large for a first-time speaker to be taking on. It could literally be hundreds of presentations to make that concept work. But if they can think of one specific idea like, “Pros and Cons to clustered indexes”. This is something that could be one part of a presentation called “Indexes in an RDBMS”, in that larger presentation you might be talking about many different types of indexes and you intend 1-2 slides on the “Pros and Cons of clustered indexes”.  Perhaps you had a demo to show the advantages and what’s good and bad about them.  

This is how you would break down a speaker Idol presentation.  For a brand new speaker, we can coach them that they just need 1 idea, 1 demo, and a few slides to talk about the presentation. Once they have gotten over this hurdle they can then present the full presentation. They also have the building blocks and time to build the rest of the presentation.  

Grow the Speaker Pool

Once someone presents a short presentation at Speaker Idol the goal is to have them come back to the group and do the full presentation. Consider the short presentation as a preview of the real thing. This helps to grow speakers, it also gives organizers more presentations to fill out the year. It is your responsibility to keep fostering that new speaker and encouraging them to come back and do the full presentation. Most of the time when a speaker gets over the initial hump of presenting they want to keep doing it.  This is not true in all cases though so please don’t push people that they are required to do the full presentation.  Presenting might not be for them and most importantly you still want to keep them as a member of the community.  

Constructive Feedback 

The best way to improve as a speaker is good feedback from your audience. Speaker Idol is designed to help with this for speakers. The beginning of every Speaker Idol session starts with a quick 5 minutes on how to give “constructive speaker feedback”. The key items are listed below, you can change these as you need. 

  1. Please be detailed in your feedback and tell me how we can improve. Good examples:
    1. “Speaker needs to talk louder”
    2. “Speaker needs to engage the audience”
    3. “Speaker should be better prepared and have tested demo to make sure it worked properly”
  2. Bad Examples:
    1. “Speaker sucks” (Tell what they did wrong)
    2. “Boring session” (Tell why it was boring)
    3. “Worst session of the day” (Tell why and what went wrong)
  3. Tell the speaker what you did/did not like about the session. “Good examples”
    1. Loved the jokes/comedy, I really wished you would have reviewed this query in more detail.  
    2. You had great attention to the audience but kept forgetting to repeat the question, Please do so in the future. 
    3. I was really hoping to see X information in this presentation since that’s what I got from the Abstract.  

We use a simple google form that allows for audience members to leave feedback.  I know that in most presentations you don’t get a lot of this. That’s why Idol has to focus on it and mention that people should go fill out the form while the next presenter is getting ready. If you are in person’s hand out the forms and say a drawing will be based on the forms handed in. Even if it’s online create a drawing for the audience based on the feedback.  This greatly improves the chance of getting feedback. It’s critical that whoever is running speaker idol reminds everyone to give feedback.  

The Rules (More like “guidelines” adapt as you see fit)

  1. Each presentation should be longer than 5 minutes but less than 15 minutes.Q&A is included in the time.  TIP – focus on one topic and one demo, you are trying to get one key point across of a bigger idea. 
  2. You still will need an Abstract and Bio for the presentation.  TIP – This is a common practice in presentations and you should get used to writing them. 

That’s it,  Pretty simple, right?  Here are some more tips. 

  1. If you have 1-hour meetings schedule 3 presentations.  This gives your audience a good mix of presentations and if you have a big list of participants you can get through. It should give you enough buffer time for feedback and talking as well. 
  2. Plan a speaker gift!  Originally we had this as a competition and crowned a 1st, 2nd, and 3rd place winner. You are welcome to do that. I found in later years I really just wanted to grow speakers and grow the community so I moved this to a speaker gift for those that took part.  This is entirely up to you.
  3. Plan an audience feedback drawing.  As mentioned above feedback goes better if you have a drawing for it.  Plan to get a couple of gift cards or something that you can draw from the feedback.  
  4. Give the feedback quickly to the speakers,  If you do an online form and you have to do any parsing/work to get the data out of the form make sure you do it quickly after the presentation. The more immediate you can make the feedback to the presenter the better.  
  5. DO NOT open up the session for public feedback and discussion.  If you are a small internal team in a company this is OK, if you are a meetup/user group/public meeting with many different people make sure this feedback is done through a form method.  
  6. Do an “Introduction to presenting/Speaking 101”  presentation for the new speakers before the event.  Typically about 2-3 weeks before so they can adjust the presentation if needed.  I have videos I’ve done on this in the past you can use or you can create your own. <link to past video I did for this. Apologies for the not great audio>

I’ve found in years past this is a great way to kick off your year as a user group leader.  It gets people excited and gets a lot of future presenters for you to work with.  Hopefully, you can use this concept to grow your community! 

PGSQL Phriday #004 Postgresql And Software Development

Perhaps a good discussion and drink are all that you really need. 

This Blog post is for the PGSQL Phriday blogging event. Henrietta Dombrovskaya asks about Software Development and PostgreSQL. This is a significant topic, I work with developers frequently and how they use the database(usually telling them it’s time to move away from an ORM). I think for this month I’ll take the topic from that perspective. 

Did you ever have (frustrating) interactions with application developers? Did they end with some truce?

I rarely have non-frustrating interactions with developers, when I start working on a DB project. The first thing I do is have a good discussion with the DB. These are scripts I’m running to do this but it usually goes something like this.

Pat: Hey DB, Let’s check your query and resource utilization and see how you are doing, 

DB: I keep getting these different queries hitting me, none are in functions or procedures, none are optimized and they keep asking for 10 tables in every join?!?!!?! Help! 

Pat: Sound like you have an ORM problem. 

DB: What’s an ORM? Why is it hurting me so much? Please help! 

Pat: An ORM is a way for developers to build something fast, cheap, and easy. They use it to build applications quickly and then rarely if ever find ways to remove those ORMs and make a better application.

DB: Can we charge them with DB abuse? 

Pat: Unfortunately it’s not that easy, but don’t worry I’ll start working with them and we’ll give you some medicine for the short term and long term we will work on removing the bad pieces. 

DB: <Takes some new index pills, and starts feeling better> Thanks! I look forward to being healthy in the future! 

I just realized this would be a perfect “Tell me you’re a DBA without telling me you’re DBA” 

As a data person, whether with PostgreSQL or any other RDBMS we feel a certain sense to “defend” the database. It’s a system that cannot defend itself in most cases. This isn’t wrong to defend the database but you have to be careful how you present this.

We too often assume developers are doing this because they just don’t care about the DB. I find that’s almost never the case. They want to write an optimized, scalable, and efficient system as well they just don’t usually understand how to do that. Most application developers that went through school barely got 1-2 semesters of “How to write SQL”. Most of that time was how to work with 3rd normal form and nothing else. They also don’t think like databases. In Procedural logic in which Application Developers live everything is “IF this happens then do X else do Y”. It bases the ideas on one item going through some sort of logic. Databases think in sets, they think in large chunks of data, and they format based on rows and columns and not just one item. So most application developers at first apply the same thing they did in code to the DB and you end up in a bad situation. 

The key here is not to come into these situations with guns blazing trying to tell the developers how many things they have done wrong to the database. You need to walk into situations like this and focus on what short-term items you can do for the database to give it some time so that you can educate and start discussions with your application developers. 

Does it end in a truce? 

For me, a “truce” means it’s a competition and someone has to win. I don’t see any need for competition. No one has to “win”. They have to create a system that works for the company in a way that works for the company. If the Database is hit a little harder than I would like but it makes better financial and cultural sense for the company then both the application developers and DBA/Data people are winning. That’s what you really want. You don’t want a Truce, you want a working system that makes the company money. 

Thank you, Hettie, for bringing up a great topic! Hopefully, all my readers can think about how they approach working with application developers in the future. Perhaps like in the picture at the beginning they will sit down and have a drink and a good discussion about Databases. 

Engineers Guide to Layoffs, A Checklist 

This was presented at the Big Data Utah Meetup, on 12-14-22. If you would like to see the video of this please use this link.

Before the Big Mountain Data and Dev conference, I decided to make a presentation about what you should do to prepare for being laid off.  I had no idea of the storm that was about to happen in the Tech Community.  

When I first told people about the presentation, they all thought it was a negative thing and what would compel me to bring up that topic and speak on it. It felt like people believed that if you talk about it, it will magically happen to you.

This is a problem! No one likes layoffs and no one wants to be laid off.  But we cannot avoid it.  It WILL happen, sooner or later in this environment we live in it will happen to you.  I would much rather be prepared for it. I would much rather talk about it now rather than after I was already laid off.

The first rule of being prepared for something like this is to accept one simple fact.  

Job Stability is an illusion.  No job is 100% Safe 

  • I *know* you love the company you work for.
  • I *know* you love your manager, you hang out as friends.
  • I *know* you won X awards from the company, and you’ve been promoted X times.  

I know because I’ve been there,  I also know that a Company is a business and the first rule of a business is to make money so that it can keep being a business.  It is true that 95% of the time it is not personal and it’s not performance related when you are laid off.  You should NOT take it personally,  I know this is said a LOT, it’s true and needs to be accepted.

You can still be loyal to a company, still, have fun, and still, go ALL in with your work. Just understand that you may not have a position in the future. Regardless of how much time and energy you spend on the job. 

I have a lot more to say on this topic and you are welcome to watch me talk about it in my presentation.   For now, I wanted to provide a checklist you can do RIGHT NOW whether you have been laid off or not you should do this right now.  

Be Prepared 

  1. Schedule a lunch,
    1. Right now go to your calendar and setup a re-occurring meeting that reminds you at the beginning of the month to schedule a lunch with co-workers, former workers, and friends.  Someone in your network that you can keep up with, chat with, and network with.  You should do this at minimum once a quarter.  Even better monthly.  With different people so you can keep your network strong and connected. 
  2. Attend Meetups/User groups/Conferences.
    1. Even if you do not LOVE the topic, Go for the networking, discussion, and meeting others.  Talk to other people in the group and talk about projects you are working on.  
    2. Attend Conferences even if the company is not paying for them. You need to invest in YOU  do not wait for a company to invest in you.
  3. Blog/Linked in posts
    1. Stay active on Linked in, even if you just comment from time to time on a few posts. Show activity, Update your job skills and your job functions.  YES that gets you lots of annoying recruiters reaching out to you but it also keeps you active which is good for future employers.  
  4. Volunteer.
    1. This doesn’t have to be something related to your work, it can be any volunteer organization. You get to meet a lot of different people when volunteering and this increases your network and shows a drive to do other things.  Future employers love hearing about your drive and passion. 
  5. Accept Lunch!
    1. As Tech people we don’t really like sales pitch lunches, we just want the technical details and how the system works. But we need the sales people to connect us with other companies to have future connections with how things work. So don’t be afraid to attend a sales event even if it’s just to talk to other users of the systems that you are using.  
  6. Take a Class/Attend meetups on different Technology
    1. Learn something you DO NOT USE at work. No your current employer is not going to help support this most likely. This is once again investing in YOU and your future. 
    2. Learn to Present,  Presenters are seen as leaders in the community, they have a great chance of recovering quickly from a layoff because others have seen what they can do and want the passion they have.  I’m always willing to fully train someone on this if you are interested hit me up in the comments. 
    3. Learn to Sell,  Ya I don’t like this one either, but the truth is that you have to learn to sell yourself a little.  It’s a fact of life that an interview is about expressing how much you can do for the company. You are selling your skills and abilities and you need to practice that.  For most tech people this does not come natural. 

Handling your Layoff 

  1. Take some time.
    1. It is Almost never personal, But you will feel that it is. I know I did.  Take some time to process those feelings and work through them.  Even if it’s a few days or a few hours make sure you accept what has happened and focus on how to move forward. 
  2. Pivotal Change
    1. Re-think where you are and where you want to be.  Even if this is a stressful time, you need to take a minute and think about the positions you are looking for and what you want to do.  Somethings a Layoff ends up being a much more positive thing in the end.  
  3. Share/Post
    1. Everyone should post on Social networks about being Laid off.  You need to let your network know and you need to make sure they are all aware that you are looking for assistance.  This is not being weak, complaining, sob story, or silliness. This is what your network is here for!  Reach out and let others know! 
  4. Leave Well
    1. Yes, It hurts, Yes the company betrayed your trust, put you in a bad spot, and in many cases I’ve been reading truly ruined people’s lives.  You have to move forward.  You hope to work with some of the people again in the future and doing something bad is not a good thing to keep that relationship going.  Be mindful of the words you use as leaving and in your social posts.  

To steal an idea from my good friend Andrea Allred(RoyalSQL).  The song for this post is. 

Going through Hell By Rodney Atkins

I hope you found this list helpful and I hope that you will take a few minutes to do some of the items on this list so that you can be more prepared for when you are laid off.  If I’ve learned anything about being in the Tech sector for 20 years is that Layoffs can and will happen. All the time.