Category: Microsoft
Category Archives: Microsoft
Not able to integrate ai multi service
HI am having just the hardest time trying to integrate the Azure AI multi-service in to any sort of copilot (teams, copilot studio, 365 in ms 365 app or teams app or outlooks app, or any copilot. It seems impossible to get this in to a copilot or any ai bot. Any help at all? With at least services like Decision, L, S, V and DI. or – at least least – V, L, DI. Thanks! Matt
HI am having just the hardest time trying to integrate the Azure AI multi-service in to any sort of copilot (teams, copilot studio, 365 in ms 365 app or teams app or outlooks app, or any copilot. It seems impossible to get this in to a copilot or any ai bot. Any help at all? With at least services like Decision, L, S, V and DI. or – at least least – V, L, DI. Thanks! Matt Read More
“Organize mail by thread” for Outlook for Mac
Hello, when do you think we can expect the “Organize mail by thread” feature for Outlook for Mac?
Hello, when do you think we can expect the “Organize mail by thread” feature for Outlook for Mac? Read More
Can anyone record me an easy to use Windows screen recorder?
Sometimes I need to record tutorial videos on my computer for our customers. I search and found that Xbox game bar is a good option. I use it, it did capture my screen. However, it failed to record popup from the software and did not capture all my operations.
Can anyone record me a simple screen recorder for PC? It should allow me to:
Record part of my screenRecord app and file explorer Record screen and webcam at the same timeCapture screen in high resolution
I really need to have such a screen recorder for my work. Thanks!
Please don’t record me OBS studio. I downloaded the open-source app and used it. Sorry, it is so hard for me to record selected area of my screen. It seems that I need to input the distance by pixels.
Sometimes I need to record tutorial videos on my computer for our customers. I search and found that Xbox game bar is a good option. I use it, it did capture my screen. However, it failed to record popup from the software and did not capture all my operations. Can anyone record me a simple screen recorder for PC? It should allow me to: Record part of my screenRecord app and file explorer Record screen and webcam at the same timeCapture screen in high resolution I really need to have such a screen recorder for my work. Thanks!Please don’t record me OBS studio. I downloaded the open-source app and used it. Sorry, it is so hard for me to record selected area of my screen. It seems that I need to input the distance by pixels. Read More
Project Online – Project Owner is changing to old owner automatically.
In project online the owner of project keeps changing to previous(old) owner automatically. Even if we change it back to new owner after some days it will revert back to old owner. Can anyone help me solving this issue.
In project online the owner of project keeps changing to previous(old) owner automatically. Even if we change it back to new owner after some days it will revert back to old owner. Can anyone help me solving this issue. Read More
Windows Login MFA via Intune
Dear Experts,
Does Microsoft support MFA on windows login via Intune?
I know there are third party tools for this but can we enforce windows login MFA via Intune?
Dear Experts,Does Microsoft support MFA on windows login via Intune?I know there are third party tools for this but can we enforce windows login MFA via Intune? Read More
Create Your First Visual Agent Using AOAI and AI Search – Search Product Catalog Images
Search Product Catalog Images Using Azure Search and OpenAI with Langchain
In the ever-evolving landscape of retail, businesses are continually seeking innovative solutions to streamline their operations and enhance customer experiences. One such breakthrough is the implementation of artificial intelligence (AI) to search product catalog images efficiently. This transformative technology not only simplifies the search process but also empowers businesses to provide personalized and seamless shopping experiences for their customers.
The Need for AI in Product Catalog Image Search: Traditional methods of searching through product catalogs involve manual tagging and categorization, which can be time-consuming and prone to human error. As the volume of products in a catalog grows, managing and searching for specific items becomes a daunting task. AI, particularly computer vision, addresses these challenges by automating the recognition and categorization of products in images.
Key Features of AI-Powered Product Catalog Image Search:
Object Recognition and Tagging: AI algorithms can identify and tag objects within images, providing accurate and consistent categorization of products. This reduces the reliance on manual tagging, ensuring that products are correctly labeled in the catalog.
Visual Similarity Search: AI enables visual similarity search, allowing users to find products based on visual attributes rather than relying solely on text-based queries. This feature is especially valuable for customers who may struggle to describe a product in words but can easily recognize it visually.
Enhanced Product Discovery: By understanding the visual characteristics of products, AI facilitates a more sophisticated recommendation system. Customers can discover related or complementary items, leading to increased cross-selling opportunities and a more engaging shopping experience.
Improved Accuracy and Efficiency: AI-powered image recognition is highly accurate and can process large volumes of images in a fraction of the time it would take a human. This efficiency not only reduces operational costs but also enhances the speed at which customers can find and purchase products.
Integration with E-Commerce Platforms: AI-driven image search can seamlessly integrate with existing e-commerce platforms, making it easy for businesses to adopt this technology without major disruptions. This integration allows for a smoother transition and ensures that the AI-enhanced search becomes an integral part of the overall shopping experience.
Now lets try to implement this with Azure OpenAI.
Firs you need to import some libraries
import azure.cognitiveservices.speech as speechsdk
import datetime
import io
import json
import math
import matplotlib.pyplot as plt
import numpy as np
import openai
import os
import random
import requests
import sys
import time
from azure.core.credentials import AzureKeyCredential
from azure.search.documents import SearchClient
from azure.search.documents.indexes import SearchIndexClient
from azure.search.documents.indexes import SearchIndexerClient
from azure.search.documents.indexes.models import (
SearchIndexerDataContainer,
SearchIndexerDataSourceConnection,
)
from azure.storage.blob import BlobServiceClient, generate_blob_sas, BlobSasPermissions
from azure.cognitiveservices.speech import (
AudioDataStream,
SpeechConfig,
SpeechSynthesizer,
SpeechSynthesisOutputFormat,
)
from azure.cognitiveservices.speech.audio import AudioOutputConfig
from azure.search.documents.models import VectorizedQuery,VectorizableTextQuery
from dotenv import load_dotenv
from io import BytesIO
from IPython.display import Audio
from PIL import Image
import os
import base64
import re
from datetime import datetime, timedelta
import requests
import os
from tenacity import (
Retrying,
retry_if_exception_type,
wait_random_exponential,
stop_after_attempt
)
import json
import mimetypes
Initiate some environmental variable for your
Azure OpenAI Endpoint
Azure Cognitive Service End point
Azure Search End point
load_dotenv(“azure.env”)
# Azure Open AI
openai_api_type = os.getenv(“azure”)
openai_api_base = os.getenv(“AZURE_OPENAI_ENDPOINT”)
openai_api_version = os.getenv(“AZURE_API_VERSION”)
openai_api_key = os.getenv(“AZURE_OPENAI_KEY”)
# Azure Cognitive Search
acs_endpoint = os.getenv(“ACS_ENDPOINT”)
acs_key = os.getenv(“ACS_KEY”)
# Azure Computer Vision 4
acv_key = os.getenv(“ACV_KEY”)
acv_endpoint = os.getenv(“ACV_ENDPOINT”)
blob_connection_string = os.getenv(“BLOB_CONNECTION_STRING”)
container_name = os.getenv(“CONTAINER_NAME”)
# Azure Cognitive Search index name to create
index_name = “azure-fashion-demo”
# Azure Cognitive Search api version
api_version = “2023-02-01-preview”
Now lets create a function to create text embedding using vision API
def text_embedding(prompt):
“””
Text embedding using Azure Computer Vision 4.0
“””
version = “?api-version=” + api_version + “&modelVersion=latest”
vec_txt_url = f”{acv_endpoint}/computervision/retrieval:vectorizeText{version}”
headers = {“Content-type”: “application/json”, “Ocp-Apim-Subscription-Key”: acv_key}
payload = {“text”: prompt}
response = requests.post(vec_txt_url, json=payload, headers=headers)
if response.status_code == 200:
text_emb = response.json().get(“vector”)
return text_emb
else:
print(f”Error: {response.status_code} – {response.text}”)
return None
Lets Now lets create a function to create Image embedding using vision API
def image_embedding(image_path):
url = f”{acv_endpoint}/computervision/retrieval:vectorizeImage”
mime_type, _ = mimetypes.guess_type(image_path)
headers = {
“Content-Type”: mime_type,
“Ocp-Apim-Subscription-Key”: acv_key
}
for attempt in Retrying(
retry=retry_if_exception_type(requests.HTTPError),
wait=wait_random_exponential(min=15, max=60),
stop=stop_after_attempt(15)
):
with attempt:
with open(image_path, ‘rb’) as image_data:
response = requests.post(url, params=params, headers=headers, data=image_data)
if response.status_code != 200:
response.raise_for_status()
vector = response.json()[“vector”]
return vector
Next thing we require is to create a function which takes a text prompt as input and search Azure Search for most relevant images. Here Buy Now Link is a dummy link which can be replaced with actual product URL
def prompt_search(prompt, topn=5, disp=False):
“””
Azure Cognitive visual search using a prompt
“””
results_list = []
# Initialize the Azure Cognitive Search client
search_client = SearchClient(acs_endpoint, index_name, AzureKeyCredential(acs_key))
blob_service_client = BlobServiceClient.from_connection_string(blob_connection_string)
container_client = blob_service_client.get_container_client(container_name)
# Perform vector search
vector_query = VectorizedQuery(vector=text_embedding(prompt), k_nearest_neighbors=topn, fields=”image_vector”)
response = search_client.search(
search_text=prompt, vector_queries= [vector_query], select=[“description”], top = 2
)
for nb, result in enumerate(response, 1):
blob_name = result[“description”] + “.jpg”
blob_client = container_client.get_blob_client(blob_name)
image_url = blob_client.url
sas_token = generate_blob_sas(
blob_service_client.account_name,
container_name,
blob_name,
account_key=blob_client.credential.account_key,
permission=BlobSasPermissions(read=True),
expiry=datetime.utcnow() + timedelta(hours=1)
)
sas_url = blob_client.url + “?” + sas_token
results_list.append({“buy_now_link” : sas_url,”price_of_the_product”: result[“description”], “product_image_url”: sas_url})
return results_list
Lets ingest some Product Images to the Azure Search. Here we are basically the idea is we have folder called images having all the product images stored. We are basically creating a container and uploading all the images from the folder to the specific container.
EMBEDDINGS_DIR = “embeddings”
os.makedirs(EMBEDDINGS_DIR, exist_ok=True)
image_directory = os.path.join(‘images’)
embedding_directory = os.path.join(’embeddings’)
output_json_file = os.path.join(embedding_directory, ‘output.jsonl’)
for root, dirs, files in os.walk(image_directory):
for file in files:
local_file_path = os.path.join(root, file)
blob_name = os.path.relpath(local_file_path, image_directory)
with open(local_file_path, “rb”) as data:
blob_client.upload_blob(data, overwrite=True)
Next we will create the embedding of the product images and store the same locally in the embedding directory. Point to note is that we have used only 2 metadata id and description. You can basically extend to many more metadata like price, buy now link etc.
with open(output_json_file, ‘w’) as outfile:
for idx, image_path in enumerate(os.listdir(image_directory)):
if image_path:
try:
vector = image_embedding(os.path.join(image_directory, image_path))
except Exception as e:
print(f”Error processing image at index {idx}: {e}”)
vector = None
filename, _ = os.path.splitext(os.path.basename(image_path))
result = {
“id”: f'{idx}’,
“image_vector”: vector,
“description”: filename
}
outfile.write(json.dumps(result))
outfile.write(‘n’)
outfile.flush()
print(f”Results are saved to {output_json_file}”)
Now since have created the local embedding file , we can upload the same into a Azure Search. Before that lets create an index .
from azure.search.documents.indexes import SearchIndexClient
from azure.search.documents.indexes.models import (
SimpleField,
SearchField,
SearchFieldDataType,
VectorSearch,
HnswAlgorithmConfiguration,
VectorSearchProfile,
SearchIndex
)
credential = AzureKeyCredential(acs_key)
# Create a search index
index_client = SearchIndexClient(endpoint=acs_endpoint, credential=credential)
fields = [
SimpleField(name=”id”, type=SearchFieldDataType.String, key=True),
SearchField(name=”description”, type=SearchFieldDataType.String, sortable=True, filterable=True, facetable=True),
SearchField(
name=”image_vector”,
hidden=True,
type=SearchFieldDataType.Collection(SearchFieldDataType.Single),
searchable=True,
vector_search_dimensions=1024,
vector_search_profile_name=”myHnswProfile”
),
]
# Configure the vector search configuration
vector_search = VectorSearch(
algorithms=[
HnswAlgorithmConfiguration(
name=”myHnsw”
)
],
profiles=[
VectorSearchProfile(
name=”myHnswProfile”,
algorithm_configuration_name=”myHnsw”,
)
],
)
# Create the search index with the vector search configuration
index = SearchIndex(name=index_name, fields=fields, vector_search=vector_search)
result = index_client.create_or_update_index(index)
print(f”{result.name} created”)
Once you have created the index , you can upload the locally stored index file.
from azure.search.documents import SearchClient
import json
data = []
with open(output_json_file, ‘r’) as file:
for line in file:
# Remove leading/trailing whitespace and parse JSON
json_data = json.loads(line.strip())
data.append(json_data)
search_client = SearchClient(endpoint=acs_endpoint, index_name=index_name, credential=credential)
results = search_client.upload_documents(data)
for result in results:
print(f’Indexed {result.key} with status code {result.status_code}’)
Congratulations you have finally ready to implement your Agent using OpenAI
Lets create tool called image search which will be used by the Agent
from typing import Optional
from langchain_core.callbacks import CallbackManagerForToolRun
from langchain_core.tools import BaseTool
from util import prompt_search
class ImageSearchResults(BaseTool):
“””Tool that queries the Fashion Image Search API and gets back json.”””
name: str = “image_search_results_json”
description: str = (
“A wrapper around Image Search. “
“Useful for when you need search fashion images related to cloth , shoe etc”
“Input should be a search query. Output is a JSON array of the query results”
)
num_results: int = 4
def _run(
self,
query: str,
run_manager: Optional[CallbackManagerForToolRun] = None,
) -> str:
“””Use the tool.”””
return str(prompt_search(prompt = query, topn=self.num_results))
Here we will be using Langchain to implement our Fashion Agent called Luca
from langchain_core.prompts.chat import (
BaseMessagePromptTemplate,
ChatPromptTemplate,
HumanMessagePromptTemplate,
MessagesPlaceholder,
SystemMessagePromptTemplate,
PromptTemplate,
)
from langchain_core.messages import AIMessage, HumanMessage, SystemMessage
from langchain_core.runnables import Runnable, RunnablePassthrough
from langchain_community.tools.convert_to_openai import format_tool_to_openai_function
from langchain_core.utils.function_calling import convert_to_openai_function
from langchain.agents.output_parsers.openai_functions import (
OpenAIFunctionsAgentOutputParser,
)
from langchain.agents.format_scratchpad.openai_functions import (
format_to_openai_function_messages,
)
from langchain.agents import AgentExecutor
from langchain_openai import AzureChatOpenAI
from langchain_core.runnables import RunnableConfig
from custom_tool import ImageSearchResults
import openai
Lets initialize our LLM
from langchain_openai import AzureChatOpenAI
llm = AzureChatOpenAI(
api_key=os.environ[“AZURE_OPENAI_KEY”],
api_version=”2023-12-01-preview”,
azure_endpoint=os.environ[“AZURE_OPENAI_ENDPOINT”],
model=”gpt-4-turbo”,
)
llm(messages=[HumanMessage(content = “Hi”)])
prefix=”””You are Luca a helpful Fashion Agent who help people navigating and buying products online
Note:
\ Show Prices always in INR
\ Always try user to buy from the buy now link provided”””
suffix = “”
Lets attach tool we created, here we are using LCEL to implement out agent
tools = [ImageSearchResults(num_results=5)]
llm_with_tools = llm.bind(
functions=[convert_to_openai_function(t) for t in tools]
)
messages = [
SystemMessage(content=prefix),
HumanMessagePromptTemplate.from_template(“{input}”),
AIMessage(content=suffix),
MessagesPlaceholder(variable_name=”agent_scratchpad”),
]
input_variables = [“input”, “agent_scratchpad”]
prompt = ChatPromptTemplate(input_variables=input_variables, messages=messages)
agent = (
RunnablePassthrough.assign(
agent_scratchpad=lambda x: format_to_openai_function_messages(
x[“intermediate_steps”]
)
)
| prompt
| llm_with_tools
| OpenAIFunctionsAgentOutputParser()
)
Congratulation !! You are ready to test your Agent
response = agent_executor.invoke(
{
“input”: “I am looking for some summer dress as I am travelling to new Delhi”,
“chat_history”: [
HumanMessage(content=”hi! my name is bob”),
AIMessage(content=”Hello Bob! How can I assist you today?”),
],
}
)
Hurray !! You are now ready to deploy this Agent to a Enterprise App with some good looking UI.
Here is the reference github repo with all the code artifact.
https://github.com/monuminu/AOAI_Samples/tree/main/content_product_tagging
Favor : Please clap if you like this and Follow me for more such content.
References:
Microsoft Tech Community – Latest Blogs –Read More
Ned help with my excel
Hey guys i’m trying to make a spreadsheet to keep track of my golf putts and percentages but it keeps returning a huge percent and i would like to see out of 100 if this makes any sense.
Hey guys i’m trying to make a spreadsheet to keep track of my golf putts and percentages but it keeps returning a huge percent and i would like to see out of 100 if this makes any sense. Read More
Protect data on an unmanaged device
For various reasons my employer wants to allow people to access their email (on prem right now soon to be exo) from a personal hone with absolutely zero management of that device.
Access can be granted easily enough but if that person leaves how do I deal with the emails sitting on the device?
Do I ban the native mail app and only require Outlook app? Only allow email from Outlook if the devices unmanaged or some combination of using the Outlook app, CA policies, mobile device mailbox policy in EXO etc. allow me to prevent access to the Outlook app and therefore downloaded emails if their account no longer exists.
I don’t care if they add their personal emails to the outlook app and then can’t access it, they can just delete the app and reinstall it and add their personal email again.
Any ideas?
For various reasons my employer wants to allow people to access their email (on prem right now soon to be exo) from a personal hone with absolutely zero management of that device. Access can be granted easily enough but if that person leaves how do I deal with the emails sitting on the device? Do I ban the native mail app and only require Outlook app? Only allow email from Outlook if the devices unmanaged or some combination of using the Outlook app, CA policies, mobile device mailbox policy in EXO etc. allow me to prevent access to the Outlook app and therefore downloaded emails if their account no longer exists. I don’t care if they add their personal emails to the outlook app and then can’t access it, they can just delete the app and reinstall it and add their personal email again. Any ideas? Read More
MDE extension getting pushed automatically but failing
Hi members,
My tenant has Defender for Endpoint already for cloud-native devices and at the same time, I have Defender for Cloud Plan 1 enabled for my Azure VMs (Windows 11). These machines are also reporting on Defender for Endpoint but the MDE extensions keeps failing due to unsupported OS. I did a workaround and turned OFF Endpoint Protection from the Plan 1 and the issue is not occurring anymore.
My question: Should I deploy MDE from Defender for Endpoint for these machines and keep “Endpoint Protection” turned OFF from Defender for Cloud? It seems it is conflicting.
Hi members, My tenant has Defender for Endpoint already for cloud-native devices and at the same time, I have Defender for Cloud Plan 1 enabled for my Azure VMs (Windows 11). These machines are also reporting on Defender for Endpoint but the MDE extensions keeps failing due to unsupported OS. I did a workaround and turned OFF Endpoint Protection from the Plan 1 and the issue is not occurring anymore. My question: Should I deploy MDE from Defender for Endpoint for these machines and keep “Endpoint Protection” turned OFF from Defender for Cloud? It seems it is conflicting. Read More
Windows 10’s Start menu Colored Tiles
This will let users have the option to re-enable the colored tiles without using regedit.
This will let users have the option to re-enable the colored tiles without using regedit. Start menu tile color Read More
Copilot Outlook and Teams cannot find next meeting with someone
The meeting is dated 2024-09-18 with someone. Copilot is unable to answer it even I specifically hinted the 2024 Sep.
The meeting is dated 2024-09-18 with someone. Copilot is unable to answer it even I specifically hinted the 2024 Sep. Read More
Troubleshooting by windows server 2019
Hi Community,
I need your wisdom to stop windows server 2019 from rebooting on its own.
I believe that the reboot is caused by windows update because I saw the following code in the logs
Service pack (Planned)
Reason Code:0x80020010
I reboot once every two weeks using task-scheduler.
But the day after the reboot, it rebooted itself again!
I checked the GPOs applied using gpresult /H and found the following
Specify an automatic restart deadline to install updates
Quality Updates : 14
Feature updates : 14
Configure Automatic Updates: 4
Installing during automatic maintenance
Disabled
Allow automatic updates to be installed immediately
Enabled
Is there any setting that is missing?
Hi Community,I need your wisdom to stop windows server 2019 from rebooting on its own.I believe that the reboot is caused by windows update because I saw the following code in the logs Service pack (Planned)Reason Code:0x80020010 I reboot once every two weeks using task-scheduler.But the day after the reboot, it rebooted itself again!I checked the GPOs applied using gpresult /H and found the following Specify an automatic restart deadline to install updatesQuality Updates : 14Feature updates : 14 Configure Automatic Updates: 4Installing during automatic maintenanceDisabled Allow automatic updates to be installed immediatelyEnabledIs there any setting that is missing? Read More
Error Code “Excel ran our of resources while attempting to calculate one or more formulas”
Hi there!
I couldn’t find an updated response to this issue so figured I would repost for some help. I am getting the error code “Excel ran our of resources while attempting to calculate one or more formulas” every time I try to enter anything in a cell…
Using Microsoft 365, Ver 2405, 16.0.176.28.20006
Hi there! I couldn’t find an updated response to this issue so figured I would repost for some help. I am getting the error code “Excel ran our of resources while attempting to calculate one or more formulas” every time I try to enter anything in a cell… Using Microsoft 365, Ver 2405, 16.0.176.28.20006 Read More
Excel Copilot does not work with dates
My worksheet Column B is Log Date
Using system suggested prompt:
Show items with ‘Log Date’ of ‘2024-06-14’
Or I tried:
Filter Log Date that is 2024-06-17
Almost all the time it doesn’t work. As shown in attached screenshots.
My worksheet Column B is Log DateUsing system suggested prompt: Show items with ‘Log Date’ of ‘2024-06-14’ Or I tried: Filter Log Date that is 2024-06-17 Almost all the time it doesn’t work. As shown in attached screenshots. Read More
scan to email
Hello
Please i need your help on this issue.
Scan account has Authen account settings but getting errors when trying to do a scan to email T5872147220973: The transport failed to connect to the server
Hello Please i need your help on this issue. Scan account has Authen account settings but getting errors when trying to do a scan to email T5872147220973: The transport failed to connect to the server Read More
Teams needs a Copilot button on team channel level
Currently Teams Copilot is available on:
1. Left panel level
2. Chat header level
3. Individual chat level
4. Team channel within single conversation level
On Web Copilot and Left panel level Copilot, I am not able to target a specific team channel in prompt. It always answers “I’m sorry, but it seems there is no specific information available regarding the XXX team General channel about XXX”.
Within the team channel, Copilot is available only on single conversation level. An I can still get “This conversation doesn’t have enough activity to generate a response.” for a conversation with 14 replies. And I can’t prompt for things happen within the channel.
Teams needs a Copilot button on team channel level!!!
Currently Teams Copilot is available on:1. Left panel level2. Chat header level3. Individual chat level4. Team channel within single conversation level On Web Copilot and Left panel level Copilot, I am not able to target a specific team channel in prompt. It always answers “I’m sorry, but it seems there is no specific information available regarding the XXX team General channel about XXX”. Within the team channel, Copilot is available only on single conversation level. An I can still get “This conversation doesn’t have enough activity to generate a response.” for a conversation with 14 replies. And I can’t prompt for things happen within the channel. Teams needs a Copilot button on team channel level!!! Read More
Error when trying to deploy ARM template
I’m receiving the following error when trying to deploy an Azure VM using an ARM template. Hoping someone can help!
New-AzResourceGroupDeployment -ResourceGroupName $rgName -TemplateFile $templateFile -TemplateParameterFile $parametersFile
New-AzResourceGroupDeployment: Cannot retrieve the dynamic parameters for the cmdlet. Your Azure credentials have not been set up or have expired, please run Connect-AzAccount to set up your Azure credentials.
SharedTokenCacheCredential authentication failed: Unknown Status: Unexpected
Error: 0xcaa5004b
Context: (pii)
Tag: 0x21213023 (error code 3399811147) (internal error code 555823139)
I downloaded the template and parameters JSON files from Azure (from the create new VM process).
I have tried authentication with both Connect-AzAccount and Connect-AzAccount -DeviceCode.
I’m receiving the following error when trying to deploy an Azure VM using an ARM template. Hoping someone can help! New-AzResourceGroupDeployment -ResourceGroupName $rgName -TemplateFile $templateFile -TemplateParameterFile $parametersFile New-AzResourceGroupDeployment: Cannot retrieve the dynamic parameters for the cmdlet. Your Azure credentials have not been set up or have expired, please run Connect-AzAccount to set up your Azure credentials.SharedTokenCacheCredential authentication failed: Unknown Status: UnexpectedError: 0xcaa5004bContext: (pii)Tag: 0x21213023 (error code 3399811147) (internal error code 555823139) I downloaded the template and parameters JSON files from Azure (from the create new VM process). I have tried authentication with both Connect-AzAccount and Connect-AzAccount -DeviceCode. Read More
ODBC version compatible with OS and SQL server version
Hi,
Im trying to pratice to run SQL server and Im wondering ODBC version is compatible with specific OS version and SQL server version.
Im using redhat 9.0 and SQL server 2008, 2019.
And if there is a official guide to learn, please let me know.
Thx
Hi,Im trying to pratice to run SQL server and Im wondering ODBC version is compatible with specific OS version and SQL server version.Im using redhat 9.0 and SQL server 2008, 2019.And if there is a official guide to learn, please let me know.Thx Read More
iCloud sync solution for 32-bit Outlook (incorrect password, default profile error, iCloud repair)
As of version 15.x.x, iCloud for Outlook appears to be permanently broken when synchronizing contacts and calendars. The previous steps posted in “iCloud for Outlook Incorrect Username or Password” no longer work. As per a comment by @MarMD in that thread, 64-bit office is the solution.
Some people are able to fix the issue simply by upgrading to 64-bit office.
If that doesn’t work on the first try, the solutions below include additional steps to make it happen.
(We had one PC just work, one required a few additional tweaks in Solution A, another required the full battery of steps in Solution B).
Please note that both lists below are solutions, /not/ recommendations — please decide for yourself.
– Mike
——————————————————————————————————-
SOLUTION A: 64-BIT OFFICE — WITH A FEW INSTALLATION TWEAKS
This usually works, and ran fine the first time on one of our PC’s.
1. Back up your current contacts and calendars from Outlook and from iCloud in Outlook to .pst files
2. Remove all 32-bit Office installations, including msAccess runtimes
(msOffice installers insist upon 32-bits if there are any 32-bit Office components installed)
3. Reboot
4. Install 64-bit Office including Outlook
To force this, you may need to specify a config.xml file
See the attached .xml and .bat files show examples on how to specify the bits for the
installation, as well as how to exclude specific Office applications like Lync and Groove.
Note: these are examples to play with, not a full tutorial
5. Reboot.
6. Install iCloud, but do NOT enable any features yet
This includes Outlook/Calendar/Contacts integration in the final step of the installation wizard.
7. Open iCloud.
8. Turn on Calendars and Contacts
9. Follow the steps in the wizard
10. If there’s no error, go to step 12.
11. If there’s an error, including any of the following, go to SOLUTION B.
– Setup can’t continue because outlook isn’t configured to have a default profile
– Incorrect username or password
– iCloud outlook repair required
12. If you open Outlook at the iCloud ribbon section shows on these ribbons, click Refresh
– Home ribbon
– iCloud ribbon
13. If refresh works, celebrate, you’re done!
14. If the iCloud ribbon sections don’t show, continue.
15. Go to File -> Options -> Add-ins -> Manage: COM Add-ins -> Go…
16. If iCloud Outlook Add-in is available, but un-checked, check it.
17. If the iCloud Oudlook Add-in does not show, click Add… and pick it from:
%ProgramData%Apple InciCloudOutlookaplzod6432.dll (generic path, should work)
C:ProgramDataApple InciCloudOutlookaplzod6432.dll (typical path, might work)
18. Enable the iCloud Outlook Add-in
19. Re-start Outlook
20. If all works, now enable iCloud Photos, Drive, and other features
(waited until now for other features just in case we had to sign out of iCloud while
debugging, which removes all iCloud content and settings from the computer)
——————————————————————————————————-
SOLUTION B: 64-BIT OFFICE — WITH ADDITIONAL FOLDER PERMISSIONS
This was required on a PC that just didn’t want to cooperate.
It’s not pretty, and requires admin privileges, some freeware, and some tech experitise. But it worked.
1. Go through steps 1-10 in Solution A
2. Install Nirsoft’s Advanced Run utility and 7-zip multi-archive software, both non-adware freeware
3. Run Advanced Run
4. Choose 7-zip’s file manager: 7zFM.exe for Program to Run
5. Run as… TrustedInstaller
6. Navigate to the iCloud master folder in %programFiles%WindowsApps
As of the date of this post, with iCloud 15.0.215.0:
C:Program FilesWindowsApps
AppleInc.iCloud_15.0.215.0_x64__nzyj5cx40ttqa
7. Right-click on the iCloud folder and choose properties -> security -> advanced
8. Add localPCAdministrators to permissions, full control, for this folder, subfolder, and files
9. Add the current user to permissions, full control, for this folder, subfolder, and files
Note: step 9 is required even if the current user is an admin. No idea why.
10. Apply
11. Close iCloud and reopen
12. Turn on Calendars and Contacts
13. Follow the steps in the wizard
14. This should now work, in which case go to step 12 in SOLUTION A above
If not…
15. Close iCloud
16. In the iCloud application subfolder, manually run iCloudOutlook64.msi
As of the date of this post, with iCloud 15.0.215.0:
C:Program FilesWindowsApps
AppleInc.iCloud_15.0.215.0_x64__nzyj5cx40ttqa
iCloudiCloudOutlook64.msi
17. Run iCloud again
18. Turn on Calendars and Contacts
19. Follow the steps in the wizard
20. This should now work, in which case go to step 12 in SOLUTION A above
If not… I really have no idea
GOOD LUCK!
As of version 15.x.x, iCloud for Outlook appears to be permanently broken when synchronizing contacts and calendars. The previous steps posted in “iCloud for Outlook Incorrect Username or Password” no longer work. As per a comment by @MarMD in that thread, 64-bit office is the solution. Some people are able to fix the issue simply by upgrading to 64-bit office. If that doesn’t work on the first try, the solutions below include additional steps to make it happen.(We had one PC just work, one required a few additional tweaks in Solution A, another required the full battery of steps in Solution B). Please note that both lists below are solutions, /not/ recommendations — please decide for yourself. – Mike ——————————————————————————————————-SOLUTION A: 64-BIT OFFICE — WITH A FEW INSTALLATION TWEAKSThis usually works, and ran fine the first time on one of our PC’s. 1. Back up your current contacts and calendars from Outlook and from iCloud in Outlook to .pst files2. Remove all 32-bit Office installations, including msAccess runtimes (msOffice installers insist upon 32-bits if there are any 32-bit Office components installed)3. Reboot4. Install 64-bit Office including Outlook To force this, you may need to specify a config.xml file See the attached .xml and .bat files show examples on how to specify the bits for the installation, as well as how to exclude specific Office applications like Lync and Groove. Note: these are examples to play with, not a full tutorial5. Reboot.6. Install iCloud, but do NOT enable any features yet This includes Outlook/Calendar/Contacts integration in the final step of the installation wizard.7. Open iCloud.8. Turn on Calendars and Contacts9. Follow the steps in the wizard10. If there’s no error, go to step 12.11. If there’s an error, including any of the following, go to SOLUTION B. – Setup can’t continue because outlook isn’t configured to have a default profile – Incorrect username or password – iCloud outlook repair required12. If you open Outlook at the iCloud ribbon section shows on these ribbons, click Refresh – Home ribbon – iCloud ribbon13. If refresh works, celebrate, you’re done!14. If the iCloud ribbon sections don’t show, continue.15. Go to File -> Options -> Add-ins -> Manage: COM Add-ins -> Go…16. If iCloud Outlook Add-in is available, but un-checked, check it.17. If the iCloud Oudlook Add-in does not show, click Add… and pick it from: %ProgramData%Apple InciCloudOutlookaplzod6432.dll (generic path, should work) C:ProgramDataApple InciCloudOutlookaplzod6432.dll (typical path, might work)18. Enable the iCloud Outlook Add-in19. Re-start Outlook20. If all works, now enable iCloud Photos, Drive, and other features (waited until now for other features just in case we had to sign out of iCloud while debugging, which removes all iCloud content and settings from the computer) ——————————————————————————————————-SOLUTION B: 64-BIT OFFICE — WITH ADDITIONAL FOLDER PERMISSIONSThis was required on a PC that just didn’t want to cooperate.It’s not pretty, and requires admin privileges, some freeware, and some tech experitise. But it worked.1. Go through steps 1-10 in Solution A2. Install Nirsoft’s Advanced Run utility and 7-zip multi-archive software, both non-adware freeware3. Run Advanced Run4. Choose 7-zip’s file manager: 7zFM.exe for Program to Run5. Run as… TrustedInstaller6. Navigate to the iCloud master folder in %programFiles%WindowsApps As of the date of this post, with iCloud 15.0.215.0: C:Program FilesWindowsApps AppleInc.iCloud_15.0.215.0_x64__nzyj5cx40ttqa7. Right-click on the iCloud folder and choose properties -> security -> advanced8. Add localPCAdministrators to permissions, full control, for this folder, subfolder, and files9. Add the current user to permissions, full control, for this folder, subfolder, and files Note: step 9 is required even if the current user is an admin. No idea why.10. Apply11. Close iCloud and reopen12. Turn on Calendars and Contacts13. Follow the steps in the wizard14. This should now work, in which case go to step 12 in SOLUTION A above If not…15. Close iCloud16. In the iCloud application subfolder, manually run iCloudOutlook64.msi As of the date of this post, with iCloud 15.0.215.0: C:Program FilesWindowsApps AppleInc.iCloud_15.0.215.0_x64__nzyj5cx40ttqa iCloudiCloudOutlook64.msi17. Run iCloud again18. Turn on Calendars and Contacts19. Follow the steps in the wizard20. This should now work, in which case go to step 12 in SOLUTION A aboveIf not… I really have no idea GOOD LUCK! Read More
Announcing public preview for Geo-replication for Azure Event Hubs Dedicated
Azure Event Hubs is a fully managed, cloud-native, real-time data streaming service that enables you to stream millions of events per second from any source to build dynamic data pipelines and immediately respond to business challenges. It sits at the center of all the operational and analytical workflows for Azure’s customers – whether they are large enterprises or scrappy startups, enabling them to leverage their streaming data to enable new workflows, all in real time.
Data availability and service reliability are core tenets of a cloud-native service and today we are excited to announce the public preview of geo-replication for Azure Event Hubs to complete our story. Geo-replication builds on and fortifies our data availability and geo-disaster recovery story, by allowing you to replicate your Event Hubs data payloads across different Azure regions.
With geo-replication, client applications still talk to the primary copy of the namespace, but customers can specify a secondary region, replication consistency (synchronous or asynchronous) and replication lag for the data, and the service takes care of replicating the data between primary and secondary regions. When customers need to change the primary (for planned maintenance or forced failover), they can promote the secondary copy to be the primary and all client requests are then serviced by the new primary, without changing any configuration (connection strings, authentication, etc.) on the client application. The previous primary then becomes demoted to a secondary region, ensuring that both primary and secondary copies are in sync.
Geo-replication is designed to provide you with the following benefits:
High availability: You can ensure that your data is always accessible and durable, even in the event of a regional outage or disruption. You can also reduce the impact of planned maintenance events by switching to the secondary region before the primary region undergoes any updates or changes.
Disaster recovery: You can recover your data quickly and seamlessly in case of a disaster that affects your primary region. You can initiate a failover to the secondary region and resume your data streaming operations with minimal downtime and data loss.
Regional compliance: You can meet the regulatory and compliance requirements of your industry or region by replicating your data to a secondary region that complies with the same or similar standards as your primary region. You can also leverage the geo-redundancy of your data to support your business continuity and resilience plans.
Pricing
The Dedicated tier for Event Hubs is priced per Capacity Unit. With the Geo-Replication feature, customers must provision a dedicated cluster in secondary region, and the pricing is calculated over the total number of CUs provisioned. Additionally, there is a charge for the data transfer between the primary and secondary regions. During the early public preview, this data transfer charge is waived.
Which regions support Azure Event Hubs Geo-replication?
We’re rolling out the geo-replication feature across our entire fleet, but at launch you can get started by creating Event Hubs dedicated clusters in the below regions:
US
Central US EUAP
Europe
Italy North
Spain Central
Norway East
How to get started with Azure Event Hubs Geo-replication?
If you are interested in trying out Azure Event Hubs Geo-replication, please check out the official documentation – Azure Event Hubs Geo-replication documentation.
We hope that you find Azure Event Hubs Geo-replication useful and valuable for your data streaming scenarios. We look forward to hearing your feedback and suggestions on how to improve this feature and make it more suitable for your needs.
Microsoft Tech Community – Latest Blogs –Read More