SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Friday, June 29, 2007
SQL Server: Taming Your Transaction Log
Ignoring the slightly cheesy story and author pseudonym, this is good starting point for getting a large transaction log under control. Remember, it's always wise to backup your transaction log (and data file) before making any changes.
Wednesday, June 13, 2007
TechEd 2007 Online
The list of TechEd 2007 on-demand webcasts available for download is here. It's a great resource, but the whole download process from MS Events is fairly ugly! I have mentioned this before, but it has not improved in the last year...
Sunday, June 10, 2007
Programmer Personality Test
Apparently, I'm a DHSB
What type of programmer are you? Take the test here!
Saturday, June 09, 2007
Of Interest: Roundup
Enterprise Library 3.1: A new version of the Enterprise Library 3.1 was released in May. You can download it from here.
The Smart Client Software factory was also updated in May. The download link is here.
Subsonic was also updated mid-May to version 2.0.1. Subsonic is an ActiveRecord based Code Generation tool and is well worth checking out. You can literally get a website up and running in less than 30 minutes! You can download from CodePlex here and check out the screencast walkthrough. David Hayden’s short version of the same is here.
The Windows Forms site seems to have metamorphosised into http://windowsclient.net/ to include WPF. There are videos, controls and a windows forms FAQ.
Virtual: Over at Microsoft TechNet you can try out Windows Server 2008 via a collection of Virtual Labs. In fact, there are an extensive range of these here for many Microsoft products.
SQL Server 2005: Must read article Top 10 Hidden Gems in SQL Server 2005. Also of interest is the SQL Server 2005 Performance Dashboard, a collection of Reporting Services reports for monitoring and resolving performance problems. You can download the .msi file here. For a comprehensive overview of installing and running the reports have a read of Making the Most Out of the SQL Server 2005 Performance Dashboard by Brad M. McGehee
Biztalk: If you haven't already seen it, this article contains 8 good tips.
If that didn’t give you enough to do, can anyone tell me how Microsoft thinks it’s a good idea that if I copy and paste something into an Outlook 2003 email from a web page, and I’m on dialup, Word 2003 comes to a halt too?!? To say it is annoying, is a bit of an understatement!
Free e-Books at Apress
There are several free, downloadable e-books at Apress here including
The last one is of particular interest. It describes the design, development and refactoring of SharpDevelop, an open-source alternative to the Visual Studio IDE.
Tuesday, June 05, 2007
DiffMerge: A free Difference and Merge Tool
Eric Sink of SourceGear fame has posted that SourceGear have released DiffMerge, a free tool for comparing and merging source files and folders. It includes:
There aren't that many good, free merge tools around, and certainly not many that provide three-way merge and intra-line highlighting.
Sunday, June 03, 2007
MCPD: Web and Windows
Last week I sat and passed two Microsoft exams, 70-551 and 70-552. Whilst this does not make me a better developer than someone who does not pursue the certifications (I know several developers who have none and are exceptionally skilled), it does force me to look at areas I might not use day-to-day.
This post, by Vishal Joshi, details the various upgrade paths to certification with a great additional comment by Rob Farley, which is the direction I've taken [MCPD:EAD = MCSD +551 + 552 + 554]
How To Research Efficiently
Having just mentioned "Team Development with TFS" I couldn't pass up the opportunity to mention this gem of a post by J.D.Meier on How to Research Efficiently. It is a simple and highly effective way to be more productive. You might recognise the name J.D.Meier from the Patterns and Practices Guidance team, and from the numerous MSDN articles and books he's either written or been involved with.
Team Development with TFS
The Patterns & Practices Team has released a Beta version of their "Team Development with TFS" document here. The original "Team Development with Visual SourceSafe" document was just 7 Chapters long; the new one weighs in at 17 Chapters and 360 pages!
MSN, Email: mitch døt wheat at gmail.com