Retrospective on the 2023 Data.SQL.Saturday.LA event

A few weeks ago (June 10, 2023) we had our 2nd EVER (after covid) in-person event and it’s time to talk about how it all happened. This blog post is going to talk about our original plan, what we were able to deliver, and what worked well vs. what needs improvement.

After our first in-person event (after covid), our goal was to rinse and repeat while trying to meet or beat our 300+ attendees in pre-covid days. We wanted to see more speakers, sponsors, and attendees. We wanted to see more enthusiasm for data, and we wanted to see greater outreach beyond our 78 attendees back in 2022.

Despite a late/slow start on March 2023, we got things together pretty quickly. Due to our past experience and the desire of teammates/volunteers to have another awesome event, we were ready in less than 2 months. After a total of 5 online meetings to prepare for the event and numerous emails/text messages/calls/messengers, we were ready to make it happen.

Running an in-person after covid and after the PASS demise

Since this was our second in-person after PASS’s demise, we already had most if not all tools lined up at our disposal to replicate and enhance our event experience. The Team behind sqlsaturday.com was excited and ready to help with YAML. The LMU Team was excited to have us back. We (aka the Team) were excited to forget about online meetings for a day and have a great in-person event.

Tools used during this event:

  • Eventbrite.com for event registration
  • Eventbrite Organizer mobile app to check in and register on the spot if needed
  • Eventbrite.com to sell & process lunch tickets and credit card transactions
  • Eventbrite.com event collection to promote both pre-conference and the main event
  • Datadriventechnologies.org blog post to list all available sponsorship tiers
  • Microsoft Form with QR code to enable sponsor sign-up
  • Stripe.com to generate invoices for sponsors and process sponsorship fees
  • Sessionize.com for speaker registration/schedule/session management
  • Sqlsaturday.com for event listing
  • Microsoft Forms with QR codes for event and session feedback
  • Microsoft Forms with QR codes for event/sponsor raffle
  • Microsoft Forms with QR codes for volunteer registration
  • Sender.net to send email marketing campaigns
  • Buffer.com for scheduling posts on Facebook, Twitter, and LinkedIn
  • Planoly.com for scheduling posts on Instagram

Event stats:

  • 100+ attendees with 200+ registered attendees
  • 20+ speakers and 20 sessions (4 rooms x 5 sessions)
  • 10+ paid sponsors (5 sponsor’s tables)

Things that we planned, but decided against

  • Advertise using road billboards
  • Record sessions and publish them on our YouTube channel
  • Codecamp challenge

What worked great

  • Speaker appreciation dinner at the Gulp Restaurant and Brew Pub in Playa Vista to facilitate flow and exchange of enthusiasm for data
  • Pre-conference SQL Server Performance Tuning with Free Tools all-day training by John Sterrett
  • Lunch group order for 20 people from Mendocino Farms
  • Eventbrite Organizer phone app to register and check-in attendees
  • 2 separate event tickets, one for free admission and one for a $15 lunch ticket
  • Combined Social Media Booth with Keynote and Raffle
  • Event raffle with a minimum paper trail
  • Inclusion of raffle gift cards for each paid sponsorship
  • Speaker gifts (something small, but valuable)
  • Sessionsize-made social media banners to promote the event on social media
  • Communication via Sender.net email campaigns
  • Created session PPT template
  • Guesstimated the right amount of food and beverages for breakfast and lunch
  • Buying canopies instead of renting them out to save money
  • Buying our own coffee/tea urns instead of renting them out to save money
  • Printed event schedules as well as created large format event schedules (with session feedback and event schedule QR codes)
  • Shared all the event printable stuff with an entire team
  • Invited Postgres sessions with distributed database systems
  • Scheduled a Women in Technology (“WIT”) session
  • Recorded interviews with speakers/sponsors for our YouTube channel
  • Recorded all event expenses and gains in Office 365
  • Employed a group on WhatsApp mobile app to capture session attendance and photos
  • Procured drawstring backpacks as attendee bags

Things to improve

  • Find alternatives to Stripe credit card processing that currently charges extra for invoicing
  • Revisit included gift cards and make changes to make them attractive and consistent
  • Explore venue alternatives to St. Robert’s Building (“STR”)
  • Change static QR codes to dynamic and print high-quality posters
  • Check if Eventbrite allows conditional event tickets
  • Improve raffle management, provide a list of sponsors and items to raffle, list of winners to raffle managers, note sponsor prizes
  • Improve event attendance, with more speakers and sponsors
  • Ask the LMU desktop support to check the room projector hookups
  • Ask the LMU maintenance crew to make sure that A/C is working in all the session rooms
  • Use a Group order option/feature for Lunch orders to have an exact amount of food with attached attendees’ names
  • Make a QR code for LMU Guest WiFi
  • Add more event signage

