Category: Microsoft
Category Archives: Microsoft
How to resolve icwrapper.dll Failed to Register in Quick___Books on Windows 11
Hello everyone,
I’m encountering an issue where Quick___Books on Windows 11 displays an error message stating that “icwrapper.dll failed to register” when updating Quick___Books .I’ve attempted such as reinstalling Quick___Books or updating Windows. However, the issue persists. Could anyone please advise on how to resolve this error?
Thank you in advance for your help!
Hello everyone,I’m encountering an issue where Quick___Books on Windows 11 displays an error message stating that “icwrapper.dll failed to register” when updating Quick___Books .I’ve attempted such as reinstalling Quick___Books or updating Windows. However, the issue persists. Could anyone please advise on how to resolve this error?Thank you in advance for your help! Read More
How do I fix a Quick_Books error code 108 with Support ?
Quick_Books Error Code 108 occurs when your bank sends a message that needs attention. Resolve this issue by checking your bank’s notifications and following the necessary steps to update your account information
Quick_Books Error Code 108 occurs when your bank sends a message that needs attention. Resolve this issue by checking your bank’s notifications and following the necessary steps to update your account information Read More
How do I colour a cell based on text and a date range in a Gantt chart?
Hi there, I’m looking for help working out how to do the below.
Here is the set up:
Column A – Event title
Column B – Organiser
Column C – Start date
Column D – End date
From Column F is a Gantt chart with dates at the top.
I am currently using conditional formatting to auto colour the cells on the Gantt chart under the start date through to the end date for each event. The formula I am using for this is:
=AND(F$6>=$D8,F$6<=$E8)
I want to now distinguish between organisers using different colours on the cells from the start date through to the end date e.g. column B lists the organiser as Elizabeth and column C has a start date of 23/7/24 and Column D has an end date of 26/7/24 so the coloured cells on the Gantt chart will be yellow. Where as if the organiser was Dave then the cells would be green between those two dates.
I’m thinking I need to use an IF formula in addition to my current formula but I cannot work it out – would anyone know how to do this?
Many thanks in advance,
Hi there, I’m looking for help working out how to do the below. Here is the set up: Column A – Event title Column B – Organiser Column C – Start date Column D – End date From Column F is a Gantt chart with dates at the top. I am currently using conditional formatting to auto colour the cells on the Gantt chart under the start date through to the end date for each event. The formula I am using for this is: =AND(F$6>=$D8,F$6<=$E8)I want to now distinguish between organisers using different colours on the cells from the start date through to the end date e.g. column B lists the organiser as Elizabeth and column C has a start date of 23/7/24 and Column D has an end date of 26/7/24 so the coloured cells on the Gantt chart will be yellow. Where as if the organiser was Dave then the cells would be green between those two dates. I’m thinking I need to use an IF formula in addition to my current formula but I cannot work it out – would anyone know how to do this?Many thanks in advance, Read More
Changing Public Team to Org Wide team
We have created a team originally as a Private Team until we get everything set up, then the plan was to switch it to an Org team once ready. The issue is every time I go to change it to an Org team it reverts to a public team. The account I am using has global admin so that is not the issue. How can I get this changed?
We have created a team originally as a Private Team until we get everything set up, then the plan was to switch it to an Org team once ready. The issue is every time I go to change it to an Org team it reverts to a public team. The account I am using has global admin so that is not the issue. How can I get this changed? Read More
Get Expert Support for Quick_Books Data Conversion Services ?
Get expert assistance with Q_B data conversion services for seamless transitions and reliable support, ensuring your financial data is accurately and efficiently migrated.
Get expert assistance with Q_B data conversion services for seamless transitions and reliable support, ensuring your financial data is accurately and efficiently migrated. Read More
Integrated Camera into the laptoop
Since I use 365 I cannot use the integrated camera into the notebook to validate identification, since a message appears that says “another application or program is using the camera.” The problem is that I am not using the camera in another program and I cannot solve the problem.
Can you help me on this.
In advance many thanks.
Since I use 365 I cannot use the integrated camera into the notebook to validate identification, since a message appears that says “another application or program is using the camera.” The problem is that I am not using the camera in another program and I cannot solve the problem.Can you help me on this.In advance many thanks. Read More
Update: Security hotfix released for OLE DB driver for SQL Server
We’ve released hotfix packages for the following drivers to address an important security issue:
Microsoft OLE DB Driver for SQL Server (version 18.7.4 release notes / download)
Microsoft OLE DB Driver 19 for SQL Server (version 19.3.5 release notes / download)
The CVE for these OLE DB driver updates is:
CVE-2024-37334 – Microsoft OLE DB Driver for SQL Server Remote Code Execution Vulnerability
The issue involves connecting to a malicious server that sends malicious data in order to compromise a client. These driver updates are available via Microsoft Update, standalone download, and are included in the SQL Server 2019 and SQL Server 2022 updates that released July 9, 2024.
Next steps
For Windows installations, automatic updates will be provided via Microsoft Update or you can download the packages directly:
Microsoft OLE DB Driver 18 for SQL Server (version 18.7.4 download)
Microsoft OLE DB Driver 19 for SQL Server (version 19.3.5 download)
How do I know what version of a driver I have installed?
On Windows, look in Add or remove programs. The version is shown with the installed package. Additionally, you can look at the file properties of the installed files and inspect the Product Version field in the Details. Here are the main files for each driver:
Microsoft OLE DB Driver for SQL Server – %Windir%system32msoledbsql.dll
Microsoft OLE DB Driver 19 for SQL Server – %Windir%system32msodlebsql19.dll
Roadmap
We are committed to improving quality and bringing more feature support for connecting to SQL Server Azure SQL Database Azure Synapse Analytics, and Azure SQL Managed Instance through regular driver releases. We invite you to explore the latest the Microsoft Data Platform has to offer via a trial of Microsoft Azure SQL Database or by evaluating Microsoft SQL Server.
David Engel
Microsoft Tech Community – Latest Blogs –Read More
Public Preview of the Windows Server Annual Channel for Containers on Azure Kubernetes Service
Today, we are excited to announce the public preview for the Windows Server Annual Channel for Containers on Azure Kubernetes Service (AKS). The annual channel delivers a more agile and portable experience for our partners and customers in an accelerated annual cadence.
What’s New:
Portability
As mentioned last year, a large component of the benefits that the first edition of the annual channel brings is portability. With the addition of a new stable application binary interface (ABI) for user and kernel interaction, the user and kernel components of the system are decoupled, allowing for the components to be updated and maintained separately. This allows for older container images to run on a newer host OS, dampening the need for updating infrastructure and container images before updating the host. This means Windows Server 2022 container images can be run on the Annual Channel for Containers host.
Faster Innovation
The annual channel will be a completely optional upgrade for our customers, but one that drives faster innovation and higher quality for our customers. By providing an annual update to the container host, customers can now get performance, security and reliability improvements on a yearly-cadence basis versus a three-year cadence basis. In addition, the Windows Server Annual Channel for Containers will receive the same servicing as the current three-year Windows Server releases. This will not only allow users to consistently be on the best performing version of our container hosts but also ease the load when it comes time to migrate to newer versions.
How to get started:
To upgrade your Windows Server 2022 clusters to the Windows Server Annual Channel for Containers, customers will need to create a new node pool with the new “Windows Annual Channel” OS SKU.
Supported on nodepools running Kubernetes 1.28 and above, this page walks through detailed instructions on how to upgrade existing Windows Server 2022 nodepools as well as create your first Windows Server Annual Channel for Containers nodepool.
Microsoft Tech Community – Latest Blogs –Read More
How can I create an App?
I would love to find out, if there is a simple way to create an app, doesn’t matter what it does, as that could be updated, frequently, after it is functional, right?
I would love to find out, if there is a simple way to create an app, doesn’t matter what it does, as that could be updated, frequently, after it is functional, right? Read More
Need Help with Quick-B00ks Error Message 17337
Hi everyone,
I’ve encountered Quick-B00ks Error message 17337 while trying to perform tasks in Quick-B00ks. It’s causing some delays in my work, and I’m not sure how to resolve it. Can anyone provide guidance on how to fix Quick-B00ks Error message 17337? Any step-by-step instructions or tips would be greatly appreciated!
Thanks in advance for your assistance!
Hi everyone,I’ve encountered Quick-B00ks Error message 17337 while trying to perform tasks in Quick-B00ks. It’s causing some delays in my work, and I’m not sure how to resolve it. Can anyone provide guidance on how to fix Quick-B00ks Error message 17337? Any step-by-step instructions or tips would be greatly appreciated!Thanks in advance for your assistance! Read More
Help Needed: Quick=B00ks Desktop Error 176109
Hello everyone,
I’m facing Q=B Desktop Error 176109 when trying to open Quick=B00ks Point of Sale. This error is preventing me from accessing the software, and I’m unsure how to proceed. Could someone please guide me on how to resolve Quick=B00ks Desktop Error 176109? Any assistance or tips would be greatly appreciated!
Thank you in advance!
Hello everyone,I’m facing Q=B Desktop Error 176109 when trying to open Quick=B00ks Point of Sale. This error is preventing me from accessing the software, and I’m unsure how to proceed. Could someone please guide me on how to resolve Quick=B00ks Desktop Error 176109? Any assistance or tips would be greatly appreciated!Thank you in advance! Read More
How does anyone startup a new business?
Oneway might be to subscribe to a platform such as silentoffices.com where anyone can create their own business and use AI and bots to create an income stream to pay off the initial subscription costs, breakeven and then generate positive revenue and renew their 60-month lease for another 60-months and keep repeating as long as they choose. Here is a video that explains this process.
Oneway might be to subscribe to a platform such as silentoffices.com where anyone can create their own business and use AI and bots to create an income stream to pay off the initial subscription costs, breakeven and then generate positive revenue and renew their 60-month lease for another 60-months and keep repeating as long as they choose. Here is a video that explains this process. Read More
How to resolve Quick–B00ks Error Code 15215
Hello everyone,
I’ve recently encountered Quick–B00ks Error code 15215 while trying to update Quick–B00ks. This error seems to be causing issues with the update process, and I’m unsure how to proceed. Can anyone provide guidance on how to fix Quick–B00ks Error code 15215? Any advice or step-by-step instructions would be greatly appreciated!
Thank you in advance for your assistance!
Hello everyone,I’ve recently encountered Quick–B00ks Error code 15215 while trying to update Quick–B00ks. This error seems to be causing issues with the update process, and I’m unsure how to proceed. Can anyone provide guidance on how to fix Quick–B00ks Error code 15215? Any advice or step-by-step instructions would be greatly appreciated!Thank you in advance for your assistance! Read More
Planned % Complete Vs Duration Variance Vs Actual Complete
Hi,
Can there be a scenario in project plan where overall the project duration is delayed, however a task actual % complete can be more that planned percentage calculated based on duration?
Thanks
Hi, Can there be a scenario in project plan where overall the project duration is delayed, however a task actual % complete can be more that planned percentage calculated based on duration? Thanks Read More
Meltwater partners with Microsoft to deliver AI-powered communications insights
Check out this new video to see how Meltwater partners with Microsoft to deliver AI-powered communications insights.
Hear from John Box, CEO of Meltwater, on how Meltwater’s partnership with Microsoft allows them to deliver unparalleled AI-powered data insights to businesses. Meltwater is a global leader in social media and consumer intelligence and leverages Microsoft Azure services, including Azure Open AI to harness the world’s data in real time to fuel their customer’s competitive edge.
Check out this new video to see how Meltwater partners with Microsoft to deliver AI-powered communications insights.
Hear from John Box, CEO of Meltwater, on how Meltwater’s partnership with Microsoft allows them to deliver unparalleled AI-powered data insights to businesses. Meltwater is a global leader in social media and consumer intelligence and leverages Microsoft Azure services, including Azure Open AI to harness the world’s data in real time to fuel their customer’s competitive edge. Read More
How to resolve Quick_B00ks Error message Code 6176
I’ve encountered Error Code 6176 when trying to open my Quick_B00ks company file. It says there’s an issue with accessing the company file over the network. I’ve tried restarting my computer and updating Quick_B00ks, but the error persists. What steps can I take to resolve this issue? Has anyone else experienced this problem and found a solution?
I’ve encountered Error Code 6176 when trying to open my Quick_B00ks company file. It says there’s an issue with accessing the company file over the network. I’ve tried restarting my computer and updating Quick_B00ks, but the error persists. What steps can I take to resolve this issue? Has anyone else experienced this problem and found a solution? Read More
Tech Talks Presents: Build Microsoft Copilot extensions with Copilot Studio
Join us on Thursday, July 11th at 8am PT to learn how to build Microsoft Copilot extensions with Copilot Studio.
Call to Action:
Click on the link to save the calendar invite: https://aka.ms/TechTalksInvite
View past recordings (sign in required): https://aka.ms/TechTalksRecording
Join us on Thursday, July 11th at 8am PT to learn how to build Microsoft Copilot extensions with Copilot Studio.
Call to Action:
Click on the link to save the calendar invite: https://aka.ms/TechTalksInvite
View past recordings (sign in required): https://aka.ms/TechTalksRecording Read More
How to skip to next cell value if current cell doesn’t match the criteria in the formula
Hi,
I have a following problem:
In Sheet1 employees copy/paste some data about customers.
They always have same 5 rows and are always copies in column A (see photo below):
There can be thousands of rows because they keep adding each day new data.
I need to create a formula in Sheet2 to copy/paste all this data (using formula, not actually copy/pasting) into a table which is more easier to filter data in.
Example how I want it to look like:
so,
I want it all copied like this and avoid blank rows.
I tried using this formula for A2 in Sheet2 (and similar for B2,C2….) , but I am not sure how to skip the cell if it doesn’t match the criteria, so it ends up looking like this: =IF(COUNTIF(Sheet1!$A2,”*E-mail*”),Sheet1!$A2,””)
Any idea how to do this using a formula or is VBA needed here?
Thanks in advance!
Hi, I have a following problem: In Sheet1 employees copy/paste some data about customers.They always have same 5 rows and are always copies in column A (see photo below): There can be thousands of rows because they keep adding each day new data. I need to create a formula in Sheet2 to copy/paste all this data (using formula, not actually copy/pasting) into a table which is more easier to filter data in.Example how I want it to look like: so,I want it all copied like this and avoid blank rows.I tried using this formula for A2 in Sheet2 (and similar for B2,C2….) , but I am not sure how to skip the cell if it doesn’t match the criteria, so it ends up looking like this: =IF(COUNTIF(Sheet1!$A2,”*E-mail*”),Sheet1!$A2,””) Any idea how to do this using a formula or is VBA needed here? Thanks in advance! Read More
Say hello to the Talking Postgres podcast
The TL;DR of this blog post is simple: the “Path To Citus Con” podcast for developers who love Postgres has been renamed—and the new name is Talking Postgres.
And if you’re just hearing about the Talking Postgres podcast for the first time, it is a monthly podcast for developers who love Postgres, with amazing guests from the Postgres world who talk about the human side of Postgres, databases, and open source.
Listening to the Talking Postgres podcast is the next best thing to being in the hallway at a Postgres conference, eavesdropping on other people’s conversations and learning from the experiences of experts. As Floor Drees says, it’s as if you’re sharing a coffee with them.
Past podcast guests include (in order of appearance) some amazing Postgres, database, and open people such as: Simon Willison, Marco Slot, Abdullah Ustuner, Burak Yucesoy, Melanie Plageman, Samay Sharma, Álvaro Herrera, Boriss Mejías, Thomas Munro, Grant Fritchey, Ryan Booz, Chelsea Dole, Floor Drees, Paul Ramsey, Regina Obe, Andres Freund, Heikki Linnakangas, Dimitri Fontaine, Vik Fearing, Lukas Fittl, Rob Treat, Jelte Fennema-Nio, Derk van Veen, Arda Aytekin, Chris Ellis, Michael Christofides, Aaron Wislang, and Teresa Giacomini. The podcast is produced by the Postgres team at Microsoft—and I have the privilege of being your host.
So whether you’re an existing listener or new to this podcast, we hope you enjoy the Talking Postgres podcast—and help to spread the word about the new name.
Some key things to know about the Talking Postgres podcast
Why did we rename the podcast?: Guests & friends repeatedly—and I mean repeatedly—nudged us to rename the podcast to a name that makes it more clear what the podcast is about. And at the end of the day it’s about Postgres things! So while the podcast was born in March 2023 as a pre-event to last year’s Citus Con—hence the original name, “Path To Citus Con”—Talking Postgres has grown into its own monthly podcast that has everything to do with Postgres and little to do with Citus Con (now called POSETTE.)
Where can you catch up on past podcast episodes?: All 16 of the past episodes of Path To Citus Con can now be found on the talkingpostgres.com site—as well as on the Talking Postgres playlist on YouTube, and wherever you get your podcasts.
If you’re already subscribed to the podcast, are you still subscribed?: We renamed the previous podcast, so if you were already subscribed, you should still be subscribed. Same thing for the RSS feed, it should just work! If you have any problems, please let us know via the #talkingpostgres channel in the Microsoft Open Source Discord.
Can you still attend the LIVE recording of the podcast on Discord each month?: Yes! Inspired by the Oxide and Friends podcast that is hosted by Bryan Cantrill and Adam Leventhal—two of my former teammates from the kernel group at Sun Microsystems—we also record Talking Postgres (formerly Path To Citus Con) each month on Discord—with a parallel live text chat that is quite fun to be part of.
When are the future LIVE podcast recordings: If you’ve never participated in this type of live podcast recording, you might want to give it a try. It’s easy to subscribe to the Talking Postgres calendar of future LIVE podcast recordings: we usually record on Wed mornings Pacific Time (PT) on the 1st or 2nd Wednesday of the month.
Episode 17 of Talking Postgres will be recorded LIVE this Wed July 10, 2024: This July, our guest is Pino de Candia—the former co-host of the podcast—and the topic will be a bit “meta” this time! We’ll explore “Podcasting about Postgres” and we’ll look back at some of our greatest hits, talk about some of the other wonderful Postgres podcasts we listen to, and of course we’ll spend a few minutes reflecting on the podcast rename (why why why!) This Ep17 calendar invite should give you all the instructions you need to join us live on Discord this Wed Jul 10th at 10:00am PDT.
And David Rowley is scheduled to be the guest on the August episode: Since David Rowley—a Postgres committer—is based in New Zealand, Ep18 in August with David Rowley will be recorded at an unusual time for us, on a Tuesday, specifically at 4:00pm PDT on Tue Aug 6th. The topic will be “How I got started as a developer & in Postgres” and we hope you can join us on the parallel live text chat! David is brilliant—and I’m definitely going to have to do my homework on Postgres performance topics to prep for the conversation, since that is one of David’s specialties.
Let us know what you think of the podcast & please use hashtag #TalkingPostgres
The new hashtag for the new podcast name is #TalkingPostgres. And as soon as we see some interesting tweets, toots, and threads about the podcast using the new name, perhaps we’ll add some of them to the talkingpostgres.com website.
For now, here is a screenshot highlighting guests and topics for some of the most recent podcast episodes. You can of course subscribe to Talking Postgres and listen from anywhere, wherever you get your podcasts from. Enjoy!
Microsoft Tech Community – Latest Blogs –Read More
Public Preview Announcement: Azure Policy Built-in Versioning
Welcome to a new era of policy management, where policy definitions are more agile, adaptable, and accessible than ever before! We are thrilled to introduce version management support for controlled built-in definition and initiative updates through Azure Policy. In a push to empower and simplify policy management, built-in definitions and initiatives will have the ability to store & reference multiple versions within a single definition ID. This new development will enhance your ability to govern, enforce and evolve your cloud governance policies. Keep reading for more information and be sure to check out our video walk-through of versioning to get started and learn more.
What’s new? Now, built-in definitions and initiatives can reference multiple versions within a single definition ID! This will help with:
Regulated updates: All built-in definitions will be reviewed and evaluated to stay aligned with versioning guidelines standards.
Change Management: Version will provide visibility into the evolution of built-in definitions and initiatives over each iteration.
Controlled application and enforcement: Users can specify what version of the definition or initiative to be assessed against at assignment time.
Gradual Rollout: Versioning in collaboration with assignment resource selectors and overrides can be used to introduce new versions of definitions gradually into the environment.
Testing and quality assurance: Different versions of definitions may undergo different stages of roll out and application.
Versioning awareness: Applicable version number will be shown in compliance logs on a per resource basis.
Ready to dive in? Keep reading to discover how you can get started with Policy versioning and make the most of these new capabilities!
Getting started:
All built-in definitions and initiatives have been updated to be on the latest current version. This can be seen in the portal, or through making a direct API call to the built-in definition. Through either client, you will see a new top-level version property (that follows semantic versioning format: #.#.#)
Now if that built-in definition were to introduce a new version, you would see the same definition ID but a new top level version number. With a slight change to the API call, you can retrieve other versions. See Policy Definition Versions – REST API (Azure Policy) | Microsoft Learn. If no version is specified, the latest version will be returned.
Portal:
When assigning a definition or initiative, users can select from either the current or previous versions while maintaining awareness of the version in your environment.
API Response:
The current version of the definition can also be seen through querying the definition ID, by default the latest version will be returned.
Important items to note:
1. Assignment version reference
All current assignments of built-in definitions and initiatives have been backfilled to reference the latest version of the definition and allow for updates on minor definition versions. Any assignment would ingest all minor changes as before but will not auto-ingest major or breaking changes. If you do not want to ingest minor changes, you can update the existing assignment to pin to a minor version.
2. Understand patch change pattern.
Assignments will not be able to pin to the patch version of definitions. Patch is reserved for non-impacting text changes and critical hotfixes. Patch changes require ingestions reserved for rare and special cases. Since a text change or definition category can occur without warning, please ensure any additional functionality relies on the definition ID and not the definition name as the name is dynamic, but ID is static.
3. Understand major vs minor updates.
Following semantic versioning, major updates occur when there is a breaking change to the definition. This could include introducing a new deny policy to a built-in initiative. A minor update does not include breaking changes but can include rule logic changes that enhance the scope of the definition’s applicability or changes to parameters.
Stay tuned for more updates on Azure Policy features and releases here, and on X at @AzureGovernance.
Link to video overview of Policy versioning: https://youtu.be/eejdoDgofZ8
Microsoft Tech Community – Latest Blogs –Read More