Thursday, December 23, 2004

VFP: Change DSN Database on the fly

So I had to do some import work, using both SPT and Remote Views (which means a connection pointed to a DSN). Needed away to easily switch between databases.

It goes a little something like this...

*-- Flavor SERVER, UID and PWD to taste.
*-- Change server name in SetDataBase proc as well
#DEFINE HKEY_LOCAL_MACHINE -2147483646 && BITSET(0,31)+2
LOCAL lnConn && connection handle for SPT

SetDataBase("LIVE", @lnConn)

* do some stuff to LIVE data

SetDataBase("STAGE", @lnConn)

* do some stuff to STAGE data

PROCEDURE SetDataBase(tcDatabase, tnConnection)
* Set connection handle to current database
tnConnection=SQLSTRINGCONNECT(C_CONNECT_SQL + m.tcDatabase )
* change DSN to current database
lcRegFile = HOME()+"samples\classes\registry.prg"
oReg = CREATEOBJECT("Registry")
oReg.SetRegKey("DataBase",m.tcDatabase ,;
RETURN m.tnConnection

sorry about the wrapping... this template isn't very code friendly...

Wednesday, December 22, 2004

100 programmers are lined up in a row by an assassin...

answers to technical interview questions

I was asked this question several months ago when I interviewed for a full-time gig at Microsoft. There were only 10 in the room, and I figured out how to save 6... but the best solution is much simpler than I imagined...

Thanks to John Donaghy for the link!

Monday, December 20, 2004

A Taste of XQuery for the DBA

A Taste of XQuery for the DBA

Eric McMullen has a good article on XPath in SQL 2005. XPath is the way to query XML data sets -- it's been well integrated into the next version of SQL Server.

VFP9 ships!

December 2004 - Letter from the Editor


Mad props to the team, you guys did an amazing job!

Really large datasets in VFP

FoxPro Advisor :: The Ultimate Power & Speed of VFP

This article has been around for awhile, but it just surfaced in conversation recently. VFP is being used for the "Euro Tunnel". The data requirements for this application include 128 GB of data. Yes, VFP has a 2GB per table limit (not going to change), but this article points out how you can work around this limitation.

Monday, December 13, 2004

New Google trick

Well, new to me. Google Suggests type in a few characters and wait... (or hit the down arrow if you must...)

Friday, December 10, 2004

RF exposure FCC

I need a new cell phone, considering Bluetooth so I can have a wireless headset. Came across this:

"Tests for SAR are conducted using standard operating positions specified by the FCC with the phone transmitting at its highest certified power level in all tested frequency bands. Although the SAR is determined at the highest certified power level, the actual SAR level of the phone while operation can be well below the maximum value. This is because the phone is designed to operate at multiple power levels so as to use only the power required to each the network. In general, the closer you are to a wireless base station antenna, the lower the power output. Before a phone model is available for sale to the public, it must be tested and certified to the FCC that it does not exceed the limit established by the government-adopted requirement for safe exposure. The tests are performed in positions and locations (e.g., at the ear and worn on the body) as required by the FCC for each model. (Body-worn measurements may differ among phone models, depending upon available accessories and FCC requirements). While there may be differences between the SAR levels of various phones and at various positions, they all meet the government requirement for safe exposure.

For body worn operation, to maintain compliance with FCC RF exposure guidelines, use only accessories that contain no metallic components and provide a separation distance of 15mm (0.6 inches) to the body. Use of other accessories may violate FCC RF exposure guidelines and should be avoided."

Boot Camp - Mashing for Beginners

Great tutorial on "Mashing" -- puting two songs on top of each other. Includes Mackie's currently "Free" editor.

Tuesday, December 07, 2004

IBM Sells PC Business for $1.75 Billion

Well, maybe this means the Transnote could make a comeback.

Wednesday, November 24, 2004

Windows Installer Appears Every Time I Start an Application

I've run into this more than once, here is a an "unsupported" work around. is a repository of such things...

Thanks to Tristan of ProFox.

Tuesday, November 23, 2004

Construx: Construx Estimate

"Construx Estimate contributes to project success by helping improve your software estimation capabilities. Estimate leverages a blend of proven estimation models to predict effort, budget, and schedule for your project based on size estimates. Estimate comes calibrated with industry data, but is most powerful when calibrated with your organization's data.
As part of our mission to advance the art and science of commercial software engineering, we provide Construx Estimate™ version 2.0 free of charge with a limited license."

Construx is the group that Steve McConnell (of Code Complete) runs. Great book, interesting tool. Thanks Boudewijn Lutgerink.

Monday, November 22, 2004

Firefox Extensions

Everybody knows how cool FireFox is... I've been addicted to tabbed browsing since Mozilla first introduced it. FireFox doesn't stop at just the browser... check out the extentions!

First -- if you love tabbed browsing, check out the Tabbrowswer Extentions. Great control over how tabs load and save. You can have all tabs come back up after a crash or even shutdown...

BlogThis! is like the Blogger link you get in the Google Toolbar...

FlashGot lets you pull down multiple files from a webpage in one move...

FoxyTunes lets you control Media Player, WinAmp, REAL, etc from a small controller in the browser status bar...

Oh... and a native behavior for FireFox... if you are on a site that supports RSS feeds, you should see a small orange icon in the bottom right hand corner of the screen. Click on it, and you'll create a bookmark that pulls the RSS feeds. Save the bookmark under the BookMarks ToolBar Folder and when you click on the link, you'll see the last several feeds from the site... too cool!

Toad® for SQL Server

"Toad® for SQL Server is a freeware tool that improves the productivity of developers and administrators by providing an easy-to-use development environment for T-SQL code."

Been around for awhile, this is a great tool -- a must for SQL Server DBA's and developers. Stored procedure version control, lots of automation...

Fully functional 60 day eval version available under Software Downloads.

Thursday, November 18, 2004

Who wants to be the Next Top Model?

Business Model Generator

"This is a free service provided by a research group of volunteers from the Sprott School of Business and Faculty of Engineering and Design at Carleton University in Ottawa, Canada.

We believe that sound business models are an essential, even fundamental, building block for new and established enterprises. For startups, a good business model can mean that the harder you work, the more money your enterprise will make, an obviously important consideration for new entrepreneurs. For existing businesses, even mega corporations, they need to continually update and revisit their business models to ensure that they are changing and responding to evolving conditions in their marketplaces."
Visual FoxPro 9.0: Still Here, Still Relevant

An OpEd piece I did for

I tried to provide managers a reason to give respect where it's due, and VFP die hards a reality check.

I was late getting it in, so I didn't get a chance to see the final before it went up, so there are a few errata.

If they don't get fixed, I'll post a follow-up here.


Tuesday, November 16, 2004


So the last month or so has looked like completing the contract testing gig with the Visual FoxPro team at Microsoft, restarting Alden Anderson (note to self: get a designer), speaking at DevCon, writing these articles and working at DevConnections and trying to restart this cranky Seattle Visual FoxPro Special Interest Group... which really, really needs a better name. ;)

