Friday, November 13, 2015

Managing Disk Partitions

Today I want to write about disk partition, probably you have seen that a computer has one or more drives (C:, D: and more) but it doesn't mean that there is actually such amount of physical drives, therefore they are called partitions.

I consider that it's a best practice to always have an exclusive partition for your operating system and one o more for all you data, because if you have a problem that will require your system to be reinstalled then the reinstallation is not going to delete your data just the operating system.

What do I have to do if I save my data and my operating system in one partition? Well, you must create a partition and for that I'm going to show you Gparted, this is a free tool and I recommend you to use the live version because it will be better to have it in a CD just in case.

With the CD in your computer just turn on it and Grub will show you a screen like this, select the first option (the other ones are advanced).

Here select 'Don't touch keymap'.

At this point you can choose the language, type the number you want and press 'Enter'.

Be careful here, because if you don't pick 0 you'll have to fight with command prompt.

After all, Grub is going to show, you will see all the partitions you have, the amount of space used and the size of each one.

To have a more detailed view just double click on the partition you want.

In this window you will be able to resize or move the partition, to do so you can use the arrows located at the left o right of the rectangle, with this you can reduce the amount your operating system will have in its partition, remember that used space is in yellow and total size is in white.

Once you have reduced the operation system partition you can create a new partition by double clicking on the free space, if you want a Windows partition select 'ntfs' as file system, but if you want a Linux one select 'ext4'.

Even, you can decide to not use all the space, so use the arrows to resize the partition as you wish.

Remember that nothing of this changes has been applied yet because you need to explicitly point that you want the changes to perform.

Click on 'Apply' and wait for the results.

It's very important to keep your laptop with the charger because this process could take hours depending of the operations needed to be performed.

Once everything is donde just reboot the computer and remove the Grub cd from the tray to boot up in your operating system. Don't forget to move all data you want to keep towards your new partition.

Sunday, July 19, 2015

Recalling Outlook Message Once You Sent It

Sometimes when you send a mail through Outlook and realizes that you want that mail back because you didn't mean to send it yet, there's an option.

To recall a message you have to open the sent mail and go to 'Actions', then you have hit 'Recall This Message...'.

Once you use this option it's going to show a popup that will allow you to delete or replace the message.

So, you have an ocassion to make things as you want.

Saturday, June 13, 2015

Rotating Computer Screen

Few weeks ago I went to a cellphone store and this store had a computer where clients could look for information. However, the screen looked like this:

So it was useless for clients, fortunately there's a way to solve this easily, just press at the same time keys 'Ctrl' + 'Alt' and the arrow indicating where the top of the screen is going to be.

Now you can rotate your screen anytime you want.

Friday, April 3, 2015

Getting a Value Giving Column and Row on Excel

Many times it's interesting to see how business requires you to use functions from Excel that you don't even know they exist. In this post I have the following mission: I want to know the value of a cell when I write the column and row, consider that column and row can have any identification.

To get the value from a table you must use 2 functions: Match and Index, Match function gives you the position of a given value in a range, therefore it's necessary to first get the position of the column and the row.

Once you have both positions use them into Index function that is going to give you the value located in the position you put related to a given matrix.

Sunday, February 15, 2015

Turning Horizontal Visio Swimlanes into Vertical Ones

In one ocassion, a friend at work called me because she had a problem with Microsoft Visio, she was trying to draw a process flowchat but using swimlanes, this was not a problem until she realized that it would be better to use vertical swimlanes instead of horizontal ones.

But, when she tried to drag a vertical one it just put together to the previous swimlanes created before.

To avoid creating a new visio document and lost your work just go to 'Cross-Functional Flowchart' ribbon and select 'Orientation' and 'Vertical'.

And it's done, now you can work with vertical swimlanes or if you like it you can turn them back to horizontal ones.

Saturday, December 6, 2014

Looking for Installation Folder of ClickOnce Applications

If you are using ClickOnce applications then you have to know that they are not installed in the common "Program Files" folder, due to the arquitecture that this Microsoft technology has, that's the reason because you don't find the program folder when you need to locate it.

First at all, it's necessary to set Windows to show hidden folders, otherwise you won't be able to find the application folder, so you can get this by going to "Control Panel", "Folder Options" in "Appearance" section. In the window that appears just go to "View" tab and pick the "Show hidden files, folders and drives" option.

Now, you must navigate through the folders to reach the common one that is used by Windows to store this type of applications, consider that Windows creates a random name for this repository.

Looking inside you'll notice that the names of the folders have some part of the application name in them, with many numbers and letters.

Well, you found the application folder, congratulations.

Saturday, September 13, 2014

Making Queries to Compare Dates in SQL Server

It's time to share a little tech knowledge!, when you are working with databases, SQL Server specifically, it's a good practice to keep in some tables records that could be used as auditing information, for this purpose you need to save date of the performed operation necessarily.

However, when the audit comes, you open your database to make a query against it but you think at that moment whether you should use <,>,= operators or you could write the date as is or you must use it as text and so on.

Well, too much thinking, the answer is to use the "between" keyword and putting date as text including time as shown.

select * from Scheme.OperationAudit where AuditDate between '07/01/2013 00:00' and '08/14/2013 23:59' order by AuditDate asc

Remember that date format depends of format used by the server, this is easy to know by using 13, yes, put 13 first in the date and if the query shows error then the month is not first (because there are just 12 months).