2023 Data.SQL.Saturday.LA Sponsorship Plans

Sponsorship Plan

We appreciate you taking the time to consider sponsoring 2023 Data.SQL.Saturday in LA. We have assembled a few sponsorship plans that you can select from. Donations for this event will be used to cover the costs of running the event and the LA Data Platform SQL User Group meetings. If we have any surplus, it will go into sponsoring future events. The event is put on by Data Driven Technologies, Inc. a local 501.c.3 non-profit, and its volunteers.

Event Overview

The Data.SQL.Saturday is a single-day conference that offers data professionals the opportunity to improve their skills and learn about new products while networking with others in their field and connecting with other members of the local Database community and our sponsors.

This event is put together by a group of dedicated Los Angeles database community volunteers, local database user groups, and volunteer speakers from Los Angeles, California, other US States, and across the globe. 

Attendance

When the event was held in person, it used to bring in 300+ attendees.  In 2020 we moved to a virtual event for the first time and had 700+ registrations from all around the world, with 400+ attending the event. In 2022, the first in-person event after COVID19, we had 78 attendees in total. For 2023 event, we anticipate 100+ attendees.

Cost of Sponsorship

This year, sponsorship ranges from Swag Only at $0 to Platinum at $2,000.00, depending on the package you select:

 TierSwagBronzeSilverGoldPlatinum
Amount$0$350$650$1250$2000
Sponsor Logo and URL on the event website xxxxx
Sponsor Logo and URL included
in social media/email campaigns
xxxxx
Sponsors Logo included in session slidesxxxxx
Sponsor Logo included in YouTube videosxxxxx
Social Media posts Facebook/Twitter/LinkedIn/Instagramxxxxx
Sponsor Rafflexx
$25 GC included
x
$50 GC included
x
$75 GC included
x
$100 GC
included
Collect Raffle Leads*x xxx
Email sent on behalf of a sponsor  xxx
Sponsor table (comes with canopy
, 1 table, 2 chairs, WiFi and electricity)
(based on availability) 
  xxx
Product-focused sponsor session 
(based on availability) 
xx
Sponsor a room (name a room)
(based on availability) 
  xx
Short video advertising embedded in
a recorded session (if the room is recorded)
   xx
Caffeine and pastriesxx
Sponsor Emailx
Speaker Appreciation dinnerx
12 months of LA Data Platform
User Group sponsorship
x
Sponsorship Plan

To sponsor please follow this link to fill out the sponsorship form: https://forms.office.com/r/4VWxbgTBrQ.  An invoice will be emailed to you (generated by PayPal) and can be paid by check or credit card. All fees must be paid in advance.

Cancellation Policy

Any cancellation that is caused by us will result in a full refund. It’s really that simple – no event, no expenses, no need for sponsorship money.

Raffle Management

Raffle registration is used to opt-in attendee information with our sponsors.  Remember the raffle prize is your key to success and the better the prize the more leads you will collect. Attendees must be present to win.

We will manage the raffle and collect, clean up, and de-dup the data for you and send you the leads after the event.  We will let you know who the winners of the raffle are, and you can send them the prize.  At the same time, we strongly recommend we take over prize disbursement as well, to be a one-stop shop for an entire raffle lifecycle. Please let us know if you would like to handle the raffle prize on your own. 

2023 Data.SQL.Saturday Call to Speakers

We are looking for speakers. We are looking for awesome and passionate people to present on different data-related topics, such as:

RDBMS/NoSQL – SQL Server, Postgres, Oracle, MySQL, Snowflake, MongoDB, and others

Public cloud: Azure, AWS, GCP, Alibaba, Oracle, IBM, and others

Visualization – Power BI, Tableau, Qlik, and others

Please follow the link or scan the QR code below to submit your session(s):

https://sessionize.com/2023-data-sql-saturday-la/

Retrospective on 2022 Data.SQL.Saturday.LA event

Last month (August 2022) we had our 1st EVER (after covid) in-person event and it’s time to talk about how it all happened. This blog post is going to talk about our original plan, what we were able to deliver, and what worked well vs. what needs improvement.

After 2 years of virtual events, our goal was to finally have an in-person event. Whenever this is going to be a 300+ attendees event or small event, we were anxious to just have an in-person event. While running virtual events was better than having no events, we missed the energy exchange that frequently happens during an in-person event.

While we were originally targeting our regular event month, we had to give up on June 2022 due to venue unavailability. We were ecstatic to hear that August is available and booked Loyola Marymount University for August 13.

Running a PASS-free in-person event

Since this was our first in-person after PASS’s demise, we had to bring new tools to replicate and enhance our event experience. Unfortunately, sqlsaturday.com in its current form only provides us with the event listing. Luckily, our 2 past virtual events allowed us to master additional tools.

Tools used during this event:

  • Attendee registration – Eventbrite.com (+ Organizer mobile app to check-in)
  • Sponsor registration – custom-built Microsoft Form to enable sponsor sign-up, listing all available sponsorship tiers on the datadriventechnologies.org website, and PayPal invoicing to collect fees
  • Speaker registration/schedule/session management – sessionize.com
  • Event listing – sqlsaturday.com
  • Event/session feedback – custom-built Microsoft Form with QR code
  • Event raffle – custom-built Microsoft Form with QR code
  • Volunteer registration – custom-built Microsoft Form with QR code
  • Email marketing – Sender.net
  • Social Media marketing – buffer.com

Event stats:

  • 14 speakers and 15 sessions (3 rooms x 5 sessions)
  • 78 attendees with 209 registered attendees
  • 6 paid sponsors (4 sponsor’s tables)

What worked great

  • Using EventBrite Organizer phone app check-in option provided us with real-time exact attendance numbers (no need to count attendee bags)
  • Having Social Media Booth generated plenty of visual content for our Instagram account
  • Running raffle without any paper and relying solely on electronic data collected by Microsoft Forms
  • Inclusion of raffle gift cards for each paid sponsorship
  • Indulging our speakers with both t-shirts and Yeti mugs
  • Communicating via 5 attendee email campaigns using Sender.net
  • Communicating with 3 speaker email campaigns using Sender.net
  • Creating session PPT template
  • Buying enough food and beverages for breakfast and lunch
  • Allocating 30-minute long breaks between sessions

Things to improve

  • Choose an event date with no local conflicts (choosing August 13 for event data was a strategic mistake as we ended up competing with DataConLA which happened on the same day and affected our attendance)
  • Create a printer-friendly Sessionize schedule (apparently, attendees preferred a printed schedule instead of a Sessionize PWA app)
  • Offer 2 Eventbrite types tickets (bring your own lunch and paid lunch) and collapsing paid into free few weeks before August 13 introduced complexity and confusion
  • Hick ups with the Eventbrite Organizer phone app
  • Automate raffle management
  • Perfect sponsor raffle QR codes
  • Improve keynote attendance

You are cordially invited to attend 2022 in-person Data.SQL.Saturday.LA event!

2022 Data.SQL.Saturday.LA
 Logo by Janella Payumo and Robert Mizikovsky

You are cordially invited! 😎

We are reaching out to all people that enjoyed SQL Saturday in LA 2017, 2018, 2019, 2022 and 2021 events to let you know that the 2022 event is quickly approaching. Only 30+ days remain until the Data.SQL.Saturday.LA event on Saturday, August 13.

More information here – https://www.sqlsaturday.com/la
Follow us on social media – https://linktr.ee/sqlsatla

Event Flyer

Flyer by Nasser Mansour and Elaena Bakman

Announcing 2022 Data.SQL.Saturday.LA Sponsorship Plans

Sponsorship Plan

We appreciate you taking the time to consider sponsoring 2022 Data.SQL.Saturday in LA. We have assembled a few sponsorship plans that you can select from. Donations for this event will be used to cover the costs of running the event and the LA Data Platform SQL User Group meetings. If we have any surplus, it will go into sponsoring future events. The event is put on by Data Driven Technologies, Inc. a local 501.c.3 non-profit, and its volunteers.

Event Overview

The Data.SQL.Saturday is a single-day conference that offers data professionals the opportunity to improve their skills and learn about new products while networking with others in their field and connecting with other members of the local Database community and our sponsors.

This event is put together by a group of dedicated Los Angeles database community volunteers, local database user groups, and volunteer speakers from Los Angeles, California, other US States, and across the globe. 

Attendance

When the event was held in person, it used to bring in 300+ attendees.  In 2020 we moved to a virtual event for the first time and had 700+ registrations from all around the world, with 400+ attending the event. In 2022, we anticipate 200+ attendees.

Cost of Sponsorship

This year, sponsorship ranges from Swag Only at $0 to Platinum at $2,000.00, depending on the package you select:

 TierSwagBronzeSilverGoldPlatinum
Amount$0$350$650$1250$2000
Sponsor Logo and URL on the event website and xxxxx
Sponsor Logo and URL included in email campaignsxxxxx
Sponsors Logo included in session slidesxxxxx
Sponsor Logo included in YouTube videosxxxxx
Social Media posts Facebook/Twitter/LinkedIn/Instagramxxxxx
Sponsor Rafflexx
$50 GC included
x
$75 GC included
x
$100 GC included
x
$125 GC
included
Collect Raffle Leads*x xxx
Email sent on behalf of a sponsor  xxx
Sponsor table (comes with canopy, table, 2 chairs, and electricity)
(based on availability, first come first serve) 
  xxx
Product-focused sponsor session 
(based on availability, first come first serve) 
xx
Sponsor a room (name a room)
(based on availability, first come first serve) 
  xx
Short video advertising embedded in a recorded session (if the room is recorded)   xx
Caffeine and pastriesxx
Sponsor Emailx
Speaker Appreciation dinnerx
12 months of LA Data Platform User Group sponsorshipx
Sponsorship Plan

To sponsor please follow this link to fill out the sponsorship form: https://forms.office.com/r/4VWxbgTBrQ.  An invoice will be emailed to you (generated by PayPal) and can be paid by check or credit card. All fees must be paid in advance.

Cancellation Policy

Any cancellation that is caused by us will result in a full refund. It’s really that simple – no event, no expenses, no need for sponsorship money.

Raffle Management

Raffle registration is used to opt-in attendee information with our sponsors.  Remember the raffle prize is your key to success and the better the prize the more leads you will collect. Attendees must be present to win.

We will manage the raffle and collect, clean up and de-dup the data for you and send you the leads after the event.  We will let you know who the winners of the raffle are, and you can send them the prize.  At the same time, we strongly recommend we take over prize disbursement as well, to be a one-stop-shop for an entire raffle lifecycle. Please let us know if you would like to handle the raffle prize on your own. 

A TechSmith Camtasia video editing boot camp

Introduction

Digital content is the king. Record, run video editing software, upload to a resource like YouTube or Rumble, and it will stay there forever. There are many benefits in recording and sharing knowledge via video: it can improve the speaker’s ability to deliver material, anybody can see it again and again. This blog post is going to cover a number of easy-to-follow steps to do video editing using TechSmith Camtasia.

Problem

Let’s talk about video editing. Making video content is usually split into 2 phases – pre-production (recording) and post-production (perfecting). While recording video is fairly obvious and mostly involves hitting the red record button, perfecting video is usually a time-consuming and scary process. Let’s make it easy. The following steps and screenshots will help you to get up to speed in creating video content as quickly as possible.

Solution

  • Add media artifacts

Start with downloading the mp4 from MS Teams. Now proceed with opening Camtasia and add a thumbnail, downloaded video, and intro (see Fig #1).

Fig #1 – Add Media artifacts
  • Add media artifacts to a track

Drag and drop media artifacts from the Media Bin into Track1 in the following order intro, thumbnail, and then video (Fig #2). Make sure that all 3 are stacked up one after the other, meaning that there is no space between them.

Fig #2 – Adding media to track 1
  • Edit the video to lose anything that is not important

Left double-click on the video, drag the red time tracker, and then choose Cut (Fig #3).

Fig #3 – edit recorded video
  • Remove noise

Apply noise reduction audio effect to remove any undesired noise from the recorded video by Clicking Audio Effects, choosing Noise Removal, and dragging and dropping it to the video.

Fig #4 – Remove noise
  • Make sure your video is perfect

Left double-click on the intro to bring back the triangle-shaped time tracker to the beginning, and hit the play button (Fig #5) to watch the entire video to make sure it’s all perfect.

Fig #5
  • Make it a video file (mp4)

Choose Share from a menu item above, and then click on Local File (see Fig #6). Depending on your machine, dimension, and format as well as the TechSmith version, this step might take between 30-90 minutes.

Fig #6 – Make a video file
  • Enjoy it

Create a YouTube account with a channel, upload your mp4 file, and let everyone know that it’s ready for public consumption (Fig #7). Don’t forget to make it public.

Fig #7 – YouTube video
  • Syndicate your content

While YouTube drives most of the viewers to channel, others platforms like Rumble are becoming more and more popular. Why not push your content to other platforms?

While you might think it’s not worth the time due to an effort that involves re-uploading your content, in reality, most YouTube competitors have a syncing capability built-in. Make your content available on YouTube, create an account in a competing platform, give that platform permission to access YouTube, and walla, your YouTube content will become available on the other platform as well.

Fig #8 – Content syndication

Disclaimer

This blog post is made possible by two great products Snag-It and Camtasia by the TechSmith Corporation.