Category: Microsoft
Category Archives: Microsoft
Allocating / Apportioning Challan Amounts to Different Receipts
The attached file contains three Tables
1. Challan : This table contains the data for the Tax deposited via Challan.
2. Receipts : This table contains the data for the Amounts received against which the tax has been deposited.
3. ChallanAllocation : This table contains the mapping (from Challan Table) of challan number and date to all the amounts (in the Receipts Table)
My Request involves creation of ChallanAllocation like Information in an automated way
Here one challan amount might be sufficient to cover multiple receipts
or
One receipt might be sufficient to cover multiple challans
Considering the Receipts Table as base We need to Map (allocate and / or apportion) the Challan amount to all the receipts on FIFO basis, without leaving any balance in challan, and create a new table (Structured Data Table or simple data range). We might need to split the single challan across various receipts OR split the single receipts across several challans and might need to ADD more rows to accommodate such splits.
Notes:
1. Challan date and Receipt Date need to be in ascending order, but Challan Date may be before or after the Receipt Date. I will enter the data in ascending order but appreciate if the proposed solution can sort the data based on ID and CIN Date / Receipt Date.
2. I have given data for only Two IDs (i.e., A01, A02) but there are multiple IDs for which Data is maintained in the same table.
3. Total Challan Amount and Total Receipt Amount is matching in case of A01 but might be different in other cases (like in A02). In case Total Challan Amount is MORE than the Total Receipt Amount, the balance can be ignored. But if the Challan Amount is LESS than the Receipt Amount, the additional row should appear with “Short” in CIN Column in ChallanAllocation Table (like in Cell Q49)
Any solution (VBA, non VBA) to solve this and create the desired data is EQUALLY appreciated.
As I am not very good in VBA, I am trying my best to find a Non VBA solution using Dynamic Array Functions, but I am struggling to add new rows automatically to the existing table.
In real scenario, I am going to use three different sheets (Challan, Receipts, ChallanAllocation) and will be copying the new data on the Challan and Receipts sheet, hoping that the solution will create the desired data in Sheet ChallanAllocation. Here for the sake of easy matching, I have kept the data on one sheet.
and to all the Esteemed Experts
The attached file contains three Tables1. Challan : This table contains the data for the Tax deposited via Challan.2. Receipts : This table contains the data for the Amounts received against which the tax has been deposited.3. ChallanAllocation : This table contains the mapping (from Challan Table) of challan number and date to all the amounts (in the Receipts Table) My Request involves creation of ChallanAllocation like Information in an automated way Here one challan amount might be sufficient to cover multiple receiptsorOne receipt might be sufficient to cover multiple challans Considering the Receipts Table as base We need to Map (allocate and / or apportion) the Challan amount to all the receipts on FIFO basis, without leaving any balance in challan, and create a new table (Structured Data Table or simple data range). We might need to split the single challan across various receipts OR split the single receipts across several challans and might need to ADD more rows to accommodate such splits. Notes:1. Challan date and Receipt Date need to be in ascending order, but Challan Date may be before or after the Receipt Date. I will enter the data in ascending order but appreciate if the proposed solution can sort the data based on ID and CIN Date / Receipt Date.2. I have given data for only Two IDs (i.e., A01, A02) but there are multiple IDs for which Data is maintained in the same table.3. Total Challan Amount and Total Receipt Amount is matching in case of A01 but might be different in other cases (like in A02). In case Total Challan Amount is MORE than the Total Receipt Amount, the balance can be ignored. But if the Challan Amount is LESS than the Receipt Amount, the additional row should appear with “Short” in CIN Column in ChallanAllocation Table (like in Cell Q49) Any solution (VBA, non VBA) to solve this and create the desired data is EQUALLY appreciated. As I am not very good in VBA, I am trying my best to find a Non VBA solution using Dynamic Array Functions, but I am struggling to add new rows automatically to the existing table. In real scenario, I am going to use three different sheets (Challan, Receipts, ChallanAllocation) and will be copying the new data on the Challan and Receipts sheet, hoping that the solution will create the desired data in Sheet ChallanAllocation. Here for the sake of easy matching, I have kept the data on one sheet.@Sergei Baklan@Peter Bartholomew@lori_m@Chris_Grossand to all the Esteemed Experts Read More
How can I send a message between steps
I have a python script to send email from SSIS, which reads the parameter as text and sends it. I’d like to be able to recognize what is the preceding step, instead of creating several repeated send email processes. Thanks!
I have a python script to send email from SSIS, which reads the parameter as text and sends it. I’d like to be able to recognize what is the preceding step, instead of creating several repeated send email processes. Thanks! Read More
Define Patch Approvals in WSUS but pull patches from Internet
We currently use WSUS to distribute Microsoft patches and also use Solarwinds Patch Manager to push 3rd party patches into WSUS. This allows us to fully patch an endpoint with all MS and 3rd party software patches via Windows Update Agent/WSUS. We now have a fleet of laptops connected back to our Datacenter via a VPN and they are consuming a lot of bandwith during patching cycles.
We have the following challanges:
We do use some throttling on BITS/Delivery opitmization but have had mixed resultsWe have MECM but don’t use Cloud Management gatway as was deemed too expensive. we have not moved patching to MECM yet.If we use Windows Update for Business we cannot patch 3rd party updates and loose some control around pilot groups and reporting in our estimation
Q: So is there a way for us to continue to define the approved patches/metadata via WSUS but have the system pull the patches files from the internet (Windows Update) source? Perhaps this is possible with MECM?
We currently use WSUS to distribute Microsoft patches and also use Solarwinds Patch Manager to push 3rd party patches into WSUS. This allows us to fully patch an endpoint with all MS and 3rd party software patches via Windows Update Agent/WSUS. We now have a fleet of laptops connected back to our Datacenter via a VPN and they are consuming a lot of bandwith during patching cycles.We have the following challanges: We do use some throttling on BITS/Delivery opitmization but have had mixed resultsWe have MECM but don’t use Cloud Management gatway as was deemed too expensive. we have not moved patching to MECM yet.If we use Windows Update for Business we cannot patch 3rd party updates and loose some control around pilot groups and reporting in our estimationQ: So is there a way for us to continue to define the approved patches/metadata via WSUS but have the system pull the patches files from the internet (Windows Update) source? Perhaps this is possible with MECM? Read More
Trying to pull specific data from spread sheet to a calendar
Hello,
I’m trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am unsure of what formula i could use to total the bed types for each day. I’m sure it is an easy thing but my googling has failed me.
here is the calendar.
Hello,I’m trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am unsure of what formula i could use to total the bed types for each day. I’m sure it is an easy thing but my googling has failed me. here is the calendar. Read More
Blank area in the cell when printing.
Row or line break turn to blank area in the cell when printing. Cell size changes from 5 lines to 4 lines and one blank row when printing.
Row or line break turn to blank area in the cell when printing. Cell size changes from 5 lines to 4 lines and one blank row when printing. Read More
Explore Cloud Computing with the New “Azure for Students” Module!
I’m really excited to share a new module that I developed by working with the Microsoft Learn Team: “Introduction to Azure for students.” As students, we often encounter numerous tech challenges, from managing projects and assignments to exploring new fields like AI and data science. This module is designed to help you tackle these challenges head-on by diving into the fascinating world of cloud computing with Azure.
Why Cloud Computing?
Cloud computing might sound complex, but it’s simpler than you think. Imagine it as a giant library where you can borrow books whenever you need them, without the hassle of buying or storing them. Similarly, cloud computing lets you use computing resources whenever you need them, without owning or maintaining the hardware and software. It’s flexible, easy, and often more affordable.
What You’ll Learn
In this module, you’ll discover:
Core Concepts of Cloud Computing: Learn the basics and understand what cloud computing is all about.
Azure in Action: Explore real-world scenarios to see how Azure is used in various fields, from student projects to professional healthcare.
Getting Started with Azure: Find out about the tools and services that will help you begin your Azure journey.
Why Azure Cloud?
Azure is Microsoft’s cloud platform, offering over 200 products and services. Whether you’re into AI, app development, data science, or machine learning, Azure has it all. Here’s how Azure can help you as a student:
Access Powerful Tools: Utilize advanced tools and services without the need for expensive hardware.
Scalability: Easily scale your resources up or down based on your project needs.
Cost-Effective: Pay only for the resources you use and take advantage of free services and a $100 Azure credit with the Azure for Students offer.
How Azure Can Help with College Projects?
Imagine you’re working on a complex college project that involves data analysis and collaboration with classmates. With Azure, you can set up a virtual environment where everyone can work together seamlessly, share resources, and analyze data in real-time. Need to develop a mobile app for your project? Azure provides all the necessary tools and platforms to build, test, and deploy your app efficiently.
Special Offer for Students!
Being a student usually means living on a budget. Good news—Microsoft’s got your back with Azure for Students! Get a $100 Azure credit and access a sea of free services. Learning has never been so cost-effective and fun! Learn more about the Azure for Students offer.
What are you waiting for? Start learning cloud today by going through the module with hands-on experience by claiming the Azure for Students offer. Whether you’re working on a school project, developing an app, or just curious about the cloud, this module will provide you with the foundation to succeed.
Ready to get started? Sign up on Microsoft Learn to save your progress and take the first step towards an exciting career in cloud computing!
Microsoft Tech Community – Latest Blogs –Read More
Removing duplicates and sorting data in columns instead of rows
Hello, one of our software exports data in the following format. I don’t want to touch this file since it will be exported frequently.
I want to create a different Excel file with formulas which is linked to this file and configure it in a way to obtain the results in the following way:
Basically removing the duplicates and sorting the data in columns and leaving blanks when nothing is found.
Thank you!
Hello, one of our software exports data in the following format. I don’t want to touch this file since it will be exported frequently.I want to create a different Excel file with formulas which is linked to this file and configure it in a way to obtain the results in the following way:Basically removing the duplicates and sorting the data in columns and leaving blanks when nothing is found.Thank you! Read More
Automatically replace old data with new data
Hello.
I am trying to create a sheet that averages the last 5 scores.
My idea is to have the input cell at A1, and the average cell at A7.
When a value is entered into A1, it appears in A2.
When a second value is entered into A1, it appears in A2 and the value in A2 moves to A3.
When a third value is entered into A1, it appears in A2, the value in A2 moves to A3 and the value in A3 moves to A4, and so on.
All the while, the value in A7 changes to represent the new mean.
Once A6 is full, a new A1 entry will cause the A6 number to disappear, as the value is now to old and no longer of any use.
Is this possible in excel?
Cheers
Hello. I am trying to create a sheet that averages the last 5 scores.My idea is to have the input cell at A1, and the average cell at A7.When a value is entered into A1, it appears in A2.When a second value is entered into A1, it appears in A2 and the value in A2 moves to A3.When a third value is entered into A1, it appears in A2, the value in A2 moves to A3 and the value in A3 moves to A4, and so on.All the while, the value in A7 changes to represent the new mean.Once A6 is full, a new A1 entry will cause the A6 number to disappear, as the value is now to old and no longer of any use.Is this possible in excel? Cheers Read More
Error – Your windows insider build ran into a problem and needs to restart . We will restart for you
please help me with this problem. I cannot open my laptop!
please help me with this problem. I cannot open my laptop! Read More
SVG attribute animation
CSS does not support many SVG attribute animations, and the original Edge fully supports SMIL to implement all SVG attribute animations; But the latest edge has encountered many problems, and the latest beta version is also not working. Before CSS animations fully support SVG attributes, smil animations should not be overlooked. I hope you can answer our concerns.
CSS does not support many SVG attribute animations, and the original Edge fully supports SMIL to implement all SVG attribute animations; But the latest edge has encountered many problems, and the latest beta version is also not working. Before CSS animations fully support SVG attributes, smil animations should not be overlooked. I hope you can answer our concerns. Read More
Build your own copilot! New Microsoft Copilot extensions
Customize Copilot for Microsoft 365 with tailored experiences and external data integration through Copilot extensions. Enhance productivity by leveraging large language models and Microsoft Graph for personalized responses. With plugins and connectors, extend Copilot’s capabilities to streamline tasks and automate actions, all while maintaining context and boosting efficiency.
Abram Jackson, Principal Product Manager for Microsoft 365 shows how you can get started building Copilot extensions.
Enrich and focus Microsoft Copilot with Copilot extensions.
How to tailor the user experience with actions, knowledge, and your own copilots.
Automate tasks.
Seamless integration with external systems and tailored experiences. Check out Copilot extensions using connectors and plugins and Microsoft Graph connectors.
Integrate multiple Copilot extensions in one session.
Leverage insights for comprehensive, polished outputs. See how it works.
Watch our video here:
QUICK LINKS:
00:00 — Copilot extensions
01:08 — Types of Copilot extensions
01:59 — Microsoft Graph connectors
03:20 — Plugins
04:14 — Specialized copilot
04:54 — Multiple customized copilots working together
05:42 — How to build Copilot extensions
06:45 — Plug into data-external or inside of Microsoft 365
07:31 — IDE/Visual Studio Code
08:57 — Wrap up
Link References
To get started, check out https://copilotstudio.microsoft.com
Unfamiliar with Microsoft Mechanics?
As Microsoft’s official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries
Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast
Keep getting this insider knowledge, join us on social:
Follow us on Twitter: https://twitter.com/MSFTMechanics
Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics
Video Transcript:
-You can now customize Copilot for Microsoft 365 for your own unique needs, with tailored experiences that can work with external data, while adding unique skills to accelerate the things you do every day. This is now possible with Copilot extensions. And today I’ll demonstrate the experience with Copilot extensions and how to build them.
-First, let me unpack how Copilot for Microsoft 365 works in relation to Copilot extensions. Copilot for Microsoft 365 comprises large language models, information in the Microsoft Graph to find or reference files and data in places like SharePoint, OneDrive, email, your calendar, and Teams, along with information found on the internet to personalize the Copilot experience inside the Microsoft 365 apps you use.
-For example, when you submit a prompt in Word, Copilot determines what you are trying to do, finds additional information to ground your prompt, and then returns a fully formatted, highly personalized response to you. This is what sets Copilot for Microsoft 365 apart from free generative AI experiences.
-Copilot extensions enrich and focus this already great baseline experience further. There are a few main types. The first lets you plug into information sources relevant to you that are sitting outside of Microsoft 365 in near real time, and you can interact with them, like confirming a task was completed.
-This is made possible by available plugins. You can also use connectors to extend what the Microsoft Graph indexes to sites or services also outside of Microsoft 365. The next lets you build your own Copilot, focused on a specific task requiring a specific set of files or data to guide it.
-You can also add additional instructions and workflow to scope what it generates and even automate specific actions. This specialized Copilot is then made available as a Copilot extension for others to use. Let me make this real by walking through how Copilot extensions customize your experience with Copilot for Microsoft 365.
-In this example, I’m a support technician. And one of the things I regularly have to do is write a weekly report detailing the support cases that I’ve worked on. I’m in Copilot for Microsoft Teams, and I’ll first start with my baseline Copilot experience without extensions. I’ll write a prompt to find all the emails I sent today and group them by topic.
-And that finds me all of the emails I was looking for and groups them like I asked. I now want to go beyond Microsoft 365 data and include information and knowledge base articles outside of it that are on our support site. I’ll show you the enriched experience with my Copilot extension first, and then explain what’s going on under the covers.
-I’ll use a different session, and paste in, “Summarize all the emails I sent today, group them by high level topic. For each topic, find the support wiki article that is most related.” And KB articles will come from the connected site. Once the entire response is generated, I can see the matching KB articles for each topic. And if I look at the citations, these ones are the sources using my Graph connected site.
-Here, my Copilot extension is using a Microsoft Graph connector to find information from the external sources that are connected to the Microsoft Graph. Next, I’ll use a different Copilot extension that can also perform actions with an external system on my behalf. My IT team has enabled a plugin called Doc Improvement.
-In this prompt from yesterday, I’ll paste create a doc improvement task to improve that first KB article based on the related emails I sent. This doesn’t need all of the detail from the previous prompt because Copilot gets that information from the chat history in this session. And this extension actually writes back to another system and creates a task for a content writer to update one of our KB support articles.
-After I confirm, I see a confirmation that it has created the doc improvement work item. So far I’ve shown how by using Copilot extensions, my experience as a technician was tailored with content specific to me, while enabling dynamic connections to external data and creating a ticket in my knowledge base system. Now let’s look at how I can go further by focusing in on a specific task with a specialized Copilot available as a Copilot extension.
-This is our support content author Copilot, which my team has built to help us keep our knowledge base articles up to date. You can see that it has a few suggested prompts for skills or frequent tasks. I’ll paste in update the Wiki article about remote help to add a first step of making sure that the user has logged in. This will first find the correct KB article, get its contents, understand where to insert the text, and then ask me to confirm.
-I can also suggest a modification, but let me type, go ahead, and let Copilot make the update. And one more thing I’ll show you is how you can have multiple custom Copilots work together in the same conversation. I’ll go back to the session I had with Copilot earlier. This time, I will at mention the support content author Copilot with a similar prompt.
-This performs the same job, but keeps me in this same session. Now, I’ll at mention another custom Copilot that my team has written called Support Report Writer. Because it is being used in the same session, it has Microsoft Copilot’s analysis of my email, as well as information about the KB article I just updated.
-Then after it’s finished, you’ll see that I now have a fully written draft report that I can copy into an email or a document, and make any additional changes. So, that’s how Copilot extensions work. To build them, you can choose a low-code approach with Microsoft Copilot Studio, or an IDE like Visual Studio. Let’s start with the low-code approach to build your own Copilot. You can get to Copilot Studio by going to copilotstudio.microsoft.com.
-From the Copilots tab, I just need to add a Copilot. And I can either use a prompt to describe the Copilot I want to build, or I can skip right to the configuration, which I’ll do in this case. First, I need to give it a name, so I’ll type in “Support Report Writer.” For description, I’ve enabled clipboard history here, so I’ll paste in the text to describe my Copilot. Next, instructions, give your Copilot more context about its purpose and how to respond. You can get very specific with these instructions using natural language.
-Here I’ve pasted in about 600 characters, but these can be up to 8,000 characters. Starter prompts like we saw before in our custom Copilot can also be added for frequent tasks and to help new users quickly get started. These are optional, and I’ll skip this step to save a little time. From there, I just need to hit create.
-Once complete, I can make it available to the right users and groups by publishing it. Next, you can plug into other data, which can be external to, or inside of Microsoft 365. In the Copilot from Microsoft 365 page, you can see that I already have a few actions, including a few that point to a specific SharePoint locations for content. I’ll add an action.
-Here, I can choose between a connector to link to the data I want, conversation to link to an existing solution, a prompt to link to a standard reusable prompt, and a flow containing workflow automation. I’ll choose a conversation in my case. Now, I’ll give it a name, “Support KB Docs Improvement.” I’ll leave the default solution, and you’ll see that the schema name updates itself automatically.
-Then I’ll hit create. And if you prefer to use an IDE like Visual Studio Code, let me show you the experience with the Microsoft Teams toolkit installed. I’ll start with the plugin this time. You’ll see that I have three basic JSON files open in my tabs. Swagger that JSON to connect to my API using specified operations and responses to send back when it succeeds or fails. Supportplugin.JSON describes the actions to take for users and gives more information for the model to use. Below that, the functions are defined to perform tasks.
-Then in runtimes, it points back to the swagger file and what functions are defined there. Finally, the manifest.JSON, which includes a bit more metadata including the ID, naming, developer, description, and branding details. Importantly, you’ll see that in the manifest, I’ve also defined declarative Copilots. In my case, the content Copilot I showed you earlier. So let’s jump into that JSON file to show you how to build a Copilot.
-You’ll see that this file contains essentially the same elements that we saw in Copilot Studio. Things like the name, ID, and description. The instructions, again, to provide more context for your custom Copilot. We’ve also defined capabilities, which point to our Graph connector data. Actions for a plugin that points to our open API specification, and there are also conversation starters as suggested prompts with details about what those should do.
-And with that, you can get started building Copilot extensions for more tailored experiences, capable of specialized tasks with the data you specify, even if it sits outside of Microsoft 365. These capabilities will be rolling out in the coming weeks. To learn more and get started, check out copilotstudio.microsoft.com. Keep watching Microsoft Mechanics for all the deep dives and latest updates for Copilot and more. Subscribe if you haven’t yet, and we’ll see you soon.
Microsoft Tech Community – Latest Blogs –Read More
Sharepoint template
Hi ,
Is there any one please has a sharepoint online template for employees records for HR purpose
Best regards
Hi ,Is there any one please has a sharepoint online template for employees records for HR purpose Best regards Read More
Multiple sequential vlookups
Hi!
I use Excel 2016. I have one very large excel file that I must validate several columns of data by comparing it to 3 other workbooks in a certain order. I VLOOKUP against the first workbook and then perform the second round of VLOOKUPS against the second work book for any #N/A caused by the first VLOOKUP and so on. Then I compare the data using the EXACT function. My question is – is there any way I can automate this process
Hi!I use Excel 2016. I have one very large excel file that I must validate several columns of data by comparing it to 3 other workbooks in a certain order. I VLOOKUP against the first workbook and then perform the second round of VLOOKUPS against the second work book for any #N/A caused by the first VLOOKUP and so on. Then I compare the data using the EXACT function. My question is – is there any way I can automate this process Read More
Multiple images in a cell?
Hey all –
I was wondering if there’s any way to insert multiple images in a cell?
I’d ideally love to be able to insert multiple images in 1 cell and have a drop-down arrow, where a person can click the cell and use the drop-down to scroll through different images. Like you can do with names or regular text in cells.
Not sure if this is possible, probably not, just wondering!
Hey all – I was wondering if there’s any way to insert multiple images in a cell?I’d ideally love to be able to insert multiple images in 1 cell and have a drop-down arrow, where a person can click the cell and use the drop-down to scroll through different images. Like you can do with names or regular text in cells.Not sure if this is possible, probably not, just wondering! Read More
Se pierden los perfiles de Microsoft edge
A cada reinicio de PC pierdo los perfiles en Edge, cuando trato de loguearme para sincronizar no me permite usar mi cuenta.
A cada reinicio de PC pierdo los perfiles en Edge, cuando trato de loguearme para sincronizar no me permite usar mi cuenta. Read More
PackageDependencies and RtlDosApplyFileIsolationRedirection
For security purposes, we would prefer to keep all of the VCRuntime dlls out of MSIX packages and instead replace them with Microsoft.VCLibs.xxx package dependencies.
For most applications (being repackaged), we can simply remove the files from the package and add the dependency in the AppXManifest file. LoadLibrary happily finds the files in the dependency package without need of the PSF.
There are applications, however, that have folders containing numerous managed dlls along with the VCRuntimes in a folder, and use an internal manifest in the exe that includes a
Dependency / dependentassembly / Assemblyidentity that lists the folder,
and then an external manifest in that folder that lists all of the dependent dlls to be loaded.
When the application process is launched, the internal manifest is processed and we see the dlls listed in the external manifest being located using the API RtlDosApplyFileIsolationRedirection rather than load library.
It appears that this API does not look at the location containing AppXManifest PackageDependencies thus the dlls are not found and the launch of the exe fails. The PackageDependencies should always be respected or they are useless.
I have an example package (Blender) that has this condition if you’d like to look at it.
For security purposes, we would prefer to keep all of the VCRuntime dlls out of MSIX packages and instead replace them with Microsoft.VCLibs.xxx package dependencies.
For most applications (being repackaged), we can simply remove the files from the package and add the dependency in the AppXManifest file. LoadLibrary happily finds the files in the dependency package without need of the PSF.
There are applications, however, that have folders containing numerous managed dlls along with the VCRuntimes in a folder, and use an internal manifest in the exe that includes a
Dependency / dependentassembly / Assemblyidentity that lists the folder,
and then an external manifest in that folder that lists all of the dependent dlls to be loaded.
When the application process is launched, the internal manifest is processed and we see the dlls listed in the external manifest being located using the API RtlDosApplyFileIsolationRedirection rather than load library.
It appears that this API does not look at the location containing AppXManifest PackageDependencies thus the dlls are not found and the launch of the exe fails. The PackageDependencies should always be respected or they are useless.
I have an example package (Blender) that has this condition if you’d like to look at it. Read More
Microsoft Build 2024: Resumo das Principais Novidades em IA e Tecnologia
Durante os dias 21 a 23 de Maio de 2024, aconteceu o evento Microsoft Build 2024, que foi realizado tanto de forma presencial quanto online. O evento contou com inúmeras novidades e incríveis anúncios, principalmente voltados para o uso da Inteligência Artificial em diversas áreas. Neste artigo, estarei abordando os principais destaques do evento, bem como as novidades apresentadas durante o evento.
Keynote de Abertura – Satya Nadella
O evento já começa destacando a importância e a transformação que a Inteligência Artificial está trazendo para o mundo. Sendo considerado uma das maiores revoluções tecnológicas nos últimos 30 anos.
Logo em seguida Satya Nadella entra no palco para realizar o keynote de abertura do Microsoft Build 2024. Satya Nadella destacou as inovações e lançamentos que prometem transformar a maneira como desenvolvemos e utilizamos a tecnologia com foco em Inteligência Artificial.
Caso queira assistir a keynote de abertura, podem rever abaixo:
Novidades e Anúncios
Copilot+ PCs: O Futuro da Computação com IA
Um dos anúncios mais empolgantes foi o lançamento dos Copilot+ PCs, a nova geração de computadores que integra IA em todos os níveis de hardware e software. Esses dispositivos, estarão disponíveis a partir de 18 de junho, prometem ser até 20 vezes mais poderosos e 100 vezes mais eficientes para cargas de trabalho de IA em comparação com PCs tradicionais.
Em relação a esse lançamento, Satya Nadella apresentou um vídeo demonstrando o poder e a eficiência dos novos Copilot+ PCs. Abaixo vocês podem ver algumas das principais características desses novos dispositivos:
Há uma série de recursos em relação a essa novidade. Para mais informações, acesse o link: Introducing Copilot+ PCs
Windows Copilot Runtime: Integração de IA no Coração do Windows
A Microsoft apresentou o Windows Copilot Runtime, uma plataforma que traz APIs e modelos de IA diretamente para o Windows 11. Com suporte a frameworks populares como PyTorch e a nova estrutura WebNN. Assim sendo, os desenvolvedores poderão criar aplicativos de IA mais eficientes e poderosos.
Para mais informações sobre o Windows Copilot Runtime, acesse o link: Windows Copilot Runtime
Parcerias Poderosas: NVIDIA e AMD
As parcerias da Microsoft com NVIDIA e AMD foram reforçadas, com a introdução de novas GPUs como a NVIDIA H200 e B100, além de VMs baseadas no acelerador AMD MI300X. Essas colaborações visam fornecer a melhor performance e custo-benefício para desenvolvedores que utilizam IA.
Para mais informações sobre essas parcerias, acesse os links: NVIDIA e AMD
Microsoft Fabric: Inteligência em Tempo Real
O Microsoft Fabric foi revelado como uma plataforma integrada para a gestão de dados em tempo real. Com ele, empresas poderão obter insights acionáveis de maneira rápida e eficiente, integrando dados de diversas fontes, incluindo IoT e sistemas de telemetria. Entre as novidades relacionadas ao produto:
Inteligência em Tempo Real: Solução de SaaS para análise de dados em tempo real, permitindo decisões mais rápidas e informadas.
Banco de Dados PostgreSQL no Azure: Capacidades avançadas de IA integradas ao banco de dados, permitindo chamadas para o Azure OpenAI Service e geração de embeddings diretamente no banco de dados.
Novos Recursos no Microsoft Fabric: Kit de Desenvolvimento de Workload, compartilhamento de dados em tempo real, API GraphQL e habilidades de IA integradas para experiências de dados.
Para mais informações sobre as novidades relacionadas ao Microsoft Fabric, acesse o artigo: Unlock real-time insights with AI-powered analytics in Microsoft Fabric
Expansão do Copilot: De Assistente Pessoal a Assistente de Equipe
O Microsoft 365 Copilot foi expandido para atuar como um assistente de equipe, denominado “Team Copilot“. Essa ferramenta promete melhorar a colaboração e a produtividade das equipes, facilitando a gestão de reuniões e a comunicação em grupo.
Para mais informações sobre o Team Copilot, acesse o link: Team Copilot
Copilot Studio: Personalização e Automação de Copilots
Com o Copilot Studio, desenvolvedores agora podem criar copilotos personalizados, integrando fontes de dados específicas e automatizando tarefas complexas. A ferramenta também suporta a criação de conectores personalizados, facilitando a integração com sistemas corporativos.
Para mais informações sobre o Copilot Studio, acesse o link: Copilot Studio
Família Phi-3: Modelos de Linguagem Avançados
A Microsoft ampliou sua família de modelos de linguagem, afirmando o seu compromisso em desenvolver soluções Open Source. E, como estamos vivenciando uma demanda crescente por modelos de linguagem, a Microsoft introduzindo o P**hi-3 Vision**, que combina capacidades de linguagem e visão, e novos modelos menores e mais eficientes. Esses modelos prometem ser altamente eficazes em uma variedade de aplicações.
Para mais informações sobre a Família Phi-3, acesse o link do artigo: New models added to the Phi-3 family, available on Microsoft Azure
Windows 365 e Parceria com Meta: Expansão para Novos Dispositivos
A parceria com a Meta permitirá que o Windows 365 seja utilizado em dispositivos Quest, trazendo a experiência do Windows para a realidade virtual e permitindo a criação de aplicativos volumétricos em 3D.
Keynote Dia 2 – Scott Guthrie
O segundo dia do evento foi marcado pela keynote de Scott Guthrie, que destacou a importância da nuvem e da IA especificamente para desenvolvedores. Ele apresentou várias novidades e atualizações relacionadas ao Azure e ao desenvolvimento de aplicativos relacionados à IA.
Caso queira assistir a keynote de Scott Guthrie assista abaixo:
Vamos agora conferir as principais novidades apresentadas por Scott Guthrie
GitHub Copilot Workspace: Revolucionando o Desenvolvimento de Software
Scott Guthrie anunciou o GitHub Copilot Workspace, uma evolução do GitHub Copilot que permite aos desenvolvedores brainstorm, planejamento, construção e teste de código usando linguagem natural. A ferramenta promete aumentar a produtividade e reduzir a complexidade do desenvolvimento de software.
O serviço por enquanto está em fase preview. Mas, você pode saber mais sobre o GitHub Copilot Workspace acessando o link: GitHub Copilot Workspace
AKS Automatic: Kubernetes Simplificado
A nova oferta AKS Automatic tem como proposta automatizar a configuração e gerenciamento de clusters Kubernetes, garantindo desempenho otimizado e segurança. Essa ferramenta é ideal para desenvolvedores que buscam simplicidade e eficiência na gestão de suas aplicações em contêineres.
.NET Aspire: Desenvolvimento em Nuvem Facilitado
A Microsoft lançou o como General Availability o .NET Aspire, uma ferramenta de código aberto que facilita o desenvolvimento de soluções nativas da nuvem, proporcionando segurança, confiabilidade e alto desempenho.
Se você deseja experimentar o .NET Aspire, acesse o tutorial: Quickstart: Build your first .NET Aspire app
E, se você for uma Pessoa Desenvolvedora C# e deseja saber como usar o .NET Aspire com Node.js, acesse o tutorial: Build .NET Aspire apps with Node.js
GitHub Copilot for Azure: Integração Perfeita com a Nuvem
A integração do GitHub Copilot com Azure permite que os desenvolvedores façam perguntas em linguagem natural sobre seus ambientes de nuvem Azure, aumentando a eficiência e mantendo os desenvolvedores no fluxo de trabalho.
Para saber mais sobre o GitHub Copilot for Azure, acesse o link: do artigo: Copilot in Azure Technical Deep Dive
Azure AI Studio: Hub de Desenvolvimento de IA Generativa
O Azure AI Studio é o centro de desenvolvimento para soluções de IA generativa, incluindo o novo serviço de tokens PGO Global, que oferece até 10 milhões de tokens por minuto de throughput, e um desconto de 50% para processamento de lotes fora do horário de pico.
Algumas das novidades apresentadas no Azure AI Studio:
Abordagem de Desenvolvimento Dual: Interface amigável e capacidades de desenvolvimento orientado a código
Experiências de Desenvolvimento: Integração com Azure Developer CLI (azd) e AI Toolkit para Visual Studio Code, facilitando operações de modelos de linguagem (LLMOps). (Em pré-visualização)
Modelos como Serviço (MaaS): Acesso a modelos de fundação de líderes do setor, permitindo a criação de apps de IA generativa sem necessidade de infraestrutura dedicada. (Em pré-visualização)
Ferramentas e Serviços de IA: Integração de dados, orquestração de prompts e avaliação de sistemas, suportando fluxos de trabalho multimodais. (Em pré-visualização)
Rastreamento e Depuração: Melhoria na visão e depuração de fluxos de trabalho de IA. (Em pré-visualização)
Monitoramento de Apps de IA Generativa: Monitoramento de uso de tokens, qualidade e métricas operacionais, com alertas para melhorias contínuas. (Em pré-visualização)
Agora o serviço está como General Availability. Para saber mais sobre o Azure AI Studio, acesse o link: Azure AI Studio
Modelos Frontier e Open Source: Flexibilidade e Escolha
A Microsoft está trazendo uma ampla gama de modelos de IA de código aberto para o Azure AI, incluindo mais de 1600 modelos de parceiros como Hugging Face, Meta, MSR AI e Nvidia, oferecendo flexibilidade e escolha para os desenvolvedores.
Devido a isso, a Microsoft informou que o novo modelo da OpenAI, o GPT-4o, que conta como um omni-modelo capaz de realizar tarefas de visão, texto e falas, estará disponível no Azure AI Studio.
Para saber mais sobre os modelos de IA de código aberto, acesse o link: OpenAI GPT-4o
Azure AI Search e Azure Cosmos DB: Poder para Aplicações RAG
Ferramentas como Azure AI Search e Azure Cosmos DB são essenciais para a criação de aplicações RAG (Retrieval-Augmented Generation), permitindo escalabilidade e alta qualidade nas respostas.
As novidades apresentadas sobre o Azure AI Search:
Capacidade de RAG em Escala: Suporte para tipos de vetor binário e outras funcionalidades de busca vetorial, melhorando a eficiência de armazenamento.
Relevância da Pesquisa: Melhorias na busca vetorial e híbrida, incluindo ponderação de vetores, controle de limiar de pontuação e aumento no tamanho máximo de recuperação de texto, aprimorando a precisão das respostas.
Integrações de Dados e Processamento:
Vetorização de imagens integrada via Azure AI Vision e novos modelos de embedding no catálogo do Azure AI Studio.
Conector OneLake para integração direta de dados do Microsoft Fabric ao Azure AI Search, ampliando as fontes de dados que podem ser indexadas e pesquisadas.
As novidades apresentadas sobre o Azure Cosmos DB:
Capacidades de Banco de Dados Vetorial Integradas: Indexação vetorial embutida e busca de similaridade vetorial no Azure Cosmos DB para NoSQL, eliminando a necessidade de um banco de dados vetorial separado. (Disponível em junho, em Preview)
Migração de Conta Serverless para Provisionada: Transição de contas serverless para modo de capacidade provisionada através do portal Azure ou CLI, mantendo acesso total a operações de leitura e escrita. (Em pré-visualização)
Recuperação de Desastres Entre Regiões: Recuperação de desastres no Azure Cosmos DB baseado em vCore para MongoDB, permitindo a criação de réplicas de clusters em outras regiões, com promoção automática em caso de falha. (Em Preview)
Integração com Vercel: Conexão fácil de apps Vercel a bancos de dados Azure Cosmos DB existentes ou criação de novas contas Azure Try Cosmos DB integradas aos projetos Vercel. (Em GA)
SDK Go para Azure Cosmos DB: O SDK Go permite operações em contas Azure Cosmos DB para NoSQL, suportando regiões preferidas, tentativas entre regiões e diagnósticos de solicitações. (GA)
Para saber mais sobre as novidades lançadas sobre Azure Cosmos DB, acesse o link: aqui
Conclusão
O Microsoft Build 2024 foi um evento repleto de novidades e anúncios incríveis, principalmente voltados para a Inteligência Artificial e a nuvem. As parcerias com empresas como NVIDIA e AMD, o lançamento dos Copilot+ PCs e a expansão da família Phi-3 são exemplos de como a Microsoft está investindo em soluções inovadoras e de alto desempenho.
Além disso, a integração do GitHub Copilot com Azure e as atualizações no Azure AI Studio demonstram o compromisso da Microsoft em fornecer ferramentas poderosas e flexíveis para desenvolvedores de todo o mundo.
Claro que só foi possível abordar uma pequena parte das novidades apresentadas no evento. Para saber mais sobre todas as novidades e anúncios apresentados durante o Microsoft Build, existe um book explicando detalhadamente cada uma das novidades. Vocês podem acessar o book através do link: Microsoft Build 2024 – Book of News
Espero que tenham gostado do resumo e que as novidades apresentadas possam inspirar vocês a criar soluções inovadoras e impactantes.
Nos vemos no próximo artigo!
Microsoft Tech Community – Latest Blogs –Read More
Need help!
Our e-mail accounts have been de-activated in the middle of our subscription year. Our e-mail has been down for a week but we have no one to contact. Does anyone have a phone number or way to get help?
Thank you in advance
Our e-mail accounts have been de-activated in the middle of our subscription year. Our e-mail has been down for a week but we have no one to contact. Does anyone have a phone number or way to get help?Thank you in advance Read More
Message Displayed Every Time I make a Call
This message is displayed everytime I make a call. It doesn’t matter which prompt I pick the next time I make a call it is displayed. How do I make it stop?
This message is displayed everytime I make a call. It doesn’t matter which prompt I pick the next time I make a call it is displayed. How do I make it stop? Read More
