Archive for the ‘Microsoft Dynamics CRM’ category

Dynamics 365 Wave 2 April 2020 start planning……..

January 28th, 2020

The first release wave of 2020 for Dynamics 365 in April will contains hundreds of new features across Dynamics 365 applications including: Sales, Marketing, Customer Service, Field Service, Finance, Supply Chain Management, Human Resources, Commerce and Business Central.

During April 2020, Microsoft will turn on all environments to receive the 2020 release wave 1 features.
The updates will be deployed on your environments automaticallyfollowing their Safe Deployment Process (SDP).

Dynamics 365 Finance, Dynamics 365 Supply Chain Management, or Dynamics 365 Commerce:
- You can configure the maintenance day and time windows in Lifecycle Services (LCS).
- You’ll receive an email if you opt in to receive LCS notifications.
- You’ll be able to select the designated tier 2 sandbox for the update.
– The sandbox environment will be updated followed by the production environment.

You’ll have five business days for testing and validation.

So its important to consider testing and training with previews beforehand.

If you need consulting resources to assist, with testing and training in new features during April there is only a 5 day window and all customers will be upgraded in April so plan ahead to schedule any consulting resources you may need,

The downloadable PDF will be available on January 31, 2020.
Highlights from Customer Engagement applications include:
Dynamics 365 Sales continues to focus on user experience and sellers productivity improvements.
Dynamics 365 Sales Insights expands focus to include inside sales scenarios and enhances conversation intelligence capabilities. New features include deeper conversation analysis with emotion detection to enable sellers with the information they need, when they need it.
Dynamics 365 Customer Service expands agent productivity tooling to help organizations evolve a proactive and predictive service model.
Dynamics 365 Customer Service Insights optimizes the customer service experience through AI with new capabilities including richer integration with Power Virtual Agents and access to the insights data for in-depth analytics.
Dynamics 365 Field Service improves effectiveness through a new resource scheduling dashboard, integration with Dynamics 365 Supply Chain Management, and technician time entries.
Dynamics 365 Marketing remains focused on enabling marketers by enhancing product usability, personalized marketing capabilities with dynamic content for contacts, and integration scenarios with third-party content management systems and Microsoft Forms Pro.
Dynamics 365 Customer Insights enhances data profiling enrichment and segmentation capabilities, helping organizations better understand their customer data and derive actionable insights to drive business processes.

Highlights from Dynamics 365 Operations, Finance, Commerce, and HR applications include:
Dynamics 365 Human Resources expands capabilities for human resources professionals, employees, and managers in leave and absence and benefits management programs.
Dynamics 365 Commerce strengthens the personalized, omni-channel experience for consumers by adding e-commerce, providing smart product recommendations, and enhancing clienteling.
Dynamics 365 Fraud Protection helps merchants increase revenue and reduce fraud losses and costs while improving the consumer’s online check-out experience by releasing two new services, account protection and loss prevention.
Dynamics 365 Finance releases enhancements to: country-specific tax, invoicing, payment formats, and regulatory reporting capabilities to help global organizations stay compliant with newly introduced local regulations.
Dynamics 365 Supply Chain Management helps organizations reduce operational costs by: introducing customer self-service experiences, enhancements to asset management, and the new on-hand inventory service for inventory visibility across Dynamics 365 and other legacy systems.

Power Platform
New Power Platform capabilities combine Power BI, Power Apps, Power Automate, Power Virtual Agents, and the Common Data Service into an unmatched palette of tools to analyze data, build solutions, and automate processes. This release includes robotic process automation (RPA) capabilities in Power Automate, to automate rule-based tasks with point-and-click simplicity supporting on-premises or cloud-based apps.

Power Apps gains significant improvements for developers of all skill levels, improving the sophistication and usability of apps that are created across the web and mobile devices.

Microsoft business intelligence simplifies how organizations derive insights from transactional and observational data. It helps organizations create a data culture where employees can make decisions based on facts, not opinions. In this release wave, Power BI invests in four key areas including: intuitive experiences, a unified BI platform, big data analytics, and pervasive artificial intelligence (AI).

Early access available Feb 3, 2020
Test and validate new features and capabilities that will be a part of the 2020 release wave 1, coming in April, before they get enabled automatically for your end-users

General availability April 1, 2020 Production deployment for the 2020 release wave 1 begins. Regional deployments will commence on April 3, 2020.

Model-driven apps in Dynamics 365: The 2020 wave 1 release does not apply to customers of Dynamics 365 Customer Engagement (on-premises). The 2020 release wave 1 release will be applicable for the customers of both commercial and the Government Cloud.
Dynamics 365 Finance, Dynamics 365 Supply Chain Management, Dynamics 365 Commerce, or Dynamics 365 Business Central: The 2020 wave 1 release is applicable for customers of Finance + Operations (on-premises) as well. You can opt in to preview the new functionalities similar to online.
industry accelerators are included in this wave:

Nonprofit accelerator enables you to develop nonprofit solutions based on entities and attributes that nonprofits commonly leverage for constituent management, fundraising, awards, program delivery, and impact tracking.
Financial services accelerator enables you to quickly develop solutions based on entities and attributes that banks commonly leverage for customer experience and other business processes. These entities include banks, branches, financial products, loans, referrals, limits, requested facilities, and more.
Health accelerator allows you to build solutions and create new use cases and workflows with entities focused on enhanced care coordination and the ability to segment patients and providers based on Electronic Medical Record (EMR) data.
Automotive accelerator enables you to quickly develop solutions based on entities and attributes that dealerships and OEMs commonly leverage for customer experience and other business processes. These entities include deals, sales contracts, specifications, fleet, warranties, inspection, test drives, branding, business, customer-vehicle relationship, vehicle and equipment, lead, service and after-sales management, and more.

End of support deadlines -Microsoft

January 15th, 2020

Businesses running Microsoft’s business software are facing all sorts of end-of-support deadlines at the start of 2020.

Major premises-installed business products are falling out of “extended support” this year, which means they’ll no longer get patches, including security updates, from Microsoft. It’s considered potentially risky to continue to use such “unsupported software” after their end-of-support milestones.

IT pros may have already reacted to address many of these milestones, but some workloads remain as problems to address.
Crashing deadlines are very near this month for organizations using Windows 7 and Windows Server 2008, but other important milestones loom, as well.
Windows 7 Client and Server Deadlines – Jan. 14, 2020 end-of-support date for Windows 7. That support deadline also applies to Windows Server 2008/R2, Dynamics CRM 2015, Dynamics GP 2015 R2, Dynamics NAV 2015,Dynamics SL 2015.
Later this year Office 2016 , and Outlook 2016 versions will also go out of support.

Be prepared for Potential Iranian Cyberattacks

January 10th, 2020

The drone attack as Suleimani was visiting Baghdad last week is widely expected to prompt counterattacks of some sort from Iran, with Iranian leaders vowing as much in recent days. One of the most rapid ways that Iran can respond is through attacks on computer systems of U.S. businesses and government agencies

The U.S. agency in charge of cybersecurity urges organizations in the United States to prepare for potential attacks from Iran in response to the American drone killing of General Qassim Suleimani.

The Cybersecurity and Infrastructure Security Agency (CISA) issued its warning, “Potential for Iranian Cyber Response to U.S. Military Strike in Baghdad,” on Monday afternoon. CISA is a federal agency created in 2018 to coordinate with other government entities and the private sector on cybersecurity and critical infrastructure protection.

The drone attack as Suleimani was visiting Baghdad last week is widely expected to prompt counterattacks of some sort from Iran, with Iranian leaders vowing as much in recent days. One of the most rapid ways that Iran can respond is through attacks on computer systems of U.S. businesses and government agencies. However, proxy attack on perceived USA allies, or major USA technology firms also have to be considered.

A key feature in your defence is the way your anti malware software handles unknown files. All Ransomware/Malware starts as an unknown file. Older protection software uses a detect and remediate approach to stop it. Basically, a default ‘allow’ policy, because they let unknown files come into their system and then try to stop the effect. This is a problem because hackers make new malicious codes every single day, and rely on signature based detection methods.

We offer a solution with a default ‘Deny’ approach. Our auto-containment features is a patented and the one-and-only technology that renders malware useless and to date the Platform and Auto Containment.
has 0 breaches.

With growing and ever more sophisticated and expensive attacks, and increasingly stringent legislation such as GDPR with swinging data breach penalties, the risks of international war by cybercrime have gone up another notch.

