Episode 277: PostgreSQL for the SQL Server Crowd

Episode 277: PostgreSQL for the SQL Server Crowd

Is testing out pgAdmin on your to-do list?

In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into PostgreSQL, one of the most popular open source databases in the world.

Ryan came from a career background in SQL Server, but after experiencing his accidental "jump-into-the-deep-end" PostgreSQL moment, he hasn't looked back.

Naturally, open source presents DBAs and their organizations with many desirable features, but there are certain drawbacks as well. Ryan shares how he navigated his transition into PostgreSQL and raises some points to consider if you are thinking about a switch. We discuss a few of the land mines you might encounter along the way as well as terminology differences in this space.

Be sure to check out Planet PostgreSQL for the most recent blog posts from the very folks that are contributing code to the PostgreSQL project.

Have you shifted from SQL Server to PostgreSQL? How'd it go? Did you get any good take-aways from today's podcast or have some questions? Leave us a comment and some love ❤️ on LinkedIn, X, Facebook, or Instagram.

The show notes for today's episode can be found at Episode 277: PostgreSQL for the SQL Server Crowd. Have fun on the SQL Trail!

Episoder(287)

Episode 223: Podcast Update

Episode 223: Podcast Update

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episo...

14 Apr 20219min

Episode 222: Azure Arc-enabled Data Services

Episode 222: Azure Arc-enabled Data Services

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from th...

24 Mar 20211h 4min

Episode 221: SQL Trail March 2021 Retrospective

Episode 221: SQL Trail March 2021 Retrospective

Virtual conferences are just not the same as the conferences we are used to, but we're still determined to provide a good learning and networking environment for our friends. We very much miss having...

22 Mar 202139min

Episode 220: Microsoft Ignite Recap

Episode 220: Microsoft Ignite Recap

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss someth...

10 Mar 202145min

Episode 219: SQL Server Inventory

Episode 219: SQL Server Inventory

How do you document your SQL Server environments? I can remember walking through Brent Ozar's takeover script back in the day and how cumbersome it was to put all that information together. We have a ...

24 Feb 202147min

Episode 218: File Growths

Episode 218: File Growths

In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show no...

17 Feb 202130min

Episode 217: A Little Something About A Few Things

Episode 217: A Little Something About A Few Things

The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about ...

10 Feb 202134min

Episode 216: EDI vs ETL

Episode 216: EDI vs ETL

When working on a customer on an import process, she made the comment—if we were doing true EDI, we'd [Do X]. The comment got me thinking—Aren't we working on an EDI process? As someone who frequentl...

3 Feb 202132min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
treningspodden
rss-strid-de-norske-borgerkrigene
foreldreradet
rss-sunn-okonomi
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
rss-kunsten-a-leve
merry-quizmas
gravid-uke-for-uke
hverdagspsyken
smart-forklart
hagespiren-podcast
rss-kull
lederskap-nhhs-podkast-om-ledelse
fryktlos
uroskolen