Category Archives: Databases

How to upgrade MSSQL Tools Express to Complete

Now I’ve had this issue one or two times but this is the first time I actually managed to solve it. The scenario is that I had SQL Server 2008 R2 Express install, which is missing the profiler tools. So I thought I’ll just upgrade to standard since we have licenses at my company. That [...]

Split column in sql (t-sql)

Ok, first of all you should never be in a situation where you need to split columns in a database if you ask me, that is, if you have done your job well. A sql database consists of tables and tables consists of columns so why join columns together and separate the values with ‘;’? [...]