Microsoft Support & Discussions

In this article, I will share with you the steps needed to copy your Azure SQL database from one of servers to another on a different subscription and different tenant (Microsoft Entra). Usually, it is the best approach when you have different subscriptions and tenants for different environments, like when you want to refresh your development or preprod with a new and up to date copy of your production database. 1. Both servers' firewalls must be configured to allow inbound connection from the IP of my machine: Make sure to enable public access and add my IP to both source and destination: [ATTACH=full]54707[/ATTACH] 2. To find my IP using SSMS and m…

In the realm of biomedical research and healthcare analytics, one common task is the selection of specific cohorts of patients from larger datasets. These cohorts often serve as the foundation for various studies, clinical trials, and population analyses. The ability to construct patient cohort accurately and efficiently is crucial for gaining insights, conducting research, and improving patient care. There are several things specific to the healthcare field that make cohort generation more challenging. Many datasets have restricted access and, in some cases, even data schemas are not available to researchers. Also, a dataset might contain Protected Health Inform…

Dynamics 365 Guides continues to roll out improvements, with the latest set of new features resulting from working closely with our customers on their feedback. These three features enhance and expand usability and user experience. These features make it easier than ever to build and share your guides content. [ATTACH=full]54703[/ATTACH]object anchors: scanning an ATV to create a mesh Object Anchors Imagine being able to walk up to any object and your HoloLens 2 scans and recognizes it. A holographic overlay snaps to the object without a QR code or any extra physical markers. This is exactly how object anchors work in Guides. They allow users to embed inst…

Marketplace Azure Applications are used by thousands of ISVs to offer cloud solutions hosted in the customer Azure tenant. We’re excited to announce new Azure Application deployment modes to give ISVs and customers more flexibility to configure and sell Azure Applications managed by their customers. This is how some leading ISVs and startups are selling and deploying Azure Apps via Marketplace: [ATTACH=full]54700[/ATTACH] "Microsoft's Azure Marketplace allows us to serve and support a global audience leveraging native Microsoft technologies like Azure Virtual Desktop, Microsoft Intune, and Windows 365. Having Azure Apps that run inside the customer's Azure t…

AI is here today and opening up a new frontier for productivity at a time when the pace and volume of work has increased significantly. Small and medium businesses (SMBs) are looking for the best ways to integrate AI into their work to help them productively run their day-to-day business, creatively reach and serve their customers, and scale and grow. To support their business objectives one of our newest AI offerings, Bing Chat Enterprise, is now available (in preview) for all Microsoft 365 Business Standard and Business Premium customers at no additional cost. Bing Chat Enterprise is an AI-powered web chat that will you get instant answers, insights, and creative…

We are very glad to announce new auditing feature added to Exchange Online public folders. The feature allows you to monitor/track public folder deletions in the organization. Public folder deletions performed using any client (Outlook desktop client, Exchange admin center, Exchange Online PowerShell etc.) are all audited. The feature is now available for all Exchange Online tenants. The following are the steps to track the deletion: Login to Microsoft Purview Compliance portal (Sign in to your account) Select Audit and specify the following under New Search Date range for which auditing entries should be searched Under Record types select Public Folder P…

