# Friday, November 14, 2003

The Source

 

Whenever I am on the Microsoft Campus, it is a strange feeling. Kind of like Neo returning to The Source in The Matrix Reloaded.

 

Yesterday I was on campus and had a good experience planning things for 2004. Stay tuned!

posted on Friday, November 14, 2003 6:00:30 PM (Eastern Standard Time, UTC-05:00)  #    Comments [1] Trackback
# Wednesday, November 12, 2003

PASS Session

If you attended my PASS session in Seattle today called Efficient and Secure Data Retrieval in Your Middle Tier Using Stored Procedures and ADO. NET, you can download the materials here.

Off to dinner with Bill!

posted on Wednesday, November 12, 2003 8:13:40 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Tuesday, November 11, 2003
SubQueries Rock in a Where Clause

I have been using subqueries in Where clauses since I learned TSQL. This SQL below gives me all of the data in one table that is not in another table. Clemons, try doing that with XML! <g>

select location_id  from rpt_rcep11 where location_ID not in (select location_ID from dbo.tblExtrnl_Location_Mapping group by location_ID) group by location_id

posted on Tuesday, November 11, 2003 9:33:48 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Monday, November 10, 2003

Gentlemen, Start your Word Processors

 

I am one of three authors of the Microsoft Press book on Developing/Programming for SQL Server “Yukon” due out when the product ships. Last night I met with fellow authors Andrew Brust and Bill Zack at Andrew’s house and discussed the final outline, chapter assignment and writing schedule. Bill has written an article on the new SQL Server Service Broker for SQL Server magazine, so look for that in the March issue and I have written and article for MSDN magazine for the February issue on the new TSQL improvements, IDE and CLR Stored Procedures. These of course are excepts from chapters, so the writing process has officially begun.

 

This is going to be a great book since we will target .NET developers more than the DBA, while covering all the administrative features and tools. Since performance is as much of a developer concern as DBA concern, expect lots on performance tuning and optimization. I can’t post the outline and sample chapters here just yet (stay tuned, one day I can), but I can tell you we cover everything from soup to nuts. I was assigned (actually asked) for the chapter on XQuery, XML and the XML Datatype. Clemens must find that so funny!

posted on Monday, November 10, 2003 4:10:13 PM (Eastern Standard Time, UTC-05:00)  #    Comments [2] Trackback
# Friday, November 7, 2003

Movin' On Up

Like George and Wese. Today is moving day.

Not sure how much Linda will miss me, but Andrew must be happy to get his room back.

posted on Friday, November 7, 2003 5:13:35 PM (Eastern Standard Time, UTC-05:00)  #    Comments [1] Trackback
# Thursday, November 6, 2003

Do you like what I’ve done with the place?

 

Saw Matrix Revolutions last night and it was good and bad. If you saw the first two you need to see it. Lots of eye candy in the fight scenes, but the movie ran out of gas in the end.

posted on Thursday, November 6, 2003 2:08:33 PM (Eastern Standard Time, UTC-05:00)  #    Comments [12] Trackback
# Wednesday, November 5, 2003

Linux on the Desktop

 

Not anytime soon. This actually bums me out, I would like to see what the competition would do to Microsoft. From ZDNet:

 

“Linux is seen by Microsoft as its most dangerous competitor for desktop operating systems, and after a number of high-profile cases where government departments have switched from Windows to Linux-based systems, the OS has been making some progress. However, Red Hat said that the hype around desktop Linux is still mostly unfounded at the moment.

 

Matthew Szulik, chief executive of Linux vendor Red Hat, said on Monday that although Linux is capable of exceeding expectations for corporate users, home users should stick with Windows: "I would say that for the consumer market place, Windows probably continues to be the right product line," he said. "I would argue that from the device-driver standpoint and perhaps some of the other traditional functionality, for that classic consumer purchaser, it is my view that (Linux) technology needs to mature a little bit more."

posted on Wednesday, November 5, 2003 2:06:14 PM (Eastern Standard Time, UTC-05:00)  #    Comments [11] Trackback
# Tuesday, November 4, 2003

An Evil Company Forcing Expensive Upgrades

 

Today an evil company told its customers that it will force an upgrade on its users. The company will discontinue maintenance and errata support for versions 7.1, 7.2, 7.3 and 8.0 as of December 31, 2003," and that the company will "discontinue maintenance and errata support for version 9 as of April 30, 2004," and that the company "does not plan to release another product in the line." You will have to upgrade to a very expensive Enterprise version.

 

So you say the boys in Redmond are at it again. Think again, these are Germans. Got this in the mail today. I have a lot to say on this, but will let it sink in, because I predicted this years ago and the Linux crowd created a FUD site dedicated to me. Payback is a bitch.

 

The email:

 

 

Thank you for being a Red Hat Network customer.

 

This e-mail provides you with important information about the upcoming

discontinuation of Red Hat Linux, and resources to assist you with your

migration to another Red Hat solution.

 

As previously communicated, Red Hat will discontinue maintenance and

errata support for Red Hat Linux 7.1, 7.2, 7.3 and 8.0 as of December

31, 2003. Red Hat will discontinue maintenance and errata support for

Red

 

Hat Linux 9 as of April 30, 2004. Red Hat does not plan to release

another product in the Red Hat Linux line.

 

With the recent announcement of Red Hat Enterprise Linux v.3, you'll

find migrating to Enterprise Linux appealing. We understand

that transitioning to another Red Hat solution requires careful planning

and implementation. We have created a migration plan for Red Hat Network

customers to help make the transition as simple and seamless as

possible. Details:

 

****************

If you purchase Red Hat Enterprise Linux WS or ES Basic before February

28, 2004, you will receive 50% off the price for two years.[*] (That's two

years for the price of one.)

 

****************

In addition, we have created a Red Hat Linux Migration Resource Center

to address your migration planning and other questions, such as:

 

* What are best practices for implementing the migration to Red Hat

    Enterprise Linux?

 

* Are there other migration alternatives?

 

* How do I purchase Red Hat Enterprise Linux WS or ES Basic at the price

    above?

 

* What if my paid subscription to RHN extends past April 30, 2004?

 

****************

 

Find out more about your migration options with product comparisons,

whitepapers and documentation at the Red Hat Linux Migration Resource

Center:

 

    http://www.redhat.com/solutions/migration/rhl/rhn

 

Or read the FAQ written especially for Red Hat Network customers:

 

    https://rhn.redhat.com/help/rhlmigrationfaq/

 

Sincerely,

 

Red Hat, Inc.

 

[*] Limit 10 units. Higher volume purchase inquiries should contact a

        regional Red Hat sales representative. Contact numbers available at

        http://www.redhat.com/solutions/migration/rhl/rhn

 

--the Red Hat Network Team

posted on Tuesday, November 4, 2003 1:37:20 PM (Eastern Standard Time, UTC-05:00)  #    Comments [13] Trackback