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 07: SQL Server Security

Episode 07: SQL Server Security

I chat with Microsoft MVP Chris Bell about database security and some seemingly cavelier attitudes some organziations have about keeping data safe.  We hit some of the methods SQL Server has to protec...

2 Sep 201541min

SQL Data Partners Podcast: Episode 06 Build Your Personal Brand

SQL Data Partners Podcast: Episode 06 Build Your Personal Brand

Steve Jones, the editor from SQL Server central and I talk about the need to build your own brand and we share a few ideas on how to do that.  We talk about Steve's brand and how he built that over ti...

26 Aug 201532min

SQL Data Partners Episode 05: Principal of Least Privilege

SQL Data Partners Episode 05: Principal of Least Privilege

Robert Verell and I chat about good security practices and the principle of least privilege.  We discuss Robert's rule to never give anyone db_owner, other groups and Robert's home grown group to give...

19 Aug 201531min

SQL Data Partners Podcast Episode 04: Advanced Backup Options

SQL Data Partners Podcast Episode 04: Advanced Backup Options

We finish up our conversation with MVP Tim Radney on backup options with discussions on encryption and Azure.  Tim also shares his favorite tools and his super hero power of choice. Erik Véliz, the cr...

12 Aug 201519min

SQL Data Partners Podcast Episode 03: Backup and Recovery

SQL Data Partners Podcast Episode 03: Backup and Recovery

I chat with MVP Tim Radney about Backup and Recovery options in SQL Server. We chatted for quite awhile and I ended up making two episodes out of our conversation. This episode focuses on why we bac...

5 Aug 201531min

SQL Data Partners Podcast Episode 02: Extended Events

SQL Data Partners Podcast Episode 02: Extended Events

I was in Argentina for the SQLSaturday event in May of 2015 and made friends with Javier Villegas, a 20 year veteran in the DBA world. While extended events have been around for some time, many are s...

5 Aug 201524min

SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About

SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About

Today I am super happy to announce the launch of my podcast and I start with episode 00. In this episode I take some time to go through my journey in becoming a data professional and how I think the p...

5 Aug 201524min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
jakt-og-fiskepodden
rss-sunn-okonomi
sinnsyn
mikkels-paskenotter
takk-og-lov-med-anine-kierulf
hverdagspsyken
gravid-uke-for-uke
rss-kunsten-a-leve
tomprat-med-gunnar-tjomlid
hagespiren-podcast
rss-bisarr-historie
rss-var-forste-kaffe
fryktlos
rss-kull