Posts

Error starting SQL Server 2017 service. Error Code 3417 - Fixed

It's already a third time I uninstall and install again SQL Server 2017 Dev version on my local computer... It's working fine for few days and than suddenly stop running with Error Code 3417: Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online. I tried many ways to fix this, including security changes on master.mdf and of course full re-install. Until suddenly I saw in MS SQL log file this error before the main error: Error: 2775, Severity: 17, State: 12. The code page 65001 is not supported by the server I went to find this error in Google and I found this article, where the author talked with himself about logs, errors, screenshots and questions about them. Until in the bottom of the article he wrote: Uncheck  Beta: Use Unicode UTF-8 for worldwide language support  in  Control Panel -> Re...

Please welcome our new application - ArtPlayBox!

Image
Hi all, Please welcome our first Android application ArtPlayBox ! It's designed for tablets but supports smartphones as well.  Reviews, stars and post shares will be very appreciated! :-) Thank you in advance!

Company Site Update

I make some changes in my site. The most of them is a prototype of universal content localization engine that can be applyed on web content without changes in DB or server-side code. It's a good start for Language Medium platform that is going to be easy and useful. NOTE: not all text content is localized to Russian right now - only menu, first section and few first Projects. It's becasue the engine is without BackOffice right now and all translations I'm adding  directly in DB:-) But don't worry - it will be soon B-) Also there are links to projects pages and some of them are real :-)

Remove items from list that appears in another list by ID

I tried many options and stopped on this one: lst1.RemoveAll(itemFromLst1 => lst2.Any(itemFromLst2 => itemFromLst2.ID == itemFromLst1.ID));

Pluralizing words in C#.Net

Today I wanted to create a dynamic title of a page according to name of category. Like "My Playlists", "My Libraries" etc. So there is a parameter of categoryID passing to page and I find category object accordingly. So there is a usage of .Net service: using System.Data.Entity.Design.PluralizationServices; .... Category category = Category.GetByID(categoryID); PluralizationService ps = PluralizationService.CreateService( new System.Globalization.CultureInfo( "en-GB" )); Page.Title = $"My { ps.Pluralize( category .Name) }" ; ..... Note : you need to add reference System.Data.Entity.Design to the project.

MongoDB Cloud Cluster Test

Today I performed initial basic test of  MongoDB Atlas  - it's MongoDB Cloud Cluster that can use different cloud providers. This process took me something like an hour to get my test system working. It's amaizing timing IMHO. And I'm happy to admit that I succesfully connect this cluster to .Net aplication using MongoDB Official driver - this part was not succeeded around an half a year ago in my previous company. Now I know the problem we faced there - it's incorrect connection string. Only incorrect connection string. And we failed. It's sad.... :-( P.S. As a client I used MongoDB Compass that is free and light but lack of major DBA features and UI. And I'm going to use something more powerfull, like Studio3T that I tried once and was very satisfied.

Information and methods to handle it

Image