Tag Archives: microsoft
Extracting common data into columns
Hi,
I wonder if anyone can help explain how I can create an alternative view for a big data set I have.
For the sake of this question, I have created an illustration of what I am trying to achieve.
There are two columns (Category & Value) in a data set that I need to appear on a separate sheet, but instead the Category needs to be the column title and the values that fall within this category listed below it – is this possible please?
Hi, I wonder if anyone can help explain how I can create an alternative view for a big data set I have. For the sake of this question, I have created an illustration of what I am trying to achieve. There are two columns (Category & Value) in a data set that I need to appear on a separate sheet, but instead the Category needs to be the column title and the values that fall within this category listed below it – is this possible please? Read More
Microsoft Commercial Marketplace – Customer Office Hours
The Microsoft Commercial Marketplace Customer Office Hours are a golden opportunity to understand the marketplace from a customer’s perspective.
These events feature 30-minute presentations on topics like procurement optimization, private offers, and getting started in the marketplace, followed by Q&A sessions.
Especially for new ISVs, these insights are crucial for tailoring your offerings and navigating the ecosystem effectively. Don’t miss out on these sessions to enhance your strategy and connect with your audience more deeply.
Here’s the link: https://microsoftcloudpartner.eventbuilder.com/CustomerQ&A
The Microsoft Commercial Marketplace Customer Office Hours are a golden opportunity to understand the marketplace from a customer’s perspective.These events feature 30-minute presentations on topics like procurement optimization, private offers, and getting started in the marketplace, followed by Q&A sessions.Especially for new ISVs, these insights are crucial for tailoring your offerings and navigating the ecosystem effectively. Don’t miss out on these sessions to enhance your strategy and connect with your audience more deeply.Here’s the link: https://microsoftcloudpartner.eventbuilder.com/CustomerQ&A Read More
Unified Sentinel and playbooks
Hi all
It’s been a few weeks now since the unified Sentinel experience dropper publicly and I’ve been running that since then. It was alot of bells, whistles and hype build since the Ignite event but I feel like…meh, now what.
What happened to playbooks? What happened to all the automations we had that enriched events into the the audit logs in Sentinel for correlation?
These are either gone or not working as intended anymore. Before the “unification” we had an incident come in from our firewalls with a blocked URL which was enriched from externa threat intelligence sources and could be closed within minutes by an operator after scrolling the audit log. Now it seems the idea is for the operator to click around in the Defender portal and view the different pages for similar information, not to mentioning the seemingly nesessity for the Microsoft Intelligence platform, before the operator can determine the posture of an incident. It feels like we took a step back.
Peace
/Fredrik
Hi allIt’s been a few weeks now since the unified Sentinel experience dropper publicly and I’ve been running that since then. It was alot of bells, whistles and hype build since the Ignite event but I feel like…meh, now what.What happened to playbooks? What happened to all the automations we had that enriched events into the the audit logs in Sentinel for correlation?These are either gone or not working as intended anymore. Before the “unification” we had an incident come in from our firewalls with a blocked URL which was enriched from externa threat intelligence sources and could be closed within minutes by an operator after scrolling the audit log. Now it seems the idea is for the operator to click around in the Defender portal and view the different pages for similar information, not to mentioning the seemingly nesessity for the Microsoft Intelligence platform, before the operator can determine the posture of an incident. It feels like we took a step back. Peace/Fredrik Read More
Disappointing Session Schedule for M365 Conference
The M365 Conference takes place in Orlando, FL from April 28 to May 2, 2024. I have two sessions, but my attempts to find sessions that cover all of Microsoft 365 failed because there’s no coverage of Entra ID and Exchange Online. Instead, the Microsoft priorities like Copilot, Viva, and SharePoint take front and center stage. I think that’s a pity, but maybe the reason is because speakers don’t submit sessions covering Entra ID and Exchange Online topics?
https://office365itpros.com/2024/04/22/m365-conference-2024/
The M365 Conference takes place in Orlando, FL from April 28 to May 2, 2024. I have two sessions, but my attempts to find sessions that cover all of Microsoft 365 failed because there’s no coverage of Entra ID and Exchange Online. Instead, the Microsoft priorities like Copilot, Viva, and SharePoint take front and center stage. I think that’s a pity, but maybe the reason is because speakers don’t submit sessions covering Entra ID and Exchange Online topics?
https://office365itpros.com/2024/04/22/m365-conference-2024/
Read More
Upcoming Microsoft 365 Product Connect for CSPs Q4 | Live Webinar
Don’t miss our upcoming Live Webinar | Microsoft 365 Product Connect for CSPs on May 16, 2024. Our quarterly live webinar series shares the most relevant and important product news for CSP partners.
Modern Work product experts will cover new and upcoming product news, promotions, and program announcements that include Microsoft 365, Copilot for Microsoft 365, Microsoft Teams, Security, Windows 365, and more!
Date: May 16, 2024
Americas/EMEA: 8:00 AM-9:00 AM PT
APAC: 5:00 PM-6:00 PM PT
If you have Modern Work product questions, please submit in advance by May 2nd using the Microsoft 365 CSP Partner Connect questionnaire. Questions will be reviewed and answered during this session. Our goal is to answer as many as possible during the live event!
Don’t miss our upcoming Live Webinar | Microsoft 365 Product Connect for CSPs on May 16, 2024. Our quarterly live webinar series shares the most relevant and important product news for CSP partners. Modern Work product experts will cover new and upcoming product news, promotions, and program announcements that include Microsoft 365, Copilot for Microsoft 365, Microsoft Teams, Security, Windows 365, and more! Date: May 16, 2024Americas/EMEA: 8:00 AM-9:00 AM PT APAC: 5:00 PM-6:00 PM PT
If you have Modern Work product questions, please submit in advance by May 2nd using the Microsoft 365 CSP Partner Connect questionnaire. Questions will be reviewed and answered during this session. Our goal is to answer as many as possible during the live event! Read More
SQL MI Restore with valid SAS key failing with Operating System Error 86
On a recent case, a customer was trying to restore a database from a storage account using a SAS token when they received the below error.
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Additional information:
Cannot open backup device
‘https://storage.blob.core.windows.net/container/dbbackup_2024_03_21_121901.bak‘
Operating system error 86(The specified network password is not correct.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
To ensure that the SQL Managed Instance could successfully connect to the storage account, we checked that it was not behind a firewall in Azure.
We also used a SQL Agent job to check connectivity was successful using this blog post.
After confirming connectivity was successful, the final check was to test the SAS token.
To do this, we used the SSMS restore GUI to connect to the storage account using the same token, which was successful and allowed us to browse and select a backup file.
Despite everything looking well, the restore was still failing.
In the end, we dropped and recreated the credential, which solved the issue.
DROP CREDENTIAL [https://storageaccount.blob.core.windows.net/container]
GO
CREATE CREDENTIAL [https://storageaccount.blob.core.windows.net/container]
WITH IDENTITY = N’SHARED ACCESS SIGNATURE’,
SECRET = N’SAS_TOKEN’
GO
Disclaimer
Please note that products and options presented in this article are subject to change. This article reflects the behaviour from April 2024.
I hope this article was helpful for you, please feel free to share your feedback in the comments section.
Microsoft Tech Community – Latest Blogs –Read More
Tracking a file using its Hash Value
Hi, I want to track files based on the SHA256 generated hash value. And while I am aware of the n number of tables in Log Analytics, it there any other way to accomplish this?
For example if I want to track a file going out to an external email address, I want to be notified. I thought of transport rules but those don’t seem to be useful for this use case. However I did find some records through Advanced Hunting, but it tracks only files identified as spam/phish/malware etc.
Is there any way to track ALL files without Defender for Endpoint Solutions?
Thanks in advance!
Hi, I want to track files based on the SHA256 generated hash value. And while I am aware of the n number of tables in Log Analytics, it there any other way to accomplish this?For example if I want to track a file going out to an external email address, I want to be notified. I thought of transport rules but those don’t seem to be useful for this use case. However I did find some records through Advanced Hunting, but it tracks only files identified as spam/phish/malware etc.Is there any way to track ALL files without Defender for Endpoint Solutions? Thanks in advance! Read More
iFrame Microsoft bookings, “grey” part too big
Hi
I want to embed a bookings page with iFrame. Sadly the “grey” part is using a lot of space and the “main” part of bookings page is way too small. Even if it is not embedded, the “grey” part uses a lot of space. Is there a way to reduce/remove that?
greetings
Hi I want to embed a bookings page with iFrame. Sadly the “grey” part is using a lot of space and the “main” part of bookings page is way too small. Even if it is not embedded, the “grey” part uses a lot of space. Is there a way to reduce/remove that? greetings Read More
Unable to set TeamsFilePolicy
Hi,
I’m trying to update a policy value from teams, the ‘CsTeamsFilePolicy’. All the documentation redirects to use powershell.
Documentation – Teams native file upload policy
Documentation – Turn off teams native file upload policy
Every time I try to update this value or create a new CsTeamsFilesPolicy the error ‘DefaultFileUploadAppId must be a GUID value’ appears:
I don’t see this property in the cmdlet, either reported anywhere.I have tried with 3 different tenants and all raise the same errorI don’t see this configuration in the graph API, so I can’t manipulate elsewhereI tried to downgrade the module versionI don’t see any changes to this cmdlet in the releases page
So don’t really know if I’m doing something wrong or if the cmdlet it’s broken.
Thanks
Hi, I’m trying to update a policy value from teams, the ‘CsTeamsFilePolicy’. All the documentation redirects to use powershell. Documentation – Teams native file upload policy Documentation – Turn off teams native file upload policy Every time I try to update this value or create a new CsTeamsFilesPolicy the error ‘DefaultFileUploadAppId must be a GUID value’ appears: I don’t see this property in the cmdlet, either reported anywhere.I have tried with 3 different tenants and all raise the same errorI don’t see this configuration in the graph API, so I can’t manipulate elsewhereI tried to downgrade the module versionI don’t see any changes to this cmdlet in the releases page So don’t really know if I’m doing something wrong or if the cmdlet it’s broken. Thanks Read More
Guest access to plans in Planner – Do they need to switch organisations to see the plans?
Hi Planner team
With guest access set up for plans in planner, will the guest be able to view the plan in their own user? Or will they still be required to change organisations?
We see this a quite a barrier to collaboration across external partners and therefore are wondering if at all possible?
Many thanks!
Khanya
Hi Planner team With guest access set up for plans in planner, will the guest be able to view the plan in their own user? Or will they still be required to change organisations? We see this a quite a barrier to collaboration across external partners and therefore are wondering if at all possible? Many thanks!Khanya Read More
archived Teams or Channels: still sychronised in Windows Explorer and files still writeable?
Hi everybody,
i am struggling with the concept of archiving teams and channels, after a project is finished i want to archive (not delete) the teams/channels. i am testing this and noticed a few things:
archived teams and channels are still synchronized with my windows explorer, can i control this behaviour? i want archived channels to Desynchronise in windows Explorer, is this possible?when teams are synchronized i can not edit files in Teams but files are still editable in Windows exploer. So i could edit a Word File in Windows Explorer, save the file and it will be synchronized via One Drive in Teams. why is that? does not really make any sense. when i archive a teams i want to freeze all the files in it and not just the ones opened in teams, how do i change this?
Hi everybody,i am struggling with the concept of archiving teams and channels, after a project is finished i want to archive (not delete) the teams/channels. i am testing this and noticed a few things:archived teams and channels are still synchronized with my windows explorer, can i control this behaviour? i want archived channels to Desynchronise in windows Explorer, is this possible?when teams are synchronized i can not edit files in Teams but files are still editable in Windows exploer. So i could edit a Word File in Windows Explorer, save the file and it will be synchronized via One Drive in Teams. why is that? does not really make any sense. when i archive a teams i want to freeze all the files in it and not just the ones opened in teams, how do i change this? Read More
Azure Data Factory Synapse Analytics: Validate FileFolder before using!
In real time, every project would deal with Azure storage or Azure SQL Database. It can be blobs, folders/directories, files. It becomes a crucial step to validate the filefoldertable before actually using them.
Few usecases:
Suppose we have to load a file named SalesData.csv from a folder that gets created everyday in the format yyyy/MM/dd. Before we use this file in a copy data activity or a data flow activity, we have to first validate, if the folder exists or not.
If the folder exists, we might want to validate the size of the file. This is important, because, sometimes the files bring no data, i.e. a 0 kb file.
Another usecase would be to validate a table structure or file structure and make sure it is compliant with what we expect.
In ADFSynapse, we can use Validation activity andor getmetadata activity to validate files, folders and tables.
Validation Activity Settings & short description follows:
In the above image, we have a referenced a dataset called DelimitedText2, which would point to either a folder or file in azure blob storage or a table in a Azure SQL DB. Timeout property holds the time afterwhich the activity would timeout (note that, it wont fail). For instance, if the validation activity is meant to validate the presence of a filefoldertable, and it doesn’t find the corresponding item, after the timeout time, the activity execution stops and timesout. Next, we have the sleep property which makes the validation activity wait for certain number of seconds before revalidation or timeout. Minimum size property is used to mention the minimum size of a file in bytes (not applicable to table based dataset).
When the validation activity completes execution or times out, we can access the output json of the validation activity to know about the validation results.
Let us look at the GetMetadata activity and its settings.
Like validation activity, we have few properties that would help us validate the filefoldertable in a GetMetadata activity in ADFSynapse. Depending on whether the dataset points to a folderfiletable, the properties (field list) would differ.
The above image depicts the field list corresponding to a folder in ADLS. When we make the dataset point to a file, it would be as below.
So, if the dataset points to a file or table, we see couple of additional properties like Column Count, Size, Structure.
Having seen about the individual properties field list of both the activities, its time to compare and know the similarities and differences.
The below table compares the capabilities of Validation activity & Get metadata activity.
Validation Activity
Get metadata activity
Property Used
Validate File
Yes
Yes
Exists (returns boolean)
Validate Folder
Yes
Yes
Exists (returns boolean)
Validate File Size
Yes
Yes
Get Metadata Activity: Use Size property in field list
Validation Activity: Use Minimum size field in Settings tab
Validate File Structure
No
Yes
Get Metadata:
Use the Field List: Structure.
Then, Use another activity like If condition to validate the structure against the expected.
Validate File Column Count
No
Yes
Get Metadata:
Use the Field List: Column Count.
Then, Use another activity like If condition to validate the count against the expected.
In a nutshell, ADFSynapse comes with a variety of activities, sometimes with similar characteristics or capabilities. When it comes to validation, it is based on the use case, we decide to use either Validation activity or Get Metadata activity or both.
Microsoft Tech Community – Latest Blogs –Read More
Change Microsoft Logo to Company Logo
How to change the Microsoft Logo to a preferred company Logo? Where is that setting located in the admin center?
See sample here
How to change the Microsoft Logo to a preferred company Logo? Where is that setting located in the admin center? See sample here Read More
display Versionnumber in Files (Word …)
Hello everyone, I hope someone can help me with my problem.
I have been given the task of displaying the version number in Word documents. Without Powershell this works without any problems.
Activated the Library and Folder Based Retention Site Collection feature
Checked “Enable Labels” in the Information Management Policy Settings for the Document Content Type, and entered “{Version}” into the Label format field
Created a Word document in my library
Opened the document in Word, and inserted a Quick Part (Document Property > Label)
But I have to roll it out to all SharePoint sites in the tenant, so I have to implement it programmatically somehow.
Does anyone have any idea how I can do it with Powershell, unfortunately I can’t find anything on the internet after a long search.
Hello everyone, I hope someone can help me with my problem. I have been given the task of displaying the version number in Word documents. Without Powershell this works without any problems.Activated the Library and Folder Based Retention Site Collection featureChecked “Enable Labels” in the Information Management Policy Settings for the Document Content Type, and entered “{Version}” into the Label format fieldCreated a Word document in my libraryOpened the document in Word, and inserted a Quick Part (Document Property > Label) But I have to roll it out to all SharePoint sites in the tenant, so I have to implement it programmatically somehow. Does anyone have any idea how I can do it with Powershell, unfortunately I can’t find anything on the internet after a long search. Read More
Nouveau départ
Bonjour, je suis nouveau dans cette communauté et pour me parfaire dans mes compétences dans l’optimisation de requetes SQL et les logiciels travaillant dans ce langage, je dois rejoindre une communauté. J’ai étudié sur MySQL, un peu Clickhouse mais j’amerai découvrir plus, d’où ma présence ici dans la commu SQL Server: je n’ai jamais touché cet outil. Apprenez-moi comment m’en servir s’il vous plait .
J’espère qu’on pourra collaborer.
Je m’appelle Bathy. Enchanté !
Bonjour, je suis nouveau dans cette communauté et pour me parfaire dans mes compétences dans l’optimisation de requetes SQL et les logiciels travaillant dans ce langage, je dois rejoindre une communauté. J’ai étudié sur MySQL, un peu Clickhouse mais j’amerai découvrir plus, d’où ma présence ici dans la commu SQL Server: je n’ai jamais touché cet outil. Apprenez-moi comment m’en servir s’il vous plait .J’espère qu’on pourra collaborer.Je m’appelle Bathy. Enchanté ! Read More
Microsoft at the European Cloud Summit (ECS) 2024 (Wiesbaden, Germany)
What: European Cloud Summit and European Collaboration Summit – co-located in 2024
Register today |Use the MSCMTY discount code to save 15% off registration.
Note: For this guide, we’ll use their main acronym ECS to talk about the event and be clear when highlighting content in either Collab or Cloud side of things.
Content: 2 Microsoft general keynote + 4 general sessions || 100+ overall sessions – 34 Microsoft-led sessions| 12 full-day tutorials – 4 are Microsoft-led
Microsoft is sending over 45+ product makers to present and engage.
Review all sessions, tutorials, and speakers.
When & where: May 14-16, 2024
In-person: Wiesbaden, Germany – RheinMain Congress Center
Tutorials: May 14, 2024
Cost: €500 – €1,240 (Learn more about ticket pricing)
Social https://x.com/eucloudsummit
Join Microsoft and community experts in-person, in one place. The European Collab Summit and European Cloud Summit are co-located in 2024 – converging on Wiesbaden, Germany, May 14-16, 2024 – with two pre-event and one post-event workshop days. They are both wonderful events, together spanning Copilot and AI, SharePoint, Teams, OneDrive, Viva, Power Platform, related Microsoft 365 apps, plus Azure and its vast portfolio of services.
With 2,500+ attendees, the European Collaboration Summit is the largest Microsoft 365 and Power Platform conference in the world. It hosts high ranking Microsoft executives, program managers and architects as speakers, as well as numerous Microsoft Regional Directors and Microsoft MVPs. With 75+ sponsors and exhibitors year after year, it features the largest industry related expo in the world.
The European Cloud Summit is the largest conference in Europe focused on Microsoft Azure, OpenAI, and Cloud Computing. It is the ideal opportunity to meet with 1,200+ Microsoft Azure executives and engineers and program leaders, as well as top managers and engineers from the cloud computing software vendors, consultancies, and cloud integrators. Among the audience will be 80 Microsoft MVPs and Microsoft Regional directors – this is the perfect opportunity to expand your professional network.
You’ll hear the latest product updates and guidance from over 45 Microsoft product makers — filled with real-world solutions across a combined general keynote, four general sessions, numerous breakout sessions, and pre/post event deep-dive workshops to build your expertise – presented alongside Microsoft MVPs and community experts. We hope you join in to learn, share, and engage –including evening gatherings, the attendee party, and a dedicated community space + a lightning talk stage + a dedicated AI Cloud Startup Competition with Microsoft for Startups Founder Hub – all within the Expo Hall alongside all the wonderful event sponsors.
Microsoft keynotes, sessions, and workshops: Copilot/AI, SharePoint, OneDrive, Teams, Viva, Power Platform, D&I, and related technology
Microsoft general keynote and general sessions
Hear from Microsoft leadership revealing the latest innovations shaping the flexible, innovative, and secure business environments of the future. [all times listed in CET]
General keynote:
Day 1 “AI Landscape“
Host: Carlotta Castelluccio
Day 1 “Thriving in the age of Copilots”
Host: Laurie Pottmeyer | Panelists: Dan Holme, Vesa Juvonen, Dona Sarkar, and Jason Himmelstein.
Day 2 “This Is Why We Can’t Have Nice Things“
Host: Dona Sarkar
Register today | Note: Use the MSCMTY discount code to save 15% off registration.
Microsoft-led breakout sessions for each event
Take the opportunity to select the sessions best suited for your role and interests. All breakouts bring product updates, demos, customer stories, best practices, and insights into product and solution strategy – including guidance on the future.
Microsoft-led Cloud sessions
When discovering opportunities across Azure, Copilot, and OpenAI, professionals, entrepreneurs, and businesses are invited to enhance their knowledge and establish meaningful connections. Attendees can expect interactive demos, enlightening discussions, and a deep dive into Microsoft’s strategic direction with advances in cloud. The goal is to discover both ‘how-to’ and increase awareness of the ‘what-if’ – focusing on the impact of cloud adoption and gravitating towards Responsible AI.
“A developer’s journey on maximizing generative AI” with Korey Stegared-Pace | May 15, 2:00pm | Forum 2
“Responsible AI in engineering” with Lee Stott | May 15, 4:20pm | Foyer Nord
“It’s not just words: LLMs in Computer vision” with Carlotta Castelluccio | May 16, 10:20am | Foyer Nord
“Prompt engineering – An art, a science, or your next job title?” with Maxim Salnikov | May 15, 12:00pm | Studio 2.2 C
“Future of cybersecurity in the era of Quantum Computers” with Holger Sirtl May 15, 5:20pm | Studio 2.2 D
“Demystifying Microsoft Defender for Servers” with Tom Janetscheck | May 15, 2:00pm | Halle Sud, D
“Designing the SAP Deployment Automation Framework” with Kimmo Forss | May 16, 2:50pm | Forum 2
“Exploring the future of analytics with Microsoft Fabric” with John White and Jason Himmelstein | May 15, 4:20pm | Studio 2.2 D
“What in the world is Azure Data Explorer and why should I care?” with John White and Jason Himmelstein | May 16, 11:20am | Loge 2.2 A+B
“Increase your SOC efficiency across Microsoft 365 and Azure with Microsoft Sentinel and Automation” with Tobias Martin and Dominik Hoefling | May 15, 12:00pm | Studio 2.2 D
“Let’s unlock scenarios with Microsoft Graph and Azure OpenAI and ChatGPT with Semantic Kernel” with Fabian Williams | May 15, 3:00pm | Halle Sud, D
“Maximizing cost optimization with FinOps in Azure: Best practices and strategies” with Francesco Sodano and Marta Lopata | May 16, 11:20am | Foyer Nord
“Microsoft Defender for Cloud – Defender CSPM in the field” with Dominik Hoefling and Tom Janetscheck | May 16, 2:50pm | Halle Sud, D
“Real-time data processing using Azure Event Hubs & Azure Stream Analytics with or without code” with Ajeta Singhal | May 16, 3:30pm | Loge 2.2 A+B
“Serverless Actor Model with Durable Functions!” with Massimo Bonanni | May 15, 5:20pm | Studio 2.2 C
“The Future of Network and Identity Security: Microsoft Entra SSE” with Shruti Ailani and Bert-Jan Pals | May 16, 11:20am | Studio 2.2 D
Cloud tutorial:
“Everything you wanted to know about Power BI” with John White and Jason Himmelstein | May 14, 9:00am | Studio 1.3 D
“Microsoft Cloud security powerclass” with Sasha Kranjac, Omar Kudović, Tom Janetscheck | May 14, 9:00am | Forum 1.2
“Artificial Intelligence with Azure and Open AI Powerclass (with Microsoft Hands-on Lab)” with Stephan Bisser, Thomas Goelles, Lee Stott, Korey Stegared-Pace, Carlotta Castelluccio | May 14, 9:00am | Studio 1.5 A+B
Microsoft-led Collab sessions
It is crucial to ensure your organization is technically ready for the full potential of Copilot for Microsoft 365. The sessions below focus on technical readiness and ensuring you have the latest guidance. Our experts will share best practices and provide guidance on how to leverage AI and to maximize the benefits of Copilot within your organization.
“The new era of corporate communications” with Liz Sundet | May 15, 12:00pm | Forum 1.1
“Unlock your brand expression in SharePoint and Viva Connections” with Cathy Dew | May 15, 4:20pm | Forum 1.1
“What’s new and next for Microsoft Viva and the Employee Experience” with Dan Holme | May 16, 1:30pm | Halle Sud, A+B
“Viva Engage and AI transform communications: From eyeballs to engagement, from channels to change ag…” with Dan Holme | May 15, 3:00pm | Halle Sud, C
“From community to keynote” with Liz Sundet | May 16, 1:30pm | Expo Stage
“Mastering Teams meetings” with Laurie Pottmeyer | May 16, 10:20am | Halle Sud, A+B
“Skill up on Microsoft Lists” with Mark Kashman | May 16, 11:20am | Halle Sud, A+B
“Understanding Microsoft 365 Copilot” with Mark Kashman (link, time, and location coming soon)
“There’s no time like the present – Real-time reporting with Power BI and Microsoft Fabric” with John White and Jason Himmelstein | May 15, 4:20pm | Studio 1.2 A-B
“SharePoint API platform: What’s new and coming” with Bert Jansen | May 16, 2:50pm | Halle Sud, A+B
“What’s new with Microsoft Profile in the age of generative AI” with Wictor Wilén | May 15, 5:20am | Halle Sud, A+B
“Automating manual processes through Robotic Process Automation (RPA) with Power Automate Desktop” with Christina Wheeler | May 16, 10:20am | Forum 1.3
“Build apps that don’t fail in production” with Garry Trinder and Waldek Mastykarz | May 15, 2:00pm | Halle Sud, C
“Data Classifiers, the first step to identifying sensitive data” with Al Eardley | May 15, 12:00pm | Studio 1.1, A+B
“Microsoft Graph development simplified with MGT” with Gavin Barron | May 15, 5:20pm | Halle Sud, C
“Mastering Microsoft Graph Connectors with the NEW Microsoft Graph Python SDK” with Fabian Williams and Gabrielle Williams | May 15, 12:00pm | Halle Sud, A+B
“Top hidden features of custom connectors to level up the maker experience” with Daniel Laskewitz and Mats Necker | May 15, 5:20pm | Forum 1.2
“Security Copilot in Microsoft 365 Defender: Use cases from the field and demo” with Tobias Martin and Dominik Hoefling | May 15, 3:00pm | Forum 1.3
“Viva Connections for administrators – Setup, configuration and decisions” with Dragan Panjkov | May 15, 2:00pm | Studio 1.4, A+B
Collab tutorials:
“Building intranets with Viva, SharePoint and Microsoft 365” with Emily Mancini, Cathy Dew, and Liz Sundet | May 14, 9:00am | Studio 1.4 A
“Building experiences for the Microsoft 365” with Vesa Juvonen, Stefan Bauer, Waldek Mastykarz, Paolo Pialorsi, Derek Cash-Peterson, Julie M Turner, Anoop Tatti, Garry Trinder | May 14, 9:00am | Forum 1.3
You can review each full agenda for Collab sessions and Cloud sessions. Plus, use the event mobile app (iOS and Android) to add sessions to your schedule.
Register today | Note: Use the MSCMTY discount code to save 15% off registration.
Get the most out of ECS: Our top five tips while attending
Introduce yourself | Unique perspectives await, including yours.
Attend as much as you can | Laptops down, eyes open – depth learning, tips, and tricks abound.
Share what you know |Your knowledge saves time – pay it forward.
Ask questions, share feedback | Your issues and ideas Inform us and influence the roadmap.
Hydrate and dress for steps | Keep the brain healthy and mind active.
BONUS | Update your LinkedIn profile and photo | Best reflect your professional experience and growing technical aptitude.
Remember, use the discount code MSCMTY discount code to save 15% off your conference registration. Register today!
Microsoft Tech Community – Latest Blogs –Read More
Build your first ML-Model with ML.NET Model Builder
I’m Hamna Khalil, a Beta Microsoft Learn Student Ambassador from Pakistan. Currently, I’m a third-year student pursuing my bachelor’s degree in Software Engineering from Fatima Jinnah Women University.
Integrating machine learning functionalities into your .NET applications can be both exciting and daunting. However, with the advent of tools like ML.NET Model Builder and Visual Studio’s development environment, the process is significantly streamlined.
In this step-by-step guide, I’ll walk you through the process of building your first machine learning model using ML.NET Model Builder within Visual Studio 2022. From setting up your development environment to training and evaluating your model’s performance, each step is meticulously outlined to ensure a smooth and rewarding experience.
Step#01 Download and install
Download and install Visual Studio 2022 with the .NET desktop development workload selected, including the optional ML.NET Model Builder component.
After enabling ML.NET Model Builder in Visual Studio, download and install ML.NET Model Builder 2022
Step#02 Create .NET console app
To create a .NET console app in Visual Studio, follow these steps:
Open Visual Studio 2022 and select Create a new project.
Select C# Console App project template.
Change the project name to myMLApp. Ensure that Place solution and project in the same directory is unchecked.
Select the Next button.
Select .NET 8.0 (Long Term support) as the Framework.
Select the Create button.
Step#03 Add machine learning model
To add a machine learning model to your .NET console app in Visual Studio, follow these steps:
Right-click on the myMLApp project in Solution Explorer
Select Add > Machine Learning Model.
In the Add New Item dialog, ensure that Machine Learning Model (ML.NET) is selected.
Change the Name field to SentimentModel.mbconfig and select the Add button.
Step#04 Choose machine learning scenario
To build your sentiment analysis model, you first need to select your machine learning scenario.
In the Model Builder Scenario screen, choose the Data classification scenario.
Step#05 Select training environment
After selecting the Data classification scenario, choose your training environment.
Select the Local (CPU).
Step#06 Prepare data
Download the Sentiment Labelled Sentences dataset from the UCI Machine Learning Repository.
Unzip sentiment labelled sentences.zip and save the yelp_labelled.txt file to the myMLApp directory.
Select File as the input data source type.
Browse for the yelp_labelled.txt file. Once selected, a preview of your data will appear in the Data Preview section.
Under Column to predict (Label), select “col1”.
Step#07 Train the model
To train your model using Model Builder with the yelp_labelled.txt dataset, follow these steps:
Adjust Time to train to 60 seconds (you may increase this value if no models are found after training).
Select Start training to start the training process. Once training is done, you’ll see a summary of the training results.
Step#08 Evaluate model performance
The Evaluate step shows the best-performing algorithm and the best-accuracy.
In the Try your model section, the textbox is pre-filled with the first line of data from your dataset. You can modify this input to test different sentiment predictions.
After modifying the input, select the Predict button to see the model’s prediction.
Step#09 Consume the trained model
In the Consume step in Model Builder, a code snippet is provided that generates sample input for the model. Additionally, Model Builder offers two Project templates (a console app and a web API), both designed to consume the trained model.
To consume your trained model, replace the Program.cs code with the following code:
using MyMLApp;
// Add input data
var sampleData = new SentimentModel.ModelInput()
{
Col0 = “This restaurant was wonderful.”
};
// Load model and predict output of sample data
var result = SentimentModel.Predict(sampleData);
// If Prediction is 1, sentiment is “Positive”; otherwise, sentiment is “Negative”
var sentiment = result.PredictedLabel == 1 ? “Positive” : “Negative”;
Console.WriteLine($”Text: {sampleData.Col0}nSentiment: {sentiment}”);
Step#10 Run and debug
Navigate to the Debug menu and select Start Without Debugging or use the shortcut Ctrl + F5.
After running, you should see the following output, predicting whether the input statement is positive or negative.
Congratulations on successfully building and executing your first machine learning model with ML.NET Model Builder in Visual Studio 2022!
From setting up your development environment to training and evaluating your model’s performance, you’ve acquired the skills to leverage ML.NET’s capabilities for crafting predictive models efficiently. Armed with the power of ML.NET, you’re now ready to seamlessly integrate advanced machine learning functionalities into your .NET applications.
Additional Resources
Microsoft AI Discord Community
Microsoft Tech Community – Latest Blogs –Read More
Get account name if UserPrincipalName is UserId
Sometimes the signin events in the various AAD signin logs contain the UserId as the UserPrincipalName. In some spot checks it looks to me that this often happens when the signin comes from a Teams app on an iOS device…
This requires the reader of the output to lookup the UserId e.g. in the Entra ID portal, to figure out which user this was.
Is there a way to do this dynamically in the KQL query so that I could add the name to the output?
Sometimes the signin events in the various AAD signin logs contain the UserId as the UserPrincipalName. In some spot checks it looks to me that this often happens when the signin comes from a Teams app on an iOS device…This requires the reader of the output to lookup the UserId e.g. in the Entra ID portal, to figure out which user this was.Is there a way to do this dynamically in the KQL query so that I could add the name to the output? Read More
Whatsapp App displays Notification Even After It was Closed!
Hi.
I installed Whatsapp on my Windows 11.
The bizzare thing that happened is that, even after I closed Whatsapp (it was not visible anymore neither on the task bar nor on the tray icon area), Whatsapp kept running on the background and displaying notifications of new messages arriving on my whatsapp on the screen!
I certainly don’t want apps running on the background after they were completely closed on the interface.
How can I force Whatsapp to be closed completely when I close it? Certainly that raises the concern of how many other apps are running on the background after being closed? I’m talking here, obviously, of explicit apps that should work only when opened by the user and displayed on the screen. I’m not talking about normal background processes of apps used to improve performance.
A background process to optimize performance is completely different of an app fully running and receiving messages after being closed. It’s like closing Outlook Email and keep receiving notifications that a new Email arrived even though the app was closed. That didn’t happen with outlook. but it’s a good analogy. That behaviour from Whatsapp is unacceptable!
Hi.I installed Whatsapp on my Windows 11.The bizzare thing that happened is that, even after I closed Whatsapp (it was not visible anymore neither on the task bar nor on the tray icon area), Whatsapp kept running on the background and displaying notifications of new messages arriving on my whatsapp on the screen! I certainly don’t want apps running on the background after they were completely closed on the interface.How can I force Whatsapp to be closed completely when I close it? Certainly that raises the concern of how many other apps are running on the background after being closed? I’m talking here, obviously, of explicit apps that should work only when opened by the user and displayed on the screen. I’m not talking about normal background processes of apps used to improve performance.A background process to optimize performance is completely different of an app fully running and receiving messages after being closed. It’s like closing Outlook Email and keep receiving notifications that a new Email arrived even though the app was closed. That didn’t happen with outlook. but it’s a good analogy. That behaviour from Whatsapp is unacceptable! Read More
Integrate services inside InTunes
Dear Team,
We have a requirement to integrate our services within InTunes. Essentially, our customers’ devices are already registered on InTunes. Therefore, our technicians and/or customers require a direct connection to our services, eliminating the need for re-registration of the same device on our platform. Is it feasible to implement a feature where clicking on a device triggers our app icon, allowing users to seamlessly navigate to our platform with all the necessary device details preloaded?
Thank you.
Dear Team,We have a requirement to integrate our services within InTunes. Essentially, our customers’ devices are already registered on InTunes. Therefore, our technicians and/or customers require a direct connection to our services, eliminating the need for re-registration of the same device on our platform. Is it feasible to implement a feature where clicking on a device triggers our app icon, allowing users to seamlessly navigate to our platform with all the necessary device details preloaded?Thank you. Read More