I’m a bit confused!

I created a form, have a link to it on a page that looks like this:

https://mycompany.sharepoint.com/:l:/s/ambertest/FKRPIB72pvNDvoC4t1TFCTMBitqYSm8AauzGLQbWGK9_Pg?nav=NGZkZDM2M2UtNjMyZi00OTRkLWE1ZGEtNTBkM2NlNGIyMjZl

If I click this link, it opens the form I created.
I don’ remember where I copied this link from. 
I am trying to link to this form from another page. AND I want to edit the form – but can’t find where/how I do this!

Thanks in advance.
Amber

​I’m a bit confused!I created a form, have a link to it on a page that looks like this: https://mycompany.sharepoint.com/:l:/s/ambertest/FKRPIB72pvNDvoC4t1TFCTMBitqYSm8AauzGLQbWGK9_Pg?nav=NGZkZDM2M2UtNjMyZi00OTRkLWE1ZGEtNTBkM2NlNGIyMjZl If I click this link, it opens the form I created.I don’ remember where I copied this link from. I am trying to link to this form from another page. AND I want to edit the form – but can’t find where/how I do this!Thanks in advance.Amber  Read More

​

I have been using the Booking calendar for a while now and more often than not, it allows people to schedule appointments that are not within the Booking hours. It even allows them to book on days where the schedule is set to closed for the day. It is becoming a major problem, as it requires us contacting that person and potentially rescheduling. 

Do you know why this is happening and do you have an ETR? (expected time of resolution)

​I have been using the Booking calendar for a while now and more often than not, it allows people to schedule appointments that are not within the Booking hours. It even allows them to book on days where the schedule is set to closed for the day. It is becoming a major problem, as it requires us contacting that person and potentially rescheduling. Do you know why this is happening and do you have an ETR? (expected time of resolution)  Read More

​

After sending an email, when I look at it in sent, some of the content is missing and if I forward the email to the same person, all the content is visible.  This does not happen to all emails I send, no idea why this is happening, please help…BOB  

​After sending an email, when I look at it in sent, some of the content is missing and if I forward the email to the same person, all the content is visible.  This does not happen to all emails I send, no idea why this is happening, please help…BOB    Read More

​

Hi, 

I have a specific multi-step task I would like to automate in excel, ideally with the use of a formula. 

I have four columns (A. application year, B. patent ID, C. backward citations and D. forward citations). Columns C and D contain strings (comma separated values). 

First step:

1) For each row, I want to identify if there is a matching string value present in both column C and D. In column E (new column), I want to output the matching citation. E.g. in image file attached, cell E2 contains US1111, the string value that is present in both C2 and D2. 

Second step (column F)

2) I want to then search for patent US1111 (value in E2) in column B (list of all patents) and identify it’s application year (column A). 

Third step (column G)

3) If the output in F2 (matching citation year) is less than the value in A2, then the formula searches column B for value in E2 (US1111) and in the corresponding row, the output is “DELETE”.

An example in the data attached is

Row 2: In C2 and D2, the matching string/citation is US1111. Ideal Output in E2 is “US1111”.

Then formula in F2, searches for US1111 in column B and output’s it’s application year from column A (A16: 1994). Output in F2 = 1994.

Then in G2, new formula compares F2 (1994) to A2 (2024) and if F2<A2 (1994<2024), the formula searches for US1111 (E2) in column B and outputs “DELETE” in the corresponding row column G (G16 in our example spreadsheet as US1111 is located in B16. 

any help would be greatly appreciated!

Many many thanks

​Hi,  I have a specific multi-step task I would like to automate in excel, ideally with the use of a formula.  I have four columns (A. application year, B. patent ID, C. backward citations and D. forward citations). Columns C and D contain strings (comma separated values).  First step:1) For each row, I want to identify if there is a matching string value present in both column C and D. In column E (new column), I want to output the matching citation. E.g. in image file attached, cell E2 contains US1111, the string value that is present in both C2 and D2.  Second step (column F)2) I want to then search for patent US1111 (value in E2) in column B (list of all patents) and identify it’s application year (column A).  Third step (column G)3) If the output in F2 (matching citation year) is less than the value in A2, then the formula searches column B for value in E2 (US1111) and in the corresponding row, the output is “DELETE”. An example in the data attached isRow 2: In C2 and D2, the matching string/citation is US1111. Ideal Output in E2 is “US1111”.Then formula in F2, searches for US1111 in column B and output’s it’s application year from column A (A16: 1994). Output in F2 = 1994.Then in G2, new formula compares F2 (1994) to A2 (2024) and if F2<A2 (1994<2024), the formula searches for US1111 (E2) in column B and outputs “DELETE” in the corresponding row column G (G16 in our example spreadsheet as US1111 is located in B16.  any help would be greatly appreciated! Many many thanks  Read More

​

Social Media Posts Analysis:

I have a tabular columns on excel with days (1-31) in columns and the months (1-12) in rows, which looks like this:

The data to this feeds from another sheet in the same excel file. This data is basically saying the date on which a post was made on a social media:

I have made the tabular column (Image 1) using countifs function, where it automatically takes the day and month from the Date column and places it in appropriate cell in the 1st sheet.

For example:
Sheet1!B2=COUNTIFS(Sheet2!$D:$D,Sheet1!B$1,Sheet2!$E:$E,Sheet1!$A2)

Now my question is:
I want to format the tabular column (Image 1) as follows:

No Background color to cell -> If no posts have been made on this day and month at all or the day (DD) and month (MM) appears only in one year (there can be more than one post in the same date (DD/MM/YYYY), that is not a problem)Yellow -> If there are atleast two posts in the same day (DD) and month (MM) but in two separate years (YYYY)Green -> If there are atleast three posts in the same day (DD) and month (MM) but in three separate years (YYYY)

I hope that was clear. Please help me out if there are any methods to acheive this formating in Excel.

Let me know if you need any further clarfications.

Thanks in advance,

Eashwar

​Social Media Posts Analysis:I have a tabular columns on excel with days (1-31) in columns and the months (1-12) in rows, which looks like this:The data to this feeds from another sheet in the same excel file. This data is basically saying the date on which a post was made on a social media:  I have made the tabular column (Image 1) using countifs function, where it automatically takes the day and month from the Date column and places it in appropriate cell in the 1st sheet.For example:Sheet1!B2=COUNTIFS(Sheet2!$D:$D,Sheet1!B$1,Sheet2!$E:$E,Sheet1!$A2)Now my question is:I want to format the tabular column (Image 1) as follows:No Background color to cell -> If no posts have been made on this day and month at all or the day (DD) and month (MM) appears only in one year (there can be more than one post in the same date (DD/MM/YYYY), that is not a problem)Yellow -> If there are atleast two posts in the same day (DD) and month (MM) but in two separate years (YYYY)Green -> If there are atleast three posts in the same day (DD) and month (MM) but in three separate years (YYYY) I hope that was clear. Please help me out if there are any methods to acheive this formating in Excel.Let me know if you need any further clarfications. Thanks in advance,Eashwar  Read More

​

what I have:

I have a workbook that has to 2 sheets. (Sheet1 and Sheet2).

Sheet1(ColumnA) has the column i need to hyperlink to cells(ColumnB) on sheet2.

What i need :

create a routine that will insert a hyperlink on Sheet1 relating to Sheet2.

example:

on Sheet1 have Cell A2 HYPERLINK TO B5 on Sheet2.

A3 will hyperlink to B6

A4 will hyperlink to B7   etc….

but hard code the range…so i can change the range if needed.

This formula sub seems to only do a single insert  ?

Sub HyperlinkAnotherSheet()

Worksheets(“Sheet1”).Select Range(“B5”).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=“”, SubAddress:=“‘Sheet2’!A1”

End Sub

Thanks

fordraiders

​what I have:I have a workbook that has to 2 sheets. (Sheet1 and Sheet2).Sheet1(ColumnA) has the column i need to hyperlink to cells(ColumnB) on sheet2. What i need :create a routine that will insert a hyperlink on Sheet1 relating to Sheet2. example:on Sheet1 have Cell A2 HYPERLINK TO B5 on Sheet2.A3 will hyperlink to B6A4 will hyperlink to B7   etc…. but hard code the range…so i can change the range if needed.  This formula sub seems to only do a single insert  ?Sub HyperlinkAnotherSheet()Worksheets(“Sheet1”).Select Range(“B5″).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=””, SubAddress:=”‘Sheet2’!A1″End Sub Thanksfordraiders  Read More

​

Hi,

I have a managed solution in a production Power Apps environment that runs the Project for the web app. I noticed a “Calendar” option on the Project main form that was not there until last week. I then opened the unmanaged solution in the dev environment from where I export it as a managed solution, the Project table’s form does not have this Calendar option. No other changes were made to the main form so where is this Calendar option appearing in my solution? 

I can confirm both solution versions are the same & no other user updated the solution.

Unmanaged solution Project main form:

The production app where the Calendar option is visible:

​Hi,I have a managed solution in a production Power Apps environment that runs the Project for the web app. I noticed a “Calendar” option on the Project main form that was not there until last week. I then opened the unmanaged solution in the dev environment from where I export it as a managed solution, the Project table’s form does not have this Calendar option. No other changes were made to the main form so where is this Calendar option appearing in my solution? I can confirm both solution versions are the same & no other user updated the solution. Unmanaged solution Project main form: The production app where the Calendar option is visible:   Read More

​

Um pouco sobre como o processo funciona

Vou começar com um pouco de contexto em como a alocação de CPU funciona no Kernel do Linux. Vamos olhar para o núcleo de um processador, ele é capaz de processar uma única operação por vez, não tem mágica, você manda a operação ele processa e retorna. Se você tem dois cores, duas operações por vez e assim por diante.

Mesmo os processadores com Hyper Threading o núcleo do processador continua processando task a task, uma por vez, a tecnologia Hyper Threading (presente em processadores intel) mantém o core mais tempo processando do que ocioso, ou seja, usa melhor o tempo, mas nada mudou no núcleo, continuamos não podendo paralelizar as tarefas, apenas melhorar a concorrência entre elas.

Kernel do Linux gerenciando tarefas

Falamos um pouco da camada de hardware, agora vamos para a camada de software. Para simplificar, vamos imaginar um processador com apenas 1 core (um Intel 4004). Se você simplificar as coisas e pensar que 1 core pode processar 1 task por vez, e você tiver uma task que vai levar 10min para terminar, significa que seu processador vai ficar processando apenas esta task por 10min, o que obviamente travaria todo seu Sistema Operacional. Imagina, enquanto você está baixando um arquivo você não iria conseguir mexer o mouse, digitar no teclado, ou escutar uma música.

É para isso que existem o que chamamos de CPU Schedulers. São programas que rodam no S.O que fazem o gerenciamento das tasks que irão rodar no núcleo do processador, e obviamente eles não vão permitir que sua task de 10min cause um starvation nos outros processos. E como isso funciona ? Bom, existem diversos tipos de Schedulers, dependendo do seu S.O, vamos focar aqui no Linux. A partir da versão 2.6.23 do Kernel do Linux é utilizado um Scheduler chamado Completely Fair Scheduler (a.k.a CFS).

O CFS, como o nome já diz, tenta garantir a distribuição justa (fair) da CPU entre os processos do S.O. Em termos simples, isso significa que se você tem 1 core e 2 processos (P1 e P2), P1 vai usar 50% da CPU e P2 vai usar 50% da CPU, em termos simples ok ? É bem mais complexo que isso, envolve prioridade e agrupamento de processos, mas em termos gerais o CFS tenta distribuir igualmente.

Limits no Kubernetes

Agora que você entende como as tasks são distribuídas no núcleo do processador, vamos falar de Kubernetes. Mas primeiro, tenha em mente uma importante lição tirada da explicação acima, o ideal é que o processador fique ocupado 100% do tempo, usando 100% do seu núcleo para processar o máximo de tarefas, sem ociosidade.

Para o Kubernetes existem 2 tipos de recursos: compressible resources e not compressible resources , traduzindo para o Português, recursos compreensíveis e não compreensíveis. A memória, por exemplo, é um recurso não compreensível porque ao atingir o máximo permitido o K8s vai enviar um sinal de SIGKILL para o seu POD, por outro lado a CPU é um recurso compreensível, ou seja, mesmo que você esteja com 100% de uso, o K8s não vai mandar um SIGKILL. Porque isso ? A memória tem um tamanho finito, e quando você a enche não tem mais para onde ir, o que fazer ? Matar qualquer processo que tente usar mais memória do que o disponível. Já a CPU, tenta alocar todos os processos, porque ela trabalha com tempo, que não é um recurso finito, você pode alocar milhares de processos dentro de milli/micro/nano segundos. É óbvio se você tiver milhares de processos e apenas 1 core, cada processo vai usar 0,001% da cpu, deixando o seu S.O muito lento, devido a grande quantidade de troca entre os processos no núcleo do processador.

Agora podemos responder porque não usar Limit CPU no K8s. Quando você configura um limite de CPU, vamos supor 200m (200 millicores), você está dizendo para o K8s: “não deixe meu processo usar mais de 200 milissegundos da CPU a cada ciclo de 1 segundo“. Então vamos supor que por alguns instantes a CPU esteja livre de outros processos, você poderia estar usando 100% dela, mas estará limitado a 20% (200m), com 80% da cpu ociosa. Agora imagina que você tire esse limite, o Linux CFS vai tentar distribuir igualmente a carga da CPU entre seus PODs, e cá entre nós, provavelmente ele fará um trabalho melhor que eu e você tentando configurar um limite de CPU.

Agora um aviso muito !!IMPORTANTE!!, eu não estou dizendo que você deve sair tirando o limit CPU de todos os seus projetos. Se você tem PODs que não precisam de alto throughput , você deve sim limitar o uso de CPU, para que não haja uma concorrência pelo uso da CPU com outros PODs que realmente precisam de alto throughput. Lembra que o Linux CFS vai tentar distribuir igualmente o uso da CPU, e PODs que precisam de alta vazão podem ser impactados por aqueles que não precisam, simplesmente porque o CFS vai tentar ser fair .

Para quem chegou até aqui meu muito obrigado. Críticas e sugestões ? Deixa seu comentário.

​Microsoft Tech Community – Latest Blogs –Read More 

Microsoft.Data.SqlClient 6.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server.

Our plan is to provide regular GA releases with several preview releases in between. This cadence should provide time for feedback and allow us to deliver features and fixes in a timely manner. This 6.0 preview includes fixes and changes over the 5.2 GA release.

Breaking Changes

Removed support for .NET Standard. #2386
Removed UWP (UAP) references. #2483

Added

Added TokenCredential object to take advantage of token caching in ActiveDirectoryAuthenticationProvider. #2380
Added DateOnly and TimeOnly support to DataTable as a structured parameter. #2258
Added Microsoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic type in .NET. #2226
Added scope trace for GenerateSspiClientContext. #2497, #2725

Fixed

Fixed Socket.Connect timeout issue caused by thread starvation. #2777
Fixed pending data with SqlDataReader against an encrypted column. #2618
Fixed Entra authentication when using infinite connection timeout in ActiveDirectoryAuthenticationProvider. #2651
Fixed GetSchema by excluding unsupported engines due to lack of support for ASSEMBLYPROPERTY function. #2593
Fixed SSPI retry negotiation with default port in .NET. #2559
Fixed assembly path in .NET 8.0 and .AssemblyAttributes. #2550
Fixed certificate chain validation. #2487
Fixed clone of SqlConnection to include AccessTokenCallback. #2525
Fixed issue with DateTimeOffset in table-valued parameters, which was introduced in 5.2. #2453
Fixed ArgumentNullException on SqlDataRecord.GetValue when using user-defined data type on .NET. #2448
Fixed SqlBuffer and SqlGuild when it’s null. #2310
Fixed SqlBulkCopy.WriteToServer state in a consecutive calls. #2375
Fixed null reference exception with SqlConnection.FireInfoMessageEventOnUserErrors after introducing the batch command. #2399

Changed

Replaced System.Runtime.Caching with Microsoft.Extensions.Caching.Memory. #2493
Improved memory allocation when reader opened by CommandBehavior.SequentialAccess over big string columns. #2356

For the full list of changes in Microsoft.Data.SqlClient 6.0 Preview 1, please see the Release Notes.

To try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application and pick the 6.0 preview 1 version.

We appreciate the time and effort you spend checking out our previews. It makes the final product that much better. If you encounter any issues or have any feedback, head over to the SqlClient GitHub repository and submit an issue.

David Engel

​Microsoft Tech Community – Latest Blogs –Read More 

How to identify if a bot project is using Azure bot SDKV3 or SDKV4

As you may already know, SDK V3 has been deprecated. With the introduction of new functionalities in SDK V4 for creating Azure bots, it is crucial to migrate to the latest version. However, some projects are still running on SDK V3. I am frequently asked to verify whether a bot is using SDK V3 or V4. Therefore, I am writing this blog post to guide you on how to identify the current version your bot is running on and to emphasize the importance of migrating to SDK V4 to take advantage of enhanced performance, security, and new features.

Deprecation details 

To identify whether your Azure bot project is using SDK V3 or SDK V4, you can look for a few key indicators:

Project Structure and Files:

SDK V3: Typically, SDK V3 projects will have files like Microsoft.Bot.Builder.dll and Microsoft.Bot.Connector.dll.
SDK V4: SDK V4 projects often include files like Microsoft.Bot.Builder.Dialogs.dll and Microsoft.Bot.Builder.Integration.AspNet.Core.dll.

Code Patterns:

SDK V3: The bot’s main logic is often found in a class that inherits from IDialog or LuisDialog<T>. The message handling is done using MessageController.
SDK V4: The bot’s main logic is usually in a class that inherits from ActivityHandler or DialogBot<T>. The message handling is done using OnMessageActivityAsync.

Configuration Files:

SDK V3: You might see configuration settings in web.config or app.config.
SDK V4: Configuration settings are typically found in appsettings.json.

Dependencies:

SDK V3: Look for dependencies on Microsoft.Bot.Builder version 3.x.x.
SDK V4: Look for dependencies on Microsoft.Bot.Builder version 4.x.x.

By checking these aspects, you should be able to determine which SDK version your bot project is using.

How we can migrate the Azure bot from SDKV3 to SDKV4

Set Up a New SDK V4 Project

Create a new bot project using the Bot Framework SDK V4. You can use the Bot Framework templates for Visual Studio or the Bot Framework CLI to get started.

Migrate Bot Logic

Dialogs: In SDK V3, dialogs are often implemented using IDialog or LuisDialog<T>. In SDK V4, you will use ComponentDialog and WaterfallDialog. You’ll need to rewrite your dialog logic to fit the new structure.
Message Handling: In SDK V3, message handling is done in MessageController. In SDK V4, you handle messages in the OnMessageActivityAsync method of a class that inherits from ActivityHandler.

Update Dependencies

Ensure that your new project references the appropriate SDK V4 packages. You can find these packages on NuGet, such as Microsoft.Bot.Builder, Microsoft.Bot.Builder.Dialogs, and Microsoft.Bot.Builder.Integration.AspNet.Core.

Update Configuration

Move your configuration settings from web.config or app.config (SDK V3) to appsettings.json (SDK V4). Update any necessary settings to match the new SDK requirements.

Test Your Bot

Thoroughly test your bot to ensure that all functionalities are working as expected. Use the Bot Framework Emulator to test locally and make sure to cover all scenarios.

Deploy the Bot

Once testing is complete, deploy your bot to Azure.
You can follow the Azure Bot Service documentation for detailed steps on deployment.

Update Channels

Reconfigure your bot channels in the Azure portal to ensure they are correctly set up for the new SDK V4 bot.

Additional Resources

Bot Framework SDK V4 Documentation
Migration Guide from SDK V3 to V4

Migrating can be a bit complex, but these steps should help you get started.
Hope this helps!

​Microsoft Tech Community – Latest Blogs –Read More