Many people find it daunting when they think about Databases and SQL. I know I found it very scary in the beginning and my early experiences with Database developers left me feeling very small and I thought that maybe I was not good enough to succeed in this field. However, I was luckily given a… Continue reading Quick introduction to SQL, databases and relational theory
Over the years I have written quite a lot of code. These are the tips that I wish I had known when I had started out and would have saved me a lot of head scratching and restless nights: Create a “to do” list. Always write down your tasks and keep it updated as you… Continue reading My top tips for new programmers
During December I decided to dedicate myself to learning Powershell for the next few months. Many of the blogs I follow and some of my respected peers have recommended the Learn Windows PowerShell in a Month of Lunches book and ashamedly I have owned the book and never gotten past the first chapters. The reason I… Continue reading Book Review: Learn Windows PowerShell in a Month of Lunches, Second Edition by Don Jones
This year I am going to get back to blogging regularly and this time I really mean it. I have neglected to blog regularly due to procrastination and not being happy with most of the blog posts I had written. I will try to blog at least every fortnight and will, subject to my work… Continue reading 2017 Blogging Plan
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… Continue reading Why you should learn programming
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… Continue reading What would you like to learn or for me to talk about?
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… Continue reading Ruby Challenge update
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… Continue reading How to change the collation of a database in SQL Server?
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… Continue reading Ruby Rails challenge
Have you ever needed to check your database or SQL instance to find out its collation? Have you ever wanted to check whether a collation is supported by Windows or SQL Server? Well I am going to show you how to find out the information quickly and easily. The below query will show the instance… Continue reading SQL Server Collations Find current collation and all supported collations