Microsoft Support & Discussions

About this blog series Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. To learn about the Microsoft MVP Award and to find MVPs visit the official website: Microsoft MVP Award. The Azure Synapse Analytics team presents you with a blog series "Azure Synapse MVP Corner" to highlight sele…

Issue: When user view the audit log file from the log file viewer in SSMS he gets an error “Item has already been added. Key in dictionary: 'MNDO’ Key being added: 'MNDO'“. Investigation: After investigating this issue with SQL server profiler we found that this option is executing the following query: select distinct action_id, name from sys.dm_audit_actions where action_in_log = 1 and by running this query in SSMS query editor you will find the duplicate value for ‘MNDO’ key As SSMS is using the unique value action_id instead of the combination of action_id+name when creating the internal dictionary, So…

For security or compliance, your subscription administrators might assign policies that limit how resources are deployed. Deny policy, as one policy type, is used to prevent a resource request that does not match defined standards through a policy definition and fails the request. For example, deny policies that prevent creating public IP addresses, network security groups, user-defined routes, or route tables. Document Reference: Understand how effects work - Azure Policy This blog will show you how to troubleshoot deny policy related issues and how to fix them. Troubleshoot RequestDisallowedByPolicy errors and non-compliant resources [Examp…

Recently, a new feature called “Manual effect” popped out to users and it is still in the PREVIEW stage. It allows users to self-attest the compliance of resources or scopes. In another word, it gives users a chance to determine the compliance result of the specific resource and the reason. Currently, it is mostly used inside the Security related built-in policies and initiatives. In this post, I will briefly introduce what it looks like and how it works. There are multiple built-in policies under the Security category to check the subscription level compliance results with manual effect. For the built-in example, you may check “Issue public key certificates” (poli…

I did a post a while ago on installing software onto virtual machines using policy state change events as the trigger. Now with the general availability of Azure Automanage Machine Configuration (formerly Azure Policy Guest Configuration) it’s time for a bit of an update to that post. In this guide I’ll again be installing PowerShell 7 – however I’ll use Machine Configuration and Azure Policy to handle the installation. Let’s get started…. Development Environment To make sure I have all the tools to complete this process I need to install some pre-requisite software. This is so I can generate the package which the virtual machine will download to tell it how t…

What’s the difference between ‘Poll’, ‘Polls’ and ‘Forms’ app in Teams? Poll, Polls, and Forms are 3 different apps (icon shown below) for the polling experience in the context of Teams meetings. App Name Icon Description Polls (plural) [attachment=29043:name] Polls app is dedicated for the polling experience in Teams Forms [attachment=29044:name] Forms app was tailored for different experiences in Teams based on the sync vs async user scenarios, as it points to polling experience in meetings for quick creation to launch, while it points to survey experience in the context of Teams channel. Poll (singul…

Today, I worked on a service request that our customer got the following error message using Python code: pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)'). I would like to share with you what was my lessons learned here. The first thing is to isolate the problem running the suggested Python code using pymssql and pyodbc to see the results: import os import pymssql import pyodbc conn = pyodbc.connect("DRIVER={ODBC Driver 17 for SQL Server};server=servername.database.windows.net,1433;UID=username;PWD=Password;database=dbName"); conn2 = pymssql.connect(server='serverna…

Since the last update of v1.4.0, this Azure Functions OpenAPI extension has a lot of improvements. Here in this post, let's discuss what improvements have been made. Update – v1.5.0 .NET 7 support for the isolated worker extension According to the Azure Functions roadmap, Azure Functions isolated worker model has started supporting .NET 7. Therefore, this OpenAPI extension also starts supporting .NET 7 with the isolated worker model. The migration step is as easy as changing the target framework. Update your .csproj file and find the <TargetFramework> node, and change it from netcoreapp3.1 (.NET Core 3.1), net5.0 (.NET 5) or net6.0 (.NET 6), to net7.0 (.N…

About WordPress WordPress is one of the most powerful tools and is widely used by over 40% of the web to create websites, blogs, and other applications. WordPress can be run on a few different Azure services: AKS, Virtual Machines, and App Service. The easiest and straight forward deployment option is to use the WordPress template from the Web Apps gallery. With Azure App service, you can deploy and configure your own WordPress website in minutes. Why use Microsoft Azure The evolution of the content management system means websites require a flexible and scalable hosting platform. Hosting a WordPress site on Azure can give organizations the scalability and …

Today, I worked on a service request that our customer using Always Encrypted is facing the following error message: SqlErrorNumber=33277,Class=16,ErrorCode=-2146232060,State=2,Errors=[{Class=16,Number=33277,State=2,Message=Encryption scheme mismatch for columns/variables 'ColumnName'. The encryption scheme for the columns/variables is (encryption_type = 'RANDOMIZED', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'xxx') and the expression near line '1' expects it to be DETERMINISTIC, or PLAINTEXT. Using Azure Data Studio -> SQL Server Profiler extension during the exe…

Hello hello, everyone! I hope you’re all having a good week without too much on your plate. Speaking of plates, before I log off to partake in some festive feasting, lets recap some highlights from the past few days in the MTC and start looking ahead to the new year :) MTC Moments of the Week We are putting this week’s MTC Member of the Week spotlight on @Vasil Michev, a longtime Tech Community member and Microsoft MVP. We sincerely appreciate all the knowledge and guidance you share across so many different MTC forums! Over on the blogs this week, @BrookeLynnWeenig shared an announcement about a brand new webinar series coming January 25, 2023…

This monthly series features training content aligned to Microsoft Security, compliance, and identity (SCI) solutions on Microsoft Learn. This month is all about Microsoft Security Virtual Training Days. These free and in-depth virtual training events help professionals of all levels grow their technical skills and gain confidence to navigate what’s ahead. Visit the Microsoft Security Virtual Training Days page to view and register for upcoming events in your region. NEW Virtual Training Day: Secure Access and Management The new Secure Access and Management Virtual Training Day replaces the Zero Trust Virtual Training Day and features new, extended con…

Architecting a global application is challenging. On one side you want to assure that API will have very low latency to give end users the best experience when navigating a website or using a mobile app; on the other side you also need a centralized access to data with rich query capabilities to efficiently provide data consistency and query performances. There is no “one-size-fits-all" approach here, but like in a good soccer team, you need teamwork. Azure SQL DB and Redis works amazingly well together to achieve both the goals. Let’s see, together, how, in this Data Exposed episode with Anna Hoffman, Davide Mauri, and Roberto Perez. Resources: End-To-…

When COVID hit, we had to rush to find virtual meeting solutions. Some divisions were already using WebEx, others bought Zoom, and the organization decided to enable Microsoft Teams since we already had Microsoft 365. There was no time for training, but everyone was saying it’s easy to use and we didn’t have the choice. It was a bit clunky at the beginning to work from home. The VPN seemed to be causing some problems, some meetings were crashing, some froze, some were hard to hear. But we are resilient, and we got used to it. After a few months, we started to find our way using Teams. We understood that we didn’t need the VPN to connect to Teams and t…

Architecting a global application is challenging. On one side you want to assure that API will have very low latency to give end users the best experience when navigating a website or using a mobile app; on the other side you also need a centralized access to data with rich query capabilities to efficiently provide data consistency and query performances. There is no “one-size-fits-all" approach here, but like in a good soccer team, you need teamwork. Azure SQL DB and Redis works amazingly well together to achieve both the goals. Let’s see, together, how, in this Data Exposed episode with Anna Hoffman, Davide Mauri, and Roberto Perez. Resources: End-To-End Sampl…

There are four critical components to a private 5G network: the local radio and networking functions, the edge compute platform, the application ecosystem, and the cloud. Private 5G network solutions are often built as a collection of loosely integrated components. This loose-integration approach might make sense in terms of physical and organizational demarcation points, but it has drawbacks. The following problems are inherent in this approach: Difficult to deploy Difficult to manage Expensive to scale Not secure Microsoft offers a different approach to help operators take advantage of the opportunity to provide private 5G to enterprises. This cloud-managed …

Introduction According to SAP, 77% of the world’s transaction revenue touches an SAP system. To understand these systems and extracting the data is a challenging job. To gain insights, it is always helpful to integrate the data source systems seamlessly with analytics services. During a hack session, we tried to accomplish the challenge of extracting the data from SAP source and integrating it with analytical services using the new Database Templates/Lake Database feature that is available in Synapse workspaces. The SAP source system was SAP S/4HANA Analytics services was Azure Synapse Analytics and Lake database templates The scope for our Hack E…

This blog is in continuation of part 1 linked : Integrate Synapse Database Templates with SAP Data - Part 1 - Microsoft Community Hub 3.Data Mapping Next step is the data mapping task which was the most time consuming as we mapped our source data entities to entities in our lake database. Some source SAP tables used: Source tables Table description KNA1 General Data in Customer Master KNVV Customer Master Sales Data LIKP SD Document: Delivery Header Data LIPS SD document: Delivery: Item data Destination lake database tables used are: Destination tables Shot table desc…

Case: In a situation, you observe your EventHub namespace is still incurring the cost, even though you are not doing any operations (read/write/management) on it and your EventHub namespace has no active EventHub instances present. Root Cause of the behavior: At the time of creating the Azure EventHub namespace (Basic/Standard/Premium/Dedicated tier), you may have to give pre-purchased units of capacity in terms of Throughput units/Processing units/Capacity units based on the tier you choose. These pre-purchased units of capacity controls throughput capacity of the EventHub namespace. Among all the other pricing factors, cost will be incurred based on the num…

Background Information As we all know, the API management service is nothing but a proxy that helps to forward the request and response between the client and the backend server. Ideally, the API Management server will maintain two connections: the one with the client side, and the one with the backend server. The backend server proceeds the request from APIM when SSL/TLS connection is successfully established between APIM and the backend server. However, if any of the elements within the SSL/TLS connection go wrong, the client server may receive a 500 BackendConnectionFailure error with the message ‘The underlying connection was closed: Could not establish trust…

Once a private link is created our customers disabled the option "Public network access" but connecting to the database they faced the following error: 'Microsoft SQL: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes. To connect to this server, use the Private Endpoint from inside your virtual network . In this article I would like to explain why this situation happened. The most tipical scenario is when the DNS server that our customer is using is resolving the public IP instead of resolving the private IP. For this reason, running a ping servername.data…

Before we start, please not that if you want to see a table of contents for all the sections of this blog and their various Purview topics, you can locate the in the following link: Microsoft Purview- Paint By Numbers Series (Part 0) - Overview - Microsoft Tech Community Disclaimer This document is not meant to replace any official documentation, including those found at docs.microsoft.com. Those documents are continually updated and maintained by Microsoft Corporation. If there is a discrepancy between this document and what you find in the Compliance User Interface (UI) or inside of a reference in docs.microsoft.com, you should always defer to that offi…

We are excited to announce the release of auto-refresh of message counters on the queue overview blades in Service Bus portal experience. This feature updates the queue settings and message counters automatically in specific time intervals selected by the user to provide real time message counts within portal. Queue settings and message counts Every Service Bus queue overview blade on Azure Portal shows valuable information pertaining to the queue settings and messages on the queue. Some of the metrics exposed to users are as shown below: Currently, the queue settings and message counts are only updated if the page is voluntarily refresh…

We were recently alerted to an issue where Samsung devices are unable to enroll as personally-owned Work Profile on Android 13. Users may see a dialog box saying that the profile was unable to be created. S21 and S22 devices are confirmed to be affected, but impact on other models may be possible. We have been working with Samsung and Google friends, who have issued a fix. In order to resolve, we recommend that admins tell users to reboot the device. The Android Device Policy app will be downloaded during enrollment, but it will not change the user experiences. If the reboot does not resolve the issue, try guiding your users to install the Android Device Policy man…

Today, I worked on a service request that our customer got the following error message: SSL is required but not requested. This issue means that SSL is required (Azure SQL or Azure SQL Managed Instance is encrypting the data) but in the connection string has not been specified SSL connection. If you faced this issue, please, review in the documentation of the driver any parameter related about the encryption method to specify the value for SSL, for example, EncryptionMethod=SSL. In Setting the connection properties - JDBC Driver for SQL Server | Microsoft Learn we don't have this parameter. Enjoy! Continue reading...