Random outpourings of a software developer
http://mikehadlow.blogspot.co.uk/2011/02/asmspy-little-tool-to-help-fix-assembly.html
In a sufficiently big codebase it is hard to avoid the assembly version conflict problem.
This tool is a great means of tracking down the problem.
Run it in the directory that the assembly is in and it will list the versions of the dependencies oif everything used.
Get-WmiObject -ComputerName MYSERVER -Class win32_service | where {$_.Name -like “*SERVICENAMEPART*”} | ft Name,State
$serv = Get-WmiObject -ComputerName MYSERVER -Class win32_service | where {$_.Name -like “*SERVICENAMEPART*”}
$serv[0].StopService()
function Execute-Query
{
param
(
[string]$server = “.”,
[Parameter(Mandatory=$true)]
[string]$database,
[Parameter(Mandatory=$true)]
[string]$query
)
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = “Server=$server;Database=$database;Integrated Security=True”
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = $query
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
[void]$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$DataSet.Tables[0]
}
Here is an article on using Raspberry Pi as a universal media centre.
This allows all of the catchup service to be supported from one updatable box.
Here is a great article on documenting sql databases using powershell.
This could easily be turned into a full database compare tool which would be ideal for testing database upgrade scripts (or for detecting the need for them).
Developer Rants 