# Friday, October 31, 2003

Everyday is Halloween

 

Today for Halloween I am going to dress up as a coder from the future. A future where Longhorn is on my desktop (with the eye candy Avalon graphics), I am coding with Whidbey (refactoring away) against a Yukon database (sorry Clemens). Now that I attended the PDC, I am counting down the days. I am going to start my count, today is day 1.

posted on Friday, October 31, 2003 6:35:55 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback
# Thursday, October 30, 2003

Great Panels @ PDC Today

The RDs are covering some panels at the PDC today, check out www.pdcbloggers.net for their reviews.

Title Speaker(s) RD
Making it Sizzle: Enabling and Building Next-Generation User Experiences on Windows “Longhorn” David Massy; Pablo Fernicola; Tjeerd Hoek; Chris Anderson; Michael Wallent Thomas Lee
Designing the CLR Brad Abrams; Anders Hejlsberg; Christopher Brumme; Patrick Dussud; James Miller; Jonathan Hawkins; Sean Trowbridge; George Bosworth Paul Sheriff
Choosing The Right Business Integration Technologies Donald Farmer; Scott Woodgate; Alex Weinert; Joe Sharp Andrés Fontán García , Mike Snell
Real World Innovation:  From Idea to Product Phil Fawcett; John Lefor; Lili Cheng; John Breese; Jeff Erwin; Katie Drucker; Renee Labran Joel Semeniuk
Connected at the Edge: Building Compelling Peer-to-Peer Applications Robert Hess; Amar Gandhi; Oliver Sharp; Kim Cameron; Shaun Pierce; Gursharan Sidhu  
Client Architecture: The Zen of Data-Driven Applications Michael  Pizzo; Alex Hopmann; Jeremy Mazner; Mike Deem; Quentin Clark; William Kennedy Edgar Sánchez, Terry Weiss
Mobile Application Development and Distribution:  Innovation and Opportunity Irwin Rodrigues; Chee Chew; David Jones; Bruce E. Johnson; Laura Rippy Jon Box, Chris Kinsman
Put The Power Inside: Hosting the CLR in Your Application Balaji Rathakrishnan; Mahesh Prakriya; Christopher Brumme; Christopher Brown; Dmitry Robsman; Ramachandran Venkatesh; Mark Alcazar Abdelmalek Kemmou
High Performance Computing on Windows: Taking Care of Business David Lifka; Kang Su Gatlin; George Spix; Andrew Lumsdaine; Max Giolitti  
“Indigo:” What’s Next for Connected Apps and Web Services Don  Box; Oliver Sharp; Omri Gazitt; Joe Long; John Shewchuk; Eric Zinda Ingo Rammer
Computing on the Beach: Visions of Mobility Donald Thompson; Tara Prakriya; Bert Keely; David Groom; Otto Berkes; Arif Maskatia Abdelmalek Kemmou
Rocking the Web with ASP.NET “Whidbey” Scott Guthrie; Rob Howard; Jon Box; Shanku Niyogi; Thomas Lewis; Nikhil Kothari; Dmitry Robsman Jon Box (panelist), Carlos R. Guevara
The Future of .NET Languages Paul Vick; Rob Relyea; Anders Hejlsberg; Brandon Bray; Erik Meijer; Daniel Thorpe; Raphael Simon; Basim Khadim  Jackie Goldstein
Architecture Panel:  What is Service-Oriented Analysis and Design Michael Burner; Brent Carlson; Mark Driver; Martin Fowler Scott Hanselman, Michele Leroux Bustamante
Security Panel: What’s Next? Directions in Security Jason Garms; James  Hamilton; Carl Ellison; Howard Schmidt Thomas Lee, Patrick Hynds

posted on Thursday, October 30, 2003 6:29:13 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback

Melody has a Fan

 

-----Original Message-----
From: Andy Catlin 
Sent: Wednesday, October 29, 2003 4:51 PM
To: Coach T (work); Adam Heiser; Linda Varoli; Fortissimo; Jack Prilook; Stephen Forte
Subject: Belle of the Ball

 

So I'm pushing my way through the flood-tide of male

ubergeeks at the Microsoft conference this morning, and

notice that the crowd is rubbernecking as it makes a wide

berth around this drop-dead beautiful blonde.  As I get

closer, I hear this most decidedly animated dialogue coming

from her side, and there, of course, is our man in LA,

Stephen.

 

"Andy, meet my editor, Melody."

 

Of course she is.

posted on Thursday, October 30, 2003 12:54:00 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Wednesday, October 29, 2003

Yukon XML Features

 

Don’t get me wrong, I like XML. Yukon has so many awesome XML features I can’t even absorb it all. I have been focusing on XQuery since beta 1, but there are many more things to work with.

 

For starters there is a native XML data type. You can also use Full Text Indexing on top of the XML datatype and use the full text query as a filter or a XQuery statement.

 

The coolest thing that I saw was the XML Schema validation of the XML Datatype, so if you try to insert data into the XML field and it violates the XSD, it will bomb.

 

