Category: Microsoft
Category Archives: Microsoft
SQL Server 2022 Replication
Is Merge Replication 2022 supported to execute stored procedue?
Is Merge Replication 2022 supported to execute stored procedue? Read More
Apple App deployment
Hi, i have Apple business manager synced with Intune for both Devices and Apps and that part is working fine. However two things
1. We are using managed apple ids, and everytime a user logs into their phone it reminds them that their managed apple ID cannot be used to purchase apps, is there a way to supress this message?
2. I am a little stuck on deploying the Company portal Intune app to these devices. It appears its as simple as assigning the Company portal Intune VPP App to a device group as required intune. problem is we have a tenant owned by our parent company that is shared by multiple child companies like ours, so i need to ensure i only assign to our iphones, do you think it’s possible to use profile name i have assigned to create the dynamic device group based on say device.enrollmentProfileName -eq “mycompany iOS/iPadOS Profile” ? i have to wait for my parent comany admins to create the group and they can take a while to respond so just making sure this will work?
Thanks for any assistance.
Hi, i have Apple business manager synced with Intune for both Devices and Apps and that part is working fine. However two things 1. We are using managed apple ids, and everytime a user logs into their phone it reminds them that their managed apple ID cannot be used to purchase apps, is there a way to supress this message? 2. I am a little stuck on deploying the Company portal Intune app to these devices. It appears its as simple as assigning the Company portal Intune VPP App to a device group as required intune. problem is we have a tenant owned by our parent company that is shared by multiple child companies like ours, so i need to ensure i only assign to our iphones, do you think it’s possible to use profile name i have assigned to create the dynamic device group based on say device.enrollmentProfileName -eq “mycompany iOS/iPadOS Profile” ? i have to wait for my parent comany admins to create the group and they can take a while to respond so just making sure this will work? Thanks for any assistance. Read More
How to avoid SP List content access to Site collection admins?
My client requests to ensure that only authorized users have access to site list content (such as task lists, document library, etc). Since I am Site collection administrator I have access to all data even if I do not show in permission list. How can I make a 100% sure that content is only available to client? How can I ensure that only he is able to change permission so nobody of my admin team can ever change anything in order to get access to the particular list?
My client requests to ensure that only authorized users have access to site list content (such as task lists, document library, etc). Since I am Site collection administrator I have access to all data even if I do not show in permission list. How can I make a 100% sure that content is only available to client? How can I ensure that only he is able to change permission so nobody of my admin team can ever change anything in order to get access to the particular list? Read More
Teams Meet Now Feature Gets a Makeover for Group Chats
Teams group chats are getting a new Meet Now experience. Is that good news? Well, it’s not an earthshattering change, but it is a nice change because it simplifies the way the Meet Now feature works. It’s the kind of change that software vendors make to tidy up the loose ends in a product.
https://office365itpros.com/2024/04/25/meet-now-teams/
Teams group chats are getting a new Meet Now experience. Is that good news? Well, it’s not an earthshattering change, but it is a nice change because it simplifies the way the Meet Now feature works. It’s the kind of change that software vendors make to tidy up the loose ends in a product.
https://office365itpros.com/2024/04/25/meet-now-teams/ Read More
Hide copilot icon in Word 365
I would like to hide/disable the copilot icon that automatically appears on Word 365 pages as I write. I *do not* want to disable copilot. Just the icon – it is intrusive and irritating.
To be clear: I have the copilot button on my ribbon – that is *not* the issue. The issue is the icon on the page I am working on.
this should be easy but I have spent an hour to no avail…
Don
I would like to hide/disable the copilot icon that automatically appears on Word 365 pages as I write. I *do not* want to disable copilot. Just the icon – it is intrusive and irritating. To be clear: I have the copilot button on my ribbon – that is *not* the issue. The issue is the icon on the page I am working on. this should be easy but I have spent an hour to no avail… Don Read More
SQLserver 2019 filestream share not visible, although no errors
Hello (first time post in sqlserver section):
Out developers have a problem regarding filestream feature in sqlserver 2019. We activated the feature with I/O Fileaccess. Then “EXEC sp_configure filestream_access_level, 2; RECONFIGURE;” then restarted the service, and started the Clustergroup. We activated fullaccess in SQLmanager and the the sharename was blank! We restarted the server , switched the nodes and back. Still blank and also not showing any fileshare with UNC. (The name of the share is “MSSQLSERVER”, fyi.)
In powershell or in the Failover-clustermanager the “other ressource”, the ” SQL Server FILESTREAM share (MSSQLSERVER)” is online and there, with the running property of 2. Server is uptodate.
The powershell showed me type “fileshare” and not of type “SQL Server FILESTREAM Share” (which i don’t know its normal or not).
And the only error i saw is when i go on the “share” tab in the failover-clustermanager, open the properties of this filestream share and i get an error like:
” the information for the share cannot be loaded” (translated from german).
Which can explain that i don’t see the sharename in managementstudio nor in the windows Shares in controlpanel, which i think is a problem on the failoverside and not on the sqlserver side.
But How i can debug or fix it?
Hello (first time post in sqlserver section): Out developers have a problem regarding filestream feature in sqlserver 2019. We activated the feature with I/O Fileaccess. Then “EXEC sp_configure filestream_access_level, 2; RECONFIGURE;” then restarted the service, and started the Clustergroup. We activated fullaccess in SQLmanager and the the sharename was blank! We restarted the server , switched the nodes and back. Still blank and also not showing any fileshare with UNC. (The name of the share is “MSSQLSERVER”, fyi.) In powershell or in the Failover-clustermanager the “other ressource”, the ” SQL Server FILESTREAM share (MSSQLSERVER)” is online and there, with the running property of 2. Server is uptodate.The powershell showed me type “fileshare” and not of type “SQL Server FILESTREAM Share” (which i don’t know its normal or not).And the only error i saw is when i go on the “share” tab in the failover-clustermanager, open the properties of this filestream share and i get an error like:” the information for the share cannot be loaded” (translated from german).Which can explain that i don’t see the sharename in managementstudio nor in the windows Shares in controlpanel, which i think is a problem on the failoverside and not on the sqlserver side. But How i can debug or fix it? Read More
Microsoft copilot
Tenho dificuldade em implementar microsoft Copilot no Office 365
Tenho dificuldade em implementar microsoft Copilot no Office 365 Read More
Countries disappear from map.
Hello everyone!
I am having trouble with my Excel map, as some countries straight up do not show when entering data, as follows :
I have tried rebooting the computer and using countries in other languages. It did work before, this issue only appeared recently.
Has anyone else encountered this issue and/or know a fix? I have a hunch that it has something to do with the Internet, not my program.
Thank you!
Hello everyone! I am having trouble with my Excel map, as some countries straight up do not show when entering data, as follows : I have tried rebooting the computer and using countries in other languages. It did work before, this issue only appeared recently. Has anyone else encountered this issue and/or know a fix? I have a hunch that it has something to do with the Internet, not my program. Thank you! Read More
How do I save/download Onlyfans Videos on my PC
Hello everyone, I’ve recently encountered an issue with downloading videos from OnlyFans that I’ve paid for and I’m looking for some assistance. Despite having a subscription and lawful access to the content, I’m unable to find a straightforward way to download videos to my device for offline viewing. Could anyone guide me on how to achieve this without violating any terms of service? Any advice on tools or methods that comply with OnlyFans’ policies would be greatly appreciated. Thank you in advance for your help!
Hello everyone, I’ve recently encountered an issue with downloading videos from OnlyFans that I’ve paid for and I’m looking for some assistance. Despite having a subscription and lawful access to the content, I’m unable to find a straightforward way to download videos to my device for offline viewing. Could anyone guide me on how to achieve this without violating any terms of service? Any advice on tools or methods that comply with OnlyFans’ policies would be greatly appreciated. Thank you in advance for your help! Read More
Using VBA or a macro to get first row
Hello,
I have a number of xlsx files in a folder and want to take the first (header) row from each of the files and place them in a new file.
How can I do this
Thanks
Hello, I have a number of xlsx files in a folder and want to take the first (header) row from each of the files and place them in a new file. How can I do this Thanks Read More
MS Teams Frontline Teams Setup
I have tried to setup frontlines in Teams. However, the setup failed and I attempted to change it in my Admin Center but it seems I have hit a wall as my apply button is greyed out.
In addition, the yellow warning popup says:
‘There was a problem with your setup. Download the error CSV to see what didn’t work and then try again.’
I see no option to download the csv. though.
I also see no way to do the setup from scratch again.
Much help is appreciated.
I have tried to setup frontlines in Teams. However, the setup failed and I attempted to change it in my Admin Center but it seems I have hit a wall as my apply button is greyed out. In addition, the yellow warning popup says:’There was a problem with your setup. Download the error CSV to see what didn’t work and then try again.’I see no option to download the csv. though. I also see no way to do the setup from scratch again. Much help is appreciated. Read More
Join if String Contains
Hello,
I want to join two tables:
Table1
IdName123Steven Brown456
Lacie Garrison
789
Tobias Booker
Table2
Names CountrySteven Brown, Sandra Muller USAlex Hampton, Tobias BookerCanadaJanet BeemMexico
Expected Result
IdNameCountry123Steven BrownUS456Lacie Garrison 789
Tobias Booker
Canada
I am working with Data Flows at the moment and I can only see that we can do joins or lookups on exact matches, not on contains.
Any ideas are appreciated.
Hello, I want to join two tables: Table1IdName123Steven Brown456Lacie Garrison 789Tobias Booker Table2Names CountrySteven Brown, Sandra Muller USAlex Hampton, Tobias BookerCanadaJanet BeemMexico Expected ResultIdNameCountry123Steven BrownUS456Lacie Garrison 789Tobias BookerCanada I am working with Data Flows at the moment and I can only see that we can do joins or lookups on exact matches, not on contains.Any ideas are appreciated. Read More
Windows Server 2016 and New Teams
Hello everyone
We know that the “old” Teams client will no longer work at the end of June.
We are currently using Teams on Citrix on Windows Server 2016.
Is there any approach other than upgrading the servers os to get teams running temporarily?
Is there a way to connect the Teams web client to Outlook?
thanks in advance
greeting
Thorsten
Hello everyoneWe know that the “old” Teams client will no longer work at the end of June.We are currently using Teams on Citrix on Windows Server 2016.Is there any approach other than upgrading the servers os to get teams running temporarily?Is there a way to connect the Teams web client to Outlook?thanks in advancegreetingThorsten Read More
Sent from Outlook for iOS links Being Quarantined in Defender
Hi,
Microsoft seem to be falsely flagging their own shortening URL for hxxps://aka.ms/o0ukef as High Confidence Phishing
This is the link that is created in emails when a user sends an email from Outlook for iOS
This is causing a lot of emails to be blocked and sent to the Quarantine queue.
Can someone at MS take a look and get this addressed.
Hi, Microsoft seem to be falsely flagging their own shortening URL for hxxps://aka.ms/o0ukef as High Confidence Phishing This is the link that is created in emails when a user sends an email from Outlook for iOS This is causing a lot of emails to be blocked and sent to the Quarantine queue. Can someone at MS take a look and get this addressed. Read More
DPM 2019 backing up Hyper-v VM
Hi all,
we have a DPM 2019 server which backs up virtual machines on a Hyper-V host and this is working great. The one issue we have is there is a VM which has a large VHD (2TB) and we have a storage location for this which keeps running out of space, it’s currently at 5TB.
I’m wondering if there is a more efficient way of backing this up, we can’t use guest level backup for this VM.
Any ideas are welcome.
Hi all,we have a DPM 2019 server which backs up virtual machines on a Hyper-V host and this is working great. The one issue we have is there is a VM which has a large VHD (2TB) and we have a storage location for this which keeps running out of space, it’s currently at 5TB. I’m wondering if there is a more efficient way of backing this up, we can’t use guest level backup for this VM. Any ideas are welcome. Read More
i can’t see work side of a COPE phone by USB
Hello everyone,
As the title says, when i plug a phone to my PC, i can’t see both profile in the folder, i only see the personnal one.
I’ve checked the configuration, which allow it to be seen from USB, I’ve check the compliance and there is nothing that can block it there ( from what i saw ).
Anyone got the same issue as me and know how to get through it ?
Thanks !
Hello everyone,As the title says, when i plug a phone to my PC, i can’t see both profile in the folder, i only see the personnal one.I’ve checked the configuration, which allow it to be seen from USB, I’ve check the compliance and there is nothing that can block it there ( from what i saw ).Anyone got the same issue as me and know how to get through it ?Thanks ! Read More
SharePoint embedded folder in Power Apps suddenly gives a 401 UNAUTHORIZED error
Hello,
We are using an iFrame in a Power Apps model-driven app to display a SharePoint Online folder in context of the record.
This approach has been working fine for at least a couple of months but suddenly we are getting an 401 UNAUTHORIZED error in the iFrame.
The user can open the folder in a new tab without any issues.
Does anyone know if anything has changed in SharePoint that could affect this approach? E.g. something regarding authentication or similar?
BR,
Niels
Hello, We are using an iFrame in a Power Apps model-driven app to display a SharePoint Online folder in context of the record. This approach has been working fine for at least a couple of months but suddenly we are getting an 401 UNAUTHORIZED error in the iFrame. The user can open the folder in a new tab without any issues. Does anyone know if anything has changed in SharePoint that could affect this approach? E.g. something regarding authentication or similar? BR,Niels Read More
Connecting Separate Excel sheets for Asset Management
Hi, am working on a simple asset management solution for my company using Excel. The spreadsheets will eventually become data sources for a power app that will make the asset tracking more user friendly. In the meantime, there is one thing I am stuck on.
I have one sheet for laptops (plus data – RAM, SSD, warranty exp, domain, etc.) One of the columns in the laptop sheet, lists the assigned user (“Employee”). The user is chosen from a dropdown, and the data/choices comes from another sheet that lists employees. The employees list also has a column for laptop and it is supposed to list the laptop assigned to them (“Laptop [Device Name]”).
I would like the laptop column in the employee list to update when the assigned user is entered into the laptop inventory list. OR vice versa, whatever is possible – if either are.
Is this type of connection possible between two sheets?
Thank you for taking the time to read my post.
Sincerely,
Not an Excel Expert
Images:
Laptop Sheet:
Employee Sheet:
Hi, am working on a simple asset management solution for my company using Excel. The spreadsheets will eventually become data sources for a power app that will make the asset tracking more user friendly. In the meantime, there is one thing I am stuck on. I have one sheet for laptops (plus data – RAM, SSD, warranty exp, domain, etc.) One of the columns in the laptop sheet, lists the assigned user (“Employee”). The user is chosen from a dropdown, and the data/choices comes from another sheet that lists employees. The employees list also has a column for laptop and it is supposed to list the laptop assigned to them (“Laptop [Device Name]”). I would like the laptop column in the employee list to update when the assigned user is entered into the laptop inventory list. OR vice versa, whatever is possible – if either are. Is this type of connection possible between two sheets? Thank you for taking the time to read my post. Sincerely,Not an Excel Expert Images:Laptop Sheet:Employee Sheet: Read More
Unlock the Power of Small Language Models with Phi-3 and Azure AI Studio
Introduction:
As a technical student, you’re likely fascinated by the rapidly evolving world of artificial intelligence (AI) and machine learning. In this blog, we’ll explore the exciting realm of Small Language Models (SLMs), a new breed of AI models that are redefining what’s possible with Azure.
What are Small Language Models (SLMs)?
Small Language Models (SLMs) are a type of neural network designed to process and generate human-like text. Unlike traditional language models, SLMS are optimized for smaller size and faster training times, making them more accessible and scalable for developers like you.
Introducing Phi-3: Redefining What’s Possible with SLMs
Microsoft announced the introduction of Phi-3, a revolutionary new architecture that leverages the power of SLMS. Phi-3 redefines what’s possible with language models, enabling faster and more accurate text processing.
Getting Started with Phi-3 and Azure AI Studio: A Step-by-Step Guide
Step 1: Set Up Your Environment
Create an Azure account if you haven’t already.
Install the Azure CLI or use a cloud-based IDE like Visual Studio Code.
Familiarize yourself with Python, as it’s the primary language used in Azure AI Studio.
Step 2: Setup your Azure Azure AI Studio
Go to the Azure AI Studio and follow the installation instructions for your preferred platform (Windows, macOS, or Linux).
Launch the Azure AI Studio and sign in with your Azure account credentials.
Step 3: Explore Phi-3 Models
Explore the model catalog in Azure AI Studio – Azure AI Studio
Navigate to the Model Catalog and install the Phi-3 models.
Import the Phi-3 models into Azure AI Studio using the built-in data loading features.
Experiment with different Phi-3 model variants to see how they perform on various text processing tasks.
Step 4: Build Your First SLM-based Application
Choose a sample project from the Azure AI Studio template gallery or create your own from scratch.
Use the Phi-3 models and Azure AI Studio’s built-in functionality to develop an SLM-based application that performs text classification, sentiment analysis, or language translation.
Step 5: Deploy Your Application
Once you’ve developed your SLM-based application, deploy it to the cloud using Azure Kubernetes Service (AKS) or Azure Functions.
Use Azure Monitor and Log Analytics to track your application’s performance and troubleshoot any issues that arise.
Tips and Tricks for Success
Experiment with different Phi-3 model variants and hyperparameters to optimize your SLM-based application’s performance.
Leverage Azure AI Studio’s built-in collaboration features, such as code sharing and version control, to work with team members on your project.
Join the Microsoft AI Discord community forum to connect with other developers and get help when you need it.
Conclusion:
In this blog, we’ve explored the exciting world of Small Language Models (SLMs) and introduced you to Phi-3, a revolutionary new architecture that leverages the power of SLMS. By following the steps outlined in this guide, you can get started with Phi-3 and Azure AI Studio and unlock the full potential of SLMs for your technical projects.
Additional Resources:
Try Phi-3 Playground Experience
Azure Blog: Introducing Phi-3: Redefining what’s possible with SLMs | Microsoft Azure Blog
Microsoft Developer Blog: Phi-3 Models Getting Started
Azure AI Studio Documentation: Getting Started Guide
Phi-3 benchmarks and technical paper.
Phi-3 on the AI Show
Microsoft AI Discord Community http://aka.ms/AzureAI/Discord
Global AI Community http://globalai.community
Azure AI Samples http://github.com/azure-samples/azureai-samples
Microsoft AI Show http://aka.ms/aishow
Microsoft Tech Community – Latest Blogs –Read More