Microsoft Support & Discussions

A few days ago, a customer asked us how they could capture statistics changes that result in a new execution plan, receive a notification when queries have anti-patterns, or changes in automatic SQL Server optimization. Next, I would like to show you some examples. The script is used to create an Extended Event session named "CaptureChangesOnQuery" on a database. This session captures several different events related to automatic tuning, plan regression, settings changes, missing column statistics, query anti-patterns, and SQL statement recompilation. Let's go through each event and its details: This is the definition of Extended Event: CREATE EVENT …

Note: This article applies for configuration of Email notifications with Exchange Online for SCSM2019 only. For SCSM2022 users, we have released a new Hotfix that adds support for Modern Auth. Introduction Microsoft Service Manager (SCSM) uses SMTP server to send notification emails. If the sender mailbox is an Exchange Online mailbox, then you may face some issues because Basic Authentication has been deprecated. Please be informed that SMTP Authentication is still available in Exchange Online (see last section at Deprecation of Basic authentication in Exchange Online). As a solution, SCSM connects to an SMTP server (via Anonymous or Windows authentication) t…

Over 3 million consumers suffered from corporate data breaches in 2023 so far., according to SafeSmartLiving website, tracking major data breach announcements. Now more than ever, it’s important for enterprises to fully understand the risks and consequences of data breaches. This post offers tips and best practices insights into database security hardening of Azure Database for PostgreSQL - Flexible Server, our premium DBaaS PostgreSQL offering in Microsoft Azure. As we look at PostgreSQL Flexible Server, we can review following server components for security hardening opportunities: Physical Security With database servers its critical is to look at how…

Hi! Ready to meet your new best friend? Say hello to GitHub Copilot, the AI pair programmer that's about to change the way you code. It's like having a super-smart friend who's always ready to help. No matter the scenario, writing code, fixing bugs, or just trying to remember that one command you always forget. We've got a brand-new GitHub Copilot Fundamentals Learning Path all about GitHub Copilot. What's a Learning Path, you may ask? Well, it's a sequence of courses that guides you step-by-step to learn new skills and discover the power of Microsoft products. You can find all sorts of Learning Paths on Microsoft Learn. Our new Learning Path is s…

Hey there, MTC’ers! Happy Friday! I’m back with your weekly MTC recap! Took a little time off to focus on some other projects, but that doesn’t mean we didn’t have a LOT going on. So, without further ado, let’s dive in to what’s up and coming! MTC Moments of the Week This was a packed week of events with 2 Ask Microsoft Anything’s (AMA’s) and a new episode of Windows In The Cloud. First up, we had a very special episode of WITC that featured a deep look into Windows 365 Boot and its new features from the IT admin and user perspectives—directly from the creators, including @Elina_Luthra, @Andrew_Miyasato, @AjitSurana, and @rinkustephen. Make sur…

