Mitch Wheat - Treat the cause, not the symptoms!

Perth .NET UG Meeting: What’s New in C# 4.0 – Joe Albahari

2009-11-03T18:28:00.001+08:00

Join us at the Perth .NET User Group, Thurs November 5th to hear Joe Albahari present on the new C# 4.0 features. C# 4.0 is just around the corner, and it introduces a number of much-requested features including optional parameters, named arguments and (horror) dynamic typing! We're going to demo all of C# 4.0's new features, discuss best practices, show off dynamic Office and Python interop, and explore some novel uses for dynamic typing that may not have crossed your mind. In particular, we'll examine a surprising pattern whereby a little quacking can make large classes much more manageable. VB programmers may attend - but please, no smirking!

TOPIC: What's new in C# 4.0 - Joe Albahari
DATE: Thursday, Nov 5th, 5:30pm
VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
COST: Free. All welcome

Joe Albahari is author of C# 3.0 in a Nutshell and the upcoming C# 4.0 in a Nutshell.

There will be a door prize of a LINQPad 10-user team license donated by Joe, and a choice of license from JetBrains (one of ReSharper , TeamCity Build Agent, dotTrace Profiler, RubyMine, or IntelliJ IDEA).

More details here.

Resuming Microsoft Download Manager

2009-10-29T21:44:00.001+08:00

Restarting the Microsoft Transfer Manager

If you have ever started a large download via the resumable Microsoft Transfer Manager, forgotten about it and shutdown your PC. You will no doubt have found yourself in the same situation I found myself in a few days ago. I started a download from the MSDN subscription site and later shutdown my PC. No problem I thought, I’ll simply resume the download.

Except I couldn’t find the Microsoft Transfer manager to restart it! There was no shortcut or entry in the Programs menu.

So where is the download manager located! After some hunting around, it turns out it lives at %windir%\Downloaded Program Files\TransferMgr.exe.

[Note: If you open that folder in Windows Explorer and find garbled names, open a console window (cmd.exe), change directory (CD) to C:\WINDOWS\Downloaded Program Files\, and run a list the contents (DIR). You should see TransferMgr.exe]

TIP: Once you have found and re-run Transfer Manager, there is an option to place a shortcut on the desktop. Click the Options button, and tick the checkbox “Place application shortcut on the desktop”.

Windows Azure Platform Training Kit - October Update

2009-10-28T09:55:00.001+08:00

Aligned with the SQL Azure October CTP release, Microsoft have published an updated version of the Windows Azure Platform Training Kit: Windows Azure Platform Training Kit - October Update

Among other things, the training kit contains the following SQL Azure related content:

Presentations

Introduction to SQL Azure
Building Applications using SQL Azure
Scaling Out with SQL Azure

Demos

Preparing your SQL Azure Account
Connecting to SQL Azure
Managing Logins and Security in SQL Azure
Creating Objects in SQL Azure
Migrating a Database Schema to SQL Azure
Moving Data Into and Out Of SQL Azure using SSIS
Building a Simple SQL Azure App
Scaling Out SQL Azure with Database Sharding

Hands On Labs

Introduction to SQL Azure
Migrating Databases to SQL Azure
Building Your First SQL Azure App

To try out SQL Azure you first need to obtain a SQL Azure token. Then there are a few differences connecting to the server, specifically using SSMS to connect to your DB in the cloud.

Visual Studio 2010 & .NET Framework 4 Training

2009-10-25T09:26:00.001+08:00

Microsoft have released the October preview of the Visual Studio 2010 & .NET Framework 4 Training Kit. This training content is ready to use with VS2010 Beta 2. You can download from here: Visual Studio 2010 and .NET Framework 4 Training Kit

In addition, Channel 9 has recently launched a free online learning centre that will host developer focused training courses created by developers for developers. The online training course allows developers to search for and browse the content without downloading the full training kit.

The Visual Studio 2010 and .NET Framework 4 Training Course includes videos and hands-on-labs designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including: C# 4.0, Visual Basic 10, F#, Parallel Computing Platform, WCF, WF, WPF, ASP.NET AJAX 4.0, ASP.NET MVC Dynamic Data.

Windows 7: They’re Here!!!

2009-10-21T22:13:00.001+08:00

Well almost! OK, granted I’m a few hours early, but it’s a bit like waking up early on xmas morning :)

Bye bye Vista, Hellooo Windows 7!

[Looks as if Microsoft’s OS fortunes are going to be nicely aligned with the economic recovery…]

The single Windows 7 license that was part of the Windows launch ‘party’ pack will be one of the prizes for the Perth .NET User Group December’s DevJam community event (since a single license, a party does not make!).

