Chrissie1's Blog

Moved blog

Chrissie1 — Sun, 15 Jun 2008 12:48:39 GMT

I moved my blog to http://blogs.lessthandot.com

Lessthandot has launched

Chrissie1 — Sun, 01 Jun 2008 08:39:16 GMT

Yes, LessThanDot is finaly live and kicking.

LessThanDot launches june 1st

Chrissie1 — Mon, 19 May 2008 19:01:52 GMT

Me and some other people have been working on a brilliant new site it is called LessThanDot and it contains a wiki, blog and forums all accessible via a single login. Please visit us from the first of june onwards at http://www.lessthandot.com

File Unlocker for Windows

Chrissie1 — Mon, 28 Apr 2008 08:13:19 GMT

On windows files can be locked by different programs. This little gem unlocks your file so that you can delete it.

Do automated restore tests on your SQL-Backups.

Chrissie1 — Thu, 17 Apr 2008 12:00:00 GMT

I found out yesterday that my sql server backups were corrupt and so I couldn't restore them (happy me). So I went out on Google and combined a few things to make this

declare @verifystatement nvarchar(250) declare @backupdevice nvarchar(250) declare @err int set @backupdevice
=     (SELECT     TOP 1
[physical_device_name]             FROM     msdb.dbo.backupmediafamily
backupmediafamily                 JOIN msdb.dbo.backupset
backupset ON backupmediafamily.media_set_id
= backupset.media_set_id                 and backupset.backup_start_date
= (    SELECT max(backup_start_date)
                                    FROM msdb.dbo.backupset
child                                     WHERE child.database_name
= backupset.database_name and child.type
= 'D')
                and database_name
= 'TexDatabase'                 and backupset.type
= 'D') set @verifystatement
= 'restore
verifyonly from disk = ''' + @backupdevice + '''' exec sp_executesql @verifystatement SELECT @err
= @@error if @err
<> 0         begin             insert into utils.dbo.tbl_backupverify(BackupDevice,BackupStatus,BackupError,
VerifyStatement)             values (@backupdevice, 'Failed',
@err, @verifystatement)         end         else         begin             insert into utils.dbo.tbl_backupverify(BackupDevice,BackupStatus)
            values (@backupdevice, 'Succes')
        end

Just put it in a Store procedure and run it as a job.

This is the tbl_BackupVerify create table statement.

if exists (select * from dbo.sysobjects where id
= object_id(N'[dbo].[tbl_BackupVerify]') and OBJECTPROPERTY(id,
N'IsUserTable')
= 1) drop table [dbo].[tbl_BackupVerify]
GO CREATE TABLE [dbo].[tbl_BackupVerify]
(     [Id] [int] IDENTITY (1,
1) NOT NULL ,
    [BackupDevice] [nvarchar]
(250) COLLATE Latin1_General_CI_AS NOT NULL ,
    [BackupStatus] [nvarchar]
(50) COLLATE Latin1_General_CI_AS NOT NULL ,
    [VerifyDate] [datetime] NOT NULL ,
    [BackupError] [bigint] NULL ,
    [VerifyStatement] [nvarchar]
(500) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY]
GO

You could add this as a scheduled job in sql-server.

Just don't forget to check the log table or make it send an email.

Find the last Backup taken in SQL Server

Chrissie1 — Thu, 17 Apr 2008 08:38:06 GMT

SELECT * FROM msdb.dbo.backupmediafamily
backupmediafamily JOIN msdb.dbo.backupset
backupset ON backupmediafamily.media_set_id
= backupset.media_set_id and backupset.backup_start_date
= (SELECT max(backup_start_date) FROM msdb.dbo.backupset
child WHERE child.database_name
= backupset.database_name and child.type
= 'D') and database_name
= 'ReplaceWithDatabaseNameHere' and backupset.type
= 'D'

This is Based on something I found here. Thank you mrDenny.

And this works in SQL Server 2000.

Resharper File template for Nunit testing with Structuremap support for VB.Net

Chrissie1 — Tue, 15 Apr 2008 12:52:23 GMT

So I also made the a similar template with structuremap support included.

Wich looks something like this

Imports Nunit.FrameWork Imports StructureMap Namespace $NAMESPACE$
    '''
<summary>     '''
A TestClass     '''
</summary>     '''
<remarks></remarks>     <TestFixture()>
_     Public Class $CLASSNAME$
     #Region "
Setup and TearDown "         '''
<summary>         '''
Sets up the Tests         '''
</summary>         '''
<remarks></remarks>         <Setup()>
_         Public Sub Setup()
    StructureMapConfiguration.UseDefaultStructureMapConfigFile = False         StructureMapConfiguration.ScanAssemblies.IncludeTheCallingAssembly()
        End Sub         '''
<summary>         '''
Tears down the test. Is executed after the Test is Completed         '''
</summary>         '''
<remarks></remarks>         <TearDown()>
_         Public Sub TearDown()
            ObjectFactory.ResetDefaults()        
    End Sub #End Region    
#Region "
Tests "     '''
<summary>         '''
A Test         '''
</summary>         '''
<remarks></remarks>      <Test()> _     Public Sub $Test_Name$()
    End Sub #End Region
    End Class End Namespace

And of course I also made an XmlFile so you can easily import it.

NunitTestFixtureWithStructureMapSupport.xml (2,44 KB)

Resharper Template Nunit TestFixture for VB.Net

Chrissie1 — Tue, 15 Apr 2008 12:49:23 GMT

I made a file template for resharper to make it eassier to create a TestClass

it looks like this.

Imports Nunit.FrameWork Namespace $NAMESPACE$
    '''
<summary>     '''
A TestClass     '''
</summary>     '''
<remarks></remarks>     <TestFixture()>
_     Public Class $CLASSNAME$
     #Region "
Setup and TearDown "         '''
<summary>         '''
Sets up the Tests         '''
</summary>         '''
<remarks></remarks>         <Setup()>
_         Public Sub Setup()
        End Sub         '''
<summary>         '''
Tears down the test. Is executed after the Test is Completed         '''
</summary>         '''
<remarks></remarks>         <TearDown()>
_         Public Sub TearDown()
                 End Sub #End Region    
#Region "
Tests "     '''
<summary>         '''
A Test         '''
</summary>         '''
<remarks></remarks>      <Test()> _     Public Sub $Test_Name$()
    End Sub #End Region
    End Class End Namespace

I also made an xmlFile so you can easily import it into Resharper.

NunitTestFixture.xml (2,15 KB)

Unused references

Chrissie1 — Mon, 14 Apr 2008 11:48:41 GMT

Sometimes we just add references and never use them or use them and then remove it all again. And sometimes it is hard to say which reference we don't use anymore. Well MS has provided us with a button that looks up the unused references and if it finds ione you can remove the unused references.

So how do we do it.

First we right clikc on our project and select properties.

Then we go to the tab references and click on the button Unused References.

This will open a dialog with either a list of unused references (see below) or nothing in it.

And now you can just click remove and the references will be gone.

Changing the targeted framework in VB.NET 2008

Chrissie1 — Mon, 14 Apr 2008 11:32:58 GMT

Changing the targeted framework of a project in VB.NET 2008 with the Visual Studio IDE goes like this.

First we click right on the project name and choose properties.

Then we select the compile tab and click on the "Advanced Compile Options..." Button.

And last but not least we select the desired framework from the list "Target framework (all configurations)".

Mocking events

Chrissie1 — Sun, 13 Apr 2008 21:05:57 GMT

Now that I have StructureMap and RhinoMocks in my stack I sometimes need to look for VB.Net examples of how to do things, because sometimes translating them from C# is not all that easy.

This article has helped me mocking events.

Lambda expressions

Chrissie1 — Sun, 13 Apr 2008 19:59:08 GMT

After reading A post by Sergio Pereira I thought about translating his code to VB.Net because as usual all the cool things are written in C#.
So this piece

 using(StreamReader
rd = File.OpenText("Data.txt")) 


{ 


string line = rd.ReadLine(); 


while(line
!= null) 


{ 


DoSomething(line); 


//
do more stuff with the line text 




//move
on 


line = rd.ReadLine(); 


} 


}

Becomes

Dim rd As System.IO.StreamReader = System.IO.File.OpenText("Data.txt")

Using (rd)



Dim line As String = rd.ReadLine()

While (line
IsNot Nothing)



dosomething(line)

'
do more stuff with the line text 




'move
on 


line = rd.ReadLine()

End While


End Using

and the next bit

 public static class FileUtil 


{ 


public static void EachLine(string fileName,
Action<string>
process) 


{ 


using(StreamReader
rd = File.OpenText(fileName)) 


{ 


string line = rd.ReadLine(); 


while(line
!= null) 


{ 


process(line); 


line = rd.ReadLine(); 


} 


} 


} 


}

will translate in

Public Class FileUtil



Public Shared Sub EachLine(ByVal fileName As String, ByVal process As Action(Of String))

Dim rd As System.IO.StreamReader = System.IO.File.OpenText(fileName)

Using (rd)



Dim Line As String = rd.ReadLine()

While (Line
IsNot Nothing)



process(Line)

Line = rd.ReadLine()

End While


End Using

End Sub


End Class

And we call that last piece of code like this

FileUtil.EachLine("Data.txt", AddressOf dosomething)

The doSomething method would look something like this

Private Sub dosomething(ByVal line As String)
MessageBox.Show(line) End Sub

And that's it.