It's pretty simple but I didn't know this: TRIM ( '.,! ' FROM '# test .' )

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 -> Region ->

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!

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 :-)

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

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.

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.

Few months ago, after some big update of Win 10, I started to get annoying notifications: This message appeared randomly without any systematic causes. The system looked like this: I endured this for a long time but finally decided to fix it. And I had a plan to slice small piece from C: and extend E: to this piece. Note: disk D: is removable disk so C: and E: are on same HDD and they siblings :-) So I went to Disk Management to fix this and I saw this thing: E: drive hasn't major actions of another drives include "Extend Volume..." Anyway I sliced 2Gb from my C: drive with "Shrink Volume..." option. I got Additional unallocated space between C: and E: drives. After that I tried many "dances with tamburin around a campfire" - move E: after C:, allocate new space etc. Nothing didn't help. I know that there is limitations of built-in utilities of Windows and I started to search around the Net... All leads told me that I should use

So there is an evolution of this process - SQL script that import SQLite linked DB to MS SQL DB: declare @ temp table ( col1 varchar ( 255 ), col2 varchar ( 255 ), [ name ] varchar ( 255 ), [ type ] varchar ( 255 ), col3 varchar ( 255 ) ) insert @ temp exec sp_tables_ex 'Your_LinkedServer_Name' select * from @ temp And also open a cursor: DECLARE lstTables CURSOR FOR select [ name ] from @ temp

This is the working instructions to open SQLite DB in MS SQL or Access Creating a SQL Server Linked Server to SQLite to Import Data The main point is ODBC Driver declaration in System DSN. After this you can link the DB to MS SQL or open it in Access as well. The short list of steps: Install ODBC driver for SQLite ( http://www.ch-werner.de/sqliteodbc/ ) Create a System DSN for the DB file (via C:\Windows\SysWOW64\odbcad32.exe or odbcad64.exe) Create a linked server in SQL Server Just few remarks: Don't use spaces in System DSN name - it will be a problem to work with select queries in MS SQL It also opens as Access DB Despite of possibility to open DB in Access, an import from Access to MS SQL was failed because there are no fields detected during export procedure. It's sad...  For browsing of original file I used the recommended soft  DB Browser for SQLite

This is a first finished and published project today! :-) AliExpress Order Extractor

Company branded page was created today. Take a look! https://www.facebook.com/OxymoronTech

Today I did insertion of blog feed into the company site. That's how it looks: http://oxymoron-tech.oxy.co.il/Blog.aspx

This is Workspace 😎

This is my new office (Phase 1) 😎 The process: