Home 2017-01-14T17:15:04+00:00

Improve the speed of your laptop with SSD

Practically there's no better way to upgrade your laptop's speed than to replace the hard disk with an SSD SSDs are fast reliable and they don't have mechanical parts, which makes solid state drives more resilient to failures then the magnetic hard drives. Upgrading to an SSD is pretty straight forward process. Advantages Speed: SSD is much faster than hard drives Fragmentation: Yes, SSDs do get fragmented but the performance is not affected as much as with regular hard drives. Durability: An SSD has no moving parts, so it is more likely to keep your data safe in the event you [...]

January 3rd, 2017|Categories: Blog, Tips & Tricks|0 Comments

How to install windows service with command prompt

To install a windows service using the command line you can use the installutil.exe located at the path where Windows .NET Framework is installed. If you are like me, you don't want always to keep typing and check if the user you are logged in as to the server or the box generally has the right UAC access etc. You can always "automate" the whole process by simply creating a batch file which accepts two arguments to install/uninstall the service and the path to the executable of the windows service. Below is the the batch file I'm using ::::::::::::::::::::::::::::::::::::::::: [...]

December 13th, 2016|Categories: .net, command prompt, Tips & Tricks|0 Comments

Create your own dynamic dns service with AWS SDK and Route53

I have several webservers running various services and websites but I had a need one of the servers to be aware of an ip address which is dynamic. I looked at dyndns service which I thought it would be free but to my surprise I had to pay $40 per year, which in my case wasn’t a good option. So, since I’m using from Amazon’s several cloud services, I thought, why not creating my own dynamic dns service utilizing the Amazon Route 53 highly available and scalable cloud Domain Name System web service? The implementation of it was much more [...]

December 8th, 2016|Categories: .net, AWS, Blog, C#|Tags: , , |0 Comments

Generate unique file name with number in parenthesis

You must have noticed that if a file name is duplicate when you copy paste a file in windows or download a file then windows appends to the file name a number within parenthesis. There are various code snippets around the web to generate a file name with a number in parenthesis when saving files. Below is the code I'm using in my project because simply is better the most of the source codes I found on the web and it fills the gap in between numbers. If there are files in a directory like myfile (1).txt, myfile (2).txt, myfile [...]

November 30th, 2016|Categories: .net, asp.net, Blog, C#|Tags: , , , |0 Comments

Split workbook to separate excel files

In relation to my previous post I received few queries on how to separate each worksheet in a workbook to separate excel files. If you want to use the VBA code below without altering it, you will need to follow the below steps: 1. Press the keys ALT + F11 to open the Microsoft Visual Basic for Applications. 2. From the menu options go to Tools and select the References menu item. 3. From the available references check the Microsoft Visual Basic for Applications Extensibility 5.3 Microsoft Scripting Runtime 4. From the File menu option select Options. 5. Select Trust [...]

October 24th, 2016|Categories: Excel, VBA|Tags: , , |0 Comments

Split Data on a worksheet into multiple worksheets in Excel

Often I need to group and split the data of a worksheet into multiple worksheets, based on cell value. When there are thousands of rows to split into multiple worksheet, the task can be pretty exhaustive and time consuming. To save myself time and for my piece of mind below is a simple VBA code I wrote to split the worksheet into multiple worksheets. Option Explicit 'Note: Set the bFirstRowIsHeaderRow to False _ if you don't have header row in your excel worksheet Private Const bFirstRowIsHeaderRow As Boolean = True Sub SplitColumnIntoWorksheets() Dim oActiveSheet As Worksheet Set oActiveSheet [...]

October 20th, 2016|Categories: Excel, VBA|Tags: , , |0 Comments

Recent Posts