@KiwiPiet

Obscure error (0x801312E3) running tests

noreply@blogger.com (Pieter Jansen van Vuuren) — Fri, 22 Feb 2013 23:21:00 +0000

I just ran into the same issue Nate ran into almost two years ago.
I am busy consolidating a few assemblies when my tests started failing with:

"Could not load file or assembly or one of its dependencies. Signature missing argument. (Exception from HRESULT: 0x801312E3)"

After I referenced all the assemblies from the SUT all my tests worked as expected.

TSQL 'Tools' I use

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 16 Jan 2013 03:09:00 +0000

Daily:

sp_WhoIsActive:
If you are using sp_who or sp_who2 you are doing it wrong.
SQL Server Maintenance Solution scripts from Ola Hallengren
Database Integrity Checks, Backups and index optimization covered.

Ad-hoc:

sp_Blitz:
Get it, run it. Covers a whole host of health checks.
sp_SQLskills_SQL2008_finddupes:
Find and remove those duplicate indexes.
SQL Server Diagnostic Information Queries:
I use these to audit SQL Servers and Databases.

Gotta Love: T-SQL MERGE

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 16 Jan 2013 02:52:00 +0000

Just a quick post to say that if you don't know MERGE then get to know it.

When was my SQL Server / Instance last restarted

noreply@blogger.com (Pieter Jansen van Vuuren) — Sun, 13 Jan 2013 19:17:00 +0000

When you query usage statistics of your SQL server the data is only valid since the last time the server or instance had been restarted. To know when this was you can run the following on SQL 2005+:

SELECT 'Statistics since: ' + CAST(sqlserver_start_time AS VARCHAR) FROM sys.dm_os_sys_info;

TSQL - To CHAR or not to CHAR

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 28 Nov 2012 20:16:00 +0000

Don't use VARCHAR for columns that only need 1 or 2 elements

i.e.

DON'T:

CREATE TABLE [dbo].[Person] (
...
[Gender] VARCHAR(1) NOT NULL,
...
)

DO:

CREATE TABLE [dbo].[Person] (
...
[Gender] CHAR(1) NOT NULL,
...
)

There is a Code Analysis option in DataDude that checks for this (SR0009).

T-SQL ISNULL

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 28 Nov 2012 02:19:00 +0000

Tip:

Don't use ISNULL on columns that are not nullable

Team Foundation Service is live

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 31 Oct 2012 20:31:00 +0000

I've just created an account on http://tfs.visualstudio.com and created my first project.

It is free for up to 5 users, read more here.

Check availability

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 25 Oct 2012 04:20:00 +0000

Why is it that people don't check your availability before booking meetings with you?

Test post from blogger iPhone app

noreply@blogger.com (Pieter Jansen van Vuuren) — Fri, 31 Aug 2012 05:53:00 +0000

Testing blogger app

GitHub for Windows

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 29 Aug 2012 21:04:00 +0000

I've worked with GitHub on and off for several years now and as a windows user I always found that I struggled a bit to get to grips with the whole process every time. But with the GitHub for Windows I have none of that ramp up time anymore. I especially liked the fact that I just dragged the existing GitHub source folders I had on my machine into the app and it all just worked.

Ninject & Appccelerate.EventBroker

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 29 Aug 2012 03:39:00 +0000

I forked the ninject.extensions.bbveventbroker project and updated it to use the Appccelerate.EventBroker.
Fairly painless, but when running the tests I was getting a System.TypeLoadException : "Inheritance security rules violated while overriding member...". I found the following post that worked for me:
I added

[assembly: System.Security.SecurityRules(System.Security.SecurityRuleSet.Level1)]

to the AssemblyInfo.cs and it all worked again.

XPO Auto Properties and PostSharp 2.1 Starter Edition

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 11 Apr 2012 09:28:00 +0000

I've been using the solution from http://xpoautoproperties.codeplex.com/ for years. But last week I needed to update an application to .NET 4.0 so that I could use signalR. Problem was that xpoautoproperties used PostSharp 1.5 which does not support .NET 4.0. So I went over to the PostSharp site and saw that there was a free starter edition. Being a stingy bastard I decided to have a look. After some swearing and head scratching I produced the following that works for me.

    [Serializable]
    [AttributeUsage(AttributeTargets.Class | AttributeTargets.Property)]
    [MulticastAttributeUsage(MulticastTargets.Property, 
        TargetMemberAttributes = MulticastAttributes.NonAbstract | MulticastAttributes.Public)]
    public sealed class XpoAutomaticPropertiesAttribute : LocationInterceptionAspect
    {
        public MethodInfo OnSetPropertyValueMethod;

        public override void OnSetValue(LocationInterceptionArgs args)
        {
            // Don't go further if the new value is equal to the old one.
            // Use object.Equals, because == operator on objects always checks reference equality, but object.Equals() is virtual
            if ((args.Value == null) && (args.GetCurrentValue() == null))
                return;
            if ((args.Value != null) && (args.GetCurrentValue() != null) && args.Value.Equals(args.GetCurrentValue()))
                return;

            args.ProceedSetValue();

            var ignoreAttributes = (XpoIgnoreAutomaticPropertyAttribute[])args.Location.PropertyInfo.GetCustomAttributes(typeof(XpoIgnoreAutomaticPropertyAttribute), true);
            if (ignoreAttributes.Any())
                return;

            // Invoke method OnSetPropertyValue (our, the base one, or the overridden one).
            OnSetPropertyValueMethod.Invoke(args.Instance, new object[] { args.Location.Name, args.Value });
        }

        public override void CompileTimeInitialize(PostSharp.Reflection.LocationInfo locationInfo, AspectInfo aspectInfo)
        {
            OnSetPropertyValueMethod = locationInfo.DeclaringType.GetMethod(
                "SetPropertyValue", BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic,
                null,
                new Type[] { typeof(string), typeof(object) },
                null);
        }
    }

