Category: News

Power Query losing Columns

/ 2024-08-20

Hello there,

I have a problem importing some folders into power query. The interesting part is the different files in said folder seem to have a varying amount of columns – and power query only loads the columns that are in the example file.

I tried this twice, one set of data is a folder of PDFs. I choose the right page to extract and find out power query has only loaded the columns as in the example file – but i can load the others with some steps (picture):

The other set is a folder with CSVs. I try replicating the exact steps here, but Power Query does not load the additional column – if I refuse to choose an example file that has all columns already. If I want to automate said steps I can’t choose a fitting file every time, my only option is to accept Excel losing a column of data. Is there any way of preventing this? Thanks in advance.

Hello there, I have a problem importing some folders into power query. The interesting part is the different files in said folder seem to have a varying amount of columns – and power query only loads the columns that are in the example file. I tried this twice, one set of data is a folder of PDFs. I choose the right page to extract and find out power query has only loaded the columns as in the example file – but i can load the others with some steps (picture): The other set is a folder with CSVs. I try replicating the exact steps here, but Power Query does not load the additional column – if I refuse to choose an example file that has all columns already. If I want to automate said steps I can’t choose a fitting file every time, my only option is to accept Excel losing a column of data. Is there any way of preventing this? Thanks in advance. Read More

Microsoft

Create a New HTTPS Website in IIS using PowerShell script

/ 2024-08-20

HTTPS site on IIS

Creating a new HTTPS website in IIS using PowerShell can streamline your deployment process and ensure your site is secure from the start. In this blog, we will cover all the prerequisites, provide the necessary script, explain the steps to run the script, discuss the extensions to save the script, suggest any required modifications, and offer troubleshooting tips in case of failure.

Prerequisites

Before you begin, ensure you have the following prerequisites in place:

Windows Server with IIS installed
PowerShell version 5.1 or later
Administrator access to the server
SSL certificate (either self-signed for testing or a valid certificate from a trusted CA) else you can create a new certificate as well

The PowerShell Script

Here is a PowerShell script to create a new HTTPS website in IIS:

$siteName = “NewWebsite”
$sitePath = “C:inetpubwwwrootNewWebsite”
$bindingInformation = “*:443:”
$certificateThumbprint = “3a210b86a45e3bb20147de366197621fe9d2020d”
$certStoreLocation = “Cert:LocalMachineMy”

# Import the WebAdministration module
Import-Module WebAdministration

# Create the website directory if it doesn’t exist
if (-Not (Test-Path $sitePath)) {
New-Item -Path $sitePath -ItemType Directory
}

# Create the new website
New-IISSite -Name $siteName -PhysicalPath $sitePath -BindingInformation $bindingInformation -CertificateThumbPrint $certificateThumbprint -CertStoreLocation $certStoreLocation -Protocol https

# Verify the website creation
Get-IISSite -Name $siteName

Make sure to replace “YOUR_CERTIFICATE_THUMBPRINT” with the actual thumbprint of your certificate. You can find the thumbprint in the certificate details in the Certificates MMC snap-in.

Steps to Run the Script

Follow these steps to execute the script:

Open PowerShell as an Administrator.
Copy the script into a new file.
Replace the placeholder values (e.g., `YOUR_CERT_THUMBPRINT`) with actual values.
Save the script with a `.ps1` extension (e.g., `CreateHttpsSite.ps1`).
Navigate to the directory containing the script.
Run the script using the command:

.CreateHttpsSite.ps1

Extensions to Save the Script

PowerShell scripts should be saved with a `.ps1` extension. This denotes a PowerShell script file and allows it to be executed within the PowerShell environment.

Modifications Required

Based on your specific needs, you may need to modify the script:

Site Name: Change the `$siteName` variable to your desired site name.
Site Path: Update the `$sitePath` variable to the location of your website files.
Certificate Thumbprint: Replace `YOUR_CERT_THUMBPRINT` with the actual thumbprint of your SSL certificate.
Application Pool: Modify the `$appPool` variable if you wish to use a different application pool.

Create a Self-signed Certificate

# Create a self-signed certificate
$cert = New-SelfSignedCertificate -DnsName “yourdomain.com” -CertStoreLocation “Cert:LocalMachineMy”

# Add the certificate to the Trusted Root Certification Authorities store
$DestStore = New-Object System.Security.Cryptography.X509Certificates.X509Store([System.Security.Cryptography.X509Certificates.StoreName]::Root, “LocalMachine”)
$DestStore.Open([System.Security.Cryptography.X509Certificates.OpenFlags]::ReadWrite)
$DestStore.Add($cert)
$DestStore.Close()

# Use the thumbprint of the newly created certificate
$certificateThumbprint = $cert.Thumbprint

Advantages of using Powershell Script to create a website in IIS

Automation: PowerShell scripts allow you to automate the entire process, reducing the need for manual configuration. This is especially useful when setting up multiple websites or environments.

Consistency: Scripts ensure that each website is configured exactly the same way, minimizing human error and ensuring consistency across different environments.

Efficiency: Creating websites via PowerShell is much faster than using the IIS Manager GUI, saving time and effort.

Repeatability: Once you have a script, you can reuse it to set up new websites quickly, making it easy to replicate configurations across different servers or environments.

Scalability: PowerShell scripts can be integrated into larger automation frameworks, allowing for scalable deployment and management of web applications.

Flexibility: PowerShell provides a wide range of cmdlets and modules for managing IIS, giving you the flexibility to customize and extend your scripts as needed.

