Posts

Showing posts from December, 2011

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

Exporting All Installed Applications in Windows

Image
When I helped someone to sell her laptop on internet I needed first to look at what applications were installed in this Windows 7. But, having this list in a file was not an easy task, therefore I searched on internet to get a way to do this. Finally, I used at that moment the command line " wmic " which also allows you to export this list in few formats, always remember first to open your command line window and type the command as shown in the image.     As you can see it's very simple just don't forget to specify the destination path and the format you want your output file (the options are: HTML , Table, XML and more). Once you got your file open it and you will see something like this. If you want to have this file in a more comfortable scheme just do what is said here and it will look like this.   Ready to be used.

Problem Copying Large Path Files

Image
Some time ago I saw one problem as a consequence of a project, this consisted on moving all directories from one network device to an external drive as a backup policy. But, during the copying process happened problems with certain directories and files, an unknown error actually. However, I got the impression that this problem could be produced by the large length of the paths of this directories or files and yes, that was the reason. As a proof of this, I created a large path for a directory that just contains one text file, as you can see "D:\Large Named Directory" has a lot of similar inner directories, having the last one the "Large Named Textfile.txt" file. Pay attention, because it's not possible to create more directories inside the last one, because Windows has a limit... like everything in life.     Now, the image showed before represents the directories in the network drive, and we are going to copy them to a new directory located in the

Speeding Up your Queries with XPath

Finally I'm posting again, the time has been very tough with me... but I'm here again with one subject that I was thinking to post long time ago. This is something that I found really curious when I was helping someone, this person asked me why in certain part of an stored procedure the programmer used the text() function to improve its execution time. Actually, I didn't have idea at that moment why that function gave that kind of benefit, I mean, we had this: CREATE PROCEDURE [dbo] . [SP_Test] @xml xml AS Insert    Into dbo . temp_table Select    Id1 =           D . Item . value ( 'Id1[1]' , 'bigint' ),          Id2 =           D . Item . value ( 'Id2[1]' , 'int' ),          Text1 =         D . Item . value ( 'Text1[1]' , 'varchar(50)' ),          Text2 =         D . Item . value ( ' Text2 [1]' , 'varchar(50)' ),          Id3 =           D . Item . value ( 'Id3[1]'