Microsoft Support & Discussions

This is because the Login is mapped to the "master" database of each server. So, when we configure FailOver Groups, only the users of the user database will replicate to the secondary server. You could find more information here: Configure security for disaster recovery - Azure SQL Database | Microsoft Learn To avoid incorrect user errors, the case failover, you will have to manually create the Logins/Users of the primary server on the secondary server. In the event that you have to “replicate” SQL Logins, you will have to create the Login with the same SID (security identification number) - Logins in secondary server not mapped correctly from primary server…

About the Author Sachin Mittal - Beta Microsoft Learn Student Ambassador - Microsoft | I am pursuing my bachelor's degree from IIT Roorkee, India and a Beta Microsoft Learn Student Ambassador. I am passionate about Web Development and Open-Source Contribution. I also like sharing tech information with others. In this blog, we will learn how you can implement Azure SQL database as backend for your web app. Azure SQL Database is an always-up-to-date, fully managed relational database service built for the cloud. Want to know more about Azure SQL, check Azure SQL documentation. Why to use Azure SQL database? Fully managed and alw…

Viva Goals: Connecting people to strategy for greater business success with OKRs & Viva Goals In today’s Do More with Less workplace environment the Employee Experience is more important than ever. Microsoft Viva Goals helps the organizations people stay connected with organizational strategy bringing clarity of mission and empowering staff to remove distractions that add to workforce crisis stress. Join us Friday, February 3rd at 12 noon eastern for the webinar “Do More with Less Employee Experience Series – Viva Goals.” The webinar will be delivered by Microsoft Viva Goals Senior Director Don Campbell. During the webinar Don will cover Microsoft’s own jo…

We are happy to announce that Microsoft Teams application window sharing is now generally available on Azure Virtual Desktop for Windows users.  With application window sharing, users can now choose a specific window to share from their desktop screen. Previously, users could only share their full desktop windows or a Microsoft PowerPoint Live presentation. Application window sharing will help reduce the risk of displaying sensitive content during meetings/calls and keep meetings focused by directing participants to specified content. Getting Started   Application window sharing is available for both, Teams running on a session desktop and as a R…

Overview A global enterprise wants to migrate thousands of VMware vSphere virtual machines (VMs) to Microsoft Azure as part of their application modernization strategy. Their first step is to exit their on-premises data centers and rapidly relocate their legacy application VMs to the Azure VMware Solution as a staging area for the first phase of their modernization strategy. What should the Azure VMware Solution look like? Azure VMware Solution is a VMware validated first party Azure service from Microsoft that provides private clouds containing VMware vSphere clusters built from dedicated bare-metal Azure infrastructure. It enables customers to leverage t…

Greetings to our lovely NTA non-profits. Some of the most popular questions that the NTA team receives from our organizations have to do with file and document storage options and which one is best one to use from an organizational standpoint. This article will uncover the best use cases for storage in OneDrive, SharePoint, and Microsoft Teams. OneDrive OneDrive is a cloud storage system that allows you to save and access your documents and files from any device you sign into the account with. If you are working on Windows 10 or above, you may already be familiar with your personal account of OneDrive that was preinstalled to your computer. Once you are ap…

As part of our commitment to support the data community, we operate under the mantra “Community-Owned, Microsoft-Empowered". We created an advisory council made up of community and user group leaders from all over the globe to advise Microsoft on community needs. As existing members depart or complete their terms, we come to the community to find interested, passionate individuals to serve. From our most recent set of applicants, we have asked Rodrigo Crespi and Ben Weissman to join us. That leaves an open seat on the Council and we're hoping you're interested in giving back. What's involved with the Azure Data Community Advisory Council The Council w…

SQLBits, the largest data platform conference in Europe, is in Newport, Wales this year as a hybrid event from March 14 to March 18 with two days of full-day training sessions and three days of general sessions. Saturday is a community day and is free for all to attend! And in case the title of this blog wasn't enough of a hint, SQL Bits always has a fun conference theme and this year it’s Dungeons and Dragons! Microsoft is the headline sponsor, delivering 4 full-day workshops (including a hands-on SQL Server 2022 workshop), along with 40+ sessions, keynote, booth, and much more! We’ll even have a Community Corner at the conference where attendees can stop by and…

We’re looking into ways in which we can improve the experience of installing Exchange Server Cumulative Updates (CUs) and Security Updates (SUs). We’d love to get your input and feedback. We have created a brief survey for you which we will keep open until the end of this month. The survey is anonymous, but we do give you an option to share your contact info with us if you’re open to discussing this further with us. Please take a few moments to respond to this survey and let us know what we can do to improve the experience of installing Exchange Server updates. Microsoft Exchange Server - Update Experience Survey Microsoft Forms Exchange Server Team Co…

Ensure uptime with fully managed disaster recovery in the cloud through the link feature in Azure SQL Managed Instance, deliver seamless analytics and insights in near real time by breaking the wall between operational and analytical stores with Azure Synapse Link, and manage and govern your entire data estate through SQL Server integration with Microsoft Purview and Microsoft Defender for SQL assessments and alerts. All this and more on this episode of Data Exposed with Anna Hoffman and Bob Ward. Resources: Link feature for Azure SQL Managed Instance Azure Synapse Link for SQL Learn more about SQL Server 2022: https://aka.ms/sqlserver2022 Download SQL…

Ensure uptime with fully managed disaster recovery in the cloud through the link feature in Azure SQL Managed Instance, deliver seamless analytics and insights in near real time by breaking the wall between operational and analytical stores with Azure Synapse Link, and manage and govern your entire data estate through SQL Server integration with Microsoft Purview and Microsoft Defender for SQL assessments and alerts. All this and more on this episode of Data Exposed with Anna Hoffman and Bob Ward. Resources: Link feature for Azure SQL Managed Instance Azure Synapse Link for SQL Learn more about SQL Server 2022: https://aka.ms/sqlserver2022 Dow…

As one of the most requested features for Microsoft Bookings, we are pleased to share that you can now create a multiple staff appointment! Previously, Bookings only supported the creation of a single staff service where an appointment is scheduled with a single staff member. With the new multiple staff appointments feature, you can create service with more than one staff member in a single appointment. Your end customers will now be able to create appointments using the multiple staff service and meet all staff members together. How can you start using multi-staff appointments? Now when you try to add a new service to your Bookings page, in the Assign…

In some situations, as you could find in this URL Additional Endpoints Required for AAD Authentication and CRL Checks for Azure SQL DB - Microsoft Community Hub we faced connectivity problems reaching the different endpoints of AAD or opening the outbound ports 443. I would like to share my lessons learned based on error code and messages about this issue: Unable to acquire authorization token: No connection could be made because the target machine actively refused it x.x.x.x:443 The service located on port 443 is not responding or a firewal is blocking the port 443 or the IP. [*] Unable to acquire authorization token: An attempt was made to access …

Author: Ryan Adams is a Program Manager in Azure Synapse Customer Success Engineering (CSE) team. There are two ways to read data inside Data Lake using the Synapse Serverless engine. In this article, we’ll look at the first method which uses OPENROWSET to query a path within the lake. Synapse is a collection of tools with four different analytical engines (Dedicated Pool, Spark Pool, Serverless Pool, Data Explorer Pool). This gives you a lot of options for ingesting, transforming, storing, and querying your data. The article will focus on how you can use the Synapse Serverless Pool to query the data in your ADLS account. Let's start by going …

We continue to expand the Azure Marketplace ecosystem. For this volume, 130 new offers successfully met the onboarding criteria and went live. See details of the new offers below: Get it now in our marketplace [attachment=30378:name] Airflow by Kockpit: This offer from Kockpit provides Apache Airflow on Ubuntu 20.04.02 LTS. Apache Airflow is a platform for programmatically authoring, scheduling, and monitoring workflows. This image is designed for production environments on Microsoft Azure. [attachment=30379:name] AllegroGraph 7.3.1 VM: This offer from Franz Inc. provides AllegroGraph 7.3.1 on a Microsoft Azure virtual machine. AllegroGraph is a dis…

It’s been a big quarter for Azure learners. We’ve added dozens of opportunities aimed at helping you gain skills to confront the uncertainty in today’s market. No matter if you’re new to the IT field or more experienced, we’re here to support you in your learning journey. Discover how to take your Azure knowledge to new heights as we look back on the recently published learning resources that have been helping learners reach their goals. Get your game on and develop a new skill in 30 days Ready for a challenge? With the Windows Server Hybrid Administrator: 30 Days to Learn It challenge you’ll learn how to implement and manage on-premises and hybrid solutions, …

