Microsoft Archives - Page 144 of 1135 - Dr. Ware Technology Services

Lesson Learned #262: Database Wait Stats and Log Analytics.

by Contributed | Dec 28, 2022 | Technology

This article is contributed. See the original author and article here.

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 ResourceId =~ '/SUBSCRIPTIONS/XXXX-XXXX-XXX-XXX-D6C13FEF4316/RESOURCEGROUPS/ResourceGroupName/PROVIDERS/MICROSOFT.SQL/SERVERS/Servername/DATABASES/DatabaseName'
| where TimeGenerated >= ago(10m)
| project delta_wait_time_ms_d, wait_type_s
| summarize total_wait_time_in_ms = sum(delta_wait_time_ms_d) / 1000
    by wait_type_s
| sort by total_wait_time_in_ms desc
| extend Rank=row_rank(total_wait_time_in_ms)

Once we run this query we have:

With this Kusto Query already implemented, basically, we could create an alert using the button New alert rule:

and configure the alert and the details needed:

Enjoy!

Azure Marketplace new offers – December 27, 2022

by Contributed | Dec 27, 2022 | Technology

This article is contributed. See the original author and article here.

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
	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.
	Arize AI: Get observable machine learning, model monitoring, performance management, and root cause analysis with Arize AI, an Azure-based platform that centralizes all your data sets across training, validation, and production.
	Auditmation Connection Node: Auditmation’s Connection Node allows you to seamlessly collect data from IT systems or perform IT compliance tests by connecting an organization’s Azure environment with the Auditmation audit and risk automation platform.
	AWS CLI on CentOS Stream 8: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on CentOS Stream 8. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	AWS CLI on Red Hat Enterprise Linux 9: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on Red Hat Enterprise Linux 9. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	AWS CLI on Red Hat Enterprise Linux 9.1: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on Red Hat Enterprise Linux 9.1. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	AWS CLI on Windows Server 2012 R2: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on Windows Server 2012 R2. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	AWS CLI on Windows Server 2016: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on Windows Server 2016. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	AWS CLI on Windows Server 2019: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on Windows Server 2019. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	AWS CLI on Windows Server 2022: AskforCloud has configured this virtual machine with the AWS Command Line Interface preinstalled on Windows Server 2022. The AWS CLI lets you manage your AWS services with functionality equivalent to the AWS Management Console.
	Azure CLI on Red Hat Enterprise Linux 9.1: AskforCloud has prepackaged this virtual image containing the Azure Command-Line Interface (CLI) on Red Hat Enterprise Linux 9.1. The Azure Command-Line Interface lets you manage Azure resources through a terminal or a script.
	BigDL PPML: Secure Big Data AI on Intel SGX: BigDL PPML from Intel provides a distributed privacy preserving machine learning (PPML) platform for end-to-end Big Data AI pipelines, giving you secure analysis on a trusted cluster environment running on Intel SGX and Microsoft Azure.
	CC1 – Compliance Cloud One: CC1 is a hybrid cloud solution that lets you capture audio, text, IM, video, screen shares, and other business data from Microsoft Teams for later analysis to facilitate compliance with governance and monitoring policies under multiple regulations.
	Docker Containers as a Service (CaaS): This preconfigured image from Stackhero includes Docker on Stackhero DC OS, a custom Linux distribution. Docker helps developers build, share, and run modern applications.
	Dropvault Board Rooms: Dropvault Board Rooms delivers an Azure-based solution to encrypt your board room discussions, enhancing privacy and security for document sharing, actions, voting, meetings, and other board-level activities.
	EasyDMARC: EasyDMARC delivers an AI-powered, all-in-one email security solution hosted on Microsoft Azure, providing you with tools to generate, analyze, and maintain SPF, DKIM, and DMARC records for your organization.
	eMIP: Available only in Romanian, the eMIP platform delivers a solution for implementing and managing Operational Program Human Capital (POCU) projects and business plans.
	Emissions.AI: Emissions.AI helps you analyze your data to identify opportunities to reduce emissions, fuel consumption, and costs across facilities. You’ll also be able to reduce operational inefficiencies and optimize energy consumption.
	EspoCRM: This preconfigured virtual machine image from VMLab delivers EspoCRM 7.2.7 with MySQL, Nginx, phpMyAdmin, and Docker on Ubuntu 22.04. EspoCRM is a web-based, open-source CRM platform.
	Grafana: This preconfigured image from Stackhero includes Grafana on Stackhero DC OS, a custom Linux distribution. Grafana delivers analytics and interactive visualizations through a web interface.
	HPE StoreOnce VSA 4.3.4: HPE StoreOnce delivers fast, efficient, and scalable storage for backup data through a virtual appliance hosted on Microsoft Azure. Reduce backup data storage costs with high-performance data de-duplication.
	InfluxDB: This preconfigured image from Stackhero provides InfluxDB on Stackhero DC OS, a custom Linux distribution. InfluxDB is designed to store time series data for real-time analytics.
	Kali Linux on Azure: AskforCloud has preconfigured this virtual machine image containing Kali Linux, a Debian-based distribution designed for advanced penetration testing and security auditing.
	Matomo: This preconfigured image from Stackhero provides Matomo on Stackhero DC OS, a custom Linux distribution. Matomo is an open-source analytics platform built on PHP and MySQL.
	Mercure-Hub: This preconfigured image from Stackhero provides Mercure-Hub on Stackhero DC OS, a custom Linux distribution. The Mercure-Hub server supports the Mercure protocol, allowing fast push updates to web browsers and other HTTP clients.
	Mosquitto (MQTT): This preconfigured image from Stackhero provides Mosquitto on Stackhero DC OS, a custom Linux distribution. Mosquitto is an open-source message broker implementing the MQTT protocol.
	Node.js: This preconfigured image from Stackhero provides Node.js on Stackhero DC OS, a custom Linux distribution. Node.js features a back-end JavaScript runtime environment to execute JavaScript outside a web browser.
	PHP: This preconfigured image from Stackhero provides PHP on Stackhero DC OS, a custom Linux distribution. Deploy your PHP app on a managed server for high performance and security.
	PowerShell 7.2 on Red Hat Enterprise Linux 9.1: AskforCloud has configured this virtual machine image containing Microsoft PowerShell 7.2 on Red Hat Enterprise Linux 9.1. PowerShell is a cross-platform task automation and configuration management solution.
	PowerShell 7.3 on Debian 10 Linux: AskforCloud has configured this virtual machine image containing Microsoft PowerShell 7.3 on Debian 10 Linux. PowerShell is a cross-platform task automation and configuration management solution.
	PowerShell 7.3 on Debian 11 Linux: AskforCloud has configured this virtual machine image containing Microsoft PowerShell 7.3 on Debian 11 Linux. PowerShell is a cross-platform task automation and configuration management solution.
	PowerShell 7.3 on Red Hat Enterprise Linux 9: AskforCloud has configured this virtual machine image containing Microsoft PowerShell 7.3 on Red Hat Enterprise Linux 9. PowerShell is a cross-platform task automation and configuration management solution.
	PowerShell 7.3 on Red Hat Enterprise Linux 9.1: AskforCloud has configured this virtual machine image containing Microsoft PowerShell 7.3 on Red Hat Enterprise Linux 9.1. PowerShell is a cross-platform task automation and configuration management solution.
	Product Delivery: Product Delivery from AnyLogic is a multi-method machine learning model for Microsoft Project Bonsai depicting a supply chain for a single product, from manufacturer to distributors.
	Prometheus: This preconfigured image from Stackhero provides Prometheus on Stackhero DC OS, a custom Linux distribution. Prometheus is an open-source monitoring and time series database.
	RADIUS Server – FreeRADIUS and daloRADIUS: Cloud Infrastructure Services has packaged this virtual machine containing FreeRADIUS and daloRADIUS on Ubuntu 20.04, supporting RADIUS authentication integrated with LDAP and Microsoft Azure Active Directory.
	Redis: This preconfigured image from Stackhero provides Redis on Stackhero DC OS, a custom Linux distribution. Redis is an in-memory data structure store that is used as a database, cache, and message broker.
	RStudio Server: Elm Computing has preconfigured this virtual machine image containing RStudio Server, an integrated development environment for R with popular R packages preinstalled.
	SingleStoreDB as a Service: SingleStoreDB as a Service from IBM is a fully managed elastic cloud database hosted on Microsoft Azure. With built-in high availability, the SingleStoreDB converged database delivers query performance, scalability, and resiliency.
	Stable Diffusion: Techlatest.net has preconfigured this virtual machine image with Stable Diffusion, a deep learning, text-to-image model used for generation of detailed images from text descriptions along with an intuitive web interface for easy AI image synthesis on Azure.
	ThousandEyes: ThousandEyes from Cisco gives you a real-time map of how your customers and employees experience critical apps and services across traditional SD-WAN, internet, and cloud provider networks. See beyond the edge and get visibility into dependencies.
	Ubuntu 22.04 LTS Minimal: Cloud Infrastructure Services has preconfigured this virtual machine image containing Ubuntu Minimal 22.04 LTS. Minimal images are designed for deployment at scale, optimized boot, and easier maintenance.
	WADE for Data Lakehouse: WADE automates data lakehouses and data flow orchestration to speed data preparation for machine learning (ML) and artificial intelligence. This end-to-end solution will accelerate your ML capabilities and data insight generation.
	We Transeth: We Transeth manages and implements business plans for entrepreneurs who want a software-as-a-service solution on Azure to manage their business and control data, budget, reports, and archives.
	White Hat Managed Security Services: White Hat IT Security’s managed services for medium and large enterprises provide managed detection and response (MDR) using Microsoft Sentinel and Microsoft 365 Defender, with optional connection to your Microsoft Sentinel environment.
	Workhera: Available only in Italian, Workhera provides apps for management of office and parking booking, employee engagement monitoring, and virtual badge access. Workhera integrates with Microsoft Active Directory single sign-on.
Go further with workshops, proofs of concept, and implementations
	Avanade Intelligent Manufacturing: 12-Week Implementation: Avanade will implement a minimum viable product (MVP) of its Intelligent Manufacturing solution, built on Azure Databricks Lakehouse, to enable you to gain insights and optimize operations.
	Azure Migration: Implementation: Cloud 9INE Consulting will migrate your on-premises environment to Azure. This strategic approach utilizes native Azure tools to modernize servers, virtual machines, databases, and web applications.
	Azure Virtual Desktop: 5-Day Implementation: Available only in German, primeline Solutions’ service includes the design, installation, and configuration of a complete solution on Azure Virtual Desktop, enabling your employees to securely access work from anywhere.
	Business Intelligence with Azure: 4-Week Implementation: Available only in Spanish, DATUM REDSOFT’s service helps you take advantage of your data by creating analytical dashboards with real-time business indicators using Microsoft Azure and Microsoft Power BI.
	Cloud Scale Analytics: Implementation: Veraqor will perform a complete development lifecycle to deliver a central data repository from several data sources, delivering multiple reports and dashboards built on Microsoft Power BI and Microsoft Azure.
	Data Management: 6-Day Assessment: Sparkle will identify the main pain points of data management within your organization and address issues such as data governance and technical architecture through a high-level roadmap for a solution built on Microsoft Azure.
	Data Modernization: 4-Week Implementation: Available only in Spanish, Nebulan’s database modernization service will improve the processing, reliability, performance, and cost of your data solution on Microsoft Azure. This offer includes an option to delegate backup administration.
	FleetExecuter Automated Guided Vehicle: 8-Week Implementation: MHP FleetExecuter from Porsche lets you manage your automated guided vehicle (AGV) fleet, inclusive of vehicle maker, communication protocol, and drive technologies, via a solution built on Microsoft Azure.
	Infrastructure, Application, and Database Migration: Implementation: Veraqor will deliver a fully functional solution built on Microsoft Azure, migrating and modernizing one of your app or database systems from on-premises.
	Infrastructure, Application, and Database Migration: Proof of Concept: Veraqor will design and set up a proof-of-concept migration of any app or database from one of your on-premises systems, delivering a lift-and-shift solution built on Microsoft Azure.
	Knowledge Mining on Azure: 2- to 3-Week Implementation: Information & Communication Technology will deploy a high-performing search service built on Microsoft Azure Cognitive Services to help you extract valuable information from massive sets of structured and unstructured data.
	Land Survey using Azure & Telescope: 6-Week Proof of Concept: Affine will deliver a proof of concept of its AI-based Land Survey, powered by Microsoft Azure and Affine’s Telescope, providing an end-to-end solution that converts any aerial data set into CAD site plans for the architecture, engineering, and construction (AEC) sector.
	Migration Carbon Emission Savings Calculator: 2-Week Implementation: Version 1 will deliver its Migration Carbon Emission Savings Calculator to enable you to plan, forecast, and implement your migration to Azure in a carbon-efficient and cost-saving manner. The tool compares on-premises environments to possible migration scenarios.
	Professional Services for Prisma CSPM Optimization: Palo Alto Networks will optimize your Prisma Cloud Security Posture Management (CSPM) integration on Microsoft Azure with tangible recommendations for SecOps team activities leading to enhanced playbooks, workflows, and processes.
	Unified SIEM and XDR to Modernize Security Operations: Information & Communication Technology (ICT) will assess, deploy, and configure Microsoft Sentinel and Microsoft Defender to enable you to achieve unified threat detection and response.
	Workshop Data Strategy: Available only in French, Talent Business Solutions’ workshop will guide you through recommended solutions to automate your management processes by using the Microsoft Power Platform and Azure-based solutions.