If you need to boost your defences then contact us on 0097143365589

Power BI update -Gateway recovery key, move to .Net framework 4 – Ask Synergy Software Systems, Dubai’s Power App specialist.

December 5th, 2019

The November update for the On-premises data gateway (version 3000.14.39) is released.

Change Gateway Recovery Key
The recovery key provided by gateway admins during installation of on-premises data gateways in a standard mode could not be changed in the past. This key is used to create the symmetric key which in turn is used for encrypting credentials in data sources/connections using that gateway. With the November release of Data Gateways, you will now be able to rotate this key. More information about recovery keys, detailed description on how to perform this change and associated limitations can be found in the data gateway docs.

November version of the mashup engine
This month’s Gateway update also includes an updated version of the Mashup Engine. This will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/runtime as in the latest Power BI Desktop version.

Please note that this upcoming change may impact you:
PB1 will be using .NET 4.8 framework for gateways February 2020 version or higher hence some of the operating systems it used to support may no longer be supported. i.e. for many this change will also force a Windows update.

All .NET Framework versions since .NET Framework 4 are in-place updates, so only a single 4.x version can be present on a system.
In addition, particular versions of the .NET Framework are pre-installed on some versions of the Windows operating system. This means that:
• If there’s a later 4.x version installed on the machine already, then you can’t install a previous 4.x version.
• If the OS comes pre-installed with a particular .NET Framework version, then you can’t install a previous 4.x version on the same machine.
• If you install a later version, you don’t have to first uninstall the previous version.
• The .NET Framework requires administrator privileges for installation.

Windows Server 2008 and 2008 R2 support will end January 14, 2020- ask Synergy Software Systems about options.

November 16th, 2019

On January 14, 2020, support for Windows Server 2008 and 2008 R2 will end. Only 2 months away
That means the end of regular security updates.

Don’t let your infrastructure and applications go unprotected.

We’re here to help you migrate to current versions for greater security, performance and innovation.
009714 3365589

Azure Arc in preview manage hybrid data across cloud platforms……

November 16th, 2019

Now in preview, Azure Arc helps simplify enterprise distributed environments by managing everything via Azure services (like Azure Resource Manager). Connecting hybrid infrastructure via Azure Arc improves security for users via automated patching, and provides improved governance, with everything ‘under one roof’. Azure Arc, a tool that lets organizations manage their data on: the Microsoft Azure cloud, Amazon Web Services (AWS), Google Cloud Platform or any combination.

Microsoft says that deployments can be set up “in seconds” via Azure data services anywhere, a feature of Azure Arc.

Azure Arc also supports Kubernetes clusters and edge infrastructures, as well as on-premises Windows and Linux servers.
No final release date yet but there is a free preview of Azure Arc .


Azure Synapse – BI for petabytes of data

November 11th, 2019

Microsoft introduced Azure Synapse Analytics last week as , the “next evolution” of Azure SQL Data Warehouse.

It promises better performance and more capabilities, than Azure SQL Data Warehouse, and existing customers will “automatically benefit” from the enhancements that are now in preview.

Azure Synapse is a “limitless” analytics service, and accommodates all data warehouses, data lakes, machine learning, and BI needs, either with a serverless or provisioned resources approach.

Among the benefits of Synapse:
• The service can query both relational and non-relationship data using SQL
• It can “apply intelligence” over all data, including Dynamics 365, Office 365 and SaaS services that support the Open Data Initiative
• It offers a unified experience for data prep, data management, data warehousing, big data, and AI
• Privacy and security features include: automated threat detection, always-on data encryption, column level security, and dynamic data masking

In an Ignite demo, Rohan Kumar, Microsoft corporate vice president for Azure Data claimed a petabyte scale query across multiple data sources ran in Synapse in 9 seconds, versus over eleven minutes in Google’s BigQuery. He also claimed that both AWS Redshift and BigQuery degrade more as concurrent load increase

Micorsoft Power Platform Enhancements -ask Synergy Software Systems

November 11th, 2019