Sorry I've been light on the posts, emails and phone-calls.

Thursday, October 28, 2004 - C# Class Generator, ASP.NET Tools:

This is tool will automagically generate a complete c# class for you using 'raw' field inputs ( i.e input 'UserName', not 'strUserName' as my tool will prefix the type shortcut for you).

Friday, October 22, 2004

Pop!Tech - The Impact of Technology on People

"Pop!Tech is a one-of-a-kind intellectual and creative conference that explores the social impact of technology and the shape of things to come."

Wednesday, October 20, 2004

William Gibson blogs!

Of course he does... the father of "Cyberpunk" and all... but now it's marked!

Thanks GF!

Wednesday, October 13, 2004

NHibernate - a .NET based object persistence library for relational databases

NHibernate is a port of the excellent Java Hibernate relational persistence tool.

Hibernate is a powerful, ultra-high performance object/relational persistence and query service for Java. Hibernate lets you develop persistent classes following common Java idiom - including association, inheritance, polymorphism, composition and the Java collections framework. The Hibernate Query Language, designed as a "minimal" object-oriented extension to SQL, provides an elegant bridge between the object and relational worlds. Hibernate also allows you to express queries using native SQL or Java-based Criteria and Example queries.

Thursday, September 23, 2004

CoDe Magazine - What's New with Data in Visual FoxPro 9?

