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. As with most everything in blogging and technical writing, the opportunity to learn and grow is one of the greatest rewards and benefits. 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. This blog post was also featured in the Postgres Weekly publication. I almost lost my breath when I discovered it in my inbox one morning since I subscribe to that source for great articles as well.

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 task in all systems. Overall, I am pleased with the outcome of it.


More of my Favorite PostgreSQL Queries – and Why They Also Matter

A follow-up guest blog post I wrote for the Severalnines PostgreSQL blog. This blog is super important to me as I used it to gauge what I’ve learned from the first part of this ‘dynamic duo’ that shares similar naming with that first post. I enjoyed the bench marking sections of it but more so what I learned in the section about PLpgSQL Cursor’s. That was tons of fun for me. I hope to find a real world use case to ply them in one day. This ‘accompanying’ article also wound up featured in the Postgres Weekly publication. So excited for this exposure and another golden opportunity to learn and grow in public.

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.

Advertisements

One thought on “Portfolio – Projects

Comments are closed.