Why you should learn programming

I remember when one of my friends got a summer job where he was asked to remove certain special characters from filenames and replace it with an underscore. He complained it was boring and tedious but it paid well so he stuck at it. He was expected to do a certain amount of files per hour and he was determined ...

Read More »

What would you like to learn or for me to talk about?

Hi all. Just a quick blog post to say that I would like to thank everyone who has visited this site, sent me emails or comments on social media. It makes all my efforts worthwhile and further motivates me to continue blogging. Now I would like to reach to everyone and find out what they would like to learn more ...

Read More »

Ruby Challenge update

Hello all. A quick update on my Ruby Challenge. I am half way through the One Month Rails course and I am really enjoying learning Rails programming. I have found Ruby to be a quite intuitive and easy language to pick up. I have already started looking at creating a few simple apps which have always been on my mind. ...

Read More »

How to change the collation of a database in SQL Server?

Have you ever wondered how to change the collation for a database in SQL Server? Well the other day I received a database from a third party supplier and the first step was to change the Collation of the database. My questioning about why they would supply the database in the incorrect collation setting was met with a wall of ...

Read More »

Ruby Rails challenge

I overheard a conversation the other day in the office about some of my colleagues all challenging themselves to do an Iron Man race as they always wanted to do it and they thought it would be fun to do it as well. This got me thinking about my own dreams and challenges I could set for myself. Whilst an ...

Read More »

Generate random numbers in PowerShell with Get-Random

Generate random numbers in PowerShell with Get-Random Have you ever wanted to generate random numbers for passwords, test data…. and wondered how you could easily generate them? Well I was confronted by the same situation on one of our servers where I needed some random numbers for inputting wait times to test an application but didn’t have my usual tool ...

Read More »

ASCII String function in SQL Server

Have you wondered what the ASCII value of a character is whilst using SQL Server? Or needed to quickly check the ASCII value? Or wondered how the ASCII Function worked? Well the other day I saw one of the developers using the ASCII function which I was not familiar with so I decided to a bit of exploring. SELECT ASCII( ...

Read More »

List Hotfixes installed with PowerShell with Get-Hotfix

Have you ever wondered what updates have been applied to your Windows operating system? Well a quick and easy way to do that is to use the PowerShell command Get-Hotfix. This will list out the description, the HotfixID and when it was installed. I used this on a few PCs where it appeared that updates were not being applied and ...

Read More »

Statistical Aggregate functions in SQL Server

Have you ever wondered how to do program or perform simple statistical function within SQL Server? Well the kind people at Microsoft have enabled us to all to save time by giving us a few inbuilt functions which save us from having to solve them programmatically. I have used the unit Price column in the SalesOrderDetail table within the Adventureworks ...

Read More »