Recent Posts

Financial reporting data mart reset issue

Background of the issue: After the successful restoration of production data into the sandbox environment (tier 2) tried to reset DataMart mart through PowerShell, but it failed with below error. Error detail: ” Table ‘Datamart.DimensionValue’ uses a clustered columnstore index. Columnstore indexes are not supported in this service tier of …

Read More »

Self-service deployment for Dynamics 365 for Finance and Operations

Last week (Dec14th, 2018) Microsoft has announced Self-service deployment for Dynamics 365 for Finance and Operations – For new customers only. Here are the few changes/highlights: Highlights: No longer have Remote desktop access to the Tier 2+ Sandbox environments No access to SQL server If you want to access SQL …

Read More »

Announcing the preview of SQL Server 2019

Content copied from Microsoft email: SQL Server 2019 is now available to preview. Take advantage of built-in advanced analytics and data lake capabilities and easily integrate data from multiple sources, including Oracle, MongoDB, and Teradata—without moving your data via extraction, transformation, and load (ETL). Learn more about this latest SQL …

Read More »

Microsoft Azure & Windows Servers