OpenWrt – OS for embedded devices

Hi there,

If you are looking for some powerful SO for your routers, modems, repeaters I can say that you should give a try to OpenWrt. I tried it and I install in my two devices here:

TL-WA850RE-01[1]
TL-WA850RE
First I installed in my TL-WA850RE, using the default firmware and I had no issues. Set it up using the GUI Luci, and it worked well as expected. Seems that it works better than the original firmware, and I have way more options to set up this little repeater. Actually now it works like a regular router as well as a repeater. OpenWrt makes any device a repeater easily, I tested it with my second device.

 

 

TL-WR841N-01[1]
TL-WA850RE
My second device TL-WR841N, it’s a bit more powerful, but it has only 4MB of storage, and it is a problem sometimes when you want to install a custom software. I had installed the main latest trunk, it worked but I had no GUI. Then when I tried to install the GUI got issues with my storage. Using the forum I was able to find another way, and all is described in the forum, click here to check.

After installed the GUI I was able to set up my network quickly. Also it’s possible to make any regular router a repeater, I tried here and it works pretty well (look on YouTube how to set it up). Also I was able to define some host names, and point then to some specific IP address, make my local network more accessible.

OpenWrt also has a full dashboard to control what is going on in your network. If you like to change things and play with your devices I recommend that. Just be careful to not brick your devices, read the forum and act knowing that you may break something. Try to understand things before doing them, just it is enough. Good luck!

VSCode + Git – Step-by-Step

Hey guys, I’m amazed with VSCode, it’s simple and powerful!

My idea with this post is to make it more simplified, and clear for the ones that are just starting with code.

You must have in your machine VSCode and Git installed!

Also you must have a repository ready to be used, in my case I’m using VSTS:
Git

Now to setup your environment:

  1. Open the command prompt in the folder you want to add your project files
    GitClone
  2. Press enter and then your code will be cloned locally
    GitCloning
  3. Now to open in your VSCode just typing “code .” in the project’s folder
    (This is the folder where are your project files)
    Then you will be able to see the project:
    CodeProject
  4. Now go to Git tab
    GitTab
    Now change some file and save, and then it will appear in the Git tab as a change
    GitChange.png
  5. Now you can add a message and Commit All
    GitCommitAll
    At this point you committed your code to your local repository, then if you and to send it to the remote Git, you must sync your code.
  6. Sync to the origin
    GitSync
    Once you press sync, it will execute a git pull and then a git push, that way it can ensure that you are integrating all changes locally and then sending all integrated code back to the server. Conflicts may appear, depending on the changes done pushed to the server previously, in that case VSCode will show for you the conflict and you may use its tool to fix the conflict.

 

 

How to verify and to change the collation of some objects in our SQL Server DB

It’s a simple tip how to solve some issues caused by Collation inconsistences.

/*Selecting your DB*/
USE YOURDB
GO

/*Select all object which are different from SQL_Latin1_General_CP1_CI_AS – Put here what collation you are looking for. */
SELECT name, collation_name, *
FROM sys.columns
WHERE OBJECT_ID IN (SELECT OBJECT_ID
FROM sys.objects
WHERE type = ‘U’ )
and collation_name ‘SQL_Latin1_General_CP1_CI_AS’

/* Change the database collation */
ALTER TABLE TableName
ALTER COLUMN ColumnName NVARCHAR(6)
COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
GO

Easy, isn’t it?

Sorry but I’m so lazy now to format those SQL scripts 😛

Como verificar SHA1 de imagens ISO?/How to verify ISO’s SHA1

Se você quer ter certeza que o seu ISO não está corrompido, use a comparação de SHA1.

Para isso vc precisa do software sha1sum:
http://www.labtestproject.com/files/sha1sum/sha1sum.exe

Pelo command, vá até a pasta do software baixado e digite:
sha1sum nomedoarquivo.iso

Após alguns minutos vc vai ver o SHA1 do ISO verificado.

Agora basta ir até onde vc baixou o arquivo e ver há o SHA1 disponível para comparar, ou então procure no google o SHA1.

If you have to be sure if your ISO is not corrupted you can use the SHA1 compare.

For that you need the software sha1sum:
http://www.labtestproject.com/files/sha1sum/sha1sum.exe

Using cmd, go to the software’s folder and type:
sha1sum ISOName.iso

After some minutes you will see the SHA1 from your ISO.

Now you just need to compare the SHA1 calculated with the one available where you downloaded your ISO, or look for the SHA1 on google.