Microsoft Support & Discussions

Today, we got a service request that our customer faced the following error message connecting to the database: (pyodbc.OperationalError) ('08S01', '[08S01] [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x68 (104) (SQLExecDirectW)'). This customer is using Python in a Linux environment. Following I would like to share my lessons learned about this error message. Checking what does mean 0x68 is 104 in decimal, and that is a Connection Reset by Peer error (i.e. the server abruptly closed the connection) and in Linux errors are listed here: https://github.com/torvalds/linux/blob/master/include/uapi/asm-generic/errno.h Most probably, this …

Interested in building your knowledge for selling Azure, Business Applications, Security and Modern Work? Build your capabilities and bolster your existing skills with our on-demand sales bootcamps. View on-demand now Continue reading...

Whether you're providing services or developing software, we have the resources you need to jumpstart your growth. Compare our offerings for partners and find the best fit for your business. Discover more Continue reading...

We've introduced new Microsoft 365 Copilot capabilities and released the 2023 Work Trend Index, revealing how AI will create a new way of working. Review the Build Book of News:Introducing the Microsoft 365 Copilot Early Access Program and 2023 Microsoft Work Trend Index - The Official Microsoft Blog Continue reading...

We’ve announced a roadmap of planned enhancements with new offers and program changes that lower cost and benefit our customers and partners in the Cloud Solution Provider (CSP) – Hoster program. Learn more here: Collection Continue reading...

We’ve announced a roadmap of planned enhancements with new offers and program changes that lower cost and benefit our customers and partners in the Cloud Solution Provider (CSP) – Hoster program. Learn more Continue reading...

In an effort to create a simplified experience for our partners, we are consolidating the Surface PC and Hub channels into a single channel. Starting this month, we will be inviting all partners onboard sign the latest channel partner agreement in Partner Center to remain authorized to sell the Surface portfolio newly covering all product types. For more details visit the Surface Reseller Alliance Portal: Microsoft Surface Partner -- Home Continue reading...

In a recent demonstration, Sean Kelly, an experienced professional and educator, showcased the Microsoft Learn Catalog Connector, a custom connector he developed to access the Microsoft Learn catalog. The connector allows users to retrieve various types of content, such as certifications, learning paths, and modules, from the catalog using a simple API endpoint. In this blog post, we'll explore the capabilities of the Learn Catalog Connector and how it can be utilized in Power Automate and Power Apps to enhance the learning experience. Accessing the Microsoft Learn Catalog: The Microsoft Learn Catalog API serves as the foundation for the Learn Catalog Connec…

Stored procedure is a module or a program that is stored in the database, it adds ability to create and reuse user defined programs in supported SQL/PL languages. in all the versions , including up to PostgreSQL 10, it was not possible to create a procedure in PostgreSQL. In In PostgreSQL 11 , PROCEDURE was added as a new schema object which is a similar object to FUNCTION, but without a return value. Once compiled, they become a schema object which can be executed or referenced by multiple applications. The stored procedures/functions are very useful component of a database application as they underpin the complex application logic and database operations that needs to…

You might have read it in our recent breaking change bundle last week. Before going Generally Available (GA) in a few weeks, we have indeed enacted a breaking change on the Cosmos DB data connection: it now requires the managed identity (either system or user) assigned to the data connection to have Cosmos DB Account Reader Role (Control Plane role) on the Cosmos DB account. Now before you read any further, this doesn't actually break existing data connection as we explain in more details below. Since we released the public preview in January, we required Cosmos DB Built-in Data Reader (Data Plane role). That role allowed Kusto to read the Cosmos DB…

Your learning goes beyond Microsoft Build. Join After Parties at a local time with your local community. Here are some of our Community-led After Parties held on from May 29 to June 5 (as of May 29, 2023). Check it out and join your favorite Parties! MVP/RD/User Group-led Microsoft Build 2023 After Party Date (Local Time) Title Language(s) Format(s) May 29, 2023 Microsoft Build After Party - 気ままに勉強会 Power Platform Meetup 1 Japanese-Japan Virtual May 30, 2023 Microsoft Build After Party - Wellington Azure AI Meetup English-New Zealand Hybrid May 30, 2023 Discussion for Micro…

Today, we got a service request that our customer faced the following error message: Error SQL46010: Procedure: [dbo].[XYZ] contains a statement that is not supported on Microsoft Azure SQL Database v12. The specific error is: Incorrect syntax near '1252'. I would like to share with you the lessons learned. The first thing that we need to pay attention is trying to find the text of this incorrect syntax error: The specific error is: Incorrect syntax near '1252'. The error message indicates that the statement in the stored procedure [dbo].[XYZ] contains a syntax error that is not supported on Microsoft Azure SQL Database v12. The error message states that there is a…

Hello! My name is Nandan Sheth, and I am a part of Microsoft’s Customer Success Unit based out of Dublin, Ireland. I have been helping customers set up the Cloud Management Gateway for a few years now, but recently an organization with 40000+ users asked me a question that I haven’t given much thought to. When you set up the Cloud Management Gateway using a Virtual Machine Scale Set, one of the resources created in Azure is the Network Security Group. The Network Security Group has an inbound rule for port 8443. Why is this rule created and what is it needed for? Figure 1: Network Security Group showing the inbound rule for port 8443. After searching a bi…

About the team We are an enthusiastic team of Computer Science students hailing from University College London (UCL). What brings us together is our shared passion for utilising technology as a tool to innovate and revolutionise healthcare - a sector we believe to be paramount in any country. Our team believes that technological advancements have the power to effect palpable improvements in healthcare services, boosting the efficiency to enhancing the overall standard of patient care. As part of the enriching Industry Exchange Network (IXN) program, we've been fortunate to be under the expert guidance and supervision of UCL Professor Dean Mohamedally, Dr Yun Fu, and Pr…

