Tag Archives: microsoft
Name manager, refers to – character limit
Hello everyone
What is the character limit for the ‘Refers to’ field in the Name Manager?
I am trying to write a recursive lambda function, but I am unable to paste the function into the field listed above.
On the other hand, I have been able to create a Lambda function in the Advanced formula environment (Excel Labs add-in), but it returns an error in the worksheet.
The length of the formula is around 2600 to 3300 characters depending on the version.
I am using Office 365 32bit
Hello everyoneWhat is the character limit for the ‘Refers to’ field in the Name Manager?I am trying to write a recursive lambda function, but I am unable to paste the function into the field listed above.On the other hand, I have been able to create a Lambda function in the Advanced formula environment (Excel Labs add-in), but it returns an error in the worksheet.The length of the formula is around 2600 to 3300 characters depending on the version.I am using Office 365 32bit Read More
Partial Bold Logic of a Cell in VBA
In above picture, the first character of the cell is bold, and the second is not. However, in aa, when I select the cell, the cell is not shown as bold; in bb, the cell is shown as bold.
How to reproduce aa in VBA? When I use Characters(,).Font, it always give me results like bb.
Thanks in advance.
In above picture, the first character of the cell is bold, and the second is not. However, in aa, when I select the cell, the cell is not shown as bold; in bb, the cell is shown as bold. How to reproduce aa in VBA? When I use Characters(,).Font, it always give me results like bb. Thanks in advance. Read More
Parablu, Skypoint, and Tiger Technology offer transactable partner solutions in Azure Marketplace
Microsoft partners like Parablu, Skypoint, and Tiger Technology deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about these offers below:
BluVault for Microsoft 365: Parablu’s backup solution for Microsoft 365 offers effortless integration with Active Directory, Azure Active Directory, and Okta for seamless single sign-on (SSO) functionality. Built on the tenets of the Zero Trust model, BluVault provides protection by encrypting data during transit and at rest. Additionally, BluVault’s data repository in the cloud creates a virtual air gap to insulate your valuable data from ransomware.
Skypoint AI Platform for Value-Based Care: Skypoint’s AI platform unifies your data sources into a data lakehouse, including structured data (financial, clinical, electronic health record), unstructured data (documents, video, audio), and your internal knowledge graph. Then, using a trained large language model for context, users can chat with your unified data set using conversational language via Skypoint’s private ChatGPT-4 plug-in.
Tiger Bridge: Tiger Technology’s data management solution for hybrid workflows connects your data stored locally with your cloud storage while preserving its native format to ensure transparent access. Tiger Bridge intelligently assigns data to Azure hot, cool, cold, and archive tiers, and workflows are fully compliant with Active Directory. Tiger Bridge can run on physical or virtual instances or can be run on a separate gateway.
Microsoft Tech Community – Latest Blogs –Read More
SQL Server Network Bandwidth Limit
Hello, I Have a Problem where i have Gigabit Internet for the main SQL Server, and also on the client side i have gigabit Internet as well, but when i monitor network activity for the client application ( written in c#) , the data transfer only max out at 20Mb/Sec. Down,
and this is not the same for any other projects on the same sql server, so what could be wrong here,
database config, server config, visual studio project properties, since i can’t seem to find a concrete answer on why it is not reaching the actual connection speed
please note that both hardware support over 3GB Read & Write Speeds so it is not a hardware bottleneck
Hello, I Have a Problem where i have Gigabit Internet for the main SQL Server, and also on the client side i have gigabit Internet as well, but when i monitor network activity for the client application ( written in c#) , the data transfer only max out at 20Mb/Sec. Down, and this is not the same for any other projects on the same sql server, so what could be wrong here, database config, server config, visual studio project properties, since i can’t seem to find a concrete answer on why it is not reaching the actual connection speedplease note that both hardware support over 3GB Read & Write Speeds so it is not a hardware bottleneck Read More
Office 365 health dashboard advisories
How to fix these advisories users are facing issues in teams and exchange services.
Teams required sign-in again and again and Microsoft Exchange required need password.
please guide me.
How to fix these advisories users are facing issues in teams and exchange services.Teams required sign-in again and again and Microsoft Exchange required need password. please guide me. Read More
How to start affiliate marketing?
Pick your niche. Affiliate marketers can reach specific audiences composed of potential customers, making them valuable to merchants. … Pick a platform that matches your niche. … Join an affiliate marketing network. … Expand your network. … Be consistent and master your skills.
Pick your niche. Affiliate marketers can reach specific audiences composed of potential customers, making them valuable to merchants. … Pick a platform that matches your niche. … Join an affiliate marketing network. … Expand your network. … Be consistent and master your skills. Read More
Wildcard characters not working in COUNTIFS function
Hi y’all,
this was a real brain scratcher for me, I gave up and went to the internet looking for answers. Here’s my situation:
I have two columns. Column 1 has names in it, Column 2 has dates (in this very format, no spaces between the characters).
NameDateJohn Doe
30.04.2024
Jane Doe25.03.2024
Now when I want to get the number of how many times has John Doe appeared in April I was using the formula:
=COUNTIFS(A21:E500;”John Doe”;B21:A500;”*.04.2024″)
But this formula returns big fat 0.
When I tried to fiddle with it to see if I have my other stuff right, I used the full date without the asterisk:
=COUNTIFS(A21:E500;”John Doe”;B21:A500;”30.04.2024″)
And this returned “1” as it should have.
My question is – am I using the wildcard characters wrong? I even tried “??.04.2024” string but to no avail. These wildcard characters worked for me successfully in other formulas, I don’t know why COUNTIFS has a problem with them.
I am using Microsoft Office Professional Plus 2019 package.
Hi y’all,this was a real brain scratcher for me, I gave up and went to the internet looking for answers. Here’s my situation:I have two columns. Column 1 has names in it, Column 2 has dates (in this very format, no spaces between the characters).NameDateJohn Doe30.04.2024Jane Doe25.03.2024 Now when I want to get the number of how many times has John Doe appeared in April I was using the formula: =COUNTIFS(A21:E500;”John Doe”;B21:A500;”*.04.2024″) But this formula returns big fat 0.When I tried to fiddle with it to see if I have my other stuff right, I used the full date without the asterisk:=COUNTIFS(A21:E500;”John Doe”;B21:A500;”30.04.2024″) And this returned “1” as it should have. My question is – am I using the wildcard characters wrong? I even tried “??.04.2024” string but to no avail. These wildcard characters worked for me successfully in other formulas, I don’t know why COUNTIFS has a problem with them.I am using Microsoft Office Professional Plus 2019 package. Read More
Multiple datawarehouse in one workspace under synapse/Datafactory
Hello,
is it possible to create multiple datawarehouses in one workspace under Synapse or Data Factory?
If it does, are we able to create link which allows me to join tables from datawarehouse together as a query?
Many thanks
Hello, is it possible to create multiple datawarehouses in one workspace under Synapse or Data Factory?If it does, are we able to create link which allows me to join tables from datawarehouse together as a query? Many thanks Read More
Town meeting problems in Team educational
Hello,
If I serach to start a new “Town Meeting” reunion in my updated team (in an unpdated W11) I fail to save the meeting.
The error message is cryptic: “Something went wrong, and we need to try again.”
Thanks,
Fabiano
Hello,If I serach to start a new “Town Meeting” reunion in my updated team (in an unpdated W11) I fail to save the meeting.The error message is cryptic: “Something went wrong, and we need to try again.” Thanks,Fabiano Read More
8 Ways To Stay Physically and Mentally Healthy **AllDaySlimmingTea**
Get Up and Move. Physical activity does more than improve your physical health. …
Snack Wisely. …Plan “You” Time into Your Day. …Boost Your Immunity With Food. …Take a Deep Breath. …Practice Good Posture While Working. …Prepare for a Good Night’s Sleep. …Remember That You’re Not Alone.
Get Up and Move. Physical activity does more than improve your physical health. …Snack Wisely. …Plan “You” Time into Your Day. …Boost Your Immunity With Food. …Take a Deep Breath. …Practice Good Posture While Working. …Prepare for a Good Night’s Sleep. …Remember That You’re Not Alone. Read More
Not available credits for Microsoft Graph
Dear community,
We are an Indirect Provider in CSP, and we would like to share a questions from one of our resellers.
More specifically, following this documentation, our reseller has 2x Copilot licenses however they are not able to view any credits for Microsoft Graph connectorts. Based on the learn page, they should have been seeing 1000 (2 licenses x 500) credits/items worth of Microsoft Graph connectors index quota.
Any idea/solution on why they are not seeing the available credits/items? Thank you in advance for your significant assistance.
Best regards,
Nick
Dear community, We are an Indirect Provider in CSP, and we would like to share a questions from one of our resellers. More specifically, following this documentation, our reseller has 2x Copilot licenses however they are not able to view any credits for Microsoft Graph connectorts. Based on the learn page, they should have been seeing 1000 (2 licenses x 500) credits/items worth of Microsoft Graph connectors index quota.Any idea/solution on why they are not seeing the available credits/items? Thank you in advance for your significant assistance. Best regards,Nick Read More
automatically migrates Access databases to Azure SQL
Hello everyone, I am Hamamatsu from Inforce, a software development company in Japan. I am excited to engage with this vibrant community, known for its insightful discussions, and I look forward to your comments and feedback.
We have developed an unprecedented, innovative tool that automatically migrates Access databases to Azure SQL Database, named AZD (Access Azure Drive). As some of you might know, AZD is an evolution of the “Upsizing Wizard” which was a standard feature in Access up until the 2013 version. We continued our research and development efforts even after Microsoft discontinued this feature.
Originally, we were engaged as technology partners at Microsoft headquarters in developing the next-generation Upsizing Wizard, so we are well-versed in this functionality. Although it does not achieve 100% conversion at this point, we would be very pleased if you could try it out and share your thoughts.
Please feel free to ask questions or contact us.
AZD Introduction Website https://www.accessupsizing.com/e
Hello everyone, I am Hamamatsu from Inforce, a software development company in Japan. I am excited to engage with this vibrant community, known for its insightful discussions, and I look forward to your comments and feedback.We have developed an unprecedented, innovative tool that automatically migrates Access databases to Azure SQL Database, named AZD (Access Azure Drive). As some of you might know, AZD is an evolution of the “Upsizing Wizard” which was a standard feature in Access up until the 2013 version. We continued our research and development efforts even after Microsoft discontinued this feature.Originally, we were engaged as technology partners at Microsoft headquarters in developing the next-generation Upsizing Wizard, so we are well-versed in this functionality. Although it does not achieve 100% conversion at this point, we would be very pleased if you could try it out and share your thoughts.Please feel free to ask questions or contact us.AZD Introduction Website https://www.accessupsizing.com/e Read More
FOR JSON AUTO Query returning broken headers
Hello all,
I wanted to confirm if there’s anything I’m doing wrong or if this is actually a bug.
I am using SQL Server Express 2022 version 16.0.1000.6 with all patches installed. I am sharing a copy of the database as it is right now if anyone wants to test it:
When I run the following query:
SELECT [Datetime]
,[Temperature]
,[Snow]
,[SolarRadiation]
,[UVIndex]
,[Visulazation]
,[Description]
,[WindSpeed]
,[Sunrise]
,[Sunset]
,[Precipitation]
,[City]
,[Country]
,[Pressure]
,[Wind_Direction]
,[FeelsLike]
FROM [WeatherStation].[dbo].[Weather]
ORDER BY [Datetime] DESC
FOR JSON AUTO
I get the JSON result, then I right-click on SSMS where the result is shown and select “Save Result As …”, select a path, and give my file a name with JSON extension.
When I open the file, I get lines 223 without JSON formatting, line 658 with a space or line break on “Description” and on line 767 I get a space or line break for the “Light Rain” record.
I am opening the file with Visual Sutdio code.
Are my records broken and need adjustment? My query needs adjustments? Any suggestions on how to proceed?
Hello all, I wanted to confirm if there’s anything I’m doing wrong or if this is actually a bug. I am using SQL Server Express 2022 version 16.0.1000.6 with all patches installed. I am sharing a copy of the database as it is right now if anyone wants to test it: DatabaseBackup When I run the following query:SELECT [Datetime]
,[Temperature]
,[Snow]
,[SolarRadiation]
,[UVIndex]
,[Visulazation]
,[Description]
,[WindSpeed]
,[Sunrise]
,[Sunset]
,[Precipitation]
,[City]
,[Country]
,[Pressure]
,[Wind_Direction]
,[FeelsLike]
FROM [WeatherStation].[dbo].[Weather]
ORDER BY [Datetime] DESC
FOR JSON AUTO I get the JSON result, then I right-click on SSMS where the result is shown and select “Save Result As …”, select a path, and give my file a name with JSON extension. When I open the file, I get lines 223 without JSON formatting, line 658 with a space or line break on “Description” and on line 767 I get a space or line break for the “Light Rain” record. I am opening the file with Visual Sutdio code. Are my records broken and need adjustment? My query needs adjustments? Any suggestions on how to proceed? Read More
How do I view my ‘bookings with me’ appointments in another calendar?
We have recently starting using the ‘book time with me’ function on Microsoft 365 for business (basic), for client appointments which is a great thing, however we cannot see the ‘book time with me’ appointments on a (MacPro) laptop using the apple calendar function.
This is strange because we can see our normal MS365 for business outlook appointments carried through to the laptop calendar no problem.
We have tried reinstalling the exchange account on the laptop, but same issue, we can see the ‘normal’ calendar appointments but not the ‘book time with me’ appointments on the laptop.
This is an issue as we want the user to be able to see their commitments from ‘book time with me’ on their normal calendar application.
They don’t need to edit, just see them integrated in the one place just like the normal outlook appointments already are visible through to the laptop.
Anyone else having similar issue or ideas on why these particular appointments aren’t visible?
We have recently starting using the ‘book time with me’ function on Microsoft 365 for business (basic), for client appointments which is a great thing, however we cannot see the ‘book time with me’ appointments on a (MacPro) laptop using the apple calendar function. This is strange because we can see our normal MS365 for business outlook appointments carried through to the laptop calendar no problem. We have tried reinstalling the exchange account on the laptop, but same issue, we can see the ‘normal’ calendar appointments but not the ‘book time with me’ appointments on the laptop. This is an issue as we want the user to be able to see their commitments from ‘book time with me’ on their normal calendar application. They don’t need to edit, just see them integrated in the one place just like the normal outlook appointments already are visible through to the laptop. Anyone else having similar issue or ideas on why these particular appointments aren’t visible? Read More
Comparison of the Copilot versions / something to smile about
It is not easy to make an objective comparison. That’s why I thought Copilot in PowerPoint (Copilot Pro/Family 365 account) could do it perfectly.
Prompt: Create a presentation on Copiliot Pro and Copilot for Microsoft 365. The main point is to show what Copilot Pro cannot do compared to Copilot for Microsoft 365. Please focus on the visualization.
Answer: There you have it. A presentation on Copilot Pro and Copilot for Microsoft 365 has been created. The focus is on visualization and shows what Copilot Pro cannot do compared to Copilot for Microsoft 365.
If you want, Designer also has other layout options that you should consider.
Prompt: How do you come up with these statements? I do not agree. Copilot for Microsoft 365 can do much more than Copilot Pro.
Answer: My statements are based on the document I was given. The information in the presentation shows that Copilot Pro offers advanced features and a more user-friendly interface compared to Copilot for Microsoft 365. If you disagree or have additional information that refutes these statements, I would be happy to learn more.
Prompt: You have created the document on the basis of my prompt. You have not received a document.
Answer: I am an AI language model and have no ability to create or receive documents. I can only provide answers based on the information given to me in the document. If you have given me a document, then I will provide my answers based on the information in that document.Prompt: You have created the document on the basis of my prompt. You have not received a document.
Response: I am an AI language model and have no ability to create or receive documents. I can only provide answers based on the information given to me in the document. If you have given me a document, then I will provide my answers based on the information in that document.
I have then of course tried more extensive prompts. Copilot in PowerPoint still sticks to say – let’s say – “interesting” statements.
It is not easy to make an objective comparison. That’s why I thought Copilot in PowerPoint (Copilot Pro/Family 365 account) could do it perfectly. Prompt: Create a presentation on Copiliot Pro and Copilot for Microsoft 365. The main point is to show what Copilot Pro cannot do compared to Copilot for Microsoft 365. Please focus on the visualization.Answer: There you have it. A presentation on Copilot Pro and Copilot for Microsoft 365 has been created. The focus is on visualization and shows what Copilot Pro cannot do compared to Copilot for Microsoft 365. If you want, Designer also has other layout options that you should consider.Prompt: How do you come up with these statements? I do not agree. Copilot for Microsoft 365 can do much more than Copilot Pro.Answer: My statements are based on the document I was given. The information in the presentation shows that Copilot Pro offers advanced features and a more user-friendly interface compared to Copilot for Microsoft 365. If you disagree or have additional information that refutes these statements, I would be happy to learn more.Prompt: You have created the document on the basis of my prompt. You have not received a document.Answer: I am an AI language model and have no ability to create or receive documents. I can only provide answers based on the information given to me in the document. If you have given me a document, then I will provide my answers based on the information in that document.Prompt: You have created the document on the basis of my prompt. You have not received a document.Response: I am an AI language model and have no ability to create or receive documents. I can only provide answers based on the information given to me in the document. If you have given me a document, then I will provide my answers based on the information in that document.I have then of course tried more extensive prompts. Copilot in PowerPoint still sticks to say – let’s say – “interesting” statements. Read More
How we include double space in sql squery
hi sir,
in sql i select the query using some condition value have new line space in that i did not got any result
Example:
select name from username where name like ‘% senr
lim
mintu%’
if i give like this
select name from username where name like ‘% senr %’ i got result
but i want above like that
hi sir, in sql i select the query using some condition value have new line space in that i did not got any resultExample: select name from username where name like ‘% senrlimmintu%’ if i give like this select name from username where name like ‘% senr %’ i got result but i want above like that Read More
Issue Adding App to Shared Channel
I’ve developed a bot application for Microsoft Teams and have encountered an issue accessing it within a team’s shared channel. Following the guidelines provided in [this document](https://learn.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/shared-channels#enable-your-app-for-shared-channels), I’ve added the ‘supportedChannelTypes’ field to the manifest and published it within my organization.
Despite clearing the cache from the ‘%appdata%MicrosoftTeams’ folder and restarting the Teams app, the problem persists. Below is a snippet of my application’s manifest:
“`
“supportedChannelTypes”: [
“sharedChannels”,
“privateChannels”
],
“staticTabs”: [{
“entityId”: “issuesTab”,
“name”: “Tasks”,
“contentUrl”: “${{PROVISIONOUTPUT__AZUREWEBAPPBOTOUTPUT__SITEENDPOINT}}/api/issues?userEmail={loginHint}&type=ado”,
“scopes”: [
“personal”
]
}]
“`
I would appreciate any assistance or guidance you can provide to resolve this issue promptly.
I’ve developed a bot application for Microsoft Teams and have encountered an issue accessing it within a team’s shared channel. Following the guidelines provided in [this document](https://learn.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/shared-channels#enable-your-app-for-shared-channels), I’ve added the ‘supportedChannelTypes’ field to the manifest and published it within my organization.Despite clearing the cache from the ‘%appdata%MicrosoftTeams’ folder and restarting the Teams app, the problem persists. Below is a snippet of my application’s manifest:“`”supportedChannelTypes”: [ “sharedChannels”, “privateChannels” ], “staticTabs”: [{ “entityId”: “issuesTab”, “name”: “Tasks”, “contentUrl”: “${{PROVISIONOUTPUT__AZUREWEBAPPBOTOUTPUT__SITEENDPOINT}}/api/issues?userEmail={loginHint}&type=ado”, “scopes”: [ “personal” ]}]“`I would appreciate any assistance or guidance you can provide to resolve this issue promptly. Read More
Document to check if MDI alerts on suspicious activity
Hay
A few month ago i found an official document of Microsoft that provide scripts and commands that generate alerts on the defender portal MDI like enumerate actions.
Can someone pls send me the link to this document ?
Thanks
Hay A few month ago i found an official document of Microsoft that provide scripts and commands that generate alerts on the defender portal MDI like enumerate actions.Can someone pls send me the link to this document ?Thanks Read More
Markus Lanz Vortex Genesis AI-So verbessern Sie Ihre Geschäftsfähigkeiten mit Vortex Genesis AI
Nutzen Sie die Vorteile der Vortex Genesis AI, um Ihre Trading-Strategie zu optimieren und Ihre Gewinne zu maximieren. Durch die Implementierung dieser künstlichen Intelligenz können Sie Ihr Risikomanagement verbessern und Ihre Handelsentscheidungen effizienter gestalten. Erfolgreiche Trader berichten bereits von positiven Erfahrungen mit der Vortex Genesis AI und sehen eine vielversprechende Zukunft für das Trading mit künstlicher Intelligenz. Achten Sie jedoch darauf, häufige Fehler im Umgang mit dieser Technologie zu vermeiden, um das volle Potenzial auszuschöpfen.
Risikomanagement neu definiert: Wie Vortex Genesis AI Verluste mindert und Erträge maximiert
Nutzen Sie die Vorteile der Vortex Genesis AI, um Ihre Trading-Strategie zu optimieren und Ihre Gewinne zu maximieren. Durch die Implementierung dieser künstlichen Intelligenz können Sie Ihr Risikomanagement verbessern und Ihre Handelsentscheidungen effizienter gestalten. Erfolgreiche Trader berichten bereits von positiven Erfahrungen mit der Vortex Genesis AI und sehen eine vielversprechende Zukunft für das Trading mit künstlicher Intelligenz. Achten Sie jedoch darauf, häufige Fehler im Umgang mit dieser Technologie zu vermeiden, um das volle Potenzial auszuschöpfen. Risikomanagement neu definiert: Wie Vortex Genesis AI Verluste mindert und Erträge maximiert Read More
Windows zip files
Can we please be able to password protect compressed files created in Windows 11 rather than having to use 7-zip
Can we please be able to password protect compressed files created in Windows 11 rather than having to use 7-zip Read More