سلام من میخوام سرور با مایکروسافت پیکربندی کنم مخزن بسازم شما بفرمائید کدوم گزینه رو انتخاب بکنم پیکربندی میخوام بکنم داده های دستگاه رو

​سلام من میخوام سرور با مایکروسافت پیکربندی کنم مخزن بسازم شما بفرمائید کدوم گزینه رو انتخاب بکنم پیکربندی میخوام بکنم داده های دستگاه رو  Read More

​

Hi all,

I’m using a Sliced Pivot Table to generate dynamic Charts and only realized after working on the rest of my Workbook that changing the reference week will not update the formula, leading to a #REF error

Here is an example of formulas I’m using, with reference week 42, when changing reference week with the slicer, the table will update, but the formula keeps “[NF].[Week].&[42]” returning the error message?

=GETPIVOTDATA(“[Measures].[Count of Branch 3]”,’PIVOT NF’!$Q$3,”[NF].[Week]”,”[NF].[Week].&[42]”,”[NF].[Dep]”,”[NF].[Dep].&[EXP]”)

How can I ensure that the formula updates along with the table? Am I not using GETPIVOTDATA functions correctly?

​Hi all, I’m using a Sliced Pivot Table to generate dynamic Charts and only realized after working on the rest of my Workbook that changing the reference week will not update the formula, leading to a #REF error Here is an example of formulas I’m using, with reference week 42, when changing reference week with the slicer, the table will update, but the formula keeps “[NF].[Week].&[42]” returning the error message? =GETPIVOTDATA(“[Measures].[Count of Branch 3]”,’PIVOT NF’!$Q$3,”[NF].[Week]”,”[NF].[Week].&[42]”,”[NF].[Dep]”,”[NF].[Dep].&[EXP]”) How can I ensure that the formula updates along with the table? Am I not using GETPIVOTDATA functions correctly?  Read More

​

Hi

Currently, I have a hybrid environment with AD on-premise, Azure AD sync (with password hash & SSPR), and Exchange Online. 

My goal is to force change the password at the next login from on-premise AD to MS online and vice versa. 

It’s working. When I change the password on-premise AD, MS Online prompts me to change the password. It is not working when I set the account from the Admin center to force the password change at the next login; it does not sync to on-premise AD. The domain computer will not prompt to change password. 

Thanks in advance

MS recommend to try this 

Install-Module -Name Microsoft.Graph

Connect-MgGraph -Scopes “OnPremDirectorySynchronization.ReadWrite.All”

Then run this command.

$OnPremSync = Get-MgDirectoryOnPremiseSynchronization
$OnPremSync.Features.UserForcePasswordChangeOnLogonEnabled = $true

Update-MgDirectoryOnPremiseSynchronization -OnPremisesDirectorySynchronizationId $OnPremSync.Id -Features $OnPremSync.Features

​Hi Currently, I have a hybrid environment with AD on-premise, Azure AD sync (with password hash & SSPR), and Exchange Online.  My goal is to force change the password at the next login from on-premise AD to MS online and vice versa. It’s working. When I change the password on-premise AD, MS Online prompts me to change the password. It is not working when I set the account from the Admin center to force the password change at the next login; it does not sync to on-premise AD. The domain computer will not prompt to change password.  Thanks in advance MS recommend to try this Install-Module -Name Microsoft.Graph

Connect-MgGraph -Scopes “OnPremDirectorySynchronization.ReadWrite.All”

Then run this command.

$OnPremSync = Get-MgDirectoryOnPremiseSynchronization
$OnPremSync.Features.UserForcePasswordChangeOnLogonEnabled = $true

Update-MgDirectoryOnPremiseSynchronization -OnPremisesDirectorySynchronizationId $OnPremSync.Id -Features $OnPremSync.Features    Read More

​

formula not working proprly

​formula not working proprly   Read More

​

Title:

Introducing the Open Targets Dataset: Now Available on Genomics Data Lake on Azure for Advanced Biomedical Research

Introduction

Biomedical research is accelerating at an unprecedented pace, driven by the vast amounts of data generated from genetic studies, drug development, and disease research. Today, we would like to announce that critical datasets from Open Targets are now available on Azure Genomics Open Data Lake. This data can be seamlessly integrated into your research workflows, providing a rich resource for exploring gene-disease associations, drug targets, and biomedical mechanisms.

With Azure’s cloud-based solutions, these datasets are not only easier to access, but they can also be combined with machine learning, analytics, and AI-powered tools to drive deeper insights and foster innovation in areas like drug discovery, personalized medicine, and genomics.

Dataset Overview

The Open Targets consortium is a collaborative public -private research partnership which aims to systematically identify and prioritize drug targets. Its flagship informatics platform integrates genetic and molecular evidence associating targets and diseases, and includes extensive data on the genetic basis of diseases, drugs, and the identification of potential therapeutic targets.

The Open Targets provides crucial data that integrates genetics, genomics, and drug information, enabling researchers to identify and prioritize drug targets for complex diseases. By offering insights into gene-disease associations, molecular interactions, and drug mechanisms, it supports drug discovery and development. This dataset enhances the understanding of the genetic basis of diseases and the effects of drugs, fostering better therapeutic strategies and precision medicine. It is widely used for target validation, drug repositioning, and understanding adverse drug events.

Key Datasets

This dataset offers comprehensive access to 25 different JSON and file formats, which can be seamlessly integrated into your analysis workflows. These datasets fall into the following categories:

Drug data: Mechanism of action, indications, pharmacovigilance and pharmacogenetics

Target-Disease Associations: Curated data linking specific genes to diseases, helping researchers better understand disease pathways and mechanisms.
Target, Disease, drug annotations: core annotations for molecular targets, diseases and drugs
Molecular interactions: Target interactions and supporting evidence.
Expression and Phenotypes: Baseline expressions, animal model phenotypes and gene ontology
Pathways and essentiality: Reactome pathway and DepMap essentiality for targets

Significance in research and drug development:

This rich dataset opens numerous opportunities for researchers in a variety of fields. Below are a few use cases:

Identification of Drug Targets for Alzheimer’s Disease

Publication: “Genome-wide association study identifies new loci and functional pathways influencing Alzheimer’s disease risk” by Kunkle, B.W. et al. (2019) in Nature Genetics. 

Summary: The researchers used the Open Targets dataset to integrate genetic association data with functional genomics, which helped them prioritize genes and pathways linked to Alzheimer’s disease. This approach led to the identification of potential therapeutic targets that could be further investigated for developing treatments for Alzheimer’s

Understanding Genetic Basis of Inflammatory Bowel Disease (IBD)

Publication: “Genetic risk factors for inflammatory bowel disease” by de Lange, K.M. et al. (2017) in Nature Genetics.

Summary: This study leveraged the Open Targets dataset to identify and prioritize genetic variants associated with IBD. By linking genetic associations to specific genes and pathways, the researchers gained valuable insights into the mechanisms underlying the disease, which could inform the development of new therapeutic strategies

Drug Repurposing for COVID-19

Publication: “Drug repurposing for COVID-19: a systematic review” by Zhou, Y. et al. (2020) in Nature Reviews Drug Discovery.

Summary: The researchers used the Open Targets dataset to analyze and prioritize drug targets for COVID-19. This analysis helped them identify existing drugs that could be repurposed for treating COVID-19, providing a list of potential candidates for clinical trials

Availability

How to Access the Dataset on Azure

** Please note**  

We are enabling public access to all Genomics Data Lake containers. The existing “signed URLs” (shared access signatures) will be retired at: 2024-11-04T00:00:00Z. After this time, the URLs without a query string will continue to work, however the “signed URLs” will no longer work and will return a 403 HTTP status code. Please plan accordingly to access the public URLs without a query string after this date (remove the ‘?’ and trailing characters)

