Runakay

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.

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...

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(...

This is something that I hadn't realized until I helped a partner with an Excel, the problem was with the searching because the results were really unexpected, she selected just a column in the tab "Perú" but the searching dialog showed results from "Perú" and "Colombia" tabs, really curious, isn't it?. At that moment I thought "this could be very useful when you have a lot of tabs to search in!", so I will show you how to use it. As an example, I will use an Excel with many values corresponding each one to determined country, having at the same time many countries displayed as tabs. The aim of this searching is to find the value 4034220, for this I can use the search all option but I know that this value is only in non-spanish countries, so I just start selecting those country tabs, to do this just click on the tabs you want while pressing "Ctrl" key. As you can see, this tabs will be marked in white color. Once you ha...

One advantage that Firefox brings with it it's the possibility of extending its functionality by using what is call add-on, a software component that added to your navigator will improve it a lot and help you many times. In this occasion let me show how gTranslate can give you a hand to translate those words that you don't know what they mean, without the need of visiting a specific web to accomplish this task. The first step is installing this add-on, this is very easy so just follow the link given in the earlier paragraph. If you have just already done this then it's time to use it, for this example I will translate an English text to Spanish so let's select the text.   At this point you need to right-click on the remarked text to display the gTranslate menu.   In this menu you will see the gTranslate icon with the phrase to be translated, just move the pointer over this and you will get the translation of this text, all this is possible because it connects dire...

It's very useful to have your files in pdf files because they are very practical, the problem is that many time you have your information in documents made in Word, Excel, PowerPoint and so on. Therefore, people don't have another way rather than walking around with this documents.   Fortunately, Bullzip PDF Printer helps us with the task of converting any file we have in pdf format by "printing" them in this type of file.   After installing this tool, the only thing you have to do is to select the document you would like to have in pdf. Once you have the chosen one you should send this file to the printer, yes... sounds weird, but the key here is the use of a virtual printer which will built the file in pdf format.   As an example, I will print a Word document using the virtual printer, you are required to select the Bullzip printer and select "OK". With this action, Bullzip printer will show a popup asking you the folder it's going to save the pdf fi...

I found once a way to move cells across Excel with a curious way that I haven't known before. The simple trick is just moving a cell or a group of them while pressing the "Shift" key.     First at all, select the range of cells you want to move, then click on the border together with the "Shift" key and begin the movement.     After this, just locate the cells where you want to place them. Release the click and you will notice the new position of the cells.   The previous example was to place the cells on the right side of other cells, however you can put them also between a range.   Very curious thing, right?

I had just a week ago this case, my Excel had a cell containing 4 codes separated just by enters.Excel and other Microsoft Office applications have an option to replace any kind of text, but what happen if you want to replace no-printable characters like enters. I had just a week ago this case, my Excel had a cell containing 4 codes separated just by enters.     Then, to have this codes separate by "-" I decided to replace the enters, to do this was necessary to enter this character in the "Search" textbox, this is possible by typing "Alt + 0010" and a "." is shown flashing, after that I put the "-" which was the replacement.     Finally I got my objetive, a tip to bear in mind is that to put the enter character it's necessary to type 0010 with the numeric pad. Otherwise, nothing will happen.  

At work I've always seen this situation: someone is giving a presentation with a ppt or pptx extension in full screen mode, when suddenly there's a person who request coming back to an specific slide. This is how the expositor takes a break and gets out of the full screen mode to select the given slide.     But, when it's time to display the full screen mode everybody uses the shortcut "F5" having as result the first slide of the presentation, so if the slide to be presented is 123 of 234 slides you will have to click next, next and more next. To avoid this annoying situation just locate on the slide you want to start from and use the shortcut "Shift + F5", in this way you are going to be where you want in full screen mode.

As a constant user of Lotus Notes I have to say that one of the best features I have found in this tool is "Follow Up" which helps me a lot to don't lose the important mails I have to answer as soon as possible. To remark one mail in this way, the first thing to do is to select it.     Then, you have to go to the "Follow Up" option (remember that the images are from a Spanish version) and click on "Add or Edit Flag...".   Suddenly, Lotus Notes will pop up the following window, where you can give this message a priority and actions, configure these and click "OK".    In this way, you will mark the massage with a priority represented by a flag icon together the mail. But, if you want to see all your mails marked with some kind of priority you have to display the "Follow Up" section located at the bottom of the Lotus window.   Once you have expanded this section you will be able to see all your important mails, only the ones y...

Honestly, I have been using this Microsoft account since it was called Hotmail, but in all that time I hadn't been used frequently the account to chat through Windows Live Messenger. Also it is good to say that I use an email client, Thunderbird specifically, so logging in to the Windows Live webpage was not something that I usually did. This is how I downloaded all the mails to my PC, which is really useful, but one Sunday weeks ago I need to chat with someone, having the need to connect in my Windows Live Messenger... and when I tried to do so I found out that I could not be logged in. I was absolutely sure about the password I had used there, but it continued to reject my input so I decided to enter through the webpage, showing me the following message.   Believe it or not my account had been blocked! I had no idea about what it would be the reason for this, until I suddenly remembered that sometime ago my mail address had been used to send spam, but looking into a lot of f...

In certain point of my travel over internet I found a web page that claimed to be one of the few sites which paid you by clicking on advertisements and viewing them for a short time. At first I consider this as something very tricky, but the only thing I could do was trying it to watch the results. This was the beginning of the unknown hahaha, I started looking at these advertisements and earning a little amount for these. It's obvious that nobody will give you money as easy, therefore I had to click and click for a long time to get paid, and that was surprisingly what occurred.   The page I'm talking about is Neobux , to get an account just click on "Register". And you will have this form shown to fulfill your information and continue the procedure. When you have your user created, come back to the main page and log in to visualize your options, the major link to always visit is "View Advertisements" which will show you a squares with numbers meaning the ...