Friday, August 19, 2005

Of Endpoints, CTPs, and Virtual PC

I’ve spent the better part of this week working with HTTP.sys endpoints in Yukon – well trying to. On my notebook nothing I tried would create the endpoint. On other machines the code would run great but not on my machine. I learned that XP SP2 still uses IIS 5.1 which listens directly and therefore can conflict with the kernel HTTP.sys when also listening on the same port. Nevertheless, switching ports did not solve the problem. I suspect that the problem is that I’ve uninstalled and reinstalled various CTP versions of Yukon one too many times. So running a clean new copy of Windows Server 2003 and the June CTP under Virtual PC is the only way I’m moving forward. And in this configuration, the HTTP endpoints run smoothly.

 

Sunday, August 14, 2005

Building 35 and the O/R dbms

I had the pleasure of speaking for the Pacific Northwest SQL Server User’s Group a few evening ago. It meets in Building 35 – the home of the SQL Server team, the temple of SQL, the database monster garage. Kalen, Fernando, and Randy were there. Several Microsofties including the authors of the SQL Server BOL were there. I had a blast.

My topic was my O/R dbms layer and afterward the group sparked some good questions and ideas. The conversation even moved into the differences between modlign a relational database vs. modeling an O/R dbms.

If you’ve eve wondered about how to store classes and objects in SQL Server including inheritance, polymorphism, and associations then download the files from the files page on http://www.sqlserverbible.com/. In my next book, SQL Server 2005 Bible, I’m planning to include the O/R dbms schema as a chapter.