When dealing with data migration or integration tasks, it's common to encounter transient issues that may cause the process to fail. One common tool used for data migration is the Bulk Copy Program (BCP) in SQL Server. In this blog post, we will discuss how to implement a retry logic for BCP commands in a Linux environment, to handle temporary failures and ensure data is transferred successfully. Creating a Sample Table and Data File: Before we proceed with the retry logic, let's first create a sample SQL Server table and a text file with data to be imported. Sample SQL Server Table: CREATE TABLE MyTable2 ( ID INT PRIMARY KEY, Name VARCHAR(50)…

In March 2023, we announced the general availability of the Single to Flex migration tool. Since then, we have seen many successful migrations and over 10K+ single servers migrate to Azure Database for PostgreSQL – Flexible Server. After reviewing migrations, we noticed that pre-migration setup process can prove to be a formidable obstacle. More than a third of the attempted migrations failed due to setup issues. Networking hiccups, authentication issues, permissions problems are some of the common setup issues faced by many customers. Though many customers were able to fix these issues and run successful migrations, we felt the need to address this gap in the mig…

Layers enable users to organize multiple elements of a diagram and control which ones are seen, hidden, locked, or unlocked with just a few clicks. The Visio desktop app has long supported layers, and now Visio for the web does, too. Users with a Visio Plan 1 or Visio Plan 2 license can now use layers to group a related set of shapes in a drawing and change properties of all the layer members at once. Example user scenario: Network diagrams Tomás, a network security architect for a global financial firm, is one of a dozen members of the firm’s enterprise architecture team in charge of meticulously designing network architectures that are efficient, reliable, …

It’s my great pleasure to be back to present another accessibility-themed skilling snack. Voice access is a new feature in Windows 11, version 22H2 and later that enables everyone, including people with mobility disabilities, to control their PC using only their voice. After initial setup, it even works without an internet connection. And while today, it’s only available for six dialects of English, support for further languages is coming soon. As an IT pro, this is a feature I encourage you to lean in and learn more about. Help your users be aware of it and be an ally when you come across someone who may benefit from its features. [ATTACH=full]54674[/ATTACH] Tim…

In the fast-paced world of software development, the ability to swiftly and accurately translate client needs into tangible product features is a critical success factor. This process begins with the often-detailed discussions and conversations that help define project requirements. However, managing and extracting actionable insights from these discussions can be a time-consuming and error-prone task. But what if you could streamline and automate this process, saving both time and resources while ensuring a higher degree of precision? Welcome to the world of end-to-end automation, where we bridge the gap from requirement discussion transcripts to Azure DevOps feat…

Be Inspired | Learn | Connect [ATTACH=full]54663[/ATTACH] Amsterdam is one of the most vibrant and diverse cities in Europe – and primed for in-person depth and breadth learning during the European SharePoint Conference – now simply branded as: ESPC23 – in Amsterdam, Netherlands – November 27-30, 2023. You will have the opportunity to learn from experts, network with peers, and discover new technologies that can help you achieve your goals. The event and city have something for everyone: Inspiring keynotes, depth sessions and workshops, community, famous canals, art and culture, and much SharePint’ing. [ATTACH=full]54664[/ATTACH]European SharePoint C…

If you've been working with Azure OpenAI for a while, chances are you've heard of Semantic Kernel. It is a library implemented in multiple programming languages that can handle prompt templates, manage conversation state, integrate with plugins and many other features essential to building an advanced LLM-infused application. But how exactly do you "deploy" Semantic Kernel? Being a software library, Semantic Kernel can be deployed to any compute option capable of running Python, C# or Java. You've probably seen sample repositories with Jupyter notebooks you can use to explore the functionality. But in most cases you can't give your end-users a notebook! In this art…

IMPORTANT This article only applies if you bought a Microsoft 365 E3 Original subscription through an Enterprise Agreement (EA). If this applies to you, you now see the Microsoft 365 E3 Extra Features product on the Licenses page in the Microsoft 365 admin center. As part of your Microsoft 365 E3 Original subscription, your organization now has access to the Microsoft 365 E3 Extra Features license at no additional cost. This license enables the following features for your users: Bing Chat Enterprise — An AI-powered copilot for the web, with commercial data protection. It ensures user and business data are protected, won’t leak outside the organization a…

With Intune’s October service release (2310), we have five new capabilities to talk about! Application management for Windows, previously in public preview, is now generally available. We’ve added the ability to install and uninstall line-of-business (LOB) apps for devices that run on Android Open Source Project (AOSP). Additionally, we’ve released two new capabilities for Apple devices: Software updates with Declarative Device Management (DDM) and web enrollment with Just in Time (JIT) registration. Let me know what you think of these capabilities by commenting on this post or connecting with me on LinkedIn. Application management for Windows The highly antici…

Frontend web developers rely on iteration, flexibility, and experimentation to build websites that delight end users. With Azure Static Web Apps, we’re committed to building the platform that enables you to build productively and optimize your websites for the best performance. To this end, we are announcing two new features: Snippets and Traffic Splitting. These features are designed to improve your workflow and productivity by facilitating injecting code at runtime and splitting your traffic across environments. Snippets for Azure Static Web Apps With snippets for Azure Static Web Apps, you can specify code that will be injected into each page of your…

The Ubuntu Summit is Canonical’s annual conference and is a celebration of the latest innovations from the Linux and open-source ecosystem. This year the Ubuntu Summit will take place from November 3-5, 2023 and will be hosted in the beautiful and historic city of Riga, Latvia! Microsoft will be part of Ubuntu Summit 2023 and we’re excited about the opportunity to experience first-hand new cutting-edge technologies and engage with the open-source community. Come join us in-person or online to hear from Microsoft experts discussing a broad range of topics, including Windows Subsystem for Linux (WSL), .NET 8 applications on Ubuntu, and Azure’s integration with Ubuntu…

Welcome to this month’s newsletter. We round up the latest news, product announcements, content and community highlights – in one compact post. View the newsletter archives: This Month In SWA | Azure Static Web Apps Catch the community livestream: https://aka.ms/swa/community/standups Azure Static Web Apps Livestream The Community Standups livestream happens on the last Thursday of each month. Join us for the next one for some interactive demo and discussions. This month we’ll walk through two new features recently added to Static Web Apps, Snippets and Traffic Splitting. Check out for more exciting demos and guests! Community Highlights …

Microsoft Teams Rooms is designed to deliver the most inclusive and collaborative hybrid meeting experience across shared spaces of all sizes. Some organizations opt for a less formal set-up, offering “Bring Your Own Device” (BYOD) spaces, where employees bring their laptops into a room to connect to a display or projector, and, in some cases, a speakerphone and camera. When using these BYOD rooms to attend meetings, users often find themselves wanting a better meeting experience. Customers tell us that they haven’t upgraded these rooms to a full Teams Rooms experience due to prohibitive installation costs and limited budget for new investments. We now have a solution for…

The SQL Server TDS protocol provides two main paths for query execution (Language and RPC events.) You can trace these events using the Batch::Starting/Completed (Language) and RPC:Starting/Completed (RPC) XEvents. Language events are text streams requiring full parsing and may be susceptible to injection attacks. Language events also require educated guesses. For example, should select 1 return a smallint, bigint? Example: SQLExecDirect(“sp_who 50”) SQL Server receives Type=Language Query=”sp_who 50” SQL Server must parse the query, make an educated guess for the data type of 50 and then execute the command. Injection attack exampl…

Our Partner Program has recently added updates spanning topics from AI to cybersecurity, creating new opportunities for inspiration, learning and development. Keep up to date by reading this blog Continue reading...

We continue to expand the Microsoft AppSource ecosystem. For this volume, 217 new offers successfully met the onboarding criteria and went live. See details of the new offers below: Get it now in our marketplace [ATTACH=full]54552[/ATTACH] DocuSign: DocuSign offers seamless integrations with Microsoft 365, Teams, SharePoint, Dynamics 365, and Power Platform to improve customer and employee experiences, lower costs, and do business more quickly and securely. It also provides enhanced methods to identify signers, admin tools for greater security, and round-the-clock activity tracking. With over 400 pre-built integrations, DocuSign automates the entire contract …

What is the connector for Excel? The web connector for Excel (AKA Get Data From Web) is a powerful tool that allows you to connect to websites and import data into your Excel workbook. The Web connector leverages the strength of Power Query in Excel to import data. You can also refresh your data connection to get the latest updates from the selected websites. What's new in the improved connector for Excel? We are excited to announce that we have released an improved web connector for Excel that has new features and enhancements: Suggested Tables: Provides auto-detection of suggested tables, so you can easily structure your data. Add Table Usi…

Background: In the azure portal, we usually manually assign the access control for app service such as storage account, Virtual Machine, Log analytics workspace. However in some scenario, user wants create a container in the storage account and then give the RBAC to other user automatically by logic app. This article is a design to use logic app to give other user RBAC permission via rest API. Design: Step 1: We need to know the role definition Id for the aim RBAC We can using the power shell code in the azure portal to get the role definition id: Open the PowerShell in azure portal:[ATTACH=full]54532[/ATTACH]   Enter 'az' to connect to use az…

Scenario Sometimes we need to use Graph API to upload files, normally the API has limitation in file size for a single request. Since we have to pass binary object in Graph API request body, we need to find a way to split binary object into small pieces and upload it one by one. Mechanism In Logic App, when we print a binary object, it will be converted as base64 string and also we have an expression to convert from base64 to binary (Reference guide for expression functions - Azure Logic Apps). The alternative way is that we can simply use “Substring” expression to take partial of the base64 string and convert it back to binary. As w…