Microsoft Learn learning rooms drive connection, guidance, and new possibilities

Microsoft Learn learning rooms drive connection, guidance, and new possibilities

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

At Microsoft Learn, we’re passionate about helping our community build tech skills that can open doors to new possibilities and empower learning through connection. If you follow the Microsoft Learn Community, you may have already heard about the all-new Learning Rooms, and it’s only natural to ask what they are and how they can help you.


 


Make the most of Microsoft Learn learning rooms


Our collection of experiences in the Microsoft Learn Community offers a variety of ways to connect and engage with technical experts who are passionate about the community and who want to help you achieve your learning goals.


Learning rooms are an exclusive component of the Microsoft Learn Community, designed to offer learners like you a dedicated space where you can connect with experts and peers. Learning rooms are facilitated by Microsoft Learn experts who not only have extensive knowledge of and experience with Microsoft products and technologies but can also offer you more targeted opportunities for guidance and support. This direct engagement allows you to dive into topic-specific questions via asynchronous discussions and virtual sessions to help you achieve your skill-building goals in a global, diverse, and inclusive environment.


 


Expert speaking to cohort of learnersExpert speaking to cohort of learners


 


Enhance your technical learning journey


Whether you’re just beginning your learning journey or you have career experience and want to take it to the next level—or maybe you’re almost finished with school and are preparing to launch your career—learning rooms offer an in-depth experience where you can seek advice, ask questions related to skill-building, and connect with like-minded learners. With more than 29 learning rooms to choose from, covering AI; Azure; Microsoft business applications; Modern Workplace; Microsoft Security, compliance, and identity; and other general technologies, our new community experience covers a variety of topics that matter to you and can better guide your learning.


 


Receive the specific guidance you need


The Microsoft Learn Community is here to meet you where you are and to support your personal learning journey. Through learning rooms, you can collaborate with subject matter experts and receive guided support by participating in peer-to-peer virtual and in-person sessions on topics you’re passionate about. Becoming a part of this community can help drive your personal and professional growth, as you make the most of the valuable advice, training insights, and unique perspectives offered by experts and peers. These combined resources can help you not only build confidence but also increase your ability to upskill, pass Microsoft Certification exams, and achieve your career goals.


 


Choose the space that best suits your interests


Help accelerate your career journey in our dedicated learning environments, where you can amplify your impact and expand your network. Our community experience is designed to support ongoing dialogue and valuable interactions. To review all of the available rooms and to be added to those that interest you, go to the Learning Rooms Directory. You can filter by technology or language and view each of the descriptions to find the rooms that best suit you and your skill-building needs. When you’re ready to join, select the title of the room (or rooms) that you wish to join and then complete the registration form. You’ll receive an email letting you know that you’ve been added, and you can begin your Microsoft Learn Community journey. After you’re in a room, get the latest information from the General channel. Feel free to join any conversation or even start one yourself.


 


Directory of Learn ExpertsDirectory of Learn Experts


 


Join the Microsoft Learn Community


We’re all here to support each other on our learning journeys, and our enhanced community experience offers you more ways to increase your expertise on the topics that matter most to you. It can even help you achieve your career goals. You’re at the heart of our community, and we welcome everyone to join, learn, and grow.

Introducing AIM from Microsoft: Future-proof your business in the cloud

Introducing AIM from Microsoft: Future-proof your business in the cloud

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

Microsoft recently introduced Dynamics 365 Copilot, the world’s first AI copilot integrated into customer relationship management (CRM) and enterprise resource planning (ERP) applications in the cloud, that is designed to augment workflows, uncover insights, identify the next best actions, and reduce time spent on administrative tasks. Organizations relying on on-premises applications will struggle to compete with peers embracing these AI-powered technologies in the cloud. It is paramount for companies to migrate their critical business processes to the cloud now.

We at Microsoft want to empower every organization of any size to adopt these innovative AI-powered technologies so that no one is left behind, and that is why we are introducing AIM (Accelerate, Innovate, Move).

AIM offers organizations a tailored path to move critical processes to the cloud with confidence. It provides qualified customers with access to a dedicated team of migration advisors, expert assessments, investment offers, tools, and migration support.

AIM’s coverage extends to a broad range of on-premises business applications from Microsoft, including Dynamics AX, Dynamics CRM, Dynamics GP, Dynamics NAV, Dynamics SL, and Dynamics 365 Business Central on-premises. It truly reflects Microsoft’s commitment to guiding on-premises business application customers into the era of AI-guided productivity.

Let’s dive deeper into the AIM offering.

Accelerate now by starting with AIM assessments

Before embarking on a cloud migration journey, businesses want to understand the business value, expected outcomes, and key steps and dependencies for moving their on-premises business applications to the cloud. We designed AIM assessments to help customers answer these foundational questions. Our partner ecosystem plays a vital role in delivering these assessments, and now with AIM, we are expanding the coverage of the partner activities program to include AIM assessments for a broad portfolio of on-premises products.

Innovate faster and stay ahead of the competition

When migrating to the cloud, accelerating time to value while minimizing risks is crucial for project success. AIM offers expert implementation guidance and services from Microsoft and its certified partners. Success by Design, a systematic approach for successful cloud deployments, provides prescriptive guidance for designing, building, and deploying Microsoft Dynamics 365 solutions, as well as transitioning from on-premises to the cloud.

AIM provides partners with access to additional Success by Design tools and guidance, such as the Microsoft Dynamics 365 Implementation Portal, which offers tailored implementation guidance for successful cloud deployment. FastTrack solution architects from Microsoft are available to collaborate with eligible customers, validating solution architectures, mitigating risks, and overcoming deployment blockers. These architects work closely with the partner ecosystem to ensure seamless transitions. And as part of our Unified Support offerings, we’re launching new project quality advisory services that help support a successful cloud transformation.

Partners that want to accelerate their customers’ move to the cloud can work together with AIM Modernization Centers. These service providers bring tools, assessments, and expert migration guidance to other Microsoft partners and their customers, allowing partners to build migration expertise while focusing on delivering business outcomes for their customers. 

Move with agility and scale as your business grows.

Transforming your business through the cloud is an incremental process. AIM provides exclusive offers that help customers optimize their investments. The recently expanded Bridge to the Cloud 2 (BTTC2) promotional offer enables on-premises customers to utilize discounted subscription pricing as part of migrating to the cloud.*

In summary, AIM is a comprehensive offering that unlocks the potential of AI-powered business systems while reducing costs, providing agility for business model innovation, and operating securely with resilience. Let’s explore how some customers have benefited from moving their legacy on-premises business applications to Dynamics 365 in the cloud.

Reducing costs and driving efficiency

United Kingdom-based energy company Viridor experienced immediate cost savings and a 50 percent reduction in legacy apps after migrating to Dynamics 365, resulting in reduced IT support costs. It further experienced a 30 percent reduction in reporting effort across the organization and is saving 400 hours a month through streamlined account processes. Similarly, UK-based manufacturer Kodak Alaris projected a 25 percent cost reduction by migrating to Dynamics 365, driven by decreased customizations and ISV costs.

Driving agility and scale

