Mainfram Reality

I’ve added a new photo gallery where I am going to upload photographs I take and wish to share with the world.Photo Gallery

What could be my first subject but my daughter Maya.

I did use Adobe Photoshop for some touch ups as well as black and white photos.

What a Christmas present, for myself. My wife and I wanted a digital SLR for a long time, especially now little Maya has joined our family.Photography was always something I wanted to explore. I got my first camera at very early age and my dad who was a journalist loved photography. Unfortunatelly I haven’t had time nor budget to really get into photography, but now I am planning to devote at least a little free time I have to learning how to use the new camera.

Well over last month or so I have been migrating my build scripts from NAnt to MSBuild for all my Microsoft .NET 2.0 projects.The MSBuild task set is not as comprehensive as the Nant task set, but extending MSBuild with custom tasks is quite easy.Below is the list of reference sites for MSBuild, everythingrequired to get started with MSBuild.

MSBuild Reference and Links

MSBuild Team Blog

Everything and anything about MSBuild, the new build engine for managed code in Visual Studio 2005.

MSDN MSBuild Reference

MSBuild is the new build system for Microsoft and Visual Studio. This section contains MSBuild reference information.

MSBuild Preview Quickstart Tutorials

The MSBuild team provides several tutorials on MSBuild, each of which includes sample projects and documentation.

MSBuild Tasks

MSBuildTasks.com is a community web site for MSBuild tasks. The goal of the site is to provide a central directory for information about tasks for MSBuild. Please help this community grow by posting tasks and links to tasks in the Files section of this web site.

Microsoft Build Sidekick

MSBuild Sidekick is a tool for MSBuild Engine users providing Graphic User Interface front-end for editing MSBuild project files. The build project files may be either created as Microsoft Visual Studio© 2005 build projects or as Team Foundation Team Build build types.

This post describes how to find values that are missing from the sequence of numbers. I’ve had this problem on a project that uses MySQL, but the code can easily be adopted to work with MSSQL or other SQL engines.SetupFor the purposes of this example, lets create a table called testmissing.The table has one integer column num. The num column will be populated with values from 1 to 20 with numbers 6, 12, 13 and 15 missing;CREATE TABLE testmissing ( num int not null);INSERT INTO testmissing(num) VALUES (1), (2), (3), (4), (5), (7), (8), (9), (10), (11), (14), (17), (18), (19), (20);Get Missing NumbersThe SQL statement below will return the missing numbers from the sequence created above. SELECT tm1.num + 1 AS missing_numFROM testmissing AS tm1 LEFT OUTER JOIN testmissing AS tm2 ON tm1.num + 1 = tm2.numWHERE tm2.num IS NULLORDER BY missing_num;Please note the following:

• Number 13 is not returned. This is because each missing number returned is a starting point of a continuous sequence of missing numbers. Since 12 is missing, 13 will be returned as missing as soon as 12 is found in the table.
• 21 is returned as missing as well even though number 22 is not in the table.