Version Control: Scripts can be stored in version control systems like Git, allowing you to track changes, collaborate with others, and roll back to previous versions if needed.

Documentation: Scripts serve as documentation for your setup process, making it easier for others to understand and replicate your configurations.

Troubleshooting in Case of Failure

If you encounter issues, here are some troubleshooting tips:

Permission Errors: Ensure you are running PowerShell as an Administrator.
Invalid Certificate Thumbprint: Double-check the thumbprint value. It must be the exact thumbprint of your SSL certificate.
Site Already Exists: Verify that the site name is not already in use in IIS. You can list all sites using:

Get-Website
Binding Conflicts: Ensure no other site is using the same IP address and port combination. Check current bindings with:

Get-WebBinding
Script Syntax Errors: Review the script for any syntax errors. PowerShell will often provide details on the line number and error type.

Conclusion

Using PowerShell to create a new HTTPS website in IIS can greatly simplify the process and ensure consistency across your deployments. By following this guide, you should be able to set up your site quickly and efficiently.

Remember to always test your setup in a development environment before deploying it to production.

Microsoft Tech Community – Latest Blogs –Read More

Microsoft

Client-Side Compute: A Greener Approach to Natural Language Data Queries

/ 2024-08-20

Introduction

Using natural language to interact with data can significantly enhance our ability to work with and understand information, making data more accessible and useful for everyone. Considering the latest advances in large language models (LLMs), it seems like the obvious solution. However, while we’ve made strides in interacting with unstructured data using NLP and AI, structured data interaction still poses challenges. Using LLMs to convert natural language into domain-specific languages like SQL is a common and valid use case, showcasing a strong capability of these models. This blog identifies the limitations of current solutions and introduces novel, energy-efficient approaches to enhance efficiency and flexibility.

My team focuses on ISVs and how each design decision impacts them. For example, if the ISV needs to allow “chat with data” as a solution, they must also address the challenges of hosting, monetizing, and securing these features. We present two key strategies:

Leveraging deterministic tools to execute the domain-specific language on the appropriate systems and
Offloading compute to client devices.

These strategies not only improve performance and scalability but also reduce server load, making them ideal for ISVs looking to provide seamless and sustainable data access to their customers.

The Challenge: Efficiently Interacting with Structured Data

Structured data, typically stored in databases, structured files, and spreadsheets, is the backbone of business intelligence and analytics. However, querying and extracting insights from this data often requires knowledge of specific query languages like SQL, creating a barrier for many users. Additionally, ISVs face the challenge of anticipating the diverse ways their customers want to interact with their data. Due to increasing customer demand for natural language interfaces to simplify and intuitively access their data, ISVs are pressured to develop solutions that bridge the gap between users and the structured data they need to interact with.

While using LLMs to convert natural language queries into domain-specific languages such as SQL is a powerful capability, it alone doesn’t solve the problem. The next step is to execute these queries efficiently on the appropriate systems. Implementing such a solution must include several fundamental guardrails to ensure the generated SQL is safe to execute. Moreover, there is the additional challenge of managing the computational load. Hosting these capabilities on ISV servers can be resource-intensive and costly.

Therefore, an effective solution must not only translate natural language into executable queries but also optimize how these queries are processed. This involves leveraging deterministic tools to execute domain-specific languages and offloading compute tasks to client devices. By doing so, ISVs can provide more efficient, scalable, and cost-effective data interaction solutions to their customers.

A Common Use Case

An ISV collects data from various sources, some public and most from its customers (or tenants). These tenants could come from various industries such as retail, healthcare, and finance, each requiring tailored data solutions. The ISV implements a medallion pattern for data ingestion, a design pattern that organizes data into layers (bronze, silver, and gold) to ensure data quality and accessibility. In this pattern, raw data is ingested into the bronze layer, cleaned and enriched into the silver layer, and then aggregated into the gold layer for analysis. The gold tables, containing the aggregated data, are generally smaller than 20MB per tenant.

The data ingestion pipeline runs periodically, populating the gold tables hosted on Azure SQL Database. Data isolation is managed using row-level security or multiple schemas, tailored to the ISV’s requirements. The next step for the ISV is to provide access for its tenants to the data through a web application, leveraging homegrown dashboards and reporting capabilities. Often, these ISVs are small companies that do not have the resources to implement a full Business Continuity and Disaster Recovery (BCDR) approach or afford paid tools like Power BI, and thus rely on homegrown or free packages.

Despite having a robust infrastructure, the ISV faces several challenges:

Complex Query Language: Users often struggle with the complexity of SQL or other query languages required to extract insights from the data. This creates a barrier to effective data utilization.
Performance and Scalability: The server load increases significantly with complex queries, especially when multiple tenants access the data simultaneously. This can lead to performance bottlenecks and scalability issues.
Cost and Resource Management: Hosting the necessary computational resources to handle data queries on the ISV’s servers is resource-intensive and costly. This includes maintaining high-performance databases and application servers.
User Experience: Customers increasingly demand the ability to interact with their data using natural language, expecting a seamless and intuitive user experience.

For more detailed information on the medallion pattern, you can refer to this link.

The architecture diagram above illustrates the current setup:

Data Sources: Public sources and tenant data are ingested into the system.
Storage: The data lake (or lake house) process the data from multiple sources, perform cleansing, and store the data in the gold tables periodically.
Orchestrator: Orchestrating ELT/ETL is done using Azure Fabric/Synapse or Azure Data Factory pipelines.
Serving: The web application is hosted on Azure App Service, the data is queried using Azure SQL Database.
Visualize: Data is reported using Power BI or other reporting tools, including home grown dashboards.

