Microsoft Support & Discussions

In the episode of Data Exposed with Anna Hoffman and Lior Kamrat, we will be talking about how to get started with Azure Arc-enabled data services, the newly announced Azure Arc-enabled SQL Managed Instance Landing Zone Accelerator and the Jumpstart ArcBox flavor – “ArcBox for DataOps." Resources: Announcing Landing Zone Accelerator for Azure Arc-enabled SQL Managed Instance Introduction to Azure Arc landing zone accelerator for hybrid and multicloud Announcing Jumpstart ArcBox for DataOps Jumpstart ArcBox for DataOps Continue reading...

There is a growing need for the deployment of tools or agents on on-premise servers in bulk. Its highly time consuming to manually deploy the agent in bulk. Microsoft Azure uses Azure Arc for the agents/tools/application deployments and can be combined with Azure policy for large scale mass deployment. In the below usecase Log Analytics and Dependency agents pushed via the policy. Agents can be deployed manually using Azure portal, though for large environment, it is recommended to push these agents via custom Azure Policy or using PowerShell automation scripting. [attachment=30121:name] Deployment using Azure Policy Below usecas…

In some situations, our applications at the moment of the connection could face this type of error message: " Error 64: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) and/or following with for System.Data.SqlClient.SqlException "A connection was successfully established with the server, but then an error occurred during the pre-login handshake." Following, I would like to share with you my experience in this type of issues. Normally, this type of error message came from a TCP layer reset (either cl…

In the episode of Data Exposed with Anna Hoffman and Lior Kamrat, we will be talking about how to get started with Azure Arc-enabled data services, the newly announced Azure Arc-enabled SQL Managed Instance Landing Zone Accelerator and the Jumpstart ArcBox flavor – “ArcBox for DataOps." Resources: Announcing Landing Zone Accelerator for Azure Arc-enabled SQL Managed Instance Introduction to Azure Arc landing zone accelerator for hybrid and multicloud Announcing Jumpstart ArcBox for DataOps Jumpstart ArcBox for DataOps View/share our latest episodes on Microsoft Learn and ! Continue reading...

Microsoft Bookings as you all know is an appointment scheduling software. A lot of customers use Microsoft Bookings for use cases such as connecting with sales leads, having virtual appointments with doctors, connecting with candidates for recruitment, appointments with tech-support among others. However, some of our customers have used it very creatively for reservations and as a ticketing system. In this blog, we will highlight some of these incredible scenarios, Bookings customers have achieved. We will also walk you through on how to configure for those use cases. Using Microsoft Bookings to reserve a parking space. We recently came across a customer w…

As we shared in November 2021, Stream (Classic) will be retired as customers transition to the new Stream platform built on SharePoint. Today, we are sharing the update that Microsoft will retire Stream (Classic) on February 15, 2024 for all customers except GCC, and we will turn off upload functionality in August 2023.1 The successor service, Stream (on SharePoint), entered general availability in October 2022, and has been widely popular since we first announced it more than two years ago. In 2022, billions of videos were uploaded to the service, and its use continues to grow rapidly because of how simple it is to create, discover, and view video across Microsoft 365. …

Microsoft Sentinel leverages machine learning technology, Fusion, to automatically detect multistage attacks by identifying combinations of anomalous behaviors and suspicious activities that are observed at various stages of the kill-chain. On the basis of these discoveries, Microsoft Sentinel generates incidents that would otherwise be difficult to catch. These incidents comprise two or more alerts or anomalies. By design, these incidents are low-volume, high-fidelity, and high-severity. To help security analysts better understand and investigate Fusion incidents, we released an investigation notebook “Guided Investigation - Fusion Incident” that is available in t…

Microsoft Bookings in Outlook is coming to help you reduce the back and forth in scheduling, while helping you maintain control of your calendar. You'll be able to keep custom bookable time (via a new event drop down in the calendar pane) to share with others so they can easily find a time to schedule a 1:1 meeting with you according to your availability and preferences. When someone books a time slot with you using your personal booking page, you will both receive an email confirmation. Attendees can update or cancel scheduled meetings with you directly from your personal bookings page.   All users with the following subscriptions will have access to Bookab…

Financial Services Industry (FSI) is one of the largest consumers of HPC environments in the cloud. To evaluate the performance of these systems, it is important to use benchmark tests that accurately reflect the type of workloads of those systems. In this article, we will attempt to benchmark the most common virtual machine types used in Azure in these environments with relevant benchmarks to the industry. One of the key considerations when choosing an HPC benchmark test is the type of workload that the system will be expected to handle. Different HPC applications have different computational needs, so it is important to select a benchmark test that reflects the spe…

