Alexander's Blog

I faced a problem from SSMS which doesn't show any error when I wanted to see the "Design" of a SQL Database's View. There is a similar post  here . I would say similar because my problem was a bit different than that post as my SSMS didn't even display any error, it just became "Not Responding" and closed itself automatically. There was an AccessViolationException when I looked into the event of that SQL application, such as the following (also similar stacktrace): The solution is ... the same with the solution in the post above :) My version of SSMS (2016) is older than the SQL Server itself (2017). Another good reference which I referred for getting the version information is this:  https://buildnumbers.wordpress.com/sqlserver/

Thanks to Sugcon India and all its sponsors, around a month ago, I was in ITC Gardenia, Bengaluru, India to give a presentation about the relation between Sitecore and MongoDB from Sitecore XP 8.2 to XP 9. I just realized that my session was recorded and is now publicly available as few days ago a friend of mine told me about that. Here is the video of my presentation. You might notice that not all the agenda in the slide is explained in the video, it is because the video is cut. If you would like to know more then please find the full slide of that presentation here .

Someone reported to me about the error System.Configuration.ConfigurationErrorsException: A connection string with the name 'xdb.processing.pools' is not configured. from their ma-ops server. When I first noticed that error, I immediately thought of configuring that connection string, however, Sitecore documentation on ma-ops ( https://doc.sitecore.com/developers/90/platform-administration-and-architecture/en/configure-a-marketing-automation-operations-service.html ) does not mention the need of having the connection string for “xdb.processing.pools”. While I was working on another seemingly unrelated task (installing Sitecore Commerce 903 in Azure), I found a serendipity where the installation guide of that SXC 903 ( http://commercesdn.sitecore.net/SitecoreXC_9.0/Installation-Guide/9.0.3/Sitecore_Experience_Commerce_Installation_Guide_for_Azure_9.0.3.pdf ) actually mentions this in the step 3 of the section “ 5.4. Enable Marketing Automation ”, as s