Category: Microsoft
Category Archives: Microsoft
CVE-2022-41099, WinRE vulnerability, update, KB5025175, does the script work?
[ Edited to add version numbers that I noticed in the script, and to add a question about the script contents related to that ]
Microsoft have recently(? there’s no date on the webpage, but it was mentioned in a recent Microsoft Security update announcement) updated the WinRE update deployment PowerShell script “PatchWinREScript_2004plus.ps1”.
I’ve run it on two computers (both of them patched-up-to-date Windows 11 23H2), using the file:
windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab
.. as downloaded as suggested from the KB article link above as the most recent update package available (dated a few days ago, this month May 2024).
On both, this line appears in the output:
“Warning: After applying the patch, unexpected version found for the target file“
When I look in the (booted OS’) C:WindowsSystem32 at the target file, bootmenuux.dll, on this 23H2 system, it too has the version 10.0.22621.1635 (which a Windows 11 release history webpage says is from 22H2, not from 23H2) about which the update script complains as being unexpected. So I’m not sure that the error is correct, so to speak, or whether the WinRE update worked just fine, and for some reason the script was expecting something _other_ than the currently-correct bootmenuux.dll file? (I suppose it’s possible that Microsoft’s most recent release, even in 23H2, of this particular file, happens to be a patched version still marked as part of the 22H2 release?)
I notice that the script has a list of known Windows version numbers, which only goes up to Windows 11 22H2 22621.815.
The whole output of the update script is below.
Can someone please comment whether:
the windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab file from the Windows Update Catalog is in fact the updated, patched version which needs to be baked into WinRE, andthe error from the update script is incorrect, actually the script worked correctly and the WinRE now contains a version of the file which is not vulnerable? or, possiblythe script is NOT actually up-to-date at all, being that it doesn’t explicitly know about Windows versions newer than Windows 11 22H2 ?
(I won’t even ask 4. Why Microsoft hasn’t automated WinRE patching into Windows Update…)
thanks,
PS C:Temp> .PatchWinREScript_2004plus.ps1
cmdlet PatchWinREScript_2004plus.ps1 at command pipeline position 1
Supply values for the following parameters:
(Type !? for Help.)
packagePath: windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab
05/30/2024 09:27:29 – No input for mount directory
05/30/2024 09:27:29 – Use default path from temporary directory
05/30/2024 09:27:29 – Working Dir: C:UserslocaladmAppDataLocalTemp
05/30/2024 09:27:29 – MountDir: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
05/30/2024 09:27:29 – Create mount directory C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Directory: C:UserslocaladmAppDataLocalTemp
Mode LastWriteTime Length Name
—- ————- —— —-
d—– 30/05/2024 09:27 CA551926-299B-27A55276EC22_Mount
05/30/2024 09:27:29 – Set ACL for mount directory
processed file: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Successfully processed 1 files; Failed processing 0 files
processed file: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Successfully processed 1 files; Failed processing 0 files
processed file: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Successfully processed 1 files; Failed processing 0 files
05/30/2024 09:27:29 – Mount WinRE:
REAGENTC.EXE: Operation Successful.
05/30/2024 09:27:42 – TargetFile: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_MountWindowsSystem32bootmenuux.dll
05/30/2024 09:27:42 – Target file version: 10.0.22621.1635
05/30/2024 09:27:42 – Windows 11, version 22H2
05/30/2024 09:27:42 – Apply package:windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab
05/30/2024 09:27:48 – Successfully applied the package
05/30/2024 09:27:48 – Cleanup image
05/30/2024 09:27:50 – Cleanup image succeed
05/30/2024 09:27:50 – TargetFile: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_MountWindowsSystem32bootmenuux.dll
05/30/2024 09:27:50 – Target file version: 10.0.22621.1635
05/30/2024 09:27:50 – Windows 11, version 22H2
05/30/2024 09:27:50 – Warning: After applying the patch, unexpected version found for the target file
05/30/2024 09:27:50 – Patch succeed, unmount to commit change
Deployment Image Servicing and Management tool
Version: 10.0.22621.2792
Saving image
[==========================100.0%==========================]
Unmounting image
[==========================100.0%==========================]
The operation completed successfully.
05/30/2024 09:28:23 – Delete mount direcotry
[ Edited to add version numbers that I noticed in the script, and to add a question about the script contents related to that ] At https://support.microsoft.com/en-gb/topic/kb5025175-updating-the-winre-partition-on-deployed-devices-to-address-security-vulnerabilities-in-cve-2022-41099-ba6621fa-5a9f-48f1-9ca3-e13eb56fb589#articleFooterSupportBridge=communityBridgeMicrosoft have recently(? there’s no date on the webpage, but it was mentioned in a recent Microsoft Security update announcement) updated the WinRE update deployment PowerShell script “PatchWinREScript_2004plus.ps1″.I’ve run it on two computers (both of them patched-up-to-date Windows 11 23H2), using the file:windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab.. as downloaded as suggested from the KB article link above as the most recent update package available (dated a few days ago, this month May 2024).On both, this line appears in the output:”Warning: After applying the patch, unexpected version found for the target file” When I look in the (booted OS’) C:WindowsSystem32 at the target file, bootmenuux.dll, on this 23H2 system, it too has the version 10.0.22621.1635 (which a Windows 11 release history webpage says is from 22H2, not from 23H2) about which the update script complains as being unexpected. So I’m not sure that the error is correct, so to speak, or whether the WinRE update worked just fine, and for some reason the script was expecting something _other_ than the currently-correct bootmenuux.dll file? (I suppose it’s possible that Microsoft’s most recent release, even in 23H2, of this particular file, happens to be a patched version still marked as part of the 22H2 release?) I notice that the script has a list of known Windows version numbers, which only goes up to Windows 11 22H2 22621.815. The whole output of the update script is below.Can someone please comment whether:the windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab file from the Windows Update Catalog is in fact the updated, patched version which needs to be baked into WinRE, andthe error from the update script is incorrect, actually the script worked correctly and the WinRE now contains a version of the file which is not vulnerable? or, possiblythe script is NOT actually up-to-date at all, being that it doesn’t explicitly know about Windows versions newer than Windows 11 22H2 ?(I won’t even ask 4. Why Microsoft hasn’t automated WinRE patching into Windows Update…) thanks, PS C:Temp> .PatchWinREScript_2004plus.ps1
cmdlet PatchWinREScript_2004plus.ps1 at command pipeline position 1
Supply values for the following parameters:
(Type !? for Help.)
packagePath: windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab
05/30/2024 09:27:29 – No input for mount directory
05/30/2024 09:27:29 – Use default path from temporary directory
05/30/2024 09:27:29 – Working Dir: C:UserslocaladmAppDataLocalTemp
05/30/2024 09:27:29 – MountDir: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
05/30/2024 09:27:29 – Create mount directory C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Directory: C:UserslocaladmAppDataLocalTemp
Mode LastWriteTime Length Name
—- ————- —— —-
d—– 30/05/2024 09:27 CA551926-299B-27A55276EC22_Mount
05/30/2024 09:27:29 – Set ACL for mount directory
processed file: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Successfully processed 1 files; Failed processing 0 files
processed file: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Successfully processed 1 files; Failed processing 0 files
processed file: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_Mount
Successfully processed 1 files; Failed processing 0 files
05/30/2024 09:27:29 – Mount WinRE:
REAGENTC.EXE: Operation Successful.
05/30/2024 09:27:42 – TargetFile: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_MountWindowsSystem32bootmenuux.dll
05/30/2024 09:27:42 – Target file version: 10.0.22621.1635
05/30/2024 09:27:42 – Windows 11, version 22H2
05/30/2024 09:27:42 – Apply package:windows11.0-kb5037739-x64_d841b10d8b13bb39a95eaa43240b048cebf51f05.cab
05/30/2024 09:27:48 – Successfully applied the package
05/30/2024 09:27:48 – Cleanup image
05/30/2024 09:27:50 – Cleanup image succeed
05/30/2024 09:27:50 – TargetFile: C:UserslocaladmAppDataLocalTempCA551926-299B-27A55276EC22_MountWindowsSystem32bootmenuux.dll
05/30/2024 09:27:50 – Target file version: 10.0.22621.1635
05/30/2024 09:27:50 – Windows 11, version 22H2
05/30/2024 09:27:50 – Warning: After applying the patch, unexpected version found for the target file
05/30/2024 09:27:50 – Patch succeed, unmount to commit change
Deployment Image Servicing and Management tool
Version: 10.0.22621.2792
Saving image
[==========================100.0%==========================]
Unmounting image
[==========================100.0%==========================]
The operation completed successfully.
05/30/2024 09:28:23 – Delete mount direcotry Read More
From Applying to Repayment – How Payday Loans Work
When faced with an unexpected expense that needs to be covered immediately, it can be stressful and overwhelming. Whether it’s a car repair, medical bill, or emergency home repair, sometimes you need cash fast. For those with less-than-ideal credit or limited access to funds, a payday loan for bad credit is a viable short-term solution.
When faced with an unexpected expense that needs to be covered immediately, it can be stressful and overwhelming. Whether it’s a car repair, medical bill, or emergency home repair, sometimes you need cash fast. For those with less-than-ideal credit or limited access to funds, a payday loan for bad credit is a viable short-term solution. Read More
What is the best audio joiner for Windows 10?
I have a large collection of music library and the files are in different formats, such as mp3, wav, flac and m4a. What is the best way to join multiple small audio files into a big one?
Tried three online audio joiners but none of them worked. They told me the codecs not supported. Could anyone recommend a good audio joiner to be used on Windows 10 or share step-by-step instructions on how to merge audio files?
I have a large collection of music library and the files are in different formats, such as mp3, wav, flac and m4a. What is the best way to join multiple small audio files into a big one? Tried three online audio joiners but none of them worked. They told me the codecs not supported. Could anyone recommend a good audio joiner to be used on Windows 10 or share step-by-step instructions on how to merge audio files? Read More
What are common causes of unrecoverable errors and how can they be resolved effectively?
I’m encountering a Unrecoverable Error and can’t access my company file. This error appears with a random numeric code, and restarting doesn’t help. How can I fix this issue and prevent it from happening again?
I’m encountering a Unrecoverable Error and can’t access my company file. This error appears with a random numeric code, and restarting doesn’t help. How can I fix this issue and prevent it from happening again? Read More
How can I take a screenshot on a Windows 7 computer?
Hi everyone,
I’m currently working on a Windows 7 computer and I don’t know how to take screenshots, especially scrolling screenshots. I guess there are probably several ways to do it, but I’m looking for the simplest method. Can anyone guide me through the steps or suggest the best tools to take screenshot on Windows 7?
P.S. Are there any built-in tools or keyboard shortcuts that can make this process easier. Also, if there are any good 3rd-party screenshot tool that offer more edit features, I’d love to hear about those too.
Thanks a lot for your help!
Hi everyone, I’m currently working on a Windows 7 computer and I don’t know how to take screenshots, especially scrolling screenshots. I guess there are probably several ways to do it, but I’m looking for the simplest method. Can anyone guide me through the steps or suggest the best tools to take screenshot on Windows 7? P.S. Are there any built-in tools or keyboard shortcuts that can make this process easier. Also, if there are any good 3rd-party screenshot tool that offer more edit features, I’d love to hear about those too. Thanks a lot for your help! Read More
QUICKB00KS Desktop Is Unable To Open The Company File And Getting ERR0R 6000! How To Fix it
QUICKB00KS Desktop ERR0R 6000 often occurs due to issues with the company file itself, network problems, or incorrect folder permissions. To troubleshoot:
Check File Location: Ensure the company file is stored in a local folder, not a network drive.Rename .ND and .TLG Files: Renaming these files can help resolve data corruption issues.Use QUICKB00KS File Doctor: This tool can automatically diagnose and fix common file-related issues.
If these steps don’t resolve the problem, contacting the QUICKB00KS support team is recommended. Their experts can provide personalized assistance to quickly resolve the ERR0R 6000 and get you back to managing your PAYR0LL seamlessly.
QUICKB00KS Desktop ERR0R 6000 often occurs due to issues with the company file itself, network problems, or incorrect folder permissions. To troubleshoot:Check File Location: Ensure the company file is stored in a local folder, not a network drive.Rename .ND and .TLG Files: Renaming these files can help resolve data corruption issues.Use QUICKB00KS File Doctor: This tool can automatically diagnose and fix common file-related issues.If these steps don’t resolve the problem, contacting the QUICKB00KS support team is recommended. Their experts can provide personalized assistance to quickly resolve the ERR0R 6000 and get you back to managing your PAYR0LL seamlessly. Read More
Viva Connections Partner Showcase – Lightning Tools
We are excited to share a Partner Showcase story on Lightning Tools. Director, Brett Lonsdale from Lightning Tools is highlighting their solutions and extensions which available for the customers from the Microsoft AppSource or directly from their web site.
Viva Connections is a company-branded employee experience destination that seamlessly integrates news, conversations, and resources within the apps and devices you use daily. It is designed to foster a culture of inclusion, allowing everyone’s ideas and voices to matter, while providing employees with the flexibility to engage and participate from anywhere.
Microsoft AppSource is an online store that contains thousands of business applications and services built by industry-leading software providers. It is a platform where you can browse, try, buy, and deploy cloud-ready solutions for Microsoft Power Platform, Microsoft 365, Dynamics 365, and more, helping you drive your business and get more done with the technology you already have.
Presenters – Brett Lonsdale (Lightning Tools) & Vesa Juvonen (Microsoft)
Company – Lightning Tools
Demonstrated solutions in the video:
DeliverPoint – Centralized and De-Centralized SharePoint Permissions Management
Lightning Conductor – Content Aggregation
Data Viewer – Data Visualization
Social Squared – Discussion Forums
References
Overview of Viva Connections
Viva Connections solutions in the Microsoft AppSource
Overview of Viva Connections Extensibility
Have you created an offering for the Viva Connections? – Do you have apps available in the AppSource? – let us showcase your solutions. Please fill in the following form to get us connected with you so that we can plan the right model together – https://aka.ms/viva/connections/partnershowcase.
Providing great employee experience platform with our partner ecosystem!
Microsoft Tech Community – Latest Blogs –Read More
How to Fix Intuit Data Protect Not Working in QUICKB00KS Desktop?
I’m encountering issues with Intuit Data Protect in QUICKB00KS Desktop. It’s not functioning properly, and I’m worried about the safety of my data backups. How can I troubleshoot this problem and ensure my data is securely backed up?
I’m encountering issues with Intuit Data Protect in QUICKB00KS Desktop. It’s not functioning properly, and I’m worried about the safety of my data backups. How can I troubleshoot this problem and ensure my data is securely backed up? Read More
FIX QUICKB00KS Export to Excel Greyed Out after windows update?
Why is the “Export to Excel” option greyed out in QUICKB00KS, and how can I fix this issue to export my reports?
Why is the “Export to Excel” option greyed out in QUICKB00KS, and how can I fix this issue to export my reports? Read More
QUICKB00KS Desktop Won’t Let Me Update PAYR0LL Account – What’s the Issue?
I’m having trouble with QUICKB00KS Desktop as it won’t let me update my PAYR0LL account. Every time I try, it fails without any specific ERR0R message. How can I resolve this issue and ensure my PAYR0LL updates correctly?
I’m having trouble with QUICKB00KS Desktop as it won’t let me update my PAYR0LL account. Every time I try, it fails without any specific ERR0R message. How can I resolve this issue and ensure my PAYR0LL updates correctly? Read More
SharePoint Libray centralized and standard sync
We have a Sharepoint library to each department and they’re separate site. Before we have a standard folder structure from an onprem network drive, but after the migration we don’t have a centralized location to browse all SharePoint library we have.
Everyone needs to go to the site before they can see and browse the folder and people find it difficult to find the files.
Is it possible that an IT administrator can set up a standard sync to the users so that all Department SharePoint library from a different sites can be synced in One location.
For example it will be like this in there file explorer.
Department Sites
EngineeringITHRAdmin
They can see and browse all available SharePoint library and if they don’t have access it will not be sync or give them an error when opening it.
Appreciate who can answer this. Thank you
We have a Sharepoint library to each department and they’re separate site. Before we have a standard folder structure from an onprem network drive, but after the migration we don’t have a centralized location to browse all SharePoint library we have. Everyone needs to go to the site before they can see and browse the folder and people find it difficult to find the files. Is it possible that an IT administrator can set up a standard sync to the users so that all Department SharePoint library from a different sites can be synced in One location. For example it will be like this in there file explorer. Department SitesEngineeringITHRAdminThey can see and browse all available SharePoint library and if they don’t have access it will not be sync or give them an error when opening it. Appreciate who can answer this. Thank you Read More
Azure AI Health Bot – now supports Microsoft Entra Access Management
We are excited to announce the introduction of Microsoft Entra Access Management support in the Azure AI Health Bot. This enhancement increases security by leveraging the robust and proven capabilities of Microsoft Entra.
Customers interested in this feature can opt-in by navigating to the User Management page and enabling the Microsoft Entra Access Management feature. This feature can only be enabled for users who have the Health Bot Admin role in the Azure access control identity-access-management (IAM) pane.
When Microsoft Entra Access Management is enabled, all users and roles should be managed through Azure Access control identity-access-management (IAM) pane.
The Access Control (IAM) now contains the same Azure AI Health Bot roles in Azure, such as Health Bot Admin, Health Bot Editor and Health Bot Reader.
When the Microsoft Entra Access Management feature is enabled, the User Management page will be read-only. All users in the Management Portal page will need to be manually added with the right roles through the Azure Access Control (IAM) page in the Azure Portal.
You can read more on the Microsoft Entra Access Management features on our public documentation page
We are excited to announce the introduction of Microsoft Entra Access Management support in the Azure AI Health Bot. This enhancement increases security by leveraging the robust and proven capabilities of Microsoft Entra.
Customers interested in this feature can opt-in by navigating to the User Management page and enabling the Microsoft Entra Access Management feature. This feature can only be enabled for users who have the Health Bot Admin role in the Azure access control identity-access-management (IAM) pane.
When Microsoft Entra Access Management is enabled, all users and roles should be managed through Azure Access control identity-access-management (IAM) pane.
The Access Control (IAM) now contains the same Azure AI Health Bot roles in Azure, such as Health Bot Admin, Health Bot Editor and Health Bot Reader.
When the Microsoft Entra Access Management feature is enabled, the User Management page will be read-only. All users in the Management Portal page will need to be manually added with the right roles through the Azure Access Control (IAM) page in the Azure Portal.
You can read more on the Microsoft Entra Access Management features on our public documentation page
Read More
Search bar view not available all searched
When search anything in search bar of colum,,,, then result show only one row or one item,,,,,
When search anything in search bar of colum,,,, then result show only one row or one item,,,,, Read More
Missing DP-3001 Achievement code
Good morning,
I cannot create the achievement codes for the DP-3001 course:
https://learn.microsoft.com/training/paths/migrate-sql-workloads-azure-sql-database/
There is no “button” to request them.
Does someone else have the same problem?
Thank you,
Diana
Good morning,I cannot create the achievement codes for the DP-3001 course:https://learn.microsoft.com/training/paths/migrate-sql-workloads-azure-sql-database/There is no “button” to request them.Does someone else have the same problem? Thank you,Diana Read More
How to Fix QUICKB00KS ERR0R 40001 During PAYR0LL Update?
I’m encountering QUICKB00KS ERR0R 40001 when trying to run PAYR0LL updates. This error is disrupting my ability to manage PAYR0LL efficiently. What steps can I take to resolve this issue?
I’m encountering QUICKB00KS ERR0R 40001 when trying to run PAYR0LL updates. This error is disrupting my ability to manage PAYR0LL efficiently. What steps can I take to resolve this issue? Read More
What To Do When QUICKB00KS Error Massage H2o2 Multi-User Mode not working after windows update?
I’m encountering a “QUICKB00K Error Message H2o2 Multi-User Mode not working” issue. What are the troubleshooting steps to resolve this problem?
I’m encountering a “QUICKB00K Error Message H2o2 Multi-User Mode not working” issue. What are the troubleshooting steps to resolve this problem? Read More
Working with Data in Azure Cosmos DB for PostgreSQL using Open PSQL Shell.
Previously we introduced Getting started with Azure Cosmos Database (A Deep Dive) blog which is an end-to-end introduction of Azure Cosmos DB. In this blog we are going to talk about one of the Azure Cosmos Database API known as Azure Cosmos Database for PostgreSQL.
Imagine a scenario where you are developing a multi-tenant application, as a developer, you have been working with PostgreSQL for years, you have joined a team that is developing an application that needs to handle data for thousands of tenants, each with isolated data. The team decides to use Azure Cosmos DB for PostgreSQL.
What is covered in this Blog
Challenges with traditional PostgreSQL
What is Azure Cosmos DB for PostgreSQL
Citus for PostgreSQL.
Provisioning Azure Cosmos DB for PostgreSQL via azure Portal.
Open PSQL Shell on Azure (new feature on preview)
How to create & query distribute tables in Azure Cosmos DB for PostgreSQL
In this blog, we shall leverage the azure cosmos DB for PostgreSQL which extends PostgreSQL with more enhanced capabilities. It will be a step-by-step guide on how to leverage this service which we are being provided and managed on Azure.
Challenges with traditional PostgreSQL
Scaling Horizontally: As the user base grows, you need to scale your database horizontally to accommodate more tenants. Traditional PostgreSQL doesn’t natively support easy horizontal scaling across multiple nodes.
Global Distribution: You need a database solution that can seamlessly replicate data across different regions for low-latency access, which is normally not the case with PostgreSQL.
High Availability and Failover: Traditional PostgreSQL requires manual setup for replication and failover.
So, what is Azure Cosmos DB for PostgreSQL?
Azure Cosmos DB for PostgreSQL is a managed service for PostgreSQL extended with Citus superpower of distributed tables. Citus enables you to scale your application as requirements grow. This can be done by distributing them into different nodes of distributed tables.
Azure cosmosDB for postgreSQL empowers you to build a scalable and globally distributed application while leveraging your existing postgreSQL
Features of Azure Cosmos DB for PostgreSQL.
Automatic High availability – Azure Cosmos DB for PostgreSQL ensures that your database remains available even in the face of failures. It automatically replicates data across multiple nodes and regions, minimizing downtime.
Backups – Azure Cosmos DB for PostgreSQL automatically backs up your data, allowing you to restore it in case of accidental deletions, corruption, or other issues.
Read-Replicas – Read-replicas allows you to offload read-heavy workloads from the primary database. This improves read performance and ensures that your application can handle high read traffic.
Easy Monitoring – Monitoring your database’s health and performance is essential. Azure Cosmos DB for PostgreSQL provides built-in monitoring tools.
Private Endpoint – By using private endpoints, you can restrict access to authorized networks, preventing exposure to the public internet.
Encryption – Azure Cosmos DB for PostgreSQL encrypts data both at rest and in transit.
Citus for PostgreSQL.
Citus for PostgreSQL is a powerful extension that transforms Postgres into a distributed database, allowing you to achieve high performance at any scale. Each tenant’s data can reside on a separate shard, enabling parallel processing and efficient queries. As new tenants join, you can dynamically add shards without downtime.
We will have a look for more about Citus later in the blog. To learn more about Citus, visit the following link: citus documentation
Create an Azure Cosmos DB for PostgreSQL cluster in Azure portal
Prerequisites
An azure account create azure account
Azure subscription learn more on subscriptions
Part A: Basics
Step 1: Create a Cluster.
Sign in to your azure account: signin to Azure and you will be taken to the dashboard.
Create an Azure Cosmsos DB for PostgreSQL cluster using the direct link: Create an Azure Cosmos DB for PostgreSQL cluster or use the search option to find the resource.
Step 2: Click on create.
Step 3: select Create on the PostgreSQL tile
Step 4: Fill in the form to provision our cluster
Options you have:
Subscription – choose the subscription to use.
Resource Group – create resource group for your resource
Cluster name – will determine the DNS name of your application.
Location – Choose location near you.
PostgreSQL version – choose major option like 15 or the latest you have.
Database name – you can leave it as citus or change to your preferred name.
Admin username – must be citus, do not change it.
Password – choose a password for your access
Scale – this option allows you to specify the amount of computing you need for your resource, feel free to click configure to adjust.
Part B: Networking
Step 5: Select Next to proceed to networking
Select Allow public access from Azure services and resources within Azure to this cluster.
For our demo purposes, adding a firewall rule using Add 0.0.0.0-255.255.255.255, It will make your IP address access any host on the internet and it poses a threat. It is advised to use the rule for temporary purposes like testing a feature and later remove the rule.
Select Review+ Create to do a validation then select Create to create the cluster. It will take a few minutes to deploy your resource, after it is done, click Go to resource.
Congratulations, you have Created an Azure Cosmos DB for PostgreSQL cluster.
Connect to a cluster via Open PSQL Shell on Azure
Open PSQL shell (a feature on preview) is a terminal based front-end to PostgreSQL that enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. With this feature, you don’t need to copy your connection strings to connect. To be authenticated, you will be required to enter your password.
In the image below, click on quick start to open the open PSQL shell window, click on Open PSQL shell icon indicated with number (2) at the top. You will open a terminal which will require you to enter the password you provided earlier.
To check the available databases, write:
Create and distribute tables in Azure Cosmos DB for PostgreSQL
As earlier stated, I promised to explain more about citus, let us get a better understanding of citus for PostgreSQL.
Citus for PostgreSQL is an extension that transforms PostgreSQL into a distributed database system. It is designed to horizontally scale out PostgreSQL across multiple servers, enabling it to handle larger datasets and higher query loads than a single PostgreSQL instance could manage alone.
Citus achieves this by partitioning tables and distributing data across a cluster of PostgreSQL servers. It also provides parallel query execution across these servers, allowing queries to be processed more quickly.
Citus is particularly useful for applications that require high scalability, such as large-scale analytics, real-time data processing, and multi-tenant applications.
We shall see how citus will enable us to create distributed tables in PostgreSQL, but first let us create tables for our citus database to see its importance.
Create Tables
Run the following queries to create github_users and github_events tables:
CREATE TABLE github_users ( user_id bigint, url text, login text, avatar_url text, gravatar_id text, display_login text );
CREATE TABLE github_events(event_id bigint,event_type text,event_public boolean,repo_id bigint,payload jsonb,repo jsonb,user_id bigint,org jsonb,created_at timestamp);
Create indexes event_type_index and payload_index on github_users and github_events respectively.
The indexes created are used to allow fast querying in the JSONB.
CREATE INDEX event_type_index ON github_events (event_type);
CREATE INDEX payload_index ON github_events USING GIN (payload jsonb_path_ops);
You should see the following on executing the commands.
Distributed tables
create_distributed_table() is the magic function that Azure Cosmos DB for PostgreSQL provides to distribute tables and use resources across multiple machines. The function decomposes tables into shards, which can be spread across nodes for increased storage and compute performance.
Run the following commands to create distributed tables.
SELECT create_distributed_table(‘github_users’, ‘user_id’);
SELECT create_distributed_table(‘github_events’, ‘user_id’);
Note that if you do not distribute tables, the worker nodes cannot help running your queries.
Load Data into Distributed Tables
To load a large amount of data, we are using data on azure blob storage. To achieve this, we first must create the extension in our database:
SELECT * FROM create_extension(‘azure_storage’);
Copy data from Blob Storage: Run the following commands to fetch data from CSV files and load into database tables:
— download users and store in table
COPY github_users FROM ‘https://pgquickstart.blob.core.windows.net/github/users.csv.gz’;
— download events and store in table
COPY github_events FROM ‘https://pgquickstart.blob.core.windows.net/github/events.csv.gz’;
You should see 264308 and 126245 has been successfully loaded within a short period of time.
Viewing Distributed Tables
We can review details of our distributed tables, including their sizes. Run the following commands:
SELECT * FROM citus_tables;
Run queries in Azure Cosmos DB for PostgreSQL
Like any other database, we make use of it by querying to get information. Let us run some queries for our citus database which is powered with distributed tables.
To check count of GitHub users:
count all rows (across shards)
SELECT count(*) FROM github_users;
Azure Cosmos DB for PostgreSQL automatically runs the count on all shards in parallel, and combines the results because data is divided between multiple nodes.
To find all events for a single user, run the following command.
SELECT created_at, event_type, repo->>’name’ AS repo_name FROM github_events WHERE user_id = 3861633;
The results came in within a few seconds because of the power of the distributed tables in Azure Cosmos DB for PostgreSQL.
I do hope you have learnt from the blog and now have an idea of the power of Azure Cosmos DB for PostgreSQL. It is now time to practice and develop applications that make use AI (Artificial Intelligence) capabilities for fast processing of data.
Read more
Introduction to Azure Cosmos DB
Azure Database for PostgreSQL Training
Clusters in Azure Cosmos DB for PostgreSQL
Shard data on worker nodes
Available SDKs
Connect and run SQL commands using Python
Connect and run SQL commands using Node.js
Connect and run SQL commands using C#
Connect and run SQL commands using Java
Connect and run SQL commands using Ruby
Microsoft Tech Community – Latest Blogs –Read More
Email Delivery issue
Hello
Please i need your help on this issue.
We are having issue with email delivery from outside our organization.
Its only receiving emails from people inside my organization.
When I tried to send an email from Gmail I received this error below:
Hello Please i need your help on this issue. We are having issue with email delivery from outside our organization. Its only receiving emails from people inside my organization. When I tried to send an email from Gmail I received this error below: Read More
‘PRIMARY’ filegroup is full error
I tried to add a row to a table. That time the “Structure less material operation error: Could not allocate space for object. Because the ‘PRIMARY’ filegroup is full.” Error occurred and row is not added.
I tried below solutions:
1. Increase autogrowth size and set maximum size to unlimited.
2. Check on Filegroups -> primary- Autogrowth All Files check box check on.
3. Set maximum size to -1 by executing a query.
4. Compression
5. Restart SQL server by applying these solutions and also restart system.
These solutions are not worked.
In my database there is space, because when try to add through SQL management studio, the row is added. But by using application, the row is not added, and this error occurred.
Sometimes the row added, but sometimes issue occurred. Is there is any other solution for this issue?
I tried to add a row to a table. That time the “Structure less material operation error: Could not allocate space for object. Because the ‘PRIMARY’ filegroup is full.” Error occurred and row is not added. I tried below solutions:1. Increase autogrowth size and set maximum size to unlimited.2. Check on Filegroups -> primary- Autogrowth All Files check box check on.3. Set maximum size to -1 by executing a query.4. Compression5. Restart SQL server by applying these solutions and also restart system.These solutions are not worked.In my database there is space, because when try to add through SQL management studio, the row is added. But by using application, the row is not added, and this error occurred. Sometimes the row added, but sometimes issue occurred. Is there is any other solution for this issue? Read More
Help on making reference to multiple excel sheets saved on Microsoftteams
Hello all,
Am trying to automate data entry between separate Excels on teams. The scenario is I have 2 excels, let’s call them “Source” and “Consolidated”, my users will fill the information in “Source”, and I want it to auto populate into “Consolidated” to save time instead of manually copy pasting.
Currently I have a workaround to sync the “Source” sheet on Onedrive/sharepoint, and the “Consolidated” file just uses a “=” cell reference to pull up the necessary. It seems to work as long as we manually press sync and update, but am wondering if there is a better way to do it please?
Additionally (stretch goal), if there were multiple “Source” files, could “Consolidated” take reference to all of them and autopopulate as well?
Thank you!
P.s below is the few links I took reference to for the current method
https://www.summarypro.co.uk/blog/excel-drawing-information-from-sharepoint-files.aspx
Hello all, Am trying to automate data entry between separate Excels on teams. The scenario is I have 2 excels, let’s call them “Source” and “Consolidated”, my users will fill the information in “Source”, and I want it to auto populate into “Consolidated” to save time instead of manually copy pasting. Currently I have a workaround to sync the “Source” sheet on Onedrive/sharepoint, and the “Consolidated” file just uses a “=” cell reference to pull up the necessary. It seems to work as long as we manually press sync and update, but am wondering if there is a better way to do it please? Additionally (stretch goal), if there were multiple “Source” files, could “Consolidated” take reference to all of them and autopopulate as well? Thank you! P.s below is the few links I took reference to for the current method https://support.microsoft.com/en-us/office/sync-sharepoint-and-teams-files-with-your-computer-6de9ede8-5b6e-4503-80b2-6190f3354a88 https://answers.microsoft.com/en-us/msoffice/forum/all/mirror-new-entries-in-teams-workbook-into-another/d53c5c07-809f-446a-850a-f2e67dfc376d https://www.summarypro.co.uk/blog/excel-drawing-information-from-sharepoint-files.aspx Read More