I little ditty I wrote late one night...

... well maybe it was more than one...

The Data Archiving Service (DAS) is a piece of software that monitors and analyzes the traffic on websites. Each participant helps by contributing their websites data which is pooled together and displayed on this page (avaliable under 'DAS Community Stats') to help shed a greater understanding of current web surfing idiotisms. In return participants get realtime stats for their site! All reports are generated in real-time.

Wednesday, September 22, 2004

Tuesday, September 14, 2004


We find ourselves in need of a new place to live -- and quick!

Looking for a 2+ bed 1+ bath, pets allowed (2 female bassets, indoor raised), fenced backyard in the Seattle area. Need to be moved in by September 27th (yup, less than 2 weeks!).

Prefer older home, hardwood floors. $1200

If you have a lead please email


Friday, July 30, 2004

Sorting Algorithms Demo:

"We all know that Quicksort is one of the fastest algorithms for sorting. It's not often, however, that we get a chance to see exactly how fast Quicksort really is. The following applets chart the progress of several common sorting algorithms while sorting an array of data using in-place algorithms. This means that the algorithms do not allocate additional storage to hold temporary results: they sort the data in place. (This is inspired by the algorithm animation work at Brown University and the video Sorting out Sorting By Ronald Baecker from the University of Toronto (circa 1970!).) "

Thanks Garrett Home Page - The SQL Server 2005 Community Web site
Sample Code: Using Dropdownlist in Editable DataGrid ASP.Net sample code.

This was the kind of example I used when I did VFP training. It exposes containership and related databinding issues.
IBM Rational: Rival Microsoft Faces Uphill Battle:

"At the recent Rational Software Development User Conference, IBM Fellow and IBM Rational Chief Scientist Grady Booch delivered a keynote on his predictions of the software development landscape circa 2032, the 50th anniversary of Rational. Following his keynote, Booch sat down with eWEEK Senior Writer Darryl K. Taft to discuss Rational's development strategy going forward and the new competition from Microsoft Corp., which will enter the application lifecycle development tools market next year with Visual Studio Team System. Booch, a co-creator of UML (Unified Modeling Language), also discussed why the language is so relevant to the tools space. "
The .NET Developer's Guide to Windows Security

"A group of about forty people from the community kindly donated their time to help me port the copyedited version of the book from Word documents into this Wiki. Each person who helped added a PortedBy attribute to acknowledge their work. Thank you very much for the help - we ported a 400 page book into Wiki form in under a week, friends!"

Monday, July 26, 2004

Teemings - Extras - The Horror of Blimps Very, very funny. Thanks Garrett.

Sadly, it appears that ZanyBrainy went out of business as part of the FAO Shwartz Reorg.

But there are some pretty cool toys here...
Visual Studio 2005: Visual Studio 2005 Product Line Overview The new express tools are pretty slick. This page outlines the difference between express and pro systems.

Wednesday, July 21, 2004

AVERATEC I love my tiBook, but this Tablet has the right price...
USB Floppy Disk Drive RAID Too cool...

Monday, July 19, 2004

What happened to Xen / X#?

say "C Omega"
PC Repair when all else fails...
(Thanks Woody)
The Jargon File Hacker speak.

Thursday, July 15, 2004

Monday, July 12, 2004

ODBC DSN Less Connection Strings for most every kind of ODBC driver out there.

Thursday, July 08, 2004

Wednesday, July 07, 2004

XP SP2 Windows Firewall various bits on dealnig with XPSP2 firewall issues.

Tuesday, July 06, 2004

TestFu 0.2 database testing tools (SQL Server)in .NET

Thursday, July 01, 2004 Interesting site... but I can't vouch for the validity of the apps.

Wednesday, June 30, 2004

Explorer Switches

as in :

%windir%\explorer.exe /e, "C:\Program Files\"

Wednesday, June 23, 2004

Monday, June 21, 2004

Media Wiki: Wikipedia and Disinfopedia are based on this Wiki engine.

Tuesday, June 08, 2004

Visual Studio 2005 Team System include a comprehensive set of proven process frameworks, best practices, prescriptive architecture guidance, and integrated life-cycle tools...

West Wind SOAP Manager Free SOAP manager replacement for the depreciating MS SOAP Toolkit.

Wednesday, June 02, 2004

Dabo is the easy to use, cross-platform, 3-tier, open source desktop database development framework.

Ed and Paul announce their work on Dabo, a runtime framework for creating 3-tier desktop apps that will run on all versions of Windows, Linux, and Macintosh OSX. Written in Python, and abstracting the wxPython GUI toolkit, it is written with ease of use, power, and flexibility in mind. We've worked to create a development environment where the commonly-needed things are easy to implement, and the rarely-needed things are still doable.

Monday, May 31, 2004

Welcome to Astronomy for Kids! When looking for the answer to "What is the name of our solar system".

see also why the words Luna and Sol are sometimes used ... ;)
Saskatchewan Learning | School Age | Evergreen Curriculum | Resources | Curriculum By Subject ... great resource for home schoolers.

Wednesday, May 26, 2004

Tuesday, May 25, 2004

Looking for the latest information on a .DLL that ships with a Microsoft Product?
DLL Help Database

Friday, May 21, 2004

Insert a column into an array:

dimension myarray[2,3]


LOCAL nRows,nCols
DIMENSION aArray[nRows*(nCols+1)]

FOR i=(nCols+1) TO nRows*(nCols+1) STEP (nCols+1)
DIMENSION aArray[nRows,nCols+1]

Thanks to Peter Cushing via

Tuesday, April 27, 2004 .::. Tutorials Bloghorn: A Blog Reader Built in XAML.
Architecture Journal (by yag)
Fabulous Adventures In Coding
The Code Project - Free Source Code and Tutorials I first heard about Marc Clifton on his work with MyXaml, a declarative UI language that shares a name and some principles with the XAML declarative language in Longhorn, but that works on .NET now. Until today, I had missed his earlier work on this subject: The Application Automation Layer: Introduction And Design, along with the rest of his 51 articles on (wow).

Monday, April 19, 2004

Thursday, April 01, 2004

Google Job Opportunities: Google Copernicus Center is hiring: "Google is interviewing candidates for engineering positions at our lunar hosting and research center, opening late in the spring of 2007. This unique opportunity is available only to highly-qualified individuals who are willing to relocate for an extended period of time, are in top physical condition and are capable of surviving with limited access to such modern conveniences as soy low-fat lattes, The Sopranos and a steady supply of oxygen." This site rocks, especially now that it's hard to send pretty much any kind of attachment via email.

Create a free account, enter email address and upload the file. The recipient gets an email with a link to the file on servers. File stays there for a few days before it is automatically deleted.

Note at the bottom of their webpage: Bookmark This Site Now - Win Prizes! (note: there are no prizes)

Wednesday, March 31, 2004

PDC Talks: Avalon more on Avalon
Download details: Special Holiday Episode - XAML Beyond the Basics XAML is the programming model for Avalon. "More than just UI..."
Migrating from Table Models to Domain Models via OCL

Doc Searls | Creative Commons

Speaker, blogger, writer, and former radio personality, Doc Searls is the Senior Editor of Linux Journal, co-founder of GeekPAC and the American Open Technology Consortium, and a leading blogger.

Widely recognized as an authority on technology and marketing, Doc is co-author of the #1 sales and marketing bestseller The Cluetrain Manifesto, which will be released under a Creative Commons Public Domain Dedication.
Ambient Design Ltd. ArtRage, painting program -- especially good on TabletPCs.

mamamusings: confessions of a backchannel queen more on the Microsoft Research Social Computing Symposium
Daypop search - social software symposium for example...
Welcome to lets you filter over one million weblogs and information streams to find the content you're looking for, in real time.
Jon Udell: Macromedia Flex and for a 'Fair and Balanced' reporting, this is Macromedia's next step in extending the reach of Flash.
PDC Talks: Avalon
"Microsoft XNA a catalyst for a new ecosystem of interchangeable, interoperable software tools and technologies from Microsoft, middleware, and game-development companies. "

Category:Game Development

IT Conversations Audio and transcripts of interviews and important events.

Thanks Jmm!

Saturday, March 27, 2004

Creative Commons is devoted to expanding the range of creative work available for others to build upon and share.

Design your own Copyright.
Debug Tutorial Part 2: The Stack
W3C SQL nice basic SQL tutorial.
iNET will run on Mac OS X
Shared Source Common Language Infrastructure 1.0 Release
.Net on OS/X -- C# may be cross-platform enough.

Wednesday, March 24, 2004

C# Frequently Asked Questions a valuable resource for coding C#.

[Microsoft WebBlogs]


Monday, March 22, 2004

WilsonDotNet Home of WORM (WilsonObjectRelationalMapper) for use in .NET 1.1 as ObjectSpaces.
Enterprise Integration Patterns
Catalog of Patterns of Enterprise Application Architecture More Fowler stuff, but this is a great jumping off point.
Enterprise Application Architecture, Analysis Patterns, XP and Agile Methods, ...

Saturday, March 20, 2004

Feedster :: RSS Search Engine a great way to search the blogsphere. If you don't get blogging, start here...
Well, I've updated the blog look and feel a bit. Now can now use many of the popular RSS readers to pull posts from this blog. I'm currently using NewsGator -- it integrates well with Outlook and IE.

Also added comments and talkbacks. Check out HaloScan

TMBG has a kids music CD. Just pulled it from iTunes. "Where too much security is not enough!"
Visible Developer another model based development tool for .NET
NT Specific Batch Programs Regular expressions with file manipulation commands is fun! - King County
Welcome to Do a lot of digital printing? Cut your consumables by 2/3. Look for the bulk feed Niagra systems. Royal sayz "check it out".
Data Access & Storage Home: Using MSDE 2000 in a Web Application (MSDE 2000 Web Resource Kit) 3,000 titles of music and video for children.
My next step toward accepting wholeness is to reclaim some part of me which I have disowned. I will discover what this part is by

thinking of the person whom I judge the most harshly, or of whom I am the most afraid.

I will ask myself, 'What is it about this person that I inwardly criticize?' As I recognize that this quality is also in me, I will ask God to show me how to love this part of myself.

I did the SPIRIT program here.

Friday, March 19, 2004

Buzznet - Photologs and MoBlogs
Is Microsoft sniffing around AOL? The New York Post claims the two have had several acquisition-related discussions over the course of several months. But AOL parent Time Warner says The Post is blowing smoke.

Microsoft Watch from Mary Jo Foley
A free Usenet newsreader for Windows 9x/NT/2000/XP Xnews

Thursday, March 18, 2004