Week 1 of HackTogether: the Microsoft Teams Global Hack – the hackathon where we build apps for Microsoft Teams – is almost over. Here’s what happened and what’s coming. What happened in week 1 of the Microsoft Teams Global Hack? Following our initial keynote, we started this week with a series of live sessions to show you the different types of apps for Microsoft Teams and how to get started building them. June 5, 2023 | Introduction to Teams Tabs and building them with SharePoint Framework The first session was an introduction to Teams Tabs, which are web UI-based apps exposed inside Microsoft Teams. Olivia Guzzardo (Cloud Developer A…

The Trials, Tribulations, and Triumphs of a Power Platform Center of Excellence in the Federal Government Sphere June 21st @ 1pm ET Established in 2020, Transport Canada’s Power Apps Centre of Excellence (PACE) team has been involved in Governance, Professional Development, and Citizen Development. This presentation covers how the CoE came to be, the successes, the struggles, and the lessons learned. Discover the merits, the myths, and the majesty that comprise PACE’s history and how they could inform your own Power Platform strategy. For more about Transport Canada's innovate use of Power Apps and the creation of PACE, check out this short video. …

Today, we are excited to announce a preview of Azure Container Instances (ACI) Spot containers. ACI Spot containers offer an improved pricing plan for ACI by allowing you to take advantage of unused Azure compute capacity at a significantly lower cost. With ACI Spot containers, you can run interruptible, containerized workloads at up-to-70% discounted prices (vs standard containers on ACI) and are billed for per-second memory and core usage like standard ACI containers. ACI Spot containers are well suited to short-lived, containerized workloads that tolerate Azure interruptions. Common scenarios include parallelizable offline workloads such as image rendering, geno…

Since Azure Stack HCI 21H2, customers have used Network ATC to: Reduce host networking deployment time, complexity, and errors Deploy the latest Microsoft validated and supported best practices Ensure configuration consistency across the cluster Eliminate configuration drift Network ATC has led to HUGE reductions in customer support cases which means increased uptime for your business applications and less headaches for you! But what if you already deployed your cluster? How do you take advantage now that you’re travelled through that trepidatious train of thought against taking on new technology? With minimal alliteration, this article will show you ho…

Managing Container images for Private/Restricted Azure Kubernetes Clusters Introduction Recently I am having an increasing number of conversations with customers on how best to manage container images in disconnected or highly restricted environments. Cluster security is becoming increasingly more important, a 2023 report by Red Hat showed that 90% of enterprises surveyed had experienced a security incident in their Kubernetes environments in the last 12 months. There is certainly a trend from customers recently to harden environments making the most of Azure Services such as Azure Firewall to manage egress traffic or Network security groups…

Microsoft.Data.SqlClient 5.2 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two or three preview releases in between. This cadence should provide time for feedback and allow us to deliver features and fixes in a timely manner. This second 5.2 preview includes fixes and changes over the previous preview release. Added Added new property RowsCopied64 to SqlBulkCopy. #2004 Fixed Fixed socket synchronization issue during connect in managed SNI. #1029 Fixed issue with SqlConnectionStringBuilder property indexer no…

TLDR; We have just published the Durable Functions for PowerShell SDK in the PowerShell Gallery. This package contains several improvements, and allows the development of the Durable Functions PowerShell to be de-coupled from the release cycle of the Azure Functions runtime. Try it out by installing `AzureFunctions.PowerShell.Durable.SDK` from the PowerShell Gallery. This is a breaking change release, so make sure to read the “breaking changes” section before upgrading. Durable Functions (DF) makes it easy to implement robust stateful services that make full use of the scaling and billing benefits of serverless, all while using your language of choice: C#, JavaScrip…

In this video Harold Campos, Principal Program Manager for Azure Integration Services is joined by Uli Homann, Distinguished Architect and Corporate Vice President in Cloud and AI at Microsoft Corporation for a discussion about the Cloud Native capabilities that the Azure Cloud has for Mainframe and Midranges via Azure Logic Apps. Mainframe products such as IBM CICS, IMS, MQ, DB2, Informix, VSAM, SNA have been evolving over the last 30-40 years—and so has Microsoft. In 1993 Microsoft released its first product to provide integration with IBM host systems. This product evolved into Host Integration Server, which has been providing core mainframe and midranges integr…

This article is brought to you by the Nonprofit Tech Acceleration (NTA) for Black and African American Communities Program Technical Team. For information on how to take advantage of the granted offerings or free technical consultation, please visit: Supporting Black Community Nonprofits | Microsoft Nonprofits Artificial Intelligence (AI) has emerged as a transformative technology, revolutionizing industries and reshaping the way we interact with various applications and services. Nonprofits are increasingly turning to AI to streamline operations, improve efficiency, and deliver better outcomes. One of the key players in the AI space is Microsoft Azure, a compr…

What is Grounding? Grounding is the process of using large language models (LLMs) with information that is use-case specific, relevant, and not available as part of the LLM's trained knowledge. It is crucial for ensuring the quality, accuracy, and relevance of the generated output. While LLMs come with a vast amount of knowledge already, this knowledge is limited and not tailored to specific use-cases. To obtain accurate and relevant output, we must provide LLMs with the necessary information. In other words, we need to "ground" the models in the context of our specific use-case. Motivation for Grounding The primary motivation for grounding is that LLMs a…

Great overview of Copilot and the exciting features on the horizon for GCCH! Continue reading...

Meillä on ilo kutsua Sinut webinaariimme perjantaina 16.6.2023 klo 10:00-11:00 kuulemaan pilvipalveluiden tietosuojaan liittyvistä viimeisimmistä asioista. Webinaari on tarkoitettu kumppaneiden myynnille, pre-salesille sekä myös johdolle. Pilvipalveluiden tietosuoja puhuttaa edelleen ja asiakkaat lähestyvät kumppaneita erilaisilla kysymyksillä. Haluamme antaa kumppaneille selkeät vastaukset yleisimpiin kysymyksiin ja työkalut hälventämään epätietoisuutta ja vääriä uskomuksia. Webinaarissa selvennämme kertaalleen perusteet, joilla Microsoftin pilvipalvelut täyttävät EU:n vaatimukset jo tänään ja miten Microsoftin pilvipalveluita voidaan käyttää GDPR:n ja muiden EU-s…

Hey all, I'm John 22 years old Senior Computer Engineering student at Modern Academy for Engineering, Full-Stack Developer Nanodegree Session Lead at Udacity, Gold Microsoft Learn Student Ambassador. In this demo, I will guide you through creating a Healthcare chatbot and then how we can deploy it in some very simple steps. Prerequisites: An Azure subscription. If you don’t already have one, you can sign up for an Azure free account. For Students, you can use the free Azure for Students offer which doesn’t require a credit card only your school email. Summary of the steps: Step 1: Open your Azure Portal and Sign in Step 2: Create an Azure Healt…

Last year, we launched the Microsoft Cloud Partner Program – a program with a portfolio of tools, resources, and offerings to help partners meet evolving customer opportunities, innovate for any cloud scenario on an extensible platform, and deliver successful solutions to industries and markets worldwide. We also introduced Solutions Partner designations – each anchored on the Microsoft Cloud in six solution areas: Business Applications, Data & AI (Azure), Digital App & Innovation (Azure), Infrastructure (Azure), Modern Work, and Security – providing a way for partners to demonstrate their proven capabilities and experience across performance, skilling, an…

In this episode with Anna Hoffman and Bob Ward, you will learn the benefits of connecting SQL Server to Azure Arc, including new improvements, new billing options for SQL Server and how you can onboard your SQL Server at scale with minimum effort. Resources: Azure Arc-enabled SQL Server Continue reading...

In this episode with Anna Hoffman and Bob Ward, you will learn the benefits of connecting SQL Server to Azure Arc, including new improvements, new billing options for SQL Server and how you can onboard your SQL Server at scale with minimum effort. Resources: Azure Arc-enabled SQL Server View/share our latest episodes on Microsoft Learn and ! Continue reading...

Table of Contents Abstract Introduction BlueXP backup and recovery BlueXP architecture and configuration BlueXP backup with Azure NetApp Files snapshots BlueXP restore and recovery from Azure NetApp Files snapshot Summary Additional Information Abstract This article and the included demo videos provide an overview of how SAP HANA systems on Azure NetApp Files (ANF) can be protected by using NetApp BlueXP backup and recovery. BlueXP backup and recovery leverages Azure NetApp Files snapshot capabilities and offers end-to-end workflows to execute SAP HANA snapshot-based backup and restore operations. Co-authors: Nils Bau…

Join us on June 20, 2023 to explore the next stage of our vision at Reimagine secure access with Microsoft Entra. During the event, hear from some of our Microsoft Security leaders and experts as they present the next set of innovations from Microsoft Entra. Corporate Vice President, Security, Compliance, Identity, and Management, Vasu Jakkal will kick off the event by introducing Microsoft’s approach to comprehensive security, and how identity serves as organizations’ first line of defense. We will then be joined by Joy Chik, President, Identity and Network Access at Microsoft, who will reveal some exciting product announcements from Microsoft Entra. Th…

Toward the end of May the SQL Tools team released SQL Server Management Studio (SSMS) 19.1, which had many bug fixes as well as new functionality and a couple noteworthy changes. In addition, as users have been upgrading to SSMS 19.x, we’ve heard reports of confusion and misunderstanding related to selected settings. In this series of posts we’ll clarify the impact of changes between 18.12.1 and 19.x, as well as discuss what’s new in 19.1. Dependency Changes SQL Server Management Studio (SSMS), like many other applications, has dependencies on client libraries and drivers. For SSMS, there are three, of which you may or may not be aware: SQL Manageme…

The May webinar covered M365 Search and Search Analytics, Teams Panels, and new and coming GCCH functionality. Teams Panels: Search and Search Analytics: New and Coming Functionality: Continue reading...