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!

Avsnitt(287)

Episode 15 Working at a University

Episode 15 Working at a University

Corporate culture is a BIG deal when it comes to job satisfaction, and it is interesting to see how different sectors can be.  Today we talk with Doug Purnell, DBA at Elon College in North Carolina an...

28 Okt 201525min

Episode 14: SQL Server Clustering

Episode 14: SQL Server Clustering

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach ha...

21 Okt 201523min

Episode 13 Apply Yourself

Episode 13 Apply Yourself

I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin for a while and knew he had good stuff. He there sha...

14 Okt 201530min

Episode 12: Database Corruption

Episode 12: Database Corruption

Database corruption is something that will eventually come to all data professionals.  While I have been fortunate to only come across is a handful of times, I was glad that I was able to get back the...

7 Okt 201531min

Episode 11: SQL Server Statistics

Episode 11: SQL Server Statistics

So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software about SQL Server Statistics.  Always taking an opport...

30 Sep 201534min

Episode 10: Test Anxiety and Test Preparation

Episode 10: Test Anxiety and Test Preparation

We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation.  Taking a test can be a big deal and it is always interesting to get other options ...

23 Sep 201532min

Episode 09: Database Automation

Episode 09: Database Automation

Joey D'Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has helped him be more efficient and have fewer support...

16 Sep 201529min

Episode 08: Database Design

Episode 08: Database Design

I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are available to help you.  It may surprise you that, a...

9 Sep 201533min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
roda-vita-rosen
johannes-hansen-podcast
allt-du-velat-veta
sektledare
rss-viktmedicinpodden
not-fanny-anymore
i-vantan-pa-katastrofen
sa-in-i-sjalen
rss-max-tant-med-max-villman
rss-basta-livet
rss-sjalsligt-avkladd
sex-pa-riktigt-med-marika-smith
rss-pa-insidan-med-bjorn-rudman
rss-ar-det-rimligt