Introduction with some history

My name is Mike, and I am currently a PostgreSQL database administrator for a small tech company doing work for various clients. I started out as a green horn comp sci major back in 2006, and my first job out of college was doing development in Oracle APEX. Since then I’ve developed in various different languages against various different databases.

In 2018 I shifted into a more database centric development role that required me to get some SQL Server certifications, which can be seen on my LinkedIn profile. This was my first full database developer position, before I was more of a full-stack developer. In 2019 I had the opportunity to go to work for a small company that had a client that needed a database administrator, I had a co-worker recommend me for the position. The time was right and the money was good so just like that I was the database administrator of a very small SQL Server instance. Within a few months this got replaced with PostgreSQL due to lack of licensing funds and the need for a fresh start.

PASS Summit 2019 and 2022

In November of 2019 I attended my first PASS Summit in Seattle and it really opened my eyes to how big the SQL Server database development/administration community is. In 2022 I again attended the PASS Summit in Seattle, and while listening to one of the keynotes, the speaker suggested that even if you don’t think you have anything new to contribute to the community(whatever community that might be) you should share your knowledge because someone else might better understand your perspective on the topic. So I figured that since I worked with PostgreSQL, I could share some tips and/or tricks that I’ve learned in my short time as a PostgreSQL database administrator.

Whats next?

Since this is my first blog of any sort, I’m sure it will evolve over time and I will no doubt learn a great deal. There is still much to do and setup on this blog and I’m still getting used to putting my thoughts out there in a meaningful way. So for the next post I will show how I normally do batch transactions in pl\pgsql. Stay tuned!