Wednesday 28 April 2010

How to install Microsoft SQL Server 2008 Management Studio Express

I had on my computer installed SQL Server 2008 Express edition and I was looking for something which will help me to work with it. I have found there is Microsoft SQL Server 2008 Management Studio Express. You can find it on Microsoft download pages.
As a prerequisite you will need to install PowerShell if you already don't have it on your computer. I had trouble to use link to PowerShell 1.0 on the download page so I recommend to use this download link to PowerShell 2.0 on Windows Management Framework page in Windows Management Framework Core section.
When you have installed PowerShell you can start to install Management Studio. I was a bit surprised to see that what I downloaded contains SQL Server installation package. So for the installation of Management Studio 2008 you will need to go Installation > New SQL Server stand-alone installation or add features to an existing installation then pass installation checks and in Feature Selection check Management Tools - Basic.

Friday 16 April 2010

Book recommedation - Co programátory ve škole neučí

At first I would like to apologize to non Czech speaking people. The book I would like to recommend is written in Czech.

I had the book for quite a long time in my bookcase, found it recently and I am glad that I have finally read it. The book discusses difficulties of software development, why a lot of projects are not finished in time or in money. Book doesn't contain any heavy and hard to read theory. On the other hand there are lot of examples from author's work experience. I believe everybody will find out similar examples from his own experience which makes the book very readable.

In short the book contains:
  • specificities of software development
  • frequent reasons why software project fails
  • principals for gathering requirements, writing specification
  • the most frequent mistakes of developers and their reasons
  • how to deal with security holes
  • what can influence speed of software development
  • problems with user interfaces
  • application testing
  • economy side of projects
  • management and communication in development team
  • importance and weaknesses of methodologies, analysis, visual modeling
  • and more...