DataCloudGaze Consulting

Wishing you all Happy and Prosperous Diwali !! 🪔🎇🪔🎇

🚀🚀 Latest Release of PostgreSQL 17 is Officially Here! 🎉🎉 At DataCloudGaze Consulting we've already begun exploring the exciting new features and enhancements in PostgreSQL 17 for our Database Developers Community. Here are some key highlights: 👉 Talk by Deepak M. at pgHyd: What's New in PostgreSQL 17 Watch the full video here: https://lnkd.in/dZ6D6pvT 👉 Our blog series explores new features in depth and how they can help app developers to build better database apps. What's New in PL/pgSQL : https://lnkd.in/dUNHUxsX Null constraints and performance improvements : https://lnkd.in/dmCp6aKm COPY command has become more user-friendly : https://lnkd.in/dfMMUF7d Enhanced Merge Command : https://lnkd.in/djGmy88c Correlated-in-clause-join-transformation : https://lnkd.in/dNMmnJDu Login Event Trigger : https://lnkd.in/dkaXgK7m pg_maintain Predefined Role for Maintenance : https://lnkd.in/dYK9QBVa

🚀 🚀Thinking of migrating from Oracle or SQL Server to PostgreSQL? 🚀🚀 Before you dive in, let's talk about something crucial: 🛠️ Code Conversion Planning. 🛠️ Migrating isn’t just about moving data—it’s about ensuring your PL/SQL, T-SQL, and stored procedures work seamlessly in PostgreSQL. Without proper planning, you risk migration issues, acceleration and unnecessary headaches. At DataCloudGaze Consulting, our Automated Code Conversion Planning makes your transition to PostgreSQL smooth, efficient, and optimized for scale. Check out the preview of automated code conversion planning report. Let’s connect and discuss how we can help make your migration a success! 🤝 #PostgreSQL #DatabaseMigration #OracleToPostgreSQL #SQLServerToPostgreSQL #DataCloudGaze

PostgreSQL is even cooler when you master its Extensions, and it gets way cooler when you compare it with Managed Services from AWS, Azure, GCP, and more. Now, comparing extensions is even simpler with our new filters. Give it a try --> https://lnkd.in/dRi6mPFn #PostgreSQL #Extensions #RDS #CloudSQL #AWS #Azure #GCP

At DataCloudGaze Consulting, our goal of simplifying PostgreSQL execution plan analysis has taken the next step. Now, with pg_sqltxplain, you can view all your database objects directly within the execution plan. Give it a spin and let us know your feedback to help us improve continuously! GitHub: https://lnkd.in/dtxnz5TG Blog: https://lnkd.in/d2QerXEu #PostgreSQL #Performance #SQL #Tuning #ExecutionPlan

🚀 Explore PostgreSQL Extensions on Cloud Managed Services! 🌥️ We’ve added sample filters to showcase the powerful use cases you can achieve with pgextensions.org https://lnkd.in/dRi6mPFn. ✨ Highlights: 🌐 Explore Cloud PostgreSQL Extensions: AWS, GCP, Azure ☁️ PostgreSQL Extensions for AWS RDS, GCP Cloud SQL, Azure DB ⚡ Speed Up Queries: Postgres Performance Extensions 🔄 Migrate Oracle to Postgres: Extensions #Extensions #PostgreSQL #AWS #GCP #Azure #pgextensions

Are you a Database Developer or DBA looking for valuable insights when evaluating problematic SQL for performance? Check out our new tool - pg_sqltxplain ! 🚀🚀 It simplifies PostgreSQL execution plan analysis by curating underlying stats into a single HTML report📊. #PostgreSQL #SQL #Tuning #Explain #Analyze #Statistics Start here --> https://lnkd.in/dZqESE5Y

Happy to see our contributions helping PostgreSQL users on the cloud to navigate and understand the intricate details around extensions and their support. Quote from the blog "If evaluating services across cloud providers or wanting to migrate from one to another,pgextensions is a life saver." https://lnkd.in/dFhKurtn #PostgreSQL #Cloud #Databases #Extensions

🚀🚀🚀 Achieve a Truly Open-Source PostgreSQL Migration with AWS Schema Conversion Tool - aws_sqlserver_ext - Part 2 Migrating to PostgreSQL is a priority due to its extensibility, open-source licenses, and cloud support. At DataCloudGaze Consulting, we optimize PostgreSQL migrations by reducing costs and time, ensuring openness across platforms. In our previous blog, we eliminated aws_oracle_ext dependencies. Now, we're excited to help you get rid of aws_sqlserver_ext packs! If you're migrating SQL Server to PostgreSQL using the AWS Schema Conversion Tool, check out our solutions to remove extension pack dependencies and unlock future scalability. 🔗 https://lnkd.in/dv2iGYsP #PostgreSQL #DataMigration #AWS #SQLServer #OpenSource #aws_sqlserver_ext

🚀🚀🚀Announcing pgextensions.org Your guide to PostgreSQL extensions in the cloud.☁️🌐 Compare and discover extensions across most of Cloud provider supporting PostgreSQL and enhance your database decision!📊🔍 If you are fascinated by Extensions and PostgreSQL on #Cloud do check it out.! https://lnkd.in/dRi6mPFn #PostgreSQL #DatabaseMigration #Extensions #AWS #GCP #Azure