Manor AG, burdened by aging applications and on-premises infrastructure, initiated a cloud migration project that improved resiliency, efficiency, and overall customer experience. With Dynamics 365, Manor AG gained greater visibility into operations, allowing for optimization of procurement, sales, pricing, and stock monitoring. Similarly, Azelis, a specialty chemicals and food ingredients service provider, improved scalability by deploying Dynamics 365 across 71 entities, leading to increased productivity and meeting carbon reduction goals.

Improving extensibility, reliability, and security

Dynamics 365 offers a 360-degree view of your business by connecting data from ERP and CRM systems. It provides actionable insights through unified data accessible via Microsoft 365 and Power BI. With more than 5,000 developer extensibility points, Dynamics 365 is flexible and can be personalized to meet industry-specific needs. Microsoft Security ensures the reliability and security of Dynamics 365 in the cloud, protecting data and applications with multiple layers of cybersecurity.

AIM for the future with Microsoft today

Microsoft is committed to empowering customers to take advantage of AI capabilities in every line of business, and with AIM, organizations can start now to move to the cloud, making it easier than ever to adopt AI-guided productivity and realize the full potential of AI-powered technologies. Get started with AIM today and unlock a brighter future for your business. Watch the on-demand Inspire 2023 session to learn more. 

Colorful graphic design

AIM for the future with Microsoft

Adopt innovative AI-powered technologies

To learn about how AI copilot is breaking down data silos, turning insights into actions, and giving customers a new reason to embrace the cloud, check out this blog post: Reshaping the future of business with Microsoft Sales Copilot, Dynamics 365 Customer Insights, and a new cloud migration program.


*This offer is subject to change.

The post Introducing AIM from Microsoft: Future-proof your business in the cloud appeared first on Microsoft Dynamics 365 Blog.

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

Introducing Bing Chat Enterprise, Microsoft 365 Copilot pricing, and Microsoft Sales Copilot

Introducing Bing Chat Enterprise, Microsoft 365 Copilot pricing, and Microsoft Sales Copilot

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

Today, at Microsoft Inspire 2023, we announced the next steps in our journey to empower every person on the planet to work in a new AI-powered way.

The post Introducing Bing Chat Enterprise, Microsoft 365 Copilot pricing, and Microsoft Sales Copilot appeared first on Microsoft 365 Blog.

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

Reshaping the future of business with Microsoft Sales Copilot, Dynamics 365 Customer Insights, and a new cloud migration program

Reshaping the future of business with Microsoft Sales Copilot, Dynamics 365 Customer Insights, and a new cloud migration program

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

Copilot is breaking down data silos, turning insights into actions, and giving customers a new reason to embrace the cloud.

Since March, when we introduced Dynamics 365 Copilot—the world’s first copilot for both customer relationship management (CRM) and enterprise resource planning (ERP)—and Copilot in Microsoft Power Platform, we’ve seen an incredible response with more than 63,000 organizations experiencing Copilot in Dynamics 365 and Power Platform. Customers like Campari Group, Leatherman Tool Group, and Northrop & Johnson are able to transform how work is done, from the front office to the back office. Copilot assists employees wherever they are working, surfacing valuable business data and delivering business insights so they can focus on the most meaningful parts of their jobs. And with this momentum in AI, it’s a great time for our customers to move to the cloud.

Colorful graphic design

Microsoft Sales Copilot

Empowering sellers to increase productivity and personalize customer interactions.

Introducing Microsoft Sales Copilot

Today, we are announcing Microsoft Sales Copilot—a role-based copilot designed for sellers that empowers them to increase productivity and personalize every customer interaction so they can close more deals. Designed to be a seller companion, Sales Copilot can be accessed in the tools where sellers work, whether that is Outlook, Microsoft Teams, or Dynamics 365 Sales, and connects to other CRM systems like Salesforce.

Sales Copilot saves sellers time with CRM task automation, auto-generated email or meeting summaries, and more. Sellers can go from one customer meeting to the next feeling prepared, armed with AI-powered, real-time insights such as top opportunities and customer opportunity summaries. Sales Copilot also helps sellers with customer follow-up by generating AI-assisted content and recommendations, such as contextual emails based on Outlook and CRM data.

Microsoft Viva Sales, announced in June 2022, kick-started our work of transforming seller experiences, and these capabilities are now part of Sales Copilot. In our own sales organization at Microsoft, more than 10,000 sellers have been using Sales Copilot. Early results show that 85 percent of surveyed sellers report completing one or more tasks faster, and 70 percent stated that Sales Copilot helped them improve productivity.

Today, we’re also announcing new Sales Copilot capabilities. Sellers can now: 

  • Get auto-generated opportunity summaries including status, progress, and highlights of key changes, inside Dynamics 365 Sales.
  • Create contextual emails that utilize customer CRM data to pull in product, customer, and opportunity information, inside Dynamics 365 Sales.
  • Prepare for customer meetings with a summary view including account information, recent notes, highlights of any issues or concerns, customer news, and more—in Outlook, Teams, or Dynamics 365 Sales.
  • Get real-time tips and suggested answers during Teams meetings prompted by competitor or brand mentions by the customers to stay ready to handle objections.

“Opportunity summary in Microsoft Sales Copilot is a huge and important leap in our direction to save more time for our sales personnel. With this capability in the hands of our sellers, they can spend more time equipping organizations with best-in-class security solutions to help make our world a safer place.”

—Philip Eklund, Vice President of Client Engagement Platform, Securitas

“At Investec, we are very excited to see how we can leverage Microsoft Sales Copilot and AI within the Microsoft stack to connect our internal teams and to enhance our understanding further of prospective and current clients to ensure we are providing a best-in-class experience.”

—Dan Speirits, CRM Product Manager, Investec

Sales Copilot is generally available today both as a standalone subscription and included as part of customers’ existing Dynamics 365 Sales Enterprise and Premium licenses at no additional cost, with the new capabilities above rolling out this month.

Microsoft Dynamics 365 Customer Insights: AI-powered customer insights and journeys

Delivering exceptional customer experiences is at the heart of what sellers, marketers, and customer service agents do. From building brand loyalty and generating leads to addressing customer issues and closing deals, these roles all rely on knowing the customer in the context of their journey with the brand. Yet, limitations in managing and harnessing customer data in meaningful ways, coupled with organizational silos, have prevented organizations from delivering and realizing the value of a truly connected customer journey.

To help organizations increase the speed of acting on customer insights and orchestrating personalized customer journeys, Dynamics 365 Customer Insights will offer both customer data platform and customer journey orchestration capabilities as a single solution and continue investments into real-time marketing. In March, we announced content ideas, query assist, and dialogue with data—copilot capabilities for brainstorming marketing copy for email campaigns, creating new targeted marketing segments, and using natural language to infer key insights from your customer data and support better business outcomes. These copilot capabilities are available now for use, and we’re adding enhancements in the coming months to include the ability to refresh and improve existing marketing content as well as to summarize audience definitions and suggest improvements to simplify definition.

Today, we also announce two new copilot capabilities for marketers—all included in the new Dynamics 365 Customer Insights subscription. The new capabilities help you:

  • Easily style your email, forms, and event registration pages to perfectly match brand guidelines (as simple as using an existing website) using natural language, so you can deliver a consistent brand narrative and customer experience.
  • Use natural language to easily orchestrate contextually relevant customer journeys across marketing, sales, and service, so customer actions can be responded to appropriately and quickly, generating sales leads or increasing customer satisfaction.

These new capabilities will start rolling out in preview next month. The new Dynamics 365 Customer Insights offering will be generally available on September 1, 2023.

Dynamics 365 Customer Insights unlocks the full potential of your customer data and elevates customer experiences with predictive real-time insights, contextual and relevant customer journeys, and built-in next-generation AI. When customers combine the power of Microsoft Dynamics 365 Customer Insights, Dynamics 365 Sales, and Dynamics 365 Customer Service, they can create even more seamless leads-to-sales-to-retention cycles with differentiated capabilities, including these features that are available today:

  • A 360-degree view of the customer profile, associated marketing interactions, and predicted customer lifetime value to guide both sellers and service agents in their customer interactions.
  • Ability to surface the next best action to the sales team or service team when a lead engages with the marketing team.

“Super exciting—it’s the right move to bring together the customer data and journey capabilities into a single solution”… “this will enable our team to deliver more cohesive experiences quicker and easier.”

—Keith Perfect, Director of Technology & Intelligence, Northrop & Johnson

“At Leatherman, we are thrilled about the potential of generative AI and Microsoft Copilots to advance our business. We are beginning to realize the benefits of improved productivity, streamlined processes, and personalized customer experiences. This technology will undoubtedly propel us towards greater innovation and success.”

—Liz Lee, IT Director, Leatherman Tool Group

Customer service organizations around the globe are using AI technologies to improve service delivery and customer experiences. As examples, AB InBev and Virgin Money are empowering their customer service departments with tailored chatbots built with Copilot in Power Virtual Agents. Within minutes, businesses can train a bot using natural language to reference internal and external knowledge sources, customer service applications, and web data through Bing. Virgin Money’s chatbot addresses more than 195,000 customer interactions a month, helping their service agents to focus on more complex customer inquiries. In the next few months, we’ll be rolling out additional role-based copilots, similar to Microsoft Sales Copilot, that will help customer service agents be more productive and better engage with their customers using the innovation of Copilot in Power Virtual Agents. Learn more about Power Virtual Agents.

AIM for the future with Microsoft

Copilot is redefining productivity, efficiency, and collaboration across business workflows. However, today many businesses are challenged to access new technology innovations, like AI, to improve profitability and maintain a competitive edge because they are still operating on legacy on-premises solutions. At Microsoft, we are committed to helping customers gain access to and take advantage of AI capabilities, starting now.

So, today, we’re also announcing AIM (Accelerate, Innovate, Move), a brand-new program that offers a tailored path for our customers to move from on-premises to cloud-first Microsoft Dynamics 365 business applications.

With AIM, customers of all sizes can accelerate their migration to the cloud to adopt AI-powered technologies starting with AIM assessments. These assessments are designed to help customers understand the business value, expected outcomes, and key steps and dependencies for moving their on-premises business applications. Customers can innovate faster to stay ahead by using the proven Success by Design methodology from Microsoft to implement Dynamics 365 and go live with confidence. Customers get expert implementation guidance and services from FastTrack and its certified partners. And finally, they’ll also be able to move with agility and scale as their business grows. AIM provides exclusive offers that help customers optimize their investments and transform the business processes in an incremental manner.

AIM is a comprehensive offering that unlocks the potential of AI-powered business systems while reducing costs, providing agility for business model innovation, and operating securely with resilience. AIM provides access to a dedicated team of migration advisors, assessments, offers, tools, and support to give customers a faster route to innovation and success.

Get started today with AIM and future-proof your business.

Looking forward to Dynamics 365 solutions

  • Learn more about Microsoft Sales Copilot.
  • If you are an existing Dynamics 365 Sales or Marketing or Customer Insights customer, start using the new capabilities in preview. To learn more about the new Dynamics 365 Customer Insights offering, read more here.
  • If you are not a customer yet, learn more and sign up for a trial on our website.
  • If you are a customer using ERP and CRM systems on-premises, and want to migrate to Dynamics 365 in the cloud to accelerate adoption of AI-powered technologies, get started today with AIM.

The post Reshaping the future of business with Microsoft Sales Copilot, Dynamics 365 Customer Insights, and a new cloud migration program appeared first on Microsoft Dynamics 365 Blog.

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

2023 release wave 2 plans for Microsoft Dynamics 365 and Power Platform now available

2023 release wave 2 plans for Microsoft Dynamics 365 and Power Platform now available

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

On July 18, 2023, we published the 2023 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform, a compilation of new capabilities planned to be released between October 2023 and March 2024. This second release wave of the year offers hundreds of new features, including AI capabilities and enhancements, demonstrating our continued investment to power digital transformation for our customers and partners.

This release wave builds on our commitment to create applications and experiences that add value to every role by breaking down silos between data, insights, and people. New capabilities empower new ways to make informed decisions with AI-guided insights and suggested actions, easier ways to automate tasks and processes, and collaboration seamlessly integrated into the flow of work, plus, new low-code ways for anyone to build solutions.

Discover a whole new level of convenience in reviewing release plans for Dynamics 365 and Microsoft Power Platform with the release planner. Experience unparalleled flexibility as you personalize, filter, sort, and effortlessly share plans according to your preferences. Stay organized, stay informed, and stay in control as you effortlessly navigate through multiple active waves of plans. For more information, visit releaseplans.microsoft.com.

Highlights from Dynamics 365

Dynamics 365 Marketing will bring enhancements to Copilot features empowering marketers to quickly create new experiences and will bring unprecedented levels of personalization to email content, images, and layouts. Additionally, business-to-business (B2B) dashboards and directly assigning leads to the right sales rep will align marketers and sellers, enabling them to act as a unified team across the buying journey.

Dynamics 365 Sales will focus on enabling sales organizations to prioritize and manage digital sales processes through enhanced sequence capabilities. We will allow users to assign and monitor lead assignment status with enhanced lead assignment capabilities by providing recommendations, summarizing data, retrieving information, and performing actions in context and within flow of work.

Viva Sales is reimagining how sellers work by delivering advanced AI capabilities like email summarization, CRM recommendations, sales email composition, meeting summarization, and real-time sales tips. Additionally, we are making further investments to collaboration spaces in Microsoft Teams and will deliver new sales Copilot experiences that accelerate deal progression and close sales faster.

Dynamics 365 Customer Service will continue to empower agents to work more efficiently through Copilot capabilities, Join me On Teams, and visual enhancements to the agent workspace, ability to see live chats and voice calls in Inbox and personalizing size of conversational control. Additionally, we are making enhancements to the voice channel, call dialer improvements, and routing calls to agents with longest idle time.

Dynamics 365 Field Service updates will include new capabilities for frontline workers, service managers, and dispatchers. We are delivering several top requests such as converting quotes to work orders, enhancing inspections, and evolving our resource scheduling capabilities.

Dynamics 365 Finance is focused on enhancing organizations’ visibility into their data, continued enhancements for accounts payable and bank statement automation, and expanding out-of-the-box country coverage in Latin America. Additionally, the team will deliver further automation of complex tax scenarios and e-invoicing requirements for new countries and provide organizations ability for business model expansion and agility.

