Showing posts with label sqlsatbr. Show all posts
Showing posts with label sqlsatbr. Show all posts

Friday, July 21, 2023

SQLSat Baton Rouge 2023!


Looking forward to #jambalaya at #SQLSatBR on July 29!

Register today: sqlsatbr.com

I hope to see as many people as possible that weekend, I'll be there at the Friday night speaker event.

On Saturday, I am speaking at:


See you there!


Monday, August 01, 2022

SQLSaturday Baton Rouge is back!

Looking forward to jambalaya at #SQLSatBR in THIS SATURDAY! Also looking forward to speaking and seeing all of you there, I guess... Register today: https://sqlsaturday.com/2022-08-06-sqlsaturday1026/

After I stepped down from the SQLSaturday Baton Rouge organizing committee lead in 2019, I had no idea what was to come. A pandemic, the dissolution of SQL PASS, and two missed Augusts later, SQLSaturday Baton Rouge is back! One thing I did get right in 2019: other volunteers deserved the chance to lead and organize and network and they've been doing a great job, from what I can tell so far. I'm happy to see the assets and resources we'd built together over 11 years of SQLSaturdays at LSU continue to be put to use.

I am speaking at:
- 9:45am in the Careers in IT panel
- 11am for Tabletop Role-playing Games at Work for Fun & Profit with Stacy Vicknair and Christine Assaf - Presentation available for download
- 1:30pm for How to Think Like a Certification Exam - Presentation available for download

See you there!


Monday, March 02, 2020

SQLSaturday Baton Rouge 2020 Business Intelligence edition this Saturday!

The first of a double whammy of SQLSaturday Baton Rouge events over the next 5 months, SQLSatBatonRougeBI is this Saturday, March 7! The organizers of this event, from the Baton Rouge Analytics and Intelligence Network, have assembled a dynamite speaker schedule of business intelligence voices from around the country.

Christine and I will be speaking at 3pm on Ethics in Data. This is an important topic that lives at the crossroads of both of our careers: my wife's career in organizational psychology, my career in data, and our joint passion for history and civil rights. The effort of researching, paring down, and rehearsing our presentation together as a couple has been an exciting new challenge for us.

It's important to understand that when dealing with bias, outcomes matter, intentions don't. In this presentation we review historical bias, sources of bias, transparency in bias, patterns and anti-patterns, and disparate impact. We have loads of real-world examples and case studies pulled from journals and headlines alike. This has been a fairly interactive presentation in the past and we look forward to bringing this topic to the audience in our hometown.

I'll also be facilitating a Careers in Business Intelligence panel in the same room at 1:45pm, with a selection of speakers from the conference sharing their career progression and wisdom and experience. All students, educators, and job seekers are encouraged to join.

See you there!



Wednesday, August 21, 2019

My Organizer's Notes and Goodbye after #SQLSatBR 2019

Some 2019 tips for other SQLSat organizers from my last year as lead organizer of SQLSatBR. I hope as a fellow organizer, you can pull some ideas and inspiration for your future events!
  • Last year we tried to take an "action" pic of each sponsor booth. We sent a personal email and included those photos to the sponsors this year, with an email "We'd love to have you back at SQLSaturday Baton Rouge 2019!" This year, we included action shots from Saturday in our "thank you" email that also included the scanned raffle badges for those sponsors. It worked to renew a sponsor in a couple cases, and we received some really nice replies to those emails. Examples:

  • Always capture booth "action" photos, of conversations taking place and with big crowds in the background/foreground. Use them as great call-outs on social mediaBig crowd shots are always winners, tell your photographers! Then, we post all our photos in a shared community photo album for anyone to contribute.
  • Our Thursday night bag-packing event was just so impressive. Notice our double-barreled, assembly-line approach to packing 500 bags in <2 hours. We also packed our third annual speaker goodie bags as a team that night, which was nice, since I'd done that on my dinner table in past years. 

  • In an effort to reduce waste and our landfill impact, we bought biodegradable badge holders this year instead of the slightly cheaper PVC badge holders which are worn once, tossed in a landfill forever. (Biodegradable plastic badge holders aren't as common to find, we bought from kleertech.com and they worked fine with the SpeedPASS PDF name badges that are 4" wide.) We also had our vendor use biodegradable paper-based serving boxes for the lunches instead of standard styrofoam. 
  • Be sure to recognize your user group and host facility partners, offer them a special place in the sponsor lineup. We were fortunate in a position to offer both the La. Tech Park and LSU a free booth at our event, as a big thank you for the free host facilities they provide us year after year. We also reached out and provided free booth space to the local Toastmasters group and a nonprofit that offers STEM education to low SES kids in our city.  But it's important that we make sure to reach out and offer our host facilities some recognition and an opportunity to participate, rather than just a transactional facility rental.

    Especially if your host is a higher education facility that provides post-grad certificates or degrees, which are major revenue sources, they would likely appreciate an opportunity to staff a booth and get their pitch out. This type of relationship is the type that leads the school to give us the facility for free, because the department is "hosting" our event rather than renting us rooms, so we bend over backwards to thank them.
  • We plan on expanding the use of facilitated panel discussions next year, they have been the past three years well attended and an additional honor to speakers and community partners including new potential sponsors. This includes the CIT Panel that we've done for years in partnership with Careers in Tech and our CIO Panels in the past. 
  • Feedback from Kenny Neal, our amazing schedule master: "If we could get a drag and drop scheduling module for sqlsaturday.com it would be great. Like a listing of approved sessions on one side and let me drag them where I want them." Our schedulemaster was otherwise very happy with the new features on the admin SQLSaturday site this year. Gotta keep them happy. Big thanks to all speakers who spoke multiple times, some on short notice, and some three times back-to-back-to-back. Speaker dropouts are always a reality and easy to overcome when you have an diverse, experienced speaker lineup from around the country. Our strategy is to accept single sessions from as many distinct speakers as possible, and then add second sessions from their repertoire as needed.
  • Our Friday sponsor/speaker/volunteer dinner featured live music from the jazz band led by one of our long-time volunteers and a local data professional, Lori St George. Honestly it exceeded all expectations and Lori's Collaboration Band was a huge hit. It was an amazing collection of musical genius until they brought some of our SQLSatBR organizers up on stage for a hard-working finale.

    Are there any fun music acts in your local SQL community? Pro tip: don't ask them to play for free. Don't ask any independent/freelance folks to do what they do for free. We paid our tee shirt artist for design time, our band (no website for them... yet), our user group logo designer, and the baker of our pralines and bread pudding. If someone wants to volunteer their time, great, but if you're asking them for their normal services offer to pay their normal rate.
  • Blown away by all the people who participated in our small remembrance of SQLSaturday volunteer photographer and Baton Rouge community volunteer Carter Spade. Carter tragically passed away in July, leaving a void in many volunteer organizations like ours. Thanks for joining us in that, friends. Thanks for all your help in years past, Carter.
  • Our second year of a STEM Kid's Track was a hit. I visited the classroom after lunch, and the 30 kids in there were actively typing, plugging away, smiling and laughing, planning and debugging, and definitely the opposite of bored. Produced by the Foundation for the EBR School System, it sold out really fast despite being greatly expanded. There were definitely some disappointed parents. Next year we plan two classrooms, and an expanded partnership with STEM educational organizations in the city including the La. Women in Technology group, who we raised money for at our end-of-day raffle, netting a total donation of $1452.

    Someone asked why a few years ago we started emphasizing, featuring, showcasing, and raising money for STEM education nonprofits like The Futures Fund. It's because stuff like this helps the event to be more than "established IT professional training established IT professionals". We cast a wider net, a wider view. I don't want to be a part of an insular same-faces-every-year cycle. That's one of the reasons I have stepped down as lead organizer of SQLSatBR, but will be around to help the volunteers ready to step up.
Why am I stepping down as SQLSatBR lead organizer? There are a few reasons, I'll explain some here. I definitely will continue to support the both our SQLSat Baton Rouge conferences in 2020 as a volunteer, as well as the SQL user groups, as well as my role as a PASS Regional Mentor. But not as lead organizer for the SQLSatBR planning committee.
  1. Organizing the SQLSaturday has been really good for me professionally and personally. I've met tons of people. I've exercised skills as a public speaker, decision-maker, organizer, logistics. I've made friends from fellow organizers and volunteers, vendors in the community. I've exercised gratefulness in making sure to thank people as often and as individually as possible. So, why shouldn't others be able to do this? Other volunteers deserve the chance to own a larger portion of the conference we've built together since 2009. The Baton Rouge SQLSat scene is great to have not only a new SQLSat BI event coming in 2020, but also a dozen folks who I think would be perfectly capable and enthusiastic about running the conference, talking with sponsorships, making sure the spending lines up with the fundraising, talking to vendors, etc.
  2. First off, we have a ton of volunteer/organizers. I have had a lot of help. I want to make sure a smooth a transition as possible happens, so while I won't be lead, I will still be around. I'll probably be speaking more, leading less. But others deserve, want, and are enthusiastic about filling my shoes. There's no better time, the table is set and a great crew of volunteers is hungry. I left with a tight throat but with no animus, no regrets, and no apprehension that this thing that I have grown and loved will continue on. It'll be different in their way, and that's OK.
  3. I'm not sure what I'll do with my freed-up time in the late summers, but I'll figure it out. Don't worry about me. My wife and I have an empty nest and many adventures ahead of us. 'nuff said.
In case I got a little too choked up on Friday night, here's the notes I printed:
Lemme talk a little about SQLSaturday Baton Rouge.
I was just bragging on Twitter about the awesome volunteers we have, literally a couple dozen people show up, new faces and old, to help pack 500 attendee bags and a few dozen speaker bags. We have an amazing venue given to us free via our partnership with the LSU College of Business and the Stephenson Department of Entrepreneurship and Information Systems. We have an artist we’ve known and trusted for years for our poster and tee shirt designs. We’ve got documents, spreadsheets, contact lists. We got shared accounts for email and docs and social media. We’ve got a UPS Store box, we’ve got a high-falootin business bank account with have a dozen card holders and hours of paperwork, we’ve got a legal not for profit corporation. We even got branding for the SQL, .NET and Analytics User Groups to share a common logo concept across all our platforms and signage. We’ve got an amazing team up here, of DBA’s, Dev’s, and Data Professionals, and Microsoft MVP’s and Microsoft employees,
, and one lead singer who is also a data professional.
, and one Oracle DBA but we don’t hold that against Kristen. 
So when I say that 2019 is my last year as lead organizer of SQLSaturday Baton Rouge, I am stepping down from that role, and this is me announcing that to everyone, everyone including my wife, I’m saying it with a high degree of confidence that this thing we’re all doing with our free time in the late summer is in good hands. I’m not vanishing, I’ll be around to help, I’ll probably speak at the event, but this team has got this and we will work deliberately to make sure we’re as successful in 2020 as we have been in the past.
So, enough from me, thank you all, please eat, enjoy the music, see you tomorrow morning.

Tuesday, August 13, 2019

See you Saturday in Baton Rouge!


See you in Baton Rouge this weekend! We have 13 tracks of professional development and training, from entry-level to expert, for SQL Server Administrators, Business Intelligence Developers, Data Analysts, ETL Developers, C#/VB.NET Developers, Mobile Developers, Windows Server Admins,
SharePoint Architects, SharePoint Developers, Network Administrators, Quality Assurance Analysts, IT Managers, Students, Project Managers, Hiring Managers, Jobseekers of all levels of experience, Students, CIO's and CEO's.

Register here: SQLSatBR.com

Print your SpeedPASS PDF here: pass.org/MYPASS.aspx?viewctl=MySQLSaturday





Tuesday, November 06, 2018

Emphasizing STEM Community Education at your SQLSaturday

Was honored to speak to fellow SQLSaturday Organizers at the PASS Summit SQLSat organizer meeting on Tuesday. Here's an outline, detail and links to some of the things I mentioned.

In 2018 we celebrated our 10th annual SQLSaturday Baton Rouge event. Several years ago, our event leveled off as far as attendees go, around 500 per year, pretty steady.

One of the reasons we are a small town with a big SQLSaturday is that we are not an insular SQL Server event. Sure, we attract tons of SQL Server sessions, and the name is SQLSaturday, but we've reached across technology lines and now, across community lines. Look, it's not like we're partnering with Oracle here, we're still very much the game in town when it comes to SQL Server and business intelligence knowledge, including helping to launch a second local PASS chapter, the BR Analytics User Group.

A few years ago, we started coming up with a theme for the event, that generally dictated little but our swag. One year a brand new STEAM magnet high school was opening near LSU campus in Baton Rouge, the fancy new campus was being constructed. We decided to have a "building careers" theme, thus the bulk order of construction helmets with SQLSaturday stickers on them.

We kept going from there, wondering how more we could get involved in the community, what could we as a gathering of hundreds of IT professionals do for a city and a state that, aside from the new high school, was dis-investing in public education, healthcare, infrastructure, especially in north Baton Rouge which is just a few miles north of campus.

So we started collecting money for the Foundation for the public school system, with the help of an organizer, we got in touch with the local Star Wars cosplayers. So yeah, we made a loose alliance with the Empire and so far we've raised a few thousand for the Foundation for the EBR School System.

We've helped to spread the word on the Futures Fund, which is an organization that provides digital arts and web design and coding training to underprivileged youth in Baton Rouge, with training from local professionals in the community. We gave opportunities to their organizer and instructors to speak at our Friday night speaker's banquet and a time slot to discuss their important mission and strategy on Saturday.

This year, with help and advice from organizers of kid's tracks in Dallas and Jacksonville, we hosted our first STEM Kid's Track. It was a logical addition to our goal of getting more involved in our community, it attracted speakers and attendees alike to make it a fun parent-child Saturday. I'm hoping to expand and look for more new ideas to get involved in the local community, especially to add opportunities for young and disadvantaged kids a learning opportunity to share with their parents.

We're hardly experts at this. One of the reasons why we partnered with STEMupBR was to have volunteers, actual professional educators, using well-prepared plans for teaching stop motion animation with Minecraft and coding with littleBits inventions. Similar to the strategies we apply every day in our jobs, we didn't reinvent the wheel here, and we were fortunate to find awesome volunteers, and we let good people do what they're good at.

We're not perfect, and we're not done at reaching out and trying to make SQLSaturday as meaningful as possible for volunteers, attendees, sponsors, and the next generation of IT professionals.

Thanks for reading, but in short, here's some ideas for your SQLSaturday:

  • Reach out to local STEM education programs and initiatives. Offer them free space to do their thing in your event, with a built-in audience of tech savvy or tech enthusiast families
  • Reach out to the local public school system to see if they have any weekend or after-school programs that could easily be adapted to a one-day event.
  • Reach out to nonprofits and STEM education initiatives in your city. Face it, as an organizer for a large and free tech event, there are folks in NGO's and outreach organizations would will listen to you and are eager to partner. Partnering with a free event like SQLSaturday could be valuable to them when it comes to their grant-writing.
  • Reach out to local tech community charitable arms and foundations, who are always on the look-out for tech-focused ways to donate time and effort. If they're anything like the Foundation at my employer, they're also not just looking for places to donate money, but opportunities to get their employees involved in STEM education.
  • Reach out to STEM and STEAM-focused schools, technology incubators, and tech entrepreneur organizations, offer them a free booth in your sponsor area in exchange for volunteers, supplies, or curriculum.
Best of luck to you and your fellow organizers as you efforts to give back to your local STEM community.



Monday, August 20, 2018

Organizer's Thoughts on our STEM Kid's Track at SQLSaturday Baton Rouge

New this year to #SQLSatBR that was really nice for us - we hosted a kid's STEM track leveraging an existing children's education organization operated by the STEMupBR program inside the Foundation for EBR School System.  This is also the same organization that we have raised money for at SQLSatBR for the past four years.

Professional educators and their Americorps VISTA volunteers and our volunteers hosted 25 kids thru robotics, stop-motion animation, and LEGOs thru the day. Some kids had a parent in tow, some had a parent enjoying the rest of SQLSaturday. In the last timeslot we had a "showcase" for the kids to show off what they had created. Parents spent the final session of our SQLSaturday with their kids, and it was far from formal and far from another boring Saturday!

It was awesome, the kids would NOT stop talking about the cool things they created. For other #SQLSat organizers, contact the local school districts to see if they have a STEM program, or contact local WIT organizations, children's museums, or coding camps to see if you could partner for an all-day kid's track.

We had speakers bring kids from out of town, we had an attendee drive in from Houston with his daughter, and volunteers/organizers register their kids too. We will grow it next year because it was an inspiring addition to our event.

Originally I wrote the above as part of my PASS Post-event Form answer for SQLSaturday Baton Rouge, then turned it into a twitter thread. But I've expanded it somewhat here, so some thoughts on this part of SQLSatBR from the organizer's point of view.

We charged a small $10 fee per child to register because:

1) We wanted to start small this year, only 20, but then increased it to 25 when we had huge demand, and so we wanted those who registered to show up.

