Wednesday, April 07, 2004

Latest version of the WSS FAQ PDF file created and uploaded

Latest version of the WSS FAQ PDF file created and uploaded [Mike Walsh's WSS, Finland and more]

"Latest version of the WSS FAQ PDF file created and uploaded
Once again after a somewhat greater effort than usual, I've created a PDF file of the present state of the WSS FAQ part of the WSS FAQ site (confused yet?).

This is now the 20th 'issue' since the WSS FAQ started off about this time a year ago and you can find it here

http://wss.collutions.com/Documents/FAQv20.pdf"

Download details: Excel Excess Formatting Cleaner Add-in

Download details: Excel Excess Formatting Cleaner Add-in

"Overview
The Excel Excess Formatting Cleaner Add-in program removes all formatting that has been applied beyond the cell range that contains data, or beyond the cell range that is covered by shapes, in each worksheet in the workbook. This reduces the file size of a converted Lotus 1-2-3 file or of a file that has formatting applied beyond the data range.

You can also use this add-in program to resolve various printing and viewing problems that are caused by extra formatting that is applied outside the last cell (as defined by the UsedRange property to determine which cells in the worksheet contain data). This add-in automates one of the most frequent steps that Microsoft Product Support Services (PSS) support professionals perform when they are troubleshooting these issues."

Interesting...

MS Bob 1.0a on MSDN Subscriber Downloads...

Just got this on the MSDN Subscriber RSS Feed

"Microsoft Bob 1.0a
Microsoft Bob 1.0a was posted to MSDN Subscriber Downloads on March 31, 2004.
Wed, 31 Mar 2004 05:36 PM"

LOL... I can't seem to find it there though... I want it... um... just cuz?

Understanding Isolated Storage - .NET Developers

Understanding Isolated Storage - .NET Developers

Very nice Isolated Storage article...

Free Range SQL - It tastes better.

Free Range SQL - It tastes better.

Interesting approach to flexible queries without giving up stored procedure usage...

" common requirement from users is the ability to be able to search on the columns they want.
In affect they would like to roll there own queries.
As an example take the Employees table in Northwind. The user wants to be able to search on any/all fields.
If your development environment only allows stored procedures then the usual solution is to use the ISNULL or COALESCE for each column in the WHERE clause.
SELECT * from Employees WHERE EmployeeID = ISNULL(@EmployeeID, EmployeeID)

Problem is, performance sucks..At best you will get an index scan...
There are some ways to build the predicate that can make use of index efficiently depending on the data type, but in most cases, the column needs to be NOT NULL. Some techniques

The other solution is dynamic SQL. This raises the stress on security ,specifically injection, compared to the type parameters used in Stored Procedures.
But by bringing together sp_executesql, column ordinal positions, some bit wise arithmetic and finally a standard naming convention, we can overcome the security and performance issues while satisfying the users requirements.."

Classic Live - SimCity.com

Classic Live - SimCity.com

Nice... You can play SimCity Classic free online...

Tuesday, April 06, 2004

Application Domain FAQ

Application Domain FAQ

Nice .Net AppDomain FAQ

"This compilation of Frequently Asked Questions & answers (FAQ) is intended to answer several of the questions about application domains asked by developers writing managed code that uses the Common Language Runtime (CLR) Base Class Library (BCL) APIs.

This document concerns itself only with the managed BCL view of application domains. This FAQ does not address application domain programming for unmanaged code developers, nor does it address how to host the CLR."

Monday, April 05, 2004

Windows Installer XML (WiX) toolset has released as Open Source on SourceForge.net

Windows Installer XML (WiX) toolset has released as Open Source on SourceForge.net

" The Windows Installer Xml (WiX) toolset (pronounced "wicks toolset") appears to have finished propagating around the SourceForge.net CVS servers, so I can finally start writing this blog entry. As promised in my blog here, here, here, here, and here the WiX toolset and all of its source code has been released so that you can build Windows Installer databases (MSI and MSM files) the same way most groups inside Microsoft do. However, a funny thing happened on the way to the forum. WiX became the first project from Microsoft to be released under an OSS approved license, namely the Common Public License.

Before everyone gets sidetracked by the Open Source implications, let’s talk about exactly what WiX is. WiX is a toolset composed of a compiler, a linker, a lib tool and a decompiler. The compiler, called candle, is used to compile XML source code into object files that contain symbols and references to symbols. The linker, called light, is fed one or more object files and links the references in the object files to the appropriate symbols in other object files. Light is also responsible for collecting all of the binaries, packaging them appropriately, and generating the final MSI or MSM file. The lib tool, called lit, is an optional tool that can be used to combine multiple object files into libraries that can be consumed by light. Finally, the decompiler, called dark, can take existing MSI and MSM files and generate XML source code that represents the package."

Very cool... I dig that MS is releasing more and more as Open Source...

How SharePoint Works (Barracuda .NET)

How SharePoint Works (Barracuda .NET)
"Technical Whitepaper for Software Developers and System Architects"

Nice indepth article on how SharePoint works targeted at Dev's...

Steganography - Hiding messages in the Noise of a Picture

Some interesting links... Not that I need to hide anything, but the concept is pretty cool.

And being in the EDD business this is of professional interest...

The Code Project - Steganography - Hiding messages in the Noise of a Picture
"Hiding all kinds of data in the pixels of bitmaps."

The Code Project - Steganography II - multiple key and carrier files
"An article about spreading hidden data over many images."

The Code Project - Steganography III - Change only one Bit per Pixel
"An article about hiding each byte of a message bit-by-bit in eight pixels."

The Code Project - Steganography IV - Reading and Writing AVI files
"An article about hiding bytes in the bitmap frames of uncompressed AVI files."

Saturday, April 03, 2004

Cool Freeware - Bayden Systems

Bayden Systems

Some cool freeware things... IE addin's, some dev components and other utility apps...

The FavCave (web service for storing your favorites) looks interesting.