MrDee

ViewState 101

2009-10-29T10:44:00.000+13:00

TRULY Understanding ViewState - Infinities Loop

ViewState is a very misunderstood animal. I would like to help put an end to the madness by attempting to explain exactly how the ViewState mechanism works, from beginning to end, and from many different use cases, such as declared controls vs. dynamic controls.

I wish I had written this

2009-10-21T09:21:00.002+13:00

Five Simple Database Design Errors You Should Avoid

Clear, concise and on the money.

This article covers:

(1) Common Lookup Tables
(2) Check Constraint conundrum
(3) Entity-Attribute-Value Table
(4) Application Encroachments into DB design
(5) Misusing Data values as Data Elements

Fun with triggers

2009-10-05T14:41:00.010+13:00

What Happened:
1) Insert occurs - fires insert trigger (value 10)
2) Insert trigger updates record (value = 20) - fires update trigger
3) Update trigger updates record (value = 30) this does NOT fire a recursive call to the trigger
4) Update trigger writes hist record
5) Original insert trigger writes hist record
Hmmm interesting....

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MainTable]
( [MainTableID] [int] IDENTITY(1,1) NOT NULL
, [TheValue] [int] NOT NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[MainTable_Hist]
( [MainTable_HistID] [int] IDENTITY(1,1) NOT NULL
, [Created] [datetime] NOT NULL
CONSTRAINT [DF_MainTable_Hist_Created] DEFAULT (GETDATE())
, [MainTableID] [int] NOT NULL
, [TheValue] [int] NOT NULL
) ON [PRIMARY]

GO

CREATE TRIGGER [dbo].[trgMainTable_UPD]
ON [dbo].[MainTable]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;

DECLARE @ThisValue AS INT
      , @ThisID AS INT

SELECT @ThisID = MainTableID
     , @ThisValue = TheValue
FROM inserted

IF ( @ThisValue < 100 )
UPDATE dbo.MainTable
SET TheValue = @ThisValue + 10
WHERE MainTableID = @ThisID

INSERT INTO [dbo].[MainTable_Hist] ( [MainTableID], [TheValue] )
SELECT MainTableID, TheValue
FROM Inserted
END
GO

CREATE TRIGGER [dbo].[trgMainTable_INS] ON [dbo].[MainTable]
AFTER INSERT AS
BEGIN
    SET NOCOUNT ON;
    DECLARE @ThisValue AS INT
    DECLARE @ThisID AS INT

    SELECT @ThisID = MainTableID , @ThisValue = TheValue
    FROM inserted IF ( @ThisValue < 100 )

    UPDATE dbo.MainTable
    SET TheValue = @ThisValue + 10
    WHERE MainTableID = @ThisID

    INSERT INTO [MainTable_Hist] ( [MainTableID], [TheValue] )
    SELECT MainTableID, TheValue
    FROM Inserted
END
GO

INSERT INTO [MainTable] ( [TheValue] ) VALUES ( 10 )
GO

--==--==--==--==--==--
SELECT * FROM [MainTable] ORDER BY MainTableID

MainTableID TheValue
1           30

SELECT * FROM [MainTable_Hist] ORDER BY MainTable_HistID

MainTable_HistID Created                  MainTableID  TheValue
1                2009-10-05 14:33:02.553  1            20
2                2009-10-05 14:33:02.553  1            10

SQL Stupidity

2009-09-29T13:03:00.003+13:00

So you are logged on to SQL Management studio.
The user you are logged in as has database X as the default database
Now you detach that database... and you are stuck - the connection fails, you can't do anything.

DUH!

A warning would have been nice.

SOLUTION: Connect as another user and set the default database to something else then re-connect.

Excellent resource on Cancer

2009-08-03T09:59:00.001+12:00

BBC NEWS | Health | Cancer: The facts

One in three of us will be diagnosed with cancer during our life.

Open Government and Local body data

2009-07-02T10:42:00.004+12:00

Open Data Catalogue

Opengovt.org.nz is an open, independent catalogue of Government and Local Body datasets

Looking to download the latest list of Primary Schools? Want to find out the average market rents for Dunedin suburbs and use these in a report? Are you interested in the boundaries of your suburb? If the answer is yes then you may find some of this information hard to come by. Even though this information should be easy to obtain it is sometimes hard to find who to talk to, where to look and worse hidden behind pay-walls and restrictive license agreements. The Open Data Catalogue is an attempt to classify where this information resides, who ‘owns’ it, what license it is distributed under and if it is free or not.

Including SPATIAL datasets

marriage advice for IT peeps

2009-06-03T10:24:00.001+12:00

CIO > Why (some) IT people's marriages are from hell

With the right type of communication, and by taking small, proactive measures to demonstrate that they're thinking about their spouses, IT leaders can have happier, more satisfying marriages, says a psychoanalyst turned life coach.

Elegant solution for juggling windows

2009-05-27T16:41:00.002+12:00

WinSplit Revolution: "WinSplit Revolution is a small utility which allows you to easily organize your open windows by tiling, resizing and positioning them to make the best use of your desktop real estate."

WinSplit Revolution is freeware. Some Rights Reserved.

What’s your favorite “programmer” cartoon?

2009-05-26T16:49:00.001+12:00

What’s your favorite “programmer” cartoon?

Usability Testing

2009-05-05T09:53:00.001+12:00

Usability Testing With 5 Users

The ultimate user experience is improved much more by three tests with 5 users than by a single test with 15 users

New to computing? Have a friend/parent wanting to become digital? - try this!

2009-04-30T09:28:00.002+12:00

Digital Literacy Curriculum Original Version XP/Office 2003

Digital Literacy Curriculum II Vista/Office 2007

Cut 8 wires and see what happens

2009-04-24T11:55:00.001+12:00

Bruce Perens - A Cyber-Attack on an American City

The city of Morgan Hill and parts of three counties lost 911 service, cellular mobile telephone communications, land-line telephone, DSL internet and private networks, central station fire and burglar alarms, ATMs, credit card terminals, and monitoring of critical utilities. In addition, resources that should not have failed, like the local hospital's internal computer network, proved to be dependent on external resources, leaving the hospital with a "paper system" for the day.

The rest of the article is very interesting.

Oracle debug - output a CRLF delimited block of text

2009-04-14T16:05:00.000+12:00

v_crlf CHAR(2):=CHR(13) || CHR(10);

v_RemainingText:=v_Orig_Text || v_crlf ;
WHILE length(v_RemainingText) > 1 LOOP
    v_crpos:=instr(v_RemainingText,v_crlf);
    v_ThisText:=substr(v_RemainingText,1,v_crpos-1);
    dbms_output.put_line(v_ThisText);
    v_RemainingText:=substr( v_RemainingText
                           , v_crpos+2
                           , length(v_RemainingText)-(v_crpos+1)
                           );
END LOOP;

VPC Images for testing IE6, 7, 8

2009-03-27T09:22:00.001+13:00

Download details: IE App Compat VHD:

Nice Free Icons

2009-03-24T09:16:00.001+13:00

Free Icons: Function Icon Set, 128 Completely Free Icons

I Speak Geek

2009-03-18T13:45:00.001+13:00

Scott Hanselman's Computer Zen - FizzBin - The Technical Support Secret Handshake:

Fun with Foreign Keys

2009-03-13T09:37:00.000+13:00

SELECT object_name(SR.rkeyid) AS Master
     , RC.name                AS Master_Column
     , object_name(SR.fkeyid) AS Child
     , FC.name                AS Child_Column
     , object_name(SR.constid)AS FK_Name

FROM       sysreferences SR
INNER JOIN sys.columns   RC ON RC.Object_ID = SR.rkeyid AND RC.Column_ID = SR.rkey1
INNER JOIN sys.columns   FC ON FC.Object_ID = SR.fkeyid AND FC.Column_ID = SR.fkey1
ORDER BY object_name(SR.rkeyid)
       , object_name(SR.fkeyid)

I Am Employed

2009-01-27T09:37:00.000+13:00

Web developer at iSoft

You know you want to

2008-12-04T16:48:00.000+13:00

I don't come in different colours or sizes, but I am great value for money.
This year you could have your very own MrDee working at your place. (as long as your place is in Auckland)
As of tomorrow I am officially on the Job market.
So drop me a line I would love to chat.

What was XTRA thinking

2008-12-03T11:52:00.002+13:00

Yesterday I posted an article about the Google streetview technology.
I saw it last year and took a virtual tour of Brooklyn NY. Brilliant.
I never dreamed that NZ would be in the first 10 countries to get this. Well done Google.

So when XTRA, the number one ISP in NZ (by volume) looked for a partner to offload their e-mail capability they selected Yahoo.
I assume this 'partnership' was because of the care and concern Yahoo has for our country.
just look at the stunning level of detail in the auckland Yahoo map

Pitiful.

Yahoo mail is hostile, the data is stored off shore and XTRA is still crashing more often then a drunk university student in Palmerston north.

Can anyone recommend an ISP that is affordable and still works for their money?

Walk on by...

2008-12-02T09:43:00.001+13:00

Map here

I will wave at you from my desk :D

A support headache cured.

2008-11-07T09:51:00.001+13:00

Computerworld > Microsoft discontinues Windows... 3.x

As of November 1, 2008 Microsoft has stopped issuing licences for Windows 3.x, which debuted in May 1990.

Published! (sort of)

2008-11-06T14:30:00.000+13:00

Ask Phoebe : Grab a street map - you'll need it - 06 Nov 2008 - NZ Herald:

I have tried, to no avail, to discover the scale and extent of the roadworks on the Te Atatu interchange. A sign warned that the work would take from October 2008 to February 2009, but what exactly is being done? Is there a website that will explain this to me? Andrew Dixon, Te Atatu.

Try, Doh!, Whatever

2008-10-07T12:37:00.001+13:00

Jeff Atwood : VB.NET adds the "ain't" keyword

Microsoft is also reported to be experimenting with "AsIf", "Maybe", and "Totally". In addition, "Catch" will likely be replaced with "Doh!", and "Finally" will be replaced with "Whatever".

MeDee: Code project Author

2008-10-03T16:01:00.003+13:00

CodeProject: Database Deadlocks for Dummies.

Trying to explain a database / transaction deadlock to a non-technical person can be a challenge.

The concept however is something we have dealt with since pre-school.

Imagine a simple colouring exercise of the globe. Unless you are artistically gifted, blue and green are all that is needed to complete the picture. Being a state funded school, there is only one green and one blue crayon.