2) to cover snacks and consumable supplies, like printed materials and creative materials the kids used in the pictures here.

We're not pioneers here, we benefited from the wisdom and experience of others.

We're not the 1st, other SQLSats have done this before, and Devin Knight from SQLSat Jacksonville gave me some valuable tips. But, not operating it myself (as the SQLSaturday organizer) - instead partnering with pro STEM educators - seemed super convenient for me and effective for the kids. Partnering with a professional STEM organization like STEMupBR also gave me, the SQLSat organizer, peace of mind.

STEMupBR handled registration, parent forms, payment, refunds/cancellations. They were smart about having parents sign photography consent forms, had appropriate snacks and supplies, and a great grasp of the gear the kids were to play with.

Organizations STEMupBR, which was started with a grant from the White House US2020 grant program in 2014, also wants to partner with larger events like SQLSaturday and other STEM-oriented community events, as opposed to trying to stand up their own independent STEM events. SQLSaturday is a perfect opportunity to further their mission with a pre-primed audience of STEM-savvy parents and kids.

So you're an organizer, what's the toughest part about organizing a STEM kid's event this?

It's the volunteer adults. Let's face it, this is challenging. Professional educators have training, tools and tactics for working with kids on this stuff that your everyday Professional DBA or Dev does not have.

It's even more challenging at high school age levels, especially if you try to teach coding. It's hard to find professionals willing to dedicate their time to teaching coding to kids - though the ones who do it are AWESOME and should be thanked at the top and bottom of every hour. And it's hard to keep kids engaged if your content is not appropriately challenging.

This is why our STEM Kid's track at SQLSaturday Baton Rouge will likely never offer age levels above the 8th grade (not high school) - because the content and teachers needed to keep that age level interested and not make it "too simple" are hard to wrangle. On the other hand, it's often that scholastic organizations require volunteer hours of high schoolers - this would be a great opportunity for them to volunteer to help teach younger kids under the supervision of STEM education professionals. We'll advise that if you have an older kid in school, send them along to volunteer with their younger sibling, for example.

Between LSU, the Visit Baton Rouge local visitor's bureau, the Louisiana Technology Park, and now the STEMupBR program from local the school district, we have really worked some good partnerships with SQLSaturday and other organizations in the Baton Rouge community.

Photographs in this blog post used with permission from STEMupBR.






Saturday, August 11, 2018

SQLSaturday Baton Rouge thank yous

Hello everyone who was at #SQLSatBR this year!

We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in the afternoon. We had 25 kids in a STEM track that featured robots, magnets, stop-motion animation, and Legos. We showed off the awesome and much-needed work of the Futures Fund in Baton Rouge, we bragged about our Tiger, and we raised $1420.05 to donate to the Foundation for the East Baton Rouge Parish School System.

Oh, and we delivered 70 hours of free training to 487 new and old friends, enjoyed delicious jambalaya, then gave away an XBox One and more cool stuff at the end-of-day raffle. We were aided by an army of volunteers, sponsors from far and wide, and representatives of the Empire.

If you're a volunteer, I thank you, you made this thing happen, you cleaned up afterwards, you carried and sweated and smiled.

If you're a speaker, I thank you, you traveled thousands of miles, you prepared for hours (including the hours immediately prior to your session), you shared your enthusiasm and experience.

If you're a sponsor, I thank you, you helped us provide a free lunch, snacks, drinks, 55 technical books, speaker supplies, printed materials and much more to our attendees.

If you're an attendee, I thank you, you asked great questions and laughed at jokes and cheered and clapped and took notes and networked.

If you're a kid, know that our industry of Information Technology needs you, regardless of your color, gender, sexuality, schooling, economic status, or creed, and that there's a whole bunch of us working to make our workplaces inclusive, efficient, and successful places for you to build your careers.

See you next year, friends.

Monday, July 16, 2018

SQLSaturday Baton Rouge at LSU on August 11

We're a little under a month away from #SQLSatBR!

We need VOLUNTEERS.
Registration is required!
We still have tables of all sizes available for sponsors!

Our 10th annual SQLSaturday features an 14-track lineup of speakers from around the country, assembled by our scheduling extraordinaire Kenny Neal. Here's the categories:
  • SQL Server Administration
  • SQL Server Beginner
  • SQL Server Development
  • .NET Dev
  • Business Intelligence
  • PowerBI
  • PowerShell
  • Windows Server/Virtualization
  • Career
  • CIO/Executive
  • Professional Development
  • and for the first time, StemUP Kid's Track (REGISTRATION and SMALL FEE REQUIRED)

Who attends SQLSaturdays?
What can SQLSaturday do for my career?

This event is entirely free for attendees (please pre-register), including a jambalaya lunch, and tons of raffle prizes to giveaway at the end of the day. Everything is paid for by our amazing sponsors.

Please pre-register if you plan on attending! Please also consider signing up to be a volunteer as well, and our expert volunteer coordinator Adrian Aucoin Jr. will put you to work, probably just by being a proctor and attending the same sessions you were going be in anyway. And we still have of sponsor tables available in the atrium to be a part of this local community-driven event.

Have questions about sponsoring? Check out our informational sponsorship PDF explaining all the benefits, costs, the day-of experience, and the process of getting involved in one of the largest and broadest SQLSaturday events in the world. Have questions? Please reach out to us via email at sqlpassbr@gmail.com.



Sunday, October 29, 2017

The #SQLSAT Speaker Goodie Bag

Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and Tamera Clark (SQLSat Nashville). It was our 9th year of SQLSat Baton Rouge, we've had polo fatigue and were looking for fresh ideas for useful, memorable speaker gifts. SQLSat Nashville's speaker goodie bags, full of day-of-conference supplies, was an inspiration.

I personally heard that at least three speakers went to the bag during SQLSatBR, specifically for the Mini DisplayPort-to-everything video adapter common to laptops. It's an annual occurrence that someone with a newer laptop is dismayed to find they've left their adapter at home, and they don't have a way to hook up to the room's VGA or HDMI cable. I've heard other speakers mention it at user groups meetings since. And just today, my wife Christine (hrtact.com) mentioned that at work she pulls it out for the various useful items.

So in advance of the SQLSat Organizers meeting at PASS Summit this week, I figured I'd list out the contents and sourcing for the goodies that made it into the bag. For some of these, you can even "subscribe and save" via amazon for a huge discount... for one month. ;)

The idea is to give a useful pack of inexpensive things in a bag that sits nicely inside of a laptop bag. The goodies are small, bulk-purchased, inexpensive things that someone would need the day of a speaking event. Links to the items, almost entirely sourced from Amazon.com, are provided only as examples.
The total cost per bag ended up being around $31, or a little more than the cost of an embroidered polo shirt. The biggest single expense (and most often used) item was the mini DisplayPort, roughly half the cost of the entire bag.



Friday, August 04, 2017

Saturday Event Planner's Calendar

We just completed our 9th annual SQLSaturday Baton Rouge. In my post-mortem of the event, I've updated and tweaked the living, breathing SQLSaturday Planner's Calendar that I've been crafting for a couple years now.

If you are a SQLSaturday organizer of any level of veterancy, you may find this calendar helpful in remembering to keep up with the months-long building to your event. If you're on some of the SQLSat Slacks you have may seen an earlier version of this doc, and already I've received a ton of good feedback. I am open to feedback on what to add/move/modify in this calendar, please reach out one or another if you have some wisdom that another SQLSat organizer or I need to hear.

Link:
https://1drv.ms/x/s!ArJKDbZJcmzGgYUkumO4G1BeOzWrSw

Let me know if you have any questions or feedback!




Monday, July 31, 2017

Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge

Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern applications. Steve and I are the principal consultants for appdev and SQL Server respectively at Sparkhound, and figured that a joint presentation on this topic would be valuable.

It was! We got a lot of great questions and positive feedback from our first audience at SQLSat Baton Rouge 2017, as well as a ton of notes to add to our presentation the next time, which will likely be at Houston Tech Fest 2017 in September.

We reviewed the SQL and .NET architecture for date/time storage an informative and thought-provoking talk about handling timezones in your application architecture. Dealing with Time Zones is disconcerting, rarely straightforward, and often complicated! In the end, our architecture recommendations lead to two likely best paths - either using datetimeoffset (and optionally also storing the Time Zone information in a separate field) or storing the date and time in separate fields. (But preferably datetimeoffset.) There are few advantages and major disadvantages to storing only UTC data or all-in-one time zone data.

You can download the slidedeck and sample code here.

Fun videos:
https://www.youtube.com/watch?v=k4EUTMPuvHo


Our presentation at SQLSatBR 2017

Wednesday, July 19, 2017

SQLSaturday Baton Rouge at LSU on July 29


The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th annual SQLSaturday features an 11-track lineup of speakers from around the country, assembled by our scheduling extraordinaire Kenny Neal.

The schedule includes a whole track of PowerBI experts, a panel on Careers in IT, an entire track on Big Data/Analytics, tracks for .NET, mobile, and web developers an entire track for Business Intelligence, and so much more. Oh, and of course top-notch SQL DBA and SQL Development tracks from big names in the SQL industry!

Who attends SQLSaturdays, you say? I'm glad you asked...

This event is entirely free for attendees, including a jambalaya lunch, and tons of raffle prizes to giveaway at the end of the day. Everything is paid for by our amazing sponsors.





Please pre-register if you plan on attending! Please also consider signing up to be a volunteer as well, and our expert volunteer coordinator Adrian Aucoin will put you to work, probably just by being a proctor and attending the same sessions you were going be in anyway. And we still have of sponsor tables available in the atrium to be a part of this local community-driven event.

Have questions about sponsoring? Check out our informational sponsorship PDF explaining all the benefits, costs, the day-of experience, and the process of getting involved in one of the largest and broadest SQLSaturday events in the world. Have questions? Please reach out to us via email at sqlpassbr@gmail.com. The sponsor registration and payment deadline is July 15.

Thumbs up if I'll see you there!


Friday, June 23, 2017

A Big July Planned in Baton Rouge

Three big events planned in Baton Rouge this year that everyone can be a part of:

User Groups Networking Night at the Louisiana Technology Park on July 12

Attendees from all Baton Rouge User Groups (SQL Server, .NET, Power BI, IT Pro, SharePoint, and Women in Technology, students, and the public) are invited to this free event!

Our annual Networking Night features short-format entertaining presentations on career topics, technical or nontechnical. In 2014 and 2015 and 2016, 80+ IT professionals and students, including many newcomers, attended this fun event! It's all at the Louisiana Technology Park on July 12.


Be part of this free event by attending, enjoy a free dinner, and all the professional networking you can handle. Even better, be a part of the event by giving a 7-10 minute talk on career soft-skills, professional guidance, etc. WE NEED SPEAKERS!

Examples of entertaining short-format speech topics and a signup form here. Best of all, be a part of Networking Night with an official sponsor presence if you are a Gold or Platinum sponsor of SQLSaturday Baton Rouge (more on that later).

PowerBI PreCon at the Louisiana Technology Park on July 28


The day before SQLSaturday Baton Rouge, join us on Friday all day in the TechParkU room of the Louisiana Technology Park. The only precon for SQLSat Baton Rouge this year features an ALL DAY Deep Dive into PowerBI with Microsoft employees Adam Saxton (Guy in a Cube on Youtube) and Baton Rouge SQL UG founder Patrick Leblanc!


Bring your laptop, grab a cup of coffee, and get ready to learn! Registration fee is $120 for the all-day event and includes lunch! Register Today for the Pre-Con on Friday, July 28!


SQLSaturday Baton Rouge at LSU on July 29


And of course, the big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th annual SQLSaturday features an 11-track lineup of speakers from around the country, assembled by our scheduling extraordinaire Kenny Neal.

The schedule includes a whole track of PowerBI experts, a panel on Careers in IT, an entire track on Big Data/Analytics, tracks for .NET, mobile, and web developers an entire track for Business Intelligence, and so much more.  Oh, and of course top-notch SQL DBA and SQL Development tracks from big names in the SQL industry!

Who attends SQLSaturdays, you say? I'm glad you asked...

This event is entirely free for attendees, including a jambalaya lunch, and tons of raffle prizes to giveaway at the end of the day. Everything is paid for by our amazing sponsors.


Please pre-register if you plan on attending! Please also consider signing up to be a volunteer as well, and our expert volunteer coordinator Adrian Aucoin will put you to work, probably just by being a proctor and attending the same sessions you were going be in anyway. And we still have of sponsor tables available in the atrium to be a part of this local community-driven event.

Have questions about sponsoring? Check out our informational sponsorship PDF explaining all the benefits, costs, the day-of experience, and the process of getting involved in one of the largest and broadest SQLSaturday events in the world. Have questions? Please reach out to us via email at sqlpassbr@gmail.com. The sponsor registration and payment deadline is July 15.

Thumbs up if I'll see you there!




Wednesday, June 21, 2017

Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016

In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment (ROI) for sponsoring local SQLSaturday events. Part of my argument in favor of sponsoring SQLSaturday events are the diversity of attendees and their responsibilities, and particularly, the presence of decision makers.

Attracting the Decision Makers and Influencers


At a large-tent event like SQLSaturday Baton Rouge where we have tracks for IT management, server admins, and .NET developers, the cross section of responsibilities in the registrants skews heavily towards developers and especially decision makers, as evidenced in the below graph:


I believe the percentage of attendees in a decision-making capacity in their workplace is understated at SQLSaturday events, broadly. This is a fact that should be emphasized by SQLSaturday organizers and promoters to potential sponsors.


At SQLSaturday Baton Rouge we have sought out speakers for "IT Management" and "CIO" tracks over the past few years. The speakers remain the type of experienced, highly motivated volunteer professionals that speak in technical tracks. Topics include SQL Server disaster recovery and high availability, the value of business intelligence dashboards, and cloud adoption strategy. The typical "career" track with soft-skills sessions can include giving feedback to employees, or how to best conduct interviews, and how to be more inclusive of women and under-represented demographics. The value of having "something for the boss" at a SQLSaturday translates directly to sponsor ROI.

What about small SQLSaturday events?


To sponsors, the size of the event is a factor, but it shouldn't be the only one. Significant ROI can be returned merely by a sponsor's presence at a local event, showing support for the local IT community. Whether the sponsor is looking to recruit, drive sales, or increase market recognition, the size of a SQLSaturday event doesn't necessary translate to higher ROI.

In fact, smaller SQLSaturdays may provide a bigger share of the spotlight, a more recognized local contribution, and more face time with local IT connections. There are SQLSaturday events held locally around the world almost every weekend of the year - meaning that at least one a year, almost any company has a local, authentic, home-grown opportunity nearby.

Job Title Categorization


If you're curious for how the job titles were categorized, I've included the relatively simple TSQL categorization logic below:
...  set JobTitleCategory = CASE
      
      WHEN [job title] like 'C%' and len([job title]) = 3 
       OR [job title] like '%Chief%'   
       OR [job title] like '%Director%' 
       OR [job title] like '%President%'   
       OR [job title] like '%Officer%' 
       OR [job title] like '%Owner%' 
       OR [job title] like '%CIO%' 
       OR [job title] like 'VP%'
       OR [job title] like '%Partner'
       OR [job title] like 'Founder'
       OR [job title] like 'Attorney%'
       THEN 'C-Suite'

      WHEN [job title] like '%Manager%' 
       OR [job title] like '%Senior%Associate%'
       OR [job title] like 'Head%'
       OR [job title] like '%manger%'
       OR [job title] like 'HR%'
       OR [job title] like '%supervis%'
       OR [job title] like '%coordin%'
       OR [job title] like '%Advisor%'
       OR [job title] like '%Legal%'
       OR [job title] like 'Managing%'
       OR [job title] like 'team lead'
       OR [job title] like 'Process Optimization%'
       OR [job title] like '%Mgr%'
      THEN 'Management'

      
      WHEN [job title] like '%dba%' 
       OR [job title] like 'data%admin%' 
       OR [job title] like '%data%base%' 
       OR [job title] like '%ETL%'
       OR [job title] like '%SQL%'
       OR [job title] like '%PASS%'
       OR [job title] like '%Chapter Leader%'
       OR [job title] like '%DB Admin%'
       THEN 'DBA'
       
      WHEN [job title] like '%BI %' 
       OR [job title] like '%Business Intelligence%' 
       OR [job title] like 'Data%Scien%'
       OR [job title] like '%analytic%'
       OR [job title] like 'Math%'
       OR [job title] like '%data%Architect%' 
       OR [job title] like '%report%' 
       OR [job title] like '%warehouse%' 
       OR [job title] like '%data%specialist%' 
       OR [job title] like '%data%analyst%' 
       OR [job title] like '%Informatics%'
       OR [job title] like '%Information%'
       THEN 'Business Intelligence'

      WHEN [job title] like '%Studen%' 
       OR [job title] like '%grad%'
       OR [job title] like '%Candidate%'
       OR [job title] like '%Intern'
       THEN 'Student'

      WHEN [job title] like '%Accounting%'
       OR [job title] like '%CPA%'
       OR [job title] like '%AP %' 
       THEN 'Accounting'

      WHEN [job title] like '%design%' 
       THEN 'Design'

      WHEN [job title] like '%access control%' 
       OR [job title] like '%security%' 
       OR [job title] like '%sec%' 
       THEN 'Security'
       
      WHEN [job title] like '%Instructor%'
       OR [job title] like '%Teacher%'
       OR [job title] like '%faculty%'
       OR [job title] like 'Research%'
       OR [job title] like 'Editor'
       OR [job title] like 'Librar%'
       OR [job title] like '%school%'
       OR [job title] like '%education%'
       OR [job title] like '%science%'
       OR [job title] like '%instruct%'
       OR [job title] like 'Fellow'
       THEN 'Academia'

      WHEN [job title] like '%programmer%'  
        OR [job title] like '%software%developer%' 
        OR [job title] like '%Software%Engineer%'
        OR [job title] like 'App%Dev%'
        OR [job title] like 'Dev%'
        OR [job title] like 'Comp%Scien%'
        OR [job title] like 'App%Dev%'
        OR [job title] like '%developer%' 
        OR [job title] like 'Tech%Lead'
        OR [job title] like '%application%'
        OR [job title] = 'P/A'
        OR [job title] like 'Program%'
        OR [job title] like '%Architect%' 
        OR [job title] like '%software%' 
        OR [job title] like 'Code%' 
        OR [job title] like 'Analyst%' 
        OR [job title] like 'pgmr%' 
        OR [job title] like 'E-%' 
        THEN 'Developer'

      WHEN [job title] like '%System%Ana%' 
       OR [job title] like '%Comp%Ana%'
       OR [job title] like '%Sys%eng%' 
       OR [job title] like '%Sys%admin%'
       OR [job title] like '%Net%Admin%'
       OR [job title] like '%IT%Tech%'
       OR [job title] like 'IT%specialist%'
       OR [job title] like 'tech%specialist%'
       OR [job title] like '%Engineer'
       OR [job title] like 'MCT%'
       OR [job title] like 'Implement%Spec%'
       OR [job title] like '%technic%'
       OR [job title] like '%Administrator'
       OR [job title] like '%Network%'
       OR [job title] like '%integration%'
       OR [job title] like '%repair%'
       OR [job title] like 'helpdesk%'
       OR [job title] like  'IT%Pro%'
       THEN 'Server Admin'

      WHEN [job title] like 'Customer Support Specialist'
       OR [job title] like 'Tech%Support%'
       OR [job title] like 'Dispute Resolution%'
       OR [job title] like 'Specialist'
       OR [job title] like '%IT%Supp%'
       OR [job title] like '%IT %'
       OR [job title] like '%Support%'
       OR [job title] like 'field%service%'
       OR [job title] like 'desktop%'
       OR [job title] like 'service desk%'
        THEN 'Customer Support'

      
      WHEN [job title] like '%QA%'
       OR [job title] like '%Quality%' 
       OR [job title] like '%test%' 
       THEN 'QA/Testing'

       
      WHEN [job title] like '%SharePoint%'
       THEN 'SharePoint'

     WHEN [job title] like 'Acc%Exec%' 
      OR  [job title] like '%Sales%'
      OR  [job title] like '%Account rep%'
      OR  [job title] like 'Business%Dev%'
       THEN 'Sales'

      WHEN [job title] like  '%Recruiter%'
       THEN 'Recruitment'

      WHEN [job title] like  '%Admin%Assistant%'
       OR [job title] like  '%Assistant'
       THEN 'Administrative Assistant'

      WHEN [job title] like '%Admin%'
       OR [job title] like '%systems%'
       OR [job title] like '%engineer%'
       OR [job title] like '%technolo%'
       OR [job title] like '%operat%'
       OR [job title] like '%IT%'
       OR [job title] like '%server%'
       OR [job title] like '%system%'
       THEN 'Server Admin'

      WHEN [job title] like '%Business%Analyst%'
       OR [job title] like '%Analyst%'
       OR [job title] like '%Auditor%'
       OR [job title] like 'BSA%'
       OR [job title] like '%process%'
       OR [job title] like '%product%'
       OR [job title] like 'BA'
       THEN 'Business Analyst'

      WHEN [job title] like 'Self%Employ%'
       THEN 'Self Employed'
      
      WHEN [job title] like 'Social Worker'
       OR [job title] like '%nurse%'
       OR [job title] like '%dental%'
       OR [job title] like '%health%'
       OR [job title] like '%clinic%'
       OR [job title] like '%medical%'
       OR [job title] like '%nutrition%'
       THEN 'Medical'
      
      WHEN [job title] like '%legal%'
       THEN 'Legal'
      
      WHEN [job title] like '%Project%' 
       OR [job title] like '%PM%' 
       THEN 'Project Management'
        
      WHEN [job title] is null 
       OR [job title] = '' 
       OR [job title] = 'Mr' 
       OR [job title] = 'NA' 
       OR [job title] = 'n' 
       OR [job title] = 'n/a'
       OR [job title] = 'not provided'
       THEN 'Not provided'
      
      WHEN [job title] like '%Consultant%'
       OR [job title] like 'Principal%' 
       THEN 'Consultant'

      ELSE 'Other'

      END

