{"id":103669,"date":"2024-08-29T16:09:59","date_gmt":"2024-08-29T16:09:59","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=podcast&#038;p=103669"},"modified":"2025-01-23T16:23:20","modified_gmt":"2025-01-23T16:23:20","slug":"episode-5-sql-server-and-postgres","status":"publish","type":"podcast","link":"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/episode-5-sql-server-and-postgres\/","title":{"rendered":"SQL Server and Postgres"},"content":{"rendered":"\n<div class=\"mb-2xl\">\n            <button data-youtube-url=\"https:\/\/www.youtube.com\/embed\/aofJ0rX2iUY?si=scKAHMGahzwUNGku\" id=\"podcastModalButton\" class=\"relative aspect-[16\/9] bg-gray-900 flex items-center justify-center flex-col gap-md w-full p-md\">\n                            <img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/08\/EP5-SQL-Server-and-Postgres-Card-1024x576.jpg\" class=\"object-cover absolute inset-0 w-full h-full wp-post-image\" alt=\"\" srcset=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/08\/EP5-SQL-Server-and-Postgres-Card-1024x576.jpg 1024w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/08\/EP5-SQL-Server-and-Postgres-Card-300x169.jpg 300w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/08\/EP5-SQL-Server-and-Postgres-Card-768x432.jpg 768w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/08\/EP5-SQL-Server-and-Postgres-Card.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>                        <svg class=\"w-12 h-auto absolute m-auto text-base-white\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M10 0C3.5 0 0 3.5 0 10C0 16.5 3.5 20 10 20C16.5 20 20 16.5 20 10C20 3.5 16.5 0 10 0ZM11.47 12.71C10.08 13.51 8.64 14.11 7.25 14.5C7.06 13.13 6.95 11.61 6.95 10C6.95 8.39 7.06 6.87 7.25 5.5C8.64 5.89 10.08 6.49 11.47 7.29C12.86 8.09 14.06 9.02 15.05 10C14.07 10.98 12.87 11.9 11.47 12.71Z\" fill=\"currentColor\" \/>\n            <\/svg>\n\n        <\/button>\n    \n    <dialog id=\"podcastModal\" class=\"\">\n        <div class=\"bg-base-black bg-opacity-80 fixed inset-0 z-10 h-full w-full max-w-full max-h-full flex items-center justify-center\">\n            <div class=\"mx-auto relative w-full container\">\n                <div class=\"flex overflow-hidden rounded-xs bg-base-black\">\n                    <div class=\"relative aspect-[16\/9] w-full\">\n                        <iframe loading=\"lazy\" id=\"podcastYoutubeVideo\" class=\"absolute inset-0 w-full h-full\" width=\"560\" height=\"315\" src=\"\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n                    <\/div>\n                <\/div>\n                <button id=\"closeModalButton\" class=\"absolute -top-12 -right-0 w-auto h-12 flex items-center justify-center\">\n                    <svg class=\"w-8 h-8\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                        <path d=\"M10 0C3.5 0 0 3.5 0 10C0 16.5 3.5 20 10 20C16.5 20 20 16.5 20 10C20 3.5 16.5 0 10 0ZM13.37 11.95C13.89 12.47 14.4 12.98 14.91 13.65C14.77 13.88 14.59 14.11 14.38 14.32C14.16 14.54 13.9 14.75 13.65 14.91C13.06 14.43 12.51 13.91 11.96 13.36L10.01 11.41L8.06 13.36C7.54 13.88 7.03 14.39 6.36 14.9C6.13 14.76 5.9 14.58 5.69 14.37C5.47 14.15 5.26 13.89 5.1 13.64C5.58 13.05 6.1 12.5 6.65 11.95L8.6 10L6.65 8.05C6.13 7.53 5.62 7.02 5.11 6.35C5.25 6.12 5.43 5.89 5.64 5.68C5.86 5.46 6.12 5.25 6.37 5.09C6.96 5.57 7.51 6.09 8.06 6.64L10.01 8.59L11.96 6.64C12.48 6.12 12.99 5.61 13.66 5.1C13.89 5.24 14.12 5.42 14.33 5.63C14.55 5.85 14.76 6.11 14.92 6.36C14.44 6.95 13.92 7.5 13.37 8.05L11.42 10L13.37 11.95Z\" fill=\"white\" \/>\n                    <\/svg>\n                <\/button>\n            <\/div>\n        <\/div>\n    <\/dialog>\n    \n            <div class=\"flex flex-wrap gap-4 items-center mt-3xl\">\n            <p class=\"mb-0 leading-tight font-bold\">Listen on:<\/p>\n            <div class=\"flex flex-wrap gap-xl\">\n                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/open.spotify.com\/episode\/0RdFybaHw8p63luBPKlJLe\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/spotify-podcast.png?v=2\" alt=\"Listen on Spotify\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/podcasts.apple.com\/gb\/podcast\/sql-server-and-postgres\/id1773262159?i=1000672494500\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/apple-podcast.png?v=2\" alt=\"Listen on Apple Podcasts\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/sites.libsyn.com\/537157\/sql-server-and-postgres\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/libsyn-podcast.png?v=2\" alt=\"Listen on Libsyn\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70 flex-shrink-0\" href=\"https:\/\/music.amazon.com\/podcasts\/bb23354a-9850-428f-9cb3-83235ef279c6\/episodes\/65aeca27-6b82-4fc5-b099-1d978520e6dd\/simple-talks-sql-server-and-postgres\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/amazon-podcast.png?v=2\" alt=\"Listen on Amazon Music\">\n                    <\/a>\n                            <\/div>\n        <\/div>\n    \n    <\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-introduction\">Introduction<\/h2>\n\n\n\n<p>Steve, Grant and Ryan return to Simple Talks to discuss SQL Server and Postgres. The advocates share their experiences with both systems, highlighting what works and what doesn\u2019t. From time series and Query Store to extended events, tooling and log shipping &#8211; this is a quick-fire deep dive into the pros, cons and differences between the two. There\u2019s also conversation around making the transition from one system to the other, and Ryan reflects on his challenging introduction to Postgres\u2026on the first day of a new job.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steve, Grant and Ryan return to Simple Talks to discuss SQL Server and Postgres. The advocates share their experiences with both systems, highlighting what works and what doesn\u2019t. From time series and Query Store to extended events, tooling and log shipping &#8211; this is a quick-fire deep dive into the pros, cons and differences between the two. There\u2019s also conversation around making the transition from one system to the other, and Ryan reflects on his challenging introduction to Postgres\u2026on the first day of a new job.&hellip;<\/p>\n","protected":false},"featured_media":103670,"template":"","tags":[],"podcast_category":[159198],"podcast_season":[159199],"class_list":["post-103669","podcast","type-podcast","status-publish","has-post-thumbnail","hentry","podcast_category-advochats","podcast_season-season-1"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast\/103669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/podcast"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/103670"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=103669"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=103669"},{"taxonomy":"podcast_category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast_category?post=103669"},{"taxonomy":"podcast_season","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast_season?post=103669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}