Portfolio – Projects

Professional Blogging – Technical Writing


PostgreSQL Privileges & User Management – What You Should Know

I wrote this technical blog post for Severalnines on PostgreSQL Roles and their management. I was able to complete this project almost a full week early and surpassed the minimum 1500 word count with around 2700. The blog post was published live on Jan 8, 2018. This is my first client work project.


My Favorite PostgreSQL Queries and Why They Matter

I really had to dig deep to get this blog post where I was comfortable sending it out but in the end, I am super happy with it. Such a fantastic opportunity for development, growth, and learning in public. Little did I know this blog post would eventually make it into Hacker News, sparking much interest and many comments.

I really appreciate Severalnines giving me such a great opportunity. Published live on Apr 6, 2018.


Top PostgreSQL Security Threats

Another blog post I wrote for Severalnines on a highly interesting and important topic. Security. I really enjoyed all the research and ‘Googling’ involved to complete this blog post. This assignment was my first ‘research type’ of blog post and I learned a great deal during its various phases.


Using pg_dump and pg_dumpall to Backup PostgreSQL

A super fun guest blog post I wrote for the Severalnines PostgreSQL blog. The subject matter of this post is somewhat out of my comfort zone as I view this as more of a DBA task versus a hardcore SQL Developer (which is the role I am most interested in). Nevertheless I enjoyed ‘tackling’ it and learning what I needed to complete some of the backups I wrote about. Plus, having the ability to secure database backups is an essential tasks in all systems. Overall, I am pleased with the outcome of it.

If you like what you have viewed here and are interested in me writing similar type content for you or your site, please contact me here.
I am highly interested in engaging in other SQL focused blogging/technical writing endeavors and relish new opportunities in guest writing/blogging.