• Microsoft Flow is renamed to Microsoft Power Automate, to better align with the Microsoft Power Platform.
Robotic process automation (RPA) is added to Microsoft Power Automate, to deliver end-to-end automation solutions that span AI, APIs, and UI on the Microsoft Power Platform.
Microsoft Power Virtual Agents—a no-code/low-code app that allows anyone to create, and to deploy, intelligent, AI-powered, virtual agents.
Many security enhancements for Microsoft Power BI, no matter where analytics data is used and accessed.
Microsoft Power Platform and Microsoft Teams, As organizations encourage a data-driven culture, it’s important they break down silos and ensure that the right people in the organization have the data they need to be involved in the decision-making process. Teams and Power Platform brings together the best of workplace collaboration and data-driven business into one place.

Power Platform applications dashboards, apps, and automations are available within Teams, so they are easier to find, share, and use on an everyday basis. The conversational nature of Teams enhances how users interact with Power Platform applications. Adaptive cards and bots let users engage with these tools directly through conversation. This integration gives IT Administrators high fidelity control and prioritization of features.

Power Apps creators can publish their apps directly to their company’s app library in Teams. By the end of 2019, users will be able to pin Power Apps to their Teams left rail, to provide easy access to regularly used apps.

New triggers and actions for Power Automate are available within Teams to streamline the completion of common team and personal tasks, such as scheduling focus time, and automating document approvals.

New features coming to Power BI next year include the ability to create rich adaptive cards in Teams conversations, to help users see and act on their data. An improved Power BI tab experience in Teams will make it easy to select the correct reports..

The American Red Cross is leveraging Power Platform integration with Teams to improve disaster response times.

• New, prebuilt models for AI Builder to add more advanced AI models to Microsoft Power Automate and Microsoft Power Apps.

These new features and products provide the Power Platform with an unmatched set of capabilities that enable everyone to: analyze, act, and automate across their organization, so as to transform businesses from the ground up.

SnapLogic iPasS integration as a service – from Synergy Software Systems.

October 20th, 2019

Business Intelligence Managers/Analysts, Data/ETL Engineers, and Information/Data Architects are tasked with empowering business users to make use of
data to drive smart decisions and innovations. Data-driven initiatives can be challenging considering the explosion of data volumes due to the proliferation of sensors, IoT, and mobile computing.

Moreover, a growing number of groups within the business want access to fresh data.

To fully harness their data, organizations must also have a cloud strategy for their digital transformation efforts, namely to migrate data from
on-premises environments to the cloud. Considering the tremendous business value of unlocking that data, it’s imperative to prioritize and streamline these
data integration and migration projects.

Gone are the days when IT needed hundreds of coders to build extract, transform, load (ETL) solutions and then maintain those by writing more code. Modern integration platforms eliminate the need for custom coding. Now, data integration projects deploy and scale, often as much as ten times faster.

iPaaS platforms ease the pain because they’re designed for flexibility and ease of deployment for any integration project. A drag-and-drop UX coupled with a powerful platform and hundreds of pre-built connectors out of the box.

The connectors are always up-to-date, so the IT organization doesn’t spend an inordinate amount of time maintaining every integration by hand. This saves an incredible amount of time, money, and frustration across the team and projects and greatly reduces risk.

Not all integration platforms are created equal. Some do simple point-to-point cloud app integrations while others transform large and complex data into a data lake for advanced analytics. Some stgill require extensive developer resources to hand-code APIs while others provide self-service, drag-and-drop offerings that can be used by IT and business leaders alike. Some are best for specific tactical projects while others provide a strategic, enterprise-wide platform for multi-year digital transformation projects.

Organizations must address four key steps during the data migration and integration process:
1. Capture data that supports both the known use cases as well as future undefined use cases (think IoT data to support a future machine learning
enabled use case).
2. Conform inbound data to corporate standards to ensure governance, quality, consistency, regulatory compliance, and accuracy for downstream
consumers.
3. Refine data for its eventual downstream application and/or use cases (once its been captured and conformed to corporate standards).
4. Delivery of data needs to be broad and prepared to support future unknown destinations.

For decades, IT has been tasked to manage integration projects by writing tons of custom code. This onerous task is even more complex with the proliferation of SaaS applications, the surge in big data, the emergence of IoT, and the rise of mobile devices. IT’s integration backlog has exploded. Not only is the deployment too much work, but there is a growing cost to maintain all of the integrations.

Deploying a tactical or departmental data warehouse solution should take days, not months. Moreover, enterprise-wide data transformation projects should take months, not years.