Dynamics 365 Supply Chain Management continues to improve and optimize business processes to deliver the agility and resilience needed for businesses to thrive in an increasingly complex business environment. The sales and procurement processes will be further enhanced, manufacturers will enjoy greater flexibility, and warehouse processes related to counting, customer returns, and product receipts will be improved.

Dynamics 365 Project Operations is investing in enhancements to services procurement scenarios and project contracting and new functionalities and scenarios in pricing models will support the evolving patterns in the service-centric economy. Additionally, improvements to intelligent resource recommendations will provide suggestions based on experience, cost, and utilization across employees and subcontractors.

Dynamics 365 Human Resources will be improving recruiting experiences with functionally rich and intuitive experiences that target recruiters, candidates, and hiring managers. We will expand the human capital management ecosystem to include learning management system integration through public APIs using Microsoft Dataverse along with expanding our payroll partner network.

Dynamics 365 Guides is bringing several new capabilities and enhancements including Object Anchors, Azure Remote Rendering, and availability on Microsoft 365 Government Community Cloud High. Additionally, we are focusing on features allowing seamless integration with systems of record allowing customers to build mixed reality workflows that are integrated with their business data.

Dynamics 365 Commerce is using the power of AI to enable the effortless creation of engaging product content for digital commerce sites. New B2B investments allow distributors to view, accept, and reject orders from a centralized dashboard that enables B2B sellers, distributors, and buyers to all work in the same place.

Dynamics 365 Business Central will focus on core functionality to help companies manage their intercompany and consolidations across environments. We will continue to enhance our Copilot capabilities and will further improve our warehouse capabilities, create more Power Automate templates, and provide developers with more capabilities for automating testing of dependent apps.

Dynamics 365 Customer Insights is enhancing our Copilot features to allow you to ask questions in simple words, to quickly receive insights, and action these immediately. New capabilities in real-time data management will provide the latest view of your customers and easy access to insights within Dynamics 365 apps will allow your team to deliver seamless, personalized experiences across the customer’s lifecycle.

Microsoft Supply Chain Center is enabling resilient supply chain with enhancements in key areas such as Intelligent Order Management for purchase order orchestration, seamless collaboration with external partners via Supplier portal, and Copilot. Additionally, the team will be bringing Advanced Data Analytics to enable Insights to Action as well as new Network Inventory Optimization capabilities.

Highlights from Microsoft Power Platform

Power BI is improving the creation experience for individuals by improving and aligning our experiences with Microsoft 365, bringing more parity on the web, and bringing the Power Query diagram view into Power BI Desktop. For teams, we are bringing enhancements to meetings and multitasking. For organizations, we are enabling Git and source control integration to help developers maintain and collaborate on their business intelligence solutions.

Power Apps is expanding the use of Copilot to bring AI-assisted experiences to increase developer productivity, bring natural language to all users, and give insights to admins. We will bring modern controls and rich collaborative experiences to users, as well as improved deployment and governance support to ensure low-code can be enabled organization wide.

Power Pages continues to make strides in the Copilot maker experience to enable building a site. Managed environments will include Power Pages capabilities for maker usage and onboarding. For data, you can connect easily to data where it exists today. Low-code makers can collaborate and detect co-presence.

Power Automate will continue to make it easier to get started building new flows by using natural language across cloud flows and desktop flows, and by improving process mining to jumpstart creation of automation and authoring experiences. Additionally, we’re making it easier to manage work at scale by introducing unified activity view and deeper notifications on capabilities across the product. 

Power Virtual Agents will bring general availability for capabilities including Multi-Lingual bot support, Generative Answers and Actions, Standalone interactive voice response (IVR) and IVR integration with Dynamics 365 Customer Service, and our integration with the Conversational Language Understanding service. Additionally, we will continue to enhance our offering for customers by delivering on new Enterprise Trust capabilities.

AI Builder will allow makers to easily process structured and unstructured documents. Using the power of GPT, responses to customer requests can be pre-generated according to enterprise guidelines and will be available in a human validation station allowing makers to easily review and enhance content that is automatically generated from intelligent copilots.

2023 release wave 2 early access period

Starting July 31, 2023, customers and partners will be able to validate the latest features in a non-production environment. These features include user experience enhancements that will be automatically enabled for users in production environments during October 2023. To take advantage of the early access period, try out the latest updates in a non-production environment, and effectively plan for your customer rollout. Check out the 2023 release wave 2 early access features for Dynamics 365 and Microsoft Power Platform, or visit the early access FAQ page. 

Female worker wearing glasses and looking at one of two desktop monitors

Release planner

Personalize, filter, sort, and effortlessly share plans according to your preferences.


The post 2023 release wave 2 plans for Microsoft Dynamics 365 and Power Platform now available appeared first on Microsoft Dynamics 365 Blog.

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

Transition to real-time marketing and transform your Customer Experience

Transition to real-time marketing and transform your Customer Experience

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

Adapting to evolving customer expectations: staying ahead in the new marketing landscape

Customer experience has significantly transformed in recent years, moving away from linear buying journeys and one-size-fits-all approaches. Nowadays, customers expect digitally enabled, hyper-personalized experiences. To stay competitive, organizations must embrace a customer-first approach, bridging departmental gaps to deliver cohesive experiences. By harnessing the power of their data, organizations can gain a deep understanding of their customers, anticipate behaviors, and craft 1:1 personalized experiences across all touchpoints, including sales, marketing, business operations, and service functions to drive better customer engagement and long-term loyalty. However, that is not enough, to become or stay leaders in their industries, organizations need to take advantage of generative AI to unlock capabilities and levels of productivity that were previously out of reach.

We are making it easier than ever to acquire these capabilities. Today, at Inspire, we announced, that Dynamics 365 Customer Insights and Dynamics 365 Marketing are coming together as one offering named Dynamics 365 Customer Insights, an AI driven solution which will revolutionize your customers experiences. Within this solution are two apps: Customer Insights – Data (currently known as Dynamics 365 Customer Insights) that empowers you to effectively build a unified, real time 360-degree profile of your customers, and Customer Insights – Journeys (currently known as Dynamics 365 Marketing) that allows you to act on this comprehensive understanding to deliver highly personalized experiences. These two apps allow you to start with data or journeys and purchase what you want while providing a 40 percent savings on the base license offer compared to previous packaging.

To learn more please visit Dynamics 365 Customer Insights FAQs.

Transforming customer experiences with real-time marketing and Copilot generative AI capabilities

Recognizing the need for a modern approach to address the high level of engagement demanded by customers, over the next year we will be transitioning all customers of Dynamics 365 Customer Insights – Journeys from outbound to real-time marketing. Transitioning to real-time marketing enables you to do more with less, drives superior business results, caters to the evolving customer experience landscape, and will propel your businesses into the future of marketing. Real-time marketing has already surpassed traditional outbound marketing in functionality, effectiveness, usability testing results, satisfaction surveys. Moreover, our innovations and upcoming AI features are available exclusively in real-time marketing.

Starting August 2023, new customer environments will only include real-time marketing and event management. Existing customers, if necessary, will be able to add outbound marketing through a self-serve interface. We will continue to support outbound marketing but will not be adding new enhancements.

Transition to real-time marketing

Operations manager presenting.

By transitioning to real-time marketing now, you can gain the following benefits:

Leverage AI to do more with less

