Category: Microsoft
Category Archives: Microsoft
Azure Streaming Analytics Job not writing data to Azure storage container
Hello,
I have a situation where my Azure Streaming Analytics job is not writing the incoming events coming from our IoT Hub to the Azure storage container.
Within my dashboard, The IoT Hub Usage states there are several thousand messages coming through daily.
Below were the steps taken to start troubleshooting my problem:
Tested both the input and output connections from the query and they were both successfulUploaded test data and the file format has not changedChecked for errors within the input/IoT Hub for malformed and/or deserialization errors but there are none
Any help with this problem would be greatly appreciated.
Thank you
Hello, I have a situation where my Azure Streaming Analytics job is not writing the incoming events coming from our IoT Hub to the Azure storage container. Within my dashboard, The IoT Hub Usage states there are several thousand messages coming through daily. Below were the steps taken to start troubleshooting my problem: Tested both the input and output connections from the query and they were both successfulUploaded test data and the file format has not changedChecked for errors within the input/IoT Hub for malformed and/or deserialization errors but there are noneAny help with this problem would be greatly appreciated. Thank you Read More
Shifting from Thunderbird to Outlook
I have created a bunch of filters and folders, so that incoming mail is moved to the desired folder as soon as it comes in. But, unlike Thunderbird, the Outlook folder name does not become bold (dark characters) to indicate that there is new/unread email in this folder. Is there something I can set, for Outlook to show which folders have unread email
I have created a bunch of filters and folders, so that incoming mail is moved to the desired folder as soon as it comes in. But, unlike Thunderbird, the Outlook folder name does not become bold (dark characters) to indicate that there is new/unread email in this folder. Is there something I can set, for Outlook to show which folders have unread email Read More
Microsoft CSP – Indirect Reseller Status is Suspended and Can’t Get Fixed
I am in a very bad spot with our indirect reseller Microsoft account and am hoping that maybe someone out there might be able to help me.
In mid May, I placed an order with Pax8 for a new customer and the order was rejected by Microsoft with the error, “Associated partner LegalBusinessProfile NotFound.”
It turns out that when we moved offices and I updated our business’s address at partner.microsoft.com, Microsoft de-authorized our partner status, which I didn’t catch, and then put our Cloud Service Provider (CSP) indirect reseller program into “Suspended” status after some time.
In the partner center, I was able to get our legal business profile fixed easy enough – I just had to open a ticket and send them some legal documentation. Everything under the “Partner” tab in the Partner Portal is now green checkboxes and “Authorized”. Pax8 tried the provisioning again, and got the same error.
It turns out that our “Indirect Reseller status” is now “Suspended” and this wasn’t changed when the “Partner” status was fixed.
Microsoft has a webpage that describes why this can happen and what to do to get it fixed at https://learn.microsoft.com/en-us/partner-center/account-settings/suspended-partner-center-account . It says, “Microsoft suspends Partner Center accounts for Microsoft AI Cloud Partner Program when:
Significant account abuse is detected
Your vetting status is Rejected for more than 30 days”
We haven’t had any account abuse (mercifully, our existing tenants are still operational and being billed for through Pax8), so our vetting status was almost certainly to blame. That same document says, “If you are sure that your account is compliant and should be moved back to Active state, contact Support for help with reactivating your account,” so I opened a ticket with Microsoft.
Actually, 3 tickets so far, because every single one has the same copy-and-paste reply:
Thank you for contacting Microsoft Partner support about the suspension of the CSP account.
In the Microsoft AI Cloud Partner Program Agreement, both Microsoft and our partners reserve the right to walk away from the partner relationship by providing 30 days’ notice to the other. The notice of suspension and termination proceeding was provided April 2024. Neither party is required to offer an explanation for the decision to terminate the partner agreement. As Microsoft is exercising its rights under this section 4.b of the Microsoft AI Cloud Program Agreement, we are unable to share an explanation or further details.
Thanks,
I can’t get anywhere with Microsoft support. We just landed a big customer and need to set up their tenant. I am afraid that if this goes on much longer or if somehow we are unable to add any more customers to our Pax8 account, that we’ll lose this customer, which is large enough to really hurt the business.
Does anyone here have any ideas on how to get through to someone at Microsoft that could help with this situation? Does anyone else have any other ideas on what else we could try?
Some additional notes:
When clicking “Agreements” in the partner portal, we get an error message, “Service unavailable. Something went wrong. Please try reloading the page, if this problem persists please contact Microsoft support.”
Everything in Legal Info/Partner looks good. Our “Microsoft AI Cloud Partner Program status” is “Active”.
Everything in Legal Info/Reseller looks good except that “Indirect Reseller status” shows “Suspended”.
Under Identifiers/Microsoft AI Cloud Partner Program, I have 1 PartnerGlobal ID and 2 PartnerLocation IDs, corresponding to our old and new addresses. Do I need to delete the old PartnerLocation ID? I haven’t done so because it looks like this step is irreversible but I am getting desperate enough to try it.
Our “Company profile” is not filled out, but the “Update” button stays grayed out after I fill in the information and it appears that I am unable to update this.
I thought that maybe I just needed to sign the “Microsoft AI Cloud Partner Program Agreement” again, but I can’t find anywhere on the partner portal where I would do so.
I went through my emails exhaustively and we did not receive a, “notice of suspension and termination proceeding” in April 2024, or any other time for that matter.
I can’t find a copy of the Microsoft AI Cloud Program Agreement to even see what section 4.b says.
I’ve dealt with government bureaucracies a lot in my career, but I’ve never experienced a Kafkaesque situation 10% as bad as this one. This is probably the most stressful thing I’ve dealt with in this business in the last decade. This could destroy our business if I can’t get this sorted out.
Sorry for the wall of text, but I tried to include as much detail as possible and it got long. If you got to this point in my post, thank you for helping or trying to help me.
The latest ticket ID we have from Microsoft is 2406050040012239
I am in a very bad spot with our indirect reseller Microsoft account and am hoping that maybe someone out there might be able to help me.In mid May, I placed an order with Pax8 for a new customer and the order was rejected by Microsoft with the error, “Associated partner LegalBusinessProfile NotFound.”It turns out that when we moved offices and I updated our business’s address at partner.microsoft.com, Microsoft de-authorized our partner status, which I didn’t catch, and then put our Cloud Service Provider (CSP) indirect reseller program into “Suspended” status after some time.In the partner center, I was able to get our legal business profile fixed easy enough – I just had to open a ticket and send them some legal documentation. Everything under the “Partner” tab in the Partner Portal is now green checkboxes and “Authorized”. Pax8 tried the provisioning again, and got the same error.It turns out that our “Indirect Reseller status” is now “Suspended” and this wasn’t changed when the “Partner” status was fixed.Microsoft has a webpage that describes why this can happen and what to do to get it fixed at https://learn.microsoft.com/en-us/partner-center/account-settings/suspended-partner-center-account . It says, “Microsoft suspends Partner Center accounts for Microsoft AI Cloud Partner Program when:Significant account abuse is detectedYour vetting status is Rejected for more than 30 days”We haven’t had any account abuse (mercifully, our existing tenants are still operational and being billed for through Pax8), so our vetting status was almost certainly to blame. That same document says, “If you are sure that your account is compliant and should be moved back to Active state, contact Support for help with reactivating your account,” so I opened a ticket with Microsoft.Actually, 3 tickets so far, because every single one has the same copy-and-paste reply:Thank you for contacting Microsoft Partner support about the suspension of the CSP account. In the Microsoft AI Cloud Partner Program Agreement, both Microsoft and our partners reserve the right to walk away from the partner relationship by providing 30 days’ notice to the other. The notice of suspension and termination proceeding was provided April 2024. Neither party is required to offer an explanation for the decision to terminate the partner agreement. As Microsoft is exercising its rights under this section 4.b of the Microsoft AI Cloud Program Agreement, we are unable to share an explanation or further details. Thanks,I can’t get anywhere with Microsoft support. We just landed a big customer and need to set up their tenant. I am afraid that if this goes on much longer or if somehow we are unable to add any more customers to our Pax8 account, that we’ll lose this customer, which is large enough to really hurt the business.Does anyone here have any ideas on how to get through to someone at Microsoft that could help with this situation? Does anyone else have any other ideas on what else we could try?Some additional notes:When clicking “Agreements” in the partner portal, we get an error message, “Service unavailable. Something went wrong. Please try reloading the page, if this problem persists please contact Microsoft support.”Everything in Legal Info/Partner looks good. Our “Microsoft AI Cloud Partner Program status” is “Active”.Everything in Legal Info/Reseller looks good except that “Indirect Reseller status” shows “Suspended”.Under Identifiers/Microsoft AI Cloud Partner Program, I have 1 PartnerGlobal ID and 2 PartnerLocation IDs, corresponding to our old and new addresses. Do I need to delete the old PartnerLocation ID? I haven’t done so because it looks like this step is irreversible but I am getting desperate enough to try it.Our “Company profile” is not filled out, but the “Update” button stays grayed out after I fill in the information and it appears that I am unable to update this.I thought that maybe I just needed to sign the “Microsoft AI Cloud Partner Program Agreement” again, but I can’t find anywhere on the partner portal where I would do so.I went through my emails exhaustively and we did not receive a, “notice of suspension and termination proceeding” in April 2024, or any other time for that matter.I can’t find a copy of the Microsoft AI Cloud Program Agreement to even see what section 4.b says.I’ve dealt with government bureaucracies a lot in my career, but I’ve never experienced a Kafkaesque situation 10% as bad as this one. This is probably the most stressful thing I’ve dealt with in this business in the last decade. This could destroy our business if I can’t get this sorted out.Sorry for the wall of text, but I tried to include as much detail as possible and it got long. If you got to this point in my post, thank you for helping or trying to help me.The latest ticket ID we have from Microsoft is 2406050040012239 Read More
That should be obvious: get my contacts from outlook.com (OWA) synced Outlook 2016 or Outlook 2019.
Call me stupid; I can’t get my contacts from my outlook.com account to show up in Outlook 2016 for Mac or Outlook2019 for Windows.
All my contacts are on https://outlook.live.com/people/, I can see them in Outlook for Android on my Smartphone but I can’t see them in the desktop apps.
What are the steps to initiate the contacts syncing on desktop apps?
Call me stupid; I can’t get my contacts from my outlook.com account to show up in Outlook 2016 for Mac or Outlook2019 for Windows.All my contacts are on https://outlook.live.com/people/, I can see them in Outlook for Android on my Smartphone but I can’t see them in the desktop apps.What are the steps to initiate the contacts syncing on desktop apps? Read More
Tech Presentations: Key Strategies for Success
Navigating the intricate world of technology requires more than just expertise; it demands the ability to share that knowledge effectively. This article embarks on a journey to uncover the most effective strategies for crafting presentations tailored for the tech-savvy audience. We will dissect the elements that make a presentation not just informative, but memorable and engaging. From leveraging the latest tools to understanding the nuances of audience engagement, we aim to provide a comprehensive guide that empowers tech professionals to deliver their message with precision and impact. We’ll discuss these strategies with U.S. M365 MVP Melissa Marshall.
MVP Melissa Marshall
Share with us your journey into becoming a top-level presenter.
I started my career as a professor at Penn State University, where I taught public speaking courses for engineering students. While I was there, I had the good fortune to give a TED Talk entitled “Talk Nerdy to Me” about the importance of science communication, and that really launched my ideas on scientific presentations into global prominence. I began to receive additional invitations to speak at conferences and provide training workshops at companies and institutions. In 2015, I went full-time into my speaking, training, and consulting business, Present Your Science. I now help the leading tech professionals and companies in the world present their work in a meaningful and compelling way that inspires stakeholders to take action.
Could you please share with us the three main tools to improve presentations?
Be audience-centric. Your ability to be successful as a speaker depends upon your ability to make your audience successful.
TIP: Be an interpreter of your work, not a reporter. Always connect each piece of technical info to a “So what?” point.
Filter and Focus. When you try to share everything, you share nothing.
TIP: Start your planning with the ‘view’ you want your audience to have at the end of the talk. Then ask yourself “What would they need to know in order to get there?”
Show Your Science. Your slides should do something for you that your words cannot. This means make your slides VISUAL not VERBAL.
TIP: Avoid bullet points (seriously!). Have a brief take-away message at the top of each slide and support it with visual evidence.
What are the main challenges that presenters face during a presentation?
Presenters often allow the “status quo” of how slides are typically designed in their industry or at their company to dictate their choices. Unfortunately, this status quo is often rooted in text heavy, bulleted slides which are not successful for an audience. Instead of designing slides how you have always seen it done, I think presenters need to use a more strategic, evidence-based approach for their slide design. That’s why I worked with the MS PowerPoint team to create this slide design template for technical presenters. This template is fully customizable, but it helps to lead the presenter to a design strategy that focuses on take away messages supported by visual evidence. Which is a big step in the right direction for technical slides that are more successful for an audience.
Also, presenters often struggle to filter their details in presentations, and they overwhelm the audience with too much information. This can be improved by beginning your preparation by identifying the most critical single message you must convey. And then focus on including information that relates to that message.
When sharing data, it’s important to be very descriptive about not just what the data is, but why the data is significant. It is easy to get in the habit of simply sharing the information, without providing context for it.
How are you using AI today to help you with presentations?
I love sharing PowerPoint Speaker Coach with my clients. This is an awesome AI-Driven tool that provides the speaker with private feedback on presentation elements like rate of speaking, emphasis, verbal fillers, and inclusive language. It’s a great way to add some structure and purpose to practicing a presentation.
What advice would you have for tech professionals beginning their journey presenting?
Look for more opportunities to present! Most people have some anxiety associated with speaking in front of others, which causes them to avoid those situations as much as possible. However, the answer to becoming more comfortable speaking is to simply DO IT MORE. It’s counterintuitive to what we feel like we want to do, but if you embraced the discomfort of presenting more often, you would find quite quickly that you are all the sudden becoming more comfortable and confident.
In summary, the journey through the landscape of technical presentations is one of continuous learning and adaptation. The strategies discussed here provide a roadmap for creating presentations that not only convey complex information but also engage and inspire the tech community. By weaving together a narrative that resonates with the audience, utilizing visual aids to clarify and emphasize key points, and delivering with confidence and passion, presenters can leave a lasting impact. As technology continues to advance, so must our approach to sharing it. Let this article serve as a catalyst for innovation in your presentation techniques, empowering you to illuminate the path forward in the ever-changing world of technology.
Microsoft Tech Community – Latest Blogs –Read More
Copilot Flight Crew: Earn Your Wings?
At the M365 Community Conference in Orlando, we were told that a “Copilot Flight Crew” challenge would be starting on June 1st but I am unable to find any information about it. See image from presentation below:
At the M365 Community Conference in Orlando, we were told that a “Copilot Flight Crew” challenge would be starting on June 1st but I am unable to find any information about it. See image from presentation below: Read More
Excel file opening very slowly
I have moderately complex excel spreadsheet that opens very slowly.
I have moderately complex excel spreadsheet that opens very slowly. Read More
Project Online (PWA) Issue: When a save a project next day all my tasks are gone.
I have a problem with the Project Online (PWA). Every time I create a new project, I open it through Project Desktop, adding all the tasks, save it, and check in, everything looks fine. But the next day, when I open it, all my tasks are gone. I have given my users owner permissions to the SharePoint Site Project Web App to they check off any task in the task list. Also, when I open the project website in SharePoint, all the tasks are there, but when I open it through Project Desktop with different users, all is gone. Do you know why this is happening and how to fix it?
I have a backup to restore my project but frustrating and I don’t know what to do. Please advise.
I have a problem with the Project Online (PWA). Every time I create a new project, I open it through Project Desktop, adding all the tasks, save it, and check in, everything looks fine. But the next day, when I open it, all my tasks are gone. I have given my users owner permissions to the SharePoint Site Project Web App to they check off any task in the task list. Also, when I open the project website in SharePoint, all the tasks are there, but when I open it through Project Desktop with different users, all is gone. Do you know why this is happening and how to fix it? I have a backup to restore my project but frustrating and I don’t know what to do. Please advise. Read More
How can I write this update better?
The query below is to check if a specific date falls on a weekend and if it does update the date to the Monday following the weekend. Ex: date = 6/15/2024. This falls on a Saturday. In this case, the date is set to 6/17/2024.
The query works as expected, however, curious to know if there is a shorter, efficient version.
declare
@day int, @date datetime
set @date = convert(varchar,getdate(),101)
select @day = datepart(dw, @date)
select
case when @day = 7 then @date + 2
when @day = 1 then @date + 1
else @date
end
update table_name set run_date = @date where id = 123
The query below is to check if a specific date falls on a weekend and if it does update the date to the Monday following the weekend. Ex: date = 6/15/2024. This falls on a Saturday. In this case, the date is set to 6/17/2024.The query works as expected, however, curious to know if there is a shorter, efficient version. declare@day int, @date datetimeset @date = convert(varchar,getdate(),101)select @day = datepart(dw, @date)select case when @day = 7 then @date + 2 when @day = 1 then @date + 1 else @date endupdate table_name set run_date = @date where id = 123 Read More
TempDB space in Azure SQL DB appears much less than the published values
Issue
An issue was brought to our attention recently where an azure SQL DB was throwing TempDB related errors although the customer felt that the TempDB usage never came close to the value published in the official Microsoft document. Here’s the error the customer had complained about:
Error
Here is a more detailed error text :
The database ‘tempdb’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.’. Possible failure reasons: Problems with the query, ‘ResultSet’ property not set correctly, parameters not set correctly, or connection not established correctly.
WorkAround/Fix:
The customer wanted to know the TempDB allocated to them. While the official documentation suggested that the SLO had 1.2 TB of Temp DB, In reality they always received a TempDB full error after 64GB.
I asked their technical team to run the following command to check the current Temp DB space allocated:
SELECT FileName = df.name,
current_file_size_MB = df.size*1.0/128,
max_size = CASE df.max_size
WHEN 0 THEN ‘Autogrowth is off.’
WHEN -1 THEN ‘Autogrowth is on.’
ELSE ‘Log file grows to a maximum size of 2 TB.’
END,
growth_value =
CASE
WHEN df.growth = 0 THEN df.growth
WHEN df.growth > 0 AND df.is_percent_growth = 0 THEN df.growth*1.0/128.0
WHEN df.growth > 0 AND df.is_percent_growth = 1 THEN df.growth
END,
growth_increment_unit =
CASE
WHEN df.growth = 0 THEN ‘Size is fixed.’
WHEN df.growth > 0 AND df.is_percent_growth = 0 THEN ‘Growth value is MB.’
WHEN df.growth > 0 AND df.is_percent_growth = 1 THEN ‘Growth value is a percentage.’
END
FROM tempdb.sys.database_files AS df;
GO
The Output that was shared, verified that the TempDB allocated was indeed 1.2TB as described in the public documentation against the DB SLO. Here’s the output:
Now the next step was to check what was the free space available in the TempDB at that point because per the customer, they were not having any heavy-duty jobs/queries running on the DB at that time. I asked them to execute the query below:
— Determining the amount of free space in tempdb
SELECT SUM(unallocated_extent_page_count) AS [free pages],
(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]
FROM tempdb.sys.dm_db_file_space_usage;
— Determining the amount of space used by the version store
SELECT SUM(version_store_reserved_page_count) AS [version store pages used],
(SUM(version_store_reserved_page_count)*1.0/128) AS [version store space in MB]
FROM tempdb.sys.dm_db_file_space_usage;
— Determining the amount of space used by internal objects
SELECT SUM(internal_object_reserved_page_count) AS [internal object pages used],
(SUM(internal_object_reserved_page_count)*1.0/128) AS [internal object space in MB]
FROM tempdb.sys.dm_db_file_space_usage;
— Determining the amount of space used by user objects
SELECT SUM(user_object_reserved_page_count) AS [user object pages used],
(SUM(user_object_reserved_page_count)*1.0/128) AS [user object space in MB]
FROM tempdb.sys.dm_db_file_space_usage;
The output shared by the team below surprised even the customer as they didn’t expect to see this in their DB. Here’s the output:
Now the next question from the team was what was occupying >95% space on their TempDB. While I pointed out a specific section from the official documentation, I had to send them a query to get some material evidence around this. Here’s the public documentation states around User object Pages Used section in the output above:
user_object_reserved_page_count – Total number of pages allocated from uniform extents for user objects in the database. Unused pages from an allocated extent are included in the count.
You can use the total_pages column in the sys.allocation_units catalog view to return the reserved page count of each allocation unit in the user object. However, note that the total_pages column includes IAM pages.
The following objects are included in the user object page counters:
User-defined tables and indexes
System tables and indexes
Global temporary tables and indexes
Local temporary tables and indexes
Table variables
Tables returned in the table-valued functions
After that I shared the query below to help them investigate more into their TempDB:
SELECT
OBJECT_NAME(p.object_id) AS TableName,
au.*
FROM
tempdb.sys.allocation_units au
JOIN
tempdb.sys.partitions p ON au.container_id = p.partition_id
JOIN
tempdb.sys.objects o ON p.object_id = o.object_id
WHERE
au.type_desc = ‘IN_ROW_DATA’; — Optional: Add condition based on allocation unit type
Here is the output that we received and this explained the entire scenario to the customer:
The output above indicated that the 3rd party application that was connecting to the Azure SQL DB, was creating a lot of Global Temp Objects or objects that seem to persist beyond the session lifetime inside the Temp DB. The sum of the space occupied by those objects was a little over 1 TB, thereby explaining the 64 GB Temp DB space left for the rest of the queries. The customer also suspected that a new module of the 3rd party vendor could be either creating permanent objects inside the Temp DB or objects that are different from the usual Temp objects. After the discussion, the customer started a separate conversation with their vendor to address the issue.
They however had a complete understanding of the issue by the end of the troubleshooting session.
References
SORT_IN_TEMPDB Option For Indexes – SQL Server | Microsoft Learn
tempdb database – SQL Server | Microsoft Learn
Index Disk Space Example – SQL Server | Microsoft Learn
Azure SQL DB and TEMPDB usage tracking – Microsoft Community Hub
Microsoft Tech Community – Latest Blogs –Read More
Better support for Crosstab in Excel
This may be a sweeping statement but most data in Excel is stored as CrossTab, and not as a basic table (unless an export from another system).
It seems all LLMs including CoPilot can only function off Tabular structure and not CrossTabs, so unpivoted is a must before you can leverage CoPilot.
My wish would be that Excel supports the CrossTab structure more formally like it does with Excel Table. This will allow CoPilot to seamlessly read crosstab data without the need of the time intensive task of using Power Query to unpivot the data. This is also radically improve import of spreadsheets into Power BI!
Thoughts folks?
This may be a sweeping statement but most data in Excel is stored as CrossTab, and not as a basic table (unless an export from another system). It seems all LLMs including CoPilot can only function off Tabular structure and not CrossTabs, so unpivoted is a must before you can leverage CoPilot. My wish would be that Excel supports the CrossTab structure more formally like it does with Excel Table. This will allow CoPilot to seamlessly read crosstab data without the need of the time intensive task of using Power Query to unpivot the data. This is also radically improve import of spreadsheets into Power BI!Thoughts folks? Read More
Problems with DNS Replication after upgrade
I created a new A/D Server 2022 to replace my A/D Server 2012. The install completed and the FSMO roles transferred fine. However, I cannot manage the A/D GPO. In looking at the logs, it appears that DNS cannot replicate.
Password hash synchronization failed for domain: mrc.net, domain controller hostname: MIDSRVR01.mrc.net, domain controller IP address: 172.16.1.43. Details:
Microsoft.Online.PasswordSynchronization.SynchronizationManagerException: Unable to open connection to domain: mrc.net. Error: There was an error establishing a connection to the directory replication service. Domain controller hostname: MIDSRVR01.mrc.net, domain controller IP address: 192.168.99.12 —> Microsoft.Online.PasswordSynchronization.DirectoryReplicationServices.DrsCommunicationException: There was an error establishing a connection to the directory replication service. Domain controller hostname: MIDSRVR01.mrc.net, domain controller IP address: 192.168.99.12 —> Microsoft.Online.PasswordSynchronization.DirectoryReplicationServices.DrsException: There was an error creating the connection context. —> Microsoft.Online.PasswordSynchronization.DirectoryReplicationServices.DrsCommunicationException: RPC Error 1722 : The RPC server is unavailable. Error creating the RPC binding handle
The original A/D Server 2012 is multi-honed and it appears DNS is trying to use an IP Address on a private segment 192.168.99.12 which isn’t available to the new Server. The new server is on segment 172.16.1.x.
If I look at DNS, the server IP addresses appears in this order. How an I make the 172.16.1.43 the primary address?
How can I change the IP address to point to the other segment?
I created a new A/D Server 2022 to replace my A/D Server 2012. The install completed and the FSMO roles transferred fine. However, I cannot manage the A/D GPO. In looking at the logs, it appears that DNS cannot replicate. Password hash synchronization failed for domain: mrc.net, domain controller hostname: MIDSRVR01.mrc.net, domain controller IP address: 172.16.1.43. Details: Microsoft.Online.PasswordSynchronization.SynchronizationManagerException: Unable to open connection to domain: mrc.net. Error: There was an error establishing a connection to the directory replication service. Domain controller hostname: MIDSRVR01.mrc.net, domain controller IP address: 192.168.99.12 —> Microsoft.Online.PasswordSynchronization.DirectoryReplicationServices.DrsCommunicationException: There was an error establishing a connection to the directory replication service. Domain controller hostname: MIDSRVR01.mrc.net, domain controller IP address: 192.168.99.12 —> Microsoft.Online.PasswordSynchronization.DirectoryReplicationServices.DrsException: There was an error creating the connection context. —> Microsoft.Online.PasswordSynchronization.DirectoryReplicationServices.DrsCommunicationException: RPC Error 1722 : The RPC server is unavailable. Error creating the RPC binding handle The original A/D Server 2012 is multi-honed and it appears DNS is trying to use an IP Address on a private segment 192.168.99.12 which isn’t available to the new Server. The new server is on segment 172.16.1.x. If I look at DNS, the server IP addresses appears in this order. How an I make the 172.16.1.43 the primary address? How can I change the IP address to point to the other segment? Read More
Issue with Batch Insertion using PreparedStatement in SQL Server
Hi,
We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the settings and the code snippet we are using:
Settings:
sendStringParametersAsUnicode=falseconnection.setUseBulkCopyForBatchInsert(true)There is no Date type column in the target table. (issue not reproducible with date columns)
Mssql Driver version: Tested with latest driver
mssql-jdbc-12.6.2.jre11
Issue Description:
When using the above method, we notice that for VARCHAR columns, instead of inserting the actual values, object references are being inserted into the table.
Could you please provide guidance on how to resolve this issue or let us know if there are any specific configurations or code adjustments required?
Following is Code Example:
private def executeSqlBatch(query: String, records: List[scala.Array[Any]], conn: Connection): Unit = {
var connection = conn
var preparedStatement: PreparedStatement = null
try {
preparedStatement = connection.prepareStatement(query)
records.foreach(record => {
var idx = 0
record.foreach { field =>
idx += 1
preparedStatement.setObject(idx, field)
}
preparedStatement.addBatch()
})
if (records.nonEmpty) {
preparedStatement.executeBatch()
} else {
preparedStatement.execute()
}
if (conn == null && connection != null) {
connection.commit()
}
} catch {
case ex: Exception =>
try {
if (conn == null && connection != null) connection.rollback()
} catch {
case rEx: Exception => logger.error(“An exception occurred during rollback:”, rEx)
}
throw ex
} finally {
preparedStatement.clearBatch()
preparedStatement.clearParameters()
DbUtils.closeQuietly(preparedStatement)
if (conn == null) {
DbUtils.closeQuietly(connection)
}
}
}
Hi,We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the settings and the code snippet we are using:Settings:sendStringParametersAsUnicode=falseconnection.setUseBulkCopyForBatchInsert(true)There is no Date type column in the target table. (issue not reproducible with date columns)Mssql Driver version: Tested with latest drivermssql-jdbc-12.6.2.jre11Issue Description:When using the above method, we notice that for VARCHAR columns, instead of inserting the actual values, object references are being inserted into the table.Could you please provide guidance on how to resolve this issue or let us know if there are any specific configurations or code adjustments required?Following is Code Example:private def executeSqlBatch(query: String, records: List[scala.Array[Any]], conn: Connection): Unit = {var connection = connvar preparedStatement: PreparedStatement = nulltry {preparedStatement = connection.prepareStatement(query)records.foreach(record => {var idx = 0record.foreach { field =>idx += 1preparedStatement.setObject(idx, field)}preparedStatement.addBatch()})if (records.nonEmpty) {preparedStatement.executeBatch()} else {preparedStatement.execute()}if (conn == null && connection != null) {connection.commit()}} catch {case ex: Exception =>try {if (conn == null && connection != null) connection.rollback()} catch {case rEx: Exception => logger.error(“An exception occurred during rollback:”, rEx)}throw ex} finally {preparedStatement.clearBatch()preparedStatement.clearParameters()DbUtils.closeQuietly(preparedStatement)if (conn == null) {DbUtils.closeQuietly(connection)}}} Read More
MVP’s Favorite Content: Copilot+ PC, AI, Identity, Aspire
In this blog series dedicated to Microsoft’s technical articles, we’ll highlight our MVPs’ favorite article along with their personal insights.
Tomokazu Kizawa, Windows and Devices MVP, Japan
“The Copilot+ PC is a new PC concept that allows AI processing, which was previously done in the cloud, to be performed at the edge (on the PC itself). It requires an NPU capable of performing 40 trillion operations per second, high-speed and large-capacity memory, and fast storage. The Surface Pro 11 and Surface Laptop 7, equipped with Qualcomm’s Snapdragon X series processors, have been announced as high-performance PCs that make the Copilot+ PC a reality.
This article provides an excellent explanation of the new Surface series.”
(In Japanese, Copilot+ PCは、クラウドで処理をしていたAI処理をエッジ(PC)でも実行できるようにした新しいPCのコンセプトです。1秒間に40兆回の処理を行うNPU、高速で大容量なメモリ、高速なストレージを持つことが条件になっています。そして、Copilot+ PCを実現する高性能PCとしてQualcommのSnapdragon Xシリーズプロセッサを搭載した、Surface Pro 11とSurface Laptop 7が発表されました。
この記事は新型Surfaceシリーズをわかりやすく解説した素晴らしい記事です。)
*Relevant Video: 第731回 パソコンが変わる。Surfaceが変える。Copilot+ PC・新型Surface Pro 11とSurface Laptop (2024/5/26) (youtube.com)
Komes Chandavimol, AI MVP, Thailand
“My favorite site is the Microsoft Generative AI Hackathon, where over 1,000 participants compete in creating multimodal applications. The winner of the competition is ChatEDU, an innovative tool designed to transform students’ use of generative AI from mere task and assignment automation into a dynamic copilot that collaborates and learns with them. The runner-up is Garvis, which eliminates the need for users to verbally describe visual problems by directly analyzing and understanding the scene and replaces text-based instructions with intuitive visual demonstrations directly in the user’s environment. Both projects are incredible. You can explore more interesting multimodal applications in the gallery at Microsoft Generative AI Hackathon Project Gallery.”
(In Thai, งาน Microsoft Generative AI Hackathon ล่าสุด มีผู้เข้าแข่งขันหลายพันคน โดยมีหลายๆทีมที่น่าสนใจมาใน AI Hackathon Gallery โดยผู้ชนะ คือ ChatEDU เครื่องมือช่วยนักเรียนใช้ Gen AI ช่วยในการเรียน)
Zheng Xing, Windows Development MVP, China
Use Identity to secure a Web API backend for SPAs | Microsoft Learn
“As the architect of the project, I am responsible for guiding the team in designing and implementing products that comply with the secure development lifecycle. For our project, in a web application that is split between front-end and back-end and will integrate multiple third-party systems in the future, introducing ASP.NET Core Identity to achieve comprehensive identity authentication and authorization is an efficient and reasonable solution. This article provides detailed guidance and a link to an example. I have benefited a lot from it. Meanwhile, through community interactions, I’ve found that not all developers are aware of ASP.NET Core Identity. Therefore, I seize this opportunity to highly recommend it to everyone!”
(In Chinese, 作为项目的架构师，我需要指导团队设计并实现符合安全开发生命周期的产品。对于我们的项目来说，一个前后端分离，且未来会集成多个三方系统的Web Application中，通过引入ASP.NET Core Identity来实现完善的身份认证和授权，是一个高效合理的方案。这篇文章给出了详细的指导，并提供了示例的链接。我受益良多，同时在社区的交流中我发现，并不是所有的开发者都知道ASP.NET Core Identity，借此机会强烈推荐给大家！)
Tomomitsu Kusaba, Developer Technologies MVP, Japan
“.NET Aspire has reached General Availability (GA). I believe this will have a significant impact on creating cloud-native applications.”
(In Japanese, .NET AspireがGAしました。これはクラウドネイティブアプリケーションを作成する上で大きなインパクトを与える事項になると考えています。)
Microsoft Tech Community – Latest Blogs –Read More
Single-region deployment without Global Reach, using Secure Virtual WAN Hub with Routing-Intent
This article describes the best practices for connectivity and traffic flows with single-region Azure VMware Solution when using Azure Secure Virtual WAN with Routing Intent. You learn the design details of using Secure Virtual WAN with Routing-Intent without Global Reach. This article breaks down Virtual WAN with Routing Intent topology from the perspective of an Azure VMware Solution private cloud, on-premises sites, and Azure native. The implementation and configuration of Secure Virtual WAN with Routing Intent are beyond the scope and aren’t discussed in this document.
In regions without Global Reach support or with a security requirement to inspect traffic between Azure VMware Solution and on-premises at the hub firewall, a support ticket must be opened to enable ExpressRoute to ExpressRoute transitivity. ExpressRoute to ExpressRoute transitivity isn’t supported by default with Virtual WAN. – see Transit connectivity between ExpressRoute circuits with routing intent
Secure Virtual WAN with Routing Intent is only supported with Virtual WAN Standard SKU. Secure Virtual WAN with Routing Intent provides the capability to send all Internet traffic and Private network traffic (RFC 1918) to a security solution like Azure Firewall, a third-party Network Virtual Appliance (NVA), or SaaS solution. In the scenario, we have a network topology that spans a single region. There’s one Virtual WAN with a single hub located in the Region. The Hub has its own instance of an Azure Firewall deployed, essentially making it a Secure Virtual WAN Hub. Having a Secure Virtual WAN hub is a technical prerequisite to Routing Intent. The Secure Virtual WAN Hub has Routing Intent enabled.
The single region also has an Azure VMware Solution Private Cloud and an Azure Virtual Network. There’s also an on-premises site connecting to the region, which we review in more detail later in this document.
Note
If you’re using non-RFC1918 prefixes in your connected on-premises, Virtual Networks or Azure VMware Solution, make sure you have specified those prefixes in the “Private Traffic Prefixes” text box for Routing Intent. Keep in mind that you should always enter summarized routes only in the “Private Traffic Prefixes” section to cover your range. Do not input the exact range that is being advertised to Virtual WAN as this can lead to routing issues. For example, if the ExpressRoute Circuit is advertising 40.0.0.0/24 from on-premises, put a /23 CIDR range or larger in the Private Traffic Prefix text box (example: 40.0.0.0/23). – see Configure routing intent and policies through Virtual WAN portal
Note
When configuring Azure VMware Solution with Secure Virtual WAN Hubs, ensure optimal routing results on the hub by setting the Hub Routing Preference option to “AS Path.” – see Virtual hub routing preference
Understanding Topology Connectivity
Connection
Description
Connections (D)
Azure VMware Solution private cloud managed ExpressRoute connection to the hub.
Connections (E)
on-premises ExpressRoute connection to the hub.
The following sections cover traffic flows and connectivity for Azure VMware Solution, on-premises, Azure Virtual Networks, and the Internet.
This section focuses on only the Azure VMware Solution private cloud. The Azure VMware Solution private cloud has an ExpressRoute connection to the hub (connections labeled as “D”).
With ExpressRoute to ExpressRoute transitivity enabled on the Secure Hub and Routing-Intent enabled, the Secure Hub sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to Azure VMware Solution over connection “D”. In addition to the default RFC 1918 addresses, Azure VMware Solution learns more specific routes from Azure Virtual Networks and Branch Networks (S2S VPN, P2S VPN, SDWAN) that are connected to the hub. Azure VMware Solution doesn’t learn specific routes from on-premises networks. For routing traffic back to on-premises networks, it uses the default RFC 1918 addresses that it learned from connection “D”. This traffic transits through the Hub firewall, as shown in the diagram. The Hub firewall has the specific routes for on-premises networks and routes traffic toward the destination over connection “E”. Traffic from Azure VMware Solution, heading towards Virtual Networks, will transit the Hub firewall. For more information, see the traffic flow section.
The diagram illustrates traffic flows from the perspective of the Azure VMware Solution Private Cloud.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN Hub firewall?
1
Azure VMware Solution Cloud
→
Virtual Network
Yes, traffic is inspected at the Hub firewall
2
Azure VMware Solution Cloud
→
on-premises
Yes, traffic is inspected at the Hub firewall
This section focuses only on the on-premises site. As shown in the diagram, the on-premises site has an ExpressRoute connection to the hub (connection labeled as “E”).
With ExpressRoute to ExpressRoute transitivity enabled on the Secure Hub and Routing-Intent enabled, the Secure Hub sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to on-premises over connection “E”. In addition to the default RFC 1918 addresses, on-premises learns more specific routes from Azure Virtual Networks and Branch Networks (S2S VPN, P2S VPN, SDWAN) that are connected to the hub. On-premises doesn’t learn specific routes from Azure VMware Solution networks. For routing traffic back to Azure VMware Solution networks, it uses the default RFC 1918 addresses that it learned from connection “E”. This traffic transits through the Hub firewall, as shown in the diagram. The Hub firewall has the specific routes for Azure VMware Solution networks and routes traffic toward the destination over connection “D”. Traffic from on-premises, heading towards Virtual Networks, will transit the Hub firewall. For more information, see the traffic flow section for more detailed information.
As mentioned earlier, when you enable ExpressRoute to ExpressRoute transitivity on the Hub, it sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to your on-premises network. Therefore, you shouldn’t advertise the exact RFC 1918 prefixes (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) back to Azure. Advertising the same exact routes creates routing problems within Azure. Instead, you should advertise more specific routes back to Azure for your on-premises networks.
Note
If you’re currently advertising the default RFC 1918 addresses from on-premises to Azure and wish to continue this practice, you need to split each RFC 1918 range into two equal sub-ranges and advertise these sub-ranges back to Azure. The sub-ranges are 10.0.0.0/9, 10.128.0.0/9, 172.16.0.0/13, 172.24.0.0/13, 192.168.0.0/17, and 192.168.128.0/17.
The diagram illustrates traffic flows from the perspective of on-premises.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN Hub firewall?
3
on-premises
→
Azure VMware Solution Cloud
Yes, traffic is inspected at the Hub firewall
4
on-premises
→
Virtual Network
Yes, traffic is inspected at the Hub firewall
This section focuses only on connectivity from an Azure Virtual Network perspective. As depicted in the diagram, the Virtual Network has a Virtual Network peering directly to the hub.
The diagram illustrates how all Azure native resources in the Virtual Network learn routes under their “Effective Routes”. A Secure Hub with Routing Intent enabled always sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to peered Virtual Networks. Azure native resources in the Virtual Network don’t learn specific routes from outside of their Virtual Network. With Routing Intent enabled, all resources in the Virtual Network currently possess the default RFC 1918 address and use the hub firewall as the next hop. All traffic ingressing and egressing the Virtual Networks will always transit the Hub Firewall. For more information, see the traffic flow section for more detailed information.
The diagram illustrates traffic flows from an Azure Virtual Network perspective.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN Hub firewall?
5
Virtual Network
→
Azure VMware Solution Cloud
Yes, traffic is inspected at the Hub firewall
6
Virtual Network
→
on-premises
Yes, traffic is inspected at the Hub firewall
This section focuses only on how internet connectivity is provided for Azure native resources in Virtual Networks and Azure VMware Solution Private Clouds in a single region. There are several options to provide internet connectivity to Azure VMware Solution. – see Internet Access Concepts for Azure VMware Solution
Option 1: Internet Service hosted in Azure
Option 2: VMware Solution Managed SNAT
Option 3: Azure Public IPv4 address to NSX-T Data Center Edge
Although you can use all three options with Single Region Secure Virtual WAN with Routing Intent, “Option 1: Internet Service hosted in Azure” is the best option when using Secure Virtual WAN with Routing Intent and is the option that is used to provide internet connectivity in the scenario. The reason why “Option 1” is considered the best option with Secure Virtual WAN is due to its ease of security inspection, deployment, and manageability.
As mentioned earlier, when you enable Routing Intent on the Secure Hub, it advertises RFC 1918 to all peered Virtual Networks. However, you can also advertise a default route 0.0.0.0/0 for internet connectivity to downstream resources. With Routing Intent, you can choose to generate a default route from the hub firewall. This default route is advertised to your Virtual Network and to Azure VMware Solution. This section is broken into two sections, one that explains internet connectivity from an Azure VMware Solution perspective and another from the Virtual Network perspective.
When Routing Intent is enabled for internet traffic, the default behavior of the Secure Virtual WAN Hub is to not advertise the default route across ExpressRoute circuits. To ensure the default route is propagated to the Azure VMware Solution from the Azure Virtual WAN, you must enable default route propagation on your Azure VMware Solution ExpressRoute circuits – see To advertise default route 0.0.0.0/0 to endpoints. Once changes are complete, the default route 0.0.0.0/0 is then advertised via connection “D” from the hub. It’s important to note that this setting shouldn’t be enabled for on-premises ExpressRoute circuits. As a best practice, it’s recommended to implement a BGP Filter on your on-premises equipment. A BGP Filter in place prevents the inadvertent learning of the default route, adds an extra layer of precaution, and ensures that on-premises internet connectivity isn’t impacted.
When Routing Intent for internet access is enabled, the default route generated from the Secure Virtual WAN Hub is automatically advertised to the hub-peered Virtual Network connections. You’ll notice under Effective Routes for the Virtual Machines’ NICs in the Virtual Network that the 0.0.0.0/0 next hop is the hub firewall.
For more information, see the traffic flow section.
The diagram illustrates traffic flows from a Virtual Network and Azure VMware Solution perspective.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN hub firewall?
7
Virtual Network
→
Internet
Yes, traffic is inspected at the Hub firewall
8
Azure VMware Solution Cloud
→
Internet
Yes, traffic is inspected at the Hub firewall
HCX Mobility Optimized Networking (MON) is an optional feature to enable when using HCX Network Extensions (NE). Mobility Optimized Networking (MON) provides optimal traffic routing under certain scenarios to prevent network tromboning between the on-premises-based and cloud-based resources on extended networks.
Enabling Mobility Optimized Networking (MON) for a specific extended network and a virtual machine changes the traffic flow. After implementing Mobility Optimized Networking (MON), egress traffic from that virtual machine does not trombone back to on-premises. Instead, it bypasses the Network Extensions (NE) IPSEC tunnel. Traffic for that virtual machine will now egress out of the Azure VMware Solution NSX-T Tier-1 Gateway> NSX-T Tier-0 Gateway>Azure Virtual WAN.
Enabling Mobility Optimized Networking (MON) for a specific extended network and a virtual machine results in a change. From Azure VMware Solution NSX-T, it injects a /32 host route back to Azure Virtual WAN. Azure Virtual WAN advertises this /32 route back to on-premises, Virtual Networks, and Branch Networks (S2S VPN, P2S VPN, SDWAN). The purpose of this /32 host route is to ensure that traffic from on-premises, Virtual Networks, and Branch Networks doesn’t use the Network Extensions (NE) IPSEC tunnel when destined for the Mobility Optimized Networking (MON) enabled Virtual Machine. Traffic from source networks is directed straight to the Mobility Optimized Networking (MON) enabled Virtual Machine due to the /32 route that is learned.
With ExpressRoute to ExpressRoute transitivity enabled on the Secure Hub and Routing-Intent enabled, the Secure Hub sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to both the on-premises and Azure VMware Solution. In addition to the default RFC 1918 addresses, both on-premises and Azure VMware Solution learn more specific routes from Azure Virtual Networks and Branch Networks (S2S VPN, P2S VPN, SDWAN) that are connected to the hub. However, on-premises networks don’t learn any specific routes from the Azure VMware Solution, nor does the reverse occur. Instead, both environments rely on the default RFC 1918 addresses to facilitate routing back to one another via the Hub firewall. This means that more specific routes, such as HCX Mobility Optimized Networking (MON) Host Routes, aren’t advertised from the Azure VMware Solution ExpressRoute to the on-premises-based ExpressRoute circuit and vice-versa. The inability to learn specific routes introduces asymmetric traffic flows. Traffic egresses Azure VMware Solution via the NSX-T Tier-0 gateway, but returning traffic from on-premises returns over the Network Extensions (NE) IPSEC tunnel.
To correct any traffic asymmetry, you need to adjust the HCX Mobility Optimized Networking (MON) Policy Routes. Mobility Optimized Networking (MON) policy routes determine which traffic goes back to the on-premises Gateway via an L2 extension. They also decide which traffic is routed through the Azure VMware Solution NSX Tier-0 Gateway.
If a destination IP matches and is set to “allow” in the Mobility Optimized Networking (MON) policy configuration, then two actions occur. First, the packet is identified. Second, it’s sent to the on-premises gateway through the HCX Network Extension appliance.
If a destination IP doesn’t match, or is set to “deny” in the Mobility Optimized Networking (MON) policy, the system sends the packet to the Azure VMware Solution Tier-0 for routing.
HCX Policy Routes
Network
Redirect to Peer
Note
Azure Virtual Network Address Space
Deny
Please ensure to explicitly include the address ranges for all your Virtual Networks. Traffic intended for Azure is directed out via the Azure VMware Solution and doesn’t return to the on-premises network.
Default RFC 1918 Address Spaces
Allow
Add in the default RFC 1918 addresses 10.0.0.0/8, 172.16.0.0/12, and 192.168.0.0/16. This configuration ensures that any traffic not matching the above criteria is rerouted back to the on-premises network. If your on-premises setup utilizes addresses that aren’t part of RFC 1918, you must explicitly include those ranges.
0.0.0.0/0
Deny
For addresses that aren’t covered by RFC 1918, such as Internet-routable IPs, or any traffic that doesn’t match the specified entries above, exits directly through the Azure VMware Solution and isn’t redirected back to the on-premises network.
For more information on Virtual WAN hub configuration, see About virtual hub settings.
For more information on how to configure Azure Firewall in a Virtual Hub, see Configure Azure Firewall in a Virtual WAN hub.
For more information on how to configure the Palo Alto Next Generation SAAS firewall on Virtual WAN, see Configure Palo Alto Networks Cloud NGFW in Virtual WAN.
For more information on Virtual WAN hub routing intent configuration, see Configure routing intent and policies through Virtual WAN portal.
Microsoft Tech Community – Latest Blogs –Read More
How to fix QuickBook Error 12007 after update?
How can I resolve QuickBook Error 12007? I encounter this error during software updates, and it seems to be related to network issues. What are the steps to troubleshoot and fix this problem?
How can I resolve QuickBook Error 12007? I encounter this error during software updates, and it seems to be related to network issues. What are the steps to troubleshoot and fix this problem? Read More
autofill column only when data are added
I have a column (Column C) that calculates a formula based on the entry in another column (Column B). The spreadsheet will be used by other users. The issue is that I do not know how many entries any particular user will have. They may have 20 or they may have 200 or they may have 2000. I do not want to autofill the entire column with the formula because (a) it slows everything down, (b) it is ugly/not user-friendly (displaying #DIV/0! until the column it needs is filled, and (c) it can actually end up affecting the results. I’ve seen another sheet that does the same thing. For example, there are 22 entries right now. Cell B24 and C24 are currently blank – no formula is showing for cell C24. If I add a number to B24, then C24 auto-populates the formula and calculates it. I cannot figure out how to make my spreadsheet do that, despite much searching and exploration. I’ve tried various fill options, an arrayfunction, a table, and I haven’t yet found a solution that work. Any help is appreciated!
I have a column (Column C) that calculates a formula based on the entry in another column (Column B). The spreadsheet will be used by other users. The issue is that I do not know how many entries any particular user will have. They may have 20 or they may have 200 or they may have 2000. I do not want to autofill the entire column with the formula because (a) it slows everything down, (b) it is ugly/not user-friendly (displaying #DIV/0! until the column it needs is filled, and (c) it can actually end up affecting the results. I’ve seen another sheet that does the same thing. For example, there are 22 entries right now. Cell B24 and C24 are currently blank – no formula is showing for cell C24. If I add a number to B24, then C24 auto-populates the formula and calculates it. I cannot figure out how to make my spreadsheet do that, despite much searching and exploration. I’ve tried various fill options, an arrayfunction, a table, and I haven’t yet found a solution that work. Any help is appreciated! Read More
Is there any data on how much energy does the power saving settings achieve?
I’m working on a emission footprint reduction project and one topic that came to mind was about the power saving recommendations from Windows.
I’ve tried to gather data on the percentages but with no success.
Does anyone have any firm and reliable info on that?
Thank you.
I’m working on a emission footprint reduction project and one topic that came to mind was about the power saving recommendations from Windows. I’ve tried to gather data on the percentages but with no success. Does anyone have any firm and reliable info on that? Thank you. Read More
Accessing Web Content – Consistent Login Requests
Hi all
Hope you are well and can maybe understand this one.
In my workplace, I have a master spreadsheet that needs to be “queried” from another spreadsheet.
The way I gone about this is using the “web content” function.
The master spreadsheet is located on my OneDrive and I have shared / allowed access to all my colleagues who need to access the data via another spreadsheet.
I have then in the end user spreadsheet made a data connection to the Sharepoint URL of the master spreadsheet. All the relevant sheets are imported and updated perfectly upon opening.
However, despite me setting the web content method as “Organizational Account”, randomly and frequently the attached error is being shown to my colleagues when opening the end user spreadsheet.
They then have to click “Organizational account” > “Sign in” > Connect.
This works most of the time, other times it just refuses and repeats the message attached.
Is there a better way of linking my OneDrive master spreadsheet to the end user one? Or is there any advice on how to fix this error? Changing the “level to apply settings to” sometimes works, other times does not. I am unsure why excel is constantly not being able to access my OneDrive master file.
Your support would be most appreciated
Thanks
Matt
Hi allHope you are well and can maybe understand this one. In my workplace, I have a master spreadsheet that needs to be “queried” from another spreadsheet. The way I gone about this is using the “web content” function. The master spreadsheet is located on my OneDrive and I have shared / allowed access to all my colleagues who need to access the data via another spreadsheet. I have then in the end user spreadsheet made a data connection to the Sharepoint URL of the master spreadsheet. All the relevant sheets are imported and updated perfectly upon opening. However, despite me setting the web content method as “Organizational Account”, randomly and frequently the attached error is being shown to my colleagues when opening the end user spreadsheet.They then have to click “Organizational account” > “Sign in” > Connect.This works most of the time, other times it just refuses and repeats the message attached. Is there a better way of linking my OneDrive master spreadsheet to the end user one? Or is there any advice on how to fix this error? Changing the “level to apply settings to” sometimes works, other times does not. I am unsure why excel is constantly not being able to access my OneDrive master file. Your support would be most appreciated Thanks Matt Read More
Microsoft AVD Authentication Timeout
Is there some sort of microsoft timeout for login.microsoftonline.com where the token expires? We’re utilizing Dell ThinOS thin clients and in WMS I have the broker set to Azure AVD.
When this is applied to the thin client, immediately a microsoft login box pops up over the Dell Login UI. If no user enters credentials in that login window for a while (I believe it’s 30-60min), the next person who tries to login receives the following message “Sorry, your sign-in timed out. Please sign in again.” It doesn’t say the credentials are invalid (because they aren’t) it just doesn’t successfully authenticate. At this point it does show our tenants custom background..
At that point the user can type their credentials in again and it successfully authenticates them. My worry is that we’ll have this happen to the first user who logs into each thin client every single morning and throughout the day as the thin clients set idle.
There aren’t many options you can set for the Azure broker. I was wondering if anyone else has come across this and has a potential solution? Something to note is I’m also experiencing this from a web browser outside of utilizing a thin client across different tenants.
Is there some sort of microsoft timeout for login.microsoftonline.com where the token expires? We’re utilizing Dell ThinOS thin clients and in WMS I have the broker set to Azure AVD. When this is applied to the thin client, immediately a microsoft login box pops up over the Dell Login UI. If no user enters credentials in that login window for a while (I believe it’s 30-60min), the next person who tries to login receives the following message “Sorry, your sign-in timed out. Please sign in again.” It doesn’t say the credentials are invalid (because they aren’t) it just doesn’t successfully authenticate. At this point it does show our tenants custom background.. At that point the user can type their credentials in again and it successfully authenticates them. My worry is that we’ll have this happen to the first user who logs into each thin client every single morning and throughout the day as the thin clients set idle. There aren’t many options you can set for the Azure broker. I was wondering if anyone else has come across this and has a potential solution? Something to note is I’m also experiencing this from a web browser outside of utilizing a thin client across different tenants. Read More
