Tag Archives: sql server

oDesk Fails – Clients Who Want Everything for Nothing

Here’s the first in an occasional series about oDesk fails. Now I’m a big fan of oDesk. In fact I have a number of satisfied customers on there. My bone of contention isn’t with oDesk itself, but rather the job postings that I see on the site from time to time. However, it would be […]

Read more
phpMyAdmin Screenshot

MySQL or SQL Server – Which is Better?

MySQL or SQL Server? Which is better for developing web based applications with? I’m Brett, and I’ve been a full-time software developer since 1997. I first connected a database to a website in 1998. It was hard work. The database was Access. Hmm, it wasn’t very reliable, but it did start to revolutionise access to […]

Read more
Asian Love Connections screenshot

Portfolio

Hi, I’m Brett, and I’m the owner of Winnersh Triangle Web Solutions Limited. I’ve had a long career as a software developer. This page showcases some of the projects I’ve worked with over the years. If you want to know more about my skills and experiences, then check out my LinkedIn Profile. If you want […]

Read more
HTML format report created by the SQL Documentation Tool

SQL Documentation Tool

Click to download the trial version. Click to buy the full version. Why spent hours documenting your databases by hand? The SQL Documentation Tool automatically documents entire SQL Server databases, allowing you to get on with more important work. Benefits: A huge time saver compared to generating documentation by hand. Helps your development team get […]

Read more
Screenshot of the documentation created by the VB Documentation Tool

VB Documentation Tool

Click here to download the trial version. Click to buy the full version. Need a tool to automatically document your Visual Basic 6.0 source code? The VB Documentation Tool creates comprehensive developer documentation for Visual Basic 6.0 source code. Benefits:  Huge time savings compared to writing code documentation by hand. Allows you to get to […]

Read more
Figure 2. Adding a table column description via SQL Server 2008's SQL Server Management Studio

Documenting Microsoft SQL Server 2005/2008 Databases

This article describes how the improvements in Microsoft’s SQL Server 2005 or 2008 relational database allow for most database entities to be documented. The documentation is held within the database itself, allowing the documentation to be kept synchronised with the database itself. These enhancements offer the possibility of a self-documenting database, saving many hours of […]

Read more
Figure 1. Adding a table column description via the SQL Server Enterprise Manager

Documenting a Microsoft SQL Server Database

This article describes how to document your Microsoft SQL Server database. The principles are similar for all versions of SQL Server, although SQL Server 2005 and above contain a number of neat enhancements to database documentation capabilities. The article includes database naming conventions, adding object descriptions, documenting stored procedures, and how to create technical documentation […]

Read more