The best data integration platforms:
- Support multiple app and data integration use cases across cloud, on-premises, and hybrid deployments
- Offer the flexibility to be used in cloud, hybrid, or on-premises environments, regardless of the execution location
- Provide a self-service user experience aided by AI, machine learning, hundreds of pre-built connectors, and integration pipeline
templates (patterns) resulting in greater user productivity, and faster time-to-integration
- Have an underlying, scalable architecture to grow with evolving data and integration requirements
- Support different data modes such as streaming, event-driven, real-time or batch

The SnapLogic iPaaS offering is functionally rich and well-proven for a variety of use cases. It supports hybrid deployments and provides rich and differentiating features for analytics and big data integration (Hadooplex). Clients score SnapLogic as above average for cloud characteristics, functional completeness, ease of use and ability to meet SLAs.” Gartner

SnapLogic is a U.S.-based integration platform company. In mid-2013, it transitioned from a traditional software business to an iPaaS model with the release of the SnapLogic Elastic Integration Platform which provides a large set of native iPaaS capabilities that target the cloud service integration, analytics and big data integration use cases.

The flagship Enterprise Edition features a set of base adapters (Snaps), an unlimited number of connections and unlimited data volume.

Synergy Software Systems has been an Enterprise Solutions Integrator in the GCC since 1991. We are pleased to announce our formal partnership to represent Snap Logic in the MEA region.

Do you need to integrate with Azure? with SAP Data Warehouse Cloud? with Workday? With Odette compliant auto mamufacturers………..?.

To learn more call us on 009714 3365589

SQL Server 2016 SP2 CU10 – (it fixes CU 9)

October 10th, 2019

SQL Server 2016 SP2 CU10 is essentially a fixed version of CU9.

Microsoft added a note to the KB article to holdoff on CU9, and now…that CU9 KB article page has vanished altogether.

So CU9 is dead to Microsoft, Everything we said about CU9, is replaced by CU10.

Dynamics Ax 2012 and Ax 2009 -time for a Synergy Software Systems Health check?

October 8th, 2019

Many Dynamics Ax customers are still to make the transition to Dynamics 365.
Upgrading an Enterprise erp system needs planning, and executing across multiple companies and geographies needs time and resources. There may be extensive vertical solutions to upgrade from layered code to extensions and he company may already be involved with other projects.

Meanwhile its current systems need to be optimised, maintained and leveraged to support new disruptive challenges. Over time, experienced skilled staff from the initial implementation move on and new staff don’t get quite the same training.. That second phase project didn’t happen.
- Maintenance schedules slip.
- New System managers have not been trained.
- Critical patches and kernel updates have not been applied.
- System setting are no longer appropriate for the new data and transaction volumes and ways of working.
- System response seems slower, there are more problems with record locks and system hang.
- Users and managers get frustrated.
- Auditors question the data.
- Meanwhile cybercrime is at an all time high.

Ax 2009, Ax 2012 RTM, Ax 2012R1 and Ax 2012 R2 are already past end of Microsoft support.

Many Ax 2012 R3 will also not be upgrading for at least another year and need to get more from their system.

Your Dynamics AX ERP system is an important investment that is central to the efficiency and profitability of your business. Determining when and why it is appropriate for your organization to undergo a thorough system audit and health check can be complicated. In some instances, a business may not have the proper resources or expertise to conduct a system analysis.

Business decision makers and managers within an organization are susceptible to overlooking critical issues and process gaps because of their close proximity to the business operations. That is why our unbiased insights are so beneficial.

Our System Health Check for Dynamics AX consists of a thorough analysis of various process-related activities and system hardware and resources to identify the source of performance problems. These include: inadequate hardware, improperly configured resources, bad network architecture or poorly written system customizations.

System Health Check:
Evaluate system performance and resources
Review key configurations
Review the management of SQL, log files and history data.

System Audit:
identify process gaps within the system.
Identify unused features
Review how well the system configuration and account structure support the business needs.
Review user issues, and auditor comments.
Security

Development Audit:
Best practice code checks
Slow running reports and queries.
Batch case and workflow management and performance

User audit:
training level, use of system features, attitude /experience, access controls to do what is needed.
Data audit: errors, consistency checks, orphaned records, accounts balance with sub ledgers

