Author: PuTI
Help with Uploading MLTBX File to File Exchange
Hello,
I attempted to upload an MLTBX file, but I received the following error message: "This submission seems to have been previously rejected or deleted. Please contact the File Exchange admin if you wish to upload it again."
Could you please advise on how to resolve this issue or provide the contact information for the File Exchange admin?
Thank you for your assistance.
Best regards,
DanielHello,
I attempted to upload an MLTBX file, but I received the following error message: "This submission seems to have been previously rejected or deleted. Please contact the File Exchange admin if you wish to upload it again."
Could you please advise on how to resolve this issue or provide the contact information for the File Exchange admin?
Thank you for your assistance.
Best regards,
Daniel Hello,
I attempted to upload an MLTBX file, but I received the following error message: "This submission seems to have been previously rejected or deleted. Please contact the File Exchange admin if you wish to upload it again."
Could you please advise on how to resolve this issue or provide the contact information for the File Exchange admin?
Thank you for your assistance.
Best regards,
Daniel mltbx, file-exchange MATLAB Answers — New Questions
can I conduce this command?
hello, I’m tring to save this string, but the format is the same and it seems weird to write the command like that…
x_1 = sprintf(‘%.*fcos(%.*ft+%.*f)+%.*fcos(%.*ft+%.*f)’,presi,X(1),presi,w_n(1),presi,phi(1),presi,X(2),presi,w_n(2),presi,phi(2));
x_2 = sprintf(‘%.*fcos(%.*ft+%.*f)+%.*fcos(%.*ft+%.*f)’,presi,X(1)*r(1),presi,w_n(1),presi,phi(1),presi,X(2)*r(2),presi,w_n(2),presi,phi(2));
there is a batter way to get this output?
The image below is markout of the output strings, beside the ‘cos’,’t’,'(/)’ the all is numbers thet I whold like that the user of the overall function will be able to determine with the variable pressi.
thank you
and sorry for my English 😚hello, I’m tring to save this string, but the format is the same and it seems weird to write the command like that…
x_1 = sprintf(‘%.*fcos(%.*ft+%.*f)+%.*fcos(%.*ft+%.*f)’,presi,X(1),presi,w_n(1),presi,phi(1),presi,X(2),presi,w_n(2),presi,phi(2));
x_2 = sprintf(‘%.*fcos(%.*ft+%.*f)+%.*fcos(%.*ft+%.*f)’,presi,X(1)*r(1),presi,w_n(1),presi,phi(1),presi,X(2)*r(2),presi,w_n(2),presi,phi(2));
there is a batter way to get this output?
The image below is markout of the output strings, beside the ‘cos’,’t’,'(/)’ the all is numbers thet I whold like that the user of the overall function will be able to determine with the variable pressi.
thank you
and sorry for my English 😚 hello, I’m tring to save this string, but the format is the same and it seems weird to write the command like that…
x_1 = sprintf(‘%.*fcos(%.*ft+%.*f)+%.*fcos(%.*ft+%.*f)’,presi,X(1),presi,w_n(1),presi,phi(1),presi,X(2),presi,w_n(2),presi,phi(2));
x_2 = sprintf(‘%.*fcos(%.*ft+%.*f)+%.*fcos(%.*ft+%.*f)’,presi,X(1)*r(1),presi,w_n(1),presi,phi(1),presi,X(2)*r(2),presi,w_n(2),presi,phi(2));
there is a batter way to get this output?
The image below is markout of the output strings, beside the ‘cos’,’t’,'(/)’ the all is numbers thet I whold like that the user of the overall function will be able to determine with the variable pressi.
thank you
and sorry for my English 😚 sprintf, string, shortening MATLAB Answers — New Questions
Use VBA to Auto create a hyperlink in multiple cells for a column
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
OneDrive API and the standard Attribute enum
I need to iterate over many user’s OneDrives and set the PINNED attribute (“Always keep on this device”): FILE_ATTRIBUTE_PINNED 0x00080000.
In looking at drive/driveitem via the Graph API I can get a reference to a user’s OneDrive and a file, but I don’t see the “real” attributes.
Are these not exposed by the Graph API? If not, is there another way to automate this?
I need to iterate over many user’s OneDrives and set the PINNED attribute (“Always keep on this device”): FILE_ATTRIBUTE_PINNED 0x00080000.In looking at drive/driveitem via the Graph API I can get a reference to a user’s OneDrive and a file, but I don’t see the “real” attributes. Are these not exposed by the Graph API? If not, is there another way to automate this? Read More
Calendar option visible in Project for the web App
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
ADF Copy activity failed with Databricks as Sink
I got the error message below when sinking data from SQL Server to Databricks.
“ErrorCode=AzureDatabricksComplexTypesNotSupported,We don’t support complex types (struct, map, array) in copy activity.”
Apparently I don’t have these data types in the source table, except varchar(max) which I guess it caused the issue.
I believe I’m not the only one running into this issue,any suggestions?
Thanks!
I got the error message below when sinking data from SQL Server to Databricks.”ErrorCode=AzureDatabricksComplexTypesNotSupported,We don’t support complex types (struct, map, array) in copy activity.”Apparently I don’t have these data types in the source table, except varchar(max) which I guess it caused the issue.I believe I’m not the only one running into this issue,any suggestions?Thanks! Read More
Hotfix: JDBC Driver 12.8.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.8.1. The update addresses a few issues on top of the 12.8.0 release.
Fixed issues
Adjusted DESTINATION_COL_METADATA_LOCK, in SQLServerBulkCopy, so that is properly released in all cases #2492
Reverted “Execute Stored Procedures Directly” feature, as well as subsequent changes related to the feature. #2493
Changed driver behavior to allow prepared statement objects to be reused, preventing a “multiple queries are not allowed” error #2494
Changes
Changed MSAL logging from FINER to FINEST #2491
Getting the latest release
The latest bits are available to download from Microsoft, from the GitHub repository, and via Maven Central.
Add the JDBC 12.8.1 RTW driver to your Maven project by adding the following code to your POM file to include it as a dependency in your project (choose .jre8 for Java 8/1.8 or .jre11 for Java 11 and up).
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>12.8.1.jre11</version>
</dependency>
Help us improve the JDBC Driver by filing issues on GitHub or contributing to the project.
Microsoft Tech Community – Latest Blogs –Read More
Uso de Resource CPU Limit no Kubernetes
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
Released: Microsoft.Data.SqlClient 6.0 Preview 1
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
Announcing TRIMRANGE and accompanying trim references
I’m excited to announce a new function, TRIMRANGE, and a set of new reference operators.
NOTE: This is a preview function. Its signature and results may change substantially before being broadly released, based on your feedback. So, we do not recommend using it in important workbooks until it is generally available.
New TRIMRANGE function and trim refs: easily remove blanks from the edges of a range
We’re introducing a new function and a set of supporting references:
TRIMRANGE function – a function that removes empty rows from the edges of a range.
Trim references – offer a more succinct way to call common variances of the TRIMRANGE function.
TRIMRANGE function
The TRIMRANGE function removes empty rows from the edges of a range. This can be particularly useful when writing dynamic array formulas or optimizing lambda functions for performance.
In the example below, we use TRIMRANGE to calculate the length of any text entered into column A.
Calculate the length of text entered into column A with TRIMRANGE
Without the use of TRIMRANGE, =LEN(A:A) would run on every cell, returning over a million unnecessary results. Besides being inefficient, trailing undesirable 0’s are returned to the grid. This can be especially problematic if you then try and operate on the spill using =C1# notation.
TRIMRANGE is also a great new tool for optimizing the performance of lambda functions that operate on ranges. It allows lambda authors to more tightly scope ranges, which can reduce the number of necessary computations.
More information on the TRIMRANGE function can be found on the help page.
Trim References
Trim References (‘Trim Refs’) offer a more succinct way to call common variances of TRIMRANGE. They are a modifier of the iconic colon range operator A1:E5. By prefixing or suffixing the colon with a period, you can request to trim blanks from the start, end or both.
Type
Example
Equivalent TRIMRANGE
Description
Trailing trim ref (:.)
A1:.E10
TRIMRANGE(A1:E10,2,2)
Trim trailing blanks
Leading trim ref (.:)
A1.:E10
TRIMRANGE(A1:E10,1,1)
Trim leading blanks
Full trim ref (.:.)
A1.:.E10
TRIMRANGE(A1:E10,3,3)
Trim leading and trailing blanks
Full-column references are often avoided because they can have poor performance with some functions. However, with trim refs, they are much more performant as the full-column reference can be constrained to just the portion with values.
In the example below, we use the trailing trim ref to trim a full column reference. We expect trailing trim refs to be the most commonly used of the 3 trim ref variants.
Trim a full column reference with trailing trim ref
Learn More
You can learn more about the TRIMRANGE function on our help page.
Availability
This new function and new references are currently available to Beta Channel users running Version 2409 (Build 18020.2000) or later.
Don’t have it yet? It’s probably us, not you.
Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.
Feedback
We want to hear from you! Please click Help > Feedback in Excel on Windows to submit your thoughts about these new functions.
Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!
Microsoft Tech Community – Latest Blogs –Read More
Identifying the SDK Version in an Azure Bot Project: V3 or V4?
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.
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
Released: Microsoft.Data.SqlClient 4.0.6, 5.1.6, 5.2.2
We have released updates to multiple supported versions of Microsoft.Data.SqlClient. The updates address several issues.
Microsoft.Data.SqlClient 4.0 and 5.1 are LTS releases. 5.2 is a non-LTS release. All will continue to get fixes and updates until their respective End of Support dates.
To see which versions are LTS versus non-LTS, what that means, and their support timelines, see the Support Lifecycle for Microsoft.Data.SqlClient.
Updates in Microsoft.Data.SqlClient 4.0.6 include:
Fixed
Fixed connection to unsubscribe from transaction completion events before returning it to the connection pool #2301 #2435
Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider #2707
Changed
Code health improvements: #2147, #2513, #2519
For more details about the changes in Microsoft.Data.SqlClient 4.0.6, you can also see the Release Notes.
Updates in Microsoft.Data.SqlClient 5.1.6 include:
Fixed
Fixed Transient fault handling issue with OpenAsync. #1983 #2508
Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider. #2706
Fixed pending data with SqlDataReader against an encrypted column. #2618 #2818
Changed
Upgraded Azure.Identity version from 1.11.3 to 1.11.4 [#2649] (#2649) [#2529] (#2529) to address CVE-2024-35255.
Upgraded Microsoft.Identity.Client version from 4.60.0 to 4.61.3 [#2649] (#2649) [#2529] (#2529) to address CVE-2024-35255.
Added caching to TokenCredential objects to take advantage of token caching. #2776
Code health improvements: [#2490] (#2490)
For more details about the changes in Microsoft.Data.SqlClient 5.1.6, you can also see the Release Notes.
Updates in Microsoft.Data.SqlClient 5.2.2 include:
Fixed
Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider. #2650
Fixed issue with Socket.Connect in managed SNI. #2779
Fixed path for AssemblyAttributes in obj folder causing NET 8.0 assembly to appear in NET 6.0 dll. #2789
Fixed SSPI retry negotiation with default port in .NET. #2815
Fixed ArgumentNullException on SqlDataRecord.GetValue when using user-defined data type on .NET. #2816
Fixed pending data with SqlDataReader against an encrypted column. #2817
Changed
Upgraded Azure.Identity version from 1.11.3 to 1.11.4 #2648 to address CVE-2024-35255.
Upgraded Microsoft.Identity.Client version from 4.60.0 to 4.61.3 #2648 to address CVE-2024-35255.
Added caching to TokenCredential objects to take advantage of token caching. #2775
For more details about the changes in Microsoft.Data.SqlClient 5.2.2, you can also see the Release Notes.
To get the new packages, add a NuGet reference to Microsoft.Data.SqlClient in your application.
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
Azure Durable Function-How to separate Orchestrator and Activity across different blueprints
Azure Durable Function-How to separate Orchestrator and Activity across different blueprints:
Durable Functions Overview – Azure | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
How can I scale and plot the graph according to the formula I use?
Hello everyone,
I am trying to plot only the diffusion and FDEP diffusion using the formulas below. However, the FDEP diffusion plot is incorrect. I am also attaching the reference graph that it should match.
formulas:
reference graph:
my graph:
% Define parameters
epsilon0 = 8.85e-12; % F/m (Permittivity of free space)
epsilon_m = 79; % F/m (Relative permittivity of the medium)
CM = 0.5; % Clausius-Mossotti factor
k_B = 1.38e-23; % J/K (Boltzmann constant)
R = 1e-6; % m (Particle radius)
gamma = 1.88e-8; % kg/s (Friction coefficient)
q = 1e-14; % C (Charge of the particle)
dt = 1e-3; % s (Time step)
T = 300; % K (Room temperature)
x0 = 10e-6; % Initial position (slightly adjusted from zero)
N = 100000; % Number of simulations
num_steps = 1000; % Number of steps (simulation for 1 second)
epsilon = 1e-9; % Small offset to avoid division by zero
k = 1 / (4 * pi * epsilon_m); % Constant for force coefficient
% Generate random numbers
rng(0); % Reset random number generator
W = randn(num_steps, N); % Random numbers from standard normal distribution
% Define position vectors (with and without DEP force)
x_dep = zeros(num_steps, N);
x_diff = zeros(num_steps, N);
x_dep(1, 🙂 = x0;
x_diff(1, 🙂 = x0;
% Perform iterations using the Euler-Maruyama method
for i = 1:num_steps-1
% With DEP force (FDEP is present)
FDEP = 4 * pi * R^3 * epsilon0 * epsilon_m * CM * (-2 * k^2 * q^2) ./ ((abs(x_dep(i, 🙂 – x0) + epsilon).^5);
x_dep(i+1, 🙂 = x_dep(i, 🙂 + (FDEP / gamma) * dt + sqrt(2 * k_B * T / gamma) * sqrt(dt) * W(i, :); % sqrt(dt) added here
% Only diffusion (FDEP is absent)
x_diff(i+1, 🙂 = x_diff(i, 🙂 + sqrt(2 * k_B * T / gamma) * sqrt(dt) * W(i, :); % sqrt(dt) added here
end
% Calculate means
x_mean_dep = mean(x_dep, 2);
x_mean_diff = mean(x_diff, 2);
% Plot results (y-axis scaled by 10^-6)
figure;
plot((0:num_steps-1) * dt, x_mean_dep * 1e6, ‘b’, ‘LineWidth’, 1.5); % y-axis scaled by 10^-6
hold on;
plot((0:num_steps-1) * dt, x_mean_diff * 1e6, ‘r–‘, ‘LineWidth’, 1.5); % y-axis scaled by 10^-6
xlabel(‘Time (s)’);
ylabel(‘Particle Position (μm)’); % Units updated to micrometers
title(‘Particle Positions with and without DEP Force’);
legend(‘DEP Force Present’, ‘Only Diffusion’);
grid on;Hello everyone,
I am trying to plot only the diffusion and FDEP diffusion using the formulas below. However, the FDEP diffusion plot is incorrect. I am also attaching the reference graph that it should match.
formulas:
reference graph:
my graph:
% Define parameters
epsilon0 = 8.85e-12; % F/m (Permittivity of free space)
epsilon_m = 79; % F/m (Relative permittivity of the medium)
CM = 0.5; % Clausius-Mossotti factor
k_B = 1.38e-23; % J/K (Boltzmann constant)
R = 1e-6; % m (Particle radius)
gamma = 1.88e-8; % kg/s (Friction coefficient)
q = 1e-14; % C (Charge of the particle)
dt = 1e-3; % s (Time step)
T = 300; % K (Room temperature)
x0 = 10e-6; % Initial position (slightly adjusted from zero)
N = 100000; % Number of simulations
num_steps = 1000; % Number of steps (simulation for 1 second)
epsilon = 1e-9; % Small offset to avoid division by zero
k = 1 / (4 * pi * epsilon_m); % Constant for force coefficient
% Generate random numbers
rng(0); % Reset random number generator
W = randn(num_steps, N); % Random numbers from standard normal distribution
% Define position vectors (with and without DEP force)
x_dep = zeros(num_steps, N);
x_diff = zeros(num_steps, N);
x_dep(1, 🙂 = x0;
x_diff(1, 🙂 = x0;
% Perform iterations using the Euler-Maruyama method
for i = 1:num_steps-1
% With DEP force (FDEP is present)
FDEP = 4 * pi * R^3 * epsilon0 * epsilon_m * CM * (-2 * k^2 * q^2) ./ ((abs(x_dep(i, 🙂 – x0) + epsilon).^5);
x_dep(i+1, 🙂 = x_dep(i, 🙂 + (FDEP / gamma) * dt + sqrt(2 * k_B * T / gamma) * sqrt(dt) * W(i, :); % sqrt(dt) added here
% Only diffusion (FDEP is absent)
x_diff(i+1, 🙂 = x_diff(i, 🙂 + sqrt(2 * k_B * T / gamma) * sqrt(dt) * W(i, :); % sqrt(dt) added here
end
% Calculate means
x_mean_dep = mean(x_dep, 2);
x_mean_diff = mean(x_diff, 2);
% Plot results (y-axis scaled by 10^-6)
figure;
plot((0:num_steps-1) * dt, x_mean_dep * 1e6, ‘b’, ‘LineWidth’, 1.5); % y-axis scaled by 10^-6
hold on;
plot((0:num_steps-1) * dt, x_mean_diff * 1e6, ‘r–‘, ‘LineWidth’, 1.5); % y-axis scaled by 10^-6
xlabel(‘Time (s)’);
ylabel(‘Particle Position (μm)’); % Units updated to micrometers
title(‘Particle Positions with and without DEP Force’);
legend(‘DEP Force Present’, ‘Only Diffusion’);
grid on; Hello everyone,
I am trying to plot only the diffusion and FDEP diffusion using the formulas below. However, the FDEP diffusion plot is incorrect. I am also attaching the reference graph that it should match.
formulas:
reference graph:
my graph:
% Define parameters
epsilon0 = 8.85e-12; % F/m (Permittivity of free space)
epsilon_m = 79; % F/m (Relative permittivity of the medium)
CM = 0.5; % Clausius-Mossotti factor
k_B = 1.38e-23; % J/K (Boltzmann constant)
R = 1e-6; % m (Particle radius)
gamma = 1.88e-8; % kg/s (Friction coefficient)
q = 1e-14; % C (Charge of the particle)
dt = 1e-3; % s (Time step)
T = 300; % K (Room temperature)
x0 = 10e-6; % Initial position (slightly adjusted from zero)
N = 100000; % Number of simulations
num_steps = 1000; % Number of steps (simulation for 1 second)
epsilon = 1e-9; % Small offset to avoid division by zero
k = 1 / (4 * pi * epsilon_m); % Constant for force coefficient
% Generate random numbers
rng(0); % Reset random number generator
W = randn(num_steps, N); % Random numbers from standard normal distribution
% Define position vectors (with and without DEP force)
x_dep = zeros(num_steps, N);
x_diff = zeros(num_steps, N);
x_dep(1, 🙂 = x0;
x_diff(1, 🙂 = x0;
% Perform iterations using the Euler-Maruyama method
for i = 1:num_steps-1
% With DEP force (FDEP is present)
FDEP = 4 * pi * R^3 * epsilon0 * epsilon_m * CM * (-2 * k^2 * q^2) ./ ((abs(x_dep(i, 🙂 – x0) + epsilon).^5);
x_dep(i+1, 🙂 = x_dep(i, 🙂 + (FDEP / gamma) * dt + sqrt(2 * k_B * T / gamma) * sqrt(dt) * W(i, :); % sqrt(dt) added here
% Only diffusion (FDEP is absent)
x_diff(i+1, 🙂 = x_diff(i, 🙂 + sqrt(2 * k_B * T / gamma) * sqrt(dt) * W(i, :); % sqrt(dt) added here
end
% Calculate means
x_mean_dep = mean(x_dep, 2);
x_mean_diff = mean(x_diff, 2);
% Plot results (y-axis scaled by 10^-6)
figure;
plot((0:num_steps-1) * dt, x_mean_dep * 1e6, ‘b’, ‘LineWidth’, 1.5); % y-axis scaled by 10^-6
hold on;
plot((0:num_steps-1) * dt, x_mean_diff * 1e6, ‘r–‘, ‘LineWidth’, 1.5); % y-axis scaled by 10^-6
xlabel(‘Time (s)’);
ylabel(‘Particle Position (μm)’); % Units updated to micrometers
title(‘Particle Positions with and without DEP Force’);
legend(‘DEP Force Present’, ‘Only Diffusion’);
grid on; graph, graphics, mathematics, matlab, loop MATLAB Answers — New Questions
Error in MATLAB R2021a: Example Not Found in Specified Path
when I put this line to open an example in the command section:
>> openExample(‘simscape/LithiumBatteryCellOneRCBranchEquivalentCircuitExample’)
I am getting this message:
Error using findExample (line 22)
Example "LithiumBatteryCellOneRCBranchEquivalentCircuitExample" not found in "C:Program
FilesMATLABR2021bexamplessimscapeexamples.xml".
Error in openExample (line 30)
metadata = findExample(exampleId);when I put this line to open an example in the command section:
>> openExample(‘simscape/LithiumBatteryCellOneRCBranchEquivalentCircuitExample’)
I am getting this message:
Error using findExample (line 22)
Example "LithiumBatteryCellOneRCBranchEquivalentCircuitExample" not found in "C:Program
FilesMATLABR2021bexamplessimscapeexamples.xml".
Error in openExample (line 30)
metadata = findExample(exampleId); when I put this line to open an example in the command section:
>> openExample(‘simscape/LithiumBatteryCellOneRCBranchEquivalentCircuitExample’)
I am getting this message:
Error using findExample (line 22)
Example "LithiumBatteryCellOneRCBranchEquivalentCircuitExample" not found in "C:Program
FilesMATLABR2021bexamplessimscapeexamples.xml".
Error in openExample (line 30)
metadata = findExample(exampleId); findexample, error in openexample MATLAB Answers — New Questions
How to vary the pixel size in matlab imagesc() plot?
I have data of a heated plate (2m x 2m = L x L) defined by a grid (x- and y-coordinates from 0 to 2 in same or different refinements) and a corresponding matrix containing the temperatures of the centres of the plates fields (the field dimensions are defined by the x- and y-grid).
The imagesc() plot function from matlab creates good results on equidistant grids since every field has the same length and width. However working with an non-equidistant grid requires to adjust all fields dimensions according to x-y-grid.
Is it possible to do this within the imagesc() function?
Code:
imagesc(x,y, sol)
set(gca,’YDir’,’normal’)
colormap(jet(2000)); colorbar;
xlabel(‘x[m]’)
ylabel(‘y[m]’)
x and y are vectors containing the coordinates of the grid, sol is the matrix containing the field centres temperatures.
Plot:
[Heated Plate with equidistant grid]
[Heated Plate with non-equidistant grid]
The non-equidistant grid performs a refinement on the right side of the plate since numerical error is biggest there.
The refinement is defined by
– same discretization for 0 <= x <= L/2 (same for y)
– double fine discretization for L/2 <= x <= L*3/4 (same for y)
– four times discretization for L*3/4 <= x <= L (same for y)
As you can see, the refinement’s new field dimensions are not considered which ends up ruining the visulization.
I’ve already tried different plot methods like surf or pcolor. Both are not well suited for a field-centre-oriented solution.
Thank’s for any advice.I have data of a heated plate (2m x 2m = L x L) defined by a grid (x- and y-coordinates from 0 to 2 in same or different refinements) and a corresponding matrix containing the temperatures of the centres of the plates fields (the field dimensions are defined by the x- and y-grid).
The imagesc() plot function from matlab creates good results on equidistant grids since every field has the same length and width. However working with an non-equidistant grid requires to adjust all fields dimensions according to x-y-grid.
Is it possible to do this within the imagesc() function?
Code:
imagesc(x,y, sol)
set(gca,’YDir’,’normal’)
colormap(jet(2000)); colorbar;
xlabel(‘x[m]’)
ylabel(‘y[m]’)
x and y are vectors containing the coordinates of the grid, sol is the matrix containing the field centres temperatures.
Plot:
[Heated Plate with equidistant grid]
[Heated Plate with non-equidistant grid]
The non-equidistant grid performs a refinement on the right side of the plate since numerical error is biggest there.
The refinement is defined by
– same discretization for 0 <= x <= L/2 (same for y)
– double fine discretization for L/2 <= x <= L*3/4 (same for y)
– four times discretization for L*3/4 <= x <= L (same for y)
As you can see, the refinement’s new field dimensions are not considered which ends up ruining the visulization.
I’ve already tried different plot methods like surf or pcolor. Both are not well suited for a field-centre-oriented solution.
Thank’s for any advice. I have data of a heated plate (2m x 2m = L x L) defined by a grid (x- and y-coordinates from 0 to 2 in same or different refinements) and a corresponding matrix containing the temperatures of the centres of the plates fields (the field dimensions are defined by the x- and y-grid).
The imagesc() plot function from matlab creates good results on equidistant grids since every field has the same length and width. However working with an non-equidistant grid requires to adjust all fields dimensions according to x-y-grid.
Is it possible to do this within the imagesc() function?
Code:
imagesc(x,y, sol)
set(gca,’YDir’,’normal’)
colormap(jet(2000)); colorbar;
xlabel(‘x[m]’)
ylabel(‘y[m]’)
x and y are vectors containing the coordinates of the grid, sol is the matrix containing the field centres temperatures.
Plot:
[Heated Plate with equidistant grid]
[Heated Plate with non-equidistant grid]
The non-equidistant grid performs a refinement on the right side of the plate since numerical error is biggest there.
The refinement is defined by
– same discretization for 0 <= x <= L/2 (same for y)
– double fine discretization for L/2 <= x <= L*3/4 (same for y)
– four times discretization for L*3/4 <= x <= L (same for y)
As you can see, the refinement’s new field dimensions are not considered which ends up ruining the visulization.
I’ve already tried different plot methods like surf or pcolor. Both are not well suited for a field-centre-oriented solution.
Thank’s for any advice. imagesc, plot, grid, refinement MATLAB Answers — New Questions
How to avoid the state of “S”, when using matlab in ubuntu?
When I run matlab script in ubuntu, I find that their states are "S" using "top" (touching figure). What should I do to avoid it?When I run matlab script in ubuntu, I find that their states are "S" using "top" (touching figure). What should I do to avoid it? When I run matlab script in ubuntu, I find that their states are "S" using "top" (touching figure). What should I do to avoid it? ubuntu state MATLAB Answers — New Questions
M365 – Exchange Admin BUG – you cannot see the mailbox name redirected for
Hi,
as we perform actions on M365 customers tenant day to day, after changes we review what we did. After manage a mailbox and then set a ‘mail flow redirecion’, the redirection works fine but you cannot see the mailbox named for it, but only its ‘ID’.
> > > If you – reading this post -are a MS employee, pls, make sure to that issue goes to the right team to fix asap.
Hi, as we perform actions on M365 customers tenant day to day, after changes we review what we did. After manage a mailbox and then set a ‘mail flow redirecion’, the redirection works fine but you cannot see the mailbox named for it, but only its ‘ID’.> > > If you – reading this post -are a MS employee, pls, make sure to that issue goes to the right team to fix asap. Read More
Conditional formatting for Gantt chart bar based on another cell
I looked through the help topics and tried copying several other formulas, but can’t get this to work.
I’m creating a Gantt chart and would like to add a conditional formatting rule where the Gantt chart bar (which is currently blue) turns red if the “Lead” for that row is “Milestone”.
Any help is appreciated!
I looked through the help topics and tried copying several other formulas, but can’t get this to work. I’m creating a Gantt chart and would like to add a conditional formatting rule where the Gantt chart bar (which is currently blue) turns red if the “Lead” for that row is “Milestone”. https://docs.google.com/spreadsheets/d/1P_16ZsdwawvFmGkBFXBcsklo69MzA2zb/edit?usp=sharing&ouid=109402566229526341381&rtpof=true&sd=true Any help is appreciated! Read More
Intune device enrollment and authorization
Hello there, so the situation we have is we want to lock down accessing any of our o365 apps from only approved devices. I assume the only/best way to do this is via Intune. What we want to do is have it setup where users can enroll devices or do auto enrollment as long as we can approve devices coming in. We had a breach where someone was able to login to a users account that had MFA enabled still so the thought here is we would only allow access on devices we have approved. Microsoft KB articles on enrollment seem a little dry on examples and instructions. Does anyone have any good info on how to set something like that up if possible?
Hello there, so the situation we have is we want to lock down accessing any of our o365 apps from only approved devices. I assume the only/best way to do this is via Intune. What we want to do is have it setup where users can enroll devices or do auto enrollment as long as we can approve devices coming in. We had a breach where someone was able to login to a users account that had MFA enabled still so the thought here is we would only allow access on devices we have approved. Microsoft KB articles on enrollment seem a little dry on examples and instructions. Does anyone have any good info on how to set something like that up if possible? Read More
