Month: November 2024
Excel worksheet 的計算錯誤
A1=30.8，A2=A1；B2=33.3，B3=B2+0.01；F2=ROUND(B2*(A2-0.8),0)
B87=B86+0.01=34.15，A87=A86=30.8，F87的公式=ROUND(B87*(A87-0.8),0)，工作表計算結果F87=1024
K1=30.8，K2=K1；L2=33.3，L3=L2+0.01；P2=ROUND(L2*(K2-0.8),0)
B87=B86+0.01=34.15，A87=A86=30.8，P37的公式=ROUND(L37*(K37-0.8),0)，工作表計算結果P37=1025
依上列公式ROUND(B87*(A87-0.8),0)為(34.15*(30.8-0.8))=1024.5，四捨五入1025，F87的結果是錯的，P37是對的，請問這種錯誤(F87)要怎麼修正?
感謝
A1=30.8，A2=A1；B2=33.3，B3=B2+0.01；F2=ROUND(B2*(A2-0.8),0)B87=B86+0.01=34.15，A87=A86=30.8，F87的公式=ROUND(B87*(A87-0.8),0)，工作表計算結果F87=1024K1=30.8，K2=K1；L2=33.3，L3=L2+0.01；P2=ROUND(L2*(K2-0.8),0)B87=B86+0.01=34.15，A87=A86=30.8，P37的公式=ROUND(L37*(K37-0.8),0)，工作表計算結果P37=1025依上列公式ROUND(B87*(A87-0.8),0)為(34.15*(30.8-0.8))=1024.5，四捨五入1025，F87的結果是錯的，P37是對的，請問這種錯誤(F87)要怎麼修正?感謝 Read More
How to convert PDF to MOBI on my Windows 11 computer (Without loss)?
I often have eBooks and documents in PDF that I want to read on my Kindle, so I’m looking for assistance with converting PDF files to MOBI format on my Windows 11 computer. And I’m unsure of the best method to make this conversion. While I’ve encountered a few software options and online tools, I’m not certain which ones are reliable and easy to use, especially since I want to preserve the layout and formatting of the original document.
I would greatly appreciate your advice. Thank you.
I often have eBooks and documents in PDF that I want to read on my Kindle, so I’m looking for assistance with converting PDF files to MOBI format on my Windows 11 computer. And I’m unsure of the best method to make this conversion. While I’ve encountered a few software options and online tools, I’m not certain which ones are reliable and easy to use, especially since I want to preserve the layout and formatting of the original document. I would greatly appreciate your advice. Thank you. Read More
Help making something like a decision tree with dropdowns
Hello,
I would like help creating a thing please. I’m pretty confident that Excel will be able to handle it, but I’m not sure how do go about it.
I work in a medical practice, and for this one task we have a very complicated assigning structure which I’m wanting to simplify. The task is requested by a Doctor, and is then assigned to a Person to report on based off of who the requesting Doctor is, and what day of the week it is. It could look like any of the following scenarios:
Dr A requests the test on Wednesday, and so it is assigned to Person Z
Dr A requests the test on Tuesday, and so it is assigned to Person Y
Dr B requests the test and it is assigned to Person Y
Dr C requests the test and it is assigned to Person X, except if it’s a Tuesday then it’s Person Y
Dr D requests the test and it is assigned to Person W, but only once a day, and after that it goes to person Y on a Wednesday, and Person X every other day
This task involves a list of maybe 50 Doctors, and almost as many Person’s. I’m hoping to eventually have an Excel form where I can select a day of the week, and a Doctor, and it will tell me who the Person is.
I hope that that makes sense, and I’m hoping someone might be able to help point me in the right direction please? Thanks
Hello, I would like help creating a thing please. I’m pretty confident that Excel will be able to handle it, but I’m not sure how do go about it. I work in a medical practice, and for this one task we have a very complicated assigning structure which I’m wanting to simplify. The task is requested by a Doctor, and is then assigned to a Person to report on based off of who the requesting Doctor is, and what day of the week it is. It could look like any of the following scenarios:Dr A requests the test on Wednesday, and so it is assigned to Person ZDr A requests the test on Tuesday, and so it is assigned to Person YDr B requests the test and it is assigned to Person YDr C requests the test and it is assigned to Person X, except if it’s a Tuesday then it’s Person YDr D requests the test and it is assigned to Person W, but only once a day, and after that it goes to person Y on a Wednesday, and Person X every other day This task involves a list of maybe 50 Doctors, and almost as many Person’s. I’m hoping to eventually have an Excel form where I can select a day of the week, and a Doctor, and it will tell me who the Person is. I hope that that makes sense, and I’m hoping someone might be able to help point me in the right direction please? Thanks Read More
How to copy text from a PDF file opened through teams
Teams includes a file browser. I can open PDF-files through it. But I can’t manage to copy text. I can even select text, but CTRL+C does not work.
How does it work?
And if it is impossible…why on earth does teams not provide the most basic functionality?
Teams includes a file browser. I can open PDF-files through it. But I can’t manage to copy text. I can even select text, but CTRL+C does not work. How does it work? And if it is impossible…why on earth does teams not provide the most basic functionality? Read More
15% discount for eligible nonprofit customers on Microsoft 365 Copilot effective November 1, 2024
Microsoft 365 Copilot is now available to eligible nonprofits for $25.50 (USD) per user per month when purchased for an annual subscription and billing cycle.
To purchase Microsoft 365 Copilot, customers must have or purchase a separate license for a qualifying Microsoft 365 plan.
Eligible nonprofit customers can switch to the nonprofit-priced Microsoft 365 Copilot subscription at renewal. If they wish to add new licenses before renewal, they can start a new subscription 11/1 onwards.
Discount details
Geography: Available in all markets where Microsoft 365 Copilot is sold on CSP (Worldwide).
Customer eligibility: All eligible nonprofit customers (new and existing Microsoft 365 Copilot customers).
There is no minimum purchase requirement, and no limit on the number of licenses you can buy.
Eligible nonprofit customers must purchase a new subscription; licenses added to existing subscriptions won’t receive the nonprofit discount.
The discount is available on New Commerce Experience (NCE) only.
Additional resources:
Leverage nonprofit Copilot GTM resources for your customer conversations: Modern Work | Drive Business Transformation with Copilot
Partners, invite your nonprofit customers to the Copilot Quickstart Trainings for nonprofits.
Microsoft 365 Copilot is now available to eligible nonprofits for $25.50 (USD) per user per month when purchased for an annual subscription and billing cycle.
To purchase Microsoft 365 Copilot, customers must have or purchase a separate license for a qualifying Microsoft 365 plan.
Eligible nonprofit customers can switch to the nonprofit-priced Microsoft 365 Copilot subscription at renewal. If they wish to add new licenses before renewal, they can start a new subscription 11/1 onwards.
Discount details
Geography: Available in all markets where Microsoft 365 Copilot is sold on CSP (Worldwide).
Customer eligibility: All eligible nonprofit customers (new and existing Microsoft 365 Copilot customers).
There is no minimum purchase requirement, and no limit on the number of licenses you can buy.
Eligible nonprofit customers must purchase a new subscription; licenses added to existing subscriptions won’t receive the nonprofit discount.
The discount is available on New Commerce Experience (NCE) only.
Additional resources:
Leverage nonprofit Copilot GTM resources for your customer conversations: Modern Work | Drive Business Transformation with Copilot
Partners, invite your nonprofit customers to the Copilot Quickstart Trainings for nonprofits. Read More
Enhance Cost Optimization in Azure Cosmos DB Without Compromising Service
Optimizing Azure cosmos DB involves using strategies and best practices to reduce the overall spending on the service while maintaining and improving performance and availability.
In this blog, I’ll explore actionable strategies and tools for reducing your Azure Cosmos DB costs without sacrificing the speed, scalability, or reliability of your database. Whether you’re managing large-scale applications or developing on a budget, these insights will help you make the most out of Azure Cosmos DB.
The main sub-topics we shall dive into includes:
Pricing model
Free development
Plan for Optimization
1. Pricing model
Azure cosmos DB bills for three types of usage: compute, storage, and bandwidth. What does this mean? Let us break it down.
Compute
Azure Cosmos DB bills based on Request Units (RU) measured per second (RU/s). Request Units are currency for throughput. This represents the cost of operations on your database which can either be read, write, and query. These operations consume a certain number of RUs (Request Units) based on their complexity and size.
Storage
Azure Cosmos DB bills for consumed storage, rounded up to the next gigabyte (GB) per container, collection, table, or graph per region.
Bandwidth
Data transfer between Azure Cosmos DB and other Azure services or the internet incurs additional costs. The exact pricing depends on the amount of data transferred.
Types Azure Cosmos DB account
You get charged depending on the type of account you have. Azure cosmos DB account can be either be Provisioned Throughput or a Serverless Account.
Provisioned Throughput.
Think of provisioned throughput as the “speed limit” for your Azure Cosmos DB database and containers. It determines how many requests (or operations) your database or container can handle per second. Just like a highway with different speed limits, you allocate a specific amount of throughput to your database or container.
Based on your workloads, you can scale either upwards or downwards. However, there is a minimum throughput requirement to guarantee SLAs. You will be charged for the provisioned throughput even when you do not run any workloads, this is because the model dedicates resources to your container or your database.
What is the difference between Azure cosmos DB database and azure cosmos DB containers?
Azure cosmos DB database is a storage area where you can organize a set of containers. You can create multiple containers to hold different types of data.
Azure cosmos DB Containers are individual storage compartments within a database. They help organize data effectively. An advantage you get is that you can set different throughput for each based on the workload.
Example/ Illustration
Imagine you are developing an e-commerce application. Your database is called: OnlineStore. The containers it contains include:
Products – to store product details
Customers – to store customer information
Orders – to store orders places
Database level and Container level Throughput in Azure cosmos DB.
When you set throughput at the database level, it applies to all containers within that database. You can choose between two options for provisioned throughput.
Standard (Manual) Throughput: This is a fixed speed limit for a specific container.
Autoscale Throughput: The speed limit adjusts automatically based on demand.
The throughputs are evenly distributed to all the partitions. If a container gets more requests than it is allocated, it might slow down.
Throughput on a container.
Throughput provisioned for a container is evenly distributed among its physical partitions while it assumes the logical partitions of the container. At times, the logical partitions consume more than the throughput allocated to the underlying physical partition. If such happens, operations will be rate limited. This will need you to reprovision the throughput for the entire container. Learn more about Partitioning and horizontal scaling in Azure Cosmos DB
The image shows how a physical partition hosts one or more logical partitions of a container:
Throughput on a database.
As earlier stated, when you provision throughput on a database, it will be shared across all the containers unless you specify that the throughput should be used in some containers.
It is recommended that when you configure throughput for your database, it should be across all the containers and not any parti container.
The image below demonstrates how a physical partition can host one or more logical partitions that belong to different containers within a database:
Learn more provisioned throughput in Azure Cosmos DB
Serverless Account
The serverless account type in Azure Cosmos DB is designed for scenarios where you want to pay only for the resources you use. With the serverless option, you’re charged based on the request units (RUs) consumed by your database operations and the storage used by your data.
Uses Cases of serverless Account
You are in development or testing a service
When there is unpredicted traffic
When integrating with serverless compute services, like Azure Functions.
Learn more about Azure Cosmos DB serverless account type
2. Free development
The second way to optimize your services on Azure cosmos Db is free development. There are two ways to develop for free: You can use Free tier or use the emulator.
Free tier
The Azure Cosmos DB free tier makes it easy to get started, develop, test your applications, or even run small production workloads for free.
When you enable the free tier on an Azure Cosmos DB account, you’ll receive the following benefits:
First 1000 RU/s (Request Units per second): You get the first 1000 RU/s for free.
25 GB of Storage: You also receive 25 GB of storage at no cost.
Beyond these limits, any additional throughput or storage consumed is billed at regular prices.
The free tier is available for all API accounts with provisioned throughput, autoscale throughput, single, or multiple write regions.
With the free tier, you do not accrue any cost, however, you do not have the option for high availability.
Note that free tier is not available for serverless accounts.
You can have up to one free tier Azure Cosmos DB account per Azure subscription. If you don’t see the option to apply the free tier discount, another account in the same subscription has already been enabled with the free tier.
Learn more about Azure Cosmos DB lifetime free tier
Use the emulator
The Azure Cosmos DB emulator is a powerful tool that provides a local environment for emulating the Azure Cosmos DB service. It is mostly used for development and Testing. With the emulator, you can develop without the need for Azure subscriptions.
The emulator’s Data Explorer pane is only supported in the API for NoSQL and API for MongoDB. Understand the differences between the emulator and cloud service
3. Plan for Optimization
Estimate Costs Before Creating Resources:
Use the Azure Cosmos DB capacity calculator to estimate your workload cost before creating any resources. This tool allows you to input details such as the number of regions, data stored, and anticipated operations volume.
It provides an estimate of storage costs and provisioned throughput based on your workload parameters.
Here is an image to show how to use the capacity calculator. Visit the Documentation on Estimating RU/s using the Azure Cosmos DB capacity planner to learn how to use it
Understand the Full Billing Model
Azure Cosmos DB runs on Azure infrastructure, and costs accrue when you deploy new resources. Be aware that the costs for Azure Cosmos DB are only a portion of your monthly Azure bill, which includes all azure services and resources used in your subscription, including third-party services
Understand the full billing model
Monitor Costs
As you use resources with Azure Cosmos DB, you incur costs. Regularly monitor your usage and spending to stay within budget.
You can view this on Azure portal.
Step 1: Login to your azure portal and go to your resource.
Step 2: Go to the overview section
Step 3: At the bottom, click on monitoring to show the estimate chart., you can estimate the usage at an interval of 1hr, 24hrs,7days and 30days. You will be able to see the estimates on the chart.
Create Budgets
Set budgets in Azure Cost Management to manage costs effectively. Create alerts that will notify of spending anomalies and overspending risks.
Here are images to show you how you can achieve that.
Step 1: In your resource, expand on monitoring and select alerts and click on add rule.
Step 2: Select a signal, I will select CPU Credits consumed.
Step 3: Set the threshold that will trigger the actions
Step 4: On the sections tab, select actions. I will go with ‘Use quick actions’ a feature with is on preview. It will send me an email to alert me. Give the group name and a display name for it.
Step 5: On Details Tab, add a name to the alert then review and create the alert.
Conclusion.
We have covered several ways you can optimize your resources on Azure cosmos DB. Following the good practices, you can optimize costs while your services are still running as expected. To learn more, you can visit the links shared below.
Read More
Total Cost of Ownership (TCO) with Azure Cosmos DB
Best practices for scaling provisioned throughput (RU/s)
Provisioned throughput in Azure Cosmos DB
Learn more on how to plan and manage costs for Azure Cosmos DB
Optimize request cost in Azure Cosmos DB
Optimize storage cost in Azure Cosmos DB
Optimize multi-region cost in Azure Cosmos DB
Optimize development and testing cost in Azure Cosmos DB
Microsoft Tech Community – Latest Blogs –Read More
How to disable annoying popup in Outlook
Over the past few days, Outlook desktop (new) version 1.2024.1023.300 has been showing an annoying popup (as shown in the image) every time I open Outlook. It’s becoming quite frustrating.
I’ve tried clicking both buttons and even submitted a report, but the popup still appears every time I open Outlook.
Over the past few days, Outlook desktop (new) version 1.2024.1023.300 has been showing an annoying popup (as shown in the image) every time I open Outlook. It’s becoming quite frustrating.I’ve tried clicking both buttons and even submitted a report, but the popup still appears every time I open Outlook. Read More
Azure devops are there any out of the box time log feature?
Hi,
We are new to Azure devops boards and we are trying to understand how we can log time against each work item. however, we are unable to find any out of the box feature for this
what is the best option for this? also we have a requirement to access these worklogs via an rest API
Hi, We are new to Azure devops boards and we are trying to understand how we can log time against each work item. however, we are unable to find any out of the box feature for thiswhat is the best option for this? also we have a requirement to access these worklogs via an rest API Read More
How to Factory Reset my Hard Drive on Windows 10 computer?
I’m looking to factory reset hard drive on a Windows 10 computer, and I could really use some guidance. I want to make sure all my personal data is wiped clean before I recycle it, and I’m not entirely sure about the best steps to take. Are there specific instructions I should follow to ensure everything on the drive is erased securely? Also, if there are any built-in tools or third-party software recommendations that would make this process easier, I’d love to hear about those too.
Thanks in advance for your help!
I’m looking to factory reset hard drive on a Windows 10 computer, and I could really use some guidance. I want to make sure all my personal data is wiped clean before I recycle it, and I’m not entirely sure about the best steps to take. Are there specific instructions I should follow to ensure everything on the drive is erased securely? Also, if there are any built-in tools or third-party software recommendations that would make this process easier, I’d love to hear about those too. Thanks in advance for your help! Read More
老街腾龙娱乐公司70411382据库管理系统
强大的数据存储和管理能力：支持大规模数据存储，可以处理海量的结构化数据。无论是小型企业的业务数据，还是大型企业的复杂数据集合，SQL Server 都能提供稳定可靠的数据存储解决方案。提供高效的数据管理功能，包括数据的插入、更新、删除、查询等操作。通过优化的存储引擎和查询处理器，能够快速响应各种复杂的查询请求，提高数据处理效率。高可用性和可靠性：具备多种高可用性解决方案，如数据库镜像、故障转移集群等。这些技术可以确保在硬件故障、软件故障或其他意外情况下，数据库系统能够持续运行，保证业务的连续性。支持数据备份和恢复功能，可以定期对数据库进行备份，并在需要时快速恢复数据。这对于保护企业的重要数据至关重要。安全性：提供强大的安全功能，包括用户身份验证、访问控制、数据加密等。可以对不同的用户和角色设置不同的访问权限，确保数据的安全性和保密性。支持透明数据加密（T DE）等高级加密技术，可以对整个数据库进行加密，防止数据泄露。集成性和扩展性：与微软的其他产品和技术紧密集成，如 Windows Server、Visual Studio 等。这使得开发人员和管理员能够更加方便地进行开发、部署和管理。提供丰富的扩展功能和接口，可以与第三方软件和工具进行集成。例如，可以通过 O D B C、J D BC 等接口与其他编程语言和数据库系统进行交互。
企业资源规划（E R P）系统：SQL Server 可以作为 E R P 系统的后端数据库，存储和管理企业的各种业务数据，如销售订单、库存信息、财务数据等。通过与 E R P 软件的集成，可以实现高效的数据处理和业务流程管理。客户关系管理（C R M）系统：用于存储客户信息、销售机会、客户服务记录等数据。通过强大的查询和分析功能，可以帮助企业更好地了解客户需求，提高客户满意度和销售业绩。电子商务平台：管理商品信息、订单数据、用户信息等。支持高并发的访问请求，确保电子商务平台的稳定运行。数据分析和报表：作为数据仓库的后端存储，支持大规模的数据存储和分析。可以使用 SQL Server 的分析服务和报表服务，创建各种数据分析报表和仪表盘，为企业决策提供数据支持。
优势：功能强大：提供了丰富的功能和工具，满足企业级应用的各种需求。易于使用：与微软的其他产品和技术具有良好的集成性，使得开发人员和管理员能够快速上手。高可用性和可靠性：通过多种技术保障数据库系统的持续运行。安全性高：提供了多层次的安全防护措施，保护企业数据的安全。不足：成本较高：对于小型企业来说，可能需要较高的成本投入。对硬件要求较高：在处理大规模数据时，可能需要较高配置的硬件设备。
QL 服务器（SQL Server）是由微软公司开发的一款关系型数据库管理系统，在企业级应用中具有广泛的用途。 一、主要特点 强大的数据存储和管理能力：支持大规模数据存储，可以处理海量的结构化数据。无论是小型企业的业务数据，还是大型企业的复杂数据集合，SQL Server 都能提供稳定可靠的数据存储解决方案。提供高效的数据管理功能，包括数据的插入、更新、删除、查询等操作。通过优化的存储引擎和查询处理器，能够快速响应各种复杂的查询请求，提高数据处理效率。高可用性和可靠性：具备多种高可用性解决方案，如数据库镜像、故障转移集群等。这些技术可以确保在硬件故障、软件故障或其他意外情况下，数据库系统能够持续运行，保证业务的连续性。支持数据备份和恢复功能，可以定期对数据库进行备份，并在需要时快速恢复数据。这对于保护企业的重要数据至关重要。安全性：提供强大的安全功能，包括用户身份验证、访问控制、数据加密等。可以对不同的用户和角色设置不同的访问权限，确保数据的安全性和保密性。支持透明数据加密（T DE）等高级加密技术，可以对整个数据库进行加密，防止数据泄露。集成性和扩展性：与微软的其他产品和技术紧密集成，如 Windows Server、Visual Studio 等。这使得开发人员和管理员能够更加方便地进行开发、部署和管理。提供丰富的扩展功能和接口，可以与第三方软件和工具进行集成。例如，可以通过 O D B C、J D BC 等接口与其他编程语言和数据库系统进行交互。 二、应用场景 企业资源规划（E R P）系统：SQL Server 可以作为 E R P 系统的后端数据库，存储和管理企业的各种业务数据，如销售订单、库存信息、财务数据等。通过与 E R P 软件的集成，可以实现高效的数据处理和业务流程管理。客户关系管理（C R M）系统：用于存储客户信息、销售机会、客户服务记录等数据。通过强大的查询和分析功能，可以帮助企业更好地了解客户需求，提高客户满意度和销售业绩。电子商务平台：管理商品信息、订单数据、用户信息等。支持高并发的访问请求，确保电子商务平台的稳定运行。数据分析和报表：作为数据仓库的后端存储，支持大规模的数据存储和分析。可以使用 SQL Server 的分析服务和报表服务，创建各种数据分析报表和仪表盘，为企业决策提供数据支持。 三、优势与不足 优势：功能强大：提供了丰富的功能和工具，满足企业级应用的各种需求。易于使用：与微软的其他产品和技术具有良好的集成性，使得开发人员和管理员能够快速上手。高可用性和可靠性：通过多种技术保障数据库系统的持续运行。安全性高：提供了多层次的安全防护措施，保护企业数据的安全。不足：成本较高：对于小型企业来说，可能需要较高的成本投入。对硬件要求较高：在处理大规模数据时，可能需要较高配置的硬件设备。 总之，SQL Server 是一款功能强大、可靠安全的关系型数据库管理系统，适用于各种规模的企业应用。在选择数据库管理系统时，企业需要根据自身的业务需求、预算和技术实力等因素进行综合考虑。 Read More
Enhancing Gaming Experiences with Interactive Tools and Immersive Content on Fan Sites
Hi Mixed Reality community,
I run a site called Pokémon Infinite Fusions, which is dedicated to providing fans with interactive tools and resources for creating unique Pokémon fusions. We’ve developed several features aimed at enriching the gaming experience for fans, including:
Downloadable Game: A desktop version with endless customization.Mobile Gameplay Guide: Instructions for fans who want to play on their mobile devices.Fusion Pokédex: An index showcasing unique Pokémon fusions created by our community.Fusion Generator Tool: A real-time tool that lets users create their own Pokémon fusions.Stat Calculator: A tool for calculating stats of custom Pokémon fusions.
These features, especially the interactive tools, engage users by allowing them to create and experiment with their own content, which I believe could benefit from some mixed-reality enhancements. I’m curious if anyone here has explored adding AR or MR elements to similar fan-driven websites? Any suggestions on implementing mixed reality to improve engagement would be greatly appreciated!
Looking forward to your thoughts!
Hi Mixed Reality community,I run a site called Pokémon Infinite Fusions, which is dedicated to providing fans with interactive tools and resources for creating unique Pokémon fusions. We’ve developed several features aimed at enriching the gaming experience for fans, including:Downloadable Game: A desktop version with endless customization.Mobile Gameplay Guide: Instructions for fans who want to play on their mobile devices.Fusion Pokédex: An index showcasing unique Pokémon fusions created by our community.Fusion Generator Tool: A real-time tool that lets users create their own Pokémon fusions.Stat Calculator: A tool for calculating stats of custom Pokémon fusions.These features, especially the interactive tools, engage users by allowing them to create and experiment with their own content, which I believe could benefit from some mixed-reality enhancements. I’m curious if anyone here has explored adding AR or MR elements to similar fan-driven websites? Any suggestions on implementing mixed reality to improve engagement would be greatly appreciated!Looking forward to your thoughts! Read More
This Month in Azure Static Web Apps | 09/2024
We are back with another edition of the Azure Static Web Apps Community! :party_popper:
September was yet another month filled with amazing content created by the Technical Community! 🚀
Remember, if you want to learn more about Azure Static Web Apps, we have:
👉 Tutorials
👉 Videos
👉 Sample Codes
👉 Official Documentation
👉 And much more!
If you want to see your content featured next month, share it with us! Don’t know how to do that? Don’t worry! We’ll explain how to participate at the end of this article. 😉
Special Thanks
We would like to express our gratitude to everyone who contributed their content in September! 🚀
Now, let’s check out what the community brought to us in September 2024!
Community Content Highlights – September 2024
Let’s take a look at the main content created by the community in September 2024!
Article: Build Scalable Azure Static Web Apps for Handling High Traffic Websites
Author: Lakindu Hewawasam
The article presents strategies for scaling Azure Static Web Apps to handle high traffic volumes, emphasizing the importance of adjustments to ensure global performance. It covers optimizations like asset compression, caching, and lazy loading, along with infrastructure improvements using Azure Front Door and CDN.
Backend scalability is discussed, focusing on the auto-scaling capabilities of Azure Functions. The use of Azure Monitor and Application Insights is recommended for proactive monitoring. Paid plans and advanced features are suggested to ensure high quality. Explore the full article for more details.
Link: Build Scalable Azure Static Web Apps for Handling High Traffic Websites
Video: Deploy Next.js websites to the cloud with Azure Static Web Apps – Beginner’s Guide
Author: Microsoft Azure Developers Youtube Channel
This video guide is a great starting point for beginners who want to learn how to deploy their Next.js websites using Azure Static Web Apps. The tutorial covers all the necessary steps, from setting up the GitHub repository to deploying on Azure, all for free and quickly.
Video: Deploy Blazor websites to the cloud with Azure Static Web Apps – Beginner’s Guide
Author: Microsoft Azure Developers Youtube Channel
In this guide, Dheeraj Bandaru, Product Manager for Azure Static Web Apps, teaches how to deploy Blazor sites to the cloud using Azure Static Web Apps. The video highlights benefits like speed, cost savings, and security, along with integrating frameworks such as Angular and React.
The guide demonstrates how to set up the Blazor app, publish with GitHub Actions, configure custom domains, and set up a backend with Azure Functions. It also covers traffic testing, CDN usage, and database connections. To learn each step in detail, watch the full video.
Video: Deploy Angular websites to the cloud with Azure Static Web Apps – Beginner’s Guide
Author: Microsoft Azure Developers Youtube Channel
Another video from the Microsoft Azure Developers channel, this guide is aimed at beginners who want to deploy Angular sites to the cloud using Azure Static Web Apps. The tutorial is detailed and easy to follow, covering everything from creating the Angular app to publishing on Azure.
Video: Deploy React websites to the cloud with Azure Static Web Apps – Beginner’s Guide
Author: Microsoft Azure Developers Youtube Channel
And to close with a golden key, we have another video from the Microsoft Azure Developers channel! This guide is for those who want to deploy React sites to the cloud using Azure Static Web Apps. The tutorial is comprehensive and easy to follow, covering everything from setting up the React app to publishing on Azure.
Documentation: Enterprise-grade edge
Author: Microsoft Azure Docs
This documentation provides an overview of the new Enterprise-Grade Edge feature for Azure Static Web Apps, integrating Azure Front Door and Azure CDN to offer faster page loading, enhanced security, and greater reliability for global applications.
Enterprise-Grade Edge Overview (09/23/2024): Azure Static Web Apps now includes the Enterprise-Grade Edge, integrating Azure Front Door and Azure CDN to provide faster page loading, enhanced security, and greater reliability for global applications.
Key Features: The service covers over 118 edge locations in 100 metropolitan cities, offering caching capabilities, proactive DDoS protection, IPv6 and HTTP/2 support, and optimized file compression.
Caching Levels: Enterprise-Grade Edge allows caching at CDN, DNS, and browser levels, with options to configure custom cache-control headers to optimize performance.
Configuration Options: Users can enable Enterprise-Grade Edge via a managed experience in the Azure portal (with no configuration changes or downtime) or manually, for greater control over CDN configuration, traffic limits, and web application firewall usage.
Considerations and Limitations: Enabling the feature incurs additional costs. Removing a custom domain may take up to 48 hours to propagate, and Private Endpoint is not supported.
Link: Enterprise-Grade Edge Overview
Article: Unleashing My Passion for Azure Static Web Apps!
Author: Stacy Cash
In this article, Stacy Cash shares his passion for Azure Static Web Apps, highlighting the ease of deployment and integration with Azure Functions. He also announces an online conference that will take place on October 31, 2024, featuring talks and demonstrations on using this technology, from basic introductions to advanced use cases. If you are looking for an enthusiastic and detailed view of Azure Static Web Apps, this article is a great choice.
Link: Unleashing My Passion for Azure Static Web Apps
Documentation: Quickstart: Building your first static site using the Azure CLI
Author: Microsoft Azure Docs
This quickstart guide teaches you how to create and deploy your first static site using Azure Static Web Apps with the Azure CLI. The tutorial covers prerequisites, environment variable configuration, repository creation, and app publishing, offering a practical and efficient way to get started with the service.
Link: Quickstart: Building your first static site with the Azure Static Web Apps using the CLI
Article: CI/CD with GitHub Actions on Azure Web App (Dev, QA and Prod)
Author: Lorenzo Uriel
The article “CI/CD with GitHub Actions on Azure Web App (Dev, QA and Prod)” guides you through creating a complete CI/CD pipeline for Azure Static Web Apps using GitHub Actions. It covers how to set up separate environments for Development, QA, and Production, ensuring an organized and secure deployment process. Ideal for those looking to automate cloud application delivery efficiently.
Link: CI/CD with GitHub Actions on Azure Web App (Dev, QA and Prod)
Article: Stop building CRUD APIs, use Data API Builder instead!
Author: Sander ten Brinke
The article “Stop building CRUD APIs, use Data API Builder instead!” explores how Microsoft’s Data API Builder (DAB) can simplify API creation, eliminating the need to manually configure CRUD APIs. The author highlights the benefits of DAB, such as support for multiple databases and automatic generation of REST and GraphQL endpoints. Ideal for developers looking to streamline data exposure and reduce time spent on repetitive tasks.
Link: Stop building CRUD APIs, use Data API Builder instead!
Article: Deploying a Full-stack Next.js App to Azure Web App through Bitbucket Pipelines
Author: @tharakahalkewelatecs
The article “Stop building CRUD APIs, use Data API Builder instead!” explores how Microsoft’s Data API Builder (DAB) can simplify API creation, eliminating the need to manually configure CRUD APIs. The author highlights the benefits of DAB, such as support for multiple databases and automatic generation of REST and GraphQL endpoints. Ideal for developers looking to streamline data exposure and reduce time spent on repetitive tasks.
Link: Stop building CRUD APIs, use Data API Builder instead!
Article: Deploying a Full-stack Next.js App to Azure Web App through Bitbucket Pipelines
Author: @tharakahalkewelatecs
This guide details the process of deploying a full-stack Next.js application to Azure Web App using Bitbucket Pipelines. It covers everything from initial project setup, adjustments in Bitbucket and Azure, to using pipelines for automating build and deployment. Ideal for those looking for a practical solution to host Next.js applications on Azure.
Link: Deploying a Full-stack Next.js App to Azure Web App through Bitbucket Pipelines
Article: Implementing Custom Middleware in .NET 8 for Azure Web Apps
Author: NashTech
The article “Implementing Custom Middleware in .NET 8 for Azure Web Apps” explores how to configure custom middleware in .NET 8 to add functionalities such as request logging and processing time. With detailed instructions on creating, local testing, and deploying to Azure Web Apps, it’s ideal for those looking to apply middleware in real-world scenarios.
Link: Implementing Custom Middleware in .NET 8 for Azure Web Apps
Video: How to host a website in Microsoft Azure for Free
Author: Azure Innovation Station
This video explains how to host a website for free on Microsoft Azure, highlighting the benefits of Azure Static Web Apps. It covers features such as custom domain support, free SSL, continuous integration (CI/CD), and Azure Functions for the backend. If you’re looking for a quick and easy solution to get your website online, this video is a great choice.
How to Participate?
Enjoyed the article? Want to see your content featured next month? It’s simple! Let us explain how you can participate:
Create content about Azure Static Web Apps (article, video, project, or podcast).
Share it on social media using the hashtag #AzureStaticWebApps.
Post it on the official Azure Static Web Apps repository on GitHub, under the Discussions tab. Find the topic called This Month In Azure Static Web Apps and share your content link there.
This way, your content could be shared on Microsoft TechCommunity in the next edition!
Conclusion
And these were the highlights of the Azure Static Web Apps Community in September 2024! We thank everyone who contributed their content and helped strengthen this amazing community! If you want to see your content featured next month, don’t forget to share it with us! 🌟
Until the next edition! 👋
Microsoft Tech Community – Latest Blogs –Read More
What’s EventID 5059？
I encountered Event5059 today,accompanied with my spooky logining direct into my desk,no need for typing in my secret code?That’s terrifying!
I encountered Event5059 today,accompanied with my spooky logining direct into my desk,no need for typing in my secret code?That’s terrifying! Read More
Automating label downgrade email notifications
I’ve been asked to investigate scheduling a query to run once a day that searches for label downgrade activities and sends an email with a list of events to the user’s manager (according to the AD attribute). The thinking is, the manager is more likely to know if the files that are being downgraded are sensitive, personal or inconsequential and can alert us if they are sensitive and we need to investigate further.
I have a KQL query that provides the results, I have created an analytics rule that runs the query every 24 hours and generates an alert, but when it comes to the Playbook i’m not sure how/if I can extract the fields/attributes from the results so I can use them to generate the email(s). I want the manager to only get the results for the people in their team/department, not the results for everyone in the company, so I would expect separate emails will be sent to each manager daily, rather than the same email going to multiple managers.
Is what I am trying to do feasible, and if so, am I going about it the right way?
Any advice appreciated.
I’ve been asked to investigate scheduling a query to run once a day that searches for label downgrade activities and sends an email with a list of events to the user’s manager (according to the AD attribute). The thinking is, the manager is more likely to know if the files that are being downgraded are sensitive, personal or inconsequential and can alert us if they are sensitive and we need to investigate further. I have a KQL query that provides the results, I have created an analytics rule that runs the query every 24 hours and generates an alert, but when it comes to the Playbook i’m not sure how/if I can extract the fields/attributes from the results so I can use them to generate the email(s). I want the manager to only get the results for the people in their team/department, not the results for everyone in the company, so I would expect separate emails will be sent to each manager daily, rather than the same email going to multiple managers. Is what I am trying to do feasible, and if so, am I going about it the right way? Any advice appreciated. Read More
Need help with Multiple IF and AND statements
Hi all,
I have been working on this for hours with no luck. There must be something I am missing.
I have 1 spreadsheet with two tabs. Tab 1 “Issues Register” contains all the raw data entry information for each incident, Tab 2 “Working Formula Sheet” is where I am generating all my “working” formulas which will be used to prepare graphs, based on info from Tab 1.
In Tab 1, Column C displays the date the incident was created, and Column M displays the progress bar for the incident, e.g. 01-Item Started, 02-Awaiting Information, 03-Up for Approval and 04-Item Closed etc.
I am trying to work out yearly and monthly totals, risk level totals and progress totals etc. I’ve been able to work out formulas for all these except the progress totals.
In Tab 2, I have Column A, Row 2 which displays the first date of January, and Column B, Row 2 which displays the last date of January, then Column A, Row 3 and Column B, Row 3 for Feb and so on. I also have in Column A, Row 28 04-Item Closed.
To identify how many entries were created for a specific month, I used this formula:
=(IF(AND(‘Issue Register’!C3>=$A$2, ‘Issue Register’!C3<=$B$2), “1”, “0”))+0
This has worked well.
What I’m now trying to work out is:
How many entries in each month were “closed”, eg has the cell value of 04-Item Closed”.
I tried to use the formula above, and added in an extra IF statement:
=(IF(AND(‘Issue Register’!C3>=$A$2, ‘Issue Register’!C3<=$B$2, ‘Issue Register’!M3=$A$28), “1”, “0”))+0 but it doesnt work.
What am I missing please?
Thanks.
Hi all, I have been working on this for hours with no luck. There must be something I am missing. I have 1 spreadsheet with two tabs. Tab 1 “Issues Register” contains all the raw data entry information for each incident, Tab 2 “Working Formula Sheet” is where I am generating all my “working” formulas which will be used to prepare graphs, based on info from Tab 1. In Tab 1, Column C displays the date the incident was created, and Column M displays the progress bar for the incident, e.g. 01-Item Started, 02-Awaiting Information, 03-Up for Approval and 04-Item Closed etc. I am trying to work out yearly and monthly totals, risk level totals and progress totals etc. I’ve been able to work out formulas for all these except the progress totals. In Tab 2, I have Column A, Row 2 which displays the first date of January, and Column B, Row 2 which displays the last date of January, then Column A, Row 3 and Column B, Row 3 for Feb and so on. I also have in Column A, Row 28 04-Item Closed. To identify how many entries were created for a specific month, I used this formula:=(IF(AND(‘Issue Register’!C3>=$A$2, ‘Issue Register’!C3<=$B$2), “1”, “0”))+0 This has worked well. What I’m now trying to work out is:How many entries in each month were “closed”, eg has the cell value of 04-Item Closed”. I tried to use the formula above, and added in an extra IF statement:=(IF(AND(‘Issue Register’!C3>=$A$2, ‘Issue Register’!C3<=$B$2, ‘Issue Register’!M3=$A$28), “1”, “0”))+0 but it doesnt work. What am I missing please? Thanks. Read More
OneDrive taking up space on C drive
Hi
My OneDrive is taking up a lot of space on my C drive. I thought OneDrive was in the Cloud. Did I set it up wrong? Any tips or ideas on how to save space on my C drive when I am using OneDrive? Thanks!
Hi My OneDrive is taking up a lot of space on my C drive. I thought OneDrive was in the Cloud. Did I set it up wrong? Any tips or ideas on how to save space on my C drive when I am using OneDrive? Thanks! Read More
Office 365 for IT Pros November 2024 Update
Monthly Update #113 for the Office 365 for IT Pros eBook
The Office 365 for IT Pros eBook team is happy to announce the availability of the November 2024 update (#113) for Office 365 for IT Teams (2025 edition). Current subscribers can download the updated files using the link in their receipt or through their Gumroad.com account. More details about how to fetch updates are available in our FAQ. Details of changes made at the chapter level are available in our change log.
Office 365 for IT Pros (2025 edition) includes the Automating Microsoft 365 with PowerShell eBook. The PowerShell book has also been refreshed and expanded in this update.
Microsoft FY25 Q1 Results
Closing off the November update coincided with Microsoft releasing its FY25 Q1 results. Normally, I publish a post to comment about the parts of the results that relate to Microsoft 365, but Microsoft’s current rush to apply artificial intelligence to everything means that their quarterly results feature less detail about Microsoft 365.
What we learned was that revenues for the Microsoft Cloud reached $38.9 billion (up 22% year-over-year), or an annual run rate of $155.6 billion. These revenues come with a very healthy 71% margin. In terms of seats, Microsoft has stopped talking about Office 365 seats and now discusses Microsoft 365 seats. That’s fine because Microsoft 365 includes Office 365. In any case, Microsoft said that the number of paid seats had increased 8% year-over-year, which puts Office 365 seats at or around 420 million. Most of the new seats come from frontline workers and small businesses, which might indicate that Office 365 is at saturation point within the enterprise.
In a response to analyst questions (see the earnings call transcript), CFO Amy Hood said that the new seats have “a lower RPU point” (lower average revenue per user). However, upgrades to E5 and Copilot help drive the ARPU and Hood said that she expects to see the impact of Copilot engagement in that number (which Microsoft doesn’t share) going forward.
The Impact of Microsoft 365 Copilot
Speaking of Copilot, Microsoft gave no firm numbers about the number of Microsoft 365 Copilot licenses they’ve managed to sell. They gave some meaningless statistics, like the number of people using Copilot doubled quarter over quarter and that 70% of the Fortune 500 use Copilot. With true numbers, this data is useless. They could be true if Copilot seats doubled from 2 to 4 and each Fortune 500 organization was testing with 100 seats (or less). Citing Microsoft 365 Copilot deployments like Vodafone (68,000 seats) and UBS (50,000 seats) is more impressive.
Microsoft said that the annual run rate of their AI business will get to $10 billion in the next quarter. It’s important to say that this number includes business like Azure OpenAI and isn’t interpreted as Copilot revenue.
The Meaningless Teams Data
Another example of meaningless Microsoft assertions is the statement that 75% of Teams enterprise customers use Premium, Phone, or Rooms. In their FY24 Q4 results, Microsoft said that 3 million users had Teams Premium licenses (less than 1% of the 320 million Teams installed base). The claim now being made doesn’t detail the number of seats sold to Teams enterprise customers or a breakdown of how many have Premium, Phone, or Rooms licenses, so it’s impossible to say whether this is an impressive or disappointing statistic.
On to Office 365 for IT Pros Update #114
What we learned from Microsoft’s results is that the number of paid Microsoft 365 seats continues to grow, albeit possibly more slowly in the enterprise segment. Microsoft’s focus on upselling customers to more expensive products and add-ons continues in the pursuit of higher ARPU. Not much has changed in those respects over the last few years. Meanwhile, the attention of the Office 365 for IT Pros team turns to monthly update #114, which we anticipate will be available on December 1, 2024.
How do I access planner roster?
I have created a planner roster and added members using
https://learn.microsoft.com/en-us/planner/access-planner-roster
This includes adding my own account.
But I can’t see it anywhere or access it – for instance, I go to tasks.office.com and there is no new plan with the name I used to create it.
Does anyone know how to actually use this planner roster?
I have created a planner roster and added members usinghttps://learn.microsoft.com/en-us/planner/access-planner-rosterThis includes adding my own account.But I can’t see it anywhere or access it – for instance, I go to tasks.office.com and there is no new plan with the name I used to create it. Does anyone know how to actually use this planner roster? Read More
