Archives
-
Project Management
Grand Designs (on Channel 4 on November 2nd 2005) was all about a build in Belfast. After having seen the organised chaos that is many of the other builds that Grand Designs has showcased, this one …
-
Developer (& Tester!) Quality
Joel of Joel on Software posted an interesting entry a while ago that makes a point about time vs developer resource.
The part I'm interested in starts about a third of the way …
-
Managing...
Time -- Time Management Tips for Developers
Collect all tasks in a to-do list -- I started doing this fairly recently (in part prompted by an internally delivered training course I …
-
What are the INFORMATION_SCHEMA views?
They're fantastically useful things which make it easy to access metadata in SQL Server in a (theoretically!) version agnostic manner. I've mentioned them (or similar) in SQL Server 2005: sysXXXX …
-
Writing Bug Reports / Defects
Spurred by: The Perfect Bug
Having read this blog entry and found it really rather interesting, it's got me thinking about Severity and Priority of defects/bug reports. What's the …
-
Finding the Foreign Keys for a table
For a while it's been driving me barmy, trying to obtain a list of Foreign Keys which reference a particular table. Below is the end result of my hunting. No doubt the code could be optimised, which …
-
Managing Email
A couple of good articles regarding the art of managing email. [via: Jonathan Hardwick: Shipping Version One]
Tips for Mastering E-mail overload
Change This :: The Tyranny of …
-
Enumerating the databases on a server in SQLDMO/vb.net
Whilst you could just execute the following TSQL command:
select name from master..sysdatabases
to obtain the list of databases on a SQL Server box, it's far more fun to try and do it the SQLDMO …
-
Using SQLDMO in .net (VB.net)
Using SQLDMO within .net isn't the easiest thing to find information about, so here goes with some documentation.
The first thing that you need to do is add a reference to the SQLDMO library. With . …