Embrace generative AI to ensure long-term success by increasing your productivity while delivering superior customer experiences. You can already leverage Copilot features to assist you in targeting the right audience simply by describing your segments using everyday words – without having to learn the underlying data model or construct queries. With content ideas, you can provide key points or select a topic and a tone of voice matching your message to generate engaging email content within seconds. Furthermore, to complement your message, you can easily choose images from your library that resonate with your audience without having to spend time searching for them.
In the upcoming months, you will be able to use innovative Copilot capabilities to make your messages more compelling by rewriting your existing content, create journeys just by describing them in simple words, set up quiet times to prevent messages from sending during unwanted times, effortlessly style your emails and forms based on your website design, and receive guidance to authenticate your domains easily. By adopting AI now your organization will be better equipped to stay competitive and thrive in the ever-evolving market landscape, ensuring better business results.

Optimize every interaction

Experience the power of seamless integration between Customer Insights – Data and Customer Insights – Journeys, allowing you to continuously capitalize on customer understanding and insights in real-time, to proactively address customer needs and enhance every interaction. Leverage real-time marketing to craft journeys for contact and lead entities in Dataverse, or profiles from Customer Insights. React to customers’ actions instantly using out-of-the-box triggers, custom triggers, or triggers based on any data change in Dataverse without writing any code. Refine your audience targeting with advanced segmentation capabilities, and an unlimited number of segments. Deliver your messages through out-of-the-box text messages, push notifications, custom channels and benefit from AI-powered channel optimization to reach customers on the most effective channel. Embrace hyper-personalization features like dynamic text and no-code conditional content to support 1:1 responsive campaigns tailored to individual preferences with real-time marketing.

Sales team meeting
Unify sales and marketing

To win deals, sales and marketing teams must work together – break down silos between these teams to fuel revenue growth and increase pipeline. As a marketer, use our new and improved UX across all capabilities! As part of the enhanced upcoming lead scoring builder, you will be able to define granular qualification criteria to better identify and prioritize leads. Thanks to the deep integration with Dynamics 365 Sales, you can align your efforts with sellers by sharing a unified timeline of customer activities, seamlessly transfer qualified leads to the sales team or engage sales representatives within your customer journey exactly at the right time by assigning a sales call or triggering a sales sequence to further increase the likelihood of closing deals. Continuously optimize your marketing efforts by using AI-powered attribution analytics to understand how your marketing activities contribute to your defined milestones.

Scale your business

Real-time marketing unlocks new opportunities for growth and success. Thanks to business units, brand profiles, and a new consent center you can tailor real-time marketing to cater to your business’ unique requirements. As a scalable, customizable solution, real-time supports up to 100 million marketing contacts with 300 million monthly interactions so you can grow your customer base in new markets, reach additional geographies, promote new products, or expand your prospective customer pipeline to reach higher sales targets.

The future is now: the new Dynamics 365 Customer Insights and real-time marketing

To make sure your transition to real-time marketing is a success, we have designed a user-friendly interface that does not require extensive retraining – you will experience UI enhancements that significantly improve usability and efficiency.
To easily kick start delivering experiences using real-time marketing, we have designed an email transition tool, made outbound segments available directly in real-time, and empowered you to generate more engaging content and revisit or create new journeys within minutes thanks to our new AI Copilot features.

Please visit for detailed guidance and resources for transitioning to the real-time marketing.

We are excited about how this change to an AI powered, unified Dynamics 365 Customer Insights, with a generative AI interface coming to every capability will fundamentally change what your company can achieve and how easily you will be able to achieve it.
We look forward to building the future of customer experiences together and have big plans for Dynamics 365 Customer Insights in the coming year and beyond.

Read our real-time marketing FAQ

Discover the upcoming Dynamics 365 Customer Insights Data and Journey wave 2 2023 features:

The post Transition to real-time marketing and transform your Customer Experience appeared first on Microsoft Dynamics 365 Blog.

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

Improve sales productivity and close more deals with Microsoft Sales Copilot

Improve sales productivity and close more deals with Microsoft Sales Copilot

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


As a seller, you know you need to focus on building relationships with your customers and getting the details you need to close the deal. The challenge is that like most sellers, you spend less than 30% of your time selling.[1] Most of your day goes to searching for information and administrative duties like composing emails and keeping your CRM system up to date. You need more from your technology—and we delivered. In February, we introduced the world’s first AI copilot in CRM with the launch of Microsoft Dynamics 365 Copilot. And today, we’re announcing Microsoft Sales Copilot, a role-based copilot designed to improve sales productivity by empowering sellers with the data and insights they need, when and where they’re needed, allowing them to focus on what they do best—selling.

Sales Copilot brings new capabilities to Microsoft Outlook, Teams, and Dynamics 365 Sales, helping sellers to increase their productivity and personalize every customer interaction. And it works out of the box—not just with Dynamics 365 Sales, but with Salesforce, too.

The following Sales Copilot capabilities are now available for preview[2]:

  • AI-generated lead and opportunity summaries to streamline your sales process and close deals faster
  • A customer meeting preparation summary view that includes auto-generated summaries of previous meetings, recent notes, highlights of issues and concerns, and CRM information
  • Real-time tips and suggested answers during Teams meetings, prompted by the customer’s mention of a competitor or brand
  • Customer email summary and follow-up, with contextual replies and actions based on Outlook emails and CRM data

Additionally, we recently announced the general availability of collaboration spaces in Sales Copilot. Collaboration spaces in Teams can easily be created from Sales Copilot in Outlook to help sellers stay better connected with their customers and colleagues.

Watch this brief video to learn how Microsoft Sales Copilot can help you improve your sales productivity:

AI-generated lead and opportunity summaries

Sales Copilot uses generative AI to quickly summarize leads and opportunities for you. An opportunity summary is a concise overview of the status, progress, and potential of a prospective sale or deal. A “catch up” section highlights key updates since the last visit. An opportunity summary is also available in Outlook, where sellers can view a brief background of the opportunity and the latest activities.

Opportunity summary in Dynamics 365 Sales

Similarly, a lead summary gives sellers an overview that seamlessly combines data from multiple sources, such as CRM information, contact profiles from LinkedIn[3], and the latest news from Bing to expedite the lead qualification process.


Lead summary in Dynamics 365 Sales

Meeting preparation and summaries

Being prepared for customer meetings is vital for sales productivity. It facilitates informed decision-making and fosters productive discussions, ultimately yielding improved sales outcomes. Sales Copilot detects meetings coming up in the next 24 hours and offers a summary of recent email exchanges and the last three seller notes to help you prepare.

Meeting preparation in Dynamics 365 Sales

After the meeting, Sales Copilot in both Outlook and Dynamics 365 Sales generates a professional and friendly meeting summary email, making follow-up as easy as clicking a button.

Meeting summary in Outlook email

Real-time tips in Teams meetings

In Teams, sellers receive real-time coaching tips (currently in private preview) during meetings right in the Sales Copilot Teams panel, to help them respond to customer inquiries and competitor or brand mentions. It’s easier to overcome objections and demonstrate that you’re knowledgeable and prepared when the information you need is right in front of you.

Competitor mentioned tip during Teams meeting

Summary, follow-up, and contextual emails

Sales Copilot lets you spend less time composing email. Select a pre-defined category or enter your own text, and Sales Copilot suggests content with specific prompts and actions informed by Outlook and CRM data, helping sellers quickly follow up, reply to inquiries, and move deals forward. Adjust the tone and length of the message to better resonate with your customers, fostering stronger connections. You can further customize the suggested content before you send it.

Contextual email reply in Dynamics 365 Sales

Sales Copilot is equally invaluable on the receiving end, summarizing lengthy email threads when you respond to incoming messages and enabling you to save the summary to your CRM with one click. By condensing complex discussions, it streamlines the communication process and ensures comprehension. It also helps to keep you on track by identifying action items and key customer requests in your incoming emails that you might have missed. It continuously monitors your inbox so you don’t have to.

Contextual email follow-up in Dynamics 365 Sales

Collaboration spaces

Sellers can easily work with colleagues and customers in collaboration spaces—predefined Teams channels with pinned apps designed for collaboration. Collaboration spaces link to your CRM system and are accessible from Teams, the Sales Copilot app in Outlook, and Dynamics 365 Sales. Learn more about collaboration spaces.

Collaboration space in Teams

Responsible AI

Microsoft is committed to investing in features that reduce or eliminate unsafe output from generative AI capabilities in products like Sales Copilot.

Sales Copilot inherits your organization’s security, compliance, and privacy policies and enforces two-factor authentication, making Sales Copilot a tool you can trust.

Because we know that data leakage is a concern for our customers, as it is for us, the language models that underlie Sales Copilot aren’t trained on and don’t learn from your company’s business, tenant, or individual data. Sales Copilot is part of the Azure ecosystem and employs the same safeguards, compliance boundaries, and enterprise-grade security.

Microsoft copilot AI adheres to our commitment to responsible AI. Engineering teams at Microsoft are continuously working to address issues such as misinformation and disinformation, content blocking, data safety, and promotion of harmful content, guided always by our responsible AI principles.

Users have access to specific guidance that helps to reinforce the responsible use of generative AI content. For instance, we provide guidance and prompts through informational elements that instruct the user:

  • How to responsibly use suggested content and actions, including prompts
  • How to review and edit responses as needed
  • How to manually check facts, data, and text for accuracy

Sales Copilot also cites public sources wherever relevant, so the user can easily find the web content it references.

More innovations to transform the customer experience

In addition to Sales Copilot, we’re announcing copilot innovations across Dynamics 365 to empower organizations to deliver exceptional experiences throughout their customer journeys.

  • We’re adding copilot capabilities to the newly unified Dynamics 365 Customer Insights and continuing our innovations in real-time marketing. Along with the copilot capabilities that are in public preview (Content Ideas, Query Assist, and Dialogue with Data), soon you’ll be able to use natural language to orchestrate customer journeys as well as style emails, forms, and event registration pages to match your brand guidelines.
  • Dynamics 365 Commerce Copilot can craft compelling, persuasive, and engaging content for product listings for online commerce, with an aim to drive discoverability and conversion. It allows merchandisers to optimize for search engines while tailoring the content for their customers, brand, and voice.

Next steps

Try Microsoft Sales Copilot today to see how it can improve your sales productivity by enabling sellers to engage with customers more effectively and close more deals faster.

Enable Microsoft Sales Copilot in Outlook and Teams: Microsoft Sales Copilot deployment guide for Dynamics 365 customers

Enable Microsoft Sales Copilot in Dynamics 365 Sales: Enable and set up copilot capabilities in Dynamics 365 Sales

Learn more about all the upcoming Dynamics 365 Sales Wave 2 2023 features: Overview of Dynamics 365 Sales 2023 release wave 2 | Microsoft Learn

Not a Dynamics 365 Sales customer yet? Visit the Dynamics 365 Sales website to take a guided tour and sign up for a free trial.


Footnotes:

[1] Global State of Sales Report 2022 (linkedin.com)

[2] At preview, capabilities available in English in geographies that support Dynamics 365 Sales.

[3] A Sales Navigator license is required to access contact profiles from LinkedIn.

The post Improve sales productivity and close more deals with Microsoft Sales Copilot appeared first on Microsoft Dynamics 365 Blog.

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

New transactable offers from Connecting Software and Varonis

New transactable offers from Connecting Software and Varonis

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

Microsoft partners like Connecting Software and Varonis deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about these offers below:


 













Connecting Software.png

CB Dynamics 365 to SharePoint Permissions Replicator: This solution from Connecting Software secures your Microsoft Dynamics 365 CRM documents stored in SharePoint. It covers full security roles, logic support, business unit hierarchy, sharing, cascading behavior, position-based hierarchy, and more.


 


CB Exchange Server Sync: CB Exchange Server Sync from Connecting Software synchronizes and migrates data between different servers, domains, and versions of Microsoft Exchange and Outlook. It’s ideal for large companies that need to manage shared resources across separate business units.


 


CB Seamless Attachment Extractor for Dynamics 365: Documents and attachments that harm CRM performance and undermine its functionality often take up most of the space used. Save valuable Microsoft Dynamics 365 database space by automatically moving attachments to alternative storage.


Varonis.png

Varonis: Find, Monitor, and Protect Sensitive Data: Varonis is a data security platform that protects data with low-touch, accurate security outcomes by classifying more data, revoking permissions, enforcing policies, and triggering alerts for the Varonis incident response team to review on your behalf.


Lesson Learned #401:Creating Dynamic Views from Multiple Tables using Stored Procedure

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

Recently, I encountered an intriguing scenario where our customer needed to dynamically create views based on multiple tables, allowing them to efficiently filter and aggregate data. The challenge arose when dealing with varying amounts of data, which required careful consideration for performance optimization. Through this article, I would like to share my insights and present a stored procedure that offers additional options to address this dynamic view creation requirement effectively.


 


Script Overview:
The “SearchAndView” stored procedure accepts several input parameters that define the behavior and structure of the dynamic view to be created. Let’s take a closer look at each parameter and its significance:


 


1. @SearchField: This parameter specifies the field on which the search operation will be performed within the tables. If provided, the dynamic view will only include rows that match the given criteria.


2. @SearchText: This parameter holds the search text that will be matched against the @SearchField. It complements the search functionality and allows for targeted data retrieval.


3. @TableList: This parameter contains a comma-separated list of tables from which data will be retrieved and combined in the dynamic view. By specifying the desired tables, users can tailor the view to their specific needs.


4. @TableSchema: This parameter defines the schema under which the tables reside. It ensures the correct retrieval of table data within the specified schema context.


5. @ViewSchema: This parameter represents the schema under which the dynamic view will be created. If the schema doesn’t exist, the script dynamically creates it to accommodate the view.


6. @ViewName: This parameter defines the name of the dynamic view. It should be unique within the specified @ViewSchema and serves as an identifier for accessing the combined data.


7. @FieldList: An optional parameter, @FieldList, allows users to specify a list of fields they want to include in the dynamic view. If not provided, all fields from the tables will be included by default.


8. @TopCount: Another optional parameter, @TopCount, determines the maximum number of rows to include in the dynamic view. By setting this value, users can control the amount of data returned and improve query performance.


9. @AddUniqueField: This binary parameter, when set to 1, adds an additional column called “UniqueField” to each row of the dynamic view. The value of this field is generated using the NEWID() function and ensures uniqueness within the view’s result set.


 


