Category: Microsoft
Category Archives: Microsoft
power settings ignored
Windows 11 home on msi laptop. I do consulting and have several work accounts. Something is overriding the power /sleep settings. Since it was working last fall. but has been an issue since about oct nov last year when I gained several clients policies. My pc goes to sleep mode at about 3 minutes. I loose any connections to vpns. IF I am on remote desktop on a meeting, it will go to sleep. I have to e active on my pc desktop keyboard or mouse. I have been launching teams meeting on my desktop to keep it from sleeping.
How do I find what is overriding my settings?
Windows 11 home on msi laptop. I do consulting and have several work accounts. Something is overriding the power /sleep settings. Since it was working last fall. but has been an issue since about oct nov last year when I gained several clients policies. My pc goes to sleep mode at about 3 minutes. I loose any connections to vpns. IF I am on remote desktop on a meeting, it will go to sleep. I have to e active on my pc desktop keyboard or mouse. I have been launching teams meeting on my desktop to keep it from sleeping.How do I find what is overriding my settings? Read More
sort(), filter() and IF() combined
I have a formula:
=SORT(IF(AX2 = “1+1”; FILTER(A2:J200; E2:E200 >= MAX(P:P)); 1; 1); FILTER(A2:J200; E2:E200 >= INDEX(P2:P200; X4-1)); 1; 1)
I want to sort a column by a condition statement.
For example, if the statement is true I want to filter and sort the numeric column with values only bigger and equal to the max() function result,
otherwise, I want to filter and sort the numeric column with values bigger or equal to max() – 1 (the preceding value).
Are there any workarounds for this, because the Excel pop-up with the window “can’t calculate this formula” without helper columns if possible?
I have a formula:=SORT(IF(AX2 = “1+1”; FILTER(A2:J200; E2:E200 >= MAX(P:P)); 1; 1); FILTER(A2:J200; E2:E200 >= INDEX(P2:P200; X4-1)); 1; 1)I want to sort a column by a condition statement.For example, if the statement is true I want to filter and sort the numeric column with values only bigger and equal to the max() function result,otherwise, I want to filter and sort the numeric column with values bigger or equal to max() – 1 (the preceding value).Are there any workarounds for this, because the Excel pop-up with the window “can’t calculate this formula” without helper columns if possible? Read More
Update records in a Kusto Database (General Availability)
Kusto databases, either in Fabric (KQL Database) or in Azure (Azure Data Explorer), are optimized for append ingestion.
In recent years, we’ve introduced the .delete command, allowing you to selectively delete records.
In February, we introduced the .update command in public preview. This command allows you to update records by deleting existing records and appending new ones in a single transaction.
Today, the .update is Generally Available (GA)!
During the public preview, we introduced two syntaxes: the simplified and expanded syntax. We only GA the expanded syntax (the most powerful) and are deprecating the simplified syntax. This is due to the simplified syntax being confusing in some scenarios.
We encourage you to go through the many examples of the online documentation page to familiarize yourself with the syntax.
As usual, we are looking forward for your feedback and hope this makes you more productive in Kusto!
Microsoft Tech Community – Latest Blogs –Read More
Right Clicking Teams Taskbar Icon opens “Open With” Dialogue on Windows 10
We recently identified a Windows known issue with custom Jump Lists that shipped in Windows 10 22H2. New Teams is one of several apps known to be impacted. When you right click on the New Teams icon in the taskbar on Win10 you might see an “Open With” dialogue instead of the expected Teams custom options (Status, Quit, etc).
Looks like:
Instead of:
You can work around this issue by setting Status via your Profile in the main Teams client window:
The good news is that the necessary fix has already been identified and prepared and will ship in a future update for Windows 10 22H2 soon.
To follow along monitor the Windows 10 update history page here:
Windows 10 update history – Microsoft Support
For more information about the JumpList known issue:
Windows 10, version 22H2 | Microsoft Learn
We apologize for the inconvenience.
Microsoft Tech Community – Latest Blogs –Read More
Client Analyzer Page – Release notes
It would be helpful if the client analyzer page had release notes to go along with new version releases and update, and also a subscription notification for when the page has been updated.
(https://learn.microsoft.com/en-us/defender-endpoint/run-analyzer-macos-linux?view=o365-worldwide)
Currently the best guess is check last page edited date, but this has not been reliable in the past as the page has been edited without Client Analyzer updates or the ClientAnalyzer has been updated without page edits.
It would be helpful if the client analyzer page had release notes to go along with new version releases and update, and also a subscription notification for when the page has been updated. (https://learn.microsoft.com/en-us/defender-endpoint/run-analyzer-macos-linux?view=o365-worldwide) Currently the best guess is check last page edited date, but this has not been reliable in the past as the page has been edited without Client Analyzer updates or the ClientAnalyzer has been updated without page edits. Read More
How do I submit app with api on azure, I am new to azure and struggling to submit or host.
Hi there,
I am trying for the first time on Microsoft azure I am new developer and have very few knowledge about the azure I am trying to create a web app like. AI to human text converter https://aitohumanizetextconverter.com this website is a sample but my app is similar to this. How do I submit or host my app on azure. I really appreciate if i get any sort of guidance.
Thank you
Hi there,I am trying for the first time on Microsoft azure I am new developer and have very few knowledge about the azure I am trying to create a web app like. AI to human text converter https://aitohumanizetextconverter.com this website is a sample but my app is similar to this. How do I submit or host my app on azure. I really appreciate if i get any sort of guidance. Thank you Read More
Issues with Oracle Database Classification in Microsoft Purview
Hello,I’m testing the registration of an Oracle on-prem database with Microsoft Purview. The scan is running successfully and ingesting metadata, but it is not identifying any classifications.although this dataset is used with SQL Server and works properly, showing all the classifications, there is a section discussing this saying that If the user is not the owner of the table, the scan will run successfully and ingest metadata, but will not identify any classifications. https://learn.microsoft.com/en-us/purview/register-scan-oracle-source#required-permissions-for-scanBut it’s already done and the user have all the select roles and system roles.Could anyone help i don’t know where is the problem Thanks in advance Read More
Issues with Hybrid Azure AD Join During Autopilot Enrollment
Hello Community,
I am seeking advice on an issue we’re experiencing with Microsoft Intune and Autopilot in our environment. We have set up an enrollment profile intended to enroll devices as Hybrid Azure AD joined during the Autopilot process. However, we’re encountering a problem where some devices are enrolling as Azure AD joined (cloud-only) instead of Hybrid.
Has anyone else experienced this issue? Any suggestions on what might be causing this inconsistency or how to troubleshoot it further would be greatly appreciated!
Hello Community,I am seeking advice on an issue we’re experiencing with Microsoft Intune and Autopilot in our environment. We have set up an enrollment profile intended to enroll devices as Hybrid Azure AD joined during the Autopilot process. However, we’re encountering a problem where some devices are enrolling as Azure AD joined (cloud-only) instead of Hybrid.Has anyone else experienced this issue? Any suggestions on what might be causing this inconsistency or how to troubleshoot it further would be greatly appreciated! Read More
The ability to add photos / images to Microsoft Authenticator accounts
Hi,
First post in this forum (hello to all !).
Can we have the ability to add photos / images to each account listed on our Microsoft Authenticator accounts ? This would allow me to quickly identify which account code I need on the long list of accounts I have connected to my Authenticator app.
Many thanks
Jay
Hi, First post in this forum (hello to all !). Can we have the ability to add photos / images to each account listed on our Microsoft Authenticator accounts ? This would allow me to quickly identify which account code I need on the long list of accounts I have connected to my Authenticator app. Many thanksJay Read More
Days Earned Calculator
Good Day!
I have a set of guidelines for earning bonus days off. (eg. between 251-450hrs earns 2 holiday days) As you can see in the attached pic. I would like to build a calculator that will allow me to enter a number of hours and it tells me how many bonus days I qualify for. The guidelines and rough calculator are in the pic, can you please help?
(Please note: these are not actual numbers, only made up values. Please don’t call the labor board LOL)
Good Day! I have a set of guidelines for earning bonus days off. (eg. between 251-450hrs earns 2 holiday days) As you can see in the attached pic. I would like to build a calculator that will allow me to enter a number of hours and it tells me how many bonus days I qualify for. The guidelines and rough calculator are in the pic, can you please help? (Please note: these are not actual numbers, only made up values. Please don’t call the labor board LOL) Read More
Viva Training Inquiry
Hi,
Our company is looking to implement online training programs and I have a few questions. I have not been able to get in touch with a microsoft sales representative.
1. We would like to create quizzes and have them embedded to the training modules. Is this possible?
2. Is this private so it is only visible to people within the company?
3. Organizaiton is key factor for us. These training documents will be auditied How does it keep records?
4. Is there any type of integration possibilies with our in house crm(customer relationship management system)?
5. Company of around 50 people what is the cost? What is the main differences in price tiers
6. Any metrics available to show the impact of the viva system?
Hi, Our company is looking to implement online training programs and I have a few questions. I have not been able to get in touch with a microsoft sales representative. 1. We would like to create quizzes and have them embedded to the training modules. Is this possible?2. Is this private so it is only visible to people within the company?3. Organizaiton is key factor for us. These training documents will be auditied How does it keep records?4. Is there any type of integration possibilies with our in house crm(customer relationship management system)?5. Company of around 50 people what is the cost? What is the main differences in price tiers6. Any metrics available to show the impact of the viva system? Read More
Visual Basic/Macros
I have uninstalled office, reinstalled office. I have even updated the office apps and then I have ran quick repair. I have checked for any add ins that can cause this issue. For some reason my selection options for the VBA and the Macros are all greyed out on Word app. I cannot use the VBA as all the options to make changes and personalization are all greyed out.
I have uninstalled office, reinstalled office. I have even updated the office apps and then I have ran quick repair. I have checked for any add ins that can cause this issue. For some reason my selection options for the VBA and the Macros are all greyed out on Word app. I cannot use the VBA as all the options to make changes and personalization are all greyed out. Read More
Purview Governance – New Portal Not Ready for GA Use (noted in Preview)
It feels like the New Portal for Purview, Governance in particular is partially ready for release. I am getting many errors and inconsistencies. I havent received support yet. Anyone else experienceing these issues?
1. Unable to test my REGEX for pattern accuracy (though used same file to create pattern)
2. Unable to set a Data Quality Connection for SQL
3. Missing Data Products within Data Access
4. Inconsistent use of Tech metadata to Business Glossary terms
5. Missing Glossary terms in Data Search function
6. Missing Data Products in Data Products Search
7. Unable to bulk upload Business Glossary terms
I am surprised their are not more community postings for the issues.
It feels like the New Portal for Purview, Governance in particular is partially ready for release. I am getting many errors and inconsistencies. I havent received support yet. Anyone else experienceing these issues?1. Unable to test my REGEX for pattern accuracy (though used same file to create pattern)2. Unable to set a Data Quality Connection for SQL3. Missing Data Products within Data Access4. Inconsistent use of Tech metadata to Business Glossary terms5. Missing Glossary terms in Data Search function6. Missing Data Products in Data Products Search7. Unable to bulk upload Business Glossary termsI am surprised their are not more community postings for the issues. Read More
Internal Quick Link opening in a new tab
I have a quick links web part at the top of my SharePoint page that is used as quick navigation. There are currently 5 quick links that, when clicked, take the user to the appropriate section on the page. However, when I try to add a new one following the same steps (copy and paste the section link into the quick link web part), I’m not getting the same result; it will open in a new tab. All of the links are internal and from the SharePoint page. What am I missing?
I have a quick links web part at the top of my SharePoint page that is used as quick navigation. There are currently 5 quick links that, when clicked, take the user to the appropriate section on the page. However, when I try to add a new one following the same steps (copy and paste the section link into the quick link web part), I’m not getting the same result; it will open in a new tab. All of the links are internal and from the SharePoint page. What am I missing? Read More
Maximize Your Cloud Efficiency: Embrace VM Hibernation
In the ever-evolving landscape of cloud computing, cost management remains a top priority for businesses. One innovative feature that stands out for its ability to drive down costs without compromising performance is VM Hibernation. This powerful tool allows you to pause your Virtual Machines (VMs) when they’re not in active use, leading to significant savings on compute costs.
Ideal Use Cases for VM Hibernation.
VM Hibernation shines in several scenarios:
Virtual Desktops and Dev/Test Servers: These environments often don’t require round-the-clock operation, making hibernation an excellent choice for reducing expenses.Memory-Intensive Applications: Systems that take considerable time to boot up due to such applications can benefit immensely. By initializing these applications on VMs and then hibernating them, you can have “prewarmed” VMs ready to spring into action swiftly, with all applications already in the desired state.
Understanding the Hibernation Process
When you opt to hibernate a VM, Azure orchestrates a seamless suspend-to-disk action. It securely stores the VM’s memory contents on the OS disk and then deallocates the VM. Upon reactivation, these contents are promptly restored to memory, allowing your applications and processes to pick up exactly where they left off.
Cost Implications of Hibernating Your VM
A hibernated VM incurs no charges for VM usage. Instead, you’re only billed for the storage (OS and data disks) and networking resources (like IPs) that remain attached to the VM.
Key Points When Hibernating a VM:
Trigger hibernation through various means like the Azure portal, CLI, PowerShell, SDKs, or APIs.The memory contents are preserved on the OS disk while the VM is deallocated and powered off.Temporary disk data is not retained.The OS disk, data disks, and NICs stay attached, and any static IPs remain unchanged.Enjoy freedom from VM usage billing during hibernation.Storage and networking resource billing continues as usual.
Embracing VM Hibernation is a smart move for any cloud-centric organization looking to optimize operations and reduce costs. It’s not just about saving money; it’s about smart resource management that aligns with your business needs.
Hibernation support is limited to certain VM sizes and OS versions. Make sure you have a supported configuration before using hibernation.
The following Windows operating systems support hibernation:
Windows Server 2022Windows Server 2019Windows 11 ProWindows 11 EnterpriseWindows 11 Enterprise multi-sessionWindows 10 ProWindows 10 EnterpriseWindows 10 Enterprise multi-session
The following Linux operating systems support hibernation:
Ubuntu 22.04 LTSUbuntu 20.04 LTSUbuntu 18.04 LTSDebian 11Debian 10 (with backports kernel)RHEL 9.0 and higher (with minimum kernel version 5.14.0-70)RHEL 8.3 and higher (with minimum kernel version 4.18.0.240)
VM sizes with up to 64-GB RAM from the following General Purpose VM series support hibernation.
Dasv5-seriesDadsv5-seriesDsv5-seriesDdsv5-seriesEasv5-seriesEadsv5-seriesEsv5-seriesEdsv5-series
VM sizes with up to 112-GB RAM from the following GPU VM series support hibernation.
NVv4-series (in preview)NVadsA10v5-series (in preview)
To enable hibernation on an existing VM, you can use Azure CLI, PowerShell, or REST API.
Enabling hibernation on an existing Windows/ Linux VM using PowerShell
1. To use Azure PowerShell to enable hibernation on an already-running virtual machine, stop the machine first using Stop-Az vm deallocate. Update the VM and OS disk after the VM has been deallocated.
Stop-AzVM -ResourceGroupName ‘TestResourceGroup’ -Name ‘TestVMName’
2. Update the OS disk to change SupportsHibernation to true after the virtual machine has been halted. You can skip this step and go on to the next if SupportsHibernation is already set to true.
$disk = Get-AzDisk -ResourceGroupName “TestResourceGroup” -DiskName “myOSDisk”
$disk.SupportsHibernation = $True
Update-AzDisk -ResourceGroupName ‘myResourceGroup’ -DiskName ‘myOSDisk’ -Disk $disk
3. Enable hibernation on the VM.
$vm= Get-AzVM -ResourceGroupName “TestResourceGroup” -Name “TestVM”
Update-AzVM -ResourceGroupName “TestResourceGroup” -VM $vm -HibernationEnabled
4. After launching the virtual machine, configure the guest operating system for hibernation.
Start-AzVM -ResourceGroupName ‘TestResourceGroup’ -Name ‘TestVM’
General limitations
When hibernation is activated on a virtual machine, you can resize it; when hibernation is disabled, you cannot. It should be either Running or Stopped for the virtual machine.Nested Virtualization only supports hibernation if Trusted Launch is turned on in the virtual machine.You are unable to attach, detach, or alter any disks or NICs connected to a hibernated virtual machine. Rather, a Stop-Deallocated state must be applied to the VM.There is no capacity guarantee when a virtual machine (VM) is hibernated, hence there may not be enough capacity to restart the VM at a later time. You can attempt starting the virtual machine (VM) later if, in the extremely unlikely event that capacity problems arise. Hibernated VM capacity is not guaranteed by capacity reservations.Using the Azure portal, CLI, PowerShell, SDKs, and API is the sole way to hibernate a virtual machine. The virtual machine (VM) is still billed even when it is put into hibernation by guest OS activities.
If you want step-by-step guidance to enable hibernation for existing Windows VM, you can check the below YouTube video.
https://www.youtube.com/watch?v=cLs6DI8cz_w
In the ever-evolving landscape of cloud computing, cost management remains a top priority for businesses. One innovative feature that stands out for its ability to drive down costs without compromising performance is VM Hibernation. This powerful tool allows you to pause your Virtual Machines (VMs) when they’re not in active use, leading to significant savings on compute costs.Ideal Use Cases for VM Hibernation. VM Hibernation shines in several scenarios: Virtual Desktops and Dev/Test Servers: These environments often don’t require round-the-clock operation, making hibernation an excellent choice for reducing expenses.Memory-Intensive Applications: Systems that take considerable time to boot up due to such applications can benefit immensely. By initializing these applications on VMs and then hibernating them, you can have “prewarmed” VMs ready to spring into action swiftly, with all applications already in the desired state.Understanding the Hibernation Process When you opt to hibernate a VM, Azure orchestrates a seamless suspend-to-disk action. It securely stores the VM’s memory contents on the OS disk and then deallocates the VM. Upon reactivation, these contents are promptly restored to memory, allowing your applications and processes to pick up exactly where they left off. Cost Implications of Hibernating Your VM A hibernated VM incurs no charges for VM usage. Instead, you’re only billed for the storage (OS and data disks) and networking resources (like IPs) that remain attached to the VM. Key Points When Hibernating a VM: Trigger hibernation through various means like the Azure portal, CLI, PowerShell, SDKs, or APIs.The memory contents are preserved on the OS disk while the VM is deallocated and powered off.Temporary disk data is not retained.The OS disk, data disks, and NICs stay attached, and any static IPs remain unchanged.Enjoy freedom from VM usage billing during hibernation.Storage and networking resource billing continues as usual. Embracing VM Hibernation is a smart move for any cloud-centric organization looking to optimize operations and reduce costs. It’s not just about saving money; it’s about smart resource management that aligns with your business needs. Hibernation support is limited to certain VM sizes and OS versions. Make sure you have a supported configuration before using hibernation. The following Windows operating systems support hibernation: Windows Server 2022Windows Server 2019Windows 11 ProWindows 11 EnterpriseWindows 11 Enterprise multi-sessionWindows 10 ProWindows 10 EnterpriseWindows 10 Enterprise multi-sessionThe following Linux operating systems support hibernation: Ubuntu 22.04 LTSUbuntu 20.04 LTSUbuntu 18.04 LTSDebian 11Debian 10 (with backports kernel)RHEL 9.0 and higher (with minimum kernel version 5.14.0-70)RHEL 8.3 and higher (with minimum kernel version 4.18.0.240)VM sizes with up to 64-GB RAM from the following General Purpose VM series support hibernation. Dasv5-seriesDadsv5-seriesDsv5-seriesDdsv5-seriesEasv5-seriesEadsv5-seriesEsv5-seriesEdsv5-seriesVM sizes with up to 112-GB RAM from the following GPU VM series support hibernation. NVv4-series (in preview)NVadsA10v5-series (in preview) To enable hibernation on an existing VM, you can use Azure CLI, PowerShell, or REST API. Enabling hibernation on an existing Windows/ Linux VM using PowerShell1. To use Azure PowerShell to enable hibernation on an already-running virtual machine, stop the machine first using Stop-Az vm deallocate. Update the VM and OS disk after the VM has been deallocated. Stop-AzVM -ResourceGroupName ‘TestResourceGroup’ -Name ‘TestVMName’ 2. Update the OS disk to change SupportsHibernation to true after the virtual machine has been halted. You can skip this step and go on to the next if SupportsHibernation is already set to true. $disk = Get-AzDisk -ResourceGroupName “TestResourceGroup” -DiskName “myOSDisk”
$disk.SupportsHibernation = $True
Update-AzDisk -ResourceGroupName ‘myResourceGroup’ -DiskName ‘myOSDisk’ -Disk $disk 3. Enable hibernation on the VM. $vm= Get-AzVM -ResourceGroupName “TestResourceGroup” -Name “TestVM”
Update-AzVM -ResourceGroupName “TestResourceGroup” -VM $vm -HibernationEnabled 4. After launching the virtual machine, configure the guest operating system for hibernation. Start-AzVM -ResourceGroupName ‘TestResourceGroup’ -Name ‘TestVM’ General limitationsWhen hibernation is activated on a virtual machine, you can resize it; when hibernation is disabled, you cannot. It should be either Running or Stopped for the virtual machine.Nested Virtualization only supports hibernation if Trusted Launch is turned on in the virtual machine.You are unable to attach, detach, or alter any disks or NICs connected to a hibernated virtual machine. Rather, a Stop-Deallocated state must be applied to the VM.There is no capacity guarantee when a virtual machine (VM) is hibernated, hence there may not be enough capacity to restart the VM at a later time. You can attempt starting the virtual machine (VM) later if, in the extremely unlikely event that capacity problems arise. Hibernated VM capacity is not guaranteed by capacity reservations.Using the Azure portal, CLI, PowerShell, SDKs, and API is the sole way to hibernate a virtual machine. The virtual machine (VM) is still billed even when it is put into hibernation by guest OS activities. If you want step-by-step guidance to enable hibernation for existing Windows VM, you can check the below YouTube video. https://www.youtube.com/watch?v=cLs6DI8cz_w Read More
any recent change on MDC classic view?
Is there any recent change on MDC classic view? about 2 weeks ago, we saw some high severity recommendations, such as “All network ports should be restricted on network security groups associated to your virtual machine” for a VM because the source for an inbound port rule of the NSG is any, today, we no longer see the high severity recommendation for the VM, even the rule remains the same.
Is there any recent change on MDC classic view? about 2 weeks ago, we saw some high severity recommendations, such as “All network ports should be restricted on network security groups associated to your virtual machine” for a VM because the source for an inbound port rule of the NSG is any, today, we no longer see the high severity recommendation for the VM, even the rule remains the same. Read More
Unable to create a new object on my list
Hello,
I created a new object on my list (grid view), but he doesn’t appear on my main page (yellow circle). I don’t understand whats the problem.
Grid view
Main view
Thank you
Hello, I created a new object on my list (grid view), but he doesn’t appear on my main page (yellow circle). I don’t understand whats the problem. Grid view Main view Thank you Read More
I cant see my own lists
So, I created one list on my sharepoint page but after that I can’t find it on “my lists”.
I can find it using the search bar and I can put information in it.
Also I can’t add the list on my favorite.
So, I created one list on my sharepoint page but after that I can’t find it on “my lists”.I can find it using the search bar and I can put information in it.Also I can’t add the list on my favorite. Read More
.BAK file restore in SSMS
hi, All. I am trying to restore database using .Bak file in (using ssms). But When I am restoring it shows me error of memory. I have attach the pic below. Even my C drive have 132 gb free space. What should I do in this ? Please help
hi, All. I am trying to restore database using .Bak file in (using ssms). But When I am restoring it shows me error of memory. I have attach the pic below. Even my C drive have 132 gb free space. What should I do in this ? Please help Read More
Azure enterprise application access to all user
Hi
I was hoping someone can shed some light on this. I added an SSO Enterprise application. We are not auto=provisioning and don’t want to restrict the Azure connectivity to a small group. How can I manage this?
Hi I was hoping someone can shed some light on this. I added an SSO Enterprise application. We are not auto=provisioning and don’t want to restrict the Azure connectivity to a small group. How can I manage this? Read More