Thoughts anyone on the new blog theme.
Archive for July, 2008
Updated blog theme
July 28th, 2008
Lost data will rescue
July 26th, 2008
A while ago my external backup drive died. I tried everything short of sending it off to a place like Doctor Disk to get the data restored at exorbitant prices. So with little hope of getting all the data back I left the disk for another day.
Until recently when I found File Scavenger a great little program that is currently recovering all of the content of the disk. I have my fingers crossed hoping that i will have my precious data safe.
Anyone know of any other programs like File Scavenger that would do the same? Anyone have any experience with File Scavenger and the issues with it. What would you recommend?
Article on DDD In An Example
July 21st, 2008A really good article in using Domain Driven Design in Practice from Srini Penchikala on InfoQ
Technorati Tags: Domain Driven Design,Domain Modeling
Proper Case in SQL
July 18th, 2008First up Proper Case is really Title Case. And if you ever need to convert text to Title Case in SQL you can use Vyas Kondreddi’s PROPERCASE SQL script or David Wiesman’s PROPERCASE SQL script
My only change to their scripts would be to use NVARCHAR(MAX) or VARCHAR(MAX) as compared to their use of VARCHAR(8000), if your using SQL Server 2005 or above.
1: CREATE FUNCTION [dbo].[fProperCase]
2: (
3: @Value VARCHAR(8000),
4: @Exceptions VARCHAR(8000),
5: @UCASEWordLength TINYINT
6: )
7: RETURNS VARCHAR(8000)
8: AS
9: BEGIN
10: ...
11: END
So I would covert the above syntax when using SQL Server 2000 to the T-SQL below when using SQL Server 2005
1: CREATE FUNCTION [dbo].[fProperCase]
2: (
3: @Value VARCHAR(MAX),
4: @Exceptions VARCHAR(MAX),
5: @UCASEWordLength TINYINT
6: )
7: RETURNS VARCHAR(MAX)
8: AS
9: BEGIN
10: ...
11: END
Upgraded to WordPress 2.6
July 18th, 2008I have now upgraded to WordPress 2.6, most things seem like they are working perfectly however i think that my comments may not be working. Something to look into tommorow.
Turbo mode, and revision tracking have got me very excited. Check out this video for more detail.
Using the CLR on SQL Server 2005 with 4GB Ram or More
July 14th, 2008For most people using SQL Server CLR is not an issue however when you have more that 4GB or more of memory, the CLR does not just work.
Enter the –g startup switch, You can read more about the SQL Server 2005 startup options to get the fine detail. In order to make the required changes follow these steps
1.) Launch SQL Server Configuration Manger
2.) Under Sql Server 2005 Services choose the instance of SQL Server that you are targeting for the change and right click on it and select Properties.
3.) Move to the Advanced Tab and locate the Startup Parameters
4.) Add the –g option to the end by first closing the previous parameter with a ‘;’ then –g, not adding the ‘;’ to the end of the previous parameter will cause SQL server to fail on restart
5.) Click Apply /OK and restart the service. When the service restarts you should now have SQL CLR on your machine. A simple Hello World CLR stored proc should do tell you if your in business or not.
Technorati Tags: SQL Server 2005 CLR,enable clr
The Long Drop
July 13th, 2008Edwin Fitzpatrick the State Manager of Victoria for CCH and myself had a deal if we delivered the System that we were working on for the last 8 months on June 30th we would we through ourselves out of a plane, with a parachute of course.
Now June 30th has come and gone and we released and rolled out the software on the 30th of June very successfully. Yes there were hiccups but hey what software development project does not have them. Not one of those hiccups stopped us from moving forward. All credit for this great success is due to the great team and their fantastic work.
Back to the jump. While most people wonder why any person would throw them selves out of a perfectly good airplane, I did it! No Nancy half hearted tandem jump either, a solo the only way to truly test yourself. and yes I would do it again.
The only disappointing thing about the jump was that when I did jump out of the plane at 14,000 feet the camera got way too much frost on the lens therefore all my antics in the sky were useless. I will however post footage of my pre and post flight shenanigans.