Continuously copying data from its source to a new location is very common - backups, high availability, and analytics are just a few examples of why you would do so. But as data grows, making a full copy every time becomes impractical - copying terabytes of data requires time, compute, and networking resources, all of which increase the total cost of ownership of a solution. So, in most cases, it makes sense to load data incrementally - meaning, only what you need - each time you run the synchronization process. In this article, we discuss a common technique for incremental data loading, called High-watermarking. What is High-watermarking? High-wat…

"Are you struggling to effectively manage and engage your volunteers? Look no further! Introducing Volunteer Management, the powerful tool that will revolutionize the way your nonprofit approaches volunteer coordination." Volunteer Management is a powerful tool that helps nonprofits manage and engage volunteers in a more efficient and effective way. The application is designed to streamline coordination, so volunteer managers can easily match the right volunteers with the right opportunities. One of the key features of Volunteer Management is the ability to publish engagement opportunities. Volunteer managers can design the opportunity, define the qu…

Data protection is a critical role for security and compliance teams, and it is essential to make sure that data is secure at all times, including when it is at rest, in use, and when it leaves the organization's control. In this blog post, we will go through the three main components of a data protection plan as well as the initial deployment goals for establishing a Zero Trust approach to data security. Know your data This is the first step in safeguarding data with Zero Trust. It is vital to identify data within the organization and categorize all data according to sensitivity level. This encompasses both on-premises and cloud-based data. It is impossible t…

Early this week Satya Nadella, Microsoft CEO, and Eric Boyd, Corporate AI Vice President, announced Azure OpenAI Service generally available, which will soon include ChatGPT – the fine-tuned version of GPT-3.5 built upon Azure AI infrastructure gone viral in the last few weeks. But let’s take a step back. What is Azure OpenAI? The Azure OpenAI Service is the result of a 4-years partnership between Microsoft and OpenAI with the mission of building an artificial general intelligence (AGI) system, democratizing AI and generating a broadly distributed economic benefits. From a technical point of view, Azure OpenAI provides access to OpenAI’s powerful language (like …

We’re excited to announce that support for the new Azure Durable Functions storage providers, Netherite and Microsoft SQL Server (MSSQL), is now generally available! Some of you may have learned about these new storage providers during the annual Build conference and/or from this preview announcement blog post. Durable Functions enables you to write long-running, reliable, event-driven, and stateful logic on the serverless Azure Functions platform using everyday imperative code. We believe the new storage providers will enable a host of new scenarios for apps using Durable Functions because they allow apps to run at a higher scale, with greater price-performance ef…

We got a new customer service request where they got the following error message: The database 'UserDB' has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions. We found that database reached it's size limit (1024GB) with Space Used 1023.253 GB. After analyzing these two links Lesson Learned #150: Calculating the space used by table and per column - Microsoft Community Hub and Lesson Learned #227: How much data is using my database per table - Microsoft Community Hub and we didn't find that might be related with PVS, so, the immediate option is to increase the SLO to give you more available space …

Our customer faced the following error message Cannot find SSL Trust Store File connecting to Azure SQL Database normally that means that the client is not able to find installed the certificates needed for Azure SQL Database / Managed Instance. Depending on different service they might not have installed the certificates needed to connect to Azure SQL Database or Managed Instance. In this situation, to resolve the issue was needed to install this two certificates https://www.digicert.com/CACerts/BaltimoreCyberTrustRoot.crt.pem https://cacerts.digicert.com/DigiCertGlobalRootG2.crt.pem And depending on the service, you need to create a combined certificate …

If you are a Database Administrator (DBA) and responsible for managing, securing, protecting, and governing hundreds of SQL Servers, you are not alone, we are here to simplify these tasks using Azure Arc-enabled SQL Server. Learn more. In this blog, I will introduce you to the Best practices assessment (BPA) feature powered by Azure Arc-enabled SQL Server. This feature allows you to proactively diagnose potential issues with your SQL Server environment running on-premises and in multi-cloud environments. This capability in the past was only available to SQL Servers running on Azure VMs, and now we have enabled this capability to SQL Servers deployed outsi…

Currently, a PostgresSQL flexible server doesn't support Azure Private Link. Instead, it uses virtual network injection to make the flexible server available within a virtual network. While Azure Private Link is on the road map, today, to access Azure PostgreSQL flexible server from an Azure Data Factory VNET using a private endpoint, the following architecture and steps can be adopted. Note: Similar setup can be done for accessing PostgreSQL Flexible Server from an Azure Synapse Analytics Managed Vnet. The architecture and steps follow the tutorial provided in the documentation link below with minor changes specific to PostgreSQL Flexible s…