KIMI::STUFF presents iKnow F1 - a F1 [racing] encyclopedia for your iPod, so you can check up on just those kind of things on the tube, bus, plane, in the car (so long as you're not driving), in the pub - wherever and whenever you want.

Microsoft apologized to jurors for its past anticompetitive practices during opening statements Wednesday in a case alleging that the company's antitrust violations included word processing and spreadsheet software.

eWEEK Technology News
Architecting End-to-End Enterprise Solutions: InfoPath with BizTalk 2004, SQL Server, "Indigo", WSE and Line-of-Business Applications made with Producer for PowerPoint 2002.

Wednesday, March 17, 2004

Monday, March 15, 2004

MS Architecture Strategy Series
"These presentations describe the architectural vision that drives the "Longhorn wave" of technologies from Microsoft, and introduce a set of key initiatives that will form the pillars of the Longhorn solution architecture. Perspectives range from the metaphorical to the pragmatic. At one end, Pat Helland relates the evolution of technology architectures to the evolution of city planning (and showing us how far we have yet to go!). At the other, John Dawson presents the proven data center patterns developed by the Microsoft Systems Architecture team. Explore these presentations to discover how Microsoft views the road ahead, and what tools and technologies Microsoft plans to deliver to help you blaze your own trail to a more felicitous, better integrated enterprise application portfolio"
Together Technologies: Simplify and Accelerate the Success of Your Applications A visual modeling tool from Borland - integrated with .NET.

Friday, March 12, 2004

merck records - Lee Carvallo's Putting Challenge

Tiki Obmar, Mr. Projectile, Machinedrum, Proem and the only place you can find Suki Takahashi.

Spatial, lovely, yummy.
DotNetRocks a weekly radio show by, trainers. Check out Kevin McNeish's show.
Ultr@VNC - Remote Control Software

Been a VNC fan for many years. This looks like the latest killer implementation. Many Win2k/XP performance enhancements and optimized for broadcast to many machines ala WebEx.

Maybe XP won't be so painful from OSX?

... and of course, it's Free and distributed under the terms of the GNU General Public License.

Saturday, February 21, 2004

Wednesday, February 11, 2004

Gnod - The global network of dreams This is pretty cool, try this link: Works with movies, music, books and websites.
PhotoReflect: Find a Professional Photographer Photos from pros... send photos as cards... show to Mark Clark.

Sunday, February 08, 2004 provides a free, easy to use commenting system for weblogs and websites, allowing visitors to leave instant feedback. By copying and pasting just two lines of code into your site, you will enable your visitors to easily leave their feedback, opinion or a "comment" on the subject at hand.

LearnVisualStudio.Net Free videos on .NET (including Widbey)
' Feb/2003 -
' This class encrypts and decrypts values. Basically
' it is a wrapper for some of the .NET cryptography
' classes.

' Code for this class was originally developed by
' Paolo Miserini [].
' Reference:
' To do list:
' Port to VFP, test with dataevents.
' We should probably create shared version of Deciper and Ciper methods.
' Usage sample:
' Dim Cipher As New Cipher()
' Me.txtOriginalValue.Text = Cipher.DeCipher(Me.txtEncrypted.Text, Me.txtKey.Text)
' Dim Cipher As New Cipher()
' Me.txtEncrypted.Text = Cipher.Cipher(Me.txtOriginalValue.Text, Me.txtKey.Text)

Imports System.Text
Imports System.Security.Cryptography

Public Class Cipher

Dim DefaultEncryptionKey As String
Dim des As New TripleDESCryptoServiceProvider()
Dim hashmd5 As New MD5CryptoServiceProvider()

Public Sub New()
' Default encryption/decryption key. You should
' provide your own when you instanciate the class or
' pass a key value to Cipher and Decipher methods.
DefaultEncryptionKey = "DefaulEncryptionKeyYouShouldProvideYourOwn"
End Sub

Public Function DeCipher(ByVal TextToDecipher As String) As String
Return DeCipher(TextToDecipher, DefaultEncryptionKey)
End Function

Public Function DeCipher(ByVal TextToDecipher As String, ByVal EncryptionKey As String) As String
Dim DeCipheredValue As String = Nothing
des.Key = hashmd5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(EncryptionKey))
des.Mode = CipherMode.ECB
Dim desdencrypt As ICryptoTransform = des.CreateDecryptor()
Dim buff() As Byte = Convert.FromBase64String(TextToDecipher)
DeCipheredValue = ASCIIEncoding.ASCII.GetString(desdencrypt.TransformFinalBlock(buff, 0, buff.Length))
Return DeCipheredValue
End Function

Public Function Cipher(ByVal TextToCipher As String) As String
Return Cipher(TextToCipher, DefaultEncryptionKey)
End Function

Public Function Cipher(ByVal TextToCipher As String, ByVal EncryptionKey As String) As String
Dim CipheredValue As String = Nothing
des.Key = hashmd5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(EncryptionKey))
des.Mode = CipherMode.ECB
Dim desdencrypt As ICryptoTransform = des.CreateEncryptor()
Dim MyASCIIEncoding = New ASCIIEncoding()
Dim buff() As Byte = ASCIIEncoding.ASCII.GetBytes(TextToCipher)
CipheredValue = Convert.ToBase64String(desdencrypt.TransformFinalBlock(buff, 0, buff.Length))
Return CipheredValue
End Function

End Class

"N-tier software is easier to maintain, but more expensive to build the first time. So if you want the job, you have to go with the simplest technology that does the job, and then hope that they'll like your work and pay you what it will cost to come back and do the job right. Few clients, and especially few clients in the FoxPro world, are willing to pay extra for features that only save money later. A product like this allows us to do it right the first time, a luxury we rarely had in the past. I'm comfortable with this market of smaller companies and tighter budgets, but I'd like to give them first-class software. A framework allows me to do so. "

" IdeaBlade, an amazing framework for .NET from a company called ObjectWare "...

- Les Pinter 9/03
William GC Steinford - My vote for MVP.

Saturday, February 07, 2004

The C# Design Process: A Conversation with Anders Hejlsberg

Wednesday, February 04, 2004

World-Wide Media eXchange: WWMX Media by world wide geography.

Sunday, February 01, 2004

Friday, January 30, 2004

Thursday, January 22, 2004

SIGMOD Record - web edition / December 2000 Exciting stuff!

At the bottom of the page, New TPC Benchmarks for Decision Support and Web Commerce.

I made a shot across the bow on using the TPCH benchmark as a suite for testing compliance with the new SQL enhancements. Seemed to fly, so it's been the bulk of my work the last few days. Currently parsing the answer sets so they can be imported into a cursor for comparison with results. This may sound trivial, but the results sets are non delimited data dumps with one record spanning 3-4 rows. I've found lots of opensource and academic uses of TPCH, but no one seems to make available the complied version of DB_GEN or a normalized set of answers. ARGH!

Monday, January 19, 2004

Okay, busy blogging day...

Here is another along the lines of and SourceForge. The Code Project - Free Source Code and Tutorials While I understand the need for a viable business model to emerge for Open Source to be the "One True Way", when I hit sites like this -- it boggles the mind to think of how much work is saved by utilizing OPC (other peoples code). You down with OPC?
The whispering wheel is an electrical motor turned inside out with a wheel mounted on it. This application is for a city bus in the Netherlands. The motor is the wheel, the only combustion engine is the generator that charges the batteries. Nice!
Eric Meijer's MSR page Check out MSR in general too...
simplegeek YA .NET dev Blog.
Thoughts From The Head Working on Xen (X#?), language developer extrodinaire...also the talking head for VBTV
Microsoft Watch - News and Analysis on Microsoft Plans, People, Strategy and Products all things big fish oriented.
Red vs Blue
An animated series made by dubbing over video game footage.

Funny and True!:
The Gematriculator! The Gematriculator is a service that uses the infallible methods of Gematria developed by Mr. Ivan Panin to determine how good or evil a web site or a text passage is.

My resume is about 58% evil. A track John Miller and I did for a .NET conference last year is 98% evil!


Friday, January 16, 2004


After a few days of research, I finally found a set of benchmarks that can be used for validation of SQL results. I worked on the TCP-C benchmarks back in 96, they are more performance oriented. The TPC-H benchmark is Decision Support oriented -- so it focuses more on capabilities and validation than performance.

The source in in ANSI-C. I tried to create a solution in VS2k3, but it wouldn't build. Then I tried nmake, the command line util. The makefile that comes with the source lists a few flags that "need to be changed for Windows NT" -- but I found no documentation on how to do this. I found one message on from someone that ran into the same issues -- no response since Sep 2003.

So, Calvin to the rescue. He created a non .NET console project. This resulted in something that would build - but had a few errors.

Most of the errors were solved by adding TPCH;WIN32;SQLSERVER to the Preprocessor Definitions found under project Configuration Properties/C/C++/Preprocessor.

A few additional errors solved by defining variables that weren't resolving... sorry I don't have better notes -- but it was only 1 or 2. I'll make the revised source avail.

Wednesday, January 07, 2004

Looks like it's a "What do you want to do today?" day...
David Byrne experiments in MS PowerPoint
Virtual Playa! - Black Rock City in MS Flight Simlulator! - Suweet!

Monday, January 05, 2004

Tips For Ward At Microsoft
First post, new blog. This time it will be different! ;)
Recent blogging finds:
Web Services for bloggers
Mostly MS PMs and Devs for ASP.NET