This session covers the SQL Server Agent, with its Jobs and Alerts, along with newer features like Database Mail and Extended Events (which is replacing Profiler). You can use SQL Jobs to schedule SQL Scripts and Database Maintenance Plans. Alerts can notify you when jobs or maintenance plans fail. Extended Events can help troubleshoot and improve performance. Profiler preceded Extended Events but hasn’t advanced since 2008. What are some pros and cons of using the independent SQL Server Management Studio with any version from SQL Server 2008 through 2019.

Learning Objective: Know how to have SQL Server send you an email when a backup job fails.                                                                                                                                                                                                                               This session will be available for CPE credits pending completion of session survey post event.

Level: Intermediate

How do you improve GP security without the pain of starting from scratch? Use our practical tips for Dynamics GP! In this fast-paced session, we’ll hit 50 tips designed to make GP more secure. These tips are practical and ready to be applied as soon as you get back.

This session is geared for an audience with a basic skill set.

This session will be available for CPE credits pending completion of session survey post event.

This is a powerful tool.  To often it is thrown in.  What to think about difference between menu groups and security groups for roll based access.  Learn what screens should be used and what the settings mean and effect on what the users see. 

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic

Role-based security and the concept of “Teams” are two of the powerful building blocks provided by D365 CE for a successful security design. Proper utilization of security roles requires an understanding of privileges, access levels, and how to properly setup your system organization hierarchy to serve as the dependable foundation. In this presentation, we will discuss how to modify out-of-box roles to create custom security roles tailored for your organization and how to utilize “Teams” for improved flexibility within your security hierarchy.The content of this session is geared toward an audience with beginner-level knowledge of the subject area.

Some companies allowed remote workers in the past, yet others have not until the Coronavirus arrived. Security and access to data, like the rest of your business processes, needs to now be looked at a bit differently. The good news is that it’s likely your company has many techniques in place already, or ready to implement. However, some controls are often overlooked, and a since ‘a chain is only as strong as its weakest link,’ it’s critical all security controls are addressed. Discover commonly overlooked controls and the steps to ensure security is not compromised with a remote work force.

The content of this session is geared toward an audience with beginner to intermediate-level knowledge of the subject area.

This session will be available for CPE credits pending completion of session survey post event. 

Do you really know what’s going on in your database? Are you sure you’re not affected by some of the most common data quality & integrity problems?

In this session, I’ll present some free tools and queries to find some of the less visible data quality problems and discuss how to fix and prevent them.

The content of this session is geared toward an audience with intermediate-level knowledge of the subject area.

How do you know who has access to what?  What are the best practices for managing your BC/NAV security? We’ll discuss how to create a good process to make sure employees can do what they need to and not what they aren’t supposed to.  This session will cover the steps required to set up a new user in BC/NAV.  We’ll also review the processes to assign permissions, manage user groups, set up warehouse security and how to create customized permission sets including a demonstration of the permissions recorder.  Bring your questions, real life stories, and be prepared to share how you manage BC/NAV security in your company.  This session will combine How-To presentations with interactive discussions to share best practices and fresh ideas.

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic 

We will discuss the myriad ways to do data repair in GP, we’ll cover normal repair scenarios and go through the best practices for advanced or complex data repair in GP.  We will also be reviewing the myriad tools at your disposal for ensuring you efficiently and accurately get the data repaired with low risk to your employer or client.  Some little known tools will also be shown (free tools) that you can use to your advantage for accurately repairing or cleaning up data!  Some of these tools will be given to you! Tons of tips, tricks and resources to help.

This session is geared for an audience with an intermediate skill set.

This session will be available for CPE credits pending completion of session survey post event.

When establishing security roles in Microsoft D365, it is important to institute a robust security design with minimal security risks resulting from Segregation of Duties (SoD) conflicts and excessive sensitive access. Failure to reduce SoD conflicts and needless SA will result in unexpected risks and audit findings due to a lack of checks and balances in place. The out-of-box security roles inherently contain security risks that when assigned to users, foster a risky environment. In this session, we will discuss security risks, security design, and how to implement the security roles in D365.

The content of this session is geared toward an audience with beginner to intermediate-level knowledge of the subject area.

This session will be available for CPE credits pending completion of session survey post event.

With the release of Azure Data Lake and surrounding technologies, it is easy to see why there is hope within the AX and F&SCM communities for a better reporting solution than BYOD. Attend this session to gain a fundamental understanding of what an ADL project may entail, its time frame, estimated cost, and the resulting reporting options available to finance teams to make meaningful business decisions. It’s always best to have clear visibility and understanding of the full implementation cycle before making an investment in a new technology.

Do you think this session is not applicable to you because you may not be using Dynamics 365 Commerce? Great news! You can start leveraging the power of Microsoft to start identifying areas of revenue loss without any pre-requisites Dynamics 365 projects!  Dynamics 365 Fraud Protection is one of the newest offerings in the Dynamics 365 family and focuses on increasing the online and instore revenues for retailers and wholesalers by providing actional insights and optimizations using the power of AI and ML.

In this session we discuss the purchase protection, account protection, and loss prevention capabilities of the software and how they relate to business processes and customer experiences. After discussing capabilities we’ll discuss how you can take next steps in evaluating the solutions for your organization and what would be involved in that assessment.

Come and join the Microsoft Fraud Protection product team, a Microsoft Global Black Belt for D365 for Commerce, and a Microsoft MVP in D365 for Commerce to learn more and help answer your questions and provide insights. For specific questions you would like to have discussed in the session, please submit them here: https://forms.office.com/Pages/ResponsePage.aspx?id=vBkjbhG_ikiYD5ihUwqy1cwGHWvSbyRInK_XR0SeKDxUME5DRlI0TTVFODY4UUtEQlhaS0ExNjJWVS4u

 To learn more, read about fraud protection here: https://dynamics.microsoft.com/en-us/ai/fraud-protection/

This session is a case study for designing and building an application security framework that supports the needs of a large manufacturing company, and also drives least-privilege access and business ownership of security roles and risks during a D365FO implementation. We will start with an overview of how U.S. Venture, Inc., designed its security roles by building a segregation of duties rule set, and creating compliant task-based roles as the foundation for ensuring appropriate access and proper control throughout the D365 environment. This presentation does not require detailed knowledge of D365 security.The content of this session is geared toward an audience with beginner-level knowledge of the subject area.

Data visualization through tools like PowerBI is now critical. You need to see how your business is running, and understand the dials to move for best performance. Dashboards are only as good as the data behind them. In this session, we’ll show you how you can mistakenly create what appears to be a useful dashboard in Excel or PowerBI, but isn’t relevant due to poor data management.  We will then walk you through best practices and tools for effective data organization and governance processes, so you can ensure you will walk away with accurate dashboards that will drive stellar results. 

This session will be available for CPE credits pending completion of session survey post event.

Level: Intermediate 

If you manage the security of your company’s data, while challenging, you also have the opportunity to be a champion for your company with the right tools. In this session, learn how Fastpath can help provide your company to answers important questions like: Do you know who has access to your data, what they are doing with that data, and the risks to your data? With the Fastpath Assure cloud platform, you can answer these questions and provide an internal control framework to meet your compliance needs. Get rid of manual, prone to error, security related tasks and replace them with solid controls around user access, segregation of duties, tracking changes to critical data, and setting up new users. Fastpath will help your company take your security by design to the next level. We also will review the native controls in Dynamics 365F&O/AX around security, showing where Fastpath can help fill gaps and improve efficiencies in security reporting. In today’s world, with GDPR, SOX, and ever-growing number of audits, having the right security and financial controls in place is more important than ever. This session will show how the Fastpath governance, risk, and compliance solutions can help your company become a security and compliance superstar.

How do you expand reporting when your GP SQL server is overloaded? Set up a new server…isnt that costly?  What if it was less than $100/month? Don’t we need a SQL DBA? No, with Azure Data Factory it’s easy for a business analyst with intermediate SQL skills to copy tables, transform data, and build sophisticated workflows. Power Platform offers similar capabilities, but you might need a full database where you can build views and stored procedures.

In this session, we will walk you through the process of installing a gateway and programming all the logic from the Azure portal.

This session is geared for an audience with an intermediate skill set.

This session will be available for CPE credits pending completion of session survey post event.

We all know the Data Lake and Azure Synapse is on Microsoft’s road-map for D365FO. Join Azure Synapse and Data Lake experts to learn more about this exciting technology and how it can transform you business into a data-driven organization!  Learn how the Canada Goose company is using these business intelligence tools enhance productivity in the company.

The content of this session is geared toward an audience with an intermediate-level knowledge of the subject area.

This session will be available for CPE credits pending completion of session survey post event.