Posts

Showing posts from 2012

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

Fastest Way to Know the Size of Files or Folders

Image
Hi there! this time I'm going to show you a quick way to know the total size of any select files or folders. My idea is to give a sum up about how this task is accomplished typically so, you first select the elements you want to measure, this by using "Ctrl" key and click over the files or folders without releasing the key. As a second step you click the right button of your mouse and select "Properties" option displayed in the menu. With the procedure explain lines above you'll finally get here, where you will see the total amount of space used by the chosen elements. And what is the trick? Well, it's quite simple but I know there are people who may not have acknowledge about this, just use the keys "Alt" and "Enter" and you'll skip the right-clicking thing and selecting "Properties". Yes! just select the elements and press "Alt" + "Enter" to go straight to "Properties"

Linked Images in Sharepoint

Image
Yes! I'm back hahaha at least in this moment, I was and am very busy but I have several posts pending of being published so I will try to publish more frequently. In this opportunity I had to modify a Sharepoint site, because we are having a new process, so as a way to communicate this a site was designed, where graphically it's shown the new process divided into blocks.  But, the requirement itself was to have this graphic ready to be clicked with the purpose of sending the user to process block site. Yes, a linked image. To do so, first, it's necessary to have edit permissions on the site. Second, we have to access to "Content Editor"though "Edit" webpart option and once we have got in there, click on "Rich Text Editor...".   You will get something like, in this step you have to pick the image you want to have the link, and select the "Hyperlink" icon.   Once you do that, a window will be shown asking you for t

Using Linked Servers in SQL Server

Image
When you work with software you have in mind that everything is interconnected, even more when you're talking about servers. And things could get really ugly if you need to make queries and see that a part of your information is located in another server. Fortunately, Microsoft SQL Server helps us in this situation giving us a feature that allows us to reference a different server and use it to make queries against it. So, let's open SQL Server Management Studio, get in to the server and go to "Linked Servers" folder located in "Server Objects".     Now, you have to create a new linked server by using the right-click button and the appropriate option.   In this ocasion, just type the linked server name on the textbox and select the type of this, keep in mind that you can connect to other sources different from SQL Server.   After you do this, on the "Security" section you have to specify the mapping between users and for the rest of u

Reducing the Size of PowerPoint Presentations

Image
At work it's always required to make presentations in PowerPoint ... but sometimes these presentations have a considerable size that are needed to get smaller. And that is the reason of my next tip, which will help you with your big-sized presentations. I will use a PowerPoint file with 3 images on it and make a copy of it to prove that it's possible to reduce dramatically it size, let me show you the file itself and the 2 equal files that I have created.     Now, I will work with "Test with compressing" file to compress its images, because that's the key. The only thing you have to do is to select one image and go to "Compress Pictures" option which is located within "Picture Tools" ribbon.   Later, in the dialog box shown uncheck "Apply only to this picture" and pick "E-mail (96 ppi)", after that select "OK" button.   At this point the only thing that you have to do is to save you file and you wi

Separating One Cell Text in Columns with Excel

Image
Many times I asked for punctual information but , in contrast, I received more than I had asked for. For example, I just wanted the name of the applications of a computer, but I got much more in just one column. Therefore, I decided to use one Excel feature named "Text to Columns".   In the window that appears with this option you have to select the characters you are going to use as pattern to separate each row in columns, in this case I selected just "Tab" and got what is shown in the image, as you can appreciate the application descriptions will be in a separated column. Having as a result this. Once you get what you wanted you can proceed to removing extra columns.