Monday, April 10, 2017

Why SQLSaturday? A SQLSat Career Case Study

We all know that SQLSaturday events are good for career networking, professional development, and technical education. Sometimes the perfect story presents itself as a real testimonial.

When fellow Baton Rouge SQL Saturday organizer Adrian Aucoin Jr. and I heard about John Wells' (@SQLServerDBA318) story of making a career spark happen in the vendor expo area of our annual event, I couldn't help but think that we had to capture this as a SQLSaturday case study

The idea that people find jobs, recruits, future colleagues, and clients at SQLSaturdays is widely accepted, but it's always nice to read about a real life one in your own town.
Since Baton Rouge in August of 2016, you might have seen John recently at SQLSaturdays in Huntington BeachBirminghamDallasNashvilleOklahoma Cityand San Antonio. I'll turn it over to John, then we'll do a Q&A with this prolific SQLSat fan:


John Wells, DBA and SQLSat connoisseur  
SQLSaturday is a great day of training and networking that I participate in as much as possible. I was sold after my first experience in Dallas May 2015. Quickly realizing how powerful this event was I made it a point to go to as many as possible moving forward. It’s quite an experience as you not only have great sessions of free training, but even more powerful is the networking involved. Most events have precon sessions for a small fee the Friday before that I have attended and are well worth it. 
The vendors and speakers make this event happen so I always go out of my way to thank them during breaks and after sessions. In my short DBA career, I have made several new friends and connections because of SQLSaturday. This has made me a big advocate and I try to attend 10 SQL Saturday’s a year. The SQL Server family along with PASS is not like any other organization out of there and I’m happy I found them. 
I can go on for quite some time about this, however, my SQLSaturday success story came out of Baton Rouge in 2016. I mean how can you go wrong with great training sessions, networking and Jambalaya all in the same day? I was excited when it came time for another SQLSaturday and this time close to home. I made the short trip down to Baton Rouge from Bossier City and was a volunteer for this event. 
It was another great SQLSaturday and I went around at lunch time thanking all the vendors as I always do. I approached the vendor booth for a large tech recruiter and began to speak to one of the representatives. I told the lady that I was a younger DBA and was curious about the positions around the Baton Rouge area. It wasn’t that I was looking for a new job because I wasn’t, but I was really just curious. She asked me a few questions and gave me her card asking for a resume, which I sent her when I got back home that night. 
Two days after I sent my resume I was contacted by another representative from the tech recruiter. She told me about two positions that they had been trying to fill for months and sent me the job descriptions. There was one in Baton Rouge that caught my attention, they were really looking for someone with more experience, but were not having any luck and were open to someone with not as much experience depending on their knowledge. 
The interview came a few days later and before I knew it I was heading down to Baton Rouge for a new adventure. 
I am now a DBA at a national, publicly-traded ad agency and love it here in Baton Rouge. Everything is going great and I have recently begun attending the Baton Rouge SQL Server User Group meetings. I continue to go to SQLSaturday’s and one day will speak myself at these events. Again, I can go on and on about PASS, SQLSaturday and the SQL Server family, but my success story will always be SQLSaturday #515 Baton Rouge.



