Yesterday my friend Jonas Bandi had his last working day at the company where I work too.The conclusion after one year is not so bad as I thought it would be. Well, we had sometimes intensive discussions, but I think that is normal, when you are looking for a good solution. But what is the real conclusion? Was it really a good year? Was the project on which he and I worked on successful? Should I go too to an…
Recently my boss asked me, why the databases (Microsoft SQL Server 2005) of our customers are so big. With the following SQL-Statements I could give more or less an answer to my boss. CREATE TABLE PW_SPACE( name varchar(255), rows int, reserved varchar(255), data varchar(255), index_size varchar(255), unused varchar(255) ) GO EXEC sp_MSforeachtable @command1=”INSERT INTO PW_SPACE EXEC sp_spaceused ‘?'” GO select * from PW_SPACE order by rows desc GO select sum(rows) as Rows, convert(varchar(255), sum(convert(int, substring(data,0,len(data)-2)))) + ‘ KB’ as Data,…
There are several offline blogging tools, but two of them are interesting: Blogjet Windows Live Writer The Blogjet tool works very fine and I could also formatting my source-code. The microsoft-tool (currently it’s for free) looks even better as the blogjet-tool and I think it has more or less the same features. With both tools I could connect to my blog, but with the Blogjet tool I had a little Problem because a proposed value was wrong. The microsoft windows live…
Well, it’s sunday, the sun is shining and right now I am watching the newest epsiode of dnrTV! (it’s about design patterns). Now, what I want to be is a better software developer and software architect and I would like to see my progress in learning (and my knowledge in english). One way is watching videocasts or listening to podcasts. Another way is writing down the things I learned. Well the first thing is already “implemented”, so I tackle the…