This article is contributed. See the original author and article here.
Moved from: bobsql.com
Download attachment to read the full content.
SQL Server uses 3 types of affinity to control where the SQL Server worker threads execute. Before explaining the different scheduler affinity types let me clarify some terminology.
Node Types
SQL Server makes a specific distinction between scheduling and memory nodes.
Scheduling nodes: sys.dm_os_nodes
Memory nodes: sys.dm_os_memory_nodes
A scheduling node is a used to group a set of SQLOS schedulers. The scheduling node must :
Remain within a single memory node.
Can be configured to use a subset of the CPUs presented by the OS from the same memory node.
For example: A memory node with 64 CPUs is a complete, Operating System, scheduler group. SQL Server may choose to divide the memory node allowing for better partitioning and performance. The Soft Numa feature may take the 64 CPUs and create 8 scheduler nodes, each managing 8 CPUs or 4 scheduler nodes managing 16 CPUs, etc. The decision is performance driven.
A memory node represents the memory associated with a group of CPUs from the physical hardware. SQL Server aligns schedulers and other partitioned structures with the memory node to reduce access to remote, NUMA node memory when possible. A memory node may have 1 or more scheduling nodes, but a scheduling node can only be assigned to a single memory node.
This article is contributed. See the original author and article here.
Many organizations want to provide Microsoft Teams to their employees, but not in a “no strings attached” way. With our customers, we often see the need for a provisioning solution, so people aren’t creating teams without thinking.
With “traditional” team creation (i.e. the built-in “Create a team” functionality) a lot of the teams that get created don’t leverage the full potential that Microsoft Teams has to offer. When a team is created as a blank slate the owner has to know what the possibilities are and how to set it up, to create a team fit for their need. On the other hand, templates don’t satisfy users’ needs either. There is no such thing as “one size fits all”. Again, to modify it, the user needs to have a certain level of knowledge.
A different approach
To tackle these two challenges when it comes to Microsoft Teams provisioning, we had a vision of a provisioning solution where we blend learning with the process of creating your team. We provide the why, the user decides the what, and the tool takes care of the how. This is how ProvisionGenie ? was born.
ProvisionGenie is a tool that guides the user through the creation process. Someone who desires a team can start up the application from inside Microsoft Teams, so they stay in the flow of their work. They will need to provide some basic information such as the name, description, and members of the team. Then the tool continues with some of the essential building blocks of a great Microsoft Teams team: channels, lists and libraries. The user gets information on why they would care about these things, and they can customize them to their liking.
An enterprise-ready solution
ProvisionGenie is built with companies in mind: a scalable database, a reliable workflow engine and a Teams-like user interface.
The data is stored in Microsoft Dataverse, the relational database built into the Power Platform that allows for advanced security scenarios. In the current version, we focus on the front-end for the users of the application. By storing our data in Dataverse however, we can expand this relatively easily in the future with a model-driven application for administrators.
Azure Logic Apps take care of the workflows and logic of creating the team with its resources. Logic Apps not only offer better permission management, they can also be deployed across tenants automatically. They are more scalable and therefore performant compared to their low-code counterpart Power Automate.
Finally, a Power Apps canvas app is used to create a beautiful user interface that fits seamlessly into Microsoft Teams. With a canvas app, there is full control over the look and feel of the UI. The canvas app provides the different options to the user and saves the configuration in Dataverse. There is no direct link between the canvas app and the Logic Apps.
A community driven initiative
ProvisionGenie was born out of the collaboration of two community members because we wanted to provide a different solution for Microsoft Teams provisioning.
We decided quite early in the process that we wanted this to be a solution for the community, by the community. Therefore, this is an open-source project which you can find on GitHub (<<link>>) and to which everyone is welcome to contribute.
Bios
Carmen Ysewijn Power Platform Architect | Microsoft Business Applications MVP Carmen is a Business Applications MVP and Power Platform Architect at Qubix (Belgium) with a passion to find the right solution for any challenge that arises. With this solution-oriented approach, she helps customers improve their business processes. She loves to share the knowledge she gains along the way on her blog or speaking at conferences.
Luise Freese Microsoft MVP, Microsoft 365 Consultant, Power Platform Developer
Luise helps customers around the globe to improve their business processes and to get rid of everything that only keeps them busy without adding value in a meaningful way. She is a member of the M365 PnP team and supports developers in extending Microsoft 365. She loves all things community, open-source, stickers, and the number 42.
To write your own blog on a topic of interest as a guest blogger in the Microsoft Teams Community, please submit your idea here: https://aka.ms/TeamsCommunityBlogger
This article is contributed. See the original author and article here.
The pandemic has fundamentally changed how people value where they work, how they work, and most importantly—why they work. One year ago today, we announced Microsoft Viva to help accelerate this transformation.
This article is contributed. See the original author and article here.
CISA has added one new vulnerability to its Known Exploited Vulnerabilities Catalog, based on evidence that threat actors are actively exploiting the vulnerabilities listed in the table below. These types of vulnerabilities are a frequent attack vector for malicious cyber actors of all types and pose significant risk to the federal enterprise.
CVE Number
CVE Title
Required Action Due Date
CVE-2022-21882
Microsoft Win32k Privilege Escalation Vulnerability
Although BOD 22-01 only applies to FCEB agencies, CISA strongly urges all organizations to reduce their exposure to cyberattacks by prioritizing timely remediation of Catalog vulnerabilities as part of their vulnerability management practice. CISA will continue to add vulnerabilities to the Catalog that meet the meet the specified criteria.
This article is contributed. See the original author and article here.
Overview
Charting in Excel has long been an important tool our customers use to explore, analyze, and tell stories about their data. Until a few years ago however, Excel for the Web primarily served as consumption-based companion app to our desktop versions – this meant that users were limited in their ability to create and edit charts on the web. As part of the broader effort to evolve Excel for the Web, the team has been working hard to elevate the charting experience and is excited to share several major improvements we have made over the last couple years that are available to all free and paid customers. In this blog post, we’ll cover some of the most significant upgrades we’ve made, which provide users with a more robust chart editing experience.
The Format Pane and On-Chart Interactions
You can now leverage the format task pane and on-chart interactions to format charts on the web. The format pane provides formatting support for critical chart properties (axes, legend, data series, etc.) and makes it easy to view and navigate to each editable chart element. You are now able to make property edits to elements of a chart such as the fill/outline color, number format, axis bounds, and more.
You can now also directly select the individual elements within a chart to launch and navigate to their respective formatting options in the format pane. Previously, users could only select the entire chart but not any contents within the chart.
To explore these new capabilities, launch the task pane by double-clicking anywhere on the chart or by right-clicking and selecting “Format”. From there, you can view each chart element’s formatting options by either selecting an element within the chart or expanding the options in the format pane.
Launch and navigate the Chart Format Pane by directly interacting with chart elements
Support for Adding & Removing Chart Elements
You can now also add and remove chart elements without having to leave the format pane. Users can leverage the new on/off toggles in the pane to choose whether to include a chart element in the chart. Alternatively, you can use the delete/backspace keys to remove a chart element that is selected. We have also added support for adding/removing trendlines and error bars.
Use the Chart Format Pane’s toggles to add/remove chart elements from your chart
Other Improvements
You can now select data from non-adjacent rows to create a chart. Previously, users were limited to creating charts from a continuous range of cells.
You can now freely change between all different chart types. Previously, some chart type changes were not supported.
We have also added undo/redo support for all chart commands and enabled sheet duplication for worksheets containing any chart type.
Stay tuned as we continue to improve Excel’s web charting experience – we’ll be sharing more updates as new features become available!
Your feedback is important for us! Tell us what you think about these improvements to the charting experience in Excel for the web by writing a comment on this blog post or Send us a smile or frown. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
This article is contributed. See the original author and article here.
If sales were simple, then every seller and every sales organization would be successful. But there’s more to it, especially in the current landscape.
We’re seeing a fundamental shift in the way customers want to engageinstead of relying only on direct contact with sellers, customers more frequently use digital channels to get answers to questions and even to make purchasing decisions. The seller is moving from guiding every step of the sales process to being a trusted advisor. To fill this role, sellers must regroup and look for other ways to make a difference to their customers.
One way is through understanding the complete 360-degree view of the customer. The seller is not limited to just information from their sales force automation system, but can use data and insights on customers from across the organization. A 360-degree view provides a way to maximize the limited time a seller has with a customer and to engage them in a personalized, relevant conversation for a greater chance of success. But sellers today are suffering with digital overload from disparate systems that draw focus and time away from their customer engagements. How do we help sellers focus on actions that accelerate revenue?
The cutting-edge AI and collaborative capabilities of Microsoft Dynamics 365 Sales take the 360-degree view of the customer and give sellers the power to focus on the highest priority activity that has the best chance of moving the opportunity forward. Sellers can learn from customer history, access information from external data sources, and get next best actions to takeall within one tool, all within the sellers’ control.
And now, four AI-powered and collaborative digital selling capabilities, previously available only to Dynamics 365 Sales Premium customers, are available for all Dynamics 365 Sales Enterprise customers. You can now use these capabilities in your current environment, with your data and in real sales calls, transforming how your sellers engage with customers.
Digital selling capabilities in action:
This embed requires accepting cookies from the embed’s site to view the embed. Activate the link to accept cookies and view the embedded content.
The AI capabilities in Dynamics 365 Sales are a seller’s superpower. Sellers see, and can act on, suggested actions and collaborate with colleagues all within their flow of work. AI assists in that flow of work, identifying and suggesting actions, but the seller is in control on what to do next.
AI recommendations aren’t just in the context of working on an active deal. Sellers and managers can be proactive and drive successful deal closures with prioritized AI driven recommendations on at-risk or stalled deals. Sellers can see account relationships that are at risknot just customers with active deals.
We believe sellers will be more productive and close more deals with these digital selling tools assisted by AI. That is why we are enabling them for Dynamics 365 Sales Enterprise customers. We want sellers to be able to experience this new level of productivity and customer connection.
It’s easy to activate these features on your existing Dynamics 365 Sales product, just follow the in-app ‘Get started with digital sales’ guidance, complete with step-by-step videos.
Help sellers accelerate revenue in these four ways
1. Allow real-time call insights to drive better call outcomes. Conversation intelligence uses analytics and data science to help a seller be more efficient and productive. Calls are recorded and analyzed in real time with key insight and committed actions generated in the call conversation. We even programmatically generate meeting summaries to save time in capturing the outcome of a call.
2. Enable sellers to collaborate more effectively in the moments that matter. Sales is a team sport. Sellers need to access subject matter expertise in the context of a deal, collaborate with account teams across the globe, and share artifacts with customers throughout the sales lifecycle. With Microsoft Teams chat embedded within Dynamics 365, you can collaborate with stakeholders directly from within Dynamics 365. This allows you to use Dynamics 365 data as an organizing layer for your Teams collaboration activity and link chats to Dynamics 365 records, such as leads or opportunities, for convenient access for all participants.
3. Help sellers prioritize activities that will have the highest impact. The sales accelerator in Dynamics 365 Sales helps sellers to sell smartly by building a strong and prioritized pipeline, offering context, and surfacing automated recommendations throughout a sales sequence that helps to speed the sales process.
4. Help sellers focus on the leads and opportunities that are most likely to close. Predictive lead and opportunity scoring uses machine learning models to calculate a score for open leads and opportunities. The score is designed to help a seller prioritize their day and identify records which require immediate attention. With effective prioritization sellers should be able to quickly tackle the right leads and opportunities to increase conversion and close rates.
Conversation intelligence, sales accelerator, and lead and opportunity scoring are available in limited capacity each month, with enough quantity to see the daily productivity difference. Customers who hit the monthly limits, or simply want to enable broader use of these benefits, can upgrade to Dynamics 365 Sales Premium. Note that Microsoft Teams chat is not limited in capacity and is available to all Sales Enterprise and Sales Premium customers.
Digital selling is here to stay
With conversation intelligence, sales accelerator, and lead and opportunity scoring, sellers get best-in-class AI capabilities to remember the actions they have committed to, summarize meetings, and help prioritize their worklist. All of this helps your sellers to be more productive and save time by removing manual effort, spending more time selling.
I’m excited to share this update and encourage you to switch to these Dynamics 365 Sales Premium capabilities to take your business to the next level with best-in-class selling solutions.
Learn more
To learn more about these digital selling capabilities, click the links to these online documentation and video resources.
If you’re not already a Dynamics 365 Sales customer, to learn more about how your organization can supercharge your digital sellers, visit the Dynamics 365 Sales webpage and sign up for a free trial.
Recent Comments