Microsoft Purview DevOps policies now includes all the typical permissions for SQL support personnel

Microsoft Purview DevOps policies now includes all the typical permissions for SQL support personnel

This article is contributed. See the original author and article here.

IT/DevOps personnel need access to database and system metadata so that they can keep critical database systems healthy, performing to expectations and secure. Microsoft Purview DevOps policies, a subset of Microsoft Purview access policies, are specifically designed to provide IT/DevOps personnel with the access they need so that they perform their crucial job, while at the same time helping reduce the insider threat.


 


Microsoft Purview DevOps policies is a central, cloud-based experience. This is what the experience looks like:


 


Figure 1: Screenshot of DevOps policiesFigure 1: Screenshot of DevOps policies


 


In prior blogs, we announced the launch into General Availability (GA) of Microsoft Purview DevOps policies, first for SQL Server 2022, and subsequently for Azure SQL Database. Today, we are pleased to introduce the expansion of permissions related to role “SQL Performance Monitor”. This is one of two roles that can be provisioned as part of the Microsoft Purview DevOps policies.


 


Up to this point, this role gave a user (or group) access to hundreds to DMVs/DMFs. These DMVs/DMFs allow the user to review system parameters, identify performance bottlenecks, currently running queries, blocking issues, memory usage, file and index usage, active user connections, internal tasks, procedure execution stats and use of the Query Store, among others.


 


With the expansion, Microsoft Purview can now be used to grant access to all the typical commands that a persona tasked with performance monitoring and analysis requires.  The additional permission assignments enable the user (or group) that is assigned role SQL Performance Monitor to see data from most catalog views, which contain information about user objects and configurations. Furthermore, the user will now be able to run several DBCC commands that are used for system analysis and can even create and change Extended Event-sessions for system tracing for deeper analysis.


 


This capability will be rolled-out to all Azure regions that support Azure SQL and Microsoft Purview over the next few weeks.


 


Role definition detail


The following table lists the actions that are now part of the role definition for SQL Performance Monitor. The first four (in blue) were already part of the role and the ones that follow were recently added.


 
























































































































Microsoft Purview policy role definition



Data source specific actions


   

SQL Performance Monitor



Microsoft.Sql/Sqlservers/Connect


 

Microsoft.Sql/Sqlservers/Databases/Connect


 

Microsoft.Sql/Sqlservers/Databases/SystemViewsAndFunctions/DatabasePerformanceState/Rows/Select


 

Microsoft.Sql/Sqlservers/SystemViewsAndFunctions/ServerPerformanceState/Rows/Select


 

Microsoft.Sql/Sqlservers/Databases/SystemViewsAndFunctions/DatabaseGeneralMetadata/Rows/Select


 

Microsoft.Sql/Sqlservers/SystemViewsAndFunctions/ServerGeneralMetadata/Rows/Select


 

Microsoft.Sql/Sqlservers/Databases/DBCCs/ViewDatabasePerformanceState/Execute


 

Microsoft.Sql/Sqlservers/DBCCs/ViewServerPerformanceState/Execute


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Create


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Options/Alter


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Events/Add


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Events/Drop


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/State/Enable


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/State/Disable


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Drop


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Target/Add


 

Microsoft.Sql/Sqlservers/Databases/ExtendedEventSessions/Target/Drop


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Create


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Options/Alter


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Events/Add


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Events/Drop


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/State/Enable


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/State/Disable


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Drop


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Target/Add


 

Microsoft.Sql/Sqlservers/ExtendedEventSessions/Target/Drop



 


Conclusion


With that, we expect the SQL Performance Monitor role to cover all the typical scenarios where you need to provision access for dedicated support personnel to Azure SQL or SQL Server 2022 (Azure Arc-enabled), all from a simple, central and scalable experience.


 


Of course. we are always interested in which other scenarios you would like to see enabled via Microsoft Purview.


 


Recommended next steps



 

Create and manage cases efficiently with enhanced case forms 

Create and manage cases efficiently with enhanced case forms 

This article is contributed. See the original author and article here.

Customer service agents in a digital contact center handle multiple customer queries simultaneously and work on several support requests in a day. Often, they might spend extra time creating support cases, catching up on past activities, or performing simple case management processes. This leaves them with less time to focus on customer queries, which affects customer satisfaction. Enhanced case forms in Dynamics 365 Customer Service provide a streamlined layout to help agents expedite the case creation process and find relevant information quickly.  

With enhanced case forms, agents spend less time creating a case or finding required information and more time helping customers. As a result, agents reduce case handling time, improve productivity, and drive better customer satisfaction.   

To ensure agents can create cases quickly, Dynamics 365 Customer Service offers enhanced case forms. These forms allow agents to take quick notes before saving a case, add multiple attachments directly on the case, and access color coded priority and case status fields.   

Enhanced quick case forms

The Enhanced quick case form in the side pane helps agents enrich the case with the relevant information, while keeping sight of the customer’s details, past cases, and previous interactions. They can verify and edit customer details without switching tabs, provide updates on existing cases without interrupting case creation flow, and avoid case duplication. Moreover, auto-filling case fields with an AI-generated conversation summary reduces agents’ manual efforts and saves time. 

Enhanced full case forms

The Enhanced full case form offers a single-tab experience for simplified data entry while creating a case. Additionally, agents can enter formatted content on the Description field, including images and files. Agents can edit the customer details inline and view recent cases in context of the identified customer. This eliminates the need for screen navigation and reduces multiple clicks.

Enhanced full case form in Customer Service workspace with attachments and notes

After saving a case, agents can use the SLA timer to identify overdue activities and take action to meet their deadlines. The SLA timer is available by default on the form. Agents can view the queue the case has been added to and modify the details with minimum clicks. Also, they can access all attachments associated with a case with the ability to preview and download them. Finally, they can access knowledge articles and similar cases linked to the case without switching tabs on the form. 

Enhanced full case form in Customer Service workspace with timeline

Administrators can enable enhanced case forms for agents to use in the Customer Service workspace application. However, enhanced forms along with individual controls can be used in other applications using Power Apps maker portal.

Learn more

Watch a quick video introduction.

To find out more about enhanced case forms, read the documentation: Use enhanced case forms to manage cases

The post Create and manage cases efficiently with enhanced case forms  appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

New API for Distributed Order Management fulfillment optimization

New API for Distributed Order Management fulfillment optimization

This article is contributed. See the original author and article here.

Introduction

From same-day delivery to social commerce and self-service solutions, the modern-day supply chain is pushing retailers to keep pace with consumer expectations for near-instantaneous, omnichannel service. With Microsoft Dynamics 365 Intelligent Order Management, retailers can offer customers the best shipping and fulfillment options in real-time. Now, with the new Distributed Order Management (DOM) API, you can take advantage of the core capabilities of Intelligent Order Management well in advance of order orchestration in a platform-agnostic way.

What capabilities does the DOM API unlock? 

  • Call the DOM API from any platform. Get the fulfillment source and shipping options for an order or cart items in real-time by making a call to the DOM API from any e-commerce, ERP, or marketplace platform. Configure the rules in your fulfilment optimization settings in Intelligent Order Management so that the API can search your stores and warehouses.
  • Get shipping rates and estimated delivery dates. The DOM API can call your shipping carrier’s APIs to get the rate and estimated delivery dates for the items in an order or cart. The API can even exclude any items eligible for free shipping when calling the APIs for shipping rates.
  • Use the working calendar to optimize order routing. With the introduction of the working calendar in Intelligent Order Management, you can establish working days and holidays for each of your fulfilment sources. Turn on the constraint “Respect warehouse timings” in your fulfilment optimization settings to route your orders only to the fulfilment sources that are working on the day or time of the request. 
  • Use the carrier pickup schedule to send accurate pickup times to the carrier. With the introduction of the carrier pickup schedule in Intelligent Order Management, you can maintain up to five pickup slots for your shipping carriers. The API checks the schedule to send an accurate pickup slot to the carrier’s API to return the estimated delivery date.

Example request using the new Distributed Order Management API

Here’s an example of an API call to the FedEx API:


{{Dataverse URL}}/api/data/v9.2/msdyn_IomDomAPI 
apiVersion: 1.0 (string - mandatory)
payload:
{
"fnoCompanyId": "USMF",
"orderId": "b16bd573-ad9a-4188-bc08-e5ac5eca776e",
"strategyId": null,
"carrier": "fedex",
"salesOrderOrigin": null,
"customerInformation": {
"name": "Whole sales",
"customerNumber": "US-001",
"customerGroup": "10",
"customerEmail": "test@microsoft.com"
},
"orderDestinationAddress": {
"addressType": "Residence",
"address1": "537 N St. Francis",
"address2": null,
"address3": null,
"city": "Wichita",
"stateOrProvince": "KS",
"postalCode": "67214",
"phoneNumber": null,
"country": "US"
},
"lineItems": [
{
"lineId": "d5670621-910d-486b-90ca-61d739e9a92e",
"itemId": "1000",
"quantity": 2,
"freeShipping": "No"
},
{
"lineId": "5c8b423b-c9fe-4ff1-a16e-a75a35d7c424",
"itemId": "T0001",
"quantity": 2,
"freeShipping": "Yes",
"dimensions": {
"sizeId": "10"
}
},
{
"lineId": "a359a0ec-cded-4eda-b7b0-d7478dff48b9",
"itemId": "T0004",
"quantity": 2,
"freeShipping": "Yes",
"dimensions": {
"colorId": "black"
}
}
]
}

Watch Intelligent Order Management orchestrate an e-commerce order fulfilled by Dynamics 365 Commerce

Here’s a sample flow that illustrates the journey:

  • Call the DOM API from the e-commerce checkout flow to get shipping and fulfillment options powered by the real-time inventory visibility service and the FedEx carrier.
  • Create a sales order by building a custom order intake provider and orchestrate the order.
  • Synchronize the sales order through a custom Dynamics 365 cloud scale unit (CSU) provider.
  • Fulfil the sales order through Dynamics 365 point of sale.
  • View the order’s status through the Intelligent Order Management state framework in real-time as the retail store processes the order.
  • Call the shipping label API from the point of sale to print a FedEx shipping label at the store.
  • Trigger notifications to the customer as the order ships from the store through the Narvar provider in Intelligent Order Management.
  • View the last mile status of the shipment in the Intelligent Order Management fulfilment tracking entity as FedEx delivers the package.

Sample Illustration of a flow

Learn more

Read how one customer is partnering with Microsoft to transform their e-commerce experience, providing shorter lead times and reducing shipping costs.

Read the documentation:

Not a Dynamics 365 Intelligent Order Management customer yet?

Take a tour and get a free trial.

The post New API for Distributed Order Management fulfillment optimization appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Improve operations with real-time analytics in Dynamics 365 Customer Service

Improve operations with real-time analytics in Dynamics 365 Customer Service

This article is contributed. See the original author and article here.

In today’s fast-paced business environment, contact centers need real-time analytics to provide top-notch customer support under pressure. One of the biggest challenges contact center managers face is the ability to react quickly to unexpected events. These events may include spikes in the volume of incoming customer interactions, longer call lengths, and agent absences.

To address these challenges, we are excited to introduce Dynamics 365 Customer Service real-time analytics for omnichannel. This powerful tool provides contact center managers with real-time visibility into overall support performance. They can monitor key operational metrics, make course corrections at the right time, and keep service levels high. 

Monitor customer interactions with real-time analytics

Contact centers need to manage multiple channels, including voice, chat, and social media. With real-time analytics, supervisors can monitor the volume of interactions and wait times across all channels in real-time, providing them with the information they need to make informed decisions. The auto-refresh capability ensures that supervisors have up-to-date information at their fingertips.

Summary of real-time omnichannel analytics in Customer Service workspace

Maximize agent utilization

Agent allocation is crucial in managing customer interactions efficiently. With real-time analytics, supervisors can track the current available capacity of agents and monitor what each agent is currently working on. Supervisors can drill down and see detailed metrics for each agent. As a result, this capability helps supervisors make informed decisions about how to allocate resources, ensuring that the right agents are handling the right interactions at the right time.