Contact our partners
365 CAD for Public Safety
365 JMS – Jail Management System
AiTat
Appsmith packaged by Bitnami
Ataccama ONE Data Catalog
Atech Cloud MSSP (MDR/XDR)
Atos Digital Enablement Platform
Azure for Data Analysis & BI in Healthcare: 6-Week Assessment
Azure Infrastructure and Database Migration: Assessment
Callbot Voxibot
Carbon
Cloud Discovery: Assessment
Cloudflare Access
Cloudflare Area1
Cloudflare Gateway
Cloudflare RBI
Cloudflare Tunnel
Connect Plans 360
Data Warehousing & Business Intelligence: 6-Week Assessment
Decentriq Media Data Clean Room
DrDoctor Digital Assessments
DriveTracer
DSharp Engine
EarthNET Data Management and Visualization
EcoStruxure for Retail
Future Seed
Gitea packaged by Bitnami
HAFN Cloud Connect: Assessment
ID Document & Biometric Verification
Infonova Digital Marketplace
IoT Platform: 4-Week Assessment
Jamf Protect for Microsoft Sentinel
Myriad
PiBi – Embedded Reports Portal
Sanctions Screening API
SecurityScorecard Ratings for Microsoft Sentinel
Signzy FY 23 Update
Thales FIDO2 Passwordless Authentication for Azure AD
Thinear Sonar
Trellis
Wokr

Software Installation Using Machine Configuration and Azure Policy

by Contributed | Dec 26, 2022 | Technology

This article is contributed. See the original author and article here.

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 to install the software.

On my local machine I have installed:

PowerShell 7.3.0

The GuestConfiguration module – version 4.2.0

The PSDscResources module – version 2.12.0.0

An Azure Storage Account with a container which will host my configuration. The virtual machine needs to be able to contact this Storage Account so make sure it has connectivity.

The next steps show the process I use to create the configuration right through to running the remediation. I’ve uploaded the script to GitHub so you can follow it through and see what I have done.

Create the Configuration and MOF File

First step is to write a DSC configuration to install the software. I’m using the built in MSIPackage resource because it allows me to specify a URL which the software can be downloaded from. Note that DSC in Machine Configuration works a little bit differently – you can’t have credentials or reboots so be aware of those limitations. My configuration looks like below.

To generate the MOF file I just run the configuration by calling it: –

A MOF file is generated – the same as a normal DSC configuration and you can have a look to see what it contains.

Create the Configuration Package Artifacts

Now I use the GuestConfiguration module to create an artifact. This command packages together my MOF file, plus all the required modules into a zip file.

I just use the generated MOF file as an input and it will create the zip file for me. Notice that the type is ‘AuditAndSet’. This is telling the configuration that it can make changes to the virtual machine. The other option is ‘Audit’ which just checks the setting and reports the compliance state.

Upload the Package to a Storage Account

I must put the zip file into a storage account – I also need to generate a SAS URL which is going to be embedded into the policy. This is so the Machine Configuration agent knows where to get the package from.

Azure Policy Creation

All that is left to do is create the Azure Policy object which will check compliance for me – and allow me to commence remediation. The GuestConfiguration module has a command to generate this for me as demonstrated below.

A couple of things to note about some of the parameters in the image above:-

PolicyID is a unique ID I generated using the New-Guid cmdlet – if you make changes or updates to the policy ensure this remains the same.

Platform – ‘Windows’ in this case – if you want to do installs on Linux you need to write class-based DSC resources to do this (will cover in a future post).

Mode is ‘ApplyAndAutoCorrect’ – this will configure the machine and correct drift as well.

Tag – allows me to have some control over how the installation is targeted. This policy will only apply to machines which have a tag called “InstallPowerShell” with the value set to true.

The last line of the code above takes the generated policy and uploads it to Azure – by default it uploads it to the subscription but you can use any method you want to create the definition.

Assign the Policy

Before we assign the machine configuration policy we need to ensure that the prerequisite policy is installed – this is the same as in the previous blog.

The machines need to have a Managed Identity enabled so they can authenticate to the GuestConfiguration resource provider.

Assign the newly created policy to a scope of your choosing – we are now ready to test.

Testing the Deployment

I have my policy assigned to a resource group – the effect is going to be DeployIfNotExists however this works a little bit differently to a normal DINE policy. To show you how this works – I’ve assigned my policy to an empty resource group as below.

As expected I can see 100% compliance because there is nothing in that resource group.

Now I’m going to build a virtual machine in that resource group and wait for policy to take effect on it. The prerequisite policies set above will go through and enable a system assigned Managed Identity and install the policy agent for me.

My compliance is still showing 100% after this is done and this is the first trick we can use to control how this is deployed. Remember I specified a tag in my policy assignment – in order to make this policy apply to that virtual machine I need to add the tag to the server.

When I do that a sequence of events start – because the resource has been updated eventually the DeployIfNotExists policy will evaluate. However, unlike a normal DINE policy what Machine Configuration does is uses the metadata in the policy definition to create a Guest Assignment resource. The most important field on this object is the “assignmentType” and it is set to null by default. This means that the virtual machine will start evaluating the assignment but will only work in an audit mode.

Here is what the policy metadata looks like: –

And if I look at the Guest Assignment object in Azure (using the Resource Graph so we can view the properties) you can see that the assignmentType is null.

At this point the virtual machine will have received the assignment and downloaded the package from the storage account – and evaluated its compliance. It reports this back to the Guest Assignment object which Azure Policy is monitoring, and we can now see the non-compliant resource in the policy view.

And here is the compliance reason: –

The second “gate” we have to control the deployment is to run the proper DeployIfNotExists effect on the deployment and I can do this using a remediation task.

This will cause the deployment to happen as stated in the policy file – and you can see the major difference is that it will set that assignmentType value to “ApplyAndAutoCorrect”.

After that remediation task is run – I can check the Guest Assignment object in the Resource Graph and notice the difference.

The virtual machine will now download the new assignment details and see that the assignmentType has changed – the next time it runs it will now perform the correction if required. Once the software is installed the server will send a report back to the Guest Assignment service – and this will update the Guest Assignment object to compliant. Azure Policy will then check that object and report back the overall compliance.

Here is what the Guest Assignment resource looks like: –

And finally, the policy will also be compliant.

There are definitely a lot of moving parts involved with Machine Configuration and some limitations at this stage – however it is the way of the future so jump in and check it out.

Disclaimer

The sample scripts are not supported under any Microsoft standard support program or service. The sample scripts are provided AS IS without warranty of any kind. Microsoft further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample scripts and documentation remains with you. In no event shall Microsoft, its authors, or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample scripts or documentation, even if Microsoft has been advised of the possibility of such damages.

Polls app in Teams meeting – FAQs

by Contributed | Dec 23, 2022 | Technology

This article is contributed. See the original author and article here.

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)		Polls app is dedicated for the polling experience in Teams
Forms		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 (singular)		Poll app is now deprecated in Teams

Note, Forms app will be replaced by Polls app in Teams meetings for polling experience, and will point to survey experience across Teams.

How can I add the ‘Polls’ app in my Teams meetings?

– Go to the selected meeting and go to the top navigation bar (as indicated below), where you can see “+” button to add an app to the current meeting

– Click the ‘+’ button to open the pop-up, where you can search for “Polls”

– Click on Polls app icon then Save it to the current meeting

Similarly, if you are trying to add Polls app during meetings, you can follow the same steps as above by adding Polls app via top navigation bar shown as below

Add ‘Polls’ during meetings

Note: Polls app is currently supported in scheduled meetings, meeting chats and group chats. However, it is not yet supported in channel meetings and 1:1 calls .

What’s the key functionalities supported in Polls?

Area	Description	Screenshots
Question types supported	· Multiple-choice Poll · Quiz · Word Cloud · Rating · Ranking
Instant Poll (in-meeting only)	During meeting, launch a poll with binary options (Yes/No, Thumb up/down etc.) by single click to engage with attendees.
My recent polls	Re-use your previously created polls
Support Image in Poll Question	Add image to poll questions
Multiple-question poll	Bundle multiple polls and launch at the same time Ask multiple questions in 1 poll with single ‘Launch’

Please follow our blog for new feature updates: Microsoft Forms Blog – Microsoft Community Hub

Why some of the responses were not shown in Word Cloud poll?

The Word Cloud poll is targeting to capture the key words from responses. We used AI to extract the key phrase and display as words in the result view. While not all responses could be extracted a key word so some of the responses may not be displayed.

The creator can check the full inputs in text by clicking “Response details” in the poll card.

Who can create and launch a poll?

Meeting organizer and presenters have the access to create a draft poll and launch it before/during/after the meeting. Attendees cannot create/launch a poll.

How can I share my draft poll with others/set a co-author?

When drafting a poll, select the ‘Allow co-presenters to edit your poll while it’s a draft poll’ option to allow other presenters/organizers in the meeting to edit/launch the poll you created.

How can I manage the result access/share results?

By selecting ‘Share aggregated result with respondents’ setting, results will be shared with respondents after you launched the poll, they can:

Directly see the poll result after they vote in the poll popup during a meeting

Or poll respondents can check poll results under Polls tab after they respond

If the ‘Share aggregated result with respondents’ setting was not selected, then poll results will only be visible to the poll creator.

Why it shows ‘Failed to create new poll’?

Currently, you can create and store up to 400 polls (max.) in Teams meetings, and a message will be shown as ‘Failed to create new poll’ (as below). In this case, you can go to forms.office.com and delete some previously created polls to free up quota for new ones.

Message	Delete previous poll

How can I submit my questions/feedbacks on Polls in Teams meeting?

Please join our community to raise questions and share your feedback/suggestions on Polls experience: Microsoft Forms Community – Teams Channel

Lesson Learned #258: Python vs Connection Refused with Login timeout expired

by Contributed | Dec 23, 2022 | Technology

This article is contributed. See the original author and article here.

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='servername.database.windows.net', user='username', password='password', database='dbname',port=1433);  

cursor = conn.cursor()
cursor.execute('select 1 as a, 2 as b')
row = cursor.fetchone()
print(f"row={row}")

cursor = conn.cursor();  
cursor.execute("SELECT 1");
row = cursor.fetchall()

conn.close()

for i in row:
    print(i)

cursor2 = conn2.cursor();  
cursor2.execute("SELECT 1");
row2 = cursor2.fetchall()

conn2.close()

for i in row2:
    print(i)

After this, we saw that a better error message description using pymsql:

File “”, line 1, in

File “src/pymssql/_pymssql.pyx”, line 653, in pymssql._pymssql.connect

pymssql._pymssql.OperationalError: (20009, b’DB-Lib error message 20009, severity 9:nUnable to connect: Adaptive Server is unavailable or does not exist (nodename.trname.northeurope1-a.worker.database.windows.net,11021)nNet-Lib error during Connection refused (111)nDB-Lib error message 20009, severity 9:nUnable to connect: Adaptive Server is unavailable or does not exist (nodename.trname.northeurope1-a.worker.database.windows.net,11021)nNet-Lib error during Connection refused (111)n’)

All points to that our customer has as a connection policy Redirect and trying to connect to the port 11021 and the new node (nodename.trname.northeurope1-a.worker.database.windows.net,11021) where the database is running, the connection is refused by any firewall/NSG. Even, as this application worked previously, we need to know that the redirect port and node might be changed.

In this case we have two options:

Review the firewall policy and outbound range from 11000-12000.

Change the connection policy to proxy using the port 1433 avoiding the redirection.

Our customer chosen to change the connection policy and they were able to connect. Finally, they are going to review the firewall policy and change the Redirect connection.

For reference: Azure SQL Database connectivity architecture – Azure SQL Database and Azure Synapse Analytics | Microsoft Learn

Enjoy!

« Older Entries

Next Entries »

Lesson Learned #262: Database Wait Stats and Log Analytics.

Azure Marketplace new offers – December 27, 2022

Get it now in our marketplace

Go further with workshops, proofs of concept, and implementations

Contact our partners

Software Installation Using Machine Configuration and Azure Policy

Development Environment

Create the Configuration and MOF File

Create the Configuration Package Artifacts

Upload the Package to a Storage Account

Azure Policy Creation

Assign the Policy

Testing the Deployment

Polls app in Teams meeting – FAQs

What’s the difference between ‘Poll’, ‘Polls’ and ‘Forms’ app in Teams?

How can I add the ‘Polls’ app in my Teams meetings?

What’s the key functionalities supported in Polls?

Why some of the responses were not shown in Word Cloud poll?

Who can create and launch a poll?

How can I share my draft poll with others/set a co-author?

How can I manage the result access/share results?

Why it shows ‘Failed to create new poll’?

How can I submit my questions/feedbacks on Polls in Teams meeting?

Lesson Learned #258: Python vs Connection Refused with Login timeout expired

Recent Posts

Recent Comments

Archives

Categories

Meta

We look forward to meeting you