10 September, 2020

Sitecore - [Dilithium] Data corruption in master

When using Unicorn to serialize the content and share it with team, there are times when you will end up having inconsistency with the data like having unversioned field data in versioned table in master DB. Because of this, you may get error like "Data Corruption" when you sync using Unicorn. 

[Dilithium] Data corruption in master://{fc5c3451-dfde-4778-9901-5d0b1da1e212}! Field 19a69332-a23e-4e70-8d16-b2640cb24cc8 (unversioned) had a value in the versioned fields table. The field value will be ignored.

When looking for a solution, I found Mikael has written a SQL script which will identify these inconsistencies and provide an option to remove the incorrect data. This will stop this data corruption error message. Thank you Mikael for the script.

01 September, 2020

View the list of installed .NET version

To get the list of .NET version in a windows machine, you can run the below command. 

Get-ItemProperty -Path "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\*", "HKLM:\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\*" | Where {$_.DisplayName -like '*.NET*' -and $_.DisplayVersion -like '4.*'} | Select-Object DisplayName, DisplayVersion

30 August, 2020

Access Host SQL Server from Virtual Machine

When using VMWare, you may be trying to access the SQL server in the host machine from the VM. Be default, SQL server remote connection is disabled and also the host machine firewall may be blocking the 1433 port which is normally used for SQL connection. In order to enable the firewall and the TCP port, you can follow the below steps mentioned in the SO.