Hi All,

Hope everyone are doing well ! I have came up with a question would be helpful to share your experience.

In AVD host pools, I have a scenario where I have 50 users assigned to AVD pool, the users are standard users with same average workload per user. They all use Microsoft apps like outlook, chrome, excel. Currently, I have pool configured to run four D8sv3 session hosts.
But after using this settings for 1 week, users are now complaining about performance issues in their sessions. I feel memory should be the major issue.

If I upgrade the pool to eight D4sv3 or eight E4sv3 or two E16sv3 VMs will it resolve the issue?

Can you suggest either one of these options for upgrading the pools configured ?

Thanks.

​Hi All,Hope everyone are doing well ! I have came up with a question would be helpful to share your experience.In AVD host pools, I have a scenario where I have 50 users assigned to AVD pool, the users are standard users with same average workload per user. They all use Microsoft apps like outlook, chrome, excel. Currently, I have pool configured to run four D8sv3 session hosts.But after using this settings for 1 week, users are now complaining about performance issues in their sessions. I feel memory should be the major issue.If I upgrade the pool to eight D4sv3 or eight E4sv3 or two E16sv3 VMs will it resolve the issue?Can you suggest either one of these options for upgrading the pools configured ?Thanks.  Read More

​

The Set-MailboxFolderPermission cmdlet is usually used to set calendar permissions, including the permission for the default user to allow everyone in an organization to see each other’s calendars. But you can use cmdlets from the Microsoft Graph PowerShell SDK too. The Graph SDK cmdlets are faster, but not enough to warrant replacing the Exchange cmdlet in scripts. We explain why here.

https://office365itpros.com/2024/06/18/set-default-calendar-permission/

​The Set-MailboxFolderPermission cmdlet is usually used to set calendar permissions, including the permission for the default user to allow everyone in an organization to see each other’s calendars. But you can use cmdlets from the Microsoft Graph PowerShell SDK too. The Graph SDK cmdlets are faster, but not enough to warrant replacing the Exchange cmdlet in scripts. We explain why here.
 
https://office365itpros.com/2024/06/18/set-default-calendar-permission/  Read More

​

I’m encountering Quick.Books Error 6000 when trying to open my company file. This error is preventing me from accessing my financial data, and I need a quick solution to get back on track. What steps can I take to troubleshoot and resolve this issue effectively?

​I’m encountering Quick.Books Error 6000 when trying to open my company file. This error is preventing me from accessing my financial data, and I need a quick solution to get back on track. What steps can I take to troubleshoot and resolve this issue effectively?  Read More

​

A few days ago, our customer encountered connectivity issues while using HikariCP in their Java application. To troubleshoot the problem, we enabled detailed logging for the Microsoft JDBC Driver for SQL Server. This logging gave me a lot of information and details, following I would like to share my lessons learned here.

To capture detailed logs, we configured the Java logging framework to record the operations of the JDBC driver at a fine-grained level. 

To enable the logging I included these instrucctions in the code:

import java.util.logging.*;

public static void main(String[] args) throws Exception{
Logger globalLogger1 = Logger.getLogger(Logger.GLOBAL_LOGGER_NAME);
globalLogger1.setLevel(Level.FINE);
Logger rootLogger1 = Logger.getLogger(“”);
rootLogger1.setLevel(Level.FINE); // Set the root logger level
// Create a custom formatter
Formatter customFormatter = new Formatter() {
@Override
public String format(LogRecord record) {
return String.format(“[%1$tF %1$tT] [%2$s] %3$s %n”,
record.getMillis(),
record.getLevel().getName(),
record.getMessage());
}
};
// Remove all existing handlers

// Create a new console handler
ConsoleHandler consoleHandler = new ConsoleHandler();
consoleHandler.setLevel(Level.FINE); // Set the level for console handler
consoleHandler.setFormatter(customFormatter);
//consoleHandler.setFormatter(new SimpleFormatter()); // Set the formatter

// Add the new handler to the root logger
rootLogger1.addHandler(consoleHandler);

// Set specific log levels for SQL Server JDBC driver
Logger sqlLogger = Logger.getLogger(“com.microsoft.sqlserver.jdbc”);
sqlLogger.setLevel(Level.FINE);
Logger sqlDataSourceLogger = Logger.getLogger(“com.microsoft.sqlserver.jdbc.SQLServerDataSource”);
sqlDataSourceLogger.setLevel(Level.FINE);
}

Basically, after enabling this information we could see the following details (as an example):

ConnectionID.
Redirection (depending on connection policy).
Login Timeout. 

