blog
My blog of techy stuff, ranging around SQL (SQL Server, that is), C# and .net, JavaScript and a smattering of stuff about the Orchard CMS (that powers my site) as I get more familiar with it. There's the occasional non-technical post when something is of interest to me that I feel is worth sharing, but they should be few and far between
-
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 . …