With the coming of a new year, many people take the opportunity to set intentions for the future. We here on the Windows Autopatch team have chosen a single word to set the tone for 2023: more. In that spirit, we’re making more episodes of Behind the screens with Windows Autopatch – including . More represents not only the vision that drives Autopatch: help IT professionals do more with less, but also the spirit of innovation that inspires our product team. We want to make Autopatch more accessible, more useful, and more valuable to more enterprises. More resources for onboarding In order to help more enterprises get started with Windows Autopatch, the Fas…

I’ll be honest. I am not really one for New Years' resolutions. But what I have found myself doing in the new year is evaluating and working to change the way I go about my day-to-day habits. As 2022 began came to a close, I took a hard look at my ways of working and routine and didn’t really like what I saw. Getting stuck in hours of meetings in the spirit of FOMO, realizing I skipped lunch (and sometimes breakfast), or only walked a handful of steps in a day were all things I was noticing. This got me thinking about how I could improve or even enhance my hybrid work experience. Would I work better from a loft in Paris for a month (I actually did this, and the ans…

Author: Ryan Adams is a Program Manager in Azure Synapse Customer Success Engineering (CSE) team. In this post we are going to look at an example of streaming IoT temperature data in Synapse Spark. I have an IoT device that will stream temperature data from two sensors to IoT hub. We’ll use Synapse Spark to process the data, and finally write the output to persistent storage. Here is what our architecture will look like: Prerequisites Our focus for this post is on streaming the data in Synapse Spark so having a device to send data and the setup of IoT Hub are considered prerequisites. Their setup will not be covered in this article. …

SQL Insights for Azure SQL Db allow you to have a quick look into the resource usage of your Azure SQL Resource in a graphical way, but when we need to troubleshoot it, it sometimes presents a challenge. This article is based on troubleshooting done to solve a case related to the metrics that were not visible on the SQL Insights (Preview) tab. This feature SQL Insights (Preview) uses a Linux virtual machine to collect metrics for Azure SQL, and it can use credentials stored in Azure Key Vault to authenticate on the SQL Databases. First step to troubleshoot, we need to check status for the Virtual machine if it is Collecting with errors or Not Collecting. You…

With the coming of a new year, many people take the opportunity to set intentions for the future. We here on the Windows Autopatch team have chosen a single word to set the tone for 2023: more. In that spirit, we’re making more episodes of Behind the screens with Windows Autopatch – including . More represents not only the vision that drives Autopatch: help IT professionals do more with less, but also the spirit of innovation that inspires our product team. We want to make Autopatch more accessible, more useful, and more valuable to more enterprises. More resources for onboarding In order to help more enterprises get started with Windows Autopatch, the Fas…

As companies adopt Microsoft Defender, there are certain questions coming from customers in terms of EPP management. These questions are mostly focusing on Microsoft Defender management in Windows Servers. I’d like to touch base on different management options for different customer scenarios. I have on-premises environment, and I cannot move to cloud We can use legacy management options such as Active Directory GPOs and Microsoft Endpoint Configuration Manager (aka. System Center Configuration Manager - SCCM) for sure. However, these tools might not be the best possible solutions that would be agile enough - since these two options wait for a certain amount of ti…

