General

Quick introduction to SQL, databases and relational theory

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

PowerShell

Book Review: Learn Windows PowerShell in a Month of Lunches, Second Edition by Don Jones

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

Personal Development

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… Continue reading What would you like to learn or for me to talk about?

Ruby Challenge

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… Continue reading Ruby Challenge update

Database Engine, T-SQL

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… Continue reading How to change the collation of a database in SQL Server?

Personal Development, Ruby Challenge

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… Continue reading Ruby Rails challenge

Database Engine, T-SQL

SQL Server Collations Find current collation and all supported collations

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