Скачать с ютуб Cloud Data Driven | 2024-03-28 | Azure cloud, with a PostgreSQL database in the sky | John Miner в хорошем качестве

Cloud Data Driven | 2024-03-28 | Azure cloud, with a PostgreSQL database in the sky | John Miner

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! #### Additional notes Would love to get this presentation shown in March 2024 if possible. But any dates are open after March, want to polish off the presentation and write a couple supporting blogs. ---------------------------------------- Speakers: John Miner John Miner Insight Digital Innovations John Miner is a Senior Data Architect at Insight Digital Innovation helping corporations solve their business needs with various data platform solutions. He has over thirty years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems. His credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Also, he has earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA), Data Management & Analytics (MCSE) and Data Science (MPP). John has been recognized with the Microsoft MVP award seven times for his outstanding contributions to the Data Platform community. When he is not busy talking to local user groups or writing blog entries on new technology, he spends time with his wife and daughter enjoying outdoor activities. Some of John’s hobbies include wood working projects, crafting a good beer and playing a game of chess. ---------------------------------------- Upcoming! Future Data Driven Summit 2024 Great opportunity for professionals working in the field of data and related areas to learn about the latest trends, network with industry experts, and gain insights into the future of data-driven technologies. https://datadrivencommunity.com/Futur... ---------------------------------------- Data Driven Community The Cloud Data-Driven User Group is an integral part of the Data-Driven Community. For a comprehensive list of upcoming events and more information about our community, feel free to visit our website at [https://datadrivencommunity.com]. We look forward to your participation! ----------------------------------------