Citizenship

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 22 Feb 2012 22:48:00 +0000

I am now a proud New Zealand Citizen.

Trying out the 'New' blogger interface

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 16 Feb 2012 01:41:00 +0000

Pretty sweet.
Probably been 'new' years ago. ;)

Blog name change

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 16 Feb 2012 01:40:00 +0000

Haven't been on my blog for ages, but decided it needed a name change.
Go figure.

I’ve joined the iPod/iPhone walking with earplugs army

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 14 Jul 2011 20:10:00 +0000

Yes, I am now one of those people! :D

protected internal

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 14 Jul 2011 20:09:00 +0000

I’ve used a protected internal property for the first time yesterday!

Never thought I’d need it. But there you go, after 10+ years of using C# I’ve finally had a reason. :D

What I’ve been up to

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 02 Jun 2011 07:22:00 +0000

It’s been almost 6 months since I’ve last been on my blog. A crazy busy time, so much has happened.

In February there was a quick unscheduled visit to South Africa to see my Dad, who at the time was not doing very well. After returning home he had a bit of a rebound, unfortunately he lost his battle with cancer a few weeks ago.

Work wise things are crazy, a million things on at the same time. I am very confident that the new infrastructure team will get us to were we want to go now. This will allow me to get more involved with the Development side of things again. Have really enjoyed the last couple of days in this regard.

I am desperately looking for a Help Desk Support Analyst, a junior/graduate .NET developer and a intermediate .NET developer. If you know anyone looking for one of these roles or are yourself interested then please drop me a line – pieter_jansen at gfsg . co . nz

blogging from iphone

noreply@blogger.com (Pieter Jansen van Vuuren) — Thu, 13 Jan 2011 05:57:00 +0000

Busy testing blogging from iPhone.

No time to blog

noreply@blogger.com (Pieter Jansen van Vuuren) — Wed, 08 Sep 2010 23:52:00 +0000

The title says it all. I have buckets full I can blog about, the problem is finding some free time to do it.

I’ve recently accepted the role of Head of I.T. at Grosvenor Financial Services Group Limited and this is taking up a lot of time I didn’t even know existed. ;)

I am loving the new role at the moment though. A lot of new challenges and opportunities. It continues to be an amazing feeling to work in information technology. There is just so much to keep up with and no day is the same. Yea, I love this!

Until later then.

Where to find the SyncToy Log files

noreply@blogger.com (Pieter Jansen van Vuuren) — Sun, 04 Jul 2010 20:04:00 +0000

You can find your SyncToy logs under the Local Application Data folder for the current user, i.e.:

C:\Documents and Settings\<%userName%>\Local Settings\Application Data\Microsoft\SyncToy\2.0

LiteSpeed and Log Backup error

noreply@blogger.com (Pieter Jansen van Vuuren) — Fri, 02 Jul 2010 02:20:00 +0000

I was getting this nasty error message this morning:

slssqlmaint failed [SQLSTATE HY000] (Error 50000). The step failed.

Turns our that I ‘accidently’ added a database to my LiteSpeed log backup maintenance plan that had its recovery mode set to Simple. Removed the offending Database from the list and the job started working again.

SyncToyCmd does not want to sync

noreply@blogger.com (Pieter Jansen van Vuuren) — Fri, 02 Jul 2010 02:16:00 +0000

I was getting the following error while trying to run SyncToy from the command line:

SyncToyCmd has detected that the folder pair Database Log Backups has not been synchronized yet. Please run SyncToy.exe to complete the initial synchronization.

Turns out all I needed to do was delete the Folder Pair and recreate it. Just a little bit of a pain, but worth it for this excellent tool.

Looking for a .NET Developer

noreply@blogger.com (Pieter Jansen van Vuuren) — Fri, 25 Jun 2010 02:12:00 +0000

I have just placed an ad for a .NET Developer on Seek

Grosvenor Financial Services Group Limited is a specialist financial services and investment management services provider with offices in New Zealand and Australia.

Are you passionate about technology?

Do you love developing software?

Does TDD, Inversion of Control, Dependency Injection, Continuous Integration and code reviews excite you?

Do you want to work on agile projects in an agile organization?

Have you got C# experience?

If you have answered ‘yes’ to all of the above, then send me your CV. We are looking for a .NET Developer to join our team.

We offer a competitive remuneration package which includes health and life insurance protection as well as bonuses for top performers. If you feel you are ready for the challenge please send your CV to:
pieter_jansen@gfsg.co.nz

I am Addicted to CodeRush

noreply@blogger.com (Pieter Jansen van Vuuren) — Sun, 06 Jun 2010 02:14:00 +0000