Microsoft Support & Discussions

Azure PostgreSQL Flexible Server -February 2023 Feature Summary The Azure PostgreSQL product team is pleased to introduce a new initiative: the monthly product feature summary. This report will showcase the latest updates and new features added to the Azure PostgreSQL Flexible Server over the past month, providing customers, stakeholders, and development teams with a clear overview of the changes and improvements made to the product. Each feature or update will be briefly described, along with its benefits and any relevant documentation. By regularly sharing this information, the product team hopes to build stronger relationships with cu…

Introduction For any database created via Azure Portal, SSMS, ADS or via some automated scripting as a part of company's business requirements, it is frequently seen in large enterprises that there is a need to have a custom LTR (Long-Term Retention) and PITR (Point-in time Restore) policies to be enforced. This is an operational overhead to implement and maintain the business requirements for each and every database creation, which is currently missing as part of Azure SQL Managed instance database creation. Though, Azure SQL PaaS allows these LTR/PITR to be applied as per choice, however, we have seen customers looking for some sort of automated or buil…

PgBadger is one of the most comprehensive Postgres troubleshooting tools available. It allows users to have insight into a wide variety of events happening in the database including: (Vacuums tab) Autovacuum actions - how many ANALYZE and VACUUM actions were triggered by autovacuum daemon including number of tuples and pages removed per table. (Temp Files tab) Distribution of temporary files and their sizes, queries that generated temporary files. (Locks tab) type of locks in the system, most frequent waiting queries, queries that waited the most; unfortunately, there is no information provided which query is holding the lock, only the queries that are locked ar…

As a follow-up to my previous blog, we have now uploaded the following script examples to our open-source GitHub repository: Collect SCCM Device Logs Intune Delete Objects Intune Device Retire Intune Device Wipe Intune Provision W32 Apps Intune Remove Assignment Intune Verify Deleted Objects These example scripts were originally created for use inside of Microsoft. We have modified it to be more generic, so it can be used as a template for other Intune environments outside of Microsoft. For some ideas on how to create some end-to-end automation that can utilize these examples, you can refer to another previous blog I posted about how we build a…

At Microsoft, we love to hear your voice! The Synapse community asked for SqlPackage’s long-awaited support for Azure Synapse Analytics Serverless SQL Pools, and we delivered! Now you can automate the deployment of your Synapse serverless SQL objects along with your Synapse dedicated SQL objects! SqlPackage release 161.8089.0, dated February 13, 2023, brings a new feature: support for Synapse serverless SQL pools. According to the release notes, you can use SqlPackage to extract and publish both external and internal objects from serverless SQL pools. This includes the T-SQL surface area of serverless SQL pools is limited by design to external tables, external view…

For deploying workflows across different environments, one of the important activities is to parameterize the API connections. With the latest update of the logic apps extension (starting on version 1.0.40) parametrization of the Logic Apps Standard apps becomes easier, as now both runtime and designer support the interpolation of app settings or parameter references. More details on this concept are explained in the blog- Parameterizing Managed Connections with Logic Apps Standard - Microsoft Community Hub In this article, we will walk through the process of parameterizing different connection types. In this example, we are using: A managed API connection …

My name is Rachel Irabor, I am a Microsoft Learn Student Ambassadors and Power Platform developer. I love writing blog posts to document my learning. In this blog post, I will show you how to create a table in Microsoft Dataverse and a Sign in screen in Canvas Power Apps using the table in Microsoft Dataverse as a data store for username and password/ Throughout the sign-in screen, we will work on making the screen user-friendly. This blog will guide you through how to build a sign-in screen in Microsoft Power Apps using Microsoft Dataverse. The Step by step process Step 1: Sign into your Microsoft Power Apps Account At the left-hand side of the s…

Authors: Amirreza Rastegari, Jon Shelley Simcenter STAR-CCM+ is one of the most widely used computational fluid dynamics (CFD) simulation applications by high performance computing (HPC) customers in a variety of research and commercial fields. Over the past 5 years, our partnership has been focused on delivering great CFD performance in Azure. Recently, we evaluated Simcenter STAR-CCM+ across our HB series virtual machines (VMs) to see how the HBv3 VMs compares to the previous generations in terms of cost[1], performance, and scalability. The Azure HB series currently includes HBv3, HBv2 and HB VMs, with their technical features summarized in table 1: …

Hello! This is Jessev from the Directory Services team with some advice on how to deal with an annoyance created by the print spooler service. We, on the Direcory Service team, tend to see this issue more so than our User Experience team, who handles printer issues. The term “Print Nightmare” is related to the security vulnerability fixed in the July 6 2021 (7B.21) update. What is described in this blog post is a situation that can develop as a result of the fix for the so-called Print Nightmare vulnerability. KB5005010: Restricting installation of new printer drivers after applying the July 6, 2021 updates - Microsoft Support Common symptoms are, slow or…

Don't you wish you could take a snack break while the job would just do itself? With Windows Autopilot you can! Brush up on how you can pre-configure new devices or reset and repurpose existing devices with this automated cloud service. Time to learn: 91 minutes [attachment=33984:name]WATCH Windows Autopilot | How It Works & How to Set It Up Set yourself up for success with Windows Autopilot. Start with enrollment options and a benefit analysis, followed by admin setup, settings, and tips for success. (9 mins) Intune + Azure AD + AADJ + Self-Enrolled + Apps + Policies + Profile + Hardware ID + Pre-Provisioning [attachment=33985:name]…

Azure Web Application Firewall (Azure WAF) detects SQLI attacks and applies block mitigations by default. In certain instances, this could be a false positive that requires investigation and creation of Azure WAF exclusions. In order to complete a successful investigation, full context about the attack is needed and a process that guides you through the investigation is required. Such a guided investigation process is automated in this Microsoft Sentinel Notebook and allows you to tune Azure WAF policy with minimal user interaction. This Notebook analyzes SQL injection attacks on Azure WAF integrated with Azure Front Door premium and implements automated exclusions. …

Join us for Azure Communication Services and Microsoft Teams “Ask Microsoft Anything” on March 8 from 9:00 to 10:00 AM PST. This live online event will provide you with the opportunity to connect with Microsoft product managers from Azure Communication Services. During the event, you'll chat with product managers from Azure Communication Services to ask questions and share your ideas, concerns, and feedback about the possibilities of connecting Azure Communication Service with Microsoft Teams. This Ask Me Anything will be text-only, meaning there will not be any video or audio. Feel free to add your questions as comments beforehand on the events page. We can't…

Today, we are excited to share that Dark Mode is now available in the Azure Data Factory Studio! As we spend more time on our screens, it has become increasingly important to make accommodations for light sensitivity and help reduce eye strain. With the availability of themes, ADF now offers a new dark color scheme for the data factory studio to help improve productivity. How to enable the Dark theme in ADF To enable Dark Theme in ADF, start by navigating to Settings. Opening Settings will bring up a panel with the settings that you can configure for your data factory. Under Theme, you will see an option to switch between…

There are three best practices you should know when working in data in Power BI. Learn about them with Anna Hoffman, and stars of Guy in a Cube, Adam Saxton and Patrick LeBlanc, this week on Data Exposed. Resources: Query folding - Power Query Understand star schema and the importance for Power BI Consolidating report elements for improved performance View/share our latest episodes on Microsoft Learn and ! Continue reading...

Now that I’ve finally had opportunity to work on a notification service for the front-end, I wanted to share with everyone. This service was originally something that I piloted in my team’s project, Fast Pass, that was created to demonstrate how Text Analytics for Health can be used to extract medical information from physical patient documents to persist to an EMR. However, I recently improved it to a level of satisfaction worthy of sharing in an older project, FhirBlaze, which we recently updated with OpenAI to generate FHIR queries. Prerequisites A Blazor Project Why Nearly every application that involves activity with users is one where you want to pres…

In today’s complex and dynamic IT landscape, managing your compute across hybrid, multicloud, and edge workloads is a critical challenge. You need to have a clear and comprehensive view of your IT assets across all platforms and locations. Moreover, you need to know where they are located, how they are configured, and ensure that your resources are compliant with your policies and standards. Azure Arc affords customers the ability to extend Azure services spanning security, monitoring, and governance, this is powered by extending the Azure management plane. Every Arc-enabled resource is associated with an ARM representation. What you might not know is that extendin…

In a game-changer for the energy industry, actors including vendors, grid operators, and digital solution providers are joining forces to pilot digital twin solutions that can help accelerate the energy transition. Data from the grid is often inaccessible, lacks context, and is isolated in siloed systems. For Distribution System Operators (DSOs), a digital representation of a physical grid system unlocks the ability to make data available and leverage it for increased energy efficiency and early risk mitigation. With the addition of Internet of Things (IoT) devices, information such as sensor readings, status updates, and performance metrics can be integrated into …

Expect your apps to work on Windows 11. If you still need extra reassurance, test only your most critical apps with Test Base for Microsoft 365. This efficient and cost-effective testing service is available today to all IT pros, along with developers and independent software vendors. We hope you're already experiencing the safer, smoother, and more collaborative work environment with the new Windows 11 features. We're also here to help you ensure business continuity by maintaining high application compatibility rates and supporting you in testing the mission-critical applications that you manage. Many of you have traditional (read legacy) testing systems that are prov…

Don't you wish you could take a snack break while the job would just do itself? With Windows Autopilot you can! Brush up on how you can pre-configure new devices or reset and repurpose existing devices with this automated cloud service. Time to learn: 91 minutes [attachment=33960:name]WATCH Windows Autopilot | How It Works & How to Set It Up Set yourself up for success with Windows Autopilot. Start with enrollment options and a benefit analysis, followed by admin setup, settings, and tips for success. (9 mins) Intune + Azure AD + AADJ + Self-Enrolled + Apps + Policies + Profile + Hardware ID + Pre-Provisioning [attachment=33961:name]…

Expect your apps to work on Windows 11. If you still need extra reassurance, test only your most critical apps with Test Base for Microsoft 365. This efficient and cost-effective testing service is available today to all IT pros, along with developers and independent software vendors. We hope you're already experiencing the safer, smoother, and more collaborative work environment with the new Windows 11 features. We're also here to help you ensure business continuity by maintaining high application compatibility rates and supporting you in testing the mission-critical applications that you manage. Many of you have traditional (read legacy) testing systems that are prov…

We continue to expand the Azure Marketplace ecosystem. For this volume, 129 new offers successfully met the onboarding criteria and went live. See details of the new offers below: Get it now in our marketplace [attachment=33873:name] aaPanel Secured and Supported by HOSSTED: aaPanel is a free, open-source hosting project that lets you deploy and manage websites, manage databases and files, and more. This secure image provided by HOSSTED comes with documentation and recommendations, as well as reliable support. [attachment=33874:name] Alpine Linux on Azure: Alpine Linux is a lightweight, secure distribution for resource-constrained environments,…

MidDay Café is returning with weekly podcasts starting Monday 3/6 here at Healthcare and Life Sciences Blog Each week we will cover a Microsoft Viva topic. The first 6 podcasts will dive into the Viva product set starting with an overview of the Viva suite as it stands today and then diving into the Viva aspects of Home, Connection, Insight, Purpose, and Growth. Following this initial 6 podcast focus we will then cover Viva updates, announcements, use cases, tips and tricks, and more. Initial MidDay Café schedule: Monday 3/6: Microsoft Viva Suite - The Employee Experience that delivers more... for less. Monday 3/13: Microsoft Viva Connections Home - The entry poin…

Many of our customers have been asking about creating a disaster recovery plan for their Synapse Workspace. In a new blog series, we will cover the basics of disaster recovery and business continuity, discussing available options and custom solutions. In this first post, we'll review important concepts and questions to answer before building a disaster recovery plan, including the differences between High Availability and Disaster Recovery. High Availability High availability (HA) refers to a system's ability to operate continuously without failing for a specified time. While it's impossible to achieve 100% availability, system or application design sho…

Author(s): Arun Sethia is a Program Manager in Azure Synapse Customer Success Engineering (CSE) team. Introduction In this blog post, we will cover how to test and create unit test cases for Spark jobs developed using Synapse Notebook. This is an extension of my previous blog, Synapse - Choosing Between Spark Notebook vs Spark Job Definition, where we discussed selecting between Spark Notebook and Spark Job Definition. Unit testing is an automated approach that developers use to test individual self-contained code units. By verifying code behavior early, it helps to streamline coding practices for larger systems. For spark job definition developer usua…