Not only did John drive 250+ miles from Bossier City, Louisiana to Baton Rouge, get free SQL training, and find a job - he also volunteered!

John Wells (arrow) in his volunteer vest at SQLSaturday Baton Rouge 2016
I know one way in which John's story isn't unique: I owe a good bit of my own career trajectory to business and connections made through the Baton Rouge SQL Server User Group and the SQLSaturday it hosts. As an organizer of SQLSaturday Baton Rouge, I took the opportunity to ask John a few questions about his experiences at SQLSaturdays in general.

Q: Everybody's different, but what is it about SQLSaturdays that makes them worth giving up a Saturday and some travel time?

John: It's not just the Saturday - its the entire experience of SQLSaturday including pre-cons, great sessions and networking with similar minded individuals who share the same passion. I also look for the sessions and speakers as well. When I see certain speakers that are highly regarded in this industry that alone makes it worth my time to travel to an event to see their session.  I have driven as far as Atlanta just because of the session line up.  
SQLSaturday is a great tool to invest in yourself and I have also made some friends along the way.


Q: Is there a science to how you pick sessions to attend?
There definitely is and it breaks out into two pieces. First, am I familiar with the speaker and are they a well known name in the industry? I don't have to know who the speaker is, but someone like Kevin Kline or Grant Fritchey would be someone I would want to see speak regardless of the session content. A perfect example was last year in Oklahoma City where Bob Ward did two sessions so I went to both. 
Second, what is the session focused on? Anything to do with performance tuning, HA/DR and PowerShell are at the top of my list. However, there are still many other subjects I favor and also is it something that could immediately help me at work. I'm also lucky because I go to so many events that sometimes I will skip a session I want to see because I can see it the following month at another location.


Q: What should vendors know about maximizing their visibility and impact to potential job seekers?
I think it is how aggressive they are when they talk to attendees. Whether they are a recruiter or software vendor the way they interact with attendees sticks out. The ones that seem to be aggressive and happy to speak with me get my attention every time.


Q: Any plans on developing a technical talk yourself? We'd be happy to give you a trial audience at the Baton Rouge SQL Server User Group.
Absolutely! I have one in mind and hope to do it in the next few months. My overall goal is to be a speaker at SQL Saturday and I have 2019 in mind.


Q: We'll look for you then, John!  You're quite the a connoisseur of SQLSaturday events all over the Southern United States. Who's got the best food? 
No bias here since I'm not originally from Louisiana, but Baton Rouge owns that one. I mean SQLSaturday and jambalaya can't be beat.


Q: Give me more best-of from your SQLSat travels: most memorable session, vendor booth, end-of-day raffle?
There are so many great sessions I have attended in the past two years I can go on for awhile. One session, Branding Yourself, by Steve Jones was one. I walked away with some great ideas and have used them to my advantage. There was a pre-con, Performance Tuning for Mere Mortals, this past January in Nashville by Mike Lawell and Ed Watson. There were some major light bulb moments in that one. 
I have always enjoyed talking to the folks at Pure Storage and was able to thank Argenis Fernandez personally for answering a question two weeks earlier on #sqlhelp at Nashville SQL Saturday. 
I think all the end of day raffles are good, but Baton Rouge wins for entertainment.

Thanks again to John Wells (@SQLServerDBA318) for sharing, and congratulation on your recent career jump. Looking forward to seeing you on the SQLSat circuit!

Saturday, July 16, 2016

SQLSaturday Baton Rouge 2016!

Free SQL Server, SharePoint and .NET training

SQLSaturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQLSaturday event is sponsored by the Baton Rouge SQL Server and .NET User Groups, and will be our annual event on campus at LSU. We expect 600+ regional IT professionals and national speakers to join us. This free conference is open to the public and is perfect for students, CIO's, database administrators, developers, IT managers, server admins and job-seekers. 


Then...



What: 
An all day FREE training event with SQL Server, Development and SharePoint related sessions spread out over multiple tracks of Business Intelligence, Database Administration, SQL Development, SharePoint, IT Pro and .NET development. 

Who Attends SQLSaturday? 
Folks with the following skillsets are drawn to SQL Saturday Baton Rouge because of the professional networking, free training, and giveaways:
  • SQL Server Administrators
  • Business Intelligence Developers
  • Data Analysts
  • ETL Developers
  • C#/VB.NET Developers
  • Mobile Developers
  • Windows Server Admins
  • SharePoint Architects
  • SharePoint Developers
  • Network Administrators
  • Quality Assurance Analysts
  • IT Managers
  • Students
  • Project Managers
  • Hiring Managers
  • Jobseekers of all levels of experience
  • Students
  • CIO's
  • CEO's

At the end of 2015, we polled our user group membership and got this amazing feedback on SQLSaturday Baton Rouge #423 in August of 2015:

"As a former speaker and attendee at Sql Saturday, I must say you guys knock the ball out of the park with SQL Saturday. You guys put on a top notch event for both presenters and attendees."
"SQL Saturday is always top-notch!"
"SQL Saturday is always on point. Love this event and always promote it to other groups."
"I am happy that the talks are open to more topics than just .Net and MSSQL"


When:
Saturday, August 6, 2016. Online registration is now open, but it is filling up fast so reserve your spot now. Attendee check-in will begin at 8:00 AM first sessions beginning at 9:15 AM. A full list of session tracks and schedule is available.

Monday, July 11, 2016

[UPDATED] Training To-Do List for New DBA

Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the bottom of a very tall ladder? Don't have much of a budget for training?

Here's a list of resources I'd recommend [updated in July 2023], in no particular order. Each of these are action-oriented tasks that I would (and have) assigned to a new-to-the-job junior DBA on my team.

Got additions and suggestions? Please add them to the comments in this blog post.

UPDATE: 9/30/2019 - new bit to replace MVA, add PASStv
UPDATE: 7/30/2023 - refreshed sources and links