{"id":105010,"date":"2024-12-31T07:28:02","date_gmt":"2024-12-31T07:28:02","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=105010"},"modified":"2025-01-02T20:06:17","modified_gmt":"2025-01-02T20:06:17","slug":"simple-talk-2024-year-in-review","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/opinion\/editorials\/simple-talk-2024-year-in-review\/","title":{"rendered":"Simple Talk 2024 Year in Review"},"content":{"rendered":"\n<p><em>Edit: Added pictures to the PASS section of the Redgate Hub<\/em><\/p>\n\n\n\n<p>Happy New Year to all of the Simple talk readers! What a year this has been. I just read a list of the things we did last year for an internal report, and I wanted to share some of the pertinent stats.<\/p>\n\n\n\n<p>This year we went through a project we called \u201cSimple Talk 2.0\u201d, and the goal was to evolve Simple Talk into something a bit more than a journal of articles. Not that articles went away, or have any chance of going away, but the first step of the project was to build the foundation for all the new types of content we have on the way.<\/p>\n\n\n\n<p>It has been a wild year for me, and a really great one. So here are those highlights I promised!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-website\">The Website<\/h2>\n\n\n\n<p>The <a href=\"https:\/\/www.simple-talk.com\">Simple Talk<\/a> site got a complete renovation that was deployed in July, and it has been quite the transformation from a site that was basically just a text listing of articles, to one with some more color, and a lot mor content types.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1181\" height=\"814\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/word-image-105010-1.png\" alt=\"\" class=\"wp-image-105011\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Of courses, articles are still the focus of the site, and we have published over 210 articles this year on various topics, including:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>30 on SQL Server<\/li>\n\n\n\n<li>13 on PostgreSQL<\/li>\n\n\n\n<li>11 on MySQL<\/li>\n\n\n\n<li>11 on MongoDB<\/li>\n\n\n\n<li>1 on <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/\">Oracle<\/a><\/li>\n<\/ul>\n<\/div>\n\n\n<p><em>Of note is that the one article on Oracle is the first of many to come from the newest <\/em><a href=\"https:\/\/www.red-gate.com\"><em>Redgate<\/em><\/a><em> advocate <\/em><a href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/kellyn-potvin\/\"><em>Kellyn Pot\u2019Vin-Gorman<\/em><\/a><em>! <\/em><\/p>\n\n\n\n<p>These are currently our primary areas of focus, but as you can see, they don\u2019t even make up \u00bd of our content. We cover many different topics on Simple Talk, and while I am looking forward to bolstering our output of <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/\">database topics<\/a>, we cover a lot of different computing topics.<\/p>\n\n\n\n<p>One of my favorite changes of the year? Dark mode for articles. My eyesight is not the best, and dark mode makes it a lot easier to see and read.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1152\" height=\"697\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-screenshot-of-a-computer-description-automatica-23.png\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" class=\"wp-image-105012\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>There have been a lot of small changes you can and cannot see, and there have been a ton of down payments on stuff that will be enabled very soon!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conferences-and-sponsorships\">Conferences and Sponsorships<\/h2>\n\n\n\n<p>One thing we started this year was sponsoring conferences are Simple Talk. In total we were involved in 14 different events, some sponsored directly as Simple Talk, some co-sponsored with Redgate\u2019s event team, and a few where I just went and spoke.<\/p>\n\n\n\n<p>Even though it didn\u2019t get off to a great start since I missed the first 4 months of the year down with an injury, I spent a lot more time this year traveling all over the US from Seattle to Orlando and New York City, on planes, trains, and of course my preferred mode of transportation&#8230; automobiles.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"718\" height=\"412\" data-id=\"105014\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-blue-and-yellow-airplane-on-a-runway-descriptio.png\" alt=\"A blue and yellow airplane on a runway Description automatically generated\" class=\"wp-image-105014\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"4032\" height=\"2268\" data-id=\"105039\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/IMG_7507.jpeg\" alt=\"\" class=\"wp-image-105039\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1342\" height=\"575\" data-id=\"105013\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-silver-car-parked-on-the-side-of-a-road-descrip.png\" alt=\"A silver car parked on the side of a road Description automatically generated\" class=\"wp-image-105013\"\/><\/figure>\n<\/figure>\n\n\n\n<p>We sponsored several SQL Saturday events and a Data Saturday event, including <a href=\"https:\/\/sqlsaturday.com\/2024-04-27-sqlsaturday1077\/\">SQL Saturday Haiti<\/a> and <a href=\"https:\/\/sqlsaturday.com\/2024-10-19-sqlsaturday1093\/\">SQL Saturday Toronto<\/a> that were new to me, though I didn\u2019t attend either of them. Haiti was virtual (and mostly in a different language\u2026 pretty sure it was French!). Toronto didn\u2019t fit in my schedule as I was going to <a href=\"https:\/\/sqlsaturday.com\/2024-10-19-sqlsaturday1089\/\">SQL Saturday Orlando<\/a> the prior week, That turned out to be a blessing as Orlando had to move to the same day as Toronto due to <a href=\"https:\/\/www.orlando.gov\/News\/Press-Releases\/2024-Press-Releases\/City-of-Orlando-Hurricane-Milton-Update-2\">Hurricane Milton<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"951\" height=\"662\" data-id=\"105016\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-person-sitting-at-a-table-with-a-red-cloth-desc.png\" alt=\"A person sitting at a table with a red cloth Description automatically generated\" class=\"wp-image-105016\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"572\" data-id=\"105015\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-group-of-people-standing-around-a-table-descrip.png\" alt=\"A group of people standing around a table Description automatically generated\" class=\"wp-image-105015\"\/><\/figure>\n<\/figure>\n\n\n\n<p>One of the things we were supposed to do was do more than just sponsor SQL Server events, so we also did <a href=\"https:\/\/2024.pgdaychicago.org\/\">PGDay Chicago<\/a>, <a href=\"https:\/\/thatconference.com\/wi\/2024\/\">THAT Conference Wisconsin<\/a> (with Redgate), and <a href=\"https:\/\/sceniccitysummit.com\/\">Scenic City Summit<\/a>. I also attended <a href=\"https:\/\/2024.pgconf.nyc\/\">PGConf NYC<\/a>, which was already sponsor by Redgate.<\/p>\n\n\n\n<p>Overall, it was a lot of fun, a lot of work, but I saw familiar faces and met new people as well. It was my first experience sponsoring conferences, but while it didn\u2019t always happen smoothly, I learned a lot and Redgate was able to help out a few more conferences! Win-win!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-podcast\">Podcast<\/h2>\n\n\n\n<p>One of the things I had wanted to do since I started at Redgate was to do a podcast. I have recorded one for theme park content on and off for years, and the goal was kind of the same. This July, we finally got it off the ground! We have video and audio available for every episode, which you can find here: <a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/\">https:\/\/www.red-gate.com\/simple-talk\/podcasts\/<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1129\" height=\"449\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-screenshot-of-a-video-chat-description-automati.png\" alt=\"A screenshot of a video chat\n\nDescription automatically generated\" class=\"wp-image-105017\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>We are on Spotify, Apple Podcasts, Libsyn, and the Redgate YouTube channel as well.<\/p>\n\n\n\n<p>For 2024, we did 13 episodes, with my entries being to interview someone in the community for a \u201cCoffee Chat\u201d, and the Advocates doing a show discussing something technical. On the 19<sup>th<\/sup> of December, we dropped the final episode of the year where we discussed AI and other things that we felt defined 2024.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-pass-summit\">PASS Summit<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"867\" height=\"374\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-group-of-people-in-a-room-description-automatic.png\" alt=\"A group of people in a room\n\nDescription automatically generated\" class=\"wp-image-105018\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The final thing I want to call out is our experiences at the PASS Summit. This was, to me, the most interesting thing we did for the year. There were 4 activities that we did at the PASS Summit I want to highlight:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"818\" height=\"407\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-building-with-glass-walls-and-a-sign-descriptio.png\" alt=\"A building with glass walls and a sign\n\nDescription automatically generated\" class=\"wp-image-105019\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-sessions\">Sessions<\/h3>\n\n\n\n<p>We had 5 sessions that were considered \u201cSimple Talks.\u201d My goal was to have 2 kinds of content. Deep dive sessions, and content on writing. For the technical sessions, there were 2 sessions that were 400 level (by <a href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/fabiano-amorim\/\">Fabiano Amorim<\/a> and <a href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/ben-johnston\/\">Ben Johnston<\/a>) , that were added from sessions not chosen and 1 that was adapted from something the speaker didn\u2019t submit for the Summit (<a href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/jason-romans\/\">Jason Romans<\/a>).<\/p>\n\n\n\n<p>Then there were 2 sessions on writing, one about using AI (with myself, <a href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/tony-davis\/\">Tony Davis<\/a> and <a href=\"https:\/\/www.red-gate.com\/blog\/author\/tonie-huizer\">Tonie Hauzer<\/a>) and another giving a burst of writing tips.<\/p>\n\n\n\n<p>All were done by Simple Talk authors and reviews were all quite nice! Attendance was great for the technical sessions, and okay for the writing sessions.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-3 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1090\" height=\"620\" data-id=\"105020\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-person-giving-a-presentation-to-a-group-of-peopl.png\" alt=\"A person giving a presentation to a group of people Description automatically generated\" class=\"wp-image-105020\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1187\" height=\"571\" data-id=\"105021\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-group-of-people-sitting-in-front-of-a-black-curt.png\" alt=\"A group of people sitting in front of a black curtain Description automatically generated\" class=\"wp-image-105021\"\/><\/figure>\n<\/figure>\n\n\n\n<p>We knew the writing sessions would be lightly attended (because there are so many great technical presentations), but these sessions are timeless and will hopefully be watched by people streaming, and then hopefully in years to come.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-breakfast\">Breakfast<\/h3>\n\n\n\n<p>On the last day of the conference, Simple Talk sponsored a breakfast. The food was excellent, the company even better.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"824\" height=\"705\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-row-of-food-containers-description-automaticall.png\" alt=\"A row of food containers\n\nDescription automatically generated\" class=\"wp-image-105022\" style=\"width:466px;height:auto\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>We had many of the authors and Redgaters who are involved with Simple Talk there and the conversation was excellent.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1166\" height=\"327\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-group-of-people-sitting-at-tables-description-a.png\" alt=\"A group of people sitting at tables\n\nDescription automatically generated\" class=\"wp-image-105023\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-podcast-recording\">Podcast Recording<\/h3>\n\n\n\n<p>One of the interesting things we did was to record quite a bit of podcast content. I recorded an episode with <a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/coffee-chat-with-mala-mahadevan\/\">Mala Mahadevan<\/a> and the Advocates recorded three episodes, including one that has dropped about <a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/how-is-oracle-different-from-other-data-platforms\/\">Oracle<\/a>, plus two others.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"644\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-group-of-people-walking-in-a-hallway-descriptio.png\" alt=\"A group of people walking in a hallway\n\nDescription automatically generated\" class=\"wp-image-105024\" style=\"width:583px;height:auto\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>This image was captured by Emma Taylor who Director of Communications at Redgate and they did not know they were being photographed. Kellyn doctored it up some, and we think somehow this year we need to cut an album with these four with this as the album cover.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"791\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/word-image-105010-15.png\" alt=\"\" class=\"wp-image-105025\" style=\"width:584px;height:auto\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-redgate-hub\">Redgate Hub<\/h3>\n\n\n\n<p>New this year, Redgate split their booth up into different experiences. There was the primary booth, where they were demoing products, and the Redgate Hub experience.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-4 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"4032\" height=\"3024\" data-id=\"105037\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/IMG_2117.jpg\" alt=\"\" class=\"wp-image-105037\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"4032\" height=\"3024\" data-id=\"105036\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/IMG_2143.jpg\" alt=\"\" class=\"wp-image-105036\"\/><\/figure>\n<\/figure>\n\n\n\n<p>\u00a0<\/p>\n\n\n\n<p>The hub was there to be a kind of non-sales area. Simple Talk was a big part of it, but all of our learning resources were as well. The area was just a great feeling, one from a large conference standpoint, with a couple of really comfy chairs and a lot of swag to go around.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"4032\" height=\"3024\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/IMG_2104.jpg\" alt=\"\" class=\"wp-image-105038\" style=\"width:422px;height:auto\"\/><\/figure>\n\n\n\n<p><em>Weirdly, this is one area of the conference where I got no really good picture. I mostly took video for my <\/em><a href=\"https:\/\/www.instagram.com\/drsql\/\"><em>@drsql Instagram account<\/em><\/a><em>, where I tended to story my SQL adventures. Not any real content up there now other than a video I took of the new PASS building. So these pictures were given to me by Alison Leightley, who was at the hub area a <strong>lot<\/strong> more than I was!<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-speaking-of-pictures\">Speaking of pictures!<\/h2>\n\n\n\n<p>Standing beside Bob Ward and Conor Cunningham after their part in the Microsoft Keynote was awesome. I have looked up to these two for so many years. I first met Bob (and maybe Conor\u2026not totally sure where I met him first) in Dallas over 20 years ago when we had an MVP Summit there.<\/p>\n\n\n\n<p>He was showing us how to use the compiler to debug SQL Server and I was enthralled. I had no idea how to reproduce what he was doing of course (I understand how to code in T-SQL, and that is about it!). This was exciting stuff.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1138\" height=\"631\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/12\/a-group-of-men-standing-in-front-of-a-large-screen.png\" alt=\"A group of men standing in front of a large screen\n\nDescription automatically generated\" class=\"wp-image-105026\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-about-next-year\">What about next year?<\/h2>\n\n\n\n<p>We are busy planning next year, but hopefully it will be more of the same, and maybe a few new things too. Hopefully I will be able to share more about 2025 soon.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Edit: Added pictures to the PASS section of the Redgate Hub Happy New Year to all of the Simple talk readers! What a year this has been. I just read a list of the things we did last year for an internal report, and I wanted to share some of the pertinent stats. This year&#8230;&hellip;<\/p>\n","protected":false},"author":56085,"featured_media":105027,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[6,47125],"tags":[],"coauthors":[19684],"class_list":["post-105010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-core-site-pages","category-editorials"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/105010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/56085"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=105010"}],"version-history":[{"count":5,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/105010\/revisions"}],"predecessor-version":[{"id":105040,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/105010\/revisions\/105040"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/105027"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=105010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=105010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=105010"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=105010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}