Background introduction When a Function App is added as an API in APIM, there are some authorization details we need to consider while communicating from APIM to the backend function app. It does not matter what Authorization level (function or anonymous) the function app has configured, APIM will always attach a function host key to the request. The host key is attached to the request as a header. However, we may experiment unauthorized errors even though the function host key is present in the request header. So, this article is focused on analyzing one of those scenarios when communication between APIM and backend function app is truncated due to unauthorized …

In today's blog post, we dive into the exciting fusion of AI large language models with Microsoft's Power Platform. With over 33 million Monthly active users of Power Platform announced at Build 2023. We explore how this powerful combination can help build automation workflows, apps, webpages, and bots without requiring extensive coding knowledge. With the introduction of AI-assisted workflow generation in Power Automate, Copilot integration with Power Apps, Power Pages for website generation, and enhanced chat experiences with Power Virtual Agents, the Power Platform is revolutionizing low-code development. Sharing 33 million monthly active users of PowerPla…

Blog Banner At Microsoft Build, 50 updates were announced and among those updates were Power Platform announcements in which we will look at one of them today. Learn how to use the Excel to App with Copilot feature which enables you to take advantage of Copilot to add data processing capabilities by helping you clean and prepare your data before you even start building the app. Copilot can now ingest any Excel file, no matter how loosely structured and create robust structured tables with a variety of data types. Find out more about Microsoft Build announcements on the Microsoft Build 2023 Book of News Earn a free certification voucher by completing at least one…

We've encountered a few support cases where customers, usually after some time, have an ASP.NET Core application hosted in IIS in-process that starts returning this "HTTP 503 Server has been shutdown" status. In all these cases a restart of the application was needed to temporarily resolve the issue until it happens again, typically a few clicks around the application later or within 10-15 minutes. This post details the most likely cause of that problem and how to fix it. As of the time of this writing I have come across 5 cases where this 503 issue was occurring. In 100% of those cases, the problem was redundant code. There were a few different ways of triggering …

This article describes how to perform a REST API request in Azure using RBAC authentication with Postman. I will use as example the Get Blob (REST API) request. Please see below how to perform a REST API request in Azure using RBAC authentication: Open the Azure Portal and go to Azure Active Directory. On left side, please create a new App registration by clicking on App registration (left side bar) and then New registration. Fill in the Name and all the information required. Inside the new app: Click on Overview and and collect the Application (client) ID value, and the Directory (tenant) ID value. Clink on Certificates & secrets and create a New Cli…

Service-Based Architectures provide a modular framework from which common applications can be deployed using components from various sources and suppliers. The 3GPP defines a Service-Based Architecture (SBA) in which the control plane functionality and common data repositories of a 5G network are delivered through a set of interconnected Network Functions (NFs), with each NF authorized to access the services of other NFs. Assuming the role of either service consumer or service producer, Network Functions are self-contained, independent, and reusable. Each Network Function service exposes its functionality through a Service-Based Interface (SBI), which employs a wel…

Last month, Authenticator Lite (in Outlook) moved to public preview, bringing the security and reliability of Microsoft Authenticator to an app users already have on their phones. Today we’re excited to announce that Authenticator Lite (in Outlook) is now generally available! According to research done by Microsoft, multifactor authentications completed via push notifications in the Microsoft Authenticator app are 71% less likely to be compromised than those completed via SMS codes. Therefore, we strongly recommend moving your users off phone transports for authentication and towards more secure methods such as push notifications. Authenticator Lite (in Outlook) e…

While Microsoft Build had much in store for Windows developers and enthusiasts, we know that many of you are focused on the now vs. what's next. That's why we've organized another edition of Windows Tech Community Live next Wednesday, May 31st—to make sure you have what you need to continue your Windows 11 or app migration projects and to help you support secure, productive, accessible experiences for everyone in your organization. Tech Community Live: Windows edition – May 31, 2023 This edition of Tech Community Live features four back-to-back Ask Microsoft Anything (AMA) sessions. Here's what's on deck. Click the title for more details! Time Ask…

OSD preferred MP option for PXE boot scenario Preferred Management Point (MP) option will now allow PXE clients to communicate to an initial lookup MP and receive the list of MP(s) to be used for further communication. When the option is enabled, it allows an MP to redirect the PXE client to another MP, based on the client location in the site boundaries. New Site Maintenance task “Delete Aged Task Execution Status Messages” is now available on primary servers to clean up data older than 30 days or configured number of days You can enable this feature by utilizing the Site Maintenance Window or using PowerShell Commandlet. By default…

Scenario: PowerShell script to get the total number of partitions in Event Hub Namespace. You must be wondering how to find out total number of partition count for any Event Hub namespace?? On the Azure portal you can only see partition count per Event Hub Entity level but not Namespace level. It’s tiresome job to manually sum up partition counts of all the entities especially when you have hundreds of event hub entities under the namespace. Here is a simple way to find out total number of Partitions under Event Hub namespace using PowerShell script. Solution: Use below PowerShell script to see the total number of Partitions under your n…

While Microsoft Build had much in store for Windows developers and enthusiasts, we know that many of you are focused on the now vs. what's next. That's why we've organized another edition of Windows Tech Community Live next Wednesday, May 31st—to make sure you have what you need to continue your Windows 11 or app migration projects and to help you support secure, productive, accessible experiences for everyone in your organization. Tech Community Live: Windows edition – May 31, 2023 This edition of Tech Community Live features four back-to-back Ask Microsoft Anything (AMA) sessions. Here's what's on deck. Click the title for more details! Time Ask…