Enhanced Approach: Energy-Efficient Data Interaction

To address the challenges mentioned earlier, the ISV can adopt the following strategies:

Leveraging Deterministic Tools for Query Execution:

Translation: Utilize LLMs to convert natural language queries into SQL.
Execution: Create a sandbox environment for each customer’s data. This sandbox is hosted on lower-cost storage, such as a storage container per customer, which contains a snapshot of the data they can interact with.
Data Management: The same data ingestion pipeline that updates the gold table in Azure SQL is adapted to update a customer-specific data set stored in their respective storage container. The idea is to use SQLite to store the customer-specific data, ensuring it is lightweight and portable.
Benefits:

Efficiency and Security: Ensures that queries are executed efficiently and securely, leveraging the robust capabilities of SQL databases while minimizing risks. By isolating each customer’s data in a sandbox, the need for sophisticated guardrails against bad queries and overloading the reporting database is significantly reduced.
Cost & Energy Savings: No need to manage or host a dedicated reporting database. Since the customer-specific data is hosted on Azure storage containers, the ISV avoids the costs and energy consumption associated with maintaining high-performance database infrastructure.
Scalability and Reliability: The ISV does not need to plan for the worst-case scenario of all customers running queries simultaneously, which could impact the health of a centralized reporting database. Each customer’s queries are isolated to their data, ensuring system stability and performance.

Offloading Compute to Client Devices:

Data Transmission: The client-side application ensures it has the current data snapshot available for the customer to work with. For example, it can check the data’s timestamp or use another method to verify if the local data is up-to-date and download the latest version if necessary. This snapshot is encapsulated in portable formats like JSON, SQLite, or Parquet.
Local Processing: The client-side application processes the data locally using the translated SQL queries.
Benefits:

Performance: Reduces server load, enhances scalability, and provides faster query responses by utilizing the client’s computational resources.
Cost & Energy Savings: Significant cost savings by reducing the need for high-performance server infrastructure. Hosting a static website and leveraging client devices’ processing power also reduces overall energy consumption.
Flexibility: Ensures that customers always work with the most current data without the need for constant server communication.

Revised Architecture

Data Sources: Public sources and tenant data are ingested into the system.
Storage: The data lake (or lake house) process the data from multiple sources, perform cleansing, and store the data in customer specific containers. This enhances security and isolation.
Orchestrator: Orchestrating ELT/ETL is done using Azure Fabric/Synapse or Azure Data Factory pipelines.

The above components are hosted in the ISV’s infrastructure.

The client side web application will pull the data from the customer specific containers and process the data locally. Please visit our Azure OpenAI .NET Starter Kit for further reading and understanding – focus on the 07_ChatWithJson and 08_ChatWithData notebooks.

Why This Approach?

Efficiency: Data queries are executed locally, reducing the load on the server and improving performance.
Security: Data is securely isolated within a client-side sandbox, ensuring customers can only query what is provided.
Cost & Energy Saving: Hosting a static website is significantly cheaper and more energy-efficient than hosting a web application with a database. This approach leverages the processing power of client devices, further reducing infrastructure costs and energy consumption.
Scalability: By isolating each customer’s data in a sandbox, the ISV does not need to worry about the impact of simultaneous queries on a centralized database, ensuring system reliability and scalability.
Flexibility: Ensures that customers always have access to the most current data without the need for constant server communication.

Potential Downsides and Pitfalls

Client-Side Performance Variability: The approach relies on the computational power of client devices.
Data Synchronization: Ensuring that the local data snapshot on client devices is up-to-date can be challenging. Delays in synchronization could lead to users working with outdated data.

Conclusion

By adopting these strategies, ISVs can provide a more efficient, scalable, and cost-effective solution for natural language querying of structured data. Leveraging deterministic tools for executing domain-specific languages within isolated sandboxes ensures robust and secure query execution. Offloading compute to client devices not only reduces server load but also enhances performance and scalability, providing a seamless and intuitive user experience.

Microsoft Tech Community – Latest Blogs –Read More

Microsoft

IIS URL Rewrite Rule Not Working: Resolving ‘HTTP Error 404.4 – Not Found’ Issues.

/ 2024-08-20

Issue

Most of you have encountered situations where you have used IIS URL Rewrite to redirect traffic from one site to another. But in some cases, rewrite rules fail to work as expected and returns ‘HTTP Error 404.4 – Not Found’. The 404.4 status code means no handler configured. Which means the file name extension of the requested URL doesn’t have a handler that is configured to process the request on the Web server.

For example you have two sites hosted in IIS. Site1 bind with port 81 and Site2 bind with port 82. The requirement is to rewrite all the request coming to Site1 (port:81) should rewrite to Site2 (port:82). The below rule is configured –

<system.webServer>

<rules>

</rule>

</rules>

</rewrite>

</system.webServer>

Solution

First you need to check if the correct module is installed in IIS. To check this go to IIS Manager and open the Modules.

Within the Modules check if the correct URL Rewrite module is installed. You can get the latest IIS URL Rewrite module from this link

URL Rewrite : The Official Microsoft IIS Site

If the correct module is installed as highlighted above, the next thing you check the Failed Request Tracing logs for the request. And verify if the correct rule is invoked and it updates the URL to new one.

Here in this case you can see “RewriteToPort82” rule is invoked and it changed the request URL to http://loalhost:82/. Also verify if the HttpStatus=”404″ and HttpSubStatus=”4″.

