Sometimes technical, sometimes not, never a kitty

Following up yesterday's post (http://rjdudley.com/blog/WindowsXPNotDeadYet.aspx):

Microsoft says Windows XP sales will end June 30 despite comments by Microsoft CEO Steve Ballmer. Microsoft says it's listening, but petition author Galen Gruman says Microsoft counts a Windows Vista sale even with an option to downgrade to Windows XP. Galen's petition has more than 170,000 names asking Microsoft to save Windows XP.

Full story at http://www.newsfactor.com/story.xhtml?story_id=121009GB4QVS&nl=2

The recent outcry from fans of Windows XP -- or at least from people who hate Vista so badly they don't want to buy it -- appears to have reached the ears of Steve Ballmer. The Microsoft CEO said the company would listen to its customers if they want to continue to buy XP.

full story at http://www.technewsworld.com/edpick/62741.html

There's a new user group in town:

IS Network: PGH DW Group
Please attend this year’s first Pittsburgh Data Warehouse and Business Intelligence User Group Meeting. The morning will begin with a brief planning session on the goals and purpose of the group followed by a demonstration in building a data warehouse right before your eyes using Microsoft SQL Server 2005. The final presentation titled, "A Single Source of Truth: Implementing Enterprise Profitability" will cover the design and implementation of the enterprise profitability system utilized by Alcoa.

Coffee and light refreshments sponsored by IQ Inc.

Date:        Thursday, April 24
Time:        8 a.m. - 12 p.m.
Venue: Pittsburgh Technology Council
Cost:         Free
Register: Online | E-mail | 412.918.4229

The full error reads:

Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

This error means you're using the SQL Server Reporting Services ReportViewer control in your web application, and the server can't find the proper DLL.  All you have to do is deploy them to your server.  With Visual Studio 2008, the location of the ReportViewer DLLs has changed.  You now find them at C:\Program Files\Microsoft Visual Studio 9.0\ReportViewer.

The first way to get these on your server, and this only works if you run your own server, is to directly copy them into the C:\Windows\assembly folder, and reboot the server (this reloads the GAC).  If a reboot is out of the question, you can use GACUTIL.EXE to copy and register the DLLs.

If you're in a shared hosting environment, reference the DLLs from the VS 9 path listed above, and set the Copy Local=True (select the DLL and open the Properties tab).  This will copy the DLLs into your applications BIN folder, and look for them there first.  You can then deploy to a shared host, making sure to copy all the contents of BIN.

All attendees to a "Heroes Happen Here" Launch even receive a software pack, but it's not without its limitations.  Here is what's included, and restrictions:

1. Windows 2008 Server, Enterprise Edition, both 32-bit and 64-bit.  Full version with keys, 1 year time bomb.
2. SQL Server 2008.  This is a CTP, not the final release.  I'd avoid installing this on any machine you like--use a virtual machine or something you can throw away later.  There is a registration code in the pocket with the EULAs for a license of the final version.  No mention of a time bomb.  I just tried to register, and the site craps out when you submit your form.
3. Visual Studio 2008 Standard Edition.  This is the version one step above Express.  It's most notable feature limitation is the Office development.  That's right--all that cool MOSS/Office 2007 integration and workflow they demonstrated, well, you can't do that with this version (you need the Professional version at least).  A version comparison is at http://msdn2.microsoft.com/en-us/vs2008/products/cc149003.aspx.  No indication of a time bomb.
4. Windows Vista Ultimate with SP1.  This was a nice surprise.  The full kitty, no expiration (the Windows Live One Care has a time limit, though).
5. Microsoft Forefront and Microsoft System Center.  Two infrastructure tools marked as "Limited-Time Trial Software", but no indication of the time limit.  Forefront is Microsoft's network security suite, rolling up Antigen and other tools into one product.
6. Windows Mobile 6 Developer Resource Kit.

Useful links from Launch:

If you want to review the presentations (or in our case, see them working), check out the Virtual Launch at http://www.microsoft.com/virtualevents/.  You need a Windows Live ID and Silverlight.  Apparently you can choose from several cities, but each time I selected something other than LA, I got a Silverlight error.

Download lab manuals for each demo at http://heroes.labmanuals.virtualwide.com/.  This is totally cool.  Get these and actually do what you saw (or would have seen if the demos didn't keep crashing).  Subject to the limited features of the Standard version, unless you have a better version handy.

In addition to VS2008 Professional, Sql Server 2008 Developer and Windows Server 2008, there's also Vista Ultimate in the software pack.  If you haven't signed up yet, you need to.

Nice lunchbox swag, full of treats. Here's Shaun Eutsey with his.

We're off to the VS 2008 Launch here in Pittsburgh at the convention center.  Just at add to the fun, Hillary Clinton and Barack Obama are speaking at a union rally also at the convention center.

My buddy Shaun has an immediate need for four midlevel .NET developers in Pittsburgh.  You can contact him at shaun [dot] eutsey [at] consultusa [dot] com if you're interested in hearing more.

<edit: email fixed />

I receive a lot of feedback from my ASP Alliance articles, usually comments.  I don't typically answer via e-mail, since that doesn't help the community.  Today I received the following message, and felt it was blog worthy.

Referring URL: http://aspalliance.com/532
Dear Rechard,

I have always been using Datasets and they have given me consistent Results. In fact, I DO NOT USE Report Viewer but export CR Report to a PDF File and then give it to the user as a URL.

BUT, WHEN DATA IS VERY LARGE, THE DATASETS GIVE PROBLEMS such as out of Memory, server not available, Timeouts, hanging etc. I have asked this question to many forums as to how to handle large data sets in ASP.Net with CR.Net. But, nobody has given me any satisfying answer.

I really want to know as to how to solve this problem.

Will You please Help Me.

With Warm Regards,

DN

Here's the problem--the amount of memory which can be utilized by an ASP.NET web app is 2GB (3GB if you use the /3GB switch).  If your dataset exceeds 2GB on a Windows 2003 Server, you will get a Server Not Available error.  Less than but close to 2GB will cause a significant decrease in performance or warnings about memory.

The answer is simple--you need a smaller dataset!  A 2GB dataset is far too large, especially when you're feeding it into Crystal Reports.  It sounds like you are dumping every bit of raw data into the report, and having the report process and present the data.  You really need to have your database queries doing more of the filtering and processing, then return a significantly smaller dataset.  In a web environment, it's best if you only do presentation in your reports--leave the calculations and filtering to the database.

Want to get your hands on SLQ Server 2008, but don't have any hardware?  Check out www.sqlserverbeta.com.  You get RDP access to a SQL Server 2008 server, with your own account space so you can test your scenarios in a quasi-real world environment.  From their site:

So set your sights on the horizon and take advantage of this chance to play with real-world technology before it hits the mainstream - test it with your real-world data, with your own custom scenarios, while it's still under development. This is your chance to influence the product that you use every day - in a secure, hosted working environment.

Important Note: This Beta offer should not be used for production systems, but can be used to fully test and experience Microsoft¹s newest, most intelligent data platform in a hosted environment free of charge.

Create your own brave new world - experiment, test, explore and push SQL Server 2008 to its limits - then report back to your fellow explorers on your experience in the Community discussion forums and blogs. Compare your findings with your peers and colleagues - and share your opinions and assessments.

SQL Server Beta is a joint effort between PASS, MaximumASP and Dell.  Hat tip: SQL Server Magazine.

Happy news in the inbox--Visual Studio 2008 from Installfest has shipped!  w00t!