Script Execution:


 


The “SearchAndView” stored procedure follows a structured workflow to create the dynamic view. Here’s an overview of the execution steps:


 


1. Parameter Validation: The script first validates the input parameters, ensuring that essential values like @TableSchema, @ViewSchema, @ViewName, and @TableList are provided. If any required parameter is missing, an error is raised, and the procedure is terminated.


2. Schema Creation: The script checks if the specified @ViewSchema exists. If not, it dynamically creates the schema using the CREATE SCHEMA statement. This step ensures that the view is created within the desired schema context.


3. View Existence Check: Before creating the dynamic view, the script verifies if a view with the same @ViewName already exists within the specified @ViewSchema. If found, the existing view is dropped to avoid conflicts during view creation.


4. Dynamic View Creation: The script constructs the CREATE VIEW statement using the specified @ViewSchema, @ViewName, and other parameters. It then iterates over the tables provided in @TableList, generating SELECT statements for each table. The statements include the necessary JOIN or UNION ALL operations to combine data from multiple tables.


5. Optional Functionality: If @FieldList is provided, it is included in the SELECT statement to specify the desired fields in the dynamic view. If @TopCount is specified, a TOP clause is added to limit the number of rows returned. If @AddUniqueField is set to 1, the NEWID() function is used to generate a unique identifier column, which is included in each row of the dynamic view.


6. Dynamic SQL Execution: The constructed SQL statement is executed using sp_executesql to create the dynamic view within the specified @ViewSchema and @ViewName.


7. Error Handling: The script includes error handling logic within a TRY…CATCH block. If any error occurs during view schema creation, dropping the existing view, or creating the dynamic view, an error message is raised, providing details about the encountered error.


 


 

CREATE PROCEDURE SearchAndView (
    @SearchField VARCHAR(100),
    @SearchText VARCHAR(100),
    @TableList VARCHAR(MAX),
    @TableSchema VARCHAR(100),
    @ViewSchema VARCHAR(100),
    @ViewName VARCHAR(100),
    @FieldList VARCHAR(MAX) = NULL,
    @TopCount INT = NULL,
    @AddUniqueField BIT = 0
)
AS
BEGIN
    -- Check if TableSchema is empty
    IF @TableSchema IS NULL OR LTRIM(RTRIM(@TableSchema)) = ''
    BEGIN
        RAISERROR('Error: TableSchema is required.', 16, 1)
        RETURN;
    END

    -- Check if ViewSchema is empty
    IF @ViewSchema IS NULL OR LTRIM(RTRIM(@ViewSchema)) = ''
    BEGIN
        RAISERROR('Error: ViewSchema is required.', 16, 1)
        RETURN;
    END

    -- Check if ViewName is empty
    IF @ViewName IS NULL OR LTRIM(RTRIM(@ViewName)) = ''
    BEGIN
        RAISERROR('Error: ViewName is required.', 16, 1)
        RETURN;
    END

    -- Check if TableList is empty
    IF @TableList IS NULL OR LTRIM(RTRIM(@TableList)) = ''
    BEGIN
        RAISERROR('Error: TableList is required.', 16, 1)
        RETURN;
    END

    DECLARE @SQLStatement NVARCHAR(MAX)
    DECLARE @ErrorMessage NVARCHAR(4000)

    -- Check if the view schema exists, if not, create it
    IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = @ViewSchema)
    BEGIN
        SET @SQLStatement = 'CREATE SCHEMA ' + QUOTENAME(@ViewSchema)

        BEGIN TRY
            EXEC sp_executesql @SQLStatement
        END TRY
        BEGIN CATCH
            -- Handle any errors that occurred during execution
            SET @ErrorMessage = ERROR_MESSAGE()
            RAISERROR('Error occurred while creating the view schema. Error message: %s', 16, 1, @ErrorMessage)
            RETURN
        END CATCH
    END

    -- Check if the view already exists and drop it if necessary
    IF EXISTS (SELECT * FROM sys.views WHERE name = @ViewName AND SCHEMA_NAME(schema_id) = @ViewSchema)
    BEGIN
        SET @SQLStatement = 'DROP VIEW ' + QUOTENAME(@ViewSchema) + '.' + QUOTENAME(@ViewName)

        BEGIN TRY
            EXEC sp_executesql @SQLStatement
        END TRY
        BEGIN CATCH
            -- Handle any errors that occurred during execution
            SET @ErrorMessage = ERROR_MESSAGE()
            RAISERROR('Error occurred while dropping the existing view. Error message: %s', 16, 1, @ErrorMessage)
            RETURN
        END CATCH
    END

    -- Create the view
    SET @SQLStatement = 'CREATE VIEW ' + QUOTENAME(@ViewSchema) + '.' + QUOTENAME(@ViewName) + ' AS '

    -- Split the table list into separate table names
    DECLARE @Tables TABLE (RowNumber INT IDENTITY(1,1), TableName VARCHAR(100))
    INSERT INTO @Tables (TableName)
    SELECT value FROM STRING_SPLIT(@TableList, ',')

    -- Check if FieldList is empty, if so, assign default value '*'
    IF @FieldList IS NULL OR LTRIM(RTRIM(@FieldList)) = ''
        SET @FieldList = '*'

    -- Generate the SELECT statement for each table
    DECLARE @Counter INT = 1
    DECLARE @NumTables INT = (SELECT COUNT(*) FROM @Tables)
    WHILE @Counter <= @NumTables
    BEGIN
        SET @SQLStatement += 'SELECT '

        IF @TopCount IS NOT NULL
        BEGIN
            SET @SQLStatement += 'TOP(' + CAST(@TopCount AS NVARCHAR(10)) + ') '
        END

        IF @AddUniqueField = 1
        BEGIN
            SET @SQLStatement += 'NEWID() AS UniqueField, ' + @FieldList
        END
        ELSE
        BEGIN
            SET @SQLStatement += @FieldList
        END

        SET @SQLStatement += ' FROM ' + QUOTENAME(@TableSchema) + '.' + QUOTENAME((SELECT TableName FROM @Tables WHERE RowNumber = @Counter))

        IF @SearchField  '' AND @SearchText  ''
        BEGIN
            SET @SQLStatement += ' WHERE ' + QUOTENAME(@SearchField) + ' = ''' + @SearchText + ''''
        END

        IF @Counter < @NumTables
            SET @SQLStatement += ' UNION ALL '

        SET @Counter += 1
    END

    -- Execute the dynamic SQL statement
    BEGIN TRY
        EXEC sp_executesql @SQLStatement
    END TRY
    BEGIN CATCH
        -- Handle any errors that occurred during execution
        SET @ErrorMessage = ERROR_MESSAGE()
        RAISERROR('Error occurred while creating the view. Error message: %s', 16, 1, @ErrorMessage)
    END CATCH
END

 


 


How to call the stored procedure 


 


 

BEGIN TRY
    EXEC SearchAndView 'name', 'John',  'Table1,Table2,Table3','dbo','MyView', 'MyView','Age,Name',Null,1
END TRY
BEGIN CATCH
    -- Handle any errors that occurred during execution
    PRINT 'Error occurred while executing the stored procedure.'
    PRINT 'Error message: ' + ERROR_MESSAGE()
END CATCH

WITH cte(AgeMax, Number)
as 
(
select MAX(AGE) as AgeMax,COUNT(*) as Number from [MyView].[MyView] 
)
select AgeMax, Number from cte 

 


 


Tables and data example


 

-- Create EnglishNames table
CREATE TABLE EnglishNames (
    Name varchar(100)
);

-- Insert English names into EnglishNames table
INSERT INTO EnglishNames (Name)
VALUES
    ('John'), ('William'), ('James'), ('Charles'), ('George'),
    ('Thomas'), ('Joseph'), ('Robert'), ('Michael'), ('David'),
    ('Richard'), ('Daniel'), ('Paul'), ('Mark'), ('Donald'),
    ('Edward'), ('Steven'), ('Brian'), ('Kevin'), ('Jason'),
    ('Jeffrey'), ('Scott'), ('Kenneth'), ('Anthony'), ('Eric'),
    ('Stephen'), ('Timothy'), ('Patrick'), ('Gregory'), ('Matthew'),
    ('Andrew'), ('Christopher'), ('Jonathan'), ('Ronald'), ('Dennis'),
    ('Jerry'), ('Gary'), ('Frank'), ('Raymond'), ('Peter'),
    ('Samuel'), ('Charles'), ('Henry'), ('Larry'), ('Jose'),
    ('Albert'), ('Arthur'), ('Ryan'), ('Carl'), ('Roger'),
    ('Benjamin'), ('Wayne'), ('Billy'), ('Walter'), ('Harry'),
    ('Howard'), ('Philip'), ('Stephen'), ('Vincent'), ('Jeremy'),
    ('Ralph'), ('Sean'), ('Johnny'), ('Bobby'), ('Louis'),
    ('Eugene'), ('Randy'), ('Russell'), ('Gerald'), ('Russell'),
    ('Keith'), ('Philip'), ('Franklin'), ('Alan'), ('Willie'),
    ('Roy'), ('Jesse'), ('Frederick'), ('Dustin'), ('Victor'),
    ('Glenn'), ('Alfred'), ('Leonard'), ('Melvin'), ('Lee'),
    ('Eddie'), ('Reginald'), ('Bill'), ('Wayne'), ('Martin'),
    ('Craig'), ('Dale'), ('Randall'), ('Bradley'), ('Jesus'),
    ('Leroy'), ('Curtis'), ('Warren'), ('Clarence'), ('Jerome'),
    ('Lewis'), ('Don'), ('Nathan'), ('Calvin'), ('Keith');

-- Create Table1
CREATE TABLE Table1 (
    Name varchar(100),
    Age int
);

-- Insert random data into Table1 using English names
DECLARE @Counter INT = 1;

WHILE @Counter <= 10000
BEGIN
    INSERT INTO Table1 (Name, Age)
    SELECT 
        Name,
        ABS(CHECKSUM(NEWID())) % 100 + 1 -- Random age between 1 and 100
    FROM 
        EnglishNames
    ORDER BY NEWID();

    SET @Counter += 1;
END;

-- Create Table2
CREATE TABLE Table2 (
    Name varchar(100),
    Age int
);

-- Insert random data into Table2 using English names
SET @Counter = 1;

WHILE @Counter <= 10000
BEGIN
    INSERT INTO Table2 (Name, Age)
    SELECT 
        Name,
        ABS(CHECKSUM(NEWID())) % 100 + 1 -- Random age between 1 and 100
    FROM 
        EnglishNames
    ORDER BY NEWID();

    SET @Counter += 1;
END;

-- Create Table3
CREATE TABLE Table3 (
    Name varchar(100),
    Age int
);

-- Insert random data into Table3 using English names
SET @Counter = 1;

WHILE @Counter <= 10000
BEGIN
    INSERT INTO Table3 (Name, Age)
    SELECT 
        Name,
        ABS(CHECKSUM(NEWID())) % 100 + 1 -- Random age between 1 and 100
    FROM 
        EnglishNames
    ORDER BY NEWID();

    SET @Counter += 1;
END;

 


 

Sustainability and Tech – Do you have a role to play?

Sustainability and Tech – Do you have a role to play?

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

Last month, I presented at Women in Tech Global Conference on the topic. During the conference and afterwards, I received a lot of queries on:


 



  • Do I as a Technologist have a role to play in ‘Sustainability’?

  • What is Technology’s role in Sustainability?

  • How is Technology getting influenced by ‘Sustainability’?


In this blog, I am answering these frequently asked questions.


 


We often relate to Sustainability as an initiative or agenda through which carbon footprint of any product is shared and some organizations share their commitment to reduce the same.


 


Here is the high-level summary of the journey any enterprise or business function needs to take to become sustainable. It starts with measuring the current environmental impact of the business, which enables monitoring and leads to corrective action and thereby creating a difference by minimizing environmental impact.


 


AditiGarg_0-1689362164248.png


 


What is ‘Environmental Impact’? Carbon emissions, Waste generation, water consumption and land use are key impacts to ‘Environment’ that any industrialization process brings along, digital technology included.


 


To make this relatable, and understand how sustainability can be factored into every business process, let’s wear a hat of Garments industry Customer.


 


Just imagine, you come across a great deal (in terms of price):


 









AriyaKhamvongsa_0-1689370657511.png

 



Your deciding factors primarily will be:



  • Value of Product

  • Price, you pay for it (in terms of money) 



 


Now what if some additional information is provided: 


 


AriyaKhamvongsa_1-1689370657127.png


 


With this additional information, the decision of purchase will add an entirely new dimension, to consider the ‘Environmental Impact’ of this purchase decision. It will add additional factors:



  1. Is the ‘Environmental Impact’ of this product worth the value?

  2. What are the alternative options?

  3. How can I maximize the usage of this product to minimize the ‘Environmental Impact’?


 


This transparency will lead the Garment manufacturers to explore the best available options across their whole business process from sourcing through manufacturing, distribution, and operations to ensure minimal environmental impact, there by staying competitive. This leads to prioritization for Sustainability at each stage of business enabled by technology.


 


To summarize, if we start measuring and sharing the environmental impact of every business, this will lead to consciousness and drive towards minimizing the impact.


 


These insights will lead to efficiencies across the product lifecycle leveraging the overall ecosystem. Each participant in this ecosystem has a role here in terms of sustainability, be it producer, operator, or consumer.


 


On the same lines, as a technologist we need to know:



  1. What is the environmental impact of the business application we are supporting / leveraging?

  2. How is this impact compared to other products available in the market?

  3. How can you optimize the usage of these products, thereby minimizing the ‘Environmental Impact’?


So, whether you are a technology consumer or producer, we all have a role to play to ensure environmental impact is taken into account at every decision point.


 


We all have a role to play and responsibility here.


 


Who can leverage these solutions and resources?


Any technology customer needs to be conscious about the environmental impact their business is generating, thereby making a conscious decision during every stage of their business, be it procurement, operations, customer support or even disposition.


 


As of now this is heavily prioritized by the regional and industry-based compliance and competitive landscape, but it is not far that every business decision will be made with awareness and consideration of impact and responsibility towards the environment.


 


All these products and offerings enabling Sustainability awareness and transparency are at initial stages right now but are developing on rapid pace owing to the growing awareness and demand of having this transparency in addition to the Dollar price.