Accessing this dataset on Azure is straightforward and can be integrated into a variety of Azure services for analysis and visualization. Here’s how you can get started:

Using AzCopy

Prerequisites:

AzCopy must be installed on your machine. Download AzCopy here.

Steps:

Get the SAS URL of the blob container or file you want to download. The url can be found here
Open your command line (e.g., Command Prompt, Terminal, or PowerShell).
Run the following command to download data from the Azure Blob storage:

azcopy copy “https://datasetopentargets.blob.core.windows.net/dataset//17.02/17.02_association_data.json.gz” “C:UsersYourUserDownloads”

 This will copy the blob “17.02_association_data.json.gz” to your Downloads directory

Using Python SDK

#Install the Azure Storage Blob library for Python
pip install azure-storage-blob

Import the necessary libraries
from azure.storage.blob import BlobClient
import os

#Download the blob by specifying the SAS URL and the local file path.
sas_url = “https://datasetopentargets.blob.core.windows.net/dataset/17.02/17.02_association_data.json.gz?sv=2023-01-03&st=2024-10-24T21%3A20%3A22Z&se=2026-10-25T21%3A20%3A00Z&sr=c&sp=rl&sig=9EI4PbUvTkT%2F0jUCg5aNLP5CBlu1bUDsyK6TDFzZacw%3D”

local_path = “path/to/save/file”

#Create BlobClient
blob_client = BlobClient.from_blob_url(sas_url)

#Download the blob content to a local file
with open(local_path, “wb”) as download_file: download_stream = blob_client.download_blob() download_file.write(download_stream.readall())

Run the script. The blob will be downloaded and saved to the specified location.

Using Azure Storage Explorer

Prerequisites:

Download and install Azure Storage Explorer.

Steps:

Open Azure Storage Explorer.
Connect to your Azure account by clicking “Add an Account” or use the “Connect to Azure Storage Container”

Choose “Use a shared access signature (SAS) URI” and paste the SAS URL for your blob container. OR
Choose “Anonymously (my blob container allows public access)” [after 11/19/2024 since public access will be unabled on all dataset]

Navigate to the Blob Container in the left-hand panel where your data is stored.
Right-click on the blob or folder you want to download and select “Download”.
Select the destination folder on your local machine.
The blob data will be downloaded to the specified location

We encourage researchers to explore the Open Targets dataset to accelerate breakthroughs in target prioritisation!

Acknowledgements:

We would like to Annalisa Buniello, Manuel Bernal Llinares, Roberto LLeras and Matt Mcloughlin for helping us make the data available on Azure and Helena Cornu for help with the blog.

​Microsoft Tech Community – Latest Blogs –Read More 

I have a microsoft account in form <name> at <myowndomain.com>. If i send email in outlook the sender adress is  <name> at <myowndomain.com> as expected. However, when i send a calendar invite the outlook invite shows as sender outlook_<lotsofcharacters>@outlook.com and it is impossible to respond to this address (bounces back). How can i change the calendar invites to show <name> at <myowndomain.com>as sender like i can do in email?

​I have a microsoft account in form <name> at <myowndomain.com>. If i send email in outlook the sender adress is  <name> at <myowndomain.com> as expected. However, when i send a calendar invite the outlook invite shows as sender outlook_<lotsofcharacters>@outlook.com and it is impossible to respond to this address (bounces back). How can i change the calendar invites to show <name> at <myowndomain.com>as sender like i can do in email?  Read More

​

I use amazon connect softphone. When I go on break, locking my computer or sometimes even when my laptop not locked but just Idle / there is no activity while i wait for a call on my laptop for about 10 , 15 minutes I notice error stating webrtc issue or Network issue on the phone. I checked sleep settings and it is set to never. Happens on all browser(Chrome, Edge) I use. If i stay active i do not notice the issue. Happens only to me. My colleagues with same network do not notice issue.
Set the URL to all keep this keep this site active list did not help. 
I am wondering if there is any windows settings that could fix this. 

​I use amazon connect softphone. When I go on break, locking my computer or sometimes even when my laptop not locked but just Idle / there is no activity while i wait for a call on my laptop for about 10 , 15 minutes I notice error stating webrtc issue or Network issue on the phone. I checked sleep settings and it is set to never. Happens on all browser(Chrome, Edge) I use. If i stay active i do not notice the issue. Happens only to me. My colleagues with same network do not notice issue.Set the URL to all keep this keep this site active list did not help. I am wondering if there is any windows settings that could fix this.   Read More

​

Hi,

I’m facing a problem I still can’t find a solution to.

Short description below.

ESXi virtualization environment has a Windows Server 2016 Datacenter installed. 

The Server has AD switched on, for the sake of our discussion I’m naming it “contoso.local”.

There are shared resources on the virtualized server such as shared folders and files, also there is MS SQL server which receives incoming connections from Windows clients (Win10/11).

What do I need to achieve?

I need to create another virtualized Windows Server 2016 Datacenter or Standard which will be an alternative server that will start offering its services immediately in case of the another server failure. What do I mean by  “immediately” here?

I mean, the switching procedure/time must be immediate and all the resources such as shared folders or SQL databases must be up-to-date. So, if at 1:00 PM the first server has a failure (disconnected, shut down by mistake etc), the other server must take control of the client machines at 1:05 PM. And as I mention all shared resources and SQL connections must stay the same but on the second server. The users on client machines can’t have their work disrupted (any open Word documents in shared foilders intact or financial software connections kept on). 

I’m aware of the fact that the second server must be a sort of replica that works all the time and receives data from the server so it must be a 1-1 copy of all data that it constantly updates itself with new data coming from the first server.

The question is – how can this be done ? I tried Cluster failover, storage replica already but this mechanism didn’t work out. I created two disks (logs, data) according to step-by-step instructions but it is still not a solution to the problem. 

I’ll appreciate any advice to my issue 

​Hi,I’m facing a problem I still can’t find a solution to.Short description below.ESXi virtualization environment has a Windows Server 2016 Datacenter installed. The Server has AD switched on, for the sake of our discussion I’m naming it “contoso.local”.There are shared resources on the virtualized server such as shared folders and files, also there is MS SQL server which receives incoming connections from Windows clients (Win10/11).What do I need to achieve?I need to create another virtualized Windows Server 2016 Datacenter or Standard which will be an alternative server that will start offering its services immediately in case of the another server failure. What do I mean by  “immediately” here?I mean, the switching procedure/time must be immediate and all the resources such as shared folders or SQL databases must be up-to-date. So, if at 1:00 PM the first server has a failure (disconnected, shut down by mistake etc), the other server must take control of the client machines at 1:05 PM. And as I mention all shared resources and SQL connections must stay the same but on the second server. The users on client machines can’t have their work disrupted (any open Word documents in shared foilders intact or financial software connections kept on). I’m aware of the fact that the second server must be a sort of replica that works all the time and receives data from the server so it must be a 1-1 copy of all data that it constantly updates itself with new data coming from the first server.The question is – how can this be done ? I tried Cluster failover, storage replica already but this mechanism didn’t work out. I created two disks (logs, data) according to step-by-step instructions but it is still not a solution to the problem. I’ll appreciate any advice to my issue   Read More

​

We are moving away from a HRMS that does performance management and want to use Viva Goals for all of our individual/team/organizational goals. Our organization still has a desire to do paid for performance structure requiring us to find a Performance Review process that we can use with Viva Goals data. Has anyone used Power Automate to create a review process leveraging the Viva Goals data?

​We are moving away from a HRMS that does performance management and want to use Viva Goals for all of our individual/team/organizational goals. Our organization still has a desire to do paid for performance structure requiring us to find a Performance Review process that we can use with Viva Goals data. Has anyone used Power Automate to create a review process leveraging the Viva Goals data?  Read More

​

Today, we are excited to announce the General Availability of Inbound SMTP DANE with DNSSEC! This new capability of Exchange Online enhances the security of email communications by supporting two security standards: DNS-based Authentication of Named Entities (DANE) for SMTP and Domain Name System Security Extensions (DNSSEC).

Instructions for implementing it in your tenant are at How SMTP DNS-based Authentication of Named Entities (DANE) secures email communications. We are actively updating documentation to remove the Preview verbiage.

SMTP DANE and DNSSEC

SMTP DANE with DNSSEC provides a secure connection between sending and receiving mail servers that is resistant to both TLS-downgrade attacks and adversary-in-the-middle attacks (a form of eavesdropping where the communication is monitored or modified by a bad actor).

Here’s how it works:

DNSSEC: Protects DNS queries from tampering by ensuring the integrity of DNS records using cryptographic signatures. It prevents attacks like DNS spoofing.
DANE for SMTP: Uses DNSSEC to securely advertise TLS (Transport Layer Security) certificates for email servers via the TLS Authentication (TLSA) DNS record. It allows email servers to enforce encrypted communication (SMTP over TLS) and ensures that connections are only established with servers using valid certificates.

Security and Compliance benefits from SMTP DANE with DNSSEC

Using SMTP DANE with DNSSEC has many security and compliance benefits:

Prevents downgrade attacks: Ensures email communication always uses TLS, preventing fallback to insecure connections.
Stronger security: Validates server identities via trusted DNSSEC-backed records, making adversary-in-the-middle attacks harder.
Integrity and confidentiality: Guarantees email data is encrypted, and the recipient server is authenticated, better protecting your email domain(s) from impersonation.
Compliance: Use SMTP DANE with DNSSEC to enhance your email reputation by demonstrating compliance with industry security standards.

Expanding Email Security

Outbound SMTP DANE with DNSSEC was released in 2022, and general availability for Inbound SMTP DANE with DNSSEC has now happened. Inbound SMTP DANE with DNSSEC will continue to be included in enterprise and consumer email offerings at no charge, as part of our efforts to improve email security. Other email providers and domain owners are encouraged to adopt these standards to collectively enhance email security and protect users from malicious actors.

Inbound SMTP DANE with DNSSEC has already been implemented for several Outlook email domains, and implementation for the remaining Outlook and Hotmail domains for consumer email is expected to be completed by the end of 2024.

Exchange Online is looking forward to the impact that SMTP DANE with DNSSEC will have on the email security landscape and is deeply committed to delivering an email offering with industry-leading security such as SMTP DANE with DNSSEC.

Email Security Roadmap

Our target dates for upcoming roadmap items are:

December 2024 – Inbound SMTP DANE with DNSSEC and MTA-STS report in the Exchange admin center
December 2024 – March 2025

Deploying Inbound SMTP DANE with DNSSEC for all consumer Outlook and Hotmail domains (as an example – hotmail.nl)
Transition provisioning of mail records for all newly created Accepted Domains into DNSSEC-enabled infrastructure underneath *.mx.microsoft

May 2025 – Mandatory Outbound SMTP DANE, set per-tenant/per-remote domain

Learn more about the provisioning change at Implementing Inbound SMTP DANE with DNSSEC for Exchange Online Mail Flow.

Learn more about .microsoft and its subdomains at Introducing cloud.microsoft: a unified domain for Microsoft 365 apps and services.

Feedback

We welcome your feedback on Inbound SMTP DANE with DNSSEC, especially the enablement process. Please comment on this post if you have any feedback or concerns, and we will respond or contact you directly as needed.

Microsoft 365 Messaging Team

​Microsoft Tech Community – Latest Blogs –Read More