Efficient Partitioning of Large Tables in PostgreSQL and SQL Server using the First Letter

Partitioning by First Letter:
When partitioning by first letter, we can either create a computed column on the first letter or use a range partition. However, the most elegant solution is to use only the letter itself, as it follows a predictable orde… Continue reading Efficient Partitioning of Large Tables in PostgreSQL and SQL Server using the First Letter

Windows Server Summit 2022: Keynote Kickoff with Roanne Sones

Welcome to the “Director’s cut” of the 2022 Windows Server Summit.  I am going through and posting each of the sessions (and my comments) that were part of the event that took place December 6th, 2022.
 
This is the kick off video that was a … Continue reading Windows Server Summit 2022: Keynote Kickoff with Roanne Sones

Supercharge Archive Content Discovery with ChatGPT and Azure Video Indexer

Video has become one of the most popular forms of content on the internet, and organizations around the world are investing heavily in creating and sharing videos for various purposes, social media taking a significant share. Additionally Enterprise or… Continue reading Supercharge Archive Content Discovery with ChatGPT and Azure Video Indexer

Initiation à GitHub Projects – Partie I (Tableau Kanban)

Bonjour, je m’appelle Hamidou TESSILIMI. Je suis étudiant en 4ème année à Epitech et également un Bêta Microsoft Learn Student Ambassador. Depuis ma première année, j’utilise GitHub pour rendre la quasi-totalité de mes projets. Dans la majorité des cas… Continue reading Initiation à GitHub Projects – Partie I (Tableau Kanban)

Deploy app service with private endpoint enabled via Azure DevOps

There is a common scenario that customers want their app service being allocated inside private network and cannot be accessed by public network. Therefore, they usually enable private endpoint as well as configure Access Restriction to deny all the pu… Continue reading Deploy app service with private endpoint enabled via Azure DevOps

Trigger SQL Views with Logic App Standard with the built-in SQL Connector

By the time of writing this article, the Logic App Standard SQL Connector does not have the functionality to monitor the row version of SQL Views so it can’t be triggered by a change in the View’s data, which would have allowed us to configure a trigge… Continue reading Trigger SQL Views with Logic App Standard with the built-in SQL Connector