{"version":"1.0","provider_name":"Simple Talk","provider_url":"https:\/\/www.red-gate.com\/simple-talk","author_name":"Louis Davidson","author_url":"https:\/\/www.red-gate.com\/simple-talk\/author\/louis-davidson\/","title":"SQL Server and Postgres","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"aQ0eaCAUfG\"><a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/episode-5-sql-server-and-postgres\/\">SQL Server and Postgres<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/episode-5-sql-server-and-postgres\/embed\/#?secret=aQ0eaCAUfG\" width=\"600\" height=\"338\" title=\"&#8220;SQL Server and Postgres&#8221; &#8212; Simple Talk\" data-secret=\"aQ0eaCAUfG\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.red-gate.com\/simple-talk\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","thumbnail_url":"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/08\/EP5-SQL-Server-and-Postgres-Card.jpg","thumbnail_width":1280,"thumbnail_height":720,"description":"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 - 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;"}