Agent tab of omnichannel real-time analytics in Customer Service workspace

Proactively monitor customer-agent interactions

Customer sentiment is a crucial factor in providing high-quality service. With the ongoing conversation report, supervisors can proactively monitor customer-agent interactions using real-time sentiment signals. This allows them to identify any issues in real time and provide immediate guidance to agents. Contact center supervisors can ensure that agents are providing the best possible service, resulting in improved customer satisfaction.

Ongoing conversation tab of real-time omnichannel analytics in Customer Service workspace

Take immediate actions

Contact center managers often need to perform actions such as overriding agent status or assigning customer interactions to agents when they experience sudden spike in volume. With real-time analytics, supervisors can do the following:

  • Assign, transfer and force close actions directly from ongoing conversation report. 
  • Override agent status to route the customer conversation to the agents. 

Agent status drop down menu with agent set to available

Customize Reports

Analyzing data is essential in identifying areas for improvement. With Dynamics 365 Customer Service real-time analytics for omnichannel, supervisors can pause and resume data refresh to analyze the data at their own pace. Additionally, they can personalize out-of-the-box reports by saving filters, allowing them to focus on the data that is most relevant to them, and gain actionable insights.

Try real-time analytics for omnichannel today

Dynamics 365 Customer Service real-time analytics for omnichannel empowers contact center managers with real-time visibility into support performance, so they can make data-driven decisions and ensure high-quality customer service. With its powerful features such as real-time monitoring, agent utilization tracking, proactive monitoring of customer-agent interactions and customizable reporting, contact centers can effectively address unexpected events, optimize resources, and enhance overall customer experience. Enable Dynamics 365 Customer Service real-time analytics for omnichannel and stay ahead of the game in today’s fast-paced business environment.  

Learn more

Watch a quick video introduction.

To find out more about real-time analytics for omnichannel, read the documentation:

The post Improve operations with real-time analytics in Dynamics 365 Customer Service appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Windows client roadmap update

Windows client roadmap update

This article is contributed. See the original author and article here.

We realize that a clear Windows client roadmap update helps consumers and organizations with planning their Windows release activities.


Today we’ll provide a brief update on the latest version of Windows 10, as well as share more on the time frame for the next Long-Term Servicing Channel (LTSC) release of Windows 11.


Windows 10 support lifecycle


As documented on the Windows 10 Enterprise and Education and Windows 10 Home and Pro lifecycle pages, Windows 10 will reach end of support on October 14, 2025. The current version, 22H2, will be the final version of Windows 10, and all editions will remain in support with monthly security update releases though that date. Existing LTSC releases will continue to receive updates beyond that date based on their specific lifecycles.


Recommendation



  • We highly encourage you to transition to Windows 11 now as there won’t be any additional Windows 10 feature updates.

  • If you and/or your organization must remain on Windows 10 for now, please update to Windows 10, version 22H2 to continue receiving monthly security update releases through October 14, 2025. See how you can quickly do this via a servicing enablement package in How to get the Windows 10 2022 Update.


The final end of support date for Windows 10 does not change with this announcement; these dates can be found on the Windows 10 Lifecycle page.


Windows 11 LTSC


It’s important for organizations to have adequate time to plan for adopting Windows 11. Today we’re announcing that the next Windows LTSC releases will be available in the second half of 2024:



  • Windows 11 Enterprise LTSC

  • Windows 11 IoT Enterprise LTSC


We’ll provide more details as we get closer to availability.


Recommendation


If you’re waiting for a Windows 11 LTSC release, you can begin planning and testing your applications and hardware on the current GA channel release, Windows 11, version 22H2. Check out App confidence: Optimize app validation with Test Base for more tips on how to test your applications.


Stay informed


In the future, we will add more information here and to the Windows release health page, which offers information about the General Availability Channel and LTSC under release information for appropriate versions.


The Windows release health page lists release information for different versions of Windows.The Windows release health page lists release information for different versions of Windows.




Continue the conversation. Find best practices. Bookmark the Windows Tech Community and follow us @MSWindowsITPro on Twitter. Looking for support? Visit Windows on Microsoft Q&A.