Category: News
Microsoft Causes Fuss Around Azure MFA Announcement
On May 14, Microsoft announced that they will require Azure MFA for connections to services starting in July 2024. No details about the implementation are available, so it’s difficult to measure the likely impact on Microsoft 365 tenants. Given that very few people access services like the Azure portal, it’s probable that the impact will not be large, but it would be nice to hear more precise details from Microsoft.
https://office365itpros.com/2024/05/17/azure-mfa-july-2024/
On May 14, Microsoft announced that they will require Azure MFA for connections to services starting in July 2024. No details about the implementation are available, so it’s difficult to measure the likely impact on Microsoft 365 tenants. Given that very few people access services like the Azure portal, it’s probable that the impact will not be large, but it would be nice to hear more precise details from Microsoft.
https://office365itpros.com/2024/05/17/azure-mfa-july-2024/ Read More
Cell Referencing not Autofilling Correctly
Hello, I’m having some trouble autofilling some referenced cells from another sheet. I would like to have the column letter continue its sequence but I want the row number to stay the same (ex. a11, b11, c11, etc.). I have inserted a $ symbol before the number so it stays the same, but the letter doesn’t continue its sequence even without the $ symbol in front of it. Here are a couple of screen shots to hopefully help with this problem:
Here is what my formula looks like before I drag it down to autofill it.
Here is what it looks like after I drag it down:
The formula just stays the same for each cell. The letter doesn’t change and the number stays the same (=TPT!TX$11). I would like it to continue like this: (=TPT!TU$11, =TPT!TV$11, =TPT!TW$11, etc.). I can manually change each cell, but it can be very tedious. Any help with this would be greatly appreciated. Thanks!
Hello, I’m having some trouble autofilling some referenced cells from another sheet. I would like to have the column letter continue its sequence but I want the row number to stay the same (ex. a11, b11, c11, etc.). I have inserted a $ symbol before the number so it stays the same, but the letter doesn’t continue its sequence even without the $ symbol in front of it. Here are a couple of screen shots to hopefully help with this problem: Here is what my formula looks like before I drag it down to autofill it. Here is what it looks like after I drag it down:The formula just stays the same for each cell. The letter doesn’t change and the number stays the same (=TPT!TX$11). I would like it to continue like this: (=TPT!TU$11, =TPT!TV$11, =TPT!TW$11, etc.). I can manually change each cell, but it can be very tedious. Any help with this would be greatly appreciated. Thanks! Read More
Lesson Learned #489:Investigating CPU Spikes with Query Store Overall Resource Consumption Report
Yesterday, I worked on a customer who experienced a CPU spike that went 90% during the timeframe of 19:00 to 21:00. I would like to share how we identified the queries that potentially caused this CPU spike using the Query Store’s Overall Resource Consumption report.
First, we accessed the Query Store feature in SQL Server Management Studio (SSMS). Query Store provides detailed insights into query performance and resource consumption, making it an invaluable tool for troubleshooting performance issues.
We configured the report to display key metrics that could indicate the cause of the CPU spike. Specifically, we selected:
Execution Count: To see how frequently queries were executed.
CPU Time: To identify queries consuming significant CPU resources.
Degree of Parallelism (DOP): To check if high parallelism might be contributing to the CPU load.
Upon analyzing the report, we observed that there was indeed a significant CPU spike during the 19:00 to 21:00 window. The execution count and DOP also showed notable increases during this period.
With the list of potential culprit queries, we proceeded to:
Review the execution plans to identify inefficiencies.
Check for missing or outdated indexes.
Analyze the query logic for potential optimizations.
Consider adjusting the DOP for heavily parallelized queries.
By systematically using Query Store’s Overall Resource Consumption report, we were able to pinpoint and analyze the queries causing the high CPU usage. This approach not only helps in resolving the immediate issue but also aids in proactive performance tuning to prevent future occurrences.
Enjoy!
Microsoft Tech Community – Latest Blogs –Read More
How to Fix Reconciliation Discrepancies in QuickBooks Desktop?
I’m encountering problems while reconciling accounts in QuickBooks Desktop. Despite my efforts, I can’t seem to get my accounts to reconcile properly. How can I troubleshoot this issue and ensure accurate reconciliations?
I’m encountering problems while reconciling accounts in QuickBooks Desktop. Despite my efforts, I can’t seem to get my accounts to reconcile properly. How can I troubleshoot this issue and ensure accurate reconciliations? Read More
How to Reconcile an Account in QuickBooks Desktop?
I’m having trouble reconciling an account in QuickBooks Desktop. The reconciliation process isn’t matching up with my bank statements, and I’m unsure how to fix this. Can you provide detailed troubleshooting steps to help resolve this issue?
I’m having trouble reconciling an account in QuickBooks Desktop. The reconciliation process isn’t matching up with my bank statements, and I’m unsure how to fix this. Can you provide detailed troubleshooting steps to help resolve this issue? Read More
AZ-400 exam – How difficult it is and what to study?
For those who have taken the AZ-400 exam, how did you find the difficulty level and what areas should I focus on the most?
For those who have taken the AZ-400 exam, how did you find the difficulty level and what areas should I focus on the most? Read More
How to Fix QuickBooks Payroll Tax Not Working After Update 2024?
After updating QuickBooks to the 2024 version, my payroll tax calculations are not working correctly. It’s causing issues with my payroll processing. How can I fix this problem and ensure accurate payroll tax calculations?
After updating QuickBooks to the 2024 version, my payroll tax calculations are not working correctly. It’s causing issues with my payroll processing. How can I fix this problem and ensure accurate payroll tax calculations? Read More
How to see where Connectors are used in SharePoint online
Morning,
So have just read MC793656 in the Message Centre of my companies tenant advising the retirement of 365 connects from SharePoint Online (SPO) webparts, but I cannot find any method on how to check if any of the sites on my companies tenant are using this, anyone know how this can be checked as I have over 9,000 sites on the tenant?
Morning,So have just read MC793656 in the Message Centre of my companies tenant advising the retirement of 365 connects from SharePoint Online (SPO) webparts, but I cannot find any method on how to check if any of the sites on my companies tenant are using this, anyone know how this can be checked as I have over 9,000 sites on the tenant? Read More
Error in Trying to Build a Custom Variable Resistor In MATLAB Simulink
Hey everyone, I’m in the process of trying to build a custom variable resistor using simulink. I created a code for a simscape component in MATLAB but it’s giving me an error saying "Invalid use of a MATLAB function in This Context" when I try inserting the simscape component in simulink. Shown below is my code:
The error happens on line 26 (the equation with variable R). Are there any tips or suggestions to fix my error?
component VoltageDependentResistor
% Voltage-dependent resistor
% This resistor’s value changes based on the voltage across it.
nodes
p = foundation.electrical.electrical; % positive terminal
n = foundation.electrical.electrical; % negative terminal
end
parameters
alpha = {1, ‘1/V’}; % Coefficient for voltage dependence
epsilon = 0.6;
sigma = 5.67E-8
end
variables
v = { 0, ‘V’ }; % Voltage across the resistor
i = { 0, ‘A’ }; % Current through the resistor
end
branches
i : p.i -> n.i; % Current from p to n
end
equations
v == p.v – n.v; % Voltage across the resistor
R == 1/((epsilon*sigma*(p.v^2+n.v^2)*(p.v+n.v))/(2-epsilon)); % Resistance as a function of radiative heat transfer
v == R * i; % Ohm’s Law
end
end
Thanks for your time and help,
Elias LynchHey everyone, I’m in the process of trying to build a custom variable resistor using simulink. I created a code for a simscape component in MATLAB but it’s giving me an error saying "Invalid use of a MATLAB function in This Context" when I try inserting the simscape component in simulink. Shown below is my code:
The error happens on line 26 (the equation with variable R). Are there any tips or suggestions to fix my error?
component VoltageDependentResistor
% Voltage-dependent resistor
% This resistor’s value changes based on the voltage across it.
nodes
p = foundation.electrical.electrical; % positive terminal
n = foundation.electrical.electrical; % negative terminal
end
parameters
alpha = {1, ‘1/V’}; % Coefficient for voltage dependence
epsilon = 0.6;
sigma = 5.67E-8
end
variables
v = { 0, ‘V’ }; % Voltage across the resistor
i = { 0, ‘A’ }; % Current through the resistor
end
branches
i : p.i -> n.i; % Current from p to n
end
equations
v == p.v – n.v; % Voltage across the resistor
R == 1/((epsilon*sigma*(p.v^2+n.v^2)*(p.v+n.v))/(2-epsilon)); % Resistance as a function of radiative heat transfer
v == R * i; % Ohm’s Law
end
end
Thanks for your time and help,
Elias Lynch Hey everyone, I’m in the process of trying to build a custom variable resistor using simulink. I created a code for a simscape component in MATLAB but it’s giving me an error saying "Invalid use of a MATLAB function in This Context" when I try inserting the simscape component in simulink. Shown below is my code:
The error happens on line 26 (the equation with variable R). Are there any tips or suggestions to fix my error?
component VoltageDependentResistor
% Voltage-dependent resistor
% This resistor’s value changes based on the voltage across it.
nodes
p = foundation.electrical.electrical; % positive terminal
n = foundation.electrical.electrical; % negative terminal
end
parameters
alpha = {1, ‘1/V’}; % Coefficient for voltage dependence
epsilon = 0.6;
sigma = 5.67E-8
end
variables
v = { 0, ‘V’ }; % Voltage across the resistor
i = { 0, ‘A’ }; % Current through the resistor
end
branches
i : p.i -> n.i; % Current from p to n
end
equations
v == p.v – n.v; % Voltage across the resistor
R == 1/((epsilon*sigma*(p.v^2+n.v^2)*(p.v+n.v))/(2-epsilon)); % Resistance as a function of radiative heat transfer
v == R * i; % Ohm’s Law
end
end
Thanks for your time and help,
Elias Lynch simulink, matlab, simscape MATLAB Answers — New Questions
Deploying Win32 APPS with intune – Install Pending
Hi Guys
I’m new in deploying apps through intune for windows device but I’ve followed this guide here
https://www.recastsoftware.com/create-win32-application-and-deploy-with-microsoft-intune/
I also see that the device has read the policy in installing the software but its showing install pending?
What does install pending actually mean and how do I get it to install?
Hi Guys I’m new in deploying apps through intune for windows device but I’ve followed this guide here https://www.recastsoftware.com/create-win32-application-and-deploy-with-microsoft-intune/ I also see that the device has read the policy in installing the software but its showing install pending?What does install pending actually mean and how do I get it to install? Read More
Error Code during login with Azure Student Account
Hello! I’m having trouble login-in to my student account with Azure. The website gave me an error code to troubleshoot the page but when I tried submitting a ticket through Azure the website would continue to reload and eventually tell me I’m unable to sign into my account. This is the link I was issued by my professor https://azureforeducation.microsoft.com/devtools. The link attached did work before. Here is also the error code given by the website:
“Error Code: 50196
Request Id: db011293-d006-4ac2-8fd6-fa8e415f1900
Correlation Id: 86588f1a-9f48-4fb5-8afc-b578027465e5
Timestamp: 2024-05-17T10:26:06.725Z”
I’m hoping this problem can be resolved in a timely matter; I depend on this access to download software for my Linux class.
Hello! I’m having trouble login-in to my student account with Azure. The website gave me an error code to troubleshoot the page but when I tried submitting a ticket through Azure the website would continue to reload and eventually tell me I’m unable to sign into my account. This is the link I was issued by my professor https://azureforeducation.microsoft.com/devtools. The link attached did work before. Here is also the error code given by the website: “Error Code: 50196Request Id: db011293-d006-4ac2-8fd6-fa8e415f1900Correlation Id: 86588f1a-9f48-4fb5-8afc-b578027465e5Timestamp: 2024-05-17T10:26:06.725Z” I’m hoping this problem can be resolved in a timely matter; I depend on this access to download software for my Linux class. Read More
Sending email through Outlook smtp using third party app – it is permissible?
I want to send router and backup alerts via email and I have configured the backup and router software to send the alerts via the Outlook smtp. I know it works as I successfully tested it. However after a few hours the account has been frozen for violating acceptable use regarding spamming. Is prohibited to do this? It is certainly technically possible to do it as I have done it and it works. I had to supply my mobile to get a code to unlock the account. Will that satisfy Microsoft that I am not using the account for spamming? I cannot find a definitive statement of whether it is allowed to do what I am doing. To be on the safe side I have disabled the alerts until I know. If this is going to keep on happening and I risk a ban then I will have to find another solution. Thanks for any assistance
I want to send router and backup alerts via email and I have configured the backup and router software to send the alerts via the Outlook smtp. I know it works as I successfully tested it. However after a few hours the account has been frozen for violating acceptable use regarding spamming. Is prohibited to do this? It is certainly technically possible to do it as I have done it and it works. I had to supply my mobile to get a code to unlock the account. Will that satisfy Microsoft that I am not using the account for spamming? I cannot find a definitive statement of whether it is allowed to do what I am doing. To be on the safe side I have disabled the alerts until I know. If this is going to keep on happening and I risk a ban then I will have to find another solution. Thanks for any assistance Read More
Regenerate a PDF file with a PDF printer
Hello.
We have issues with PDF files which need to be re-generated, using the “microsoft print to PDF” printer fixed issues that we have.
How can I code that in C#? I have tried heaps of codes, nothing worked.
I have tried this :
try
{
ProcessStartInfo info = new ProcessStartInfo
{
FileName = filePath,
Verb = “PrintTo”,
Arguments = “”” + outputFilePath + “” “Microsoft Print to PDF””,
CreateNoWindow = true,
WindowStyle = ProcessWindowStyle.Hidden
};
using (Process p = new Process())
{
p.StartInfo = info;
p.Start();
p.WaitForExit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
but it’s not adapter for Windows, or even :
try
{
PrintDocument pd = new PrintDocument();
ProcessStartInfo info = new ProcessStartInfo(filePath);
info.Verb = “Print”;
pd.PrinterSettings.PrintToFile = true;
pd.PrinterSettings.PrinterName = “Microsoft Print to PDF”;
pd.PrinterSettings.PrintFileName = outputFilePath;
pd.Print();
info.CreateNoWindow = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
which generates empty files…
Thanks
Hello.We have issues with PDF files which need to be re-generated, using the “microsoft print to PDF” printer fixed issues that we have.How can I code that in C#? I have tried heaps of codes, nothing worked.I have tried this : try
{
ProcessStartInfo info = new ProcessStartInfo
{
FileName = filePath,
Verb = “PrintTo”,
Arguments = “”” + outputFilePath + “” “Microsoft Print to PDF””,
CreateNoWindow = true,
WindowStyle = ProcessWindowStyle.Hidden
};
using (Process p = new Process())
{
p.StartInfo = info;
p.Start();
p.WaitForExit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
} but it’s not adapter for Windows, or even : try
{
PrintDocument pd = new PrintDocument();
ProcessStartInfo info = new ProcessStartInfo(filePath);
info.Verb = “Print”;
pd.PrinterSettings.PrintToFile = true;
pd.PrinterSettings.PrinterName = “Microsoft Print to PDF”;
pd.PrinterSettings.PrintFileName = outputFilePath;
pd.Print();
info.CreateNoWindow = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
} which generates empty files…Thanks Read More
‘Lockdown” Malicious Behavior prevented in NetworkOnboardingClient
Hi, Good day,
we encountered “Lockdown” Malicious Behavior in the Network Connectivity Test when we RUN Test,
when we RUN a Connectivity.exe, the issue will notify the files is Malicious behavior and prevent NetworkBoardingClient.
its @anyone can help us to solve and understand what the issue encountered.
please email us at : email address removed for privacy reasons
Hi, Good day, we encountered “Lockdown” Malicious Behavior in the Network Connectivity Test when we RUN Test, when we RUN a Connectivity.exe, the issue will notify the files is Malicious behavior and prevent NetworkBoardingClient. its @anyone can help us to solve and understand what the issue encountered. please email us at : email address removed for privacy reasons Read More
How to fix the qbmapi64 Out of Memory Error on window 10/11
I’ve been encountering a “qbmapi64 Out of Memory Error” on my Windows 10/11 system while using QuickBooks. This error disrupts my workflow and I need a solution urgently. What causes this issue and how can I resolve it?
I’ve been encountering a “qbmapi64 Out of Memory Error” on my Windows 10/11 system while using QuickBooks. This error disrupts my workflow and I need a solution urgently. What causes this issue and how can I resolve it? Read More
Solve QuickBooks desktop 2023 keeps freezing Issue?
I’m experiencing a problem with QuickBooks Desktop 2023—it keeps freezing whenever I try to open it or use certain features. This issue is severely disrupting my workflow. I’ve already tried restarting my computer and updating QuickBooks, but the problem persists. Can you provide some troubleshooting steps or solutions to resolve this issue?
I’m experiencing a problem with QuickBooks Desktop 2023—it keeps freezing whenever I try to open it or use certain features. This issue is severely disrupting my workflow. I’ve already tried restarting my computer and updating QuickBooks, but the problem persists. Can you provide some troubleshooting steps or solutions to resolve this issue? Read More
What To Do When Stuck in QuickBooks desktop 2023 keeps crashing Issue?
QuickBooks Desktop 2023 keeps crashing every time I try to open it or perform certain tasks. It’s affecting my ability to manage my business finances effectively. I’ve tried restarting my computer, but the problem persists. Can anyone provide detailed troubleshooting steps to resolve this issue?
QuickBooks Desktop 2023 keeps crashing every time I try to open it or perform certain tasks. It’s affecting my ability to manage my business finances effectively. I’ve tried restarting my computer, but the problem persists. Can anyone provide detailed troubleshooting steps to resolve this issue? Read More
New Outlook Regional Settings
When can we except working regional settings for new Outlook?
For example not to lock settings to display language and/or allow sync settings from M365.
Cannot really understand that decisions to lock settings to display language???
When can we except working regional settings for new Outlook?For example not to lock settings to display language and/or allow sync settings from M365. Cannot really understand that decisions to lock settings to display language??? Read More
What are common solutions for resolving QuickBooks Error 9000 efficiently?
I keep encountering QuickBooks Error 9000 when attempting to send payroll data. It’s causing delays and frustration in processing payroll. How can I quickly resolve this issue and ensure smooth payroll processing?
I keep encountering QuickBooks Error 9000 when attempting to send payroll data. It’s causing delays and frustration in processing payroll. How can I quickly resolve this issue and ensure smooth payroll processing? Read More
Expert Tips to Fix QuickBooks Error 15101 After Latest Update
I’m encountering QuickBooks Error 15101 while trying to update my software. The error message suggests a problem with my update, but I can’t seem to resolve it on my own. Can someone explain what this error means and how I can fix it?
I’m encountering QuickBooks Error 15101 while trying to update my software. The error message suggests a problem with my update, but I can’t seem to resolve it on my own. Can someone explain what this error means and how I can fix it? Read More