In a few days we show you whether you can move forward with confidence, or how to recover a ‘distressed’ project. We deliver on time and on budget – don’t take our word for it ask our customers, ask Microsoft.

We have helped major companies audit struggling implementations, of Microsoft Dynamics Ax and taken them to the next level.

04336889

Legacy web client for Dynamics 365 CRM will be deprecated. New D365 Unified Client ask Synergy Software Systems, Dubai

October 3rd, 2019

On the 10th September 2019, Microsoft announced the legacy web client for Dynamics 365 CRM will be deprecated. Customers must transition to Unified Interface before October 1, 2020.
This will affect Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, Dynamics 365 Project Service, and Dynamics 365 Marketing customers.
According to Microsoft, they will “continue to provide support, security, and other critical updates to the Dynamics 365 legacy web client until October 1, 2020, but will not release any additional functionality beyond what has already been announced.”
In addition, the following capabilities will also be removed from Dynamics CRM solutions by October 1, 2020:
• Process dialogs
• Task flows
We expect other current functionality to also be deprecated within the next year.
New features include:
• Form Updates
• Entity Based Dashboards
• Business Process Flows
• Role Based Apps and Views
• Navigation and Views
• Panels and Subgrids
• Timelines
• Artificial Intelligence
Contact us for an upgrade analysis. We’ll help you consider the information you need before you transition to the new UI including:
• High-level state of your current CRM system
• Cloud and mobile strategy
• Usability
• List of all third-party ISVs
• User processes
• Tenant analysis
• Deployment methodology
• License changes from 1 Oct 2019

Dynamics 365 release wave 2 October 2019

October 2nd, 2019

In August, Microsoft brought Dynamics 365 2019 release wave 2 to early access. Initially, 74 new capabilities were showcased, targeting various applications that are part of Microsoft’s enterprise resource planning suite of services. These applications include Dynamics 365 for Sales, Marketing, Customer Service, Field Service, Finance and Operations, and Retail, as well as the Power Platform which comprises of PowerApps, Flow, and Power BI.

We recently posted about new licensing changes.
At the same time this latest release wave is now generally availabile,

It brings over 400 new capabilities and feature updates to users – one of the largest ever update plans for Dynamics 365.

Microsoft has invested billions of dollars in AI research to bring insights to everyone in context of the task at hand—a key to transforming from a reactive to proactive organization. New AI-powered insights applications were also released last week, including: Dynamics 365 Product Insights, Commerce, and Connected Store.

Additional capabilities for already existing services were also introduced.

Moreover, Dynamics 365 Fraud Protection is also generally available starting today.

Power BI, gets new features every month. We now have a unified platform for enterprise BI, and self-service analytics for all.
•Unified platform for enterprise BI •Data Protection (Preview)
•Shared and Certified Datasets
•Data lineage capabilities (Preview)
•Open platform connectivity (XMLA Read/Write) (Preview)
•Datasets larger than 10GB in Power BI Premium (Preview)
•Admin usage metrics
•Unattended Power BI template app installation

•Self-service analytics for everyone •New experience for report consumption
•Home customization
•Mobile Home

Other apps on the Power Platform are also have updates, with AI Builder for Powerapps and Flow reaching general availability. Administrators benefit from richer tooling, such as PowerShell Command lets (cmdlets) and the new Power Platform Admin Center.

https://dynamics.microsoft.com/en-us/business-applications/product-updates/

SQL Server 2016 Service Pack 2 SP2 CU9 release

October 1st, 2019

Cumulative Update package 9 (CU9) (build number: 13.0.5470.0) for Microsoft SQL Server 2016 Service Pack 2 SP2 is now aavilablefor download. (It contains fixes that were released after the initial release of SQL Server 2016 SP2.)
SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence. Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.

