Month: May 2024
Remove SP list columns from search results
I have created an employee directory in a SharePoint list. Currently, when I search the list using my name all records are returned since I created the records. I would like to remove the “Created by” and “Modified by” columns from the search results so that when someone searches for me all records are not returned. I’m looking for a solution that can be applied at the site level as I do not want to change the default behavior for other sites in the tenant.
I have created an employee directory in a SharePoint list. Currently, when I search the list using my name all records are returned since I created the records. I would like to remove the “Created by” and “Modified by” columns from the search results so that when someone searches for me all records are not returned. I’m looking for a solution that can be applied at the site level as I do not want to change the default behavior for other sites in the tenant. Read More
Hibernation support now available for Azure Virtual Desktop
Today we are happy to announce the general availability of hibernation support in Azure Virtual Desktop. Explore additional capabilities that make it easier to save compute costs for your idle resources.
Hibernation support in Azure Virtual Desktop
In November 2023, we announced the public preview of hibernation support in Azure Virtual Desktop. Hibernating a session host virtual machine (VM) deallocates the machine while persisting the VM’s in-memory state. When a VM hibernates, you don’t pay for the compute cost associated with the VM. Instead you pay only for the storage and networking costs associated with the VM. When the session host virtual machine starts, the user will be able to quickly resume from where they left off.
The following capabilities are now generally available in Azure Virtual Desktop:
Hibernation can be enabled for session host VMs deployed to personal host pools.
Hibernation can be chosen as the scaling action for disconnect or logoff for personal host pools. For more details about configuring personal scaling plan, see Create a scaling plan.
These capabilities are available in addition to those released during the public preview, which included the following:
Hibernation can be enabled on existing session host VMs.
Resize is supported for session host VMs with hibernation enabled.
Hibernation support extended to more VM sizes and series.
Getting started
You can enable hibernation when deploying session host VMs for your personal host pools using Azure Portal, PowerShell, CLI, ARM, SDKs, and APIs. You can enable hibernation for existing VMs using PowerShell, CLI, ARM, SDKs, and APIs.
A screenshot of personal host pool Virtual Machines configuration in Azure Virtual Desktop with vTPM and Integrity monitoring, Virtual machine size is set to ’Standard D2as v5’, hibernate is enabled.
To enable hibernation in your scaling plan, you will need to:
Create a personal scaling plan.
Define whether to enable or disable Start VM on Connect.
Choose to perform hibernation after a user session has been disconnected or logged off for a configurable period of time.
Assign a personal scaling plan to one or more personal host pools.
A screenshot of a scaling plan in Azure Virtual Desktop with a schedule of ramp-up is shown as repeating Monday to Friday at 9:00 AM Beijing time, starting VM on Connect. Disconnect settings are set to hibernate at 30 minutes. Log off settings are set to hibernate after 10 minutes.
Helpful resources
We encourage you to learn more about setting up autoscale and review frequently asked questions for more details on how to use hibernation with autoscale for Azure Virtual Desktop personal host pools. You may also find these resources helpful:
Microsoft Mechanics: Automated scaling, imaging & monitoring
Azure Academy: Enabling and managing Personal Desktop Autoscale
Cost Optimization for General Purpose VMs using Hibernation now Generally Available
Microsoft Tech Community – Latest Blogs –Read More
Check if New Desktop addon is used in current session
Is there a way to check programmatically if in the New Desktop is active in the current session (I want to detect this info in a startup file)?Is there a way to check programmatically if in the New Desktop is active in the current session (I want to detect this info in a startup file)? Is there a way to check programmatically if in the New Desktop is active in the current session (I want to detect this info in a startup file)? new desktop, matlab MATLAB Answers — New Questions
Calculating Inductance of parallel DC cables
I am currently doing a short-circuit analysis of a vessel. The vessel has a DC busbar where all the converters are connected to it. Since the inductance value of the cables holds significant importance when analyzing short-circuits I tried to calculate and add inductance & resistance in simscape environment to model these cables. IEC documents give inductance calculations for single core cables. I want to calculate inductance for multiple single core cables or cables with more than 1 core inside. Is there any general approach I can use, or any source that might be helpfull?I am currently doing a short-circuit analysis of a vessel. The vessel has a DC busbar where all the converters are connected to it. Since the inductance value of the cables holds significant importance when analyzing short-circuits I tried to calculate and add inductance & resistance in simscape environment to model these cables. IEC documents give inductance calculations for single core cables. I want to calculate inductance for multiple single core cables or cables with more than 1 core inside. Is there any general approach I can use, or any source that might be helpfull? I am currently doing a short-circuit analysis of a vessel. The vessel has a DC busbar where all the converters are connected to it. Since the inductance value of the cables holds significant importance when analyzing short-circuits I tried to calculate and add inductance & resistance in simscape environment to model these cables. IEC documents give inductance calculations for single core cables. I want to calculate inductance for multiple single core cables or cables with more than 1 core inside. Is there any general approach I can use, or any source that might be helpfull? simscape MATLAB Answers — New Questions
I get this error: Incorrect number or types of inputs or outputs for function ‘phaseShift’ when I try to compile my code.
Hi everyone. Could someone please explain what could be the cause of this error when I use the phaseShift function. Many thanks in advance.
%%Create Variables
clc
clear all
close all
freq = 5.33e9;
c = physconst("lightspeed");
lambda = c/freq;
%%Create pcbStack object
pcbobj = pcbStack;
%%Create board shape
%Creating BoardShape metal layer.
%Creating Rectangle shape.
Rectangle = antenna.Rectangle;
Rectangle.Name = "Rectangle";
Rectangle.Center = [0 0];
Rectangle.Length = 0.02725;
Rectangle.Width = 0.02725;
Rectangle = rotate(Rectangle,0,[Rectangle.Center,-1],[Rectangle.Center,1]);
BoardShape = Rectangle;
pcbobj.BoardShape = BoardShape;
%%Create Stackup
%Creating PatchLayer metal layer.
%Creating Patch shape.
Patch = antenna.Polygon;
Patch.Name = "Patch";
Patch.Vertices = [
-0.00775 0.0064 0;
0.00775 0.0064 0;
0.00775 -0.0064 0;
0.000535 -0.0064 0;
0.000535 -0.0015 0;
0.000375 -0.0015 0;
0.000375 -0.013625 0;
-0.000375 -0.013625 0;
-0.000375 -0.0015 0;
-0.000535 -0.0015 0;
-0.000535 -0.0064 0;
-0.00775 -0.0064 0];
Patch = rotate(Patch,0,[0 -0.00430416666666667 -1],[0 -0.00430416666666667 1]);
PatchLayer = Patch;
%Creating DielectricLayer dielectric layer.
DielectricLayer = dielectric("Name",’Custom’,"EpsilonR",4.66,"LossTangent",0.026,"Thickness",0.0006);
%Creating GroundPlane metal layer.
%Creating Ground shape.
Ground = antenna.Rectangle;
Ground.Name = "Ground";
Ground.Center = [0 0];
Ground.Length = 0.02725;
Ground.Width = 0.02725;
Ground = rotate(Ground,0,[Ground.Center,-1],[Ground.Center,1]);
GroundPlane = Ground;
%%Create Feed
% feedloc = [[0 -0.006237 3 1];…
% ];
feedloc = [[0 -0.0064 3 1];…
];
%%Create Metal
metalobj = metal;
metalobj.Name = ‘Copper’;
metalobj.Conductivity = 5.96e7;
metalobj.Thickness = 35e-6;
pcbobj.Conductor = metalobj;
%%Assign propertie
pcbobj.BoardThickness = 0.00053;
pcbobj.Layers = {PatchLayer,DielectricLayer,GroundPlane,};
pcbobj.FeedLocations = feedloc;
pcbobj.FeedDiameter = 0.00030672;
pcbobj.ViaDiameter = 0.00075;
pcbobj.FeedViaModel = ‘strip’;
pcbobj.FeedVoltage = 1;
pcbobj.FeedPhase = 0;
figure(‘Position’, [100 750 600 500]);
show(pcbobj)
figure(‘Position’, [700 750 600 500]);
pattern(pcbobj,freq)
figure(‘Position’, [1300 750 600 500]);
current(pcbobj,freq)
% antennaArray = rectangularArray;
antennaArray = phased.URA;
antennaArray.Element = pcbobj;
antennaArray.Size = [10 10];
antennaArray.ElementSpacing = lambda/2;
antennaArray.Lattice = "Rectangular";
antennaArray.ArrayNormal = "x";
figure(‘Position’, [100 150 600 500]);
pattern(antennaArray, freq)
pos_rec = getElementPosition(antennaArray);
pos_yx_rec = pos_rec([2,3],:);
figure(‘Position’, [700 150 600 500]);
plot(pos_yx_rec(1,:), pos_yx_rec(2,:), ‘.’, ‘MarkerSize’, 10)
% axis([-0.2 0.2 -0.2 0.2])
xlabel(‘x’); ylabel(‘y’)
title(‘Rectangular Lattice’)
figure(‘Position’, [1300 150 600 500]);
az_angle = -180:0.25:180;
pattern(antennaArray,freq, az_angle, 0, CoordinateSystem="rectangular")
axis([-90 90 -35 25])
ps = phaseShift(antennaArray, freq, [30 45]);Hi everyone. Could someone please explain what could be the cause of this error when I use the phaseShift function. Many thanks in advance.
%%Create Variables
clc
clear all
close all
freq = 5.33e9;
c = physconst("lightspeed");
lambda = c/freq;
%%Create pcbStack object
pcbobj = pcbStack;
%%Create board shape
%Creating BoardShape metal layer.
%Creating Rectangle shape.
Rectangle = antenna.Rectangle;
Rectangle.Name = "Rectangle";
Rectangle.Center = [0 0];
Rectangle.Length = 0.02725;
Rectangle.Width = 0.02725;
Rectangle = rotate(Rectangle,0,[Rectangle.Center,-1],[Rectangle.Center,1]);
BoardShape = Rectangle;
pcbobj.BoardShape = BoardShape;
%%Create Stackup
%Creating PatchLayer metal layer.
%Creating Patch shape.
Patch = antenna.Polygon;
Patch.Name = "Patch";
Patch.Vertices = [
-0.00775 0.0064 0;
0.00775 0.0064 0;
0.00775 -0.0064 0;
0.000535 -0.0064 0;
0.000535 -0.0015 0;
0.000375 -0.0015 0;
0.000375 -0.013625 0;
-0.000375 -0.013625 0;
-0.000375 -0.0015 0;
-0.000535 -0.0015 0;
-0.000535 -0.0064 0;
-0.00775 -0.0064 0];
Patch = rotate(Patch,0,[0 -0.00430416666666667 -1],[0 -0.00430416666666667 1]);
PatchLayer = Patch;
%Creating DielectricLayer dielectric layer.
DielectricLayer = dielectric("Name",’Custom’,"EpsilonR",4.66,"LossTangent",0.026,"Thickness",0.0006);
%Creating GroundPlane metal layer.
%Creating Ground shape.
Ground = antenna.Rectangle;
Ground.Name = "Ground";
Ground.Center = [0 0];
Ground.Length = 0.02725;
Ground.Width = 0.02725;
Ground = rotate(Ground,0,[Ground.Center,-1],[Ground.Center,1]);
GroundPlane = Ground;
%%Create Feed
% feedloc = [[0 -0.006237 3 1];…
% ];
feedloc = [[0 -0.0064 3 1];…
];
%%Create Metal
metalobj = metal;
metalobj.Name = ‘Copper’;
metalobj.Conductivity = 5.96e7;
metalobj.Thickness = 35e-6;
pcbobj.Conductor = metalobj;
%%Assign propertie
pcbobj.BoardThickness = 0.00053;
pcbobj.Layers = {PatchLayer,DielectricLayer,GroundPlane,};
pcbobj.FeedLocations = feedloc;
pcbobj.FeedDiameter = 0.00030672;
pcbobj.ViaDiameter = 0.00075;
pcbobj.FeedViaModel = ‘strip’;
pcbobj.FeedVoltage = 1;
pcbobj.FeedPhase = 0;
figure(‘Position’, [100 750 600 500]);
show(pcbobj)
figure(‘Position’, [700 750 600 500]);
pattern(pcbobj,freq)
figure(‘Position’, [1300 750 600 500]);
current(pcbobj,freq)
% antennaArray = rectangularArray;
antennaArray = phased.URA;
antennaArray.Element = pcbobj;
antennaArray.Size = [10 10];
antennaArray.ElementSpacing = lambda/2;
antennaArray.Lattice = "Rectangular";
antennaArray.ArrayNormal = "x";
figure(‘Position’, [100 150 600 500]);
pattern(antennaArray, freq)
pos_rec = getElementPosition(antennaArray);
pos_yx_rec = pos_rec([2,3],:);
figure(‘Position’, [700 150 600 500]);
plot(pos_yx_rec(1,:), pos_yx_rec(2,:), ‘.’, ‘MarkerSize’, 10)
% axis([-0.2 0.2 -0.2 0.2])
xlabel(‘x’); ylabel(‘y’)
title(‘Rectangular Lattice’)
figure(‘Position’, [1300 150 600 500]);
az_angle = -180:0.25:180;
pattern(antennaArray,freq, az_angle, 0, CoordinateSystem="rectangular")
axis([-90 90 -35 25])
ps = phaseShift(antennaArray, freq, [30 45]); Hi everyone. Could someone please explain what could be the cause of this error when I use the phaseShift function. Many thanks in advance.
%%Create Variables
clc
clear all
close all
freq = 5.33e9;
c = physconst("lightspeed");
lambda = c/freq;
%%Create pcbStack object
pcbobj = pcbStack;
%%Create board shape
%Creating BoardShape metal layer.
%Creating Rectangle shape.
Rectangle = antenna.Rectangle;
Rectangle.Name = "Rectangle";
Rectangle.Center = [0 0];
Rectangle.Length = 0.02725;
Rectangle.Width = 0.02725;
Rectangle = rotate(Rectangle,0,[Rectangle.Center,-1],[Rectangle.Center,1]);
BoardShape = Rectangle;
pcbobj.BoardShape = BoardShape;
%%Create Stackup
%Creating PatchLayer metal layer.
%Creating Patch shape.
Patch = antenna.Polygon;
Patch.Name = "Patch";
Patch.Vertices = [
-0.00775 0.0064 0;
0.00775 0.0064 0;
0.00775 -0.0064 0;
0.000535 -0.0064 0;
0.000535 -0.0015 0;
0.000375 -0.0015 0;
0.000375 -0.013625 0;
-0.000375 -0.013625 0;
-0.000375 -0.0015 0;
-0.000535 -0.0015 0;
-0.000535 -0.0064 0;
-0.00775 -0.0064 0];
Patch = rotate(Patch,0,[0 -0.00430416666666667 -1],[0 -0.00430416666666667 1]);
PatchLayer = Patch;
%Creating DielectricLayer dielectric layer.
DielectricLayer = dielectric("Name",’Custom’,"EpsilonR",4.66,"LossTangent",0.026,"Thickness",0.0006);
%Creating GroundPlane metal layer.
%Creating Ground shape.
Ground = antenna.Rectangle;
Ground.Name = "Ground";
Ground.Center = [0 0];
Ground.Length = 0.02725;
Ground.Width = 0.02725;
Ground = rotate(Ground,0,[Ground.Center,-1],[Ground.Center,1]);
GroundPlane = Ground;
%%Create Feed
% feedloc = [[0 -0.006237 3 1];…
% ];
feedloc = [[0 -0.0064 3 1];…
];
%%Create Metal
metalobj = metal;
metalobj.Name = ‘Copper’;
metalobj.Conductivity = 5.96e7;
metalobj.Thickness = 35e-6;
pcbobj.Conductor = metalobj;
%%Assign propertie
pcbobj.BoardThickness = 0.00053;
pcbobj.Layers = {PatchLayer,DielectricLayer,GroundPlane,};
pcbobj.FeedLocations = feedloc;
pcbobj.FeedDiameter = 0.00030672;
pcbobj.ViaDiameter = 0.00075;
pcbobj.FeedViaModel = ‘strip’;
pcbobj.FeedVoltage = 1;
pcbobj.FeedPhase = 0;
figure(‘Position’, [100 750 600 500]);
show(pcbobj)
figure(‘Position’, [700 750 600 500]);
pattern(pcbobj,freq)
figure(‘Position’, [1300 750 600 500]);
current(pcbobj,freq)
% antennaArray = rectangularArray;
antennaArray = phased.URA;
antennaArray.Element = pcbobj;
antennaArray.Size = [10 10];
antennaArray.ElementSpacing = lambda/2;
antennaArray.Lattice = "Rectangular";
antennaArray.ArrayNormal = "x";
figure(‘Position’, [100 150 600 500]);
pattern(antennaArray, freq)
pos_rec = getElementPosition(antennaArray);
pos_yx_rec = pos_rec([2,3],:);
figure(‘Position’, [700 150 600 500]);
plot(pos_yx_rec(1,:), pos_yx_rec(2,:), ‘.’, ‘MarkerSize’, 10)
% axis([-0.2 0.2 -0.2 0.2])
xlabel(‘x’); ylabel(‘y’)
title(‘Rectangular Lattice’)
figure(‘Position’, [1300 150 600 500]);
az_angle = -180:0.25:180;
pattern(antennaArray,freq, az_angle, 0, CoordinateSystem="rectangular")
axis([-90 90 -35 25])
ps = phaseShift(antennaArray, freq, [30 45]); phaseshift MATLAB Answers — New Questions
Mex error while running a code matlab 2021a
Hi, i’m new to matlab so i can’t figure out where the error is. Could somone tell me how I can rectify it
I’m using this code which sombody had already made.
Thanks in advance
function Create_Data()
% This function creates the model data depicted in Figure 4-6 of
%
% Characterization of K-Complexes and Slow Wave Activity in a Neural Mass Model
% A Weigenand, M Schellenberger Costa, H-VV Ngo, JC Claussen, T Martinetz
% PLoS Computational Biology. 2014;10:e1003923
% Move to source folder(assuming it contains the Figures folder
cd ..;
% Check if the executable exists and compile if needed
if(exist(‘Cortex_mex.mesa64’, ‘file’)==0)
mex CXXFLAGS="$CXXFLAGS -std=c++11 -O3" Cortex_mex.cpp Cortical_Column.cpp;
end
% Add the path to the simulation routine
addpath(pwd);
% Go back into figures folder
cd Figures;
% Time series
Data_Time_Series(1);
Data_Time_Series(2);
% Time series
Data_Stimulation();
end
First I got this error
>> Create_Data
Building with ‘MinGW64 Compiler (C++)’.
Error using mex
g++: error: -fexceptions: No such file or directory
So, I put D:MatlabFilescortex_mex.cpp
>> D:MatlabFilescortex_mex.cpp
D:MatlabFilescortex_mex.cpp
↑
Invalid use of operator.
But it still said thisHi, i’m new to matlab so i can’t figure out where the error is. Could somone tell me how I can rectify it
I’m using this code which sombody had already made.
Thanks in advance
function Create_Data()
% This function creates the model data depicted in Figure 4-6 of
%
% Characterization of K-Complexes and Slow Wave Activity in a Neural Mass Model
% A Weigenand, M Schellenberger Costa, H-VV Ngo, JC Claussen, T Martinetz
% PLoS Computational Biology. 2014;10:e1003923
% Move to source folder(assuming it contains the Figures folder
cd ..;
% Check if the executable exists and compile if needed
if(exist(‘Cortex_mex.mesa64’, ‘file’)==0)
mex CXXFLAGS="$CXXFLAGS -std=c++11 -O3" Cortex_mex.cpp Cortical_Column.cpp;
end
% Add the path to the simulation routine
addpath(pwd);
% Go back into figures folder
cd Figures;
% Time series
Data_Time_Series(1);
Data_Time_Series(2);
% Time series
Data_Stimulation();
end
First I got this error
>> Create_Data
Building with ‘MinGW64 Compiler (C++)’.
Error using mex
g++: error: -fexceptions: No such file or directory
So, I put D:MatlabFilescortex_mex.cpp
>> D:MatlabFilescortex_mex.cpp
D:MatlabFilescortex_mex.cpp
↑
Invalid use of operator.
But it still said this Hi, i’m new to matlab so i can’t figure out where the error is. Could somone tell me how I can rectify it
I’m using this code which sombody had already made.
Thanks in advance
function Create_Data()
% This function creates the model data depicted in Figure 4-6 of
%
% Characterization of K-Complexes and Slow Wave Activity in a Neural Mass Model
% A Weigenand, M Schellenberger Costa, H-VV Ngo, JC Claussen, T Martinetz
% PLoS Computational Biology. 2014;10:e1003923
% Move to source folder(assuming it contains the Figures folder
cd ..;
% Check if the executable exists and compile if needed
if(exist(‘Cortex_mex.mesa64’, ‘file’)==0)
mex CXXFLAGS="$CXXFLAGS -std=c++11 -O3" Cortex_mex.cpp Cortical_Column.cpp;
end
% Add the path to the simulation routine
addpath(pwd);
% Go back into figures folder
cd Figures;
% Time series
Data_Time_Series(1);
Data_Time_Series(2);
% Time series
Data_Stimulation();
end
First I got this error
>> Create_Data
Building with ‘MinGW64 Compiler (C++)’.
Error using mex
g++: error: -fexceptions: No such file or directory
So, I put D:MatlabFilescortex_mex.cpp
>> D:MatlabFilescortex_mex.cpp
D:MatlabFilescortex_mex.cpp
↑
Invalid use of operator.
But it still said this mex compiler, mex error MATLAB Answers — New Questions
Defender For Endpoint MacOS Scheduled Scan documentation error
Hi everybody!
First post here so I hope it goes to the right place. I´m configuring Defender for Endpoint on MacOS scheduled scans and found out that the examples in the documentation have errors. I got the “XML must be well formed” error and noticed that there were some end tags missing.
There is an error in the example XML files: How to schedule scans with Microsoft Defender for Endpoint on macOS – Microsoft Defender for Endpoint | Microsoft Learn
If anyone else is banging their head on the wall. The fix is to add end tag to the “array” part and a few “dict” end tags.
Hi everybody! First post here so I hope it goes to the right place. I´m configuring Defender for Endpoint on MacOS scheduled scans and found out that the examples in the documentation have errors. I got the “XML must be well formed” error and noticed that there were some end tags missing. There is an error in the example XML files: How to schedule scans with Microsoft Defender for Endpoint on macOS – Microsoft Defender for Endpoint | Microsoft Learn If anyone else is banging their head on the wall. The fix is to add end tag to the “array” part and a few “dict” end tags. Read More
Error after windows server update
Receiving error after installing updates – KB 5027283
System.InvalidOperationException: Operation is not valid due to the current state of the object.
Some site collections work and central admin works.
The updates ran successfully, SharePoint wizard ran successfully after updates, rebooted. Single server set up.
Anyone have any idea what’s wrong?
Receiving error after installing updates – KB 5027283 System.InvalidOperationException: Operation is not valid due to the current state of the object. Some site collections work and central admin works.The updates ran successfully, SharePoint wizard ran successfully after updates, rebooted. Single server set up.Anyone have any idea what’s wrong? Read More
Individuals Content in rows to two columns
I need to pull only names and emails from these rows (each person has 25 rows) and transverse them into two columns to just have the name and emails listed. Any ideas?
I need to pull only names and emails from these rows (each person has 25 rows) and transverse them into two columns to just have the name and emails listed. Any ideas? Read More
Will people I temporarily call into a teams meeting have access to the transcript after they leave?
Wondering if people who are called into a meeting temporarily (e.g. to present on a topic) will have access to the transcript. They are not invited to the meeting, just called in when needed. I know I can cancel them from the chat after they leave, but if I don’t do this will they still have access to the transcript after they leave? It’s a concern as discussions following their departure from the meeting may be confidential.
Wondering if people who are called into a meeting temporarily (e.g. to present on a topic) will have access to the transcript. They are not invited to the meeting, just called in when needed. I know I can cancel them from the chat after they leave, but if I don’t do this will they still have access to the transcript after they leave? It’s a concern as discussions following their departure from the meeting may be confidential. Read More
Disable Copilot on Mac
How do I disable Copilot on my Macbook Pro? I absolutely detest it.
How do I disable Copilot on my Macbook Pro? I absolutely detest it. Read More
Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. We know that uniqueidentifier store globally unique identifiers (GUIDs). GUIDs are widely used for unique keys due to their extremely low probability of duplication. One common method to generate a GUID in SQL Server is by using the NEWID() function. However, the ordering of GUIDs, especially those generated by NEWID(), can appear non-intuitive. I would like to share my lessons learned how to determine the ordering method using uniqueidentifier and NEWID().
We know that a GUID is a 16-byte value typically represented in a standard format of 32 hexadecimal characters separated by hyphens, for example, EB37F277-8A16-4DE3-B1E3-FFFCBA956A82.
Each section represents different parts of the GUID:
The first 8 characters (4 bytes)
The next 4 characters (2 bytes)
The following 4 characters (2 bytes)
The next 4 characters (2 bytes)
The final 12 characters (6 bytes)
When we generated a NEWID() function generates a random GUID. This randomness ensures uniqueness but can lead to seemingly arbitrary ordering when GUIDs are compared and sorted. The comparison is done byte-by-byte from left to right in lexicographical order.
Consider the following GUIDs generated by NEWID():
C2EB258A-147F-4F26-97D7-0000F053CCA8
6682BC4F-949E-478F-BBA2-0003C71CD035
A6D423B8-07F3-4F13-B34E-0004DC3317B7
EE2C394E-7AB0-468F-B959-0005C0CC598D
How the ordering works:
To understand how SQL Server orders these GUIDs, we need to break them down into their binary components and compare each part:
C2EB258A-147F-4F26-97D7-0000F053CCA8
Binary: C2 EB 25 8A 14 7F 4F 26 97 D7 00 00 F0 53 CC A8
6682BC4F-949E-478F-BBA2-0003C71CD035
Binary: 66 82 BC 4F 94 9E 47 8F BB A2 00 03 C7 1C D0 35
A6D423B8-07F3-4F13-B34E-0004DC3317B7
Binary: A6 D4 23 B8 07 F3 4F 13 B3 4E 00 04 DC 33 17 B7
EE2C394E-7AB0-468F-B959-0005C0CC598D
Binary: EE 2C 39 4E 7A B0 46 8F B9 59 00 05 C0 CC 59 8D
When these GUIDs are ordered, SQL Server compares each byte in sequence. The final sorted order is:
6682BC4F-949E-478F-BBA2-0003C71CD035
A6D423B8-07F3-4F13-B34E-0004DC3317B7
C2EB258A-147F-4F26-97D7-0000F053CCA8
EE2C394E-7AB0-468F-B959-0005C0CC598D
To better understand and work with GUIDs, you can create SQL functions that decompose GUIDs into their components and show their ordering. To understand how the GUID is decomposed I would like to share this function.
CREATE FUNCTION dbo.DescomponerGUIDString (@guid UNIQUEIDENTIFIER)
RETURNS NVARCHAR(100)
AS
BEGIN
DECLARE @part1 NVARCHAR(8) = CONVERT(NVARCHAR(8), SUBSTRING(CONVERT(BINARY(16), @guid), 1, 4), 2);
DECLARE @part2 NVARCHAR(4) = CONVERT(NVARCHAR(4), SUBSTRING(CONVERT(BINARY(16), @guid), 5, 2), 2);
DECLARE @part3 NVARCHAR(4) = CONVERT(NVARCHAR(4), SUBSTRING(CONVERT(BINARY(16), @guid), 7, 2), 2);
DECLARE @part4 NVARCHAR(4) = CONVERT(NVARCHAR(4), SUBSTRING(CONVERT(BINARY(16), @guid), 9, 2), 2);
DECLARE @part5 NVARCHAR(12) = CONVERT(NVARCHAR(12), SUBSTRING(CONVERT(BINARY(16), @guid), 11, 6), 2);
RETURN @part1 + ‘-‘ + @part2 + ‘-‘ + @part3 + ‘-‘ + @part4 + ‘-‘ + @part5;
END;
For example, we have this table and we are going to sort using the [Guid No_] column with NewID().
select [GUID No_], dbo.DescomponerGUIDString([GUID No_]) as x from dbo.ExampleTable
ORDER BY 1
For example, we have this table and we are going to sort using the sorted calculation column with NewID().
select [GUID No_], dbo.DescomponerGUIDString([GUID No_]) as x from dbo.ExampleTable
ORDER BY 2
Microsoft Tech Community – Latest Blogs –Read More
Protected model fails to build
Hello,
I have created a simulink model which implements an inlined s-function which uses a .tlc file and external .c and.h files. I have configured everything correctly as the simulation is working, and when I perform a compile this also goes without issues.
However, when a try to save te model as a protected model the compilation fails as it cannot fild the external .c and .h files. Event hough i have configured it correctly under "custom code" in the model settings.
I would expect that saving it as a protected model would also use these settings, but it does not seem to be the case. What am i dowing wrong?Hello,
I have created a simulink model which implements an inlined s-function which uses a .tlc file and external .c and.h files. I have configured everything correctly as the simulation is working, and when I perform a compile this also goes without issues.
However, when a try to save te model as a protected model the compilation fails as it cannot fild the external .c and .h files. Event hough i have configured it correctly under "custom code" in the model settings.
I would expect that saving it as a protected model would also use these settings, but it does not seem to be the case. What am i dowing wrong? Hello,
I have created a simulink model which implements an inlined s-function which uses a .tlc file and external .c and.h files. I have configured everything correctly as the simulation is working, and when I perform a compile this also goes without issues.
However, when a try to save te model as a protected model the compilation fails as it cannot fild the external .c and .h files. Event hough i have configured it correctly under "custom code" in the model settings.
I would expect that saving it as a protected model would also use these settings, but it does not seem to be the case. What am i dowing wrong? protected model, simulink MATLAB Answers — New Questions
Can we use custom markers to plot trajectory
Is there a way I can use a figure as custom marker to represent the trajectory of an unamanned aerial system. I also need it to represent the orientation of the UAS at any point on the trajectory.
I have attached examples that I found in some papers.Is there a way I can use a figure as custom marker to represent the trajectory of an unamanned aerial system. I also need it to represent the orientation of the UAS at any point on the trajectory.
I have attached examples that I found in some papers. Is there a way I can use a figure as custom marker to represent the trajectory of an unamanned aerial system. I also need it to represent the orientation of the UAS at any point on the trajectory.
I have attached examples that I found in some papers. figure, plot, plotting MATLAB Answers — New Questions
How to connect simpowersystem generic battery with simscape blocks and solve algebraic loop er?
Hello,
I’m new to Matlab-Simulink. I cannot directly connect the generic battery block to the simelectronics blocks in the model. To achieve this, I first connected the voltage measurement block to the generic battery terminals, and then its output signal to the controlled voltage sensor block. However, the voltage I receive this way is the initial voltage value of the generic battery and does not decrease over time depending on the load. To ensure this voltage decrease, I connected a controlled current source as a load to the generic battery. I connected the signal I received from the current sensor on the Simscape side to the input of the current source. But this gave the following algebraic loop error.
Is there a different way to connect the generic battery block to the simscape blocks without getting an algebraic loop error?
Thanks for any help.
Best Regards
Block diagram ‘DronePropellerMotorBattery_v5’ contains 1 algebraic loop(s). To see more details about the loops use the command Simulink.BlockDiagram.getAlgebraicLoops(‘DronePropellerMotorBattery_v5’) or the command line Simulink debugger by typing sldebug(‘DronePropellerMotorBattery_v5’) in the MATLAB command window. To eliminate this message, set Algebraic loop to "none".
Component:Simulink | Category:Block diagram warning
Found algebraic loop containing: DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/INPUT_1_1_1DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/STATE_1 (discontinuity) DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/OUTPUT_1_0DronePropellerMotorBattery_v5/powergui/EquivalentModel1/State-SpaceDronePropellerMotorBattery_v5/Voltage Measurement/do not delete this gain (algebraic variable)
Component:Simulink | Category:Model
Discontinuities detected within algebraic loop(s), may have trouble solving
Component:Simulink | Category:Model warning
Convergence problem when solving algebraic loop containing ‘DronePropellerMotorBattery_v5/Solver Configuration’ at time 0.0. Simulink will try to solve this loop using Simulink 3 (R11) strategy. Use feature(‘ModeIterationsInAlgLoops’,0) to disable the strategy introduced in Simulink 4 (R12)
Component:Simulink | Category:Block warning
Solver is encountering difficulty in simulating model ‘DronePropellerMotorBattery_v5’ at time 1.1125369292536007e-308. Simulink will continue to simulate with warnings. Please check the model for errors.
Caused by:
Solver was unable to reduce the step size without violating the minimum step size value of 2.22507E-308 for 1 consecutive times at time 0. This usually may be caused by violating algebraic constraints in the differential-algebraic system or by the high stiffness of the system. Try tightening the error tolerances, and/or the tolerances for computing consistent conditions. If the problem persists, please check the system or increase the solver Number of consecutive min steps violation parameter.
Suggested Actions
Open Solver Profiler to explore such issuesOpen
Component:Simulink | Category:Block diagram warning
An error occurred during simulation and the simulation was terminated
Caused by:
Algebraic state in algebraic loop containing ‘DronePropellerMotorBattery_v5/Voltage Measurement/do not delete this gain’ computed at time 2.2250738585072014E-308 is Inf or NaN. There may be a singularity in the solution. If the model is correct, try reducing the step size (either by reducing the fixed step size or by tightening the error tolerances) or tweak the initial guess of algebraic loop variable values.Hello,
I’m new to Matlab-Simulink. I cannot directly connect the generic battery block to the simelectronics blocks in the model. To achieve this, I first connected the voltage measurement block to the generic battery terminals, and then its output signal to the controlled voltage sensor block. However, the voltage I receive this way is the initial voltage value of the generic battery and does not decrease over time depending on the load. To ensure this voltage decrease, I connected a controlled current source as a load to the generic battery. I connected the signal I received from the current sensor on the Simscape side to the input of the current source. But this gave the following algebraic loop error.
Is there a different way to connect the generic battery block to the simscape blocks without getting an algebraic loop error?
Thanks for any help.
Best Regards
Block diagram ‘DronePropellerMotorBattery_v5’ contains 1 algebraic loop(s). To see more details about the loops use the command Simulink.BlockDiagram.getAlgebraicLoops(‘DronePropellerMotorBattery_v5’) or the command line Simulink debugger by typing sldebug(‘DronePropellerMotorBattery_v5’) in the MATLAB command window. To eliminate this message, set Algebraic loop to "none".
Component:Simulink | Category:Block diagram warning
Found algebraic loop containing: DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/INPUT_1_1_1DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/STATE_1 (discontinuity) DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/OUTPUT_1_0DronePropellerMotorBattery_v5/powergui/EquivalentModel1/State-SpaceDronePropellerMotorBattery_v5/Voltage Measurement/do not delete this gain (algebraic variable)
Component:Simulink | Category:Model
Discontinuities detected within algebraic loop(s), may have trouble solving
Component:Simulink | Category:Model warning
Convergence problem when solving algebraic loop containing ‘DronePropellerMotorBattery_v5/Solver Configuration’ at time 0.0. Simulink will try to solve this loop using Simulink 3 (R11) strategy. Use feature(‘ModeIterationsInAlgLoops’,0) to disable the strategy introduced in Simulink 4 (R12)
Component:Simulink | Category:Block warning
Solver is encountering difficulty in simulating model ‘DronePropellerMotorBattery_v5’ at time 1.1125369292536007e-308. Simulink will continue to simulate with warnings. Please check the model for errors.
Caused by:
Solver was unable to reduce the step size without violating the minimum step size value of 2.22507E-308 for 1 consecutive times at time 0. This usually may be caused by violating algebraic constraints in the differential-algebraic system or by the high stiffness of the system. Try tightening the error tolerances, and/or the tolerances for computing consistent conditions. If the problem persists, please check the system or increase the solver Number of consecutive min steps violation parameter.
Suggested Actions
Open Solver Profiler to explore such issuesOpen
Component:Simulink | Category:Block diagram warning
An error occurred during simulation and the simulation was terminated
Caused by:
Algebraic state in algebraic loop containing ‘DronePropellerMotorBattery_v5/Voltage Measurement/do not delete this gain’ computed at time 2.2250738585072014E-308 is Inf or NaN. There may be a singularity in the solution. If the model is correct, try reducing the step size (either by reducing the fixed step size or by tightening the error tolerances) or tweak the initial guess of algebraic loop variable values. Hello,
I’m new to Matlab-Simulink. I cannot directly connect the generic battery block to the simelectronics blocks in the model. To achieve this, I first connected the voltage measurement block to the generic battery terminals, and then its output signal to the controlled voltage sensor block. However, the voltage I receive this way is the initial voltage value of the generic battery and does not decrease over time depending on the load. To ensure this voltage decrease, I connected a controlled current source as a load to the generic battery. I connected the signal I received from the current sensor on the Simscape side to the input of the current source. But this gave the following algebraic loop error.
Is there a different way to connect the generic battery block to the simscape blocks without getting an algebraic loop error?
Thanks for any help.
Best Regards
Block diagram ‘DronePropellerMotorBattery_v5’ contains 1 algebraic loop(s). To see more details about the loops use the command Simulink.BlockDiagram.getAlgebraicLoops(‘DronePropellerMotorBattery_v5’) or the command line Simulink debugger by typing sldebug(‘DronePropellerMotorBattery_v5’) in the MATLAB command window. To eliminate this message, set Algebraic loop to "none".
Component:Simulink | Category:Block diagram warning
Found algebraic loop containing: DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/INPUT_1_1_1DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/STATE_1 (discontinuity) DronePropellerMotorBattery_v5/Solver Configuration/EVAL_KEY/OUTPUT_1_0DronePropellerMotorBattery_v5/powergui/EquivalentModel1/State-SpaceDronePropellerMotorBattery_v5/Voltage Measurement/do not delete this gain (algebraic variable)
Component:Simulink | Category:Model
Discontinuities detected within algebraic loop(s), may have trouble solving
Component:Simulink | Category:Model warning
Convergence problem when solving algebraic loop containing ‘DronePropellerMotorBattery_v5/Solver Configuration’ at time 0.0. Simulink will try to solve this loop using Simulink 3 (R11) strategy. Use feature(‘ModeIterationsInAlgLoops’,0) to disable the strategy introduced in Simulink 4 (R12)
Component:Simulink | Category:Block warning
Solver is encountering difficulty in simulating model ‘DronePropellerMotorBattery_v5’ at time 1.1125369292536007e-308. Simulink will continue to simulate with warnings. Please check the model for errors.
Caused by:
Solver was unable to reduce the step size without violating the minimum step size value of 2.22507E-308 for 1 consecutive times at time 0. This usually may be caused by violating algebraic constraints in the differential-algebraic system or by the high stiffness of the system. Try tightening the error tolerances, and/or the tolerances for computing consistent conditions. If the problem persists, please check the system or increase the solver Number of consecutive min steps violation parameter.
Suggested Actions
Open Solver Profiler to explore such issuesOpen
Component:Simulink | Category:Block diagram warning
An error occurred during simulation and the simulation was terminated
Caused by:
Algebraic state in algebraic loop containing ‘DronePropellerMotorBattery_v5/Voltage Measurement/do not delete this gain’ computed at time 2.2250738585072014E-308 is Inf or NaN. There may be a singularity in the solution. If the model is correct, try reducing the step size (either by reducing the fixed step size or by tightening the error tolerances) or tweak the initial guess of algebraic loop variable values. simulink, model, simscape, simpowersystems MATLAB Answers — New Questions
how to model a varying load in Simulink using specialized power system library in single phase
Hello, I’m modelling a Full-Active Hybrid Energy Storage System in Simulink using specialized power system library, For getting proper results, i need a varying load. The varying load prsent in this library is in 3-phase.. I need a single phase varying load. Can anyone help?Hello, I’m modelling a Full-Active Hybrid Energy Storage System in Simulink using specialized power system library, For getting proper results, i need a varying load. The varying load prsent in this library is in 3-phase.. I need a single phase varying load. Can anyone help? Hello, I’m modelling a Full-Active Hybrid Energy Storage System in Simulink using specialized power system library, For getting proper results, i need a varying load. The varying load prsent in this library is in 3-phase.. I need a single phase varying load. Can anyone help? simulink, simpowersystems, load MATLAB Answers — New Questions
MS Project Online API to read calendar information
Hi,
I’m trying to retrieve calendar details from MS Project Online using a calendar ID.
I’m currently using this endpoint to get the calendar information:
https://<sitecollection>/<site>/pwa/_api/ProjectServer/Calendars(‘calendarid’)
However, this endpoint does not provide information about holidays and working days in a week.
Is there an API that can fetch all this data?
Thank you.
Hi,I’m trying to retrieve calendar details from MS Project Online using a calendar ID.I’m currently using this endpoint to get the calendar information:https://<sitecollection>/<site>/pwa/_api/ProjectServer/Calendars(‘calendarid’)However, this endpoint does not provide information about holidays and working days in a week.Is there an API that can fetch all this data?Thank you. Read More
Conditional Formatting 3 Colour options
Has anyone any guidance on how I can use Conditional formatting to do the following:
Compare a value in a cell to another cell and provide a red amber green fill based on being greater than, Equal to or lower than the cell it is compared to. I want to do this to a range of cells where the value may be different in each cell and is being compared to a different cell in eache instance (example below:
Reference cell – 3 4 5 3 5 3 4
Value – 3 5 4 2 5 5 7
Fill Colour – A R G G A R R
The only was I have foud to do this so far is 3 conditional formatting formulas per cell (using formula for < = >) and I then cant copy all 3 rules to the other cells as the cell references are fixed ($B$3)
Thanks
Has anyone any guidance on how I can use Conditional formatting to do the following: Compare a value in a cell to another cell and provide a red amber green fill based on being greater than, Equal to or lower than the cell it is compared to. I want to do this to a range of cells where the value may be different in each cell and is being compared to a different cell in eache instance (example below: Reference cell – 3 4 5 3 5 3 4 Value – 3 5 4 2 5 5 7 Fill Colour – A R G G A R R The only was I have foud to do this so far is 3 conditional formatting formulas per cell (using formula for < = >) and I then cant copy all 3 rules to the other cells as the cell references are fixed ($B$3) Thanks Read More
Allow password change only on VPN
Hey guys,
currently I’m supporting a customer who got a lot of remote workers which are not often in the office. I realized that there are a lot of password issues. The cloud journey of the customer just has begun. So there is a hybrid, but Intune is not a topic yet. They have SSPR activated, and the users use different option to change their passwords, either with Ctrl + Alt + Del or directly via MySecurityInfo. Unfortunately this leads to having two passwords, if the clients are not connected to VPN. So a resetted password would effect M365 services and On-Premises infrastructure, but not the password of the local device, because this one would keep the cached device password while not having connection to local AD.
For sure you can solve this with an operational order and just tell the users that they should only change their password while being on VPN, but I would prefer to manage this with a technical solution.
One idea would be to remove the password change feature for Ctrl + Alt + Del (hopefully via GPO) and add a Conditional Access policy which should only allow the SSPR while being on VPN. It’s just my personal brainstorming.
Is this feasible, or how would you deal with this, if your device are not directly joined to Entra?
Thanks in advance.
Hey guys,currently I’m supporting a customer who got a lot of remote workers which are not often in the office. I realized that there are a lot of password issues. The cloud journey of the customer just has begun. So there is a hybrid, but Intune is not a topic yet. They have SSPR activated, and the users use different option to change their passwords, either with Ctrl + Alt + Del or directly via MySecurityInfo. Unfortunately this leads to having two passwords, if the clients are not connected to VPN. So a resetted password would effect M365 services and On-Premises infrastructure, but not the password of the local device, because this one would keep the cached device password while not having connection to local AD. For sure you can solve this with an operational order and just tell the users that they should only change their password while being on VPN, but I would prefer to manage this with a technical solution.One idea would be to remove the password change feature for Ctrl + Alt + Del (hopefully via GPO) and add a Conditional Access policy which should only allow the SSPR while being on VPN. It’s just my personal brainstorming.Is this feasible, or how would you deal with this, if your device are not directly joined to Entra? Thanks in advance. Read More
highlight cells in a column, based on values in another sheet
Hi, i have a worksheet, one sheet (“Tracker”) has a row in column E with numbers that i would like to match in a seperate sheet called “Palletainer Lookup” whereby anything that matches any numbers from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E.
i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula !
Hi, i have a worksheet, one sheet (“Tracker”) has a row in column E with numbers that i would like to match in a seperate sheet called “Palletainer Lookup” whereby anything that matches any numbers from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E. i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula ! Read More