We got an issue when our customer using Node.Js they got the following error message: Failed to connect to xyz.database.windows.net:1433 - Could not connect (sequence) at Connection.socketError (C:\...\tedious\lib\connection.js:1395:28) at C:\...\tedious\lib\connection.js:1176:14 at processTicksAndRejections (node:internal/process/task_queues:78:11) { code: 'ESOCKET', isTransient: undefined } RequestError: Requests can only be made in the LoggedIn state, not the Connecting state at Connection.makeRequest (C:\...\tedious\lib\connection.js:2204:24) at Connection.execSql (C:\...\tedious\lib\connection.js:1734:10) at executeStatement (C:\...\NodeJsVsCode\ConnectTe…

Service Fabric Explorer (SFX) is an open-source tool for inspecting and managing Azure Service Fabric clusters. Service Fabric Explorer is a desktop application for Windows, macOS and Linux. To launch SFX in a web browser, browse to the cluster's HTTP management endpoint from any browser - for example https://clusterFQDN:19080. Service Fabric explorer may not load for numerous reasons. Most frequent reasons could be access denied while trying to access or unable to choose the right certificate. Following steps provide some useful insights on investigation steps and mitigations to be followed in such scenarios. 1. Check the status of the cluster and certificate that is …

Symptoms: Uploading files using Java SDK class DataLakeFileClient fails to initiate the ADF trigger. Uploading files using Azure Portal initiates the trigger as expected. ADF trigger is configured to ignore empty blobs. Analysis: Whenever a file is created using ADLS Gen2 REST API, there are 3 operations called at the backend i.e. CreateFile, AppendFile and FlushFile. Microsoft.Storage.BlobCreated event is triggered when a blob is created or replaced. Specifically, this event is triggered when clients use the CreateFile and FlushWithClose operations that are available in the Azure Data Lake Storage Gen2 REST API. As CreateFile API c…

The MVP Program has a long-term commitment to skilling through technical communities. In this interviews series focusing on skilling initiatives, we will be highlighting MVPs who actively contributes to the Skilling Program. Jonas Rapp, Sweden Tell us a little about yourself. What is your focus as an MVP and what do you do professionally? “I’m a Business Applications MVPs. I’ve been a “developer” for close to 30 years now, but when I went into the Dynamics CRM area in 2009; I started to focus both on deployment and on development. What do I mean by that? Dynamics CRM – now Dataverse – has all the components we need for a full solution, and I can focu…

Zero Trust is a security concept that questions the traditional perimeter-based security architecture. Instead of trusting that all resources within an organization's firewall are secure, Zero Trust assumes that all access requests, regardless of origin or destination, should be considered as originating from an untrusted network. Guiding principles for the Zero Trust security strategy are as follows: Verify explicitly: All available data points must be used to authenticate and approve users, devices, and requests. Use least privilege access: Users and devices are allowed the bare minimum of access required to execute their functions, and that access is revi…

Today, I worked on a service request where our customer faced the following error: The ALTER TABLE statement conflicted with the CHECK constraint "Table1". The conflict occurred in database "DatabaseName", table "Table2". Full error message: Microsoft.Data.Tools.Diagnostics.Tracer Verbose: 0 : 2023-01-11T11:11:35 : Executing Step 341, Not Tracked, Type 'EnableConstraintsStep', Section 'None', Operation '0', Ignorable Errors 'None', Script is as follows: PRINT N'Checking constraint: table1_table2_updatedby_foreign [dbo].[Table1]'; ALTER TABLE [dbo].[Table1] WITH CHECK CHECK CONSTRAINT [table1_table2_updatedby_foreign]; Microsoft.Data.Tools.Diagnostics.Tracer E…

A Virtual Machine (VM) is like any physical laptop, smartphone, or server that we use in our day-to-day life. It has features like CPU, memory, storage size, and different networking ports with boot disk similar to the gadgets mentioned above. But these are virtual computers unlike laptops, smartphones that are physical and tangible. They exist as code and can be referred to as a computer inside a computer. Virtual machines are a part of Azure’s Infrastructure as a Service (IaaS) offering that allows you to have the flexibility of virtualization without having to invest in the underlying infrastructure. Advantages of VMs: The portability, fle…

As an Azure Sentinel user, you may have encountered the need to store and search your log data for extended periods of time. This could be due to regulatory requirements or simply as a means of maintaining a secure backup of your log data. In this blog, we'll examine the various options available for storing and searching Sentinel logs beyond the default 90-day retention period. We'll cover the main features of each option and provide guidance on how to implement them in your organization. We'll explore the options for storing and searching Sentinel logs, including their capabilities and key selection criteria. Learn how to choose the best solution for your organiz…

Registration is open for the January GCCH M365 Webinar: Connect – Collaborate – Create on Tuesday, January 24, 12-1pm EST. To register, please go here. Once registered, you will receive a calendar invite. Please feel free to forward to those who may be interested and benefit from working more productively. January agenda to include a continuation of our OneDrive sessions (part 2 of 3). Full agenda to be released prior to the event. Topics being considered include: Intranet/Hub site integration with Teams Power Automate integration with Teams Teams Live Events Microsoft Planner Thanks to everyone who participated in the November and December web…

woman and man collaborating in windows at desk on a laptop We are excited to announce a Windows 365 for Gov AMA on Tuesday, January 17th at 6:00 AM PST| 9 AM EST ! Join us as our experts discuss how you can use Windows 365 for Gov and answer your questions and collect feedback. An AMA is a live text-based online event similar to a “YamJam” on Yammer or an “Ask Me Anything” on Reddit. This AMA gives you the opportunity to connect with Microsoft product experts who will be on hand to answer your questions and listen to feedback. Feel free to post your questions about Windows 365 for Gov now through the end of the event in the Comment on this …