The CU provides the following fixes and improvements (Referenced from https://support.microsoft.com/en-us/help/4100997/cumulative-update-9-for-sql-server-2016-sp1)

KB4099472 – PFS page round robin algorithm improvement in SQL Server 2016 SQL service
KB4133164 – FIX: Error when a SQL Server Agent job executes a PowerShell command to enumerate permissions of the database Management Tools
KB4086173 – FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Analysis Services
KB4131193 – Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016 SQL service
KB3028216 – FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS Analysis Services
KB4135113 – FIX: Change tracking record is inconsistent during an update on a table which has a cluster/unique index in SQL Server SQL service
KB4293839 – FIX: TDE database goes offline during log flush operations when connectivity issues cause the EKM provider to become inaccessible in SQL Server SQL security
KB4230730 – FIX: A dead latch condition occurs when you perform an online index rebuild or execute a merge command in SQL Server SQL service
KB4163478 – FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server SQL performance
KB4230306 – FIX: Restore of a TDE compressed backup is unsuccessful when using the VDI client SQL service
KB4163087 – FIX: Performance is slow for an Always On AG when you process a read query in SQL Server SQL service
KB4164562 – FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server Data Quality Services (DQS)
KB4094893 – FIX: Database cannot be dropped after its storage is disconnected and reconnected in SQL Server SQL service
KB4162814 – FIX: An internal exception access violation occurs and the SSAS server stops responding Analysis Services
KB4134541 – FIX: Error in the MDS Add-in for Excel when you use the German version of Excel in SQL Server Data Quality Services (DQS)
KB4132267 – FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode Analysis Services
KB4101554 – FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error High Availability
KB4098762 – FIX: Hidden parameters are included in reports when the Browser role is used in SSRS 2016 Reporting Services
KB4134175 – FIX: Processing a cube with many partitions generates lots of concurrent data source connections in SSAS Analysis Services
KB4091245 – FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016 SQL performance
KB4094706 – FIX: One worker thread seems to hang after another worker thread is aborted when you run a parallel query in SQL Server SQL service
KB4058175 – FIX: TDE enabled database backup and restore operations are slow when the encryption key is stored in an EKM provider in SQL Server SQL service
KB4131960 – FIX: An access violation occurs when you execute a nested select query against a columnstore index in SQL Server SQL Engine
KB4094858 – FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server Analysis Services
KB4101502 – FIX: TDE enabled database backup with compression causes database corruption in SQL Server 2016 SQL service

CUs also often include supportability, manageability, and reliability updates.

Before udpate:

- Check compaitbiltiy with your application.
- Test CUs before you deploy to production environments.

Dynamics 365 license changes 1 October 2019 – are you ready?

September 28th, 2019

October 1, 2019 is the effective date for the beginning of Microsoft’s new licensing program for Dynamics 365. While the new pricing model kicks in on October 1, for new customers, existing customers will also transition to the new model at their next annual renewal. For example, if you just completed the annual renewal of your licenses on August 1, your licensing fees will not change until August 1, 2020.

Dynamics 365 will no longer offer multi-application bundles, for Customer Engagement (CE) and Unified Operations (UO) plans. Instead, they will adopt an ‘a la carte’ menu from which to select the licenses of individual apps.

Part of the change involves separately licensing features as ‘base models’ e.g. for Dynamics Finance and Operations Enterprise the enterprise base licensing options will be Supply Chain, or Finance, or Retail. Users who need the functionality of more than one base license can add the same features to an existing base license as an “Attach’ license at a significantly lower cost for the additional attach license.


The licensing for: Talent. and Marketing and Customer Insights are also affected but are a little different;

Microsoft suggests the overall effect will be around a 10% price increase.
Note there are also significant changes to the Power apps licenses.
That of course also reflects their rising costs of providing hosted services and considerable increases in system enhancements. It is however important you carefully consider who needs to use which application and features to ensure your license cost is optimised.

This note only scratches the surface and every Dynamics 365 customer will have a different set of requirements. Don’t wait for your subscription, renewal work with us now to better understand the changes to prepare and budget accordingly.

At the moment no changes have been announced for on premise licensing.
Activity users. Sales Professional, Customer Service Professional, and Team Member licensing will remain unchanged.

There are licensing options for:
• Additional environments
• Additional database capacity
• Additional file storage

Dynamics 365 Add-ons
Subscription add-ons apply across a single tenant; they are not tied to a specific user.
Subscription add-ons can be purchased at any time and remain a part of the subscription for the remainder of the subscription term.

Microsoft Power BI in Dynamics 365 – Dynamics 365 Unified Operations Plan and Dynamics 365 Plan
Users are not provided with any standalone or general-purpose Power BI license or use rights. Customers who require Power BI Pro will need to license and pay for it separately.
The Dynamics 365 Unified Operations applications themselves may embed Power BI content within the service User Interfaces. This is simply a product feature and no Power BI licensing is required to access this content (e.g. view embedded tables and charts)

Additional Common Data Service Capacity Add-ons
Common Data Service platform capacity add-ons gives flexibility to increase the storage capacity associated with your PowerApps subscription in increments of 1GB per additional capacity add-on license.

Subscription storage
Storage corresponding to a customer subscription is tracked against all the Dynamics 365 Customer Engagement Plan application instances associated with the tenant.
The following add-on capacity licenses are available:
• Additional Common Data Service Capacity Add-on:
• Additional Common Data Service File Capacity Add-on
• Additional Common Data Service Log Capacity Add-on

Dynamics 365 for Marketing Additional Contacts Add-on
Dynamics 365 for Marketing is based only on the number of contacts intended to be used for marketing activity and not the total number of contacts in database. Minimum purchase quantities must be met to activate packs. Customers with Dynamics 365 for Marketing included with Customer Engagement Plan application (2K contacts included), are required to purchase the Additional Contacts 8K add-on pack before purchasing any of the other Additional Contacts packs.

Microsoft Social Engagement Additional Posts Add-on
The Additional Posts Add-on may be purchased in increments of 10,000, 100,000, or 1,000,000 posts per month. On the first day of the month, the number of purchased additional posts is added to the included quantity of 10,000 posts. All unused posts expire at the end of each month.

Portals and Page Views Add-on
The default Portal provided with Dynamics 365 Customer Engagement Plan application be extended by purchasing licenses for additional portals, for use as a non-production additional production portals. Customers may purchase additional page views.

Dynamics 365 Call Intelligence Add-on
Conversation Intelligence, included capacity for Sales Insights, help sales teams gain insights from conversations with customers. Dynamics 365 Call Intelligence is a capacity add-on for Sales Insights that enables organizations to analyze additional hours of call recordings. Customers may purchase additional capacity (1k hours/tenant/month)

Dynamics 365 for Customer Service Chat Add-on
Customer Service Chat is an add-on capability for the Dynamics 356 Customer Service Enterprise application that helps agents engage in real-time with customers and resolve issues faster. Customer Service Chat is licensed per user and ensures that support agents and end users can interact effectively.

Use of historical Supervisor reporting through Omnichannel Intraday Insights, Omnichannel Chat Insights and Omnichannel Sentiment Insights Dashboards requires Power BI Pro license or higher.

Dynamics 365 for Field Service – Resource Schedule Optimization Add-on
- Resource Scheduling Optimization is an add-on capability for the Dynamics 365 for Field Service application that enables customers to automatically create a schedule for the appropriate resource in SharePoint, while simultaneously optimizing appointment setting for travel time, mileage, and many other constraints.
-Resource Schedule Optimization is licensed per resource included in the optimization process and will typically be accessed by a scheduler or dispatcher user who will designate any number of resources to be included. Resources may be individuals, such as field technicians or other human resources.
- The add-on license allows for unlimited use of schedule optimization, which may be on a regular cadence such as daily or weekly, or ad-hoc.
-A Dynamics 365 for Field Service license is required for managing the Resource Schedule Optimization.

Dynamics 365 Unified Operations – Order Lines Add-on
The Dynamics 365 for Operations – Order Lines Add-on allows customers to extend the use of their
application by providing a transactional licensing mechanism for indirect access by partners, customers,
connected automated systems, loT devices and bots. Dynamics 365 Unified Operations – Order Lines

For qualifying transaction types, customers will be able to license indirect access on a transactional ‘order line’ basis rather than on a per user basis
• Avoid common multiplexing licensing issues.
• Supports a broader set of external user integrations.
• Enables licensing of automated systems and devices that do not include users (e.g. IoT scenarios)
• Improves licensing cost transparency and predictability
• Ties licensing cost more directly with business outcomes

To be eligible for ‘order lines’ licensing a transaction must:
(i) Be an indirect transaction that utilizes an OData or DIXF integration. Direct usage of the Dynamics application or integrations outside of OData or DIXF may not utilize ‘Order Lines’ licensing.
(ii) Only update data in the tables designated as qualifying for Order Lines.