Category: Microsoft
Category Archives: Microsoft
Need Help Urgently | Microsoft Form Data is Missing
Hi,
I would like to ask for your kind support to help with my issue urgently.
I have used MS Form to collect information but for some reason, today I tried to export data into excel but many data are missing.
I have checked back to the original MS Form, the data is also missing.
I don’t know what to do to recover the data.
Could you please advice?
Regards,
Trinnakorn C.
Hi, I would like to ask for your kind support to help with my issue urgently. I have used MS Form to collect information but for some reason, today I tried to export data into excel but many data are missing. I have checked back to the original MS Form, the data is also missing. I don’t know what to do to recover the data.Could you please advice? Regards,Trinnakorn C. Read More
New columns on existing table are dropped the next day
Has anyone encountered an issue like this? I cannot find anything searching. Troubleshooting is not fruitful yet
New columns created on existing tables will disappear the next day (ie. ALTER TABLE <name> ADD <column and metadata>)
New tables created within a given DB will persist the next day/ongoing, however
Target DB is set to SIMPLE recovery. DB is in autocommit mode
Running SQL Server on Azure VM
Thankyou
Has anyone encountered an issue like this? I cannot find anything searching. Troubleshooting is not fruitful yetNew columns created on existing tables will disappear the next day (ie. ALTER TABLE <name> ADD <column and metadata>)New tables created within a given DB will persist the next day/ongoing, howeverTarget DB is set to SIMPLE recovery. DB is in autocommit modeRunning SQL Server on Azure VMThankyou Read More
SUM(IF that changes when value in column A changes
I am trying to sum values in $AY and divide the total by $AT. Every time the value in column A changes, the group of rows being summed changes as well. I am manually updating the formula every 30 rows or so for a worksheet with over 11,000 rows. The examples below cover the first 93 rows, with two changes to the values in $A.
The following formula is in $BG. The values in column A are the same for rows 1 through 32 and I sum the values in $AY$3 through $AY32.
row 1 =SUM(IF($A:$A=$E3,IF($E:$E=$A3,IF($C:$C=$C3,SUM($AY$3:$AY3/$AT3,)))))
row 2 =SUM(IF($A:$A=$E4,IF($E:$E=$A4,IF($C:$C=$C4,SUM($AY$3:$AY4/$AT4,)))))
row 3 =SUM(IF($A:$A=$E5,IF($E:$E=$A5,IF($C:$C=$C5,SUM($AY$3:$AY5/$AT5,)))))
…
row 32 =SUM(IF($A:$A=$E32,IF($E:$E=$A32,IF($C:$C=$C32,SUM($AY$3:$AY32/$AT32,)))))
The value in column A changes from rows 33 through 64, so I modify the formula manually to sum the values in those rows:
row 33 =SUM(IF($A:$A=$E33,IF($E:$E=$A33,IF($C:$C=$C33,SUM($AY$33:$AY33/$AT33,)))))
row 34 =SUM(IF($A:$A=$E34,IF($E:$E=$A34,IF($C:$C=$C34,SUM($AY$33:$AY34/$AT34,)))))
row 35 =SUM(IF($A:$A=$E35,IF($E:$E=$A35,IF($C:$C=$C35,SUM($AY$33:$AY35/$AT35,)))))
…
row 64 =SUM(IF($A:$A=$E64,IF($E:$E=$A64,IF($C:$C=$C64,SUM($AY$33:$AY64/$AT64,)))))
The value in column A changes again from rows 65 through 93, so I sum those rows by manually changing the formula:
row 65 =SUM(IF($A:$A=$E65,IF($E:$E=$A65,IF($C:$C=$C65,SUM($AY$65:$AY65/$AT65,)))))
row 66 =SUM(IF($A:$A=$E66,IF($E:$E=$A66,IF($C:$C=$C66,SUM($AY$65:$AY66/$AT66,)))))
row 67 =SUM(IF($A:$A=$E67,IF($E:$E=$A67,IF($C:$C=$C67,SUM($AY$65:$AY67/$AT67,)))))
…
row 93 =SUM(IF($A:$A=$E93,IF($E:$E=$A93,IF($C:$C=$C93,SUM($AY$65:$AY93/$AT93,)))))
I’d like to modify the following formula so it doesn’t require manually changing the first reference of $AY every the the value in $A changes. Worksheet attached. Thanks for your assistance.
I am trying to sum values in $AY and divide the total by $AT. Every time the value in column A changes, the group of rows being summed changes as well. I am manually updating the formula every 30 rows or so for a worksheet with over 11,000 rows. The examples below cover the first 93 rows, with two changes to the values in $A. The following formula is in $BG. The values in column A are the same for rows 1 through 32 and I sum the values in $AY$3 through $AY32.row 1 =SUM(IF($A:$A=$E3,IF($E:$E=$A3,IF($C:$C=$C3,SUM($AY$3:$AY3/$AT3,)))))row 2 =SUM(IF($A:$A=$E4,IF($E:$E=$A4,IF($C:$C=$C4,SUM($AY$3:$AY4/$AT4,)))))row 3 =SUM(IF($A:$A=$E5,IF($E:$E=$A5,IF($C:$C=$C5,SUM($AY$3:$AY5/$AT5,)))))…row 32 =SUM(IF($A:$A=$E32,IF($E:$E=$A32,IF($C:$C=$C32,SUM($AY$3:$AY32/$AT32,))))) The value in column A changes from rows 33 through 64, so I modify the formula manually to sum the values in those rows:row 33 =SUM(IF($A:$A=$E33,IF($E:$E=$A33,IF($C:$C=$C33,SUM($AY$33:$AY33/$AT33,)))))row 34 =SUM(IF($A:$A=$E34,IF($E:$E=$A34,IF($C:$C=$C34,SUM($AY$33:$AY34/$AT34,)))))row 35 =SUM(IF($A:$A=$E35,IF($E:$E=$A35,IF($C:$C=$C35,SUM($AY$33:$AY35/$AT35,)))))…row 64 =SUM(IF($A:$A=$E64,IF($E:$E=$A64,IF($C:$C=$C64,SUM($AY$33:$AY64/$AT64,))))) The value in column A changes again from rows 65 through 93, so I sum those rows by manually changing the formula:row 65 =SUM(IF($A:$A=$E65,IF($E:$E=$A65,IF($C:$C=$C65,SUM($AY$65:$AY65/$AT65,)))))row 66 =SUM(IF($A:$A=$E66,IF($E:$E=$A66,IF($C:$C=$C66,SUM($AY$65:$AY66/$AT66,)))))row 67 =SUM(IF($A:$A=$E67,IF($E:$E=$A67,IF($C:$C=$C67,SUM($AY$65:$AY67/$AT67,)))))…row 93 =SUM(IF($A:$A=$E93,IF($E:$E=$A93,IF($C:$C=$C93,SUM($AY$65:$AY93/$AT93,))))) I’d like to modify the following formula so it doesn’t require manually changing the first reference of $AY every the the value in $A changes. Worksheet attached. Thanks for your assistance. Read More
microsoft store blocked
i use intune to block microsoft store. however if i go to this website, i can bypass the block by download and then double click the file to install the microsoft store app.
anyone has the same behavior?
Power BI Desktop – Microsoft Apps
i use intune to block microsoft store. however if i go to this website, i can bypass the block by download and then double click the file to install the microsoft store app. anyone has the same behavior? Power BI Desktop – Microsoft Apps Read More
Managed installer errors for specific devices
Hello
Please i need your help on this issue.
We are trying to roll out Windows Defender Application Control (WDAC) to the devices however, when we enabled the managed installer it is failing on some of the devices.
When I export the devices status the file cuts off the line about the errors on the specific machine. It does look like an error in the C:windowsIMECacheHealthScriptsd78c1822-e082-491a-b3a7-4a701836481e_8remediate.ps1 file is causing the issue but we have no idea how to correct it.
Please advise
Hello Please i need your help on this issue. We are trying to roll out Windows Defender Application Control (WDAC) to the devices however, when we enabled the managed installer it is failing on some of the devices. When I export the devices status the file cuts off the line about the errors on the specific machine. It does look like an error in the C:windowsIMECacheHealthScriptsd78c1822-e082-491a-b3a7-4a701836481e_8remediate.ps1 file is causing the issue but we have no idea how to correct it. Please advise Read More
Excel 365 Sluggish Performance Issue: Seeking Solutions
Dear All,
On a daily basis, I use Microsoft Excel 365 at the office to process large-sized data as well as link it with multiple files, and so far, there haven’t been any issues. However, last Monday (June 3, 2024), I experienced extreme slowness when opening large-sized data. Why did this happen? It used to work just fine.
Previously, I was using Windows 10, and even after updating to Windows 11, the issue persists.
Has anyone encountered a similar issue?
Dear All,On a daily basis, I use Microsoft Excel 365 at the office to process large-sized data as well as link it with multiple files, and so far, there haven’t been any issues. However, last Monday (June 3, 2024), I experienced extreme slowness when opening large-sized data. Why did this happen? It used to work just fine.Previously, I was using Windows 10, and even after updating to Windows 11, the issue persists.Has anyone encountered a similar issue? Read More
Hybrid Modern Agent
A customer of mine is having issues installing the Hybrid Agent in their environment. Their network is such that they are unable to provide open access to the internet from the server we wish to install the hybrid agent on. Microsoft support are not very helpful with the full list of IPs that need to be opened to do the install (firewall in this environment can only have IP ranges opened, not URLs). They have a proxy, but all the information points to the fact that the initial install of the agent needs open access to the internet before the proxy can be configured.
The customer has proposed putting the hybrid agent server in the DMZ. This blog mentions putting the server in the DMZ, but I would like to see details on how this is done. The issue I see is that the HCW itself needs to be run on a domain joined machine, which is not ideal for a DMZ server.
If anyone can provide some insights on how to install the hybrid agent on a DMZ server, that would be great.
A customer of mine is having issues installing the Hybrid Agent in their environment. Their network is such that they are unable to provide open access to the internet from the server we wish to install the hybrid agent on. Microsoft support are not very helpful with the full list of IPs that need to be opened to do the install (firewall in this environment can only have IP ranges opened, not URLs). They have a proxy, but all the information points to the fact that the initial install of the agent needs open access to the internet before the proxy can be configured.The customer has proposed putting the hybrid agent server in the DMZ. This blog mentions putting the server in the DMZ, but I would like to see details on how this is done. The issue I see is that the HCW itself needs to be run on a domain joined machine, which is not ideal for a DMZ server.If anyone can provide some insights on how to install the hybrid agent on a DMZ server, that would be great. Read More
Excel colour formatting based off value
Hey, I have a 10 point scale (1,2,3,4,5,6,7,8,9,10) and each number has a set colour attacthed to it. I then have names on the left and for example, uniform and behaviour on the top row, so each week i update each persons scale based on the 10 point system. However I need the total value of each topic per person. Like (green, green, yellow, red, orange) should equal 10+10+5+1+3=28/50. I am wanting to make it so that i can just change the number within the cell and have the colour change accordingly to the value (and also hide the text (number)) in the mean time.
Hey, I have a 10 point scale (1,2,3,4,5,6,7,8,9,10) and each number has a set colour attacthed to it. I then have names on the left and for example, uniform and behaviour on the top row, so each week i update each persons scale based on the 10 point system. However I need the total value of each topic per person. Like (green, green, yellow, red, orange) should equal 10+10+5+1+3=28/50. I am wanting to make it so that i can just change the number within the cell and have the colour change accordingly to the value (and also hide the text (number)) in the mean time. Read More
Cannot leave insider program, never signed up
Hello, I am having an issue where I want to leave the insider program as I never signed up for it, but when I click leave program, the window continues loading and does not provide any way for me to leave.
I am currently unable to update my PC and Microsoft support has let me know that they cannot help me because I am in the insider program. I never signed up for this and I want out so that I can fix my PC.
Hello, I am having an issue where I want to leave the insider program as I never signed up for it, but when I click leave program, the window continues loading and does not provide any way for me to leave. I am currently unable to update my PC and Microsoft support has let me know that they cannot help me because I am in the insider program. I never signed up for this and I want out so that I can fix my PC. Read More
Any way to force a higher desktop resolution then active signal?
You can see from the screenshot that the display duplicated. Anyone knows how to achieve this in extend mode?
You can see from the screenshot that the display duplicated. Anyone knows how to achieve this in extend mode? Read More
Sending HoloLens 2 video stream through Roboflow API
Hello everyone,
I’m currently working on a mixed reality project for the HoloLens 2, which involves the use of a computer vision model for the recognition of some shop-floor equipment and parts. My team has trained this model in Roboflow, using the data we’ve collected in a factory.
However, we’re not sure how to integrate this model to the HoloLens. We thought it could be a good idea to access the HoloLens’ video stream in order to send it to the CV model through the Roboflow API, and get the result back, in runtime. So we’re looking at Microsoft’s CV samples for the HoloLens 2, which includes a “StreamRecorder” sample. However, this sample saves the stream in a raw format, which would need to be converted before sending it to the CV model.
We’re actually not even sure if using this sample as a basis is the best way to do what we want, so we’re a bit lost at the moment. Has anyone here tried accessing the Roboflow API from a HoloLens 2? How would be the best way to go about it?
Thanks in advance.
Hello everyone, I’m currently working on a mixed reality project for the HoloLens 2, which involves the use of a computer vision model for the recognition of some shop-floor equipment and parts. My team has trained this model in Roboflow, using the data we’ve collected in a factory. However, we’re not sure how to integrate this model to the HoloLens. We thought it could be a good idea to access the HoloLens’ video stream in order to send it to the CV model through the Roboflow API, and get the result back, in runtime. So we’re looking at Microsoft’s CV samples for the HoloLens 2, which includes a “StreamRecorder” sample. However, this sample saves the stream in a raw format, which would need to be converted before sending it to the CV model. We’re actually not even sure if using this sample as a basis is the best way to do what we want, so we’re a bit lost at the moment. Has anyone here tried accessing the Roboflow API from a HoloLens 2? How would be the best way to go about it? Thanks in advance. Read More
Show a Plan as a Tab inside Teams Channel is no more working using Graph API, any advice?
I have this work flow which create a new Team Channel + create a new Planner Plan + show the Planner Plan as a tab inside the Team Channel. this was working well for around 6 months, but recently it stop working as expected.
Here is my workflow which uses Graph API:-
here is the “Body of the request” for showing the plan as a tab inside channel action:-
{
“displayName”: “@{outputs(‘Compose_-_Friendly_Planner_Name’)}”,
“email address removed for privacy reasons”: “https://graph.microsoft.com/v1.0/appCatalogs/teamsApps/com.microsoft.teamspace.tab.planner”,
“configuration”: {
“entityId”: “@{body(‘Invoke_an_HTTP_request_-_Create_new_Channel’)?[‘id’]}”,
“contentUrl”: “https://tasks.teams.microsoft.com/teamsui/{tid}/Home/PlannerFrame?page=7&auth_pvr=OrgId&auth_upn={userPrincipalName}&groupId={groupId}&planId=@{variables(‘PlannerID’)}&channelId={channelId}&entityId={entityId}&tid={tid}&userObjectId={userObjectId}&subEntityId={subEntityId}&sessionId={sessionId}&theme={theme}&mkt={locale}&ringId={ringId}&PlannerRouteHint={tid}”,
“removeUrl”: “https://tasks.teams.microsoft.com/teamsui/{tid}/Home/PlannerFrame?page=13&auth_pvr=OrgId&auth_upn={userPrincipalName}&groupId={groupId}&planId=@{variables(‘PlannerID’)}&channelId={channelId}&entityId={entityId}&tid={tid}&userObjectId={userObjectId}&subEntityId={subEntityId}&sessionId={sessionId}&theme={theme}&mkt={locale}&ringId={ringId}&PlannerRouteHint={tid}”,
“websiteUrl”: “https://tasks.office.com/{tid}/Home/PlanViews/@{variables(‘PlannerID’)}?Type=PlanLink&Channel=TeamsTab”
}
}
Currently when i click on the new tab i will not get the new planner tasks, i will rather get “My Tasks”,as follow:-
previously i use to get the related Planner tasks as follow:-
any advice, why this is no loner working as it use to be?
Thanks
I have this work flow which create a new Team Channel + create a new Planner Plan + show the Planner Plan as a tab inside the Team Channel. this was working well for around 6 months, but recently it stop working as expected. Here is my workflow which uses Graph API:- here is the “Body of the request” for showing the plan as a tab inside channel action:-{
“displayName”: “@{outputs(‘Compose_-_Friendly_Planner_Name’)}”,
“email address removed for privacy reasons”: “https://graph.microsoft.com/v1.0/appCatalogs/teamsApps/com.microsoft.teamspace.tab.planner”,
“configuration”: {
“entityId”: “@{body(‘Invoke_an_HTTP_request_-_Create_new_Channel’)?[‘id’]}”,
“contentUrl”: “https://tasks.teams.microsoft.com/teamsui/{tid}/Home/PlannerFrame?page=7&auth_pvr=OrgId&auth_upn={userPrincipalName}&groupId={groupId}&planId=@{variables(‘PlannerID’)}&channelId={channelId}&entityId={entityId}&tid={tid}&userObjectId={userObjectId}&subEntityId={subEntityId}&sessionId={sessionId}&theme={theme}&mkt={locale}&ringId={ringId}&PlannerRouteHint={tid}”,
“removeUrl”: “https://tasks.teams.microsoft.com/teamsui/{tid}/Home/PlannerFrame?page=13&auth_pvr=OrgId&auth_upn={userPrincipalName}&groupId={groupId}&planId=@{variables(‘PlannerID’)}&channelId={channelId}&entityId={entityId}&tid={tid}&userObjectId={userObjectId}&subEntityId={subEntityId}&sessionId={sessionId}&theme={theme}&mkt={locale}&ringId={ringId}&PlannerRouteHint={tid}”,
“websiteUrl”: “https://tasks.office.com/{tid}/Home/PlanViews/@{variables(‘PlannerID’)}?Type=PlanLink&Channel=TeamsTab”
}
} Currently when i click on the new tab i will not get the new planner tasks, i will rather get “My Tasks”,as follow:- previously i use to get the related Planner tasks as follow:- any advice, why this is no loner working as it use to be? Thanks Read More
How we can filter all the tasks from all the Plans based on the assgined user
We have a Teams which contain around 40++ planner plans. The managers are facing troubles when they want to see all the tasks from all the planner plans assigned to certain user. Currently to do this, they need to go to each individual plan and do the filter, is there any built-in or using sharepoint web parts to be able to filter all the tasks from different plans based on the assigned to user?
Thanks
We have a Teams which contain around 40++ planner plans. The managers are facing troubles when they want to see all the tasks from all the planner plans assigned to certain user. Currently to do this, they need to go to each individual plan and do the filter, is there any built-in or using sharepoint web parts to be able to filter all the tasks from different plans based on the assigned to user? Thanks Read More
Web part to filter planner plans based on the Assigned To user?
We have a Teams which contain around 40++ planner plans. The managers are facing troubles when they want to see all the tasks from all the planner plans assigned to certain user. Currently to do this, they need to go to each individual plan and do the filter, is there any built-in or using sharepoint web parts to be able to filter all the tasks from different plans based on the assigned to user?
can we for example benefit from modern search web part to achieve this? or any other web parts?
We have a Teams which contain around 40++ planner plans. The managers are facing troubles when they want to see all the tasks from all the planner plans assigned to certain user. Currently to do this, they need to go to each individual plan and do the filter, is there any built-in or using sharepoint web parts to be able to filter all the tasks from different plans based on the assigned to user? can we for example benefit from modern search web part to achieve this? or any other web parts? Read More
Forgotten Password to unlock Excel Spreadsheet
Help Please!
We must have typed in the wrong password (twice??) to lock an Excel spreadsheet.
How do I get back in???
It must have been mis-typed twice, but we can’t recover it now, and have tried all variations of the regular password. 🙁
THANK YOU!
Help Please!We must have typed in the wrong password (twice??) to lock an Excel spreadsheet.How do I get back in???It must have been mis-typed twice, but we can’t recover it now, and have tried all variations of the regular password. 🙁 THANK YOU! Read More
Updates from the 162.3 release of SqlPackage and the DacFx ecosystem
The quarterly release cadence for SqlPackage and DacFx continues with the 162.3.563 release on June 6, 2024. The most notable change in this version is the preview release of a target platform for Fabric mirrored SQL databases. The 162.3.563 release also includes fixes related to script parsing (ScriptDOM) and deployments. Read more about the fixes in the SqlPackage release notes.
Target platforms in SQL projects
SQL projects are a logical framework around your database code and this sets the foundation for two development capabilities:
Build-time validation of references between objects and the syntax against a specific version of SQL
Deployment of the build artifact to new or existing databases
When a SQL project is built, the relationships between objects contained in the project files are validated. For example, the columns or tables referenced in a view definition must exist in the SQL project.
SQL project files in VS Code
Additionally, a SQL project contains a property called the “target platform” in the DSP element of the .sqlproj file. This setting is used during the build process to validate that the functions and T-SQL syntax is supported in the specified version of SQL. For example, the JSON functions added in SQL Server 2022 cannot be used in a SQL project set to the SQL Server 2017 (Sql140DatabaseSchemaProvider) target platform.
Mirroring your SQL database to Microsoft Fabric provides a streamlined experience to avoid complex ETL (Extract Transform Load) and integrate existing your Azure SQL Database estate with the rest of your data in Microsoft Fabric. In the new target platform for “Fabric mirrored SQL database (preview)” (SqlDbFabricDatabaseSchemaProvider) added in DacFx 162.3.563, the tables in the SQL project are validated for compatibility with mirroring to Microsoft Fabric. Having a target platform for a mirrored SQL database means that you can develop your Azure SQL application with confidence that the application’s data will be available for analytics with minimal additional effort.
Diagram of Fabric Database Mirroring for Azure SQL Database
The target platform is available immediately for use with SDK-style projects with the Microsoft.Build.Sql project SDK version 0.1.19-preview. Your existing SDK-style SQL projects can be moved from the Azure SQL Database target platform to the Fabric mirrored SQL database (preview) target platform by updating the version of the Sdk to 0.1.19-preview (line 3 below) and the DSP (target platform) to SqlDbFabricDatabaseSchemaProvider (line 7 below). For a walkthrough of mirroring your Azure SQL Database to Microsoft Fabric, check out the tutorial.
The “Fabric mirrored SQL database (preview)” target platform will be available directly in the SQL projects extension for VS Code and Azure Data Studio as well as Visual Studio in the upcoming months. In the meantime, SQL projects can be built and deployed with the new target platform from the command line with dotnet build and SqlPackage.
SqlPackage and SQL projects on arm64
GitHub recently announced arm64 actions runners with the initial availability in public preview of images built on Ubuntu 22.04. Whether you’re using the recently launched arm64 runners, an Apple M-series workstation, or one of the arm-powered Surface devices the base requirements for working with SqlPackage and SDK-style SQL projects remain the same – the .NET SDK must be installed. The current Ubuntu 22.04 arm64 preview image includes the .NET SDK.
With the .NET SDK installed in an arm64 environment such as the GitHub actions arm64 runners, your SQL development workflow can leverage the same commands as x64 environments. Dotnet build is still used to create a dacpac from a SQL project, but you may need to install SqlPackage as a dotnet tool to perform additional actions:
dotnet install -g microsoft.sqlpackage
Once SqlPackage is installed it can be used as usual, including deploying (publish) a dacpac to update the schema a database or to extract the objects in a database out to files.
# publish
sqlpackage /Action:Publish /SourceFile:bin/Debug/AdventureWorks.dacpac /TargetConnectionString:<YourConnectionString>
# extract
sqlpackage /Action:Extract /SourceConnectionString:<YourConnectionString> /TargetFile:AdventureWorks /p:ExtractTarget=SchemaObjectType
For developers interested in continuing to use the original SQL projects in Visual Studio, we also note that SQL Server Data Tools (SSDT) has been released for Visual Studio on arm64.
.gitignore with SQL projects
You may recall about a year ago we introduced project templates for quickly starting a new SQL project from the command line. Earlier this year an option was added to the templates (-g) which includes a default gitignore file with a new SQL project. With a .gitignore file you can avoid accidentally checking cached binaries in the bin and obj folders into source control and minimize noise in your source control history.
Installing the SQL project templates and creating a new SQL project with the Fabric mirrored SQL database (preview) target platform and a gitignore file is completed with these two commands:
dotnet new install Microsoft.Build.Sql.Templates
dotnet new sqlproj -n “AdventureWorksLT” -tp “SqlDbFabric” -g
Ways to get involved
In early 2024, we added preview releases of SqlPackage to the dotnet tool feed, such that not only do you have early access to DacFx changes but you can directly test SqlPackage as well. Eagle-eyed readers will notice that the last preview release prior to the full release only differs by a single patch build. Get the quick instructions on installing and updating the preview releases in the SqlPackage documentation.
All are welcome to stop by the GitHub repository to provide feedback, whether it is bug reports, questions, or enhancement suggestions. Here are a few recent feature suggestions you might want to weigh in on:
Support for dotnet publish https://github.com/microsoft/DacFx/issues/447
Composite projects in schema comparison https://github.com/microsoft/DacFx/issues/437
Automatic skipping of Windows logins https://github.com/microsoft/DacFx/issues/426
Microsoft Tech Community – Latest Blogs –Read More
Tasks and Plans from ToDo not in Planner
My Tasks and Plans from ToDo do not show up in Planner. I can see the ToDo Plans in Teams but the tasks assigned to those plans do not show up in My Tasks in Teams. Any idea why?
My Tasks and Plans from ToDo do not show up in Planner. I can see the ToDo Plans in Teams but the tasks assigned to those plans do not show up in My Tasks in Teams. Any idea why? Read More
New Feedback Opportunity: Microsoft Defender for Cloud DevOps Security Survey
If you work for a small or medium company and if you’re already using Microsoft Defender for Cloud and you have Defender CSPM we want to hear your thoughts about DevOps security capabilities: https://learn.microsoft.com/en-us/azure/defender-for-cloud/devops-support#azure-devops
Your opinion is instrumental in shaping the future of how Microsoft approaches the Defender for Cloud (MDC) product, for small and medium customers (SMC).
We sincerely appreciate your dedication to helping us deliver a world-class security solution that aligns with your needs.
If you work for a small or medium company and if you’re already using Microsoft Defender for Cloud and you have Defender CSPM we want to hear your thoughts about DevOps security capabilities: https://learn.microsoft.com/en-us/azure/defender-for-cloud/devops-support#azure-devops Your opinion is instrumental in shaping the future of how Microsoft approaches the Defender for Cloud (MDC) product, for small and medium customers (SMC). We sincerely appreciate your dedication to helping us deliver a world-class security solution that aligns with your needs.
Take the survey here! Read More
BLOG: What deprecation means in practical terms for Windows and Windows Server
What deprecation means in practical terms?!
An important and careful read every time.
Each release of Windows / Windows Server doesn’t only come with enhanced features and fixes, but also deprecation notices you have to consider.
What’s deprecation?
It’s a tag on a role or feature that longer under development.
And it marks the start of getting stale or even being removed completely from the OS. Most of the time all deprecated features will become optional features, first.
Karl, how do you deal with deprecated features?
I personally try to consult customers to remove inbox Optional Features. In this case they may not accidently use these, or otherwise notice they are in use when missing in the first place.
Feature removals are quite rare but that’s exactly why you should really consider watching the space of deprecation notices.
Are deprecated features generally removed?
Clear no. But there’s a risk of that. You should not build a business around or on deprecated features.
Removals can occour quickly, usually rather planned, when a security concern arises and no fix can be made, or a feature, by telemetry is rarely used in the first place.
Are deprecated features supported?
It depends. Every feature in-box is under the support policy of the product. So far the rules.
Do not expect up to par Microsoft support for deprecated features. Same as with OS versions outside the mainstream support (extended support), like Windows Server 2016 / 2019, both widely spread, at the time of writing.
Keep an eye on the product support matrix and the support conditions. Microsoft used to call these Lifecycle Policies, of each product.
Also other (Microsoft) products you are running on top of an OS. Speaking for the OS, the Microsoft support team might advice you to move on when for break / fix situation, no remediation can be found, and the product is deprecated or outside mainstream support.
References
Windows Server 2025 preview removed and deprecated features
Windows 11
https://learn.microsoft.com/en-us/windows/whats-new/deprecated-features?wt.mc_id=MVP_338345
Microsoft’s terminology (binding)
https://learn.microsoft.com/en-us/windows/whats-new/feature-lifecycle#terminology?wt.mc_id=MVP_338345
Microsoft Lifecycle Policies and product support lookup
https://learn.microsoft.com/en-us/lifecycle/?wt.mc_id=MVP_338345
What deprecation means in practical terms?! An important and careful read every time. Each release of Windows / Windows Server doesn’t only come with enhanced features and fixes, but also deprecation notices you have to consider.What’s deprecation? It’s a tag on a role or feature that longer under development. And it marks the start of getting stale or even being removed completely from the OS. Most of the time all deprecated features will become optional features, first. Karl, how do you deal with deprecated features?I personally try to consult customers to remove inbox Optional Features. In this case they may not accidently use these, or otherwise notice they are in use when missing in the first place. Feature removals are quite rare but that’s exactly why you should really consider watching the space of deprecation notices.Are deprecated features generally removed? Clear no. But there’s a risk of that. You should not build a business around or on deprecated features. Removals can occour quickly, usually rather planned, when a security concern arises and no fix can be made, or a feature, by telemetry is rarely used in the first place.Are deprecated features supported?It depends. Every feature in-box is under the support policy of the product. So far the rules.Do not expect up to par Microsoft support for deprecated features. Same as with OS versions outside the mainstream support (extended support), like Windows Server 2016 / 2019, both widely spread, at the time of writing.Keep an eye on the product support matrix and the support conditions. Microsoft used to call these Lifecycle Policies, of each product. Also other (Microsoft) products you are running on top of an OS. Speaking for the OS, the Microsoft support team might advice you to move on when for break / fix situation, no remediation can be found, and the product is deprecated or outside mainstream support.References
Windows Server 2025 preview removed and deprecated features
https://learn.microsoft.com/en-us/windows-server/get-started/removed-deprecated-features-windows-server-2025?wt.mc_id=MVP_338345
Windows 11https://learn.microsoft.com/en-us/windows/whats-new/deprecated-features?wt.mc_id=MVP_338345Microsoft’s terminology (binding)https://learn.microsoft.com/en-us/windows/whats-new/feature-lifecycle#terminology?wt.mc_id=MVP_338345Microsoft Lifecycle Policies and product support lookuphttps://learn.microsoft.com/en-us/lifecycle/?wt.mc_id=MVP_338345 Read More
Windows 11 Memory Compression
I am currently running Windows 11 Professional version 23H2 (OS Build 22631.3593).
I am looking as Task Manager, Memory to see the following:
As you can see, my workstation has 192GB of total RAM. Only 20GB is in use with plenty available. I am noticing that Windows has decided to compress memory even though I have plenty available. On-the-fly compression has a cost. Why would Windows randomly decide to waste processing time compressing when it is absolutely unnecessary?
I am currently running Windows 11 Professional version 23H2 (OS Build 22631.3593). I am looking as Task Manager, Memory to see the following: As you can see, my workstation has 192GB of total RAM. Only 20GB is in use with plenty available. I am noticing that Windows has decided to compress memory even though I have plenty available. On-the-fly compression has a cost. Why would Windows randomly decide to waste processing time compressing when it is absolutely unnecessary? Read More
