Monthly Archives: April 2017

How to get the Windows 10 Creators Update

Microsoft is gearing up to roll out the Windows 10 Creators Update to everyone starting on April 11th. If the update is not yet available available for you under Settings -> Update & security -> Check for updates then you can get it manually.   Microsoft also offers the “Windows 10 Update Assistant,” which is a tool designed… Read More »

5 cents hint – c# split text by tab delimiter

if you ever need to split text file lines or other strings by tab delimiter then it it is easy :  

and done !

5 cents hint – Dump and restore MySQL database on WAMP server

For backing up and restoring MySQL database on WAMP server no fancy tools are needed. Out of the box command line tools will do all you need: Dump database : [path to wamp mysql bin directory]\bin\mysqldump -u[user]-p[password] [database name] > [destination file] For example C:\wamp64\bin\mysql\mysql5.6.17\bin\mysqldump -uroot -p mydatabase > c:\temp\mydatabase.sql   And restoring same thing back: [path to wamp… Read More »

DevExpress XtraReports – enable custom SQL for enduser report designer in code

By default DevExpress XtraReports  enduser report designer allows only creating SQL statements using Query Builder. Custom SQL statements are security risk and because of that they are not allowed by default. If you know what you are doing  and want to use custom SQL  statements then they can be enabled on Report Designer form. See closer documentation at DevExpress site.… Read More »