To remediate the issue, go to IIS Manager, open Application Request Routing Cache module and open Server Proxy Settings form the right-hand Actions pane.

Within the Server Proxy Settings you will find an option to enable proxy. Check the Enable proxy checkbox and click apply form the right-hand Actions pane as pointed in the below picture.

After this you need to restart IIS. This should resolve the URL rewrite issue. To know more about URL rewrite in IIS you can follow this article – Using the URL Rewrite Module | Microsoft Learn

Microsoft Tech Community – Latest Blogs –Read More

Microsoft

Unleash the power and fun of learning with colorful Microsoft Education Quick Guides – Summer 2024

/ 2024-08-20

In the world of education, the integration of technology has transformed the way teaching and learning. For educators, it’s essential to keep pace with the latest tools and resources to enhance the student educational experience. Enter Heather Aird, a Microsoft Innovative Educator Expert (MIE Expert) from Scotland, who in June 2023, created an initial series of vibrant and user-friendly “Quick Guides” for Microsoft Education products. Now, Heather has created 5 new guides (Teams AI, Speaker Progress, Math Progress, Forms and Dyslexia Tools) and the total is up to 34 guides, broken out by category below. Microsoft has partnered with Heather to make these guides available around the world. With Heather’s PDF Quick Guides, teachers can effortlessly navigate the landscape of Microsoft Education tools and unleash their full potential in the classroom.

Heather’s Quick Guides alleviate this challenge by presenting information in a simple and easy-to-understand format. Each guide provides step-by-step instructions, accompanied by clear screenshots and diagrams, ensuring that even the least tech-savvy teacher can confidently navigate the tools.

A Treasure Trove of Microsoft Education Products
Microsoft Education offers a wealth of powerful tools that can transform classrooms into vibrant centers of learning. However, it sometimes can be overwhelming for teachers to explore and utilize the full potential of these resources. With Heather Aird’s Quick Guides, educators gain access to a treasure trove of insights into various Microsoft Education products. From Immersive Reader to Reflect, Translator to Speaker Coach and many more, Heather’s guides cover a range of tools and where to find them, unlocking endless possibilities for personalized and interactive learning experiences. Here is the full list, with more coming in the near future!

AI in EDU Tools

Copilot
AI-powered Reading Coach
Teams EDU AI features for Educators
Khanmigo

M365 Tools

Classwork in Teams
OneNote Class Notebook
OneNote Desktop
Word – modern updates
PowerPoint – modern updates
Forms
Loop
Stream
Minecraft EDU
Lens
Bookings
Editor
Planner
ToDo

Learning Accelerators

Reading Progress
Reading Insights
Speaker Progress
Speaker Coach
Search Progress
Search Coach
Math Progress
Math Solver
Reflect
Reflect and Well Being Insights

Inclusive and Accessibility

Dyslexia Tools
Immersive Reader
Reading Coach in Immersive Reader
Translator
Speech to Text
Live Captions

Fun and Engaging
Heather’s Microsoft Education Quick Guides instantly catch the eye with their vibrant colors and engaging design. Gone are the days of dull, text-heavy manuals. These visually stunning guides are a breath of fresh air in the world of educational resources. The clever use of colors not only captures attention but also sparks creativity and imagination, setting the stage for an exciting learning journey.

Printable Portability

One of the unique aspects of Heather’s Quick Guides is their printable PDF format. Teachers can easily print and carry these guides wherever they go, ensuring easy access to valuable information at any time. Whether you’re in the classroom, or attending professional development workshops, Heather’s Quick Guides are your trusty companions, ready to provide guidance and support whenever you need them.

Heather Aird’s EdTech “Quick Guides” are a game-changer for educators seeking to harness the power of Microsoft Education products in their classrooms. Through vibrant colors, simplicity, and comprehensive coverage of various tools, these guides empower teachers to embrace technology confidently. With Heather Aird’s Quick Guides, the integration of EdTech becomes an exciting journey of exploration, collaboration, and creativity, leading to enhanced student engagement and enriched learning experiences. So, grab your Quick Guides, embrace the possibilities, and let the transformative power of technology unfold in your classroom!

Mike Tholfsen
Group Product Manager
Microsoft Education

Microsoft Tech Community – Latest Blogs –Read More

Matlab

Issue with changing Xlabel in DensityScatterChart fucntion

/ 2024-08-20

Hi,
I am using DensityScatterChart() function to color code the data points based on the density.
Unfortunately, I couldn’t change the X label and colorbar, I inded tried the following
d.XLabel=’pixels’,’fontweight’,’bold’,’FontSize’,10,’Interpreter’,’latex’;
However, it prints only pixels without taking taking into acount the other font properties.
Actully my aim is to color code the data points in the scatter plot based on the desnity. Any other alternatives also appreciable.Hi,
I am using DensityScatterChart() function to color code the data points based on the density.
Unfortunately, I couldn’t change the X label and colorbar, I inded tried the following
d.XLabel=’pixels’,’fontweight’,’bold’,’FontSize’,10,’Interpreter’,’latex’;
However, it prints only pixels without taking taking into acount the other font properties.
Actully my aim is to color code the data points in the scatter plot based on the desnity. Any other alternatives also appreciable. Hi,
I am using DensityScatterChart() function to color code the data points based on the density.
Unfortunately, I couldn’t change the X label and colorbar, I inded tried the following
d.XLabel=’pixels’,’fontweight’,’bold’,’FontSize’,10,’Interpreter’,’latex’;
However, it prints only pixels without taking taking into acount the other font properties.
Actully my aim is to color code the data points in the scatter plot based on the desnity. Any other alternatives also appreciable. scatter plot, desnity scatter plot, color based on number density MATLAB Answers — New Questions

