MVP’s Favorite Content: SQL, AI, Microsoft 365, Azure

In this blog series dedicated to Microsoft's technical articles, we'll highlight our MVPs' favorite article along with their personal insights.

Sergio Govoni, Data Platform MVP, Italy

IDENTITY (Property) (Transact-SQL) - SQL Server | Microsoft Learn

“Recently, I faced the SQL error 8115: Arithmetic overflow error converting IDENTITY to data type int. This content describes an option to regenerate IDENTITY column values in SQL Server and Azure SQL, ensuring referential integrity and preserving related objects like constraints, indexes, and triggers. This solution prevents data overflow errors and maintains consistency without renaming or losing linked objects. Below are the error variations that occur when an overflow happens on IDENTITY columns."

*Relevant Blog:

- English: Regenerate IDENTITY column values on SQL Server and Azure SQL with sp_identity_rebirth | by Sergio Govoni | CodeX | Medium

- Italian: Rigenerare colonne IDENTITY in SQL Server e Azure SQL! – UGISS

Dicky Fung, AI Platform MVP, Hong Kong

Announcing new products and features for Azure OpenAI Service including GPT-4o-Realtime-Preview with audio and speech capabilities | Microsoft Azure Blog

“The article provides an in-depth look at the new features of the GPT-4o Realtime API, including its advanced audio and speech capabilities, which are essential for developing more natural and engaging AI applications.

Also, it highlights various use cases, such as customer support and real-time translation, demonstrating how these capabilities can be leveraged to enhance user experiences across different industries.”

Michael Blumenthal, M365 MVP, United States

Managing Microsoft 365 Message Center Triage With Planner (YouTube)

“It's important to manage changes in Microsoft 365.  This video shows how you can manage Message Center messages using Planner. It emphasizes creating a business process to handle these changes efficiently. Vesa J promoted it on LI!”

*Relevant Resources: Shifty Copilot Agents. New Outlook on by default | Ep 357 (not mine but made by other MVPs who also care about this topic. Also see Maturity Model for Microsoft 365 Practical Scenarios – Microsoft 365 Service Change Management | Microsoft Learn

Rajaniesh Kaushikk, Microsoft Azure MVP, United States

Azure landing zone design areas - Cloud Adoption Framework | Microsoft Learn

"The Azure landing zone architecture is intended to help organizations operate successful cloud environments that drive their business while maintaining best practices for security and governance. This Article describes it very nicely."

*Relevant Blog:

- Azure landing zone design best practices - Beyond the Horizon...

- Azure Architecture Best Practice for securing Azure Virtual Networks - Beyond the Horizon...