Month: November 2024
SharePoint List – Count People Column
I’m wondering if it’s possible to have one column display a running count of the number of people in a people column?
Use-case: I’m creating a Professional Development SharePoint site and a List to track what trainings are available. I have a column called Maximum Attendees, and I need a column to count from the Registered Attendees so I can make another column to count how many seats are left. I’ve tried a Calculated Value, but People columns aren’t available to use.
I’m wondering if it’s possible to have one column display a running count of the number of people in a people column? Use-case: I’m creating a Professional Development SharePoint site and a List to track what trainings are available. I have a column called Maximum Attendees, and I need a column to count from the Registered Attendees so I can make another column to count how many seats are left. I’ve tried a Calculated Value, but People columns aren’t available to use. Read More
Democratize Windows Performance Analysis
A new, public toolset for analyzing the performance of Windows / Office / Apps is now available on the Microsoft GitHub site: https://github.com/Microsoft/MSO-Scripts
Based on tools used by MS Office teams to promote broad use of Event Tracing for Windows (ETW), it’s now available to facilitate performance analysis by IT Pros, etc.
We’re looking for help to BETA test and review documentation.
Can you help?
The toolset consists of highly customizable PowerShell scripts & XML configs to drive WPR/WPA, plus a custom plug-in for network analysis.
Wiki documentation covers a wide variety of topics:
CPU/Thread activityNetwork connectionsFile and Disk I/OWindows Handles: Kernel, User, GDIMemory Usage: Heap, RAM, Working Set, Reference Set, …Office-specific loggingSymbol ResolutionCustom TracingCPU Counters,
etc.
There’s also a growing YouTube channel: Windows Performance Deep Dive
Introduction to MSO-Scripts (video)
Suggestions? Reports?
Thank you in advance…
A new, public toolset for analyzing the performance of Windows / Office / Apps is now available on the Microsoft GitHub site: https://github.com/Microsoft/MSO-ScriptsBased on tools used by MS Office teams to promote broad use of Event Tracing for Windows (ETW), it’s now available to facilitate performance analysis by IT Pros, etc.We’re looking for help to BETA test and review documentation.Can you help? The toolset consists of highly customizable PowerShell scripts & XML configs to drive WPR/WPA, plus a custom plug-in for network analysis.Wiki documentation covers a wide variety of topics:CPU/Thread activityNetwork connectionsFile and Disk I/OWindows Handles: Kernel, User, GDIMemory Usage: Heap, RAM, Working Set, Reference Set, …Office-specific loggingSymbol ResolutionCustom TracingCPU Counters,etc.There’s also a growing YouTube channel: Windows Performance Deep DiveIntroduction to MSO-Scripts (video) Suggestions? Reports?Thank you in advance… Read More
Use GDAP to set up least privilege access in Microsoft 365 Lighthouse
Use GDAP to set up least privilege access in Microsoft 365 Lighthouse
We’ve updated how granular delegated administrative privileges (GDAP) are managed in Lighthouse by adding a new Delegated access page that lets you manage GDAP templates and see GDAP relationship details.
This post explains these improvements and guides you on how to use the Delegated access page to establish GDAP relationships with your customers.
Why GDAP is important for your organization
GDAP is a security feature that provides managed service providers (MSPs) with least privilege access following the Zero Trust security strategy. With GDAP, you request granular and time-bound access to customer workloads, and the customer provides consent for the requested access. By setting up GDAP for the customer tenants that you manage, you help keep your customers secure while ensuring users in your partner organization have the permissions necessary to do their work. To learn more about GDAP, see Introduction to granular delegated admin privileges (GDAP).
Enhanced GDAP management experience
Our new GDAP management experience allows you to set up GDAP in the manner you’re familiar with. However, based on feedback from MSPs, we made several updates to give you more flexibility in how you set up GDAP and made it easier to manage existing GDAP relationships. We also made performance enhancements so that the new experience is faster, especially when it comes to assigning GDAP templates to multiple tenants at a time.
With our Lighthouse GDAP templates, you can now:
Assign any Microsoft Entra role to each support role (previously, you could only select the Microsoft-recommended setup for each support role).
Add existing security groups to a GDAP template (previously, you had to create a new security group).
Create just-in-time (JIT) access policies for new security groups (previously, you could only create a JIT access policy for the Administrator support role).
We also updated the
View the status of GDAP relationships with customers.
Identify the next expiration date for each GDAP relationship.
Set up GDAP with GDAP templates
From the GDAP templates tab of the Delegated access page, you can create, edit, and assign GDAP templates to customer tenants.
A screenshot showing the GDAP templates tab on the Delegated access page in Lighthouse
For each GDAP template, you can:
Define the name and description of the template.
Use the Microsoft-recommended selection of Microsoft Entra roles for each support role, or customize the Microsoft Entra roles to align with your organization’s needs.
Add security groups to each support role. We recommend setting up a JIT access policy
A screenshot showing the Create a template pane on the Delegated access page in Lighthouse.
After you create a GDAP template, assign the template to your desired customers by selecting the three dots (more actions) and following the prompts.
A screenshot showing how to assign a template to a customer tenant on the Delegated access page in Lighthouse
View GDAP relationships
To view details about your GDAP relationships, regardless of whether the relationships were created in Lighthouse or not, select the Relationships tab on the Delegated access page. You can use this tab to see which relationships are expiring soon. If you need to create a new GDAP relationship with a customer, go to the GDAP templates tab to assign a GDAP template to a customer tenant. When you select a GDAP relationship with an Active status, you can also view and edit security group membership and view the Microsoft Entra roles associated with each security group.
The following details are provided:
GDAP relationship status (Pending or Active)
Microsoft Entra roles associated with the selected tenant
Security groups and members associated with the selected tenant
Start date and expiration date of each GDAP relationship
A screenshot showing the Relationships tab of the Delegated access page in Lighthouse.
Benefits of using Lighthouse to manage GDAP
Using Lighthouse to manage GDAP provides several benefits to MSPs who are already using Lighthouse to actively manage and secure customer tenants:
Centralized management: Lighthouse provides a centralized platform to manage GDAP relationships across all of your customer tenants. This allows you to streamline administrative tasks and ensure consistency in managing permissions and access.
Efficiency and scalability: Lighthouse lets you create and assign GDAP templates to customer tenants in bulk or individually. This makes it easier to manage permissions at scale, especially for MSPs who manage multiple customers.
Visibility and control: The Delegated access page in Lighthouse provides detailed insights into your GDAP relationships, including the status and expiration dates of each relationship. This helps you maintain control and stay informed about your administrative privileges.
Customizable roles: You can customize Microsoft Entra roles to align with your organization’s needs, ensuring that the right permissions are assigned to the right users. This flexibility allows you to tailor GDAP setup to fit your specific requirements.
JIT access: Implementing JIT access policies for security groups ensures that permissions are time-bound and limited to when they are needed. This further enhances security by reducing the window of opportunity for potential misuse.
By using Lighthouse to manage GDAP, you can achieve a higher level of security, efficiency, and control over your administrative tasks, ultimately benefiting both your organization and your customers.
Try out our enhanced GDAP management experience today by signing in to Lighthouse and following the steps in Set up GDAP in Microsoft 365 Lighthouse.
To learn more about Lighthouse and GDAP, check out the following resources:
Overview of Microsoft 365 Lighthouse
Sign up for Microsoft 365 Lighthouse
GDAP frequently asked questions – Partner Center
We want to hear from you! Select Give feedback in the lower-right corner of any page in Lighthouse to provide feedback, or go to the feedback portal now and let us know what’s on your mind. We’re committed to making Lighthouse your one-stop shop for managing customer health and security.
Microsoft Tech Community – Latest Blogs –Read More
Simplifying Migration to Fabric Real-Time Intelligence for Power BI Real Time Reports
Simplifying Migration to Fabric Real-Time Intelligence for Power BI Real Time Reports
Power BI with real-time streaming has been the preferred solution for users to visualize streaming data. Real-time streaming in Power BI is being retired. We recommend users to start planning the migration of their data processing pipeline to Fabric Real-Time Intelligence.
Microsoft Fabric Real-Time Intelligence is a part of the Microsoft Fabric platform. It enables businesses to ingest, process, analyze, and gain insights from real-time data streams. It provides an end-to-end solution for integrating real-time data pipelines, offering advanced analytics and data visualization in one place.
This document outlines the patterns and best practices as you explore Fabric Real-Time Intelligence and the Azure ecosystem.
1. Real-Time data flow architecture
Figure 1.1 below is a general data flow pattern for a real time data analysis and visualization on Azure.
Figure1.1
On the left side, we have common real time data ingestion service like Azure Event hub, IoTHub etc. Next, we have azure stream analytics which is a fully managed stream processing engine that is designed to analyze and process large volumes of streaming data with sub-millisecond latencies. You will also find some event driven applications using Power Automate or Logic Apps for simple event processing. The processed events are then sent to streaming datasets in Power BI and to some persistent storage layer.
2. Insights into Fabric Real-Time Intelligence
Fabric Real-Time intelligence is a powerful service that empowers everyone in your organization to extract insights and visualize their data in motion.
2.1 Ingestion & Processing
Eventstream in the Microsoft Fabric Real-Time Intelligence lets you bring real-time events into Fabric, transform them, and then route them to various destinations without writing any code. Event streams provide you with multiple source connectors to fetch event data from the various sources.
If you want to connect your own application with an eventstream, you can add a custom endpoint or a custom app as a source. This is described in detail in the following section.
In Eventstream, the event processor editor is a no-code experience that allows you to drag and drop to design the event data processing logic. Here is a link to learn more about event processor editor Event processor editor. You can then route the transformed data to various destinations.
For real-time reporting experience we would recommend using Fabric Eventhouse KQL database. Eventhouses provide a solution for handling and analyzing large volumes of data, particularly in scenarios requiring real-time analytics and exploration.
Figure 1.2
2.2 Deliver & Visualize
You can build real time reports using auto page refresh feature of Power BI with sources that support direct query. Power BI direct query is supported by Fabric Eventhouse KQL database. Use this link to learn more about automatic page refresh feature in PowerBI.
Direct query feature can be used with either of the selected Eventstream destination, Eventhouse or Lakehouse. However, Eventhouse KQL database offers robust solution for managing and analyzing substantial volumes of real-time data.
Eventhouse is designed to scale efficiently, ensuring effective performance and resource use. This design is beneficial in situations where timely insights are important. Specifically built for time-based, streaming events with features like auto indexing and partitioning based on ingestion time.
3. Azure Stream Analytics
Azure Stream Analytics PowerBI output sends the transformed data to PowerBI to build rich visualizations of analysis results. Migrating Azure Stream Analytics (ASA) jobs that utilize the Power BI output connector involves few key considerations to ensure a seamless transition and maintain real-time data visualization capabilities.
3.1 Ingestion & Processing
For users leveraging Stream Analytics with Power BI output connector in their architecture, who are unable to migrate their solution to Fabric, alternative patterns can be explored following Power BI output connector retirement.
With the processing and data analytics logic implemented in Azure Stream Analytics, you can:
Route Stream Analytics output to Fabric.
Switch to other Stream Analytics connectors that support direct query mode in Power BI.
To push Stream Analytics output data to Fabric you can use Eventstream custom endpoint connector. Here is a link to learn how to add a custom endpoint or a custom app as a source to Eventstream. Add a custom endpoint or custom app source to an eventstream
Once Eventstream custom endpoint setup is complete you should have an event hub namespace and connection details available in the Eventstream. Now back in Azure Stream Analytics you can select Event Hub output connector and add the custom With this setup your existing steam analytics job can now publish data to Fabric Eventstream. Next you can add Eventhouse as your destination in Eventstream and follow the same pattern described above.
Figure 1.3
The Power BI direct query feature is compatible with various ASA and Fabric Eventstream output destinations. Here is a list of other ASA and Eventstream output connectors you can use to build reports in PowerBI with direct query.
Other Azure Stream Analytics output connectors:
SQL Server
PostgreSQL
SynapseSQL
Azure Data Explorer
Other Eventstream destination:
Lakehouse
3.2 Deliver & Visualize
In Power BI you will select Get data with KQL database or one of the sources mentioned above to design your visualization and reports.
You can choose other sources with import mode if you do not plan to use PowerBI’s auto page refresh feature.
4. Fabric, Real-Time dashboard
For the use cases where you are doing schedule refresh and looking for very short interval auto-refresh experience you can also explore Fabric Real-Time Dashboard. You can natively export Kusto Query Language (KQL) queries to a dashboard as visuals and later modify their underlying queries and visual formatting as needed. In addition to ease of data exploration, this fully integrated dashboard experience provides improved query and visualization performance.
Figure 1.4
5. Call to action
If you have questions on migration recommendations, please reach out to RTISupport.
For any questions on Azure stream analytics please contact askasa@microsoft.com
Other Useful links
Real-time streaming in Power BI
Automatic page refresh in Power BI Desktop – Power BI | Microsoft Learn
What is Real-Time Intelligence?
Microsoft Fabric event streams – overview
Introduction to Microsoft Fabric Real-Time hub – Microsoft Fabric | Microsoft Learn
Introduction to Azure Stream Analytics – Azure Stream Analytics | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Background color
How do I change the background color back to white?
Where File Home Insert Page Layout Formulas etc are located
How do I change the background color back to white?Where File Home Insert Page Layout Formulas etc are located Read More
Entering in commands on a remote workstation using a PS script
I am trying to create a PS script that opens a session on a remote workstation and executes these commands:
$session = New-PSSession -ComputerName $workstationName
# Prompt for credentials
$cred = Get-Credential
# Use Invoke-Command to run the script block with elevated credentials
Invoke-Command -Session $session -Credential $cred -ScriptBlock {
# Check if the session is available
if ($session -ne $null) {
Write-Host “Session established. Waiting for the session to be ready…”
# PowerShell commands here
netsh advfirewall firewall set rule name=”File and Printer Sharing (Echo Request – ICMPv4-In)” new enable=yes profile=domain
Set-ItemProperty -Path ‘HKLM:SystemCurrentControlSetControlTerminal Server’-name “fDenyTSConnections” -Value 0
Enable-NetFirewallRule -DisplayGroup “Remote Desktop”
netsh advfirewall firewall set rule group=”windows management instrumentation (wmi)” new enable=yes
Set-NetFirewallRule -DisplayGroup “Network Discovery” -Enabled True
Get-Process
}
# Exit the remote session
Exit-PSSession
} else {
Write-Host “Failed to establish a session.”
}
Here is the error. Any help is appreciated
Invoke-Command : Parameter set cannot be resolved using the specified named parameters.
At C:XXXXVMPrepBeta6.ps1:67 char:5
+ Invoke-Command -Session $session -Credential $cred -ScriptBlock {
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [Invoke-Command], ParameterBindingException
+ FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.PowerShell.Commands.InvokeCommandCommand
I am trying to create a PS script that opens a session on a remote workstation and executes these commands: netsh advfirewall firewall set rule name=”File and Printer Sharing (Echo Request – ICMPv4-In)” new enable=yes profile=domain Set-ItemProperty -Path ‘HKLM:SystemCurrentControlSetControlTerminal Server’-name “fDenyTSConnections” -Value 0 Enable-NetFirewallRule -DisplayGroup “Remote Desktop” netsh advfirewall firewall set rule group=”windows management instrumentation (wmi)” new enable=yes Set-NetFirewallRule -DisplayGroup “Network Discovery” -Enabled True This is the part of the script giving me trouble: $session = New-PSSession -ComputerName $workstationName# Prompt for credentials$cred = Get-Credential# Use Invoke-Command to run the script block with elevated credentialsInvoke-Command -Session $session -Credential $cred -ScriptBlock {# Check if the session is availableif ($session -ne $null) {Write-Host “Session established. Waiting for the session to be ready…”# PowerShell commands herenetsh advfirewall firewall set rule name=”File and Printer Sharing (Echo Request – ICMPv4-In)” new enable=yes profile=domainSet-ItemProperty -Path ‘HKLM:SystemCurrentControlSetControlTerminal Server’-name “fDenyTSConnections” -Value 0Enable-NetFirewallRule -DisplayGroup “Remote Desktop”netsh advfirewall firewall set rule group=”windows management instrumentation (wmi)” new enable=yesSet-NetFirewallRule -DisplayGroup “Network Discovery” -Enabled TrueGet-Process}# Exit the remote sessionExit-PSSession} else {Write-Host “Failed to establish a session.”} Here is the error. Any help is appreciated Invoke-Command : Parameter set cannot be resolved using the specified named parameters.At C:XXXXVMPrepBeta6.ps1:67 char:5+ Invoke-Command -Session $session -Credential $cred -ScriptBlock {+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : InvalidArgument: (:) [Invoke-Command], ParameterBindingException+ FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.PowerShell.Commands.InvokeCommandCommand Read More
Build Your Dream Lineup with Quick Lineup!
Hey everyone! I recently came across an amazing platform called Quick Lineup, perfect for anyone who loves creating custom football lineups. Whether you want to build your dream team, experiment with formations, or create an ideal starting 11, Quick Lineup makes it simple and fun.
What I really like about Quick Lineup is how user-friendly it is. You can pick any team, arrange the lineup in any formation you want, and make adjustments with ease. Want to go for a classic 4-4-2 or try a more modern 3-5-2 setup? It’s all just a click away.
I’m curious to hear your thoughts! Do you think Quick Lineup would make it easier to create the perfect lineup? Or do you have a lineup you’d love to see on this platform?
Has anyone here tried Quick Lineup before? If so, what features did you enjoy, or are there any you’d like to see added? Let’s discuss!
Hey everyone! I recently came across an amazing platform called Quick Lineup, perfect for anyone who loves creating custom football lineups. Whether you want to build your dream team, experiment with formations, or create an ideal starting 11, Quick Lineup makes it simple and fun. What I really like about Quick Lineup is how user-friendly it is. You can pick any team, arrange the lineup in any formation you want, and make adjustments with ease. Want to go for a classic 4-4-2 or try a more modern 3-5-2 setup? It’s all just a click away. I’m curious to hear your thoughts! Do you think Quick Lineup would make it easier to create the perfect lineup? Or do you have a lineup you’d love to see on this platform? Has anyone here tried Quick Lineup before? If so, what features did you enjoy, or are there any you’d like to see added? Let’s discuss! Read More
Review for Responsible Artificial Intelligence (RAI) issues
Following Stuart Ridout’s sample on building an AI prompt challenge, I got this error. However, there is no indication of where the violation is. It would be helpful to understand what exactly is triggering this warning.
Following Stuart Ridout’s sample on building an AI prompt challenge, I got this error. However, there is no indication of where the violation is. It would be helpful to understand what exactly is triggering this warning. Read More
Color, Conditions, and Copilot: How to save time using conditional formatting with Copilot in Excel
Hi everyone, this is part 11 in a series of posts to show you some of the things that are possible to do with Copilot in Excel.
What is conditional formatting?
Conditional formatting in Excel is a powerful tool that allows you to apply specific formatting to cells that meet certain criteria. This can include changing the cell’s background color, font color, or adding icons to highlight differences in data. By using conditional formatting, you can help data to stand out and emphasize what’s important, applying your rules automatically as your data changes and grows.
Excel already offers a variety of conditional formatting options you can apply manually to help you call attention to your data: https://support.microsoft.com/en-us/office/fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
How does Copilot make it better?
Using a formula to determine which cells to format is one of the most versatile conditional formatting tools. However, it can be challenging to set it up to do exactly what you want. You must get the formula and syntax exactly right without having the tools and tips of the formula bar or seeing interim results in cells. With Copilot, you can simply use language to describe exactly what you want to happen.
For example, in this post (Re: Conditional formatting – Microsoft Community Hub), the customer knew exactly how they wanted to color their data. They wanted to flag certain info in different ways based on a payment status and a date. If they utilized Copilot, they could have asked to “Highlight rows in red when the date is this month or earlier and the customer has not paid. Highlight rows in yellow when the date is next month, and the customer has not paid.”
Screenshot of Excel with conditional formatting suggestion from Copilot based on the prompt.
In this example, Copilot understood my table of data, interpreted my prompt, and responded with two conditional formatting rules for me to review and apply. I can deduce that the top rule assigns a red color by comparing the current date to the due date and checking if it’s in the past when the paid status is ‘no’. I can deduce the second rule assigns a yellow color by comparing the current date to the due date and checking if it’s in the future when the paid status is ‘no’. I did not need to know the logical order, needed formulas, or exact syntax to get this result. I only had to tell Copilot what I wanted.
After I review and then apply these custom formula conditional formatting rules, my worksheet shows the appropriate colors and will adjust when I change the data.
Gif showing application of Copilot generated conditional format and then how editing data updates the coloring based on the rule.
What else should I know?
You can also ask copilot to do other types of highlighting:
Make values in ‘Column Name’ greater than ‘number’ have white text on a black background.
Highlight cells in light blue for ‘Column Name’ that contain ‘Specific Text’
Highlight the top 10% of values in ‘Column Name’ using bold font
Apply a Red and Green color scale to the values in ‘Column Name’
When you have applied any conditional formatting rules using Copilot, you can manage and edit existing rules by choosing Conditional Formatting > Manage Rules from the toolbar or ribbon.
Screenshot of the Conditional Formatting menu
Conditional formatting in Excel is a versatile tool that can help you analyze and present your data more effectively. By exploring the various capabilities of conditional formatting in combination with Copilot you can unlock the full potential of this feature and make your spreadsheets more informative and visually engaging.
Microsoft Tech Community – Latest Blogs –Read More
Linux and Open Source on Azure Quarterly Update – October 2024
Since our last update in July, there’s been no shortage of new exciting updates and news for Linux and open source on Azure. Dive in to learn more!
What’s new with Linux on Azure
AlmaLinux is available as an endorsed Linux distribution
AlmaLinux, a popular alternative to CentOS Linux, has been available in the Azure Marketplace for over three years and is now an endorsed Linux distribution in Azure. As an endorsed Linux distribution, AlmaLinux will adhere to testing and update standards, while also receiving support as detailed in Microsoft’s Linux and open source support policy. Visit our blog to learn more.
Linux Promotional Offer
I’m excited to share that there is a promotional offer for the latest Linux VMs in Azure. For a limited time, you can save an additional 15% on one-year Azure Reserved Virtual Machine (VM) Instances for the latest Linux VMs. This means you could save up to 56% compared to running an Azure VM on a PAYG (pay-as-you-go) basis. This offer is available until March 31, 2025. To learn more, read the blog and refer to the terms and conditions.
ED25519 SSH key support for Linux VMs (Generally Available)
ED25519 SSH key support for Linux VMs is now generally available in Azure, providing customers with enhanced security and deployment efficiency on Azure. Now customers can choose between RSA and ED25519 based SSH keys.
Azure Cobalt 100-based Virtual Machines (Generally Available)
We recently announced the general availability of the new Azure Cobalt 100-based Virtual Machines. These VMs run on Microsoft’s first 64-bit Arm-based Azure Cobalt 100 CPU, which has been fully designed in-house. They offer up to 50% better price performance than our previous generation Arm-based VMs, making them an appealing option for a wide range of scale-out and cloud-native Linux-based workloads, including data analytics, web and application servers, open source databases, caches, and more. The new Azure Cobalt 100 VMs support a wide range of Linux distributions including AlmaLinux, Azure Linux (via AKS), Debian, Flatcar Linux, Red Hat Enterprise Linux, SUSE Enterprise Linux, Ubuntu, and more. Check out our blog to get more information.
Landing Zone for Red Hat Enterprise Linux
We’ve developed a landing zone for RHEL on Azure, offering design recommendations and a reference architecture to help support successful RHEL deployments. An Azure landing zone serves as a blueprint for cloud success. Read the blog for more details.
New guides for deploying open source software on Azure
On Azure, you can build and run applications using the open source software of your choice, whether it’s Linux or databases like as PostgreSQL and MySQL. To help accelerate your journey with open source on Azure, we’ve developed end-to-end guides for deploying open source software across a variety of workloads and include projects such as KAITO, PostgreSQL, and Inspektor Gadget. Read the blog for more information.
Azure confidential VMs with NVIDIA H100 Tensor Core GPUs (Generally Available)
We announced the general availability of confidential virtual machines (VMs) with NVIDIA H100 Tensor core GPUs. These VMs are ideal for inferencing, fine-tuning or training small-to-medium sized models such as Whisper, Stable diffusion and its variants (SDXL, SSD), and language models such as Zephyr, Falcon, GPT2, MPT, Llama2, Wizard and Xwin. Ubuntu 24.04 is the available Linux OS for these VMs. Visit the blog for additional details.
What’s new with Azure and open source
Flatcar accepted into CNCF at incubating level
Flatcar has been accepted by the CNCF at incubating level, signaling that the project is considered stable and is used successfully in production environments. This is an exciting milestone for the Flatcar project and cloud native community! For more details, read Brendan Burns’ blog and the CNCF blog.
Linux and open source events
Over the past few months, we gave talks and connected with other open source enthusiasts at several events, including All Systems Go!, Container Days, Data and AI Masters, DebConf24, Flock to Fedora 2024, FrOSCon, Linux Security Summit, Open Source Summit Europe, Red Hat Summit Connect, Ubuntu Summit, and more. If you missed any of the Microsoft sessions or want to check them out again you can catch some of the recordings:
Event
Session(s)
All Systems Go!
Introducing azure-init, a minimal provisioning agent written in Rust
Waiter, an OS please, with some sysext sprinkled on top
Container Days
Container Linux: The Next 10 Years
UX: the missing cloud native ingredient
DebConf24
Flock to Fedora
Unlocking Systems Insights: Leveraging eBPF for Data Collection
FrOSCon
Flatcar Linux: what’s new in this Container OS?
Linux Security Summit
Open Source Summit Europe
LVBS and Advanced Kernel Integrity
Verifying and Signing EBPF Programs with Inspektor Gadget
Contain Your Excitement: A Developer’s Guide to Containerized Brillance
Linux Sandboxing with Landlock
Next-Gen Testing and Compliance: Ensuring Integrity in a Complex World
Open Source Software Engineering Education
What’s coming up next
Microsoft Ignite 2024
Microsoft Ignite is coming to the Windy City (Chicago) this year from November 19-22! Whether you’re joining in-person or virtually, be sure to catch one of the Linux and open source sessions:
Session Type
Session
Breakout
What’s new in Linux: How we’re collaborating to help shape its future
Demo
Accelerate deployment of open source applications with Copilot in Azure
Lab (hosted 3x)
Fast track your Linux migration journey with Azure Migrate
Also, you can connect with and attend sessions from Canonical and Red Hat, who are Featured Partners at Ignite.
Upcoming Linux and open source events
We’ll be at KubeCon North America in Salt Lake City! Check out one of the Microsoft sessions and meet with us at our booth.
Sign up for Cloud Native Rejekts (organized/sponsored by Microsoft)
Sign up for the AKS pre-day
Bonus content
Read about LinkedIn’s journey to migrate most of their estate to Azure Linux
Check out this guest blog post by Jehudi Castro, Public Cloud Alliances Director at Canonical, to learn how Canonical and Azure are working together to improve security, operational efficiency, and performance in the cloud using Linux and open-source software.
If you have any feedback or questions, please drop them in the comments. We’d love to hear from you!
Microsoft Tech Community – Latest Blogs –Read More
Search for text within a cell and returning value based on what is found or leave the cell blank
I need to Search for text within a cell and returning value based on what is found or leave the cell blank if neither is found. Hello, I need to amend this example formula so if cell C3 finds “apple” that the value $1 is returned, but if it finds “orange” that the value is $2 and if neither word is in cell C3 that a blank is returned. =IF(OR(ISNUMBER(SEARCH(“apple”,C3)),ISNUMBER(SEARCH(“apple”,C3))),”1″,””)
I need to Search for text within a cell and returning value based on what is found or leave the cell blank if neither is found. Hello, I need to amend this example formula so if cell C3 finds “apple” that the value $1 is returned, but if it finds “orange” that the value is $2 and if neither word is in cell C3 that a blank is returned. =IF(OR(ISNUMBER(SEARCH(“apple”,C3)),ISNUMBER(SEARCH(“apple”,C3))),”1″,””) Read More
मैं फोनपे ऐप से शिकायत कैसे करूं?√√•
फोनपेपर शिकायत कैसे दर्ज करूँ? ग्राहक आप फोनपे हेल्पलाइन नंबर ( +91 O6290-348-172 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।…
फोनपेपर शिकायत कैसे दर्ज करूँ? ग्राहक आप फोनपे हेल्पलाइन नंबर ( +91 O6290-348-172 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… Read More
पेटीएम से पैसे वापस कैसे पाए अगर गलत ट्रांजेक्शन हो जाए? –
पेटीएम से पैसे वापस कैसे पाए अगर गलत ट्रांजेक्शन हो जाए? – आप पेटीएम हेल्पलाइन नंबर ( +91 O6290-348-172 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… ,,,
पेटीएम से पैसे वापस कैसे पाए अगर गलत ट्रांजेक्शन हो जाए? – आप पेटीएम हेल्पलाइन नंबर ( +91 O6290-348-172 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… ,,, Read More
फोनपे गलत ट्रांजेक्शन से पैसे कैसे वापस करें?
फोनपे गलत ट्रांजेक्शन से पैसे कैसे वापस करें? आप फोनपे हेल्पलाइन नंबर ( +91 O6290-348-172 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।…
फोनपे गलत ट्रांजेक्शन से पैसे कैसे वापस करें? आप फोनपे हेल्पलाइन नंबर ( +91 O6290-348-172 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… Read More
Access – how to joining two queries with different data without doubling data
I’m not sure how to phrase my issue, which makes finding a solution also difficult
I’m trying to combine two different queries so I can run a report that shows all of the crops FarmerID is growing as well as the number of livestock . One query is labeled qryCrops and the other qryLivestock. Both queries have the same FarmerID (the unique key). The problem is I have a variety of scenarios: some farmers have multiple crops and only one type of livestock, other farmers have one crop and multiple types of livestock, some have multiples of both, etc. Whenever I try connecting the data, Access automatically doubles the information (see example below).
I’ve tried joining data which hasn’t worked. A query with a left join won’t duplicate the crops, but will duplicate livestock. A query with a right join won’t duplicate the livestock, but will duplicate the crops. I’ve tried running a left and right join query separately, and then combining both queries into a Union query, and my data still is getting doubled (I suspect that’s not the right option as I’m not comparing apples to apples). Nothing seems to work! I’ve tried searching the internet and have been unsuccessful at finding a solution.
Here is what I want; I want access to leave fields blank if there is no data:
FarmerID
Acres
CropType
LivestockNum
LivestockType
Farmer A
6
Pasture
3
Cows
Farmer A
10
Hay
Farmer B
15
Pasture
2
horses
Farmer B
100
chickens
This is what I get when I combine the data:
FarmerID
Acres
CropType
LivestockNum
LivestockType
Farmer A
6
Pasture
3
Cows
Farmer A
10
Hay
3
Cows
Farmer B
15
Pasture
2
horses
Farmer B
15
Pasture
100
chickens
Any thoughts?
Our reports are currently set up to show the farmers and all of their crops, then the next section has the farmers and all of their livestock. I want a report that’s grouped by the farmer so it shows all of their information in one place (without doubling data), then moves on to the next farmer. I’m hoping the query solution mentioned above will solve that.
Thanks in advance!
I’m not sure how to phrase my issue, which makes finding a solution also difficult I’m trying to combine two different queries so I can run a report that shows all of the crops FarmerID is growing as well as the number of livestock . One query is labeled qryCrops and the other qryLivestock. Both queries have the same FarmerID (the unique key). The problem is I have a variety of scenarios: some farmers have multiple crops and only one type of livestock, other farmers have one crop and multiple types of livestock, some have multiples of both, etc. Whenever I try connecting the data, Access automatically doubles the information (see example below). I’ve tried joining data which hasn’t worked. A query with a left join won’t duplicate the crops, but will duplicate livestock. A query with a right join won’t duplicate the livestock, but will duplicate the crops. I’ve tried running a left and right join query separately, and then combining both queries into a Union query, and my data still is getting doubled (I suspect that’s not the right option as I’m not comparing apples to apples). Nothing seems to work! I’ve tried searching the internet and have been unsuccessful at finding a solution. Here is what I want; I want access to leave fields blank if there is no data:FarmerIDAcresCropTypeLivestockNumLivestockTypeFarmer A6Pasture3CowsFarmer A10Hay Farmer B15Pasture2horsesFarmer B 100chickens This is what I get when I combine the data:FarmerIDAcresCropTypeLivestockNumLivestockTypeFarmer A6Pasture3CowsFarmer A10Hay3CowsFarmer B15Pasture2horsesFarmer B15Pasture100chickens Any thoughts?Our reports are currently set up to show the farmers and all of their crops, then the next section has the farmers and all of their livestock. I want a report that’s grouped by the farmer so it shows all of their information in one place (without doubling data), then moves on to the next farmer. I’m hoping the query solution mentioned above will solve that. Thanks in advance! Read More
Alt + Enter on Azure VM in Excel
When logged into an Azure Virtual Desktop AVD, users are unable to use Alt + Enter. I’ve seen pages of keyboard shortcuts but none for Excel Starting New Line within a Cell.
thanks
When logged into an Azure Virtual Desktop AVD, users are unable to use Alt + Enter. I’ve seen pages of keyboard shortcuts but none for Excel Starting New Line within a Cell.thanks Read More
मैं फोनपे पर गलत ट्रांजेक्शन कैसे रिफंड करूं?
मैं पेटीएम पर गलत ट्रांजेक्शन कैसे रिफंड करूं? में जाकर “ट्रांजैक्शन” ((,+91-629O-348-172) या “इतिहास” सेक्शन में जाएं. असफल लेन- देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें. अगर रिफंड नहीं मिलता, तो अपने बैंक से संपर्क करे.
मैं पेटीएम पर गलत ट्रांजेक्शन कैसे रिफंड करूं? में जाकर “ट्रांजैक्शन” ((,+91-629O-348-172) या “इतिहास” सेक्शन में जाएं. असफल लेन- देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें. अगर रिफंड नहीं मिलता, तो अपने बैंक से संपर्क करे. Read More
Cannot switch workspace on Desktop App
Hi everybody,
My team and I are having issues using the de MS Teams Desktop App with a guest account.
Context:
We work for a company that doesn’t have an MS Teams license but we are “Staff Augmentation” for another company that uses MS Teams as the primary communication tool. The other company added us as “Guest” in their workspace.
The problem we are having is that on the desktop app when we log in with our main company credentials we get this message because our company doesn’t have a license:
However, we don’t want to enter our company’s Workspace, we want to enter the other company’s workspace (that does have a license).
In the past, we were able to switch by clicking on the “Launch trial” button, and on the next screen, we had the option to switch. But now, when we click that button we get another error:
It looks like the Trial has now expired.
We can use it on the web because it looks like it automatically switches to the other company’s workspace.
I think this is a bug on the Desktop app because it should allow switching the workspace on the “Launch trial” screen.
Do you know if there’s a way to force it to use the other company’s workspace?
How can I report this bug?
Thanks in advance.
Hi everybody, My team and I are having issues using the de MS Teams Desktop App with a guest account. Context:We work for a company that doesn’t have an MS Teams license but we are “Staff Augmentation” for another company that uses MS Teams as the primary communication tool. The other company added us as “Guest” in their workspace. The problem we are having is that on the desktop app when we log in with our main company credentials we get this message because our company doesn’t have a license:However, we don’t want to enter our company’s Workspace, we want to enter the other company’s workspace (that does have a license). In the past, we were able to switch by clicking on the “Launch trial” button, and on the next screen, we had the option to switch. But now, when we click that button we get another error: It looks like the Trial has now expired.We can use it on the web because it looks like it automatically switches to the other company’s workspace. I think this is a bug on the Desktop app because it should allow switching the workspace on the “Launch trial” screen.Do you know if there’s a way to force it to use the other company’s workspace?How can I report this bug? Thanks in advance. Read More
New Copilot agents: Supercharge Microsoft 365 Copilot
Are you ready to supercharge Microsoft 365 Copilot? Following the recent Wave 2 announcements and the general availability of Copilot agents, we are excited to introduce a curated set of new Copilot agents developed by Microsoft. These agents are designed to help you and your team optimize and reinvent your business processes.
Copilot agents can help you transform complex and dynamic processes. By integrating Copilot agents into your workflow, you can harness their power, right within the flow of your work. Powered by Microsoft 365 Copilot, these agents utilize the same scalable, secure infrastructure and platform, tailored to your business needs, providing an intuitive and advanced experience without the need for coding.
We are releasing the following Copilot agents to enhance your Microsoft 365 Copilot experience and help showcase what’s possible with simple agents created using Copilot Studio agent builder, like the coaching agents and advanced agents created with pro-code like Visual Creator.
Help your ideas come to life with Visual Creator
Visual Creator: Allows users to generate images, and soon videos, using natural language prompts. Its simple interface provides guidance of what you can create and how to write your prompt so you can enhance your work with compelling visuals.
Elevate your career with Career Coach
Career Coach: Provides personalized career development suggestions, including role understanding, skill gap analysis, learning opportunities, and career transition plans. It aims to understand the user’s current role, identify career goals, assess skills and gaps, suggest learning opportunities and create a detailed action plan for future growth.
Plan and execute brainstorming with Idea Coach
Idea Coach: Facilitates brainstorming sessions and planning, offering creative exercises, idea organization techniques, and feedback for improvement. It uses a fun, collaborative tone, asks iterative questions and provides detailed agendas and creative suggestions for running effective brainstorming sessions.
Unlock your potential with Learning Coach
Learning Coach: Helps users understand complex topics by breaking them down into simple, intermediate, and advanced summaries, and also provides guided practice and learning plans. It employs various techniques for learning complex topics, including glossaries, analogies, practice exercises and structured study plans.
Write better prompts with Prompt Coach
Prompt Coach: Assists users in creating effective and well-structured prompts for Copilot. Offering analysis, compliance checks and improvement suggestions. It asks for information on the goal, context, source, and expectations to generate effective prompts and provides detailed analyses for to help elevate your prompt writing prowess.
Take your writing to the next level with Writing Coach
Writing Coach: Provides detailed feedback on writing, helps change the tone of messages, translates text, and assists in writing instructions, stories, blog posts, and whitepapers. It focuses on clarity, coherence, grammar, and overall impact, offering specific improvements and alternatives for various types of document authoring.
Availability and deployment
These Copilot agents, created by Microsoft, extend the native capabilities of Microsoft 365 Copilot with instructions and knowledge sources relevant to each use case. They will be available to Microsoft 365 Copilot licensed users from early October 2024. Make sure to check the Teams App Store or use the Microsoft 365 Admin Center to deploy them within your organization.
Empower your developers and makers
We are making the instructions for the Career Coach, Idea Coach, Learning Coach, Prompt Coach and Writing Coach Copilot agents, open source, so your makers and developers can use them as a starting point for their own journey in creating agents to improve your business workflows, via Copilot Studio or Teams Toolkit.
Get started today
Don’t miss out on these powerful tools to enhance your Microsoft 365 Copilot experience. Start by ensuring your users can access these new tools, create excitement internally via your modern workplace champions and encourage your developers to review the source material on the PNP community today.
Microsoft Tech Community – Latest Blogs –Read More