Matlab

How to filter out the noisy portion of contourf plot?

/ 2024-08-20

The code below shows a ´contourf´ plot

load(‘impdta.mat’)
[C,h] = contourf(x1,y1,ua, ‘ShowText’,’on’,FaceAlpha=0.3,EdgeAlpha=0.2,EdgeColor=’k’,LevelStep=10);
clabel(C,h,’FontSize’,7,’Color’,[0.6 0.6 0.6])
axis equal
In the above contour plot, the left side of the contour shows a smooth trend. I want to use this contour plot to interpolate to a value (say 60), which in current situation gives multiple ‘lines’ (marked in red). Is there a way the cluttered contours can be filtered out? An idea could be to use limits of x from zero to 600, but there are multiple plots in which this noncluttered area changes location and the limits cannot be simply applied. I would like to filter out the cluttered portion and left with the smooth contour lines only so that when I interpolate the value, only distinct contours can be extracted. I would appreciate if a solution can be attained.
hold on
contourf(x1,y1,ua, [60 60], ‘ShowText’,’on’,FaceAlpha=0,EdgeAlpha=0.5,EdgeColor=’r’);The code below shows a ´contourf´ plot

Microsoft

New Outlook auto-deletes Emails in Inbox when they are closed (MacOS)

/ 2024-08-20

UNDO does not bring the email back, so it is not a user action. There is a fundamental problem with the coding in MacOS Outlook. HOW CAN THIS GET FIXED before something seriously detrimental happens to my business?

If I close an email that I’m reading from my inbox, Outlook will auto-delete the email ON OCCASION. There is no rhyme or reason to its method, it occasionally just auto-deletes my email and I have to go and fish it out of the delete box (assuming I notice it). It’s amazingly annoying and has caused multiple problems, but microsoft ignores my emails about it (they’re probably auto-deleting). UNDO does not bring the email back, so it is not a user action. There is a fundamental problem with the coding in MacOS Outlook. HOW CAN THIS GET FIXED before something seriously detrimental happens to my business? Read More

Microsoft

Azure SQL Database

/ 2024-08-20

Hi, i currently have a Microsoft Access application that uses data, queries, forms, report and custom vb coding. I’m looking for a modern cloud solution that i can use to recreate my application and then be able to offer to my clients via web link.

Is Azure SQL database a reasonable tool for this high level requirement?

Microsoft

Security in the Era of AI: The Ultimate Skilling Guide | Ft. Copilot for Security

/ 2024-08-20

Download Link: Get Your Free Copy

Designed for Business Leaders and Security Professionals, this free eBook contains insights on how to keep your organization secure by building the skills to leverage the AI-powered Microsoft Security suite – including the latest Microsoft Copilot for Security.

This Ultimate Skilling Guide covers:

The Impact of AI on SecuritySkilling Guides by Microsoft Security Solution Use CasesProtect with AI (Microsoft Copilot for Security)Defend against Threats (Microsoft Defender, Sentinel, Copilot for Security)Secure your Data (Microsoft Purview, Copilot for Security)Secure Access (Microsoft Entra ID, Copilot for Security)Secure all your Clouds (Microsoft Defender)Manage Risks and Privacy (Microsoft Purview)Microsoft Security Training RoadmapEnterprise Training Solutions to upskill your team on Microsoft Security

Download Link: Get Your Free CopyDesigned for Business Leaders and Security Professionals, this free eBook contains insights on how to keep your organization secure by building the skills to leverage the AI-powered Microsoft Security suite – including the latest Microsoft Copilot for Security. This Ultimate Skilling Guide covers:The Impact of AI on SecuritySkilling Guides by Microsoft Security Solution Use CasesProtect with AI (Microsoft Copilot for Security)Defend against Threats (Microsoft Defender, Sentinel, Copilot for Security)Secure your Data (Microsoft Purview, Copilot for Security)Secure Access (Microsoft Entra ID, Copilot for Security)Secure all your Clouds (Microsoft Defender)Manage Risks and Privacy (Microsoft Purview)Microsoft Security Training RoadmapEnterprise Training Solutions to upskill your team on Microsoft Security Read More

Matlab

how can I increase the font size in the “help on selection” window to improve readability?

/ 2024-08-20

when I request help on selected command the "help on selection" opens a small window on screen with explanation but in small letters almost unreadable for me. How can I increase the fontsize on screen?when I request help on selected command the "help on selection" opens a small window on screen with explanation but in small letters almost unreadable for me. How can I increase the fontsize on screen? when I request help on selected command the "help on selection" opens a small window on screen with explanation but in small letters almost unreadable for me. How can I increase the fontsize on screen? help window, fontsize on screen MATLAB Answers — New Questions

Matlab

Extract cell rows to new array after strfind or strcmp matching.

/ 2024-08-20

Hi everyone,
I have an array of data (500*7) and the 7th column is a series of date array, they are all in random order so I would like to rearrange by month_array. So for each cell matching the portion of string ’01/2015′ i want a loop that extract the all rows (1:7) for example and store it in a new array etc.
I have included a picture to ease the understanding.

