Ryan Booz helps a SQL Server DBA out:
Five years ago, I began my transition back to using PostgreSQL full-time, and it wasn’t the smoothest journey. One of the biggest reasons I struggled to make progress learning PostgreSQL early on was simply not knowing what I should be looking for. In fact, I often have conversations multiple times a month about the differences between SQL Server and PostgreSQL with folks setting out on a similar journey.
My guess is that you’re trying to figure out the same things, which is how you ended up on this series of posts.
Read on to take advantage of Ryan’s pain and suffering.