Archive for February, 2008

Software Development Lifecycle in a Box

February 28, 2008

A new website from Microsoft presents some guidance around an example project lifecycle.
http://www.sdlcinabox.com/homepage.html
It is interesting because it is not so much about Visual Studio and Team Foundation training. It tries to demonstrate the entire software lifecycle, and mixes Microsoft and third party tools as a method to achieve this.
Quite often on software projects, the process [...]

Heroes Happen

February 20, 2008

I’m currently in Sydney, Australia for some SQL Server work, and I received an invite for the ‘Heroes Happen’ event next week.

I don’t go to a great deal of these but it just seems like good timing
They have a few tracks, and predominately I will be going to the SQL Server 2008 one. My second [...]

Windows Install Experience

February 14, 2008

I love Windows Live Writer, but I really feel for the experience Rory Blyth has been having getting it installed.
After a long absence from the Apple world I got a MacBook and started to play with it. I was amazed at how in OS X you can still just download a utility and run it! [...]

Reverse Engineering a SQL Server 2005 Database

February 12, 2008

For small databases, I was quite liking Visual Studio for Database Professionals. It is easy to use and fantastic for managing your schema as source.
However it seems to be balking at reverse generating a giant database with 2000+ stored procedures. (It is also generally very slow, demanding validation of every little change to your schema against a running [...]

Versioning your database project

February 4, 2008

If a software project uses SQL Server in some capacity, you are going to have some developers who write very good C# code who at the same time are literally butchering the database component.
 ”Source control the database? How can that possibly work?”
“This is madness! Madness I tell you!”
 ”I’ve been in the software business for almost 2 [...]