Category: Microsoft
Category Archives: Microsoft
Formula not adding corectly
=SUM(CU6+CW6+CY6+DA6+DC6+DE6) not returning the correct value to the target cell where the source cells all contain numerical values, i.e. 2, 6, 2.5…
=SUM(CU6+CW6+CY6+DA6+DC6+DE6) not returning the correct value to the target cell where the source cells all contain numerical values, i.e. 2, 6, 2.5… Read More
What To Do When stuck in Quick-Books Error 1402 after recent update?
I’m encountering Quick-Books Error 1402 when trying to install or update Quick-Books on my computer. How can I resolve this issue?
I’m encountering Quick-Books Error 1402 when trying to install or update Quick-Books on my computer. How can I resolve this issue? Read More
June 12 update broke my printer driver. I have thousands of customers that cannot run anymore.
I have over 1000 customers in the field that cannot install this update of windows 10 and windows 11.
Sometime in 2002 I took with msplot demo driver and converted it to run our cutters. I was able to send plots up to 125″ inches by 60″ to our cutters with resolution as high as 16256.
Now with this update installed the gdi calls DrvStrokePath with the wrong clipping/boundary window cutting the maximum size to 5″ x 5″ which is impossibly too small. Some of our machines cut countertops of up to 300″ long. (I do this by sending a scaled image and then scaling it back up in the cutter driver).
I have tried changes to the cutter driver and since the cutter driver is not called with all objects, I cannot make changes to my cutter driver.
At the present time I am recommending that all of our customer not install or uninstall this update until problem is resolved. See notice at https://allendatagraph.com
I started a discussion at https://answers.microsoft.com/en-us/windows/forum/windows_11-wintop_update/the-most-recent-windows-update-broke-my-printer/0317790a-2410-4862-a5e2-0699b199b5c8 which contains lots more information about the issue.
I have also reported issue on the feedback hub.
I have over 1000 customers in the field that cannot install this update of windows 10 and windows 11. Sometime in 2002 I took with msplot demo driver and converted it to run our cutters. I was able to send plots up to 125″ inches by 60″ to our cutters with resolution as high as 16256. Now with this update installed the gdi calls DrvStrokePath with the wrong clipping/boundary window cutting the maximum size to 5″ x 5″ which is impossibly too small. Some of our machines cut countertops of up to 300″ long. (I do this by sending a scaled image and then scaling it back up in the cutter driver). I have tried changes to the cutter driver and since the cutter driver is not called with all objects, I cannot make changes to my cutter driver. At the present time I am recommending that all of our customer not install or uninstall this update until problem is resolved. See notice at https://allendatagraph.com I started a discussion at https://answers.microsoft.com/en-us/windows/forum/windows_11-wintop_update/the-most-recent-windows-update-broke-my-printer/0317790a-2410-4862-a5e2-0699b199b5c8 which contains lots more information about the issue. I have also reported issue on the feedback hub. Read More
Azure VM windows 10 randomly go black
Today I was experiencing an unexpected issue with our Azure VMs running Windows 10. Earlier today, users across several VMs encountered a sudden problem: their screens went black, and the taskbar icons turned white. When they clicked on the icons, a message indicated that the program had moved. To restore normal functionality, we had to log off and back on for a large number of users.
This is the first time we’ve encountered such an issue, and we urgently need assistance in resolving it. Could you please guide us on where to look or provide any troubleshooting steps?
Today I was experiencing an unexpected issue with our Azure VMs running Windows 10. Earlier today, users across several VMs encountered a sudden problem: their screens went black, and the taskbar icons turned white. When they clicked on the icons, a message indicated that the program had moved. To restore normal functionality, we had to log off and back on for a large number of users.This is the first time we’ve encountered such an issue, and we urgently need assistance in resolving it. Could you please guide us on where to look or provide any troubleshooting steps? Read More
Why is My Company file won’t open after windows update?
I’m unable to open my Q.B company file. It keeps giving me an error message or fails to load completely. What steps can I take to troubleshoot and resolve this issue?
I’m unable to open my Q.B company file. It keeps giving me an error message or fails to load completely. What steps can I take to troubleshoot and resolve this issue? Read More
How do I fix a Quick-Books error 400 after update?
How can I resolve Quick-Books error 400? I keep encountering this issue when trying to connect to my bank account. What are the steps to fix it?
How can I resolve Quick-Books error 400? I keep encountering this issue when trying to connect to my bank account. What are the steps to fix it? Read More
Timestamp excel cell when change is made
I’m working on a tracker for applications. I want a cell timestamp to be entered into a cell and updated every time cells in a specified column are changed. Example: when B2 changes D2 updates with the current date. I’ve been digging through what I found online. Three people will regularly be making changes to this tracker. I’ve tried a couple macros but every time I make changes it messes up the table. I’ve removed the table and the only way to move the row without it becoming a mess is to move the whole row. We have a reference chart next to the tracker so that isn’t workable. I can easily make the fixes necessary however my coworkers don’t have the same skillset as me. I’m looking for a user friendly solution.
I’m working on a tracker for applications. I want a cell timestamp to be entered into a cell and updated every time cells in a specified column are changed. Example: when B2 changes D2 updates with the current date. I’ve been digging through what I found online. Three people will regularly be making changes to this tracker. I’ve tried a couple macros but every time I make changes it messes up the table. I’ve removed the table and the only way to move the row without it becoming a mess is to move the whole row. We have a reference chart next to the tracker so that isn’t workable. I can easily make the fixes necessary however my coworkers don’t have the same skillset as me. I’m looking for a user friendly solution. Read More
Azure Database for MySQL – May 2024 updates and latest feature roadmap
We’re pleased to share a summary of the Azure Database for MySQL – Flexible Server announcements from Microsoft Build 2024 and last month, as well as the latest roadmap of upcoming features!
June 2024 Live webinar
These updates and the latest roadmap are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every month, at 7:30 AM Pacific time. Below is a link to the session recording of the live webinar we delivered earlier this week:
May 2024 updates and announcements
Microsoft Copilot in Azure: Unlock the benefits of Azure Database for MySQL with your AI companion (Public Preview)
We’re excited to announce Microsoft Copilot in Azure extends capabilities to Azure Database for MySQL. Microsoft Copilot in Azure is an AI-powered tool that leverages Large Language Models (LLMs) and the Azure control plane to help you get answers to your general questions and receive high quality recommendations to real-time problems. With this new integration with Azure Database for MySQL, you can converse with Microsoft Copilot in Azure to discover new features, determine when to enable new features to supplement your own scenarios, learn from summarized tutorials to enable features or build applications, and obtain tips and best practice recommendations to avoid issues.
Learn more: Announcement blog | Demo video
Build RAG applications with Azure OpenAI and MySQL with Azure AI Search
We’re excited to announce that you can now create Retrieval-Augmented Generation (RAG) applications using Azure OpenAI and Azure Database for MySQL with Azure AI Search.
You can combine the smart, human-like responses of Azure OpenAI with MySQL’s powerful database management and Azure AI Search’s advanced search capabilities, making it easier to build apps that deliver relevant info quickly and efficiently. If you’re running applications (content management systems (CMS), e-commerce applications, or gaming sites) with data hosted in Azure Database for MySQL, enhance your user experience by building generative AI search and chat applications using LLMs available in Azure OpenAI and vector storage and indexing provided by Azure AI Search. Unleash the power of your data hosted on MySQL with the simple and seamless AI integrations on Azure!
Learn more: Demo video and sample architecture | RAG in Azure AI Search documentation
Achieve 2x increase in throughput using Accelerated Logs in Business Critical service tier (General Availability)
We’re excited to announce the General Availability of Accelerated Logs, a feature that significantly boosts performance for write heavy workloads, offering up to a 2x improvement in throughput, out of the box, with no additional cost or application changes required. By reducing latency and enhancing data access speeds, the Accelerated Logs feature ensures that your mission-critical applications run more efficiently and smoothly on the Business Critical service tier. Try out this new feature to experience the difference in your workload performance!
Learn more: Documentation | Announcement blog | Demo video
Expand storage up to 32TB (General Availability)
You can now expand storage up to 32TB for your workloads using the Business Critical service tier. With storage auto-grow up to 32TB and auto-scale IOPs up to 80K, you can now run your large, growing mission-critical workloads worry-free on Azure!
Learn more: Announcement blog | Demo video
On-demand backup and export (Public Preview)
With Public Preview of the on-demand backup and export feature, you can now easily export a physical backup of your MySQL flexible server to an Azure storage account (Azure blob storage) with just a few clicks on the Azure portal or with a single CLI command whenever you want. After exporting backups to blob storage, you can use them for multiple purposes, including data recovery, redundancy, and availability, auditing, compliance, or to avoid vendor lock in.
Learn more: Documentation | Announcement blog | Demo video
Azure Database for MySQL Import supports Percona XtraBackup for external migrations to Flexible Server (General Availability)
Azure MySQL Import enables you to migrate your MySQL on-premises or Virtual Machine (VM) workload seamlessly to Azure Database for MySQL – Flexible Server. It takes advantage of a user-provided physical backup file (taken using Percona XtraBackup) and restores the source server’s physical data files to the target server offering a simple and fast migration path. Based on user inputs, the feature takes up the responsibility of provisioning your target flexible server, then restoring the user-provided physical backup of the source server stored in the Azure Blob storage account to the target Flexible Server instance.
Learn more: Documentation | Announcement blog
Azure DMS: MySQL consistent snapshot without locks (Public Preview)
MySQL Consistent Snapshot is a new feature that allows users to take a Consistent Snapshot of a MySQL server without losing data integrity at source because of ongoing CRUD (Create, Read, Update, and Delete) operations. Transactional consistency is achieved without the need to set the source server to read-only mode through this feature. That is, with this feature, we don’t take a read lock on the server. We instead read tables at different point in time, while keeping track of the different binlog positions of each table. This aids to reconcile the tables towards the end of the initial load by performing replication in catchup mode to get a consistent snapshot.
Learn more: Documentation | Announcement blog
Latest feature roadmap
Feature
Description
Release status
Coming soon!
(Tentative*)
On-demand backup and export
This feature provides you with the ability to export at-moment physical backup of the server to an Azure storage account (Azure blob storage) using an Azure CLI command. After export, these backups can be used for data recovery, migration, data redundancy and availability, or auditing. Learn more.
Public Preview
General Availability
in Q3 CY24
Flexible maintenance options
Building upon our existing system-managed and custom-managed maintenance windows, the following new flexible maintenance options aim to elevate user convenience and operational flexibility in server maintenance:
Reschedule window: Tailor maintenance schedules to suit your business rhythm.
On-demand maintenance: Instantly initiate maintenance activities using the Reschedule now option.
Public Preview
General Availability
in Q3 CY24
Near-zero downtime maintenance for HA servers
This feature is designed to substantially reduce maintenance downtime for HA-enabled servers, ensuring that in most cases, maintenance downtime is expected to be between 40 to 60 seconds. This capability is pivotal for businesses that demand high availability and minimal interruption in their database operations. Learn more.
Public Preview
General Availability
in Q3 CY24
Virtual Canary
The Virtual Canary feature is an exciting solution for Azure MySQL users who prioritize staying at the forefront of technology by making sure that their servers always run the most current version. Servers opted in for virtual canary receive maintenance updates earlier in advance. You can also take advantage of the feature as an opportunity to perform an additional layer of update testing on your dev, test, or staging servers to help avoid workload-specific issues like application-level compatibility issues. The feature thus offers an efficient way to manage updates, align testing and production environments, and maintain operational stability with minimal disruption.
–
Public Preview
in Q3 CY24
Long Term Retention of Backups
Previously with Azure Database for MySQL, you could retain automated backups and on-demand backups for up to 35 days. With Long Term Retention, you can now retain the backups up to 10 years, further accommodating your audit and compliance needs. Learn more.
Public Preview
General Availability
in Q3 CY24
Error Logs (in Server Logs)
This feature allows you to maintain MySQL error log files under Server logs and download them for up to seven days. These error logs can help you efficiently identify and troubleshoot performance and reliability issues, and proactively detect and respond to unauthorized access attempts, failed login attempts, and other security-related events. Learn more.
Public Preview
General Availability
in Q3 CY24
MySQL Discovery & Assessment in Azure Migrate
With this functionality, you can use Azure Migrate to discover MySQL servers in your environment, assess them by identifying their compatibility for moving to Azure Database for MySQL, and receive compute and storage SKU recommendations along with their costs. Learn more.
Private Preview
Public Preview
in Q3 CY24
*The roadmap features and dates are tentative and subject to changes. Please stay tuned for continuous updates.
Conclusion
As we continue to work on new features and functionalities, your feedback is very critical for our improvement. If you wish to enroll in Private Preview for any of the above features, or if you have any suggestions for or queries about our service, email us at AskAzureDBforMySQL@service.microsoft.com.
To learn more about what’s new with Flexible Server, see What’s new in Azure Database for MySQL – Flexible Server. Stay tuned for more updates and announcements by following us on social media: YouTube | LinkedIn | X.
Microsoft Tech Community – Latest Blogs –Read More
TextJoin returning 0 values despite content being in the originating field
I have a formula that is pulling in correct data except for a few lines in my “master grid.” (See formula below)
For some random lines, it pulls in “0” instead of the text that is in the fields on the master grid. I can’t figure it out for the life of me. Can anyone help?
TEXTJOIN(” • “,TRUE,IF(‘Master Grid’!K187:K288=”x”,’Master Grid’!$AL187:$AL288,””))
I have a formula that is pulling in correct data except for a few lines in my “master grid.” (See formula below) For some random lines, it pulls in “0” instead of the text that is in the fields on the master grid. I can’t figure it out for the life of me. Can anyone help? TEXTJOIN(” • “,TRUE,IF(‘Master Grid’!K187:K288=”x”,’Master Grid’!$AL187:$AL288,””)) Read More
Azure ADConnect Export of Settings
I’m looking to regulalry export/backup our ADConnect config as we have had an issue in the past with the persistedstate.xml file being corrputed by an AV tool (we alos now back this up). I’m a little confused though on the capabilties here. reading this guide when I export from the UI it exports a single JSON file. This file does not seem to contain all the settings that define my configuration. For example, it does list sync rules but it does not list the attributes I have configured nor the objects select for sync. If I use the Get-ADSyncServerConfiguration CMDLET I get all settings in a set of files/folders including these attributes.
Which one should I be using here?
I’m looking to regulalry export/backup our ADConnect config as we have had an issue in the past with the persistedstate.xml file being corrputed by an AV tool (we alos now back this up). I’m a little confused though on the capabilties here. reading this guide when I export from the UI it exports a single JSON file. This file does not seem to contain all the settings that define my configuration. For example, it does list sync rules but it does not list the attributes I have configured nor the objects select for sync. If I use the Get-ADSyncServerConfiguration CMDLET I get all settings in a set of files/folders including these attributes.Which one should I be using here? Read More
Desktop slideshow doesn’t work with multiple virtual desktops
To reproduce the bug:
If you don’t have multiple virtual desktops press Win Key + Tab and click the “New Desktop icon.Press Control key + Win Key + left arrow to go to Desktop 1.Right click on the desktop and select “Personalize”Click the “Background” panel.Select the “Slideshow” option from the drop-down box.On the “Choose a picture album for a slideshow” panel choose a folder with some pictures for the slideshow.On the “Change picture every” panel choose 1 minute from the drop-down box.On the “Shuffle the picture order” panel turn the switch to “off”.On the “Choose a fit for your desktop image” choose “Fill” from the drop-down box.Dismiss the “Personalization > Background” by clicking the X at the top right of the window.Press Control key + Win Key + right arrow to go to Desktop 2.Press Control key + Win Key + left arrow to go to Desktop 1.Right click on the desktop and select “Personalize”Click the “Background” panel.You will notice that the drop-down box is showing “Picture”
Windows 11 will not let you keep a slideshow if you want to move from one virtual desktop to another.
To reproduce the bug:If you don’t have multiple virtual desktops press Win Key + Tab and click the “New Desktop icon.Press Control key + Win Key + left arrow to go to Desktop 1.Right click on the desktop and select “Personalize”Click the “Background” panel.Select the “Slideshow” option from the drop-down box.On the “Choose a picture album for a slideshow” panel choose a folder with some pictures for the slideshow.On the “Change picture every” panel choose 1 minute from the drop-down box.On the “Shuffle the picture order” panel turn the switch to “off”.On the “Choose a fit for your desktop image” choose “Fill” from the drop-down box.Dismiss the “Personalization > Background” by clicking the X at the top right of the window.Press Control key + Win Key + right arrow to go to Desktop 2.Press Control key + Win Key + left arrow to go to Desktop 1.Right click on the desktop and select “Personalize”Click the “Background” panel.You will notice that the drop-down box is showing “Picture”Windows 11 will not let you keep a slideshow if you want to move from one virtual desktop to another. Read More
Default years in Excel
Hi there – when typing 5/1/35 in Excel, it is returning 5/1/1935. I tested a few years, and until 5/1/29, the system will default to 2029, but as soon as I type in 5/1/30, it reverts to 5/1/1930. Anyway to change this?
Hi there – when typing 5/1/35 in Excel, it is returning 5/1/1935. I tested a few years, and until 5/1/29, the system will default to 2029, but as soon as I type in 5/1/30, it reverts to 5/1/1930. Anyway to change this? Read More
What scalability benefits does Microsoft Azure offer financial services?
The financial services industry experiences constant fluctuations in demand. From tax season surges to daily transaction spikes, your infrastructure needs to adapt. Microsoft Azure’s scalability is a game-changer for financial institutions. Here’s how:
Elastic Provisioning: Azure offers on-demand services like virtual machines (VMs) and cloud storage. Financial institutions can easily scale resources up or down to meet processing or storage needs. During peak times, provision additional VMs to handle the extra load. When demand subsides, scale back to optimize costs.
Pay-as-you-Go Model: With Azure, you only pay for the resources you use. This eliminates the need for expensive upfront investments in hardware that may not always be utilized. Financial institutions can avoid overspending on underutilized infrastructure and channel those resources towards innovation.
Global Reach: Azure boasts a global network of datacenters. This enables financial institutions to distribute workloads geographically, ensuring high availability and disaster recovery. If a localized outage occurs, operations can seamlessly shift to another region, minimizing downtime and impact.
Built-in Autoscaling: Azure features autoscaling functionality that automatically adjusts resources based on predefined rules. This frees up IT staff from manual provisioning tasks, allowing them to focus on higher-level initiatives. Scalable Analytics: Azure provides robust data analytics solutions like Azure Synapse Analytics. Financial institutions can leverage these services to handle massive datasets and gain real-time insights to make informed decisions.
The financial services industry experiences constant fluctuations in demand. From tax season surges to daily transaction spikes, your infrastructure needs to adapt. Microsoft Azure’s scalability is a game-changer for financial institutions. Here’s how: Elastic Provisioning: Azure offers on-demand services like virtual machines (VMs) and cloud storage. Financial institutions can easily scale resources up or down to meet processing or storage needs. During peak times, provision additional VMs to handle the extra load. When demand subsides, scale back to optimize costs. Pay-as-you-Go Model: With Azure, you only pay for the resources you use. This eliminates the need for expensive upfront investments in hardware that may not always be utilized. Financial institutions can avoid overspending on underutilized infrastructure and channel those resources towards innovation. Global Reach: Azure boasts a global network of datacenters. This enables financial institutions to distribute workloads geographically, ensuring high availability and disaster recovery. If a localized outage occurs, operations can seamlessly shift to another region, minimizing downtime and impact. Built-in Autoscaling: Azure features autoscaling functionality that automatically adjusts resources based on predefined rules. This frees up IT staff from manual provisioning tasks, allowing them to focus on higher-level initiatives. Scalable Analytics: Azure provides robust data analytics solutions like Azure Synapse Analytics. Financial institutions can leverage these services to handle massive datasets and gain real-time insights to make informed decisions. Read More
B Y B I T Реферальный Код (GET888) Предложения на 2024 год – Получите до $30,020 в Бонусах!
B Y B I T Реферальный Код (GET888) Предложения на 2024 год – Получите до $30,020 в Бонусах!
Присоединяйтесь к B Y B I T сейчас с моим эксклюзивным реферальным кодом GET888 и получите до $30,020 в приветственных бонусах! B Y B I T — одна из самых быстрорастущих криптовалютных бирж, известная своим превосходным удобством использования, исключительно низкими торговыми комиссиями и доступным кредитным плечом до 100x. Не упустите эти невероятные предложения:
Бонусы для новых пользователей
Бонус за регистрацию $20: Получите $20 сразу после регистрации.До $30,000 в бонусах на депозит: Получайте значительные бонусы по мере увеличения депозитов и торговли.
Эксклюзивные бонусы на депозиты и торговлю
Депозит $100 и торгуйте на $500: Получите $10Депозит $500 и торгуйте на $800: Получите $20Депозит $1,000 и торгуйте на $2,000: Получите $50Депозит $3,000 и торгуйте на $6,000: Получите $100Депозит $10K и торгуйте на $40K: Получите $350Депозит $20K и торгуйте на $150K: Получите $800Депозит $100K и торгуйте на $10M: Получите $5,000Депозит $125K и торгуйте на $50M: Получите $8,800Депозит $150K и торгуйте на $75M: Получите $15,000Депозит $250K и торгуйте на $150M: Получите $30,000
Более 80% пользователей выигрывают $100 или больше с этими предложениями! Кроме того, наслаждайтесь обновлениями статуса VIP и приглашениями на эксклюзивные мероприятия.
Почему стоит выбрать B Y B I T?
Низкие торговые комиссии: Начинаются с 0,1% для мейкеров и тейкеров.Высокое кредитное плечо: Торгуйте с плечом до 100x.Превосходная функциональность: Легкий в использовании интерфейс как для новичков, так и для опытных трейдеров.Доступ через мобильные устройства и десктоп: Торгуйте без перерывов в любом месте или со своего компьютера.Отличная поддержка клиентов: Всегда готова помочь в случае проблем.
Конкурентные комиссии и передовые функции B Y B I T делают его отличным выбором для любого энтузиаста криптовалют. С использованием моего кода GET888 вы можете в полной мере воспользоваться выгодными приветственными бонусами B Y B I T и начать свое торговое путешествие с большим преимуществом.
Как получить свои бонусы от B Y B I T
Зарегистрируйтесь: Нажмите на ссылку и зарегистрируйтесь на B Y B I T, используя код GET888.Депозит и торговля: Сделайте первый депозит и начните торговлю, чтобы разблокировать свои бонусы.Наслаждайтесь своими наградами: Следите за накоплением своих бонусов и наслаждайтесь преимуществами пользователя B Y B I T.
Не упустите эту возможность максимизировать свой опыт торговли криптовалютами с B Y B I T. Используйте реферальный код GET888 и откройте для себя мир наград!
B Y B I T Реферальный Код (GET888) Предложения на 2024 год – Получите до $30,020 в Бонусах!Присоединяйтесь к B Y B I T сейчас с моим эксклюзивным реферальным кодом GET888 и получите до $30,020 в приветственных бонусах! B Y B I T — одна из самых быстрорастущих криптовалютных бирж, известная своим превосходным удобством использования, исключительно низкими торговыми комиссиями и доступным кредитным плечом до 100x. Не упустите эти невероятные предложения:Бонусы для новых пользователейБонус за регистрацию $20: Получите $20 сразу после регистрации.До $30,000 в бонусах на депозит: Получайте значительные бонусы по мере увеличения депозитов и торговли.Эксклюзивные бонусы на депозиты и торговлюДепозит $100 и торгуйте на $500: Получите $10Депозит $500 и торгуйте на $800: Получите $20Депозит $1,000 и торгуйте на $2,000: Получите $50Депозит $3,000 и торгуйте на $6,000: Получите $100Депозит $10K и торгуйте на $40K: Получите $350Депозит $20K и торгуйте на $150K: Получите $800Депозит $100K и торгуйте на $10M: Получите $5,000Депозит $125K и торгуйте на $50M: Получите $8,800Депозит $150K и торгуйте на $75M: Получите $15,000Депозит $250K и торгуйте на $150M: Получите $30,000Более 80% пользователей выигрывают $100 или больше с этими предложениями! Кроме того, наслаждайтесь обновлениями статуса VIP и приглашениями на эксклюзивные мероприятия.Почему стоит выбрать B Y B I T?Низкие торговые комиссии: Начинаются с 0,1% для мейкеров и тейкеров.Высокое кредитное плечо: Торгуйте с плечом до 100x.Превосходная функциональность: Легкий в использовании интерфейс как для новичков, так и для опытных трейдеров.Доступ через мобильные устройства и десктоп: Торгуйте без перерывов в любом месте или со своего компьютера.Отличная поддержка клиентов: Всегда готова помочь в случае проблем.Конкурентные комиссии и передовые функции B Y B I T делают его отличным выбором для любого энтузиаста криптовалют. С использованием моего кода GET888 вы можете в полной мере воспользоваться выгодными приветственными бонусами B Y B I T и начать свое торговое путешествие с большим преимуществом.Как получить свои бонусы от B Y B I TЗарегистрируйтесь: Нажмите на ссылку и зарегистрируйтесь на B Y B I T, используя код GET888.Депозит и торговля: Сделайте первый депозит и начните торговлю, чтобы разблокировать свои бонусы.Наслаждайтесь своими наградами: Следите за накоплением своих бонусов и наслаждайтесь преимуществами пользователя B Y B I T.Не упустите эту возможность максимизировать свой опыт торговли криптовалютами с B Y B I T. Используйте реферальный код GET888 и откройте для себя мир наград! Read More
Azure VMware Solution using a public IP down to the NSX-T Edge; configure SNAT, No-SNAT & DNAT
Azure VMware Solution
How To Series: Configuring NSX-T SNAT, No-SNAT & DNAT rules
Overview
Requirements
Lab Environment
NAT Rules
Kusto for NSX-T NAT Rule Logs
Overview
Many Azure VMware Solution customers are new to NSX-T and for a use requiring connecting directly to the internet through and Azure Public IP, then understanding how and when to use NAT functionality is a must have skillset. This This blog uses an example to walk through the configuration of NSX-T NAT rules to enable access from AVS guest VMs to VMs and services on-premises, in Azure and the Internet.
For this lab, ExpressRoute connections to Azure (vWAN) and to on-premises have been provisioned.
Requirements
Internet Connectivity has been set to “Connect using Public IP down to the NSX-T Edge” via the Azure Portal.
Cloudadmin (or equivalent role) to the Azure VMware Solution NSX-T console.
Azure VMware Solution diagnostics enabled and log analytics workspace to store the logs configured.
Figure 1: Log Analytics diagnostics for Azure VMware Solution
Check that you have set the ‘Configure the AVS SDDC to connect using Public IP down to the NSX-T Edge’ in the Internet connectivity under the menu item ‘Workload networking/Internet connectivity’ option.
Create (using the +Add button) 4 Public IPs
Figure 2: Setting up the NSX-T public IP and four Internet IPs.
Lab Environment
There are four routes that will be explored in this lab. Each route requires specific configuration of the NSX-T NAT rules. Logs generated by the NAT rules are stored in a log analytics workspace.
From AVS guest VM’s to the public Internet
From AVS guest VM’s to Azure native
From AVS guest VM’s to the on-premises environment
From the public Internet to a specific VM guest server.
This lab does not incorporate NSX-T Firewall settings; the NAT rules are used for routing, not for traffic restrictions or filtering. Note that AVS workloads are a range of IP addresses in the 192.168.0.0/24 network range, Azure native IP addresses are 10.5.4.0/22, and the on-premise environment is 172.21.86.0/24 and 192.168.87.0/24
Figure 3: NSX-T Public IP NAT rules lab.
NAT Rules
SNAT rules are used to allow access to the Internet from virtual machines and NVAs running in the Azure VMware Solution.
No-SNAT rules are used to allow access to on-premises and Azure native services from VMs running in the Azure VMware Solution.
DNAT rules are used to allow access from the Internet to VM’s running in the Azure VMware Solution.
Create a SNAT rule:
Source Network Address Translation (source-nat or SNAT) allows traffic from a private network to go out to the Internet. First let’s make sure that the DNS service can reach the default DNS server 1.1.1.1. When first logging into the NSX-T interface, first log into NSX-T, alarms will be present because the DNS service is unable to reach the upstream DNS servers at 1.1.1.1.
Figure 4: Alarms showing DNS service 1.1.1.1 is unreachable.
In this scenario, we want the application servers AppServer-01 and AppServer-02 to be able to access the Internet.
From the NSX-T console select Networking / NAT / Tier-1 Gateway and click on “ADD NAT RULE”
Figure 4: Create a SNAT rule
Add Name ‘AppServers via HTTP’, select SNAT as the action (default) and enter the two IP addresses of the AppServers (192.168.103.10, 192.168.103.11). This means the rule only applies to these two IP addresses. Next leave the Destination IP|Port as blank (ie any IP is allowed). In the translated IP|Port, use the first available public IP (20.95.39.0), or you can fill it in with any of the public IPs created when you configured the portal for NSX-T public IP. Use a specific IP if you need to enable a partner or customer to add the site/service to a Whitelist. If you have multiple rules, select a priority to ensure this rule is hit in the correct order. Note, the lower the number, the higher the priority. So a rule with priority 10 will be checked before a rule with priority 20. Enter a description, then click save.
Figure 5: Filling the the SNAT rule parameters
At this point you will be able to access the Internet from the two AppServers.
Create a No-SNAT rule:
A No-SNAT rule prevents the translation of the internal IP address of packets sent from an AVS SDDC to other networks internal to the organization or otherwise outside of the SDDC environment. This is important when using the “Connect using Public IP down to the NSX-T Edge” option in the Azure portal because without No-SNAT rules, you will not be able to access Azure or on-premises resources from workloads running in AVS.
In this simple lab environment, the Azure environment contains RFC 1918 addresses 10.X.X.X/8 and the on-premises environment contains 172.21.x.x/16 addresses. Due to the nature of NAT/SNAT, connectivity from Azure and on-premises network into the 192.168.0.0/22 address exists, however outbound initiated connectivity from AVS workloads does not.
From the NSX-T console select Networking / NAT / Tier-1 Gateway and click on “ADD NAT RULE”
Figure 6: Creating a No-SNAT rule
This demo configuration is very open, in production you would likely identify specific vNets where you require access, not the entire 10.0.0.0/8 supernet.
Click on “ADD NAT RULE” and enter the NAT rule Name “Access Azure from AVS”, change the Action to “No-SNAT”. Set the Source IP to 192.168.96.0/20 (this will cover all of the 192.168.x.x addresses in our lab environment), set the Destination IP|Port to 10.0.0.0/8 and leave the Translated IP|Port empty. Enter a Description “Enable access from AVS without SNAT. (No-SNAT)”
Figure 7: No-SNAT rules parameters
Create a DNAT rule:
Destination network address translation (DNAT), it is a technique for transparently changing the destination IP address of a routed packet and performing the inverse function for any replies. In this use case, we will create a DNAT rule that enables access to a virtual machine running in the Azure VMware Solution through a public IP address created when you enable the “Connect using Public IP down to the NSX-T Edge” option in the Azure Portal; here you can see we have configured 4 IP public addresses (20.95.39.0 to 20.95.39.3).
Create a DNAT rule that allows access on port 80 to the web server running in VLAN-2 with IP address 192.168.101.10.
We are going to assign it a public facing IP address of 20.95.39.1 from the pool of IP’s defined in the screenshot above.
From the NSX-T console select Networking / NAT / Tier-1 Gateway and click on “ADD NAT RULE”
Figure 8: Creating a NAT rule to support DNAT.
Add in the parameters as described, and enable logging.
Figure 9: Adding the DNAP rule parameters
At this point, go to a web browser and enter http://publicIPselected and you will see the web site running on your webserver.
Tips & Tricks
If access is blocked, check that any NSX-T Distributed firewall rules in place are configured to allow traffic from the Internet to the webserver/service.
Microsoft Tech Community – Latest Blogs –Read More
Join the Teams Insider Community
Using Teams with a personal account and interested in the latest updates and features? The Teams Insider program is an excellent option. You can join the Teams Insider program via the app settings or by using a direct link.
Additionally, if you wish to play a more active role in the development of the Teams app, consider joining the Teams Insider Community. Instructions on how to join can be found in a recent blog post.
As a member of the Teams Insider Community, you’ll receive an invitation to the upcoming monthly call with the Teams product team, where you’ll learn about the latest developments and future updates. For more details, refer to this blog post.
There are numerous opportunities to get involved and contribute to the development of the Teams app. Looking forward to connecting with everyone in the Teams Insider Community and during our next monthly call!
Miikka (Teams PM)
Microsoft Tech Community – Latest Blogs –Read More
Remove ‘High Contrast Only’ toggle when selecting text/cell colours
Hi,
I’ve noticed a recent accessibility addition in the colour drop down (attached photo).
Is there a way to remove this, as I don’t need to see this every time I choose a colour outside of high contrast mode.
Excel Version 2405 (Build 17628.20144)
Hi,I’ve noticed a recent accessibility addition in the colour drop down (attached photo).Is there a way to remove this, as I don’t need to see this every time I choose a colour outside of high contrast mode. Excel Version 2405 (Build 17628.20144) Read More
How do I resolve this exception thrown while trying to do CRUD operations on CSOM?
How do I resolve this exception thrown while trying to do CRUD operations on CSOM?
Let me break this down for you. CRUD, of course, means “Create Read Update and Delete”. CSOM is the tech for connection C# to a Sharepoint List (or, I assume, also a Microsoft List) in order to programmatically make additions or mortifications to said list from C# code.
I think that, due to the fact that the Microsoft List resides on a highly secure remote source dripping with security systems, I get an exception thrown when I set up a query and perform an “ExecuteQuery” from the ClientContext class. I can provide some source code if necessary but I do not think it is necessary. The question I have is simply this. What would cause a 403 Forbidden error and how can I
find a way to resolve it?
How do I resolve this exception thrown while trying to do CRUD operations on CSOM? Let me break this down for you. CRUD, of course, means “Create Read Update and Delete”. CSOM is the tech for connection C# to a Sharepoint List (or, I assume, also a Microsoft List) in order to programmatically make additions or mortifications to said list from C# code. I think that, due to the fact that the Microsoft List resides on a highly secure remote source dripping with security systems, I get an exception thrown when I set up a query and perform an “ExecuteQuery” from the ClientContext class. I can provide some source code if necessary but I do not think it is necessary. The question I have is simply this. What would cause a 403 Forbidden error and how can I find a way to resolve it? Read More
Pasting links in Outlooks looks different
Dear Community,
I would need your help. It’s been 2 days since whenever I would like to add a link from SharePoint to outlook appears under the format visible below as text, instead of like in the first screenshot. Even my outlook signature is showing as text. Does anyone know how I could revert back? Been searching for 2 days for a solution but couldn’t find it. Many thanks
Dear Community, I would need your help. It’s been 2 days since whenever I would like to add a link from SharePoint to outlook appears under the format visible below as text, instead of like in the first screenshot. Even my outlook signature is showing as text. Does anyone know how I could revert back? Been searching for 2 days for a solution but couldn’t find it. Many thanks Read More
Installing Modern Script Editor by SPFx: How to for Dummies
Hello,
I have a need to use the “Modern Script Editor” by SPFx (need to embed some Javascript code at the bottom of a page) but apparently I’m not smart enough to actually get the web part loaded into our SharePoint online site. Is there a step-by-step anywhere for dummies?
Hello, I have a need to use the “Modern Script Editor” by SPFx (need to embed some Javascript code at the bottom of a page) but apparently I’m not smart enough to actually get the web part loaded into our SharePoint online site. Is there a step-by-step anywhere for dummies? Read More