jan_table = [];
for i=1:size(ship_table);
idx = strfind(ship_table(i,7),’01/2015′);
if idx isequal(‘4’)
STORE ROW IN NEW ARRAY jan_table
else
jan_table = [jan_table num2cell(ships_table{i})];
end
end

If anyone could help, thanks!Hi everyone,
I have an array of data (500*7) and the 7th column is a series of date array, they are all in random order so I would like to rearrange by month_array. So for each cell matching the portion of string ’01/2015′ i want a loop that extract the all rows (1:7) for example and store it in a new array etc.
I have included a picture to ease the understanding.

If anyone could help, thanks! Hi everyone,
I have an array of data (500*7) and the 7th column is a series of date array, they are all in random order so I would like to rearrange by month_array. So for each cell matching the portion of string ’01/2015′ i want a loop that extract the all rows (1:7) for example and store it in a new array etc.
I have included a picture to ease the understanding.

If anyone could help, thanks! strfind, strcmp, extract cell to new array MATLAB Answers — New Questions

Matlab

Issues when exporting Creo Model with Simscape toolkit

/ 2024-08-20

Hello,
I went through the setup guide for enabling Simscape Multibody Plugin in Creo-Pro/E.
The issue that I’m running into is when I try to export, I receive an error saying that Matlab is not running as an automation server. I have ran Matlab as an Administrator and typed in: regmatlabserver and checked that it was enabled by running [s, msg] = regmatlabserver
What I’m noticing is that when I export, it creates a new matlab command window instance – Is this creating another automation server instance with default permissions?
Creo version: 8Hello,
I went through the setup guide for enabling Simscape Multibody Plugin in Creo-Pro/E.
The issue that I’m running into is when I try to export, I receive an error saying that Matlab is not running as an automation server. I have ran Matlab as an Administrator and typed in: regmatlabserver and checked that it was enabled by running [s, msg] = regmatlabserver
What I’m noticing is that when I export, it creates a new matlab command window instance – Is this creating another automation server instance with default permissions?
Creo version: 8 Hello,
I went through the setup guide for enabling Simscape Multibody Plugin in Creo-Pro/E.
The issue that I’m running into is when I try to export, I receive an error saying that Matlab is not running as an automation server. I have ran Matlab as an Administrator and typed in: regmatlabserver and checked that it was enabled by running [s, msg] = regmatlabserver
What I’m noticing is that when I export, it creates a new matlab command window instance – Is this creating another automation server instance with default permissions?
Creo version: 8 matlab, simscape, plugin, creo, issues MATLAB Answers — New Questions

Matlab

How to share a fully connected layer and is it possible to use a channel direction pooling?

/ 2024-08-20

(한국어로 답변주실 수 있다면 한국어로 답변 부탁드립니다.)
I am currently designing a model using the Deep Network Designer to implement a Convolutional Block Attention Module (CBAM).
For this, I need to use a channel-wise max/average pooling layer, and I am wondering if there is a way to implement this within MATLAB.
Additionally, I would like to know if there is a method to share a fully connected layer across different parts of the network. The current implementation of the fully connected layer seems to be limited to a single input and output.
Lastly, when passing through the fully connected layer, the dimension of the output is converted to (C x B). Is there a way to reshape this back to (S x S x C x B) in order to perform element-wise multiplication?(한국어로 답변주실 수 있다면 한국어로 답변 부탁드립니다.)
I am currently designing a model using the Deep Network Designer to implement a Convolutional Block Attention Module (CBAM).
For this, I need to use a channel-wise max/average pooling layer, and I am wondering if there is a way to implement this within MATLAB.
Additionally, I would like to know if there is a method to share a fully connected layer across different parts of the network. The current implementation of the fully connected layer seems to be limited to a single input and output.
Lastly, when passing through the fully connected layer, the dimension of the output is converted to (C x B). Is there a way to reshape this back to (S x S x C x B) in order to perform element-wise multiplication? (한국어로 답변주실 수 있다면 한국어로 답변 부탁드립니다.)
I am currently designing a model using the Deep Network Designer to implement a Convolutional Block Attention Module (CBAM).
For this, I need to use a channel-wise max/average pooling layer, and I am wondering if there is a way to implement this within MATLAB.
Additionally, I would like to know if there is a method to share a fully connected layer across different parts of the network. The current implementation of the fully connected layer seems to be limited to a single input and output.
Lastly, when passing through the fully connected layer, the dimension of the output is converted to (C x B). Is there a way to reshape this back to (S x S x C x B) in order to perform element-wise multiplication? deep learning, cbam, channel-wise pooling layer, reshape layer MATLAB Answers — New Questions

Microsoft

WinHTTP setup for microsoft entra hybrid join

/ 2024-08-20

Hello,

We are doing the configuration of Microsoft Entra hybrid join as per the following link:
https://learn.microsoft.com/en-us/entra/identity/devices/how-to-hybrid-join

Since we are using proxy (setup in Windows settings > Network & Internet > Proxy > Manuary proxy setup), we are required to use WinHTTP as a documented for Microsoft Entra hybrid join setup in the link: https://learn.microsoft.com/en-us/entra/identity/devices/how-to-hybrid-join#:~:text=If%20you%20don%27t%20use%20WPAD%2C%20you%20can%20configure%20WinHTTP%20proxy%20settings%20on%20your%20computer%20with%20a%20Group%20Policy%20Object%20(GPO)%20beginning%20with%20Windows%2010%201709.%20For%20more%20information%2C%20see%20WinHTTP%20Proxy%20Settings%20deployed%20by%20GPO.