[2024-06-18 10:27:21] [FINE] ConnectionID:1 created by (SQLServerDataSource:1)
[2024-06-18 10:27:21] [FINE] ConnectionID:1 This attempt server name: servername.database.windows.net port: 1433 InstanceName: null useParallel: false
[2024-06-18 10:27:21] [FINE] ConnectionID:1 This attempt endtime: 1718699261215
[2024-06-18 10:27:21] [FINE] ConnectionID:1 This attempt No: 0
[2024-06-18 10:27:21] [FINE] ConnectionID:1 Connecting with server: servername.database.windows.net port: 1433 Timeout slice: 19934 Timeout Full: 20
[2024-06-18 10:27:21] [FINE] ConnectionID:1 ClientConnectionId: 80f77dcf-5d20-47bc-be53-025868ac76e6 Server returned major version:12
[2024-06-18 10:27:22] [FINE] ConnectionID:1 This attempt server name: aabeaXXX.trXXXX.northeurope1-a.worker.database.windows.net port: 11002 InstanceName: null useParallel: false
[2024-06-18 10:27:22] [FINE] ConnectionID:1 This attempt endtime: 1718699261215
[2024-06-18 10:27:22] [FINE] ConnectionID:1 This attempt No: 1
[2024-06-18 10:27:22] [FINE] ConnectionID:1 Connecting with server: aabeaXXX.trXXXX.northeurope1-a.worker.database.windows.net port: 11002 Timeout slice: 19074 Timeout Full: 20
[2024-06-18 10:27:22] [FINE] ConnectionID:1 ClientConnectionId: 0bb41f4c-dcac-4a32-9e04-8f9395055527 Server returned major version:12
[2024-06-18 10:27:22] [FINE] SQLServerStatement:1 created by (ConnectionID:1 ClientConnectionId: 0bb41f4c-dcac-4a32-9e04-8f9395055527)
[2024-06-18 10:27:22] [FINE] SQLServerStatement:1 Executing (not server cursor) select 1
[2024-06-18 10:27:23] [FINE] SQLServerResultSet:1 created by (SQLServerStatement:1)
[2024-06-18 10:27:23] [FINE] SQLServerStatement:2 created by (ConnectionID:1 ClientConnectionId: 0bb41f4c-dcac-4a32-9e04-8f9395055527)
[2024-06-18 10:27:23] [FINE] SQLServerStatement:2 Executing (not server cursor) SELECT 1
[2024-06-18 10:27:23] [FINE] ConnectionID:2 created by (SQLServerDataSource:1)
[2024-06-18 10:27:23] [FINE] sp_executesql SQL: SELECT 1 AS ID: calling sp_executesql: SQL:SELECT 1 AS ID
[2024-06-18 10:27:23] [FINE] ConnectionID:2 ClientConnectionId: 3161a9ac-f8f4-4eab-bf80-999f48859d26 Server returned major version:12
[2024-06-18 10:27:23] [FINE] SQLServerResultSet:3 created by (sp_executesql SQL: SELECT 1 AS ID)

​Microsoft Tech Community – Latest Blogs –Read More 

Hello,

We found Edge (V125) Update Policies are not applied on WIN 11 PRO for workstation (23H2) device, which is managed by MDM-enrollment.  Not sure if it is by design purpose or not.

Even we enrolled the device into Intune, and configure the policy using admin template, and the device has received the policy and updated in the registry, however on edge://policy page, there are not policies displayed at all (in Microsoft EdgeUpdte Policy section).  Only normal edge policies are applied.

Could you pls look into it, coz it works on win 11 pro version and can not understand why it is not working on proworkstation, anyway, it is just a branch of pro version. 

​Hello, We found Edge (V125) Update Policies are not applied on WIN 11 PRO for workstation (23H2) device, which is managed by MDM-enrollment.  Not sure if it is by design purpose or not. Even we enrolled the device into Intune, and configure the policy using admin template, and the device has received the policy and updated in the registry, however on edge://policy page, there are not policies displayed at all (in Microsoft EdgeUpdte Policy section).  Only normal edge policies are applied. Could you pls look into it, coz it works on win 11 pro version and can not understand why it is not working on proworkstation, anyway, it is just a branch of pro version.   Read More

​

Dear Community, 

I have browsed several threads on the platform to find solution to this specific problem but havnt got it anywhere. I know that there is a methodology to lock the cells in a spreadsheet from editing as well as lock in formats to stop users from changing them however how do I do both in one. 

For example, I have a spreadsheet in which there is a table. I would like to lock the columns A,B and C such that users are not able to edit value, at the same time I would like to lock cells in column D,E,F such that users cannot paste in values but access the drop down lists in cells to select values.

Is there anyway to achieve this?

Your inputs are highly appreciated 🙂 

​Dear Community,  I have browsed several threads on the platform to find solution to this specific problem but havnt got it anywhere. I know that there is a methodology to lock the cells in a spreadsheet from editing as well as lock in formats to stop users from changing them however how do I do both in one. For example, I have a spreadsheet in which there is a table. I would like to lock the columns A,B and C such that users are not able to edit value, at the same time I would like to lock cells in column D,E,F such that users cannot paste in values but access the drop down lists in cells to select values. Is there anyway to achieve this? Your inputs are highly appreciated 🙂   Read More

​