Category: News
Scheduling Assistant Issue
Any updates to this? https://support.microsoft.com/en-us/office/error-when-opening-calendar-events-in-a-room-mailbox-from-scheduling-assistant-029a434c-0b2e-4b73-9680-7273c3a4dd2b
Weird thing is that some has this issue and some do not. Do we have a fix for this?
Thanks.
Any updates to this? https://support.microsoft.com/en-us/office/error-when-opening-calendar-events-in-a-room-mailbox-from-scheduling-assistant-029a434c-0b2e-4b73-9680-7273c3a4dd2b Weird thing is that some has this issue and some do not. Do we have a fix for this? Thanks. Read More
ASPX extension is getting mangled
Hello All,
We have a document library that contains some ASPX files.
In the past we have been able to upload these files normally and when opened they provide the expected functionality.
However, recently, our ASPX file names are being changed to include a query parameter (e.g. “story.aspx?d=wccb138f4041948d281908c2278103ca9”)
This is preventing the files from loading properly (since the extension is no longer “.aspx”).
I suspect that this is a problem with our new Proofpoint solution, but I want to see if anyone has experience filename mangling when uploading to SP O365.
Any insights are appreciated.
Thank you,
-tomas
Hello All,We have a document library that contains some ASPX files. In the past we have been able to upload these files normally and when opened they provide the expected functionality. However, recently, our ASPX file names are being changed to include a query parameter (e.g. “story.aspx?d=wccb138f4041948d281908c2278103ca9”) This is preventing the files from loading properly (since the extension is no longer “.aspx”). I suspect that this is a problem with our new Proofpoint solution, but I want to see if anyone has experience filename mangling when uploading to SP O365. Any insights are appreciated. Thank you,-tomas Read More
Cumulative Update #28 for SQL Server 2019 RTM
The 28th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:
CU28 KB Article: https://learn.microsoft.com/troubleshoot/sql/releases/sqlserver-2019/cumulativeupdate28
Starting with SQL Server 2017, we adopted a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server
Microsoft® SQL Server® 2019 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=100809
Update Center for Microsoft SQL Server: https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates
Microsoft Tech Community – Latest Blogs –Read More
[MATLAB’s GUI] Erase everything within “Delimiter matching”
Hello,
After coming across this post,
https://stackoverflow.com/questions/72543162/color-parentheses-groups-in-matlabs-ide
I improved a lot my Matlab experience by better seeing the scope of a function, it’s arguments, parenthesis, etc. It’s great.
However, I was wondering if there is a way to setup a hotkey to remove the contents that are highlighthed by such delimiters. I couldn’t find anything online.
In other words, if Matlab is properly highlighting these delimiters (i.e. parenthesis, brackets, IF/END, etc) there must be a way to capture these 2 "endpoints" and just erase everything within it. Maybe some Java hacks which I’m not super familiar with?
I’m using Matlab 2020b and have no intention of changing it anytime soon (because I have custom libraries that stopped being supported) if that changes anything.
Thanks for any input!
LucianoHello,
After coming across this post,
https://stackoverflow.com/questions/72543162/color-parentheses-groups-in-matlabs-ide
I improved a lot my Matlab experience by better seeing the scope of a function, it’s arguments, parenthesis, etc. It’s great.
However, I was wondering if there is a way to setup a hotkey to remove the contents that are highlighthed by such delimiters. I couldn’t find anything online.
In other words, if Matlab is properly highlighting these delimiters (i.e. parenthesis, brackets, IF/END, etc) there must be a way to capture these 2 "endpoints" and just erase everything within it. Maybe some Java hacks which I’m not super familiar with?
I’m using Matlab 2020b and have no intention of changing it anytime soon (because I have custom libraries that stopped being supported) if that changes anything.
Thanks for any input!
Luciano Hello,
After coming across this post,
https://stackoverflow.com/questions/72543162/color-parentheses-groups-in-matlabs-ide
I improved a lot my Matlab experience by better seeing the scope of a function, it’s arguments, parenthesis, etc. It’s great.
However, I was wondering if there is a way to setup a hotkey to remove the contents that are highlighthed by such delimiters. I couldn’t find anything online.
In other words, if Matlab is properly highlighting these delimiters (i.e. parenthesis, brackets, IF/END, etc) there must be a way to capture these 2 "endpoints" and just erase everything within it. Maybe some Java hacks which I’m not super familiar with?
I’m using Matlab 2020b and have no intention of changing it anytime soon (because I have custom libraries that stopped being supported) if that changes anything.
Thanks for any input!
Luciano delimiter matching highlight erase gui hotkey, selective highlighting MATLAB Answers — New Questions
How to export from Mathematica so that Matlab can see a variable name other than Expression1
I’m exporting a variable from Mathematica to disk in .mat format.
Later I want to read this in Matlab.
When I load the .mat file, my variable is called Expression1
How do I export it properly in Mathematica so that my original variable name is preserved?
(I don’t know if this is possible. I can’t find out how to do it when I search the mathematica help files)
Thanks,
TomI’m exporting a variable from Mathematica to disk in .mat format.
Later I want to read this in Matlab.
When I load the .mat file, my variable is called Expression1
How do I export it properly in Mathematica so that my original variable name is preserved?
(I don’t know if this is possible. I can’t find out how to do it when I search the mathematica help files)
Thanks,
Tom I’m exporting a variable from Mathematica to disk in .mat format.
Later I want to read this in Matlab.
When I load the .mat file, my variable is called Expression1
How do I export it properly in Mathematica so that my original variable name is preserved?
(I don’t know if this is possible. I can’t find out how to do it when I search the mathematica help files)
Thanks,
Tom export, load, mathematica, variable name MATLAB Answers — New Questions
Who do I contact to receive a New License/Product or a Renewal Quote?
Who do I contact to receive a New License/Product or a Renewal Quote?Who do I contact to receive a New License/Product or a Renewal Quote? Who do I contact to receive a New License/Product or a Renewal Quote? quote, quotation, inquiry, proforma, invoice, request, 見積, 見積り, renewal MATLAB Answers — New Questions
Plotting Sierpinski’s triangle
Sierpinski’s triangle can be implemented in MATLAB by plotting points iteratively according to one of the following three rules which are selected randomly with equal probability.
* Rule 1: x=05.*x y=0.5*y
* Rule 2: x=0.5*x+.25 y=0.5*y+ sqrt(3)/4
* Rule 3: x=0.5x+.5 y=.5*y
Write a script that calculates the x and y vectors and then plots y versus x as individual points.
Start with x1=0 and y1=0. Run the program three times, with 100, 1000, and 10000 iterations. Print all three plots.
I do not know where to start. I am thinking if and for loops but not sure.Sierpinski’s triangle can be implemented in MATLAB by plotting points iteratively according to one of the following three rules which are selected randomly with equal probability.
* Rule 1: x=05.*x y=0.5*y
* Rule 2: x=0.5*x+.25 y=0.5*y+ sqrt(3)/4
* Rule 3: x=0.5x+.5 y=.5*y
Write a script that calculates the x and y vectors and then plots y versus x as individual points.
Start with x1=0 and y1=0. Run the program three times, with 100, 1000, and 10000 iterations. Print all three plots.
I do not know where to start. I am thinking if and for loops but not sure. Sierpinski’s triangle can be implemented in MATLAB by plotting points iteratively according to one of the following three rules which are selected randomly with equal probability.
* Rule 1: x=05.*x y=0.5*y
* Rule 2: x=0.5*x+.25 y=0.5*y+ sqrt(3)/4
* Rule 3: x=0.5x+.5 y=.5*y
Write a script that calculates the x and y vectors and then plots y versus x as individual points.
Start with x1=0 and y1=0. Run the program three times, with 100, 1000, and 10000 iterations. Print all three plots.
I do not know where to start. I am thinking if and for loops but not sure. matlab, homework, doit4me MATLAB Answers — New Questions
Warning: PIM disconnects users from Teams Mobile
I have been working with Microsoft Support on this issue for three months. Hopefully I can save others the trouble.
Sometime around April 2024, I and my colleagues started seeing regular alerts on our mobile devices saying “Open Teams to continue receiving notifications for <email address>”, or “<email address> needs to sign in to see notifications”. Just as promised, after this message appears, we do not get notified about messages and Teams calls do not ring on our mobile devices until we open Teams. We eventually determined that these alerts coincided with activating or deactivating PIM roles.
Apparently, a change was made to Privileged Identity Management in Microsoft Entra ID around that time whereby users’ tokens are invalidated when a role is activated or deactivated. Quoting the Microsoft Support rep:
“When a user’s role changes (either due to activation or expiration), Skype AAD will revoke existing tokens of that users. Skype AAD will also notify PNH about that token revocation. This is expected behavior and is working as designed. These changes were rolled out in Skype AAD in April/May 2024 which is since when you are facing the issue as well.”
(I’ve never heard of Skype AAD or PNH, but who am I to question the expert?)
Anyway, as far as I can tell, this change was not announced or documented anywhere, so hopefully this message will show up in the search results of my fellow admins who are dealing with this. It’s not a bug, it’s “expected behavior and working as designed”.
I have been working with Microsoft Support on this issue for three months. Hopefully I can save others the trouble. Sometime around April 2024, I and my colleagues started seeing regular alerts on our mobile devices saying “Open Teams to continue receiving notifications for <email address>”, or “<email address> needs to sign in to see notifications”. Just as promised, after this message appears, we do not get notified about messages and Teams calls do not ring on our mobile devices until we open Teams. We eventually determined that these alerts coincided with activating or deactivating PIM roles. Apparently, a change was made to Privileged Identity Management in Microsoft Entra ID around that time whereby users’ tokens are invalidated when a role is activated or deactivated. Quoting the Microsoft Support rep: “When a user’s role changes (either due to activation or expiration), Skype AAD will revoke existing tokens of that users. Skype AAD will also notify PNH about that token revocation. This is expected behavior and is working as designed. These changes were rolled out in Skype AAD in April/May 2024 which is since when you are facing the issue as well.” (I’ve never heard of Skype AAD or PNH, but who am I to question the expert?) Anyway, as far as I can tell, this change was not announced or documented anywhere, so hopefully this message will show up in the search results of my fellow admins who are dealing with this. It’s not a bug, it’s “expected behavior and working as designed”. Read More
Flow to send a daily email noting missing data in a SharePoint List
I need to create a flow that will send out a daily email showing all of the records in a SharePoint list that are missing the task approval dates (Approval Column). I have been playing around with building a flow but I am stumped when needing to enter the Query Filter info.
I need to create a flow that will send out a daily email showing all of the records in a SharePoint list that are missing the task approval dates (Approval Column). I have been playing around with building a flow but I am stumped when needing to enter the Query Filter info. Read More
Migrating new company microsoft license and management to my MSP company.
My MSP company is in the process of onboarding a new company that uses some microsoft services and licenses via another microsoft partner agency. How do i migrate and manage their licenses and services to my company? Your detailed response will be appreciated.
My MSP company is in the process of onboarding a new company that uses some microsoft services and licenses via another microsoft partner agency. How do i migrate and manage their licenses and services to my company? Your detailed response will be appreciated. Read More
Forward Request in API Management not working in Basic Tier but works in Consumption
Hoping this is the correct place to post this….
I am using the API Management police “Forward-Request” to extend the time out beyond 100 seconds. I have three environments – stage, train and live. In Stage and Train, the extended time out works by placing the policy appropriately in the “All Operations” section of the APIS. Both these environments are on the consumption tier.
Doing the same exact thing in our Live module, which is set to Basic Tier, the policy does not work. Has anyone else had this issue?
Hoping this is the correct place to post this…. I am using the API Management police “Forward-Request” to extend the time out beyond 100 seconds. I have three environments – stage, train and live. In Stage and Train, the extended time out works by placing the policy appropriately in the “All Operations” section of the APIS. Both these environments are on the consumption tier.Doing the same exact thing in our Live module, which is set to Basic Tier, the policy does not work. Has anyone else had this issue? Read More
Display/highlight specific pixels of in image
לק"י
Hello guys,
A short code was written to allow me to gather data about cells masks that were clicked on in a figure.
I want to simoultaneously show all previous chosen cells with a color or other distinctive way to avoid picking twice the same cell.
Haven’t managed to find or think about easy and quick way to make it happen.
The cells masks are from time series stack that is being iterated for the amount of frames in the stack. All of this process is being iterated for the amount of cells I want to pick, which I specify in a variable before running the code.
the code:
stackfilename = ‘17.07.2024 aHER2 carrier W.T cd45low+cd4+lstrckr001 cellpose stack.tif’; %get the name of the
% time series stack of masks. These cellpose stacks are handing each cell a unique grayscale value
%ranging from 1 to the total amount of cells detected by cellpose. background (non-mask undetected cell pixels)
% is set to 0.
info = imfinfo(stackfilename); %Info function gets information of every single image of the image stack.
numberOfImages = length(info); %counting the length of info will give the amount of images in the stack.
cellnumber= 6; %Enter the desired amount of cells to be analysed.
pixelindexes={}; %Create a cell array that will hold each mouse click (mask choose) indexes.
pixelvalues={}; %Create a cell array that will hold each mask grayscale value.
for i = 1:cellnumber %The number of cells (number of main loops).
for j=1:numberOfImages %For each cell (main loop), a secondary loop will initiate for the amount…
%of frames in the cells masks stack (‘numberOfImages’).
crntimg = imread(stackfilename, j); % Read the current image
figure(1) %Create a figure
old = double(crntimg); %Turn the image from uint to double for later mathematical manipulation.
crntimgmax=double((max(max(crntimg)))); %Find the max grayscael value of the current frame…
%,equals total cell masks in the frame.
new = 10+(10*(old./crntimgmax)); %Manipulate the image matrix to allow dark tones
% (low values) to be shown with imshow command.
new(new==10)=0; %Set background values to 0 for the dark tones to be seen brighter.
imshow(new,[]) %Display image.
if i~=1 %If previous cells were chosen, start a loop that will…
%plot/show them on the new image that was created to avoid choosing the same cell twice.
hold on %Hold the image.
for k=1:(i-1)
imshow(crntimg==(pixelvalues{j,k}(1)),[]) %|||***This is where
% I can’t figure out how to SIMOULTANEOUSLY SHOW *ALL* OF THE PREVIOUSLY CHOSEN cell masks with
%a DISTINCTIVE COLOR or other way that will set them apart from the other yet unchosen cell masks.***|||
end
end
pixelindexes{j,i}= ginput(1); %Store pixel indexes.
pixelvalues{j,i}=impixel(crntimg,pixelindexes{j,i}(1,1),pixelindexes{j,i}(1,2)); %Store pixel values.
end
close (figure (1))
end
%Save the data
save(append(stackfilename, append…
( append(‘ ‘, strrep(string(datetime(now,’ConvertFrom’,’datenum’)),’:’,’-‘)),’ Worksapce data’)));
The part that I can’t seem to over come is the last for loop which should simoultaneously show all previous chosen masks with a distinctive color or any other way that will show the previously chosen cells distinctively. I tried my best to explain my self and provide with sufficient info. If anything else is needed or needs to be more clear please tell me.
Thanks,
Amit.לק"י
Hello guys,
A short code was written to allow me to gather data about cells masks that were clicked on in a figure.
I want to simoultaneously show all previous chosen cells with a color or other distinctive way to avoid picking twice the same cell.
Haven’t managed to find or think about easy and quick way to make it happen.
The cells masks are from time series stack that is being iterated for the amount of frames in the stack. All of this process is being iterated for the amount of cells I want to pick, which I specify in a variable before running the code.
the code:
stackfilename = ‘17.07.2024 aHER2 carrier W.T cd45low+cd4+lstrckr001 cellpose stack.tif’; %get the name of the
% time series stack of masks. These cellpose stacks are handing each cell a unique grayscale value
%ranging from 1 to the total amount of cells detected by cellpose. background (non-mask undetected cell pixels)
% is set to 0.
info = imfinfo(stackfilename); %Info function gets information of every single image of the image stack.
numberOfImages = length(info); %counting the length of info will give the amount of images in the stack.
cellnumber= 6; %Enter the desired amount of cells to be analysed.
pixelindexes={}; %Create a cell array that will hold each mouse click (mask choose) indexes.
pixelvalues={}; %Create a cell array that will hold each mask grayscale value.
for i = 1:cellnumber %The number of cells (number of main loops).
for j=1:numberOfImages %For each cell (main loop), a secondary loop will initiate for the amount…
%of frames in the cells masks stack (‘numberOfImages’).
crntimg = imread(stackfilename, j); % Read the current image
figure(1) %Create a figure
old = double(crntimg); %Turn the image from uint to double for later mathematical manipulation.
crntimgmax=double((max(max(crntimg)))); %Find the max grayscael value of the current frame…
%,equals total cell masks in the frame.
new = 10+(10*(old./crntimgmax)); %Manipulate the image matrix to allow dark tones
% (low values) to be shown with imshow command.
new(new==10)=0; %Set background values to 0 for the dark tones to be seen brighter.
imshow(new,[]) %Display image.
if i~=1 %If previous cells were chosen, start a loop that will…
%plot/show them on the new image that was created to avoid choosing the same cell twice.
hold on %Hold the image.
for k=1:(i-1)
imshow(crntimg==(pixelvalues{j,k}(1)),[]) %|||***This is where
% I can’t figure out how to SIMOULTANEOUSLY SHOW *ALL* OF THE PREVIOUSLY CHOSEN cell masks with
%a DISTINCTIVE COLOR or other way that will set them apart from the other yet unchosen cell masks.***|||
end
end
pixelindexes{j,i}= ginput(1); %Store pixel indexes.
pixelvalues{j,i}=impixel(crntimg,pixelindexes{j,i}(1,1),pixelindexes{j,i}(1,2)); %Store pixel values.
end
close (figure (1))
end
%Save the data
save(append(stackfilename, append…
( append(‘ ‘, strrep(string(datetime(now,’ConvertFrom’,’datenum’)),’:’,’-‘)),’ Worksapce data’)));
The part that I can’t seem to over come is the last for loop which should simoultaneously show all previous chosen masks with a distinctive color or any other way that will show the previously chosen cells distinctively. I tried my best to explain my self and provide with sufficient info. If anything else is needed or needs to be more clear please tell me.
Thanks,
Amit. לק"י
Hello guys,
A short code was written to allow me to gather data about cells masks that were clicked on in a figure.
I want to simoultaneously show all previous chosen cells with a color or other distinctive way to avoid picking twice the same cell.
Haven’t managed to find or think about easy and quick way to make it happen.
The cells masks are from time series stack that is being iterated for the amount of frames in the stack. All of this process is being iterated for the amount of cells I want to pick, which I specify in a variable before running the code.
the code:
stackfilename = ‘17.07.2024 aHER2 carrier W.T cd45low+cd4+lstrckr001 cellpose stack.tif’; %get the name of the
% time series stack of masks. These cellpose stacks are handing each cell a unique grayscale value
%ranging from 1 to the total amount of cells detected by cellpose. background (non-mask undetected cell pixels)
% is set to 0.
info = imfinfo(stackfilename); %Info function gets information of every single image of the image stack.
numberOfImages = length(info); %counting the length of info will give the amount of images in the stack.
cellnumber= 6; %Enter the desired amount of cells to be analysed.
pixelindexes={}; %Create a cell array that will hold each mouse click (mask choose) indexes.
pixelvalues={}; %Create a cell array that will hold each mask grayscale value.
for i = 1:cellnumber %The number of cells (number of main loops).
for j=1:numberOfImages %For each cell (main loop), a secondary loop will initiate for the amount…
%of frames in the cells masks stack (‘numberOfImages’).
crntimg = imread(stackfilename, j); % Read the current image
figure(1) %Create a figure
old = double(crntimg); %Turn the image from uint to double for later mathematical manipulation.
crntimgmax=double((max(max(crntimg)))); %Find the max grayscael value of the current frame…
%,equals total cell masks in the frame.
new = 10+(10*(old./crntimgmax)); %Manipulate the image matrix to allow dark tones
% (low values) to be shown with imshow command.
new(new==10)=0; %Set background values to 0 for the dark tones to be seen brighter.
imshow(new,[]) %Display image.
if i~=1 %If previous cells were chosen, start a loop that will…
%plot/show them on the new image that was created to avoid choosing the same cell twice.
hold on %Hold the image.
for k=1:(i-1)
imshow(crntimg==(pixelvalues{j,k}(1)),[]) %|||***This is where
% I can’t figure out how to SIMOULTANEOUSLY SHOW *ALL* OF THE PREVIOUSLY CHOSEN cell masks with
%a DISTINCTIVE COLOR or other way that will set them apart from the other yet unchosen cell masks.***|||
end
end
pixelindexes{j,i}= ginput(1); %Store pixel indexes.
pixelvalues{j,i}=impixel(crntimg,pixelindexes{j,i}(1,1),pixelindexes{j,i}(1,2)); %Store pixel values.
end
close (figure (1))
end
%Save the data
save(append(stackfilename, append…
( append(‘ ‘, strrep(string(datetime(now,’ConvertFrom’,’datenum’)),’:’,’-‘)),’ Worksapce data’)));
The part that I can’t seem to over come is the last for loop which should simoultaneously show all previous chosen masks with a distinctive color or any other way that will show the previously chosen cells distinctively. I tried my best to explain my self and provide with sufficient info. If anything else is needed or needs to be more clear please tell me.
Thanks,
Amit. matrix manipulation, digital image processing, imshow, overlay images/pixels, multiple imshow MATLAB Answers — New Questions
Unable To Open Photo Forwarded To Email in Forms
Greetings!
I have created a MS Form in which the responses are forwarded to email using the following Discussion (https://techcommunity.microsoft.com/t5/microsoft-forms/microsoft-forms-help-with-forwarding/m-p/1825857). While the look is different that the current version of Power Automate, the steps walked me through how to complete this task. Purpose and flow are outlined below.
Function: Out Team Members submit Content and a Photo to add to social mediaFlowThe Form is completed by the Team MemberAn email is generated with the post informationThe email is forwarded onto the Admin who has access to our social media accountsAdmin can then copy and paste the post content, download the pic, and to add to social media
The Form Submission and email work as designed. However, the photo that is forwarded is not an image file type that by photo viewer. Attached are screenshots of the Form settings and the reply that the user receives in their Inbox.
Any assistance would be HUGELY helpful! Thanks in advance.
Greetings! I have created a MS Form in which the responses are forwarded to email using the following Discussion (https://techcommunity.microsoft.com/t5/microsoft-forms/microsoft-forms-help-with-forwarding/m-p/1825857). While the look is different that the current version of Power Automate, the steps walked me through how to complete this task. Purpose and flow are outlined below. Function: Out Team Members submit Content and a Photo to add to social mediaFlowThe Form is completed by the Team MemberAn email is generated with the post informationThe email is forwarded onto the Admin who has access to our social media accountsAdmin can then copy and paste the post content, download the pic, and to add to social media The Form Submission and email work as designed. However, the photo that is forwarded is not an image file type that by photo viewer. Attached are screenshots of the Form settings and the reply that the user receives in their Inbox. Any assistance would be HUGELY helpful! Thanks in advance. Read More
Enabling ISVs to accelerate AI app development with Azure AI and GitHub
More than 60,000 organizations use Microsoft Azure AI today to explore the power of custom AI applications. The market is quickly moving from experimentation to scale, and more developers around the world are becoming AI developers. To support this shift, Microsoft is partnering with GitHub to empower developers to build AI applications directly from GitHub.com, with seamless integrations with Codespaces and Microsoft Visual Studio Code. This collaboration brings Azure AI’s leading model selection to developers through GitHub Models, along with simple APIs to empower responsible, production-ready AI applications.
Today, Azure offers the largest and most complete model library in the market, including the latest models from OpenAI, Meta, Mistral, and Cohere, as well as updates to its own Phi-3 family of small language models. GitHub Models allows developers to explore and utilize the latest models along with AI innovations and next-generation frontier models. This offering gives developers the flexibility to choose the best combination of unique capabilities, performance metrics, and cost efficiencies.
While continuous model innovation brings more choice, it also brings complexity when selecting the right model for the right scenario. Developers have a range of options for cloud vs. edge, general-purpose vs. task-specific, and more. Organizations often need multiple models to enable better quality, lower cost of goods sold, and to address complex use cases for each industry. GitHub Models simplifies model experimentation and selection across the best of the Azure AI catalog, allowing developers to quickly compare models, parameters, and prompts.
Azure AI aims to help customers rapidly go from idea to code to cloud by making Azure AI an open, modular platform. With Azure AI on GitHub, developers can utilize Codespaces to set up a prototype or use the Prompty extension to generate code with GitHub Models directly in Microsoft Visual Studio Code. In the coming months, Azure AI will expand its integration further, bringing Azure AI’s language, vision, and multi-modal services to GitHub, along with additional Azure AI toolchain elements.
Developers building with AI want to be confident their AI applications are trustworthy, safe, and secure. GitHub Models provides a strong foundation with built-in safety and security controls from Azure AI. Azure AI works with model providers and partners such as HiddenLayer to reduce emerging threats, from cybersecurity vulnerabilities to malware and other signs of tampering. GitHub Models integrates Azure AI Content Safety for top foundation models, enabling built-in, real-time protection for risks such as the generation of harmful content, copyright materials, hallucination, and new AI-specific attacks.
Increased model selection gives developers the broadest range of options for their applications, but each model brings increased complexity. To counteract this, Azure AI provides a single API for model inference, allowing developers to compare performance across a diverse set of foundational models in a uniform and consistent way. The Azure AI Inference SDK provides client libraries in Python and JavaScript, with support for C# and .NET coming soon. This SDK simplifies common tasks related to authentication, security, and retries in the developer’s programming language of choice.
Beyond these new integrations, Microsoft is making it easier for organizations to access GitHub Enterprise through Azure, combining GitHub’s cloud-native platform with Azure’s robust enterprise-grade security and scalability. Organizations with an existing Azure subscription can purchase GitHub products via self-service, directly through Microsoft Sales, or via Microsoft Cloud Solution Providers. Companies can now spin up a GitHub instance directly from the Azure Portal and connect their Microsoft Entra ID with GitHub to facilitate user management and access control. New customers can explore these capabilities with a free 30-day trial of GitHub Enterprise.
To learn more, check out this new blog: Accelerating AI app development with Azure AI and GitHub | Microsoft Azure Blog
More than 60,000 organizations use Microsoft Azure AI today to explore the power of custom AI applications. The market is quickly moving from experimentation to scale, and more developers around the world are becoming AI developers. To support this shift, Microsoft is partnering with GitHub to empower developers to build AI applications directly from GitHub.com, with seamless integrations with Codespaces and Microsoft Visual Studio Code. This collaboration brings Azure AI’s leading model selection to developers through GitHub Models, along with simple APIs to empower responsible, production-ready AI applications.
Today, Azure offers the largest and most complete model library in the market, including the latest models from OpenAI, Meta, Mistral, and Cohere, as well as updates to its own Phi-3 family of small language models. GitHub Models allows developers to explore and utilize the latest models along with AI innovations and next-generation frontier models. This offering gives developers the flexibility to choose the best combination of unique capabilities, performance metrics, and cost efficiencies.
While continuous model innovation brings more choice, it also brings complexity when selecting the right model for the right scenario. Developers have a range of options for cloud vs. edge, general-purpose vs. task-specific, and more. Organizations often need multiple models to enable better quality, lower cost of goods sold, and to address complex use cases for each industry. GitHub Models simplifies model experimentation and selection across the best of the Azure AI catalog, allowing developers to quickly compare models, parameters, and prompts.
Azure AI aims to help customers rapidly go from idea to code to cloud by making Azure AI an open, modular platform. With Azure AI on GitHub, developers can utilize Codespaces to set up a prototype or use the Prompty extension to generate code with GitHub Models directly in Microsoft Visual Studio Code. In the coming months, Azure AI will expand its integration further, bringing Azure AI’s language, vision, and multi-modal services to GitHub, along with additional Azure AI toolchain elements.
Developers building with AI want to be confident their AI applications are trustworthy, safe, and secure. GitHub Models provides a strong foundation with built-in safety and security controls from Azure AI. Azure AI works with model providers and partners such as HiddenLayer to reduce emerging threats, from cybersecurity vulnerabilities to malware and other signs of tampering. GitHub Models integrates Azure AI Content Safety for top foundation models, enabling built-in, real-time protection for risks such as the generation of harmful content, copyright materials, hallucination, and new AI-specific attacks.
Increased model selection gives developers the broadest range of options for their applications, but each model brings increased complexity. To counteract this, Azure AI provides a single API for model inference, allowing developers to compare performance across a diverse set of foundational models in a uniform and consistent way. The Azure AI Inference SDK provides client libraries in Python and JavaScript, with support for C# and .NET coming soon. This SDK simplifies common tasks related to authentication, security, and retries in the developer’s programming language of choice.
Beyond these new integrations, Microsoft is making it easier for organizations to access GitHub Enterprise through Azure, combining GitHub’s cloud-native platform with Azure’s robust enterprise-grade security and scalability. Organizations with an existing Azure subscription can purchase GitHub products via self-service, directly through Microsoft Sales, or via Microsoft Cloud Solution Providers. Companies can now spin up a GitHub instance directly from the Azure Portal and connect their Microsoft Entra ID with GitHub to facilitate user management and access control. New customers can explore these capabilities with a free 30-day trial of GitHub Enterprise.
To learn more, check out this new blog: Accelerating AI app development with Azure AI and GitHub | Microsoft Azure Blog Read More
MGDC for SharePoint FAQ: How to gather insights from a large Files dataset?
In this post, we’ll cover recommendations on how to gather insights from the SharePoint Files dataset in the Microsoft Graph Data Connect (MGDC). If you’re not familiar with MGDC for SharePoint, start with https://aka.ms/SharePointData.
1. DO – Follow the process for other MGDC datasets
The SharePoint Files dataset in MGDC delivers the largest results, reaching hundreds of millions and even billions of rows for the largest tenants. That would be one row for each document (item in a document library) in SharePoint or OneDrive.
Even though it’s typically very large, this dataset follows the same MGDC process as other datasets. From a pipeline and data source standpoint, it’s just another dataset and it uses the same procedure. There is also support for sampling, filtering, deltas and history of the last 21 days. For details, see MGDC for SharePoint FAQ: Dataset types and features.
2. DO NOT – Load hundreds of millions of rows in Power BI
In general, when using MGDC, you can pull the resulting datasets from Power BI to create your own analytics. Power BI is an amazing tool that will make it easy to pull lots of data and do all sorts of aggregations and summarizations, showing them as reports, charts and dashboards. Power BI can easily pull that data, which is basically a set of folders with JSON files inside.
However, if your tenant ends up outputting tens of millions of rows or more, it is possible that Power BI won’t be able to handle that large dataset. From my experience, Power BI Desktop running on a fast PC with 32GB of RAM can typically handle a few million rows of data. If you have more than that, which is common for the Files dataset, you will need to do some preparation work outside Power BI.
We will discuss a few of these options below.
3. DO – Create a summarized table in ADLS Gen2
If you have too many rows to load into Power BI, you could run a Synapse pipeline to do some data aggregation before pulling the data into Power BI.
For instance, you could use a Synapse data flow to summarize the Files Dataset by “Extension”, calculating the number of sites, files, and bytes for each file extension and pulling that summary into Power BI. This will require some additional work in Synapse, and you will have less flexibility on how to pivot the data once you are in Power BI.
Here are the steps to follow, using a summary by file extension as an example:
Go to the Azure portal and create a new Synapse instance.
In Synapse, create a new data flow. Make sure to enable “data flow debug”.
Add a source to your data flow, pointing to the existing ADLS Gen2 storage, using JSON as the format
Use an aggregate transformation to summarize the data as needed
In the aggregate settings, for the group by column, choose extension
In the aggregate settings, for the aggregates, choose these 3 columns:
SiteCount – countAllDistinct(SiteId)
FileCount – count()
TotalSizeGB – round(sum(SizeInBytes)/1024/1024/1024,2)
Use the “data preview” tab to make sure things are working as expected (see picture below).
Add a sink to write the summarized data back to a new JSON file in ADLS Gen2.
Trigger the pipeline to execute the data flow and summarize the data.
Pull the summarized data into Power BI.
4, DO – Create a summarized table using a Synapse Notebook with PySpark
You can use Azure Synapse Analytics with a notebook to summarize a JSON-file-based dataset in ADLS Gen2.
Here’s a step-by-step guide to help you get started:
Go to the Azure portal and create a new Synapse workspace if you don’t already have one.
Make sure the storage account is configured to allow access by the Synapse workspace. In the Access Control section of the storage account configuration, you can add a role to the app that represents the synapse workspace.
In Synapse Studio, create a new notebook.
Add some code to the notebook. Use PySpark to read the JSON file from ADLS Gen2, perform the necessary summarization operations (for example, group by a field and calculate the sum of another field) and write the summarized data back to ADLS Gen2.
Here’s an example:
from pyspark.sql import SparkSession
from pyspark.sql.functions import count, countDistinct, sum
spark = SparkSession.builder.appName(“SummarizeJSON”).getOrCreate()
# Read the file as text and parse each line as JSON
input_json_path = “abfss://<container>@<account>.blob.core.windows.net/<filespath>/<filename.json>”
rdd = spark.sparkContext.textFile(input_json_path)
df = spark.read.json(rdd)
# Group by Extension and aggregate
summary_df = df.groupBy(“Extension”).agg(
count(“*”).alias(“FileCount”),
countDistinct(“SiteId”).alias(“SiteCount”),
sum(“SizeInBytes”).alias(“TotalBytes”)
)
# Write the output
output_json_path = “abfss://<container>@<account>.dfs.core.windows.net/<extensionspath>”
summary_df.write.mode(“overwrite”).json(output_json_path)
Execute the cell in your notebook to perform the summarization.
Use the new summarized data when loading into Power BI.
5. DO – Load the data into a SQL Server database
For large datasets, you might also want to move the entire dataset from the folder with JSON files into tables in a SQL Server. If your dataset is larger than 100GB, this could become expensive, and you would need to consider using indexes to help with your query. Columnstore indexes might be particularly useful for analytical queries that end up reading the entire table.
In Azure Synapse, you can use a “Copy Data” task where the source is your Azure Data Lake Storage Gen2 (ADLSGen2) and the destination (called the sink) is a table in SQL. You could also use the “Data Flow” task shown previously to transform the data and sink to SQL.
Moving to SQL will typically also require you to flatten the dataset, projecting nested objects. That means that objects inside objects must be represented as a flat list of properties. For instance, instead of having an “Author” object with two properties inside (“Email” and “Name”), you get two columns (“Author.Email” and “Author.Name”). In the Files Dataset, you will need to flatten the “Sensitivity Label Info”, the “Author” and the “Modified By” columns.
Note that you must first land the Microsoft Graph Data Connect dataset in an Azure Storage account before you can transform it and/or move it to SQL Server.
After the data is available in SQL Server, use the Power BI option to get data using a SQL query. Here is an example of a SQL query to summarize the data in the Files table by extension:
SELECT
Extension,
COUNT(*) AS FileCount,
COUNT(DISTINCT SiteId) AS SiteCount,
SUM(SizeInBytes) AS TotalBytes
FROM Files
GROUP BY Extension
If performance is more important than absolute accuracy, you might want to help SQL by using approximate distinct counts. This delivers faster results and guarantees up to a 2% error rate within a 97% probability. Here is an example:
SELECT
Extension,
COUNT(*) AS FileCount,
APPROX_COUNT_DISTINCT(SiteId) AS SiteCount,
SUM(SizeInBytes) AS TotalBytes
FROM Files
GROUP BY Extension
6. DO – Filter data
Instead of reducing the size of the data by summarizing, you can also filter the data in the Files dataset. That could be done by filtering the dataset for a specific site or possibly looking only at files with a specific author. You can use any of the methods described here (Synapse data flow, Synapse notebook or SQL Server query) to perform this filtering.
7. DO – Join the Files dataset with the Sites dataset
It might also be useful to join the Files dataset with the Sites dataset, so you can do specific aggregations or filtering. For instance, you could look into how the Files are distributed across the different types of SharePoint site using the Template or Template Id.
Here is an example using a SQL query:
SELECT
S.RootWebTemplate AS Template,
COUNT(*) AS FileCount,
COUNT(DISTINCT F.SiteId) AS SiteCount,
SUM(F.SizeInBytes) AS TotalBytes
FROM Files AS F
LEFT OUTER JOIN Sites AS S ON F.SiteId = S.Id
GROUP BY 1
Here is an example where we first calculate a summary of files per site, then do the join. This eliminates the need to use a COUNT DISTINCT:
SELECT
S.RootWebTemplate AS Template,
COUNT(*) AS TotalSites,
SUM(G.FilesPerSite) AS TotalFiles,
SUM(G.BytesPerSite) AS TotalBytes
FROM
(SELECT
F.SiteId,
COUNT(*) AS FilesPerSite,
SUM(F.SizeInBytes) AS BytesPerSite
FROM Files AS F
GROUP BY 1) AS G
LEFT OUTER JOIN Sites AS S ON G.SiteId = S.Id
GROUP BY 1
8, DO NOT – Join Files with Permissions on ItemId
You should be very careful when you attempt to join the Files dataset with the Permissions dataset. These are typically huge datasets and the way they should be joined is a bit complicated. You definitely do not want to join them by Item Id, since not every permission has an ItemId (it could be a permission on a Site, Library or Folder) and not every file has an associated permission (again, it could be a permission declared further up in the hierarchy).
If you must find the permissions for a given ItemId, the correct way to do it is by ScopeId. I suggest that you first filter the Files dataset for a specific ItemId and then join that with the Permissions dataset using the ScopeId. Note that a single item might have multiple permissions (with different roles, for instance) and these permissions might be granted for different item types.
Here is an example of a SQL query that shows the permissions for a given file, identified by a SiteId and an ItemId. It is very important to filter the output, otherwise the query might return billions of rows and take a very long time to process.
SELECT
F.SiteId,
F.ItemId,
F.ScopeId,
F.SiteUrl,
F.DirName,
F.FileName,
F.Extension,
P.ItemType,
P.ItemURL,
P.RoleDefinition,
P.LinkId,
P.LinkScope
FROM Files AS F
LEFT OUTER JOIN Permissions AS P
ON F.SiteId = P.SiteId AND F.ScopeId = P.ScopeId
WHERE F.SiteId = ‘ FCBDFC28-9335-4666-A852-6B1C1E7EC165’
AND F.ItemId = ‘ 647DCA3A-A3B8-4DBA-B1E8-6000389E696A’
To understand more about permission scopes, see MGDC for SharePoint FAQ: What is in the Permissions dataset?
9, Conclusion
I hope this clarifies what you can do with the Files dataset in MGDC for SharePoint. Let us know in the comments if you have other suggestions on how to get more out of the Files dataset.
For further details about the schema of all SharePoint datasets in MGDC, including SharePoint Sites and SharePoint File Actions, see https://aka.ms/SharePointDatasets.
Microsoft Tech Community – Latest Blogs –Read More
How can I compile a pre-trained neural network into a standalone application using the MATLAB Compiler 4.10 (R2009a)?
The MATLAB Compiler 4.10 (R2009a) support for MATLAB and Toolboxes at the following web-link suggests that I can compile a pre-trained neural network:
http://www.mathworks.com/products/compiler/compiler_support.htmlThe MATLAB Compiler 4.10 (R2009a) support for MATLAB and Toolboxes at the following web-link suggests that I can compile a pre-trained neural network:
http://www.mathworks.com/products/compiler/compiler_support.html The MATLAB Compiler 4.10 (R2009a) support for MATLAB and Toolboxes at the following web-link suggests that I can compile a pre-trained neural network:
http://www.mathworks.com/products/compiler/compiler_support.html pretrained MATLAB Answers — New Questions
I got an error to the part that used to work no problem. Why?
I didn’t change any of that part, but it suddenly returns shown error.I didn’t change any of that part, but it suddenly returns shown error. I didn’t change any of that part, but it suddenly returns shown error. matlab, error MATLAB Answers — New Questions
Why do I receive “Too many arguments” error when trying to export data from an app designer table as a .txt file, to a user defined file location?
I am attempting to write data from an app designer table, to a .txt file, which can then be saved to a user-specified file location at the touch of a button. It should be noted that the table is quite large, with a length of 16,420 values, so maybe that is causing an issue? Not sure. Here is what I have currently:
% Button pushed function: ExporttotxtButton
function ExporttotxtButtonPushed(app, event)
t1=writetable(app.UITable.Data,’Road Profile_fl.txt’);
[file,path] = uiputfile(‘Road Profile_fl.txt’);
save(fullfile(path, file), ‘t1′,’-ascii’)
end
The following errors are returned:
Any advice on how to fix this, or even a different strategy to accomplish the same goal would be much appreciated. Thank you.I am attempting to write data from an app designer table, to a .txt file, which can then be saved to a user-specified file location at the touch of a button. It should be noted that the table is quite large, with a length of 16,420 values, so maybe that is causing an issue? Not sure. Here is what I have currently:
% Button pushed function: ExporttotxtButton
function ExporttotxtButtonPushed(app, event)
t1=writetable(app.UITable.Data,’Road Profile_fl.txt’);
[file,path] = uiputfile(‘Road Profile_fl.txt’);
save(fullfile(path, file), ‘t1′,’-ascii’)
end
The following errors are returned:
Any advice on how to fix this, or even a different strategy to accomplish the same goal would be much appreciated. Thank you. I am attempting to write data from an app designer table, to a .txt file, which can then be saved to a user-specified file location at the touch of a button. It should be noted that the table is quite large, with a length of 16,420 values, so maybe that is causing an issue? Not sure. Here is what I have currently:
% Button pushed function: ExporttotxtButton
function ExporttotxtButtonPushed(app, event)
t1=writetable(app.UITable.Data,’Road Profile_fl.txt’);
[file,path] = uiputfile(‘Road Profile_fl.txt’);
save(fullfile(path, file), ‘t1′,’-ascii’)
end
The following errors are returned:
Any advice on how to fix this, or even a different strategy to accomplish the same goal would be much appreciated. Thank you. appdesigner, export, txt MATLAB Answers — New Questions
Msgbox if all text boxes are blank
Good day,
Is there a way I can generate a msgbox when a specific button is clicked if all text boxes in a userform have been left blank? I know I can create code for each box individually but I’m thinking there must be a way to combine everything together and generate the msgbox.
Thanks in advance for any assistance!!!
Good day, Is there a way I can generate a msgbox when a specific button is clicked if all text boxes in a userform have been left blank? I know I can create code for each box individually but I’m thinking there must be a way to combine everything together and generate the msgbox. Thanks in advance for any assistance!!! Read More
Changing table border color
Hello everyone,
Is there a way to change the color of the table borders? Maybe by adding CSS styles to the page? I’m not sure if it’s possible, and if so, I don’t know how to do it either.
Thank you in advance,
Hello everyone, Is there a way to change the color of the table borders? Maybe by adding CSS styles to the page? I’m not sure if it’s possible, and if so, I don’t know how to do it either. Thank you in advance, Read More