Tag Archives: microsoft
Outlook Mobile Auto Expand the TO: Field
Im looking for a way in Outlook mobile to see all recipients in the to field without having to tap it to expand it to see all recipients. Do you know if that is an option.
Im looking for a way in Outlook mobile to see all recipients in the to field without having to tap it to expand it to see all recipients. Do you know if that is an option. Read More
Unable to Save Governance Workflow
I am trying to create a new Governance Workflow ‘Data Access Request’ in Purview.
I have validated the workflow and applied it to a collection. However, when I click ‘Save & Close’, it presents the following error message:
Error Code: Workflow.WorkflowDefinitionError.WorkflowDefinitionAuthorizationError.UserDoNotHavePermissionToEditOrDeleteWorkflowDefinition
Message: User 05ffa6b3-9edd-4e03-9797-cb67dfe5c3b1 does not have permission to edit or delete workflow definition
I have the Workflow Admin role. What permission do I require in order to save this workflow? Thank you.
I am trying to create a new Governance Workflow ‘Data Access Request’ in Purview. I have validated the workflow and applied it to a collection. However, when I click ‘Save & Close’, it presents the following error message: Error Code: Workflow.WorkflowDefinitionError.WorkflowDefinitionAuthorizationError.UserDoNotHavePermissionToEditOrDeleteWorkflowDefinitionMessage: User 05ffa6b3-9edd-4e03-9797-cb67dfe5c3b1 does not have permission to edit or delete workflow definition I have the Workflow Admin role. What permission do I require in order to save this workflow? Thank you. Read More
Virtual path maps to another application
First, I’m not sure if I am in the correct Forum please direct to proper forum if it is wrong.
I’m am getting the following error when I run my VS2019 WCF app. (Note it was originally written in VS2019)
The virtual path ‘/MyApp/MyService.svc’ maps to another application, which is not allowed.
Now, the app was working before, I think I upgraded to VS 2019 16.11.35 and this issue started to occur but I’m not sure. I have IIS 10 Express installed. I am lost why this is happening now. Can anyone offer insights or solution to this issue?
Thank you!
First, I’m not sure if I am in the correct Forum please direct to proper forum if it is wrong.I’m am getting the following error when I run my VS2019 WCF app. (Note it was originally written in VS2019) The virtual path ‘/MyApp/MyService.svc’ maps to another application, which is not allowed.Now, the app was working before, I think I upgraded to VS 2019 16.11.35 and this issue started to occur but I’m not sure. I have IIS 10 Express installed. I am lost why this is happening now. Can anyone offer insights or solution to this issue? Thank you! Read More
Released: April 2024 Exchange Server Hotfix Updates
Microsoft has released Hotfix Updates (HUs) that enable support for new functionality and address issues in the March 2024 Security Update (SU).
The April 2024 HU is available for the following builds of Exchange Server:
Exchange Server 2019 CU13 and CU14
Exchange Server 2016 CU23
New Features
The April 2024 HU introduce support for elliptic curve cryptography (ECC) certificates and hybrid modern authentication for Outlook on the web and ECP.
Support for ECC certificates
Starting with April 2024 HU, Exchange Server 2016 and Exchange Server 2019 now support ECC certificates except when used in Active Directory Federation Services (AD FS) scenarios.
Hybrid Modern Authentication (HMA) for OWA/ECP
We are also announcing that starting with April 2024 HU, HMA for OWA/ECP is also supported. This feature requires Exchange 2019 CU14 + April 2024 HU (or later). Please see the feature documentation for more information.
Issues Addressed
The April 2024 HU also addressed issues that have been reported since the release of March 2024 Security Updates for Exchange Server. The following issues in the March 2024 SUs are addressed in this HU:
Download domains not working after installing the March 2024 SU
“We can’t open this document” error in OWA after installing March 2024 SU
Search error in Outlook cached mode after installing March 2024 SU
OwaDeepTestProbe and EacBackEndLogonProbe fail after installing March 2024 SU
Edit permissions option in the ECP can’t be edited
Outlook doesn’t display unread envelope icon after installing Microsoft Exchange Server March 2024 SU (Note: the fix resolves this issue for new messages, after April 2024 HU or later is installed)
My Templates add-in isn’t working after installing Microsoft Exchange Server March 2024 SU
Published calendars might not work with a “This calendar isn’t available” error after installing March 2024 SU
March 2024 SU issue that we still need to resolve:
Calendar printing in OWA might not work unless CTRL+P keyboard shortcut is used. We will address this in a future update.
April 2024 Hotfix Update FAQ
This is the first HU released for Exchange Server, so to help you decide if you should install this update, we have prepared the following questions and answers:
We installed the March 2024 SU. Should we install the April 2024 HU?
The April 2024 HU is an optional update, but it does also introduce support for ECC certificates and HMA for OWA/ECP. If you installed the March 2024 SU but did not experience any of known issues and you don’t need the new functionality, you do not need to install the April 2024 HU and can wait until the future SU (which will include known issue fixes from April HU).
We did not yet install the March 2024 SU. Do we have to install the March SU first before installing the April 2024 HU?
The April 2024 HU includes the same security updates as the March 2024 SU, while addressing known issues with the March 2024 SU. If you did not install the March 2024 SU, you can install the April 2024 HU directly and skip the March 2024 SU.
Our Exchange servers update automatically through Windows / Microsoft Update. We installed the March 2024 SU already. Will our servers automatically install the April 2024 HU?
The April 2024 HU will appear as an optional update for your servers.
Does the April 2024 HU contain any security updates not included in the March 2024 SU?
The security content of the April 2024 HU is the same as in March 2024 SU.
Will the two new features (support for ECC certificates and HMA for OWA/ECP) also be rolled into future updates, or must we install this specific HU to get them?
The April 2024 HU will be included in subsequent updates for Exchange Server. We are simply announcing that those two features are now supported starting with April 2024 HU.
Can April 2024 HU be uninstalled (if the need arises)?
Yes. HUs, like SUs, can be uninstalled.
Please see the March 2024 SU release blog post for installation tips and information related to security fixes included.
Documentation may not be fully available at the time this post is published.
This post might receive future updates; they will be listed here (if available).
The Exchange Server Team
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Partner account accidentally linked to private Microsoft account
Hello,
I have a small account problem, my account (domain is meinefirma.de) is accidentally linked as a private account and the activation in the Microsoft Partner Center does not work.
Is it possible to correct this or to delete all links and restart them.
Thanks and greetings
Torsten
Hello, I have a small account problem, my account (domain is meinefirma.de) is accidentally linked as a private account and the activation in the Microsoft Partner Center does not work. Is it possible to correct this or to delete all links and restart them. Thanks and greetings Torsten Read More
How can I troubleshoot QuickBooks Error H202 in Windows 11?
Encountering issues with QuickBooks H202 Error on Windows 11—it’s not functioning correctly. How can I fix this to ensure smooth cooperation?
Encountering issues with QuickBooks H202 Error on Windows 11—it’s not functioning correctly. How can I fix this to ensure smooth cooperation? Read More
Microsoft Excel Charts cannot be saved as image in Windows 11. Copy-paste charts no longer work
I’m trying to save the charts as svg or even just a png, but after I right-click > Save as Picture then select the filetypes, it just deletes the file right away and I can’t find it in the selected folder. I noticed that it’s been years in the community that the Save Image function has been experiencing a lot of issues.
Trying to copy-paste the chart into other programs (Powerpoint, Word, etc) also doesnt work.
I’m trying to save the charts as svg or even just a png, but after I right-click > Save as Picture then select the filetypes, it just deletes the file right away and I can’t find it in the selected folder. I noticed that it’s been years in the community that the Save Image function has been experiencing a lot of issues.Trying to copy-paste the chart into other programs (Powerpoint, Word, etc) also doesnt work. Read More
Generate Now! AI Vodcast w/James Caton
Microsoft partners and customers around the globe have been doing incredible things with #Azure #OpenAI Service #ChatGPT and #MicrosoftCopilot. In his new vodcast, “Generate Now!” @James Caton, Microsoft Lead of GSI Portfolio (Analytics & AI Solution Areas), highlights the transformative power of this technology and shares various use cases across industries.
To kick off the series, James explores the #GenAI adoption process from start to finish with @Endeavour Energy (NSW) and @TCS. Catch their expert insights on the following channels:
Website: https://aka.ms/GenerateNow
YouTube: https://aka.ms/GenerateNowYouTube
Spotify: https://aka.ms/GenerateNowSpotify
Apple Music: https://aka.ms/GenerateNowApple
Amazon Music: https://aka.ms/GenerateNowAmazon
Microsoft Tech Community – Latest Blogs –Read More
Virtual career fairs match employers with skilled job seekers
When the Microsoft Learn Career Connected team realized that it was in a key position to connect two groups in need of an introduction—newly skilled job seekers and employers needing credentialed talent—the idea for virtual career fairs was born. The first Microsoft Learn Career Connected Career Fair was held in the United States in February 2024. This was initially a small pilot program, and now the team is rolling out career fairs worldwide to connect more employers and individuals skilled in Microsoft’s AI apps and services, Azure, and other emerging technologies. Attendees are members of the program’s talent coalition, a free-to-join community that connects job seekers, employers in need of talent, and organizations that provide skill-building and training opportunities. And the community is always looking for new members.
In kicking off the inaugural career fair, Holly Bilyeu, Microsoft Business Program Manager, quoted Jean-Philippe Courtois, Executive Vice President and President, National Transformation Partnerships at Microsoft, who has pointed out how the skills-first economy is reshaping the global workforce. “Tech skills have become an essential asset in the job market, especially as we enter an exciting new era driven by AI. This is why we must invest in skilling people right now and connecting them to meaningful jobs and career paths.”
A field of ‘up-and-coming talent’
Virtual career fairs are one more way that Microsoft is helping to bridge the gap between skills and opportunity. The day-long virtual event enabled employers to meet individuals who hold or are earning Microsoft Credentials—Certifications or Applied Skills. These validations are a helpful filter for employers, shining a spotlight on the next generation of skilled workers. As one recruiter points out, “We met with lots of up-and-coming talent.”
“Our ultimate goal is to enable our customers and partners to achieve more by finding skilled talent that meets their needs and to help learners get connected with job opportunities of the future,” explains Bilyeu. “Microsoft is not a recruitment company. But we know that our customers and partners are seeking skilled individuals, and we know the academic institutions that are producing valuable technical talent. We can now bring them together through these virtual career fairs.”
Employers at the event participate in the Microsoft Learn Career Connected talent coalition. Through this group, they get help addressing their immediate and future talent needs. They also get the opportunity to expand their talent pipeline—with workforce development partners, nonprofits, and the colleges and universities in the Microsoft Learn for Educators program. Plus, they can amplify their organization as an employer of choice.
After the career fair, participants shared valuable feedback that will be used to improve future events, but the virtual setup was an overall success. As one hiring manager comments, “We gained a lot of qualified candidates and look forward to the next event.”
A place where new skills get noticed
For job seekers, the career fair was a way to showcase their newly acquired skills, learn about available opportunities, and make an impression on hiring managers. The event offered a new way for these job seekers to get noticed. Attendees could make appointments to meet virtually with recruiters, apply for open positions and internships, and follow up on those connections. They could create virtual profiles, résumés, and business cards to show off newly minted credentials, such as the Microsoft Certified: Azure AI Fundamentals or Microsoft Certified: Azure AI Engineer Associate certifications. Other job seekers chose to demonstrate their proficiency in scenario-based Microsoft Applied Skills learning paths, including in-demand scenarios, like Build a natural language processing solution with Azure AI Language, Develop generative AI solutions with Azure OpenAI Service, and Build an Azure AI Vision solution.
In addition, the career fair introduced job seekers to business leaders and experts on a range of topics. Through webinars at the event, attendees learned about generative AI with Copilot in Bing, earning Applied Skills credentials, successful careers in Dynamics 365 Business Central, and building a stronger LinkedIn profile.
“The audience was thrilled with the webinars,” Bilyeu reports. “Microsoft’s goal was to open job seekers’ eyes to other avenues that are available.”
A community of opportunity
The Microsoft Learn Career Connected team is using the learnings from the first fair in the United States to enrich the experience for participants in the upcoming fairs (dates to be determined) in Canada, Germany, Italy, Spain, Sweden, and the United Arab Emirates.
Job seekers, including students finishing up college, recent graduates, and workers looking for a career change or reentering the work force, can go to the Microsoft Learn Career Connected site to get more information and join the LinkedIn group. There they can find support as they start learning about Microsoft’s AI apps and services, Azure, cybersecurity, Microsoft 365, Dynamics 365, or Microsoft Power Platform, among other technologies. Job seekers can also find information there about the next virtual career fair.
If you’re an employer looking to connect with skilled talent at job fairs and beyond, sign up for the Microsoft Learn Career Connected talent coalition. The program is always open to new members, and there’s no fee to join. Employers who have signed up for the talent coalition and want to join future fairs can fill out the Microsoft Learn Career Connected Career Fairs Exhibitor Request Application.
“Everyone’s looking for great resources,” Bilyeu adds. “We hope these virtual career fairs help organizations proactively find new talent.”
Learn more
For employers, sign up for the Microsoft Learn Career Connected talent coalition, and find resources to build relationships and hire the right people for the right roles.
For job seekers, discover Microsoft Learn Career Connected, including steps to your new or next career—career paths, preparation resources, LinkedIn profile tips, and community connections.
Explore the Microsoft Learn AI learning hub, to get skilled up and ready to power AI transformation with the Microsoft Cloud and to chart your AI learning journey.
Learn more about Microsoft Credentials—Microsoft Certifications and Applied Skills—to build and validate skills in Microsoft’s AI apps and services, Azure, cybersecurity, and more in-demand technologies.
Microsoft Tech Community – Latest Blogs –Read More
Database Schema Compare Tool
Introduction
Customers migrating and modernizing to Azure SQL (Azure SQL DB / Azure SQL MI / Azure SQL VM) can benefit from multiple salient functionalities as well as fundamental capabilities like security, scalability, that comes with a fully managed database offerings in Azure. It supports different deployment choices, service levels, language SDKs, data types, and more. Azure SQL also provides high reliability, disaster recovery, performance, and availability, as well as advanced features such as intelligent query processing, automatic performance tuning, serverless compute, and copilot for query generation.
A key step in migrating the data tier to Azure SQL is to validate the consistency and accuracy of the schema / metadata between the source database and target Azure SQL databases. This can be a difficult and prone to error task if done manually, especially when working with large and complex databases. To make this process easier and faster, you can utilize this tool that can perform a thorough metadata comparison between the source and target database on SQL. The tool can verify the names of tables, column names, ordering of columns, data types of columns, view names, function names, indexes, constraints, triggers, and other objects, as well as their properties and definitions. The tool generates a detailed report that shows the differences and similarities between the two databases. This technical blog will explain the features and functionalities of Db2 and Azure SQL database Schema comparison Tool that can help you compare schema from Db2 to Azure SQL with ease.
The tool currently supports Db2 z/OS and Db2 LUW as source databases and SQL as target database
Microsoft SQL Server Migration Assistant (SSMA) for Db2 is a tool to automate migration from IBM Db2 database to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance. By migrating from Db2 to Azure SQL, customers can increase their agility and innovation, and improve their data security and compliance with ease.
Comparing Schema between Db2 and Azure SQL database
How does the Schema comparison tool work?
Below steps provides details about important part of the schema comparison process followed in the Tool.
1a. Connect to Source Db2 : Schema comparison tool connects to source Db2 database. It fetches all the meta data for the given schema.
The tool supports Db2 z/OS and Db2 LUW currently.
1b. Connect to Target Sql : Tool in parallel also connects to SQL database (SQL DB / SQL MI / SQL VM to fetch all meta data for the given schema.
2a and 2b. Store Object Metadata details: Metadata information across 25+ parameters is collected which includes (not complete list) Table names, Column names, Column order, Column data type, Column default value, View names, Function names, Stores procedure names, Indexes, Index order, Index Type, Primary Key / Foreign key constraints etc.
3a and 3b. Write meta data to Azure SQL : Meta data collected from Db2 and SQL Catalogue tables is stored in staging table in target Azure SQL.
4. Schema comparison Process : Db2 and SQL Schema differences identification process runs on the top of the meta data stored in Azure SQL.
5. Write differences to Azure SQL: This process writes details about mismatches in Db2 and SQL Schema into Azure SQL differences table. Example: Table Table1 present in Db2 and not in SQL, Column Order for Col1 is different in Db2 and SQL etc.
6. Power BI or Excel connection to Azure SQL: Power BI connects to Azure SQL in Direct Query mode to access differences data.
7. Schema comparison report for Db2 and Azure SQL: Power BI Tool is used to create a report on the schema differences between Db2 and Azure SQL. Alternatively, Excel can be used to view the report.
Db2 and Azure SQL Sample Schema differences report
Below is a sample differences report generated to compare schema SCHEMACOMPARE01 present on Db2 LUW and Azure SQL Database. Numbers marked in red circle are used for annotation and are explained below:
1. Schema Name SCHEMACOMPARE01 for which meta data differences is shown.
2. The total number of differences found between source and target schema.
3. X – axis represents Object categories for which differences are found.
4. Y – axis represents Total number of differences for a given Object category.
5. It shows four differences that were found for Column Order Id in which Order of Column in Db2 and Azure SQL was different.
Tool also has the capability to drill down and show exact difference between source and target object as shown below where column names PRSTAFF and PRSTDATE present in PROJ Table on Db2 but not in target Azure SQL Database.
Db2 and Azure SQL example valid differences which should be ignored.
The following table shows some examples of how Db2 and Azure SQL have some inherent differences which are expected and hence accepted by the Tool when it compares them. This list is not exhaustive and only illustrates some differences.
Sr. No.
Difference Category
Db2
Azure SQL
1
Data Type
Blob
Varbinary
2
Data Type
Clob
Varchar
3
Data Type
Timestamp
Datetime2(6)
4
Data Type
Char varying
Varchar
How to get access to this tool?
You can request setting up this Tool for your use case by emailing at alias: datasqlninja@microsoft.com
Summary
This tool is beneficial to customers to perform automatic schema comparison between Db2 and Azure SQL and ease the migration from Db2 to Azure SQL. Using this tool before testing / migrating / cut-over can help you to minimize any issues related to schema differences while performing data migration or application execution.
We will incrementally update the supported databases based on customer feedback.
Feedback and suggestions
If you have feedback or suggestions for improving this data migration asset, please send an email to Databases SQL Engineering Team.
Microsoft Tech Community – Latest Blogs –Read More
Getting Started – Generative AI with Phi-3-mini: A Guide to Inference and Deployment
Or maybe you were still paying attention to the Meta Llama 3 released last week, but today Microsoft did something different and released a new Phi-3 series of models. The first wave of releases on Hugging face is the Phi-3-mini version with a parameter size of 3.8B. Phi-3-mini can not only run on traditional computing devices, but also on edge devices such as mobile devices and IoT devices. The Phi-3-mini release covers the traditional Pytorch model format, the quantized version of the gguf format, and the onnx-based quantized version. This also brings convenience to developers in different application scenarios. The content of this blog hopes to allow different developers to explore different model formats released by Phi-3-mini combined with different technical frameworks, so that everyone can inference Phi-3-mini first.
Use Semantic Kernel to access Phi-3-mini
In the Copilot application, we create applications through Semantic Kernel / LangChain. This type of application framework is generally compatible with Azure OpenAI Service / OpenAI models, and can also support open source models on Hugging face and local models. What should we do if we want to use Semantic Kernel to access Phi-3-mini? Using .NET as an example, we can combine it with the Hugging face Connector in Semantic Kernel. By default, it can correspond to the model id on Hugging face (the first time you use it, the model will be downloaded from Hugging face, which takes a long time). You can also connect to the built local service. Compared with the two, I recommend using the latter because it has a higher degree of autonomy, especially in enterprise applications.
From the figure accessing local services through Semantic Kernel can easily connect to the self-built Phi-3-mini model server. Here is the running result.
Sample Code https://github.com/Azure-Samples/Phi-3MiniSamples/tree/main/semantickernel
Call quantized models with Ollama or LlamaEdge
More users prefer to use quantized models to run models locally. Through Ollama/LM Studio, individual users can call different quantized models at will. I will first show how to use Ollama to call the Phi-3-mini quantization model
Create a Modelfile
FROM {Add your gguf file path}
TEMPLATE “””<|user|>
{{.Prompt}}<|end|>
<|assistant|>”””
PARAMETER stop <|end|>
PARAMETER num_ctx 4096
Running in terminal
ollama create phi3mini -f Modelfile
ollama run phi3mini
Here is the running result.
Sample Code https://github.com/Azure-Samples/Phi-3MiniSamples/tree/main/ollama
I have always been a supporter of cross-platform applications. If you want to use gguf in the cloud and edge devices at the same time, LlamaEdge can be your choice. LlamaEdge can be understood as WasmEdge (WasmEdge is a lightweight, high-performance, scalable WebAssembly runtime suitable for cloud native, edge and decentralized applications. It supports serverless applications, embedded functions, microservices, smart contracts and IoT devices. You can deploy gguf’s quantitative model to edge devices and the cloud through LlamaEdge.
Here are the steps to use
Install and download related libraries and files.
curl -sSf https://raw.githubusercontent.com/WasmEdge/WasmEdge/master/utils/install.sh | bash -s — –plugin wasi_nn-ggml
curl -LO https://github.com/LlamaEdge/LlamaEdge/releases/latest/download/llama-api-server.wasm
curl -LO https://github.com/LlamaEdge/chatbot-ui/releases/latest/download/chatbot-ui.tar.gz
tar xzf chatbot-ui.tar.gz
Note: llama-api-server.wasm and chatbot-ui need to be in the same directory
Run scripts in terminal
wasmedge —dir .:. –nn-preload default:GGML:AUTO:{Your gguf path} llama-api-server.wasm -p phi-3-chat
Here is the running result.
Sample code https://github.com/Azure-Samples/Phi-3MiniSamples/tree/main/wasm
Run an ONNX quantized model
ONNX Runtime is an efficient runtime library for ONNX models. It supports multiple operating systems and hardware platforms, including CPU, GPU, etc. The key advantages of ONNX Runtime are its efficient performance and ease of deployment. Through ONNX Runtime, developers can easily deploy trained models to production environments without caring about the underlying inference framework. In the era of large models, ONNX Runtime has released an interface (Python/.NET/C/C++) based on generative AI. We can use this interface to call the Phi-3-mini model. Next we try to call the Phi-3-mini model through Python (when using ONNX Runtime Generative AI, you need to compile the environment first, please refer to https://github.com/microsoft/onnxruntime-genai/blob/main/examples/python/phi-3-tutorial.md)
Sample Code https://github.com/Azure-Samples/Phi-3MiniSamples/tree/main/onnx
Summary
The release of Phi-3-mini allows individuals and enterprises to deploy SLM on different hardware devices, especially mobile devices and industrial IoT devices that can complete simple intelligent tasks under limited computing power. Combining LLMs can open up a new era of Generative AI. Inference is only the first step. I hope you will continue to pay attention to the content of this series.
Resources
Phi-3 Azure blog https://aka.ms/phi3blog-april
Phi-3 technical report https://aka.ms/phi3-tech-report
Learn about ONNX Runtime Generative AI https://github.com/microsoft/onnxruntime-genai
Learn about Semantic Kernel https://aka.ms/SemanticKernel
Read Semantic Kernel Cookbook https://aka.ms/SemanticKernelCookBook
Learn about LlamaEdge https://github.com/LlamaEdge/LlamaEdge
Learn about Ollama https://ollama.com/
Microsoft Tech Community – Latest Blogs –Read More
Partner Case Study Series | DevOpsGroup: Migration to Azure DevOps
DevOpsGroup empowers organizations through IT modernization
DevOpsGroup is a Microsoft gold partner that empowers enterprises and scale-up organizations to achieve more in the digital economy by modernizing IT. The Cardiff, Wales, UK-based company’s team is 90 members strong, and its cloud and DevOps engineers have vast experience working with cloud platforms and DevOps toolchains.
SureView Systems, a multinational software company with headquarters in Tampa, Florida, and Swansea, Wales, specializes in physical security monitoring software for central stations and command centers. The company’s flagship product, Immix, integrates with more than 500 security products and systems. SureView Systems wanted to move Immix from TFS to Azure DevOps to accelerate software delivery and move toward a Software-as-a-Service (SaaS) model. Azure DevOps enables collaboration and modern DevOps services via its boards, pipelines, repositories, testing tools, and extensions marketplace.
“A key driver for the migration to Azure DevOps was the need to keep pace with the latest development and deployment tools as we migrated toward a continuous delivery/continuous integration DevOps model,” said Simon Morgan, Chief Technology Officer, SureView Systems.
Continue reading here
**Explore all case studies or submit your own**
Microsoft Tech Community – Latest Blogs –Read More
Textjoin or simple “&” returns duplicate results when used on Table
I’ve used Textjoin on multiple occasions without problem, or its simple equivalent, the humble ampersand. If we use the below example:
Cell A1: 10
Cell B1: James
Cell C1: ()
Let’s say I use the “,” delimiter in Textjoin or add that criteria in a simple “&”. In all cases I shold end up with: 10,James,()
But for some reason, when applying either of these solutions to a named Table in desktop Excel app, I keep getting this result: 10,James,()10,James,() minus the colors obviously.
In other words, the results of either formula are completely duplicated, only omitting the middle “,”. Doesn’t even matter which approach I choose, and there aren’t any formulas running in the cells that I am referencing.
Has anyone experienced anything similar?
I’ve used Textjoin on multiple occasions without problem, or its simple equivalent, the humble ampersand. If we use the below example: Cell A1: 10Cell B1: JamesCell C1: () Let’s say I use the “,” delimiter in Textjoin or add that criteria in a simple “&”. In all cases I shold end up with: 10,James,() But for some reason, when applying either of these solutions to a named Table in desktop Excel app, I keep getting this result: 10,James,()10,James,() minus the colors obviously. In other words, the results of either formula are completely duplicated, only omitting the middle “,”. Doesn’t even matter which approach I choose, and there aren’t any formulas running in the cells that I am referencing. Has anyone experienced anything similar? Read More
911 Emergency address and iphone Teams app
Testing 911 with Teams app (via 933) using Teams and Operator connect. I have user emergecny calling policy enabled to use external location lookup. On the iPhone (15), I also have location services for Teams enabled and precise location “on”.
When I open the Teams app, the map correctly shows the location; I allow it to be used. I dial 933 and the address it determined is indeed correct, but it says “low confidence” and would have gone to screening center.
I’ve tried a few different things and from a few locations with same result – the address/location is identified correctly, but 933 test call still says it was low confidence. I can’t figure out why or how to get it to be recognized as a “valid” address to not go to screening center.
Testing 911 with Teams app (via 933) using Teams and Operator connect. I have user emergecny calling policy enabled to use external location lookup. On the iPhone (15), I also have location services for Teams enabled and precise location “on”. When I open the Teams app, the map correctly shows the location; I allow it to be used. I dial 933 and the address it determined is indeed correct, but it says “low confidence” and would have gone to screening center. I’ve tried a few different things and from a few locations with same result – the address/location is identified correctly, but 933 test call still says it was low confidence. I can’t figure out why or how to get it to be recognized as a “valid” address to not go to screening center. Read More
Cannot export powerpoint recordings.
Hi,
I tried to record a powerpoint video and was successful. However, I cannot download or share the video since the “export video” option does not appear. I am using a Mac. Pls help.
Cheers!
Chrishain
Hi, I tried to record a powerpoint video and was successful. However, I cannot download or share the video since the “export video” option does not appear. I am using a Mac. Pls help. Cheers!Chrishain Read More
Stop a group of users communicating with each other
Hi all,
What is the best way to stop a specific group of users communicating with each other?
Hi all, What is the best way to stop a specific group of users communicating with each other? Read More
Outlook Login Boot Loop problem?
Hello, I have a very strange issue when logging into Outlook for windows I get several attempts to login per second or any interaction within the app to try and establish an account but it always fails I’ve tried deleting certificates refreshing user accounts tied to outlook via windows settings and I’ve tried scanpst.exe all to no avail any help would be greatly appreciated!
Hello, I have a very strange issue when logging into Outlook for windows I get several attempts to login per second or any interaction within the app to try and establish an account but it always fails I’ve tried deleting certificates refreshing user accounts tied to outlook via windows settings and I’ve tried scanpst.exe all to no avail any help would be greatly appreciated! Read More
Defender for Endpoint licensing within Azure Virtual Desktop
Hi all,
I would like to have an official confirmation of the current status. Can we use Microsoft Defender for Endpoint (per user), Windows Enterprise E5, Microsoft 365 E5 Security, or Microsoft 365 E5 for all of these use cases:
– Windows 10/11 session hosts?
– Windows Server (2016/2019/2022/2025) session hosts? This would be a server OS, so maybe not possible to do per user licensing?
– Personal vs. pooled session hosts?
Can we, as an alternative, choose licensing based on Microsoft Defender for Servers Plan 1 or Plan 2 (as part of the Defender for Cloud) offering or Microsoft Defender for Endpoint for Servers in all the same use cases? I guess it would not be possible or wise to make any combinations of these two licensing scenario’s for a single Azure Virtual Desktop environment?
In that second scenario and for a nonprofit organization, would it be recommended to use Microsoft Defender for Endpoint for Servers licenses? As they are often eligible for a considerable discount that they will not receive when using (PAYG) Microsoft Defender for Servers Plan 1 or Plan 2?
Many thanks for your response!
Sources:
Onboard Windows devices in Azure Virtual Desktop | Microsoft Learn
Minimum requirements for Microsoft Defender for Endpoint | Microsoft Learn
Hi all, I would like to have an official confirmation of the current status. Can we use Microsoft Defender for Endpoint (per user), Windows Enterprise E5, Microsoft 365 E5 Security, or Microsoft 365 E5 for all of these use cases:- Windows 10/11 session hosts?- Windows Server (2016/2019/2022/2025) session hosts? This would be a server OS, so maybe not possible to do per user licensing?- Personal vs. pooled session hosts? Can we, as an alternative, choose licensing based on Microsoft Defender for Servers Plan 1 or Plan 2 (as part of the Defender for Cloud) offering or Microsoft Defender for Endpoint for Servers in all the same use cases? I guess it would not be possible or wise to make any combinations of these two licensing scenario’s for a single Azure Virtual Desktop environment? In that second scenario and for a nonprofit organization, would it be recommended to use Microsoft Defender for Endpoint for Servers licenses? As they are often eligible for a considerable discount that they will not receive when using (PAYG) Microsoft Defender for Servers Plan 1 or Plan 2? Many thanks for your response! Sources:Onboard Windows devices in Azure Virtual Desktop | Microsoft LearnMinimum requirements for Microsoft Defender for Endpoint | Microsoft Learn Read More
consume salesforce dataset through ADF
Hi everyone,
I am trying to build ADF to connect to salesforce. I am able to connect to the salesforce objects but not the salesforce analytics datasets. Can you please help how can I connect to the salesforce dataset (not object) from ADF. added screenshot of a dataset from salesforce
Hi everyone, I am trying to build ADF to connect to salesforce. I am able to connect to the salesforce objects but not the salesforce analytics datasets. Can you please help how can I connect to the salesforce dataset (not object) from ADF. added screenshot of a dataset from salesforce Read More