It directs to another link on how to configure WinHTTP via GPO: https://learn.microsoft.com/en-us/archive/blogs/netgeeks/winhttp-proxy-settings-deployed-by-gpo

When i run this example command locally on a PC as follows,
netsh winhttp set proxy proxy.contoso.com:8080 “localhost;*.contoso.com”
this should set the proxy to “proxy.contoso.com:8080” and bypass the “localhost;*.contoso.com”.

I want to know whether we have to also bypass the microsoft links as mentioned in the network requirements in this link: https://learn.microsoft.com/en-us/entra/identity/devices/how-to-hybrid-join#network-connectivity-requirements:~:text=https%3A//enterpriseregistration.windows,federated%20domains)

Or we just need to bypass the local addresses of the network?

Please guide. Thanks.

Hello,We are doing the configuration of Microsoft Entra hybrid join as per the following link:https://learn.microsoft.com/en-us/entra/identity/devices/how-to-hybrid-joinSince we are using proxy (setup in Windows settings > Network & Internet > Proxy > Manuary proxy setup), we are required to use WinHTTP as a documented for Microsoft Entra hybrid join setup in the link: https://learn.microsoft.com/en-us/entra/identity/devices/how-to-hybrid-join#:~:text=If%20you%20don%27t%20use%20WPAD%2C%20you%20can%20configure%20WinHTTP%20proxy%20settings%20on%20your%20computer%20with%20a%20Group%20Policy%20Object%20(GPO)%20beginning%20with%20Windows%2010%201709.%20For%20more%20information%2C%20see%20WinHTTP%20Proxy%20Settings%20deployed%20by%20GPO.It directs to another link on how to configure WinHTTP via GPO: https://learn.microsoft.com/en-us/archive/blogs/netgeeks/winhttp-proxy-settings-deployed-by-gpoWhen i run this example command locally on a PC as follows,netsh winhttp set proxy proxy.contoso.com:8080 “localhost;*.contoso.com”this should set the proxy to “proxy.contoso.com:8080” and bypass the “localhost;*.contoso.com”.I want to know whether we have to also bypass the microsoft links as mentioned in the network requirements in this link: https://learn.microsoft.com/en-us/entra/identity/devices/how-to-hybrid-join#network-connectivity-requirements:~:text=https%3A//enterpriseregistration.windows,federated%20domains)Or we just need to bypass the local addresses of the network?Please guide. Thanks. Read More

Matlab

Estimation the parameters of a non-linear equation

/ 2024-08-20

The equation is P =(1-(1-q)*x*m)^(1/(1-q)), where P is probability and x is inter-event time (s), q and m are the parameters that need to be determined.
I have attached the excel file, column A is the ‘x’ value, column B is the value of ‘P’…So I need to determine the best possible q and m in a log-log plot (I have attached a plot in the excel file for your reference where blue line is the drawn plot (P_actual vs x) and orange one is the fitted plot after estimating the parameters (P_calculated vs x)…
There are 21115 values..so you have to first consider the data from 1 to 2000 (Group 1), calculate the q and m for this group..Then take the data from 2 to 20001 (Group 2), calculate the q and m for this group.. and so on..i.e., calculating the parameters for each and every group..U can also increase the group size, this is just an example.
Also, I don’t have much idea about the initial guess of the parameters…whenever i give the initial guess it never converges..still for your convenience this is the range 1 < q < 3..and 10 < m < 1000…But one thing is sure ‘q’ should always be more than 1..
Please help!!The equation is P =(1-(1-q)*x*m)^(1/(1-q)), where P is probability and x is inter-event time (s), q and m are the parameters that need to be determined.
I have attached the excel file, column A is the ‘x’ value, column B is the value of ‘P’…So I need to determine the best possible q and m in a log-log plot (I have attached a plot in the excel file for your reference where blue line is the drawn plot (P_actual vs x) and orange one is the fitted plot after estimating the parameters (P_calculated vs x)…
There are 21115 values..so you have to first consider the data from 1 to 2000 (Group 1), calculate the q and m for this group..Then take the data from 2 to 20001 (Group 2), calculate the q and m for this group.. and so on..i.e., calculating the parameters for each and every group..U can also increase the group size, this is just an example.
Also, I don’t have much idea about the initial guess of the parameters…whenever i give the initial guess it never converges..still for your convenience this is the range 1 < q < 3..and 10 < m < 1000…But one thing is sure ‘q’ should always be more than 1..
Please help!! The equation is P =(1-(1-q)*x*m)^(1/(1-q)), where P is probability and x is inter-event time (s), q and m are the parameters that need to be determined.
I have attached the excel file, column A is the ‘x’ value, column B is the value of ‘P’…So I need to determine the best possible q and m in a log-log plot (I have attached a plot in the excel file for your reference where blue line is the drawn plot (P_actual vs x) and orange one is the fitted plot after estimating the parameters (P_calculated vs x)…
There are 21115 values..so you have to first consider the data from 1 to 2000 (Group 1), calculate the q and m for this group..Then take the data from 2 to 20001 (Group 2), calculate the q and m for this group.. and so on..i.e., calculating the parameters for each and every group..U can also increase the group size, this is just an example.
Also, I don’t have much idea about the initial guess of the parameters…whenever i give the initial guess it never converges..still for your convenience this is the range 1 < q < 3..and 10 < m < 1000…But one thing is sure ‘q’ should always be more than 1..
Please help!! parameter estimation, maximum likelihood MATLAB Answers — New Questions

Matlab

How to create a S-function for targetlink generated code .

/ 2024-08-20

I tried legacy tool for generating S-function which I was able to do .
eg. when I have a function with input parameters and return type well defined there is no issue .
When the function looks like this==>int sum (int a, int b) inside sum.c.
But in Targetlink generated code the main function is a void function.
eg. void sum (void), where i am struggling to create S-Function.
Can you please let me know any workaround for the same.

Regards
SumitI tried legacy tool for generating S-function which I was able to do .
eg. when I have a function with input parameters and return type well defined there is no issue .
When the function looks like this==>int sum (int a, int b) inside sum.c.
But in Targetlink generated code the main function is a void function.
eg. void sum (void), where i am struggling to create S-Function.
Can you please let me know any workaround for the same.

Regards
Sumit I tried legacy tool for generating S-function which I was able to do .
eg. when I have a function with input parameters and return type well defined there is no issue .
When the function looks like this==>int sum (int a, int b) inside sum.c.
But in Targetlink generated code the main function is a void function.
eg. void sum (void), where i am struggling to create S-Function.
Can you please let me know any workaround for the same.

Regards
Sumit s-function creation for targetlink generated code MATLAB Answers — New Questions

Matlab

S-Function creation for Target link generated code

/ 2024-08-20

Hello Team,
I am creating on S-Function creation for Target Link generated codes.
I tried Legacy tool, but Legacy tool works well only when the input parameters and the return type are properly defined.
Example: When i have a function like==> double Sum( double a, double b).
Using def.OutputFcnSpec = ‘double y1 = doubleIt(double u1, double u2)’.

But Target Link generated code, the main function is Void.
Example: The function looks like this, Void Sum(Void), in Sum.c file.
Facing difficulty in creating S-Function for this.

Can you please suggest any work around for the above issue.

Regards
Santhosh AHello Team,
I am creating on S-Function creation for Target Link generated codes.
I tried Legacy tool, but Legacy tool works well only when the input parameters and the return type are properly defined.
Example: When i have a function like==> double Sum( double a, double b).
Using def.OutputFcnSpec = ‘double y1 = doubleIt(double u1, double u2)’.

But Target Link generated code, the main function is Void.
Example: The function looks like this, Void Sum(Void), in Sum.c file.
Facing difficulty in creating S-Function for this.

Can you please suggest any work around for the above issue.

Regards
Santhosh A Hello Team,
I am creating on S-Function creation for Target Link generated codes.
I tried Legacy tool, but Legacy tool works well only when the input parameters and the return type are properly defined.
Example: When i have a function like==> double Sum( double a, double b).
Using def.OutputFcnSpec = ‘double y1 = doubleIt(double u1, double u2)’.

But Target Link generated code, the main function is Void.
Example: The function looks like this, Void Sum(Void), in Sum.c file.
Facing difficulty in creating S-Function for this.

Can you please suggest any work around for the above issue.

Regards
Santhosh A s-function creation for target link generated code MATLAB Answers — New Questions

Microsoft

How to unlock windows 10 without password in an easy way?

/ 2024-08-20

Hi,

I have a backup Windows 10 PC that I’ve been locked out of because I can’t remember the password because it has been months since the last password change. I forgot to write the new password and already tried all passwords I could think of but no avail.

I’ve heard there might be ways to unlock Windows 10 without password, possibly using safe mode, command prompt, or even third-party tools, but I’m not entirely sure how to go about it. I’d appreciate any guidance or step-by-step instructions on how to regain access to my PC.

Thanks

Hi,I have a backup Windows 10 PC that I’ve been locked out of because I can’t remember the password because it has been months since the last password change. I forgot to write the new password and already tried all passwords I could think of but no avail. I’ve heard there might be ways to unlock Windows 10 without password, possibly using safe mode, command prompt, or even third-party tools, but I’m not entirely sure how to go about it. I’d appreciate any guidance or step-by-step instructions on how to regain access to my PC. Thanks Read More

Microsoft

Subsites

/ 2024-08-20

I’ve created quality management system in SharePoint comprising of different elements such as a document register, not conformance, customer satisfaction etc. I’ve created all these elements as subsites and have them in button format on the home page, however when I try and use power automate and enter the homepage as main site, I then can’t see any lists I’ve created in the subsites to link to them.

Assume I’ve set this up wrong, any help on correct method would be greatly appreciated.

Below is screenshot

Thanks

Darren

Hi I’ve created quality management system in SharePoint comprising of different elements such as a document register, not conformance, customer satisfaction etc. I’ve created all these elements as subsites and have them in button format on the home page, however when I try and use power automate and enter the homepage as main site, I then can’t see any lists I’ve created in the subsites to link to them. Assume I’ve set this up wrong, any help on correct method would be greatly appreciated. Below is screenshotThanksDarren Read More

Previous 1 … 405 406 407 408 409 … 796 Next

All Categories

Search

Cart

All Categories

Search

Cart

HTTPS site on IIS

Prerequisites

The PowerShell Script

Steps to Run the Script

Extensions to Save the Script

Modifications Required

Create a Self-signed Certificate

Advantages of using Powershell Script to create a website in IIS

Troubleshooting in Case of Failure

Conclusion

Introduction

The Challenge: Efficiently Interacting with Structured Data

A Common Use Case

The architecture diagram above illustrates the current setup:

Enhanced Approach: Energy-Efficient Data Interaction

Revised Architecture

Why This Approach?

Potential Downsides and Pitfalls

Conclusion

Sign Up For Newsletters

Information

Contact Us