Posts

Showing posts from March, 2013

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

Beginning Task Date Does Not Move in Project

Image
I don't know if you use Microsoft Project as I do, but I have seen many times the case I'll describe next. Imagine that you have this simple project schedule where all tasks depend each other.     Then, you realize that the subtask 2 is going to last 5 days indeed, so you make this fix and hope the task 3 to begin just when subtask 2 finishes. However, when you do this change the beginning date of task 3 doesn't move, only the final date moves, highlighting new dates.   Don't worry, it's not that your project has broken or something like that, the little detail here is that, although you have your tasks set to be automatically programmed, all tasks won't move its dates if there is progress recorded in them. That's why if you want to have this date moved you must go to task details and clear any percentage shown.   That's the way to do it, and you will see the task moving according to your changes.   So, you can now moving your da

Executing SQL Script from Command Line

Yes, It's more pretty your SQL Server Management Studio, because you can just go to "File" option, find there "Open" and click on "File..." to load a SQL file (.sql) to execute it without problems. But, have you ever tried to do so with a file create by this tool being large enough to freeze it literally when you open it? Well, in this case there's no way to execute that file through the tool. Therefore, here we are with a SQL Server command that will help us with this task. You just have to keep in mind the command: sqlcmd, simple right?. Let's say that we have a SQL server called "MY_SERVER" and my SQL instance "MY_INSTANCE" installed there. What I need now is to execute the following script "my_large_script.sql" located at "D:\Test". It's important to consider that this command use Windows authentication by default, so it's only required to put this line in any command prompt: