CASSUG Meeting - Albany NY - 9.9.2024

CASSUG Meeting - Albany NY - 9.9.2024

John Miner John Miner

John Miner

Data Architect at Insight

发布日期: 2024年9月4日
+ 关注

I am looking forward to seeing my friends in the Albany area with a local talk at the user group. I hope the weather warms up for this weekend to make it enjoyable.

Topic:

Moving on up, to the Azure cloud, with a PostgreSQL database in the sky"


Abstract:

Many companies are looking to reduce licensing costs by moving databases currently written for SQL Server to PostgreSQL. What are the technical pitfalls you might encounter when moving not only the database schema but re-factoring the code?

In this presentation, we will show how recreating the existing database schema in PostgreSQL is quite easy and migrating the data from MS SQL Server to PostgreSQL is not hard. However, the old saying of “garbage in equals garbage out” applies to both views and stored code.

These two types of pre-compiled code will challenge the developer to use their skills to decipher code written years ago and convert it to modern day code that is performant, uses intermediate steps for debugging and uses logging for run time metrics.

In short, this presentation is a must for database developers that are tasked with moving and modernizing older SQL Server databases to PostgreSQL!

要查看或添加评论，请登录

John Miner的更多文章

  • Why use Tally Tables in the Fabric Warehouse?
    2025年2月26日

    Why use Tally Tables in the Fabric Warehouse?

    Technical Problem Did you know that Edgar F. Codd is considered the father of the relational model that is used by most…

  • Streaming Data with Azure Databricks
    2025年2月25日

    Streaming Data with Azure Databricks

    Technical Problem The core functionality of Apache Spark has support for structured streaming using either a batch or a…

    1 条评论
  • Upcoming Fabric Webinars from Insight
    2025年2月19日

    Upcoming Fabric Webinars from Insight

    Don't miss the opportunity to boost your data skills with Insight and Microsoft. This webinar series will help you…

  • How to develop solutions with Fabric Data Warehouse?
    2025年2月18日

    How to develop solutions with Fabric Data Warehouse?

    Technology Details The SQL endpoint of the Fabric Data Warehouse allows programs to read from and write to tables. The…

  • Understanding file formats within the Fabric Lakehouse
    2025年2月10日

    Understanding file formats within the Fabric Lakehouse

    I am looking forward to talking to the Cloud Data Driven user group on March 13th. You can find all the presentation…

    2 条评论
  • Engineering a Lakehouse with Azure Databricks with Spark Dataframes
    2025年2月3日

    Engineering a Lakehouse with Azure Databricks with Spark Dataframes

    Problem Time does surely fly. I remember when Databricks was released to general availability in Azure in March 2018.

  • Create an Azure Databricks SQL Warehouse
    2025年1月21日

    Create an Azure Databricks SQL Warehouse

    Problem Many companies are leveraging data lakes to manage both structured and unstructured data. However, not all…

    2 条评论
  • How to Load a Fabric Warehouse?
    2025年1月9日

    How to Load a Fabric Warehouse?

    Technology The data warehouse in Microsoft Fabric was re-written to use One Lake storage. This means each and every…

  • My Year End Wrap Up for 2024
    2024年12月26日

    My Year End Wrap Up for 2024

    Hi Folks, It has been a very busy year. At the start of this year I wanted to learn Fabric in depth.

    1 条评论
  • Virtualizing GCP data with Fabric Shortcuts
    2024年12月16日

    Virtualizing GCP data with Fabric Shortcuts

    New Technology Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to…

社区洞察

其他会员也浏览了