Microsoft Support & Discussions
Free PC Help Forum microsoft products support and discussions. If you need help with Microsoft Windows, Windows Server software, Microsoft 365, Microsoft Azure or any other Microsoft product you can post here. If you want to discuss Microsoft and their line of products you can do that here also.
84,928 topics in this forum
-
Security Update Guide Improvement – Representing Hotpatch Updates
by Guest Lisa Olson- 0 replies
- 0 views
Today we are updating the way Microsoft Security Update Guide (SUG) represents the Windows Hotpatch feature to make it easier for users to identify the hotpatch and security updates. Hotpatching was introduced a year ago as a new way to install updates on supported Windows Server Azure Edition virtual machines (VMs) without requiring a reboot … Security Update Guide Improvement – Representing Hotpatch Updates Read More » Continue reading...
-
Feature Focus with Microsoft MVPs: S6-6 - Microsoft 365 Dynamic Groups & Viva Insights
by Guest Stephen Rose- 0 replies
- 0 views
Thanks to all of you who checked out MVP Feature Focus 6 featuring Dan Rey where we talked about Microsoft 365 Dynamic Groups & Karoliina Kettukari shares insight on Viva Insights from a team managers point of view. If you missed the episode, you could catch it, and previous episodes, here: aka.ms/InsideMSTeams. To continue those conversations, please check out their blogs below! And as always, we welcome your feedback on what we can continue to do to help make the show a key resource in your deployment, adoption, management, and securing of Microsoft Teams. Microsoft 365 Dynamic Groups with Dan Rey Dan Rey | LinkedIn Dan Rey has been Mi…
-
SharePoint Roadmap Pitstop: December 2022
by Guest Mark Kashman- 0 replies
- 0 views
Happy holidays. We hope you’ve found time to relax and unwind a little. Our wish is that you got to where you wanted to be without delay. And that the balance of work and life found balance with the spoils of some good living. Beyond time off, our teams spent most of December refining the cloud, improving it for your return to work – whenever that may be, maybe already, maybe not until the early dawn of 2023. Below and in the related podcast, you’ll find details about all the new offerings: Microsoft Syntex Pay-as-you-go (Preview), search video transcript for Stream (on SharePoint), SharePoint Apps: Add to teams when enabling an app, OneDrive: Sensitivity labels ap…
-
Create custom attributes that uses multiple choices in Microsoft Purview
by Guest schandra- 0 replies
- 0 views
We know that Managed attributes in Microsoft Purview is helpful to enrich technical assets and help a data consumer get more context about the asset to which it is applied. In order to create these Managed Attributes, the Purview UI does a very good job and is probably the easiest and recommended approach. At the same time, Purview also offers the flexibility to create them using APIs. Here is an example: Use new APIs available with Atlas 2.2. - Microsoft Purview | Microsoft Learn But, I was looking for a way to create an attribute that uses multiple choice in the “Field type” rather than using the text (from the example in the link above). Below is an appr…
-
-
- FPCH Admin
- 0 replies
- 0 views
Today we are updating the way Microsoft Security Update Guide (SUG) represents the Windows Hotpatch feature to make it easier for users to identify the hotpatch and security updates. Hotpatching was introduced a year ago as a new way to install updates on supported Windows Server Azure Edition virtual machines (VMs) without requiring a reboot after installation.
Last reply by Cloaked, -
-
Azure Data Community Newsletter Nov/Dec 2022
by Guest RieMerritt- 0 replies
- 0 views
It’s been almost 6 months since Deborah, Hemantgiri and Michael joined the Azure Data Community Council. According to Michael, the role of the council is as advertised: hands-off with the focus to identify challenges and roadblocks in the community, identifying potential solutions and making this recommendation to the community. The focus of this year has been connecting and reaching out to the growing Azure Data Community. We have been fortunate enough to have had the opportunity to connect in person at a few of the larger events, namely SQLBits, Azure Data Conference and PASS Summit. Each of these provided different opportunities for people to reconnect & network an…
-
Prevent accidental deletions at scale using Azure Policy
by Guest kenieva- 0 replies
- 0 views
Azure Policy is happy to introduce a new preview effect: DenyAction! Unlike other effects that focus on resource configurations, the denyAction effect will block requests based on intended action, regardless of user permissions. Today this new effect supports deletions, but it's set up to handle other types of actions in the future. With the at-scale power of Azure Policy and the ability to block delete calls, denyAction allows you to prevent accidental deletions of your critical resources. Sample denyAction definition that blocks delete calls on any virtual machines: You are able to create these definitions in Portal or API. All denyAction definition…
-
Lesson Learned #262: Database Wait Stats and Log Analytics.
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Yesterday, we received a question from our customer that needs to know if it is possible to receive an email or alert about the main database wait stats usage for performance monitoring. Following, I would like to share an example how to do it. Once we have enabled in our database the option of diagnostics setting to capture the database wait statistics this information will be saved in a specific table AutoDiagnostics in the Category DatabaseWaitStatistics. Basically, we need to filter by the resource that we want to monitor and add some logic to calculate the delta. AzureDiagnostics | where Category == "DatabaseWaitStatistics" | where Resou…
-
ADX Web Explorer updates – December 2022
by Guest Michal_Bar- 0 replies
- 0 views
Welcome to the December 2022 update. We are excited to announce new features and improvements in ADX web explorer. Continue reading to learn more about: Ingest preexisting Event Hub events JPath viewer KQL editor Find my partner dashboard Ingest preexisting Event Hub events ADX can now ingest Event Hub data that existed before the creation of an Event Hub data connection in your ADX cluster. You can use this feature by entering the Event retrieval start date on the Kusto Web UI ingestion wizard (One-Click) JPath Viewer JPath notation describes the path to one or more elements in a JSON document. Using the JPath viewer in a…
-
Lesson Learned #261: Java vs Permission denied: connect
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Today, I worked on a service request that our customer got the following error message using Java code: Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host servername.database.windows.net, port 1433 has failed. Error: "Permission denied: connect. Verify the connect ion properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall." or "Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host nodename.tenantring.northeuro…
-
Lesson Learned #260: Java vs Connection is closed error message.
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Today, I worked on a service request that our customer got the following error message using Java code: Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1202) at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(SQLServerStatement.java:1063) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:445) at testconnectionms.SQLTest.main(SQLTest.java:64). I would like to share…
-
Lesson Learned #259: Capturing all blocking TSQL in Azure SQL DB and Managed Instance
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
Today, I worked on a service request that our customer is looking for all blocking issues that is happening in their database. We have many articles about it Lesson Learned #22: How to identify blocking issues? - Microsoft Community Hub and in Diagnostics Settings and QDS we can collect this information but all points to that we cannot see the TSQL that is blocking and TSQL command that is blocked in an easy way. In the following script that I share as a script example we could take this one. First of all, please, remember that a blocking issue is normal and fundamental for any RDBMS. This script is basically when you need to understand what is happening to improv…
-
OT Cloud Enablement - Cloud Adoption Models
by Guest sameeraman- 0 replies
- 0 views
Over the past few years, we have assisted mining and manufacturing organisations in adopting the cloud to stay competitive by utilising the latest cloud technologies. We have observed that some organisations prefer to follow a Segregated Model, where there is a requirement to separate the Operational Technology (OT) and Information Technology (IT) environments in the cloud. This is often the case for large organisations where the operational priorities for OT (Integrity, Availability and Confidentiality) differ from IT (Confidentiality, Integrity, and Availability). On the other hand, other organisations, typically small to medium-sized, prefer to adopt a Converged…
-
How Azure Front Door cache can help protect against DDoS attacks
by Guest DanielLarsenNZ- 0 replies
- 0 views
Recently at work I have been helping customers protect websites that have been impacted by DDoS attacks, specifically layer 7 application attacks, which take a website offline by overwhelming it with HTTP requests. These types of attacks are relatively easy for attackers to automate and execute via bot networks, and are particularly effective against web services that use older web frameworks and content management systems. A DDoS attack can completely disable a website that is not adequately prepared. The good news is that cloud computing platforms like Microsoft Azure provide global services like Azure Front Door that help protect from DDoS attacks, providing several…
-
-
- FPCH Admin
- 0 replies
- 242 views
Surface was created 10 years ago to reimagine how we work, how we connect and how we create – to empower more. As we celebrate a decade of innovation, we reflect on our top 10 notable features, initiatives and core principles that defined Surface and transformed organizations. 1. Category-defining form factors Surface became known for its industry-leading design innovation, starting with the 2-in-1 Surface Pro. We continue to create groundbreaking new form factors, including Surface Laptop Studio with full work flexibility; the 28" Surface Studio, enabling your best creative work; Surface Laptop, our most loved device; Surface Go and Surface Laptop Go, …
Last reply by AWS, -
-
December in HLS – Teams Productivity Summit, Microsoft Purview, and More
by Guest espencer38985- 0 replies
- 0 views
Welcome to the monthly Healthcare and Life Sciences blog recap, December edition! Check out the highlights below: Microsoft Teams Productivity Summit ServiceNow Integration: Learn how you can integrate ServiceNow with Microsoft Teams. Watch the episode here. Employee Engagement with Viva Engage: Did you know Yammer had a makeover? See how Viva Engage (formerly Yammer) can help increase employee engagement. Learn more here. Teams Phone Ignite Updates: Did you miss some of the ignite announcements? In this episode, hear all of the Teams Phone updates announced at Ignite. See the updates here. Microsoft Approvals and eSign Integration: In this episode, learn …
-
2022 in Review
by Guest Microsoft Excel- 0 replies
- 0 views
Wrapping up 2022, we on the Excel team are incredibly grateful to you for the opportunity to delight you with continued improvements and innovations in Excel. Throughout the year, we’ve followed up on your feedback with autocomplete for dropdown lists, automatic data conversion settings, new paste option using Crtl+Shift+V, and more. We’ve also doubled down on the core fundamentals, collaboration, and ease of use, delivering new capabilities like check performance, new text and array functions, new DAX functions in data models and Power Pivot, Excel Live, formula suggestions and formula by example – not to mention continued improvements to Power Query, assig…
-
Azure Marketplace new offers – December 27, 2022
by Guest Brady-B- 0 replies
- 0 views
We continue to expand the Azure Marketplace ecosystem. For this volume, 103 new offers successfully met the onboarding criteria and went live. See details of the new offers below: Get it now in our marketplace [attachment=29100:name] AnalyticVue: AnalyticVue delivers a secure, Azure-based platform that transforms raw K-12 data from multiple school district systems into unified insights to empower district administrators, curriculum administrators, principals, students, teachers, and parents. [attachment=29101:name] Arize AI: Get observable machine learning, model monitoring, performance management, and root cause analysis with Arize AI, an Azur…
-
Azure Synapse MVP Corner - November 2022
by Guest pawelpotasinski- 0 replies
- 0 views
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…
-
Error when viewing audit files for Azure SQL Managed Instance in SSMS.
by Guest AhmadNassar- 0 replies
- 0 views
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…
-
How to Troubleshoot Deny Policy Step by Step
by Guest zoeylan- 0 replies
- 0 views
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…
-
Quickstart: Manual Effect in Azure Policy
by Guest Yi_Yang- 0 replies
- 0 views
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…
-
Software Installation Using Machine Configuration and Azure Policy
by Guest Anthony_W- 0 replies
- 0 views
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…
-
Polls app in Teams meeting - FAQs
by Guest Liu_Aaron- 0 replies
- 0 views
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…
-
Lesson Learned #258: Python vs Connection Refused with Login timeout expired
by Guest Jose_Manuel_Jurado- 0 replies
- 0 views
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…