.NET Compact Framework Tips and Tricks

2009-10-07T09:44:00.001+08:00

I came across this useful list of Compact Framework Tips and Tricks posted by Chris Tacke on StackOverflow: .Net Compact Framework Tips, Tricks, and Gotchas

MVP Re-awarded

2009-10-04T12:29:00.001+08:00

A few days ago I was re-awarded with a Microsoft MVP and would once again like to thank everyone for their support and encouragement. A big thank you to Rose Stamell and Nick Ellery at Microsoft.

Ten LINQ Myths

2009-10-04T10:44:00.002+08:00

I was browsing over at Joe Albahari’s personal web site (Joe is the creator of the easy to use and very successful LINQPad, and one of the authors of O’Reilly’s excellent ‘C# in a Nutshell’) and noticed this 10 LINQ Myths: The ten most common misconceptions.

As well as being a C# guru, Joe is an active participant and supporter of the Perth .NET User Group. In fact, he will be presenting a session in November on the New features in C# 4.0 (More details will be posted shortly…).

Perth .NET UG Meeting: Friday, Oct 2nd: Introduction to the SQL Server 2008 Data Collector - Brad McGehee

2009-09-30T18:37:00.001+08:00

We are fortunate to have Brad McGehee present two sessions while he is in Perth. The second session is "Introduction to the SQL Server 2008 Data Collector". In previous versions of SQL Server, performance tuning was often difficult because the available tools weren't always easy to use or interpret. In SQL Server 2008, Microsoft is introducing the Performance Data Collector. This comprehensive new toolset has been designed to integrate the collection, analysis, troubleshooting, and persistence of SQL Server diagnostic information, making the jobs of DBAs much easier.

TOPIC: Introduction to the SQL Server 2008 Data Collector - Brad McGehee
DATE: Friday, Oct 2nd, 5:30pm - 7:00pm
VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
COST: Free. All welcome

Brad McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 14 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982. He is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars.

RedGate have generously donated a license to their excellent SQL Compare Pro.

More details here.

Perth .NET UG Meeting: How to Interpret Graphical Execution Plans - Brad McGehee

2009-09-30T18:33:00.001+08:00

Join us at the Perth .NET User Group in October for two talks with a SQL Server focus, aimed at both Developers and DBAs. We are fortunate to have RedGate's Brad McGehee present two sessions while he is in Perth. Brad is a frequent speaker at conferences around the world.

The first talk is Thurs October 1st, where Brad will present on "How to Interpret Graphical Execution Plans". One of the SQL Server black arts is how to read and interpret graphical Query Execution Plans. This is a key thing to understand as Execution Plans provide valuable clues as to why a particular query may be running slowly. In this session, you will learn how to read an Execution Plan, and learn what to do with the information you have gained from reading it.

TOPIC: How to Interpret Graphical Execution Plans - Brad McGehee
DATE: Thursday, Oct 1st, 5:30pm - 7:00pm
VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
COST: Free. All welcome

We will have pizza at this session courtesy of INETA.

RedGate have generously donated a license to their excellent ANTS Memory Profiler Pro. There is also a door prize of a choice of license from JetBrains (one of ReSharper , TeamCity Build Agent, dotTrace Profiler, RubyMine, IntelliJ IDEA).

Try to arrive early if you want a seat!

More details here.

Microsoft WebSiteSpark in Australia

2009-09-26T17:19:00.001+08:00

Microsoft has launched a new initiative, WebSiteSpark, aimed specifically at independent web developers and small web development companies. The only two requirements to join the program are:

Your company builds web sites and web application on behalf of others.
Your company currently has less than 10 employees.

The Australian launch of WebSiteSpark will be on the 8th of October.

What do you get?

Software licenses that you can use for three years AT NO COST. Once enrolled, you can download and immediately use the following software from Microsoft:

• 3 licenses of Visual Studio 2008 Professional Edition
• 1 license of Expression Studio 3 (which includes Expression Blend, Sketchflow, and Web)
• 2 licenses of Expression Web 3
• 4 processor licenses of Windows Web Server 2008 R2
• 4 processor licenses of SQL Server 2008 Web Edition
• DotNetPanel control panel (enabling easy remote/hosted management of your servers)

The Windows Server and SQL Server licenses can be used for both development and production deployment. You can either self-host the servers on your own, or use the licenses with a hoster.

For more info see Scott Guthrie’s post: Announcing the WebsiteSpark Program

Performance Tuning Guidelines for Windows Server 2008 R2

2009-09-19T00:01:00.001+08:00

Even though you no longer have to worry about disk partition alignment for SQL Server on Windows Server 2008 (you did on Windows Server 2003 and Earlier; see Disk Partition Alignment Best Practices for SQL Server), there are still important tuning parameters and settings that can result in improved performance for the Windows Server 2008 R2 operating system. You can download the document from here: Performance Tuning Guidelines for Windows Server 2008 R2.

Feynman: A Magician at Work

2009-09-01T07:58:00.001+08:00

It is often said that Richard Feynman was truly a magician. The Tuva project (apparently Bill Gates is its sponsor) at Microsoft Research is showing Richard Feynman’s ‘Messenger Series’ lectures. Although the format is slightly dated (check out the non-wireless microphone!), it does nothing to hide Richard Feynman’s infectious enthusiasm for science and its exposition. As Bill notes in his introduction, his motivation for making these publicly available is "...everybody ought to see these, as they make science interesting...".

If this has whet your appetite, check out The Feynman Lectures on Physics including Feynman's Tips on Physics: The Definitive and Extended Edition

Perth .NET User Group Meeting: Continuous Integration: Improving Quality and Reducing Cost

2009-08-30T21:33:00.001+08:00

Join us at the Perth .NET User Group, Thurs September 3rd to hear Colin Scott talk about Continuous Integration and why you should be doing it. Merging the work of multiple developers and producing reliable, deployable systems is a time consuming and tedious process that wastes developer effort that could be better spent on creating software. Continuous Integration (CI) allows us to automate these tasks and include automated testing and code analysis. This results in higher quality outputs at a lower cost. This presentation shows how to set up simple CI for .NET projects using readily available tools.

TOPIC: Continuous Integration: Improving Quality and Reducing Cost - Colin Scott
DATE: Thursday, Sept 3rd, 5:30pm
VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
COST: Free. All welcome

More details here.

Architecture Guidance

2009-08-30T10:50:00.001+08:00

If you have not seen it already, J.D. Meier (of the Patterns & Practices group at Microsoft) has created the Architecture Guidance Share wiki, a catalogue of software engineering principles, patterns and practices:

My purpose for this site is to share the body of guidance in software engineering that I've built over the years, while working with customers and experts in the field. While there's a lot of existing information on software engineering, it can often be difficult to find, understand or use.

See also the Patterns & Practices: Application Architecture Guide 2.0 which includes the downloadable .pdf document: Application Architecture Guide 2.0

Algorithms

2009-08-27T18:54:00.001+08:00

A programmer’s knowledge of algorithms can be (very) roughly divided into 3 categories:

Essential: Basic knowledge of the algorithms you use in your day-to-day work (hopefully, along with their ‘Big Oh’ Complexity, although it is surprising how often this is lacking…)
Desirable: Knowledge of a wide range of algorithms, including sorting, searching, graph algorithms etc.
Rarely Required in a Business Setting: Ability to Analyse an Algorithm’s Complexity

Now, I’m obviously not advocating that all programmers should be algorithm guru’s, but if you want to broaden your knowledge, here are a few places to start:

One of the classic Introduction to Algorithms books is Sedgewick’s Algorithms This used to be a single book (the format I read it in), but is now split into two volumes. It comes in various (computer) language versions, including C++: Fundamentals (parts 1-4) and Graphs (part 5). It is accessible, and covers most of the common algorithms you are likely to encounter (or need).

Another classic introductory book on the subject is Introduction to Algorithms by Cormen, Leiserson, Rivest and Stein (sometimes referred to as CLRS).

For an excellent free resource, check out the Introduction to Algorithms course on MIT OpenCourseWare (which uses CLRS as the course text; one of the authors, Prof. Leiserson, taught the course at MIT): MIT 6.046J / 18.410J Introduction to Algorithms

The course materials also contain video lectures. Here’s an example of why having at least some broader knowledge of algorithms and their application is useful: The skip list is a little known data structure (possibly because it is a relatively recent invention), and yet it is extremely useful and much easier to implement from scratch than many of the other balanced data structures: This is described in lecture 12.

Two books that are lighter and less formal are Algorithms in a Nutshell and the Algorithm Design Manual (Second Edition). Instead of formal mathematical proofs these books take a more practical approach, with real world problems and their solutions. They also show you how to estimate and measure the complexity of a solution. Both books are good, practical reference guides for programmers (I’m just about to add the Algorithm Design Manual to the Perth .NET User Group library…). Highly Recommended.

If you want something more advanced, then try these MIT OCW courses: 6.854J / 18.415J Advanced Algorithms, and the more mathematically advanced: 18.409 Topics in Theoretical Computer Science: An Algorithmist's Toolkit.

For learning how to analyse algorithms (and let’s be honest, it will be a rare event that you actually have to!), another of Sedgewick’s books, An Introduction to the Analysis of Algorithms, is a good place to start. A more advanced text is Concrete Mathematics: A Foundation for Computer Science and of course Knuth Volumes 1 - 3 (and the remaining volumes, which Knuth is releasing as ‘fascicles’…) which are not for the faint hearted and require considerable mathematical knowledge as a pre-requisite.

Parsing Log Files

2009-08-23T23:28:00.001+08:00

If you need to parse log files, before you decide to write your own parser, try using the free Log Parser from Microsoft:

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.

This post shows a nice example of SMTP Log Parsing, with the process automated via PowerShell.

The TechNet script centre contains several Examples of using LogParser.

Ten Common SQL Programming Mistakes

2009-08-22T08:18:00.001+08:00

There is a nice article over at Simple-Talk on Ten Common SQL Programming Mistakes. This tip, “Functions on indexed columns in predicates”, crops up a lot in production code, as the consequence of non-searchargs is not always obvious (until you know, of course!).

Free PowerShell ebook

2009-08-20T20:25:00.001+08:00

It’s old news by now, but this PowerShell ebook is free to download as a pdf: Mastering-PowerShell.pdf (thanks to Piers Williams for pointing this out).

Books, Books, Booko!

2009-08-15T22:00:00.001+08:00

If like me, you buy a lot of technical books each year, the opportunity to save a few dollars here and there really adds up. In the past, I have used Amazon(US) pretty much exclusively as it was always possible to save considerably on most (if at all) books in an order compared to the local retailers in Perth. And as a bonus, Amazon usually delivered them faster (from the US)!

Recently, a colleague let me know about Booko:

Booko is a site with a very simple goal - to find the cheapest place to buy books & DVDs

I’ve purchased 5 books in the last 4 weeks via Booko from 4 different sellers in 3 different countries. It’s a great way to save money on books. It is now my first stop, whereas before, I simply used Amazon.

Next time you need to buy a technical book, give Booko a go.

PDB Files: What Every Developer Must Know

2009-08-13T22:37:00.001+08:00

I’m a long time fan of John Robbins’ work, and over the years I’ve followed his blog, MSDN column and purchased several of his excellent debugging books.

He posted a must read blog entry that I meant to mention a while back: PDB Files: What Every Developer Must Know.

Here’s a snippet:

The most important thing all developers need to know: PDB files are as important as source code! …
At a minimum, every development shop must set up a Symbol Server … Briefly, a Symbol Server stores the PDBs and binaries for all your public builds. That way no matter what build someone reports a crash or problem, you have the exact matching PDB file for that public build the debugger can access. Both Visual Studio and WinDBG know how to access Symbol Servers and if the binary is from a public build, the debugger will get the matching PDB file automatically.

Windows 7 Just keeps Getting Better

2009-08-08T10:36:00.002+08:00

As most people are aware, Windows 7 went RTM and is now available to TechNet Subscribers (and many of those that took part in the Beta program). First impressions are that it feels even faster than the RC release! It installed flawlessly. Easy as.

This is simply, the best OS Microsoft have ever released.

I re-ran the Windows experience index:

Interestingly, my disk score has fallen 0.1 points, which is shame as it’s the slowest component. Rather surprising, given that it’s an SSD (and one with a reasonably high performance). I feel a bit of tweaking coming on…

So never mind your poser laptop with the nerdy cover light! Can it compete with a real PC? ;)

SQL Server 2008: ETL Data Load: 1 TB in 30 Minutes!

2009-08-02T11:35:00.001+08:00

I came across this excellent article on MSDN: We Loaded 1TB in 30 Minutes with SSIS, and So Can You, detailing the design and implementation of a large data load using SSIS. The work was actually done back in February 2008.

Summary: In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios. Even for customers who don't have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.

SQL Server 2008: Script Data as Inserts

2009-07-23T20:54:00.001+08:00

I expect many people know this already but just in case you don’t: in addition to scripting your database schema as TSQL, you can also generate data insert scripts directly from SQL Server 2008 Management Studio. Right-click on your database in SSMS, select Tasks –> Generate Scripts, ensure your database is highlighted and click next. Scroll down the options list to the “Table/View Options” section, and change “Script Data” to True.

(I’m not sure if this was also present in SQL Server 2005, as I don’t have an instance to hand).

.NET: Determine Whether You Are Running in a 32-bit or 64-bit Process

2009-07-19T11:28:00.001+08:00

Saw this excellent tip on StackOverflow today: You can use IntPtr.Size to determine whether you are running in a 32-bit or 64-bit process, as it will be 4 or 8 bytes respectively.