Good stuff, stay tuned for more as we write the book….

posted on Wednesday, October 29, 2003 11:04:00 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback

Rows and Columns Revisited-on the Radio

Today on my Sys-Con Radio Interview at 11:15am PST, I'll revisit the Rows and Column issue as well as Clemens' Elements and Attributes argument-where at the bar last night he said in a lame attempt to win the argument that Oracle is more scalable than SQL Server. :)

I think that I will have to write das Blog and base it all on SQL Server Yukon storage and call it der Blog. Anyone want to help?

posted on Wednesday, October 29, 2003 7:08:49 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback

Refactoring C# Code in Whidbey

 

Want to refactor some code? How do we do it today, maybe use global find and replace? Ugly.

 

Whidbey has several great new tools to select a block of code, right click and select one of about 8 ways to refactor your code. My personal favorite is “Extract Method” where Whidbey takes selected code and makes it a new method (complete with parameters). Whidbey then writes a line of code where the code use to exist calling your new method.

 

Some other refactoring tools allow you to promote a variable to a parameter, switch the order, etc of parameters and also “surround with” which allows you to surround your code in an If statement, Try block, etc.

 

Happy Refactoring.

(From TLS321: Visual C# "Whidbey" IDE Enhancements)

posted on Wednesday, October 29, 2003 2:23:26 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback
# Tuesday, October 28, 2003

So Clemens is here at the PDC. And as usual we got drunk together and argued Relational Databases vs XML. Clemens, while such a smart dude, is still wrong on this issue. He thinks that everything should be in XML. My crazy Dutch friend, Remi and Kevin Collins and I all tried to talk sense into Clemens (apparently the Germans don’t like Dr. Codd.) At the end of the day you need to store data in a database, not XML, XML is good for transport of data (like in a web service) or is good for something like a config file.

 

The Relational Database is not dead. XML is not the cure for everything in the world. I think that the world is really defined in Rows and Columns, not Elements and Attributes.

posted on Tuesday, October 28, 2003 6:31:29 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback

Attention passengers, this is the captain speaking: the smoke you smell is not from our plane

 

The most amazing thing (and the most horrific) I have ever saw from an airplane window was the view of the Los Angles fires from about 12,000' on the descent into LAX. I have never seen anything like it. I have flown over very large forest fires (which are more black in color) in the past and was not prepared for what I saw today flying into LA. When descending into LAX you get a good view of the San Bernardino Valley. You usually see nice homes and cars and such. Today not so much. Nothing but fire and white smoke. You could SMELL the smoke from the plane. That is a first for me. It looks like a nuclear bomb hit LA. Maybe I was getting a little emotional from the white cloud of smoke over the world trade center after 9/11, but that is what it looked like.


Well, although late, the PDC is now underway. Tomorrow I plan on taking in some WinFS and Yukon DTS sessions. It took me about 14 hours, but I got here in time for a dinner with RDs from around the world.

posted on Tuesday, October 28, 2003 10:27:24 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback

Two Chix and a Skillet

 

This weekend my good friends, Ned and Laura Gardner made it to the top of Katterskill High Peak (along with 5 of their closest friends). This was their 35th peak and 39th climb to gain entry to the Catskill 3500 Club. I did the honors and opened the Champagne at 3600’ and we had celebrated in the ice and snow. I personally have 12 more climbs before I can gain entry into the club, so we did two more peaks on Sunday, only after we had “Breakfast Grub” at Two Chix and a Skillet.

posted on Tuesday, October 28, 2003 9:59:37 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [14] Trackback
# Friday, October 24, 2003

WinFS at PDC

The PDC will be all about Longhorn, Yukon and Whidbey (and maybe some Web Services crap too.) Since I am writing the Yukon book for MS Press and have been playing with it almost all year and Whidbey is now in alpha, Longhorn is what I want to see the most of. As a developer, WinFS seems the most important.

So the future of the file system in Windows is WinFS. The hints are that WinFS will "leverage database technolgies." What exactly does that mean? Hummmmmmm. SQL Server?

Here are the sessions to look at:

WinFS: File System and Storage Advances in Windows "Longhorn": Overview

Track: Client   Code: CLI201
Room: Room 150/151/152/153   Time Slot: Tue, October 28 2:00 PM-3:15 PM
Room: Room501ABC   Time Slot: Wed, October 29 2:00 PM-3:15 PM
Learn about the next generation storage platform for Windows! In "Longhorn" we're advancing the File System into a Storage Platform for storing structured, file and XML data. Leveraging database technologies, the "Longhorn" storage platform manages data for organizing, searching and sharing. The storage platform also allows for data synchronization across other "Longhorn" and foreign data sources. The new storage platform supports rich managed "Longhorn" APIs as well as Win32 APIs.

WinFS: File System Integration

Track: Client   Code: CLI326
Room: Room 152/153   Time Slot: Wed, October 29 11:30 AM-12:45 PM
Speakers: Sanjay Anand
This session provides an overview of the File System and Security features of WinFS, including but not limited to a drilldown into the WinFS namespace, file system integration and Win32 support. We also cover the WinFS security model including authentication, authorization and encryption features that help you secure your data as well as build security into your applications. Learn how you can integrate your file-based content into WinFS using WinFS property promotion infrastructure or build support for integrating with WinFS search capabilities.

WinFS: Schemas and Extensibility

Track: Client   Code: CLI322
Room: Room 409AB   Time Slot: Wed, October 29 10:00 AM-11:15 AM
Speakers: J. Patrick Thompson, Toby Whitney
The WinFS schemas are the data and API definition that ship with Windows. The Windows Schemas define documents, contacts, system and person tasks, and much more. Learn about the thinking behind the designs of the Windows Schemas and how you can extend the schemas that ship with Windows, create your own schemas, and extend WinFS.

WinFS: Schemas, Extensibility and the Storage User Experience

Track: Client   Code: CLI323
Room: Room 409AB   Time Slot: Wed, October 29 2:00 PM-3:15 PM
Speakers: Nat Ballou
Windows "Longhorn" introduces an entirely new user storage experience and model around the storage of user's data. Get an introduction to new concepts such as: dynamic sets, static sets, and views, with a quick overview of the "Longhorn" storage user experience. Focus on how you can present application-specific data in Windows as well as re-use "Longhorn" components to build rich "Longhorn" applications.

WinFS: Using Windows "Longhorn" Storage ("WinFS") in Your Application (Part 1)

Track: Client   Code: CLI320
Room: Room 409AB   Time Slot: Tue, October 28 3:45 PM-5:00 PM
Speakers: John Ludeman
The preferred method of access to the advanced features of the new Windows Future Storage (WinFS) is through the WinFS API. This session starts by covering the broad set of concepts that form the foundation of the WinFS API design, and then delve into specific code examples. You will be able to write a simple application against WinFS by the time this session is complete. The walk-through includes connecting to the store, basic enumeration and queries, saving changes back to the store and the associated transactional semantics. Folder and Filestream access are also discussed. Basic data change notification scenarios round out the core examples.

WinFS: Using Windows "Longhorn" Storage ("WinFS") in Your Application (Part 2)

Track: Client   Code: CLI321
Room: Room 409AB   Time Slot: Tue, October 28 5:15 PM-6:30 PM
Speakers: Mike Deem
In part 2 of the WinFS API session, we jump right into the deep end and cover the advanced features of the WinFS API, including rich view support, support for XML types, asynchrony, using the "Avalon" data binding support, using the interfaces from COM, how to build your own schemas and extensions on WinFS, the different relationship lifetimes and the associated semantics. A key component of the WinFS architecture will allow for ISVs to extend the same base schemas to maximize information sharing or even create their own schemas. How and where to extend WinFS is discussed, along with the schema and API creation process. Part 1 should be considered a prerequisite for taking this session.

posted on Friday, October 24, 2003 4:14:26 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback
# Thursday, October 23, 2003

Architecting Smart Client Applications (It's a PDC Thang)

 

Allen Cooper thinks that IT people are in love with Web apps since they are too lazy to deal with deployment issues, so we as IT people force less rich and robust UIs on people (via HTML) so they don’t have to deal with the deployment. This is changing with .NET and zero touch deployment and all the tools Microsoft has given us to deploy apps on the client. This only makes sense since the client nowadays also has about as much processing power as a small city had just about 5 years ago.

 

If you want to talk more on this topic, come see a super duper BOF session at the PDC on Tuesday. You can come to the Architecting Smart Client Applications session on Tuesday night. Several RD's will be hosting this event with uber RD Tim Huckaby including: myself; Joel Semeniuk; Ingo Rammer; Tim Landgrave; Joe Homnick; Greg Frankenfield; Edgar Sánchez; Scott Stanfield; Billy Hollis; Peter Himschoot; and Patrick Hynds.

 

We want to cover a number of themes:

           What the hell is a smart client?

           The Smart Client application development offerings from Microsoft

           Web vs. Windows

           .NET fixes the historical problems of deployment

           Web applications may be headed for extinction (at least on the windows platform)

 

Hope to see you there, here is the write up:

 

Architecting Smart Client Applications (the future of application development)

Track: Birds of a Feather   Code: BoF05

Room: Room 404AB   Time Slot: Tue, October 28 9:00 PM-9:55 PM

This BOF fosters discussion on what a smart client is and delves into the implications and opportunities for smart client application development now and into the future. The topics discussed focus on smart client technologies like InfoPath, VS .NET tools for Office 2003, Framework, and Managed Code Extensions for Office 2003, and Windows Forms, with industry experts who facilitate examples and solicit comments and discussion on the best techniques to getting started on smart client apps today. Browser-based application development will be contrasted to smart client application development and we take an amusing look at the history of software design, development, and deployment and make some bold speculations, discussions and arguments on the future. Host: Tim Huckaby.

 

posted on Thursday, October 23, 2003 2:50:25 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [9] Trackback
# Wednesday, October 22, 2003

What the Hell are they going to do with it?

 

From eWeek:

 

“Microsoft Corp. on Wednesday will announce that it is giving its Most Valued Professionals access to the more than 100 million aggregate lines of Windows source code, which includes all versions, service packs and betas of the Windows 2000, Windows XP and Windows Server 2003 products.”

 

Why? Unless I can add a feature or fix something and send it in, why bother? The “Shared Source” imitative at Microsoft is strange. Last time I checked, Microsoft is paying its developers to write the code for their products and not taking any code from you and me. We can look at it, and even suggest something, but not really participate in the development. Microsoft, don’t play on both sides of the fence. Set up a program where others can work on the code and submit it in to you. Universities would love this. Uber-geeks would love this. The hippy, long haired, tie-dye wearing developers will love it. Game set match.

 

Oh yea, they are thinking to open Office? I hope that my crappy code is no longer in there. J

 

 

posted on Wednesday, October 22, 2003 4:42:34 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [17] Trackback
# Tuesday, October 21, 2003

My problems with the PDC

 

The PDC is too early. What are we going to be talking about at the PDC are: Longhorn, Yukon and Whidbey. Longhorn is scheduled for 2006 and Yukon and Whidbey in my guess (no inside knowledge) are 2005.

 

So the PDC is a little too early, it should be next year. There are so many things going on in beta land, that how can Microsoft expect us all to keep up. But that being said, it is sold out this year, so what do I know. I’m still looking forward to learning about all of this new stuff, it will just be frustrating that I can’t implement into production for at least 18 months or longer.

 

See you all there!

posted on Tuesday, October 21, 2003 12:18:49 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, October 20, 2003

It's a PDC Thang

So I have been given the task to drive people to the panels on Thursday 10/30 at the PDC. So everyone go! Ok, I did my job, now Microsoft will like me again. :)

What if you are not going to the PDC you ask? You can still participate. First check out the web site www.pdcbloggers.net, it will cover the panels pretty deep. (Most of the RDs are working on being there and posting stuff in their blogs that will also feed the portal.) Everyone with a passport can participate.

Also, the panels, (show here http://pdcbloggers.net/Question_and_Answer.category) have a way for you to submit questions and of course see the responses later at the portal, as I said even if you are not going. You can submit your question here:

http://pdcbloggers.net/Question_and_Answer/SubmitQuestion.aspx

See you in LA or at www.pdcbloggers.net!

posted on Monday, October 20, 2003 6:09:44 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [15] Trackback
# Sunday, October 19, 2003

Bill Gates in the House

BillG will be here in New York City on Tuesday to launch Office 2003 to the world. I have beta tested and apha tested every version of Office since Office 95 and can say that this is a good one. Outlook 2003 is worth the upgrade alone (my complaints from the beta were fixed). Andrew Brust claims that Outlook 2003 makes him 20% more productive than before, I'd say that is pretty fair.

For developers, Office 97 was the one and only upgrade that you HAD to do, but this one is compelling with the XML support. XML is just about everywhere in Excel, Access and even Word.

Enjoy.

posted on Sunday, October 19, 2003 6:26:06 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Friday, October 17, 2003

The Curse Must End

 

I am not a New York Yankees fan, but I don’t root against them. But to be honest, when the NLCS and ALCS started, I was rooting for the Cubs and Red Sox to make it to the World Series. I wanted the curse to end.

 

Last night when the Red Sox took a 4 run lead I was cheering. I thought the Red Sox were going to the World Series so I shouted at the bar last night “The curse ends tonight.” As a Mets fan, I should have know better. The most spectacular comeback in all of sports history is the 1986 World Series. Bill Buckner aside, the curse was alive for the Red Sox on October 25th, 1986. That historic night in Flushing, Queens proved the Babe Ruth curse when the Red Sox were 1 out away from their first world championship since 1918. Last night the Red Sox were 6 outs away from the World Series and blew it. (I was there as a Mets fan in 1999, just 3 outs away, so I know how it feels.) So New York City is a bad place for Boston, first in Shea Stadium in 1986 and last night in Yankee Stadium.

 

Last night’s awesome come from behind victory for the Yankees was great for the team, their fans and my home, New York City. Unfortunately it was bad for the sport. The curse must end. Just not this year.

posted on Friday, October 17, 2003 12:36:31 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [3] Trackback
# Thursday, October 16, 2003

Email From Maegan This Morning

They are going for the summit next Tuesday (10/20) or Wednesday (10/22). Everyone asks me "I thought you can only summit Everest in May." It is still possible to do it after May in the fall. Here are the stats, odds are against my team, but I know that they can do it! Out of 1924 successful summits on Everest, only 279 (18%) has actually occurred in the fall. Out of those 279, only 17 happened after October 20. The majority of the fall summits happened 1953-1993. Those years had 608 summits out of which 232 (38%) were made in autumn! Strange. From 1994 to 2003 however, there has been an explosion of 1320 summits - but a mere 47 (3.6%) in the fall.

So if she is going to summit and ski down, she will just have to forget the odds and go for it. Good luck and remember to come back-please.

 

posted on Thursday, October 16, 2003 7:27:37 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [16] Trackback
# Wednesday, October 15, 2003

Thomas Jefferson v James Madison

This question of direct democracy versus representative government that Dad and I are talking about is not a new one. As I said the founding fathers of this country struggled with the very same question. The Federalist Papers contain James Madison's debate with Thomas Jefferson on this point.

Jefferson wished for a pure democracy whereby the citizens could assemble and administer the government in person. All people could then have a direct say in how they are governed and share in the power that is used to govern. He talked all about a new revolution every 10 years, yadda yadda yadda. No wonder he liked the French-they are still fighting the French Revolution and the Revolutionaries at the Bastille in July 1789 were quoting Thomas Jefferson (who was in Paris at the time as George Washington’s ambassador) as if he were their spiritual leader. So the French?  How many constitutions have they had since 1789? Last I counted it was 6, not to mention all that Napoleon crap. (Let’s also not forget the Reign of Terror.)  How many have the United States had? One quite successful one.

James Madison believed that we are all prone to faction--"citizens...united and activated by some common impulse of passion, or of interest, adverse to the rights of other citizens, or adverse to the permanent and aggregate interests of the community" (Federalist Papers #10). "No man is allowed to be a judge in his own cause," said Madison, "because his interest would certainly bias his judgment, and, not improbably, corrupt his integrity."

Duh. Madison argued that the remedy to the risk of faction (or"special interests") was a representative government where a small but carefully determined number of citizens are elected by the rest to act on their behalf and in the interest of the public good. He won, Jefferson lost. Basically Thomas Jefferson gained some ground in a 215 year old debate last week with the election of the Terminator.

Sorry Dad.

So everyone, just remember the United States is not a democracy, but a Representative Democracy. (And yes we are a republic too, but so are the commies in China.)

 

 

posted on Wednesday, October 15, 2003 7:27:54 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [16] Trackback

Total Recall

 

My Dad did not agree with my thoughts on the Recall Vote- see his email below.

 

I disagree 100% with Dad. For starters, there is a recall every 4 years. The founding fathers would not be proud, they deliberately created a representative democracy, not a true democracy. The Federalist Papers warn of mob-rule (I know Dad I still have your copy, I should give it back to you to re-read). Remember that the founding fathers did not trust the electorate (only white males at the time) the Senate was not even elected, but appointed! They did not trust the electorate, why should I. Plus I have 230 years of history to judge the electorate by.

 

I do not support referendum and initiative, just look at Switzerland trying to vote to enter in the UN, enough said.

 

Dad's message:

 

-----Original Message-----
From: Albert J Forte

Sent: Wednesday, October 15, 2003 9:14 AM
To: Stephen Forte
Subject:

 

you have spent too much time at high altitude. Our founding fathers would be

proud of caliiiiiifornia.

Only 4 recalls and one succesful in  40 years. Comparing this to 9/11 is

rediculous. when did you lose faith in the electorate. Jefferson would love

this. The voters want recall on the books. I also support referendum and

initiative. Get some sleep ; you are nuts.

 

A little direct democracy once in a while might shake up the flow of special

  interest money.

 

I dare you to print this reply on your blog

posted on Wednesday, October 15, 2003 3:14:05 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [7] Trackback
# Tuesday, October 14, 2003

The Case for Case

 

Ok I have gotten a lot of press because I love the Rozenshtein Method for creating cross tab queries. I have even traveled the world and spoke about it all summer at TechEds around the world.

 

I have gotten flack, especially from annoying Australians, about how “complex” the Rozenshtein Method is. So today I found myself writing a crosstab and used the Case Method.

 

It was an ad-hoc query that I have to run a few times over the next few weeks. It never has to run in another database like Access or Oracle. It was needed to be quick and dirty. I decided NOT to use the Boolean aggregates and use a Case statement. The basic structure of a case statement is as follows:

 

CASE  FieldName WHEN ValueYouAreChecking THEN TrueExpression ELSE FalseExpression END

 

Pretty easy no? Here is a sample:

 

SELECT tlkpWeekEnding.WeekEnding_DT as Weekending, DiceCat.DiceCat_NM as 'Job Category', Sum(tblData.TotalListings) AS 'Total Listings', SUM(CASE  Service_ID WHEN 1 THEN TotalListings ELSE 0 END) AS HotJobsTotal,

SUM(CASE  Service_ID WHEN 2 THEN TotalListings ELSE 0 END) AS MonsterTotal,

SUM(CASE Service_ID WHEN 3 THEN TotalListings ELSE 0 END) AS CareerBuilderTotal

FROM DiceCat INNER JOIN ((tlkpWeekEnding INNER JOIN (trelServiceURL INNER JOIN tblData ON trelServiceURL.URL_ID = tblData.URL_ID) ON tlkpWeekEnding.WeekEnding_ID = tblData.WeekEnding_ID) INNER JOIN DiceCatDetail ON trelServiceURL.JobCategory_ID = DiceCatDetail.CorzenJobCatID) ON DiceCat.DiceCat_ID = DiceCatDetail.DiceCat_ID

WHERE tlkpWeekEnding.WeekEnding_ID=75

GROUP BY tlkpWeekEnding.WeekEnding_DT, DiceCat.DiceCat_NM

Order by  DiceCat.DiceCat_NM

 

Here are the results, we move rows to columns:

View1

Weekending

Job Category

Total Listings

HotJobsTotal

MonsterTotal

CareerBuilderTotal

10/12/2003

Accounting/Auditing/Finance

37226

10021

9694

17511

10/12/2003

Banking/Mortgage

10657

2026

2886

5745

10/12/2003

Biotech/Pharmaceutical

7569

2290

2644

2635

10/12/2003

Engineering

20549

3513

5800

11236

10/12/2003

Healthcare

44080

4415

8028

31637

10/12/2003

Information Technology

34309

10637

8924

14748

10/12/2003

Insurance

8364

1900

2718

3746

10/12/2003

Legal

7962

1976

2498

3488

10/12/2003

Science

4636

0

1074

3562

10/12/2003

Telecommunications

3650

1005

1137

1508

 

 

So if this is so easy why oh why do I insist on using the Rozenshtein Method? Well, I don’t insist on using it all the time. I like it because it is super fast and make sense to me (I was into Math as a kid, sorry). I think that you should know both and use the one that you think is most effective for the job at hand.

 

Happy Crosstabbing!

posted on Tuesday, October 14, 2003 8:40:23 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, October 13, 2003

Firehose Security and Privacy

 

Everyone is going a little too far with security and privacy. Some idiot hacker sends out an email virus and lots of ignorant people click on it and then lots of people blame Microsoft. The bigger problem is that then Microsoft responds with more firehose security methods. (Ever try to send an email attachment in Outlook now?)

 

Regardless, now the anti-virus people are trying to make our lives yet even more painful. Now if you install Norton Anti-virus, by default its Firewall software makes any web site that uses the HTTP_REFERER blow up. Like it is such an invasion of my privacy to tell a site where I clicked on the link to get there from.

 

So we had to change the code on our site to:

 

AbsoluteUri = Request.Url.AbsoluteUri

 

instead of

 

Request.ServerVariables("HTTP_REFERER")

 

This clearly has to stop. The privacy police have gone too far. I am also worried about potential legislation in Congress (which I have personally lobbied against through ACT) on Privacy. Sharing my medical records and financial information is one thing, but quadruple opt-in is another. Give it a rest.

posted on Monday, October 13, 2003 2:04:24 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [6] Trackback
# Friday, October 10, 2003

Open Up Mt. Rainier

 

Rainier Mountaineering, Incorporated (RMI) has a monopoly for guiding people up Mt. Rainier. (Unless you do it yourself.) This contract was due to expire in 2001, but is currently on its second 1-year extension. The NPS has recently proposed a range of alternatives for guiding at Mt. Rainier which will greatly affect the choices that we have when looking for a Mt. Rainier climbing guide service (see page 36):

 

 http://www.nps.gov/mora/current/CSP.pdf

 

The Preferred Alternative, #3, I enthusiastically support.  This

alternative, among other things, splits the RMI concession into three

concessions.with three equal companies having the ability to run trips on

Emmons, Kautz, and Muir routes. 

 

So send a letter saying that you support Alternative #3...and send it to:

 

Superintendent

Mt. Rainier National Park

Commercial Services Plan Comments

Tahoma Woods, Star Route

Ashford, WA  98304

 

or, you can send it by e mail:

 

mora_commercial_services@nps.gov

 

 

 

posted on Friday, October 10, 2003 11:27:34 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [10] Trackback
# Thursday, October 09, 2003

Want a Dell for under $200? (Offer expires today)

Do you want a new Dell for testing or just as an MP3 player in your home? Go to this site and follow these directions. (I of course added a few things like RAM and mine came out to about $300):

http://configure.us.dell.com/dellstore/config.aspx?c=us&l=en&oc=3D46A11&cs=04&kc=9&X=4&Y=9

Under "Dell Dimension 4600 Series" section, change the selection to "Pentium® 4 Processor at 2.40GHz w/800MHz front side bus/ HT Technology [subtract $50]"
Under "Mail-In Rebate Offer" section, check the box for "$100 MAIL-IN REBATE"
Under "Memory" section, change the selection to "256MB Dual Channel DDR SDRAM at 400MHz (2x128M) [subtract $100]"
Under "Keyboard" section, change the selection to "Dell® Quietkey® Keyboard [subtract $20]"
Under "Bundled Software" section, change the selection to "SAVE $100!! Microsoft® Office Basic Edition 2003 [subtract $15]"
Under "Hard Drive" section, change the selection to "40GB Value Hard Drive [subtract $70]"
Under "CD or DVD Drive" section, change the selection to "48x CD-ROM Drive [subtract $200]"
Under "Monitor" section, change the selection to "No Monitor [subtract $160]"
Under "Video Card" section, change the selection to "64MB DDR NVIDIA GeForce4 MX™ Graphics Card with TV-Out and DVI [subtract $15]"
Under "Modem" section, change the selection to "No Modem Requested [subtract $30]"
Check each and every option to make sure you are getting everything that you need
Scroll Down and click on "Update Price"
Scroll Down and click on "Continue"
On next page, Scroll Down and again Click on "Continue"
On next page, Scroll Down and Click on "Add to Cart"
There is a $100 Rebate on this system
Dell Small Biz is offering Free Shipping on new system purchases
Your Final Price: $239 - $100 = $139.00 + Free Shipping
Note: Dell Small Business charges tax on ALL purchases!

posted on Thursday, October 09, 2003 3:59:46 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [8] Trackback
# Wednesday, October 08, 2003

The Biggest Threat to Our Democracy

 

While I am a big fan of Arnold Schwarzenegger’s movies (I have seen each and every one more than once), read his work-out book for travelers and am counting the days until Pumping Iron is released to DVD (33 days), I think that the California Recall of Governor Davis is a larger threat to our democracy than the 9/11 attacks and all of the controversial steps taken to ensure our safety (like keeping the prisoners in Cuba, etc).

 

For starters, I tend to be a centrist, but lean more to the right, so technically I should be happy. I am not. I am losing sleep over this. This threat to our way of life has nothing with Democrats, Republicans or the Terminator. It has to do with the “What have you done for me lately, “ short attention span, need results now, Internet culture that is evolving in this country.  Now people’s short attention span has turned to elections. This is bad.

 

Another problem is that people don’t like to take responsibility for their actions anymore. The voters have the option to recall an elected official, every 4 years! Governor Davis was elected barely 11 months ago and less than 4 months after he was elected the recall movement was started.

 

This clearly has to stop. The “what have you done for me lately” culture was seen during the recent war in Iraq. While not taking any sides on the war issue, about 6 days in the news media and popular culture were saying that it was taking “too long”. Six days to invade and take over another country? They can’t be serious. But alas the news media and popular culture were.

 

People have way to much of a sense of entitlement and this attitude will only come back to haunt us. What is next? Why not elect the president via TV ratings like predicted in the late 80s TV show Max Headroom?

posted on Wednesday, October 08, 2003 3:31:59 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [18] Trackback
# Tuesday, October 07, 2003

Why didn’t they do this the first time?

 

I love DataReaders. You know this; I am a DataReader snob. I feel like a superior coder when I use a DataReader. Maybe it is my hatred of the false hype behind WebServices and XML that make me shun the DataSet. Or just my rather strange way of living my life. Who knows. Like most things you love in life, nothing is perfect. I have been using .NET 1.1 for over a year now since my company was an early adopter of Visual Studio 2003 and have gotten use to the HasRows property. For example if you want to test for an empty DataReader after you open it you can use code like this. (This code is more useful when you are NOT looping, but opening a DataReader for a single record.)

 

             if (dr.HasRows())

             {

                 txt1.Text=dr["MyField"];

             }

             else

             {

                 txt1.Text="No Data!";

             }

 

But what I forgot is that for .NET 1.0 (Visual Studio 2002), there is no HasRows property. You have to call the Read method which will return False when there are no rows. Here is the code. (Once again if you are in a loop, you would use a while Read=True and be done with it.)

 

             if (dr.Read()==true)

             {

                 txt1.Text=dr["MyField"];

             }

             else

             {

                 txt1.Text="No Data!";

             }

 

 

So this works, but my ultimate question about HasRows is why didn’t they do this the first time?

 

posted on Tuesday, October 07, 2003 3:30:52 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [13] Trackback
# Monday, October 06, 2003

I hate LA, but love the PDC

Get yourself to the PDC this year (and hurry it is almost sold out). And add your blog to http://pdcbloggers.net/.

posted on Monday, October 06, 2003 2:36:14 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [14] Trackback

 

The Buddhists say that the Earth has a song and that to hear it, you have to go to the Himalayas, away from the noise and commotion of the busy world. They also say that once you hear it, you don’t want to stop hearing it. Well, I heard it and want nothing more to hear it again and again.

 

While I was on my trek, I learned a few lesions from the simple life of the Khumbu Valley and the power of nature on the mountain. Here they are with some commentary following:

 

  1. Live your dreams
  2. Just do it
  3. Keep it simple
  4. Be thankful of what you have/make the most of what you have
  5. Its not about you

 

  1. Live your dreams. The first lesson that I learned was to live your dreams the best you could. I have wanted to go to Mt. Everest since I was 7 years old. I have finally did and when I got there a little voice in my head said “What were you waiting for?” Life is too short, live your dreams. No excuses, make it happen.
  2. Just do it. Damn those Nike people are smart. There were a few scary things on this trek. The first time I saw the Khumbu glacier, it looked very intimidating. A friend told me, “Just do it.” Just have no fears and inhibitions and face your fears and challenges head on. Once again, life is just way too short.
  3. Keep it Simple. When I was trekking in the Khumbu valley there were no cars, roads, phones, etc. I now fully appreciate the term “dirt poor.” The day of the week doesn’t matter much to these people. For the first time in my life I went days not knowing what day of the week it was or the day of the month. The folks in the valley are so poor, yet so happy. But you can see the look of joy on the kids faces living a hard but uncomplicated life. I noticed if you keep life as simple as possible, your life will be good.
  4. Be thankful of what you have. It is impossible to come to Khumbu and not pick up this concept, Once again the people are poor, yet they make do and are very happy. They make the most of what they have, don’t complain and live great lives. It may take 2 hours to cook the evening family meal, but it is a social event just preparing it and the family and friends bond while preparing and eating.
  5. Its not about you. This is the most important lesson you can learn from coming here. There is a whole universe out there, don’t spend too much time thinking about yourself and your needs. In the Khumbu there is an overwhelming sense of community (to the point that I still feel it here in New York). In the west we live in such a materialistic and selfish society, take it down a notch and see what you can give to the community at large.

 

posted on Monday, October 06, 2003 12:28:21 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [10] Trackback
# Sunday, October 05, 2003

Over the Boot Penetration

 

The hike on Saturday was awesome. We started at 4am with headlamps and it was cold but beautiful. I had to free climb over a 50’ rock face in the dark without any rope (there were tons footholds-photos will be up soon) and we got to the top of our first summit at about 5:30am in the pitch black. (Thanks to Walter who gave me extra headlamp batteries!) We summited the next peak at about 6:30am where we stayed and watched the sun rise.  This is where things went bad. It started to snow. And snow, and snow, and then rain. Then 30 mph winds. We summited the next peak at about 9am in the pouring rain and had no views and did not even stay on the summit it was so cold and windy. At 11ish we got to the spot where were suppose to meet Dorothy and we were 2 hours late and she left us a not that she had left. This should have been a sign. We summited the 4th peak at about noon, about a full hour behind schedule since it was so difficult to cross the terrain being so wet.

 

By 1:30 we had completed about 18 miles and 4 peaks and called it a day since it had now been raining/snowing for 7 straight hours and by now our gore-tex was failing Ned had stepped in mud so deep that the mud had reached “over the boot penetration”. Anyway, 18 miles, two summits in the dark, 4 peaks total and great conversation on the trail with friends made it an awesome day.

 

Since we finished early, I was able to attend a family gathering in the area for my Grandmother’s 85th Birthday. So it turns out that like everyone in my family reads my blog. (That fact alone is scary.) What is really funny is that they first say that “oh I just stumbled across it, I skimmed it, it is stupid anyway." But then they spent time telling me how I spelled this word wrong on this day and how this entry was stupid, etc. Hummm, I guess they were doing something more than skimming. :) It was great to see everyone.

posted on Sunday, October 05, 2003 2:28:20 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [20] Trackback
# Thursday, October 02, 2003

It is not often that I am right. I am right so infrequently that I have to draw attention to myself when I am right. This is going to be one of those times.

I have been predicting for years that Sun Microsystems is going to go under. (Not that I am bitter or anything about the Microsoft trial.) Yesterday Sun crossed the line from "troubled" to "doomed" and its share price dropped over 15% to prove it. Also Moody's has just about downgraded Sun into the junk-bond category.

This is not good news, I don’t like to see major companies go under, epically ones co-founded by a friend and mentor. I think that the reason why Sun is in such trouble is that they have absolutely no Linux strategy. Also contrary to popular belief, Linux is a threat more to Sun than to Microsoft. Linux is based off Unix and makes it obsolete. Sun sells Unix. Linux runs on low end machines. Sun’s Unix does not.

Sure Sun will truck on with layoffs, restructuring and loans, but it is basically done. The Sun has set. Next stop on the Linux train is Windows, watch out Bill…

 

posted on Thursday, October 02, 2003 5:08:28 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback
# Wednesday, October 01, 2003

"Only a Day Hike"

 

Saturday my friends and I are doing what Backpacker magazine rates as the hardest day hike in the United States: The Devils Path. The stats:

 

26 miles

7 peaks to summit along the way

18,000’ of elevation gain (up and down)

 

The seven peaks are:

Ste-Annes Peak

West Kill Mountain

Hunter Mountain

Plateau Mountain

Sugarloaf Mountain

Twin Mountain

Indian Head

 

This should be fun.

posted on Wednesday, October 01, 2003 5:10:52 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback