Random Thoughts of Jorriss

In my opinion, NewsGator is the best RSS aggregator. It's integration with Outlook makes reading feeds ultra-convenient. If you haven’t tried NewsGator now’s the time because version 2.5 has been released. I’ve been using the beta and the integration with the NewsGator Web Edition is fantastic. Works as advertised. You might also want to try their podcasting application FeedStation. It’s not better than Doppler, yet. But I have a feeling it’s going to get there.

 Major Nelson has posted a comparison of the PS3 development kit and the Altair. I just about fell outta my chair when I saw this.

ESPN.com is now trying to cash in on the sneaker fetish craze.  They have a new show on ESPN2 titled “It’s the Shoes” where they visit the sneaker collections of celebrities. Sounds, um, weird. And that’s coming from a guy with a subscription to Sole Collector magazine. Get your TiVo’s ready because it airs on Tuesday nights (Wednesday mornings) at 1:30 A.M. ESPN.com also has an “Ultimate Sneaker” tournament where you can vote for you favorite pair of kicks. My vote? Air Jordan V’s. But since the V’s aren’t in the tournament I’d have to go with the Jordan XI’s with the Jordan XIV second. I would love to know why they posted a pic of the Jordan XI Lows instead on the Jordan XI. This is a travesty and must be corrected.

Like I keep saying it’s only a matter of time. The Miami Herald ran this story on the front page this morning, “Miami’s housing ‘bubble’ biggest in nation”. The housing market is downright crazy in Miami. The home we bought four years ago has increased 70% without us doing a dang thing. Everybody in this town is some sort of real estate expert. It feels a lot like the internet bubble of the late 90’s when “everyone” was a web programmer. I blame a lot of this craziness to the ease of obtaining a loan, especially no interest loans. Mortgage companies have been careless in their loan approvals and some will lose more than their shirts. The market will correct itself. My only question is how much will the correction be and when will it occur. I’ll be bracing for a tough housing market here in the MIA with tons of supply and minimal demand.

Update 6/23/05 9:01 AM - While in Barnes & Noble last night I noticed that the computer section was shrinking. Guess what section replaced the two rows that used to house computer books? Real Estate. Isn't it ironic, don't ya think?

 As you probably can tell I’ve been working on integrating Reporting Services within our ASP.Net website. A part of this integration is creating an ASP.Net custom control that will easily render a report from a page. Calling the Reporting Server web service is a snap and encapsulating this in a control is not a problem since I’ve had some experience with server controls (and yes they can be a big pain in the rear). I added a couple of LinkButtons to the control allow the user to export the report. But low and behold the Click events on the buttons wouldn’t fire. Dazed, I checked up on event bubbling and the IPostBackEventHandler but no dice. Then, I ran across a post titled “No events are fired in child control” in the microsoft.public.dotnet.framework.aspnet.buildingcontrols (say that five times fast) newsgroup. In a reply to this post Jeffrey Tan of Microsoft posted this nugget:

“Acutally, in Composite Control, if you want to hook the child controls' event, you must implement the system.Web.UI.INamingContainer interface. It will provide you the unique names in the hierarchical tree of controls. If you do not implement this interface, asp.net model will not associate the event handler well.”

Nice. I added the one line of code and everything worked as advertised. Order is restored to the world

Harden MS Reporting Services Using Custom Extensions
Harden MS Reporting Services Using Custom Extensions, Part 2
SQL Server 2000 Reporting Services Deployment Guide
Hitchhiker’s Guide to SQL Server 2000 Reporting Services
Tutorial: Adding Conditional Formatting into Reporting Services
Chris Hays's Reporting Services Sleazy Hacks Weblog
Report-enable Your Web Apps with Microsoft Reporting Services
SQL Reporting Services Tree Navigation Sample using a Web Service API
Using Forms Authentication in Reporting Services
Brian Welcker's Blog, Group Program Manager for SQL Server Reporting Services
Teo Lachev's Blog, Reporting Services Consultant and Author
How to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file format on a Web page

I found a good article on the new version of Reporting Services.

According to Welcker, "Everything will be upgrade-in-place for Report Server. Reporting Services 2000 reports can be run on 2005 though there won't be support for any features that are new in 2005. Reports will be automatically upgraded if opened in the 2005 Report Designer." 

Just what I wanted to know.

• I caught Ron Howard's cabana talk on Community Server. There's a lot of cool new stuff that they've got planned. I got the feeling that they've got more features than devs/time. But it's good to know that they've got their pulse on the community and are listening. You hear that DotNetNuke community? Telligent is listening!
• I had lunch with a couple of people who spent their evenings going to clubs and parties till two or three in the morning. How in the heck can you go to all of the sessions and have enough energy to go clubbing? I wonder how much they REALLY got out of the conference. It sounds like they're not taking full advantage of this opportunity.

Speaker: Mark Rideout

• Deployment with Click-Once
• • You can run an application by clicking on a URL.
  • Update an application by updating a server.
  • Robust Downloader & Installer. File & HTTP server support. Start Menu & Add/Remove Programs integration
  • Only the previous two versions are kept in cache. I wonder if this can be changed.
  • Click-Once requires IE.
  • With the bootstrapper you can deploy the .Net framework and SQL Express. Admin privileges are required.
• He shows the My namespace. We've all heard it before. Wait. Now we really hear it. He's playing a sound (that's a resource) through the My namespace.
• Balloon tool tips (the tray kind) now supported!
• Click-once is going to be a WHOLE lot easier that the Updater Application Block.
• New Windows Forms Components
• New ToolBars and Menus (ToolStrip)
• • DataGridView
  • SplitContainer
  • WebBrower
  • MaskedEdit
  • TableLayout, FlowLayout
  • Background Worker. w00t!
  • Binding Source (manages bindings)
• Client Configuration now allows the reading/writing user settings.
• Sound API
• THE TAG PROPERTY IS BACK!
• MS Windows XP control and OS features
• Added key support for collections (tree view, list view, etc)
• I was waiting for this…partial classes. We all know what it is…
• Toolstrip container allows you to dock a toolbar.
• These new windows controls are impressive. I wonder what the third party control providers think about this. Probably not much. There is always something missing out of the box.
• He's doing the demo where he creates the Outlook UI in Windows Forms. Channel 9 showed this a few months back.
• Out of the seventy or so people here only four are women.
• The new DataGrid is the DataGridView. They've improved the styling and functionality. It's impressive. Will I stop using the Infragisics grid control, um, no.
• Plug time: www.windowsforms.net
• The base line support in the designer is a much needed feature. This allows you to see a red line when a control matches another controls character text during the move of a control.
• Geez. This TableLayout control is powerful. You can set up a data entry form in no time.

 Speaker: Andres Sanabria

• This guy just opened the IDE and didn't resize his font size. I hate this! How am I supposed to follow along when all I see is red, blue and black blurs?
• Composite Controls combines the functionality of one or more existing controls
• The associated designer ensures child controls are created at design time as well.
• Script OM: New Features
• • DefaultButton
  • Maintain scroll position on Postback
  • Focus, SetFocusOnError (for validation)
  • Web Resources
  • Out-of-band callbacks
• Script OM: Generate and render client-script
• • Valid XHTML <script> tags
  • Provides API to register inline script or reference a *.js file
• Controls con override to delegate focus to a child control if they want explicit control.
• Web Resources: Simple deployment model of client files.
• • Package scripts, images, style sheets, etc. as assembly resources.
  • Instead of installing into "aspnet_client" folder
• Script Callbacks
• • Page is interactive while the server process request
  • No browser flashing or loss of scroll position
  • Does not add to the navigation history
  • Modeled after post-back event handling
  • Implements a script callback function
  • Page framework handles partial page execution.
• Script Callbacks sound really cool. Is this their answer to AJAX?
• Asynchronous Task
• • Allows a container to register an asynchronous task to the page.
  • Container will be notified when task competed, time-out or ended.
  • Time out is defined at the page directive
  • Control developers can alter the rendering based on the async task result.
• Control State
• • The essential bits of information to allow controls to ensure expected behavior
  • Separated out of view state. Page developer can turn off view state without losing functionality. Control state cannot be turned off.
  • Controls must opt-in to participate in this mechanism. Should store only the essentials, so control state doesn’t become another view state. Properties stored in control state should not be saved in view state as well.
• He talks about how to integrates Web Parts in your controls. Check on this…
• The demos are useless. Not because they don't do anything but because I can't see the code.
• I've got to go. No I really it mean I've got to go! Too much bottled water lying around.

Disclaimer: These are my notes from my experience at TechEd 2005. I do not guarantee the validity or accuracy of these notes. They are my thoughts and what information I felt was important at the time.

• What is good UI? Not just visually appealing. It's consistent, accessible, standards compliant. It has modular/interchangeable styles. It's also time efficient.
• Master Pages
• • Factor redundancies into reusable templates
  • Inheritance concept baked-in architecturally
  • Has unlimited nesting
• The Content's page Content control ContentPlaceHolderID property and the Master's ContentPlaceHolderID ID property must match.
• You can dynamically switch the master page dynamically in the PreInit event.
• This guy is typing the server code in the markup page instead of in the code behind. I really don't like that. I think the code-behind model is great! It offers a logical division between the markup and the code.
• Working with a graphic designer
• • No need to deliver aspx, just html is fine
  • Avoid (slightly) incongruent page designs
  • Don't cross the visual line between the master an contend
• Themes and master pages overlap:
• • Change style sheet by changing Master Page.
  • Change layout by using CSS (Themes)
• Make an exception for your front page
• New Navigation controls: Menu, TreeView, SiteMapPath, SiteMapDataSource.
• If you need a free tab control (there are plenty of tab controls out there) you can change the Menu control into one. Use images & CSS
• Recommendation: Specify a CSS class for the control (i.e. Menu) and let CSS handle some of the UI.
• Navigation: Recommended Usage:
• • Not all designs are possible without templates or custom controls. Understand the intrinsic markup structure of each control. Understand Where you can specify CSSClass
• To enable themes you need to add a folder called app_themes/themename. You also need to add a skin file.
• Themes Recommended Usage:
• Do as much as you can inside the Style Sheet. When producing multiple themes, have your designer multiple CSS files but only one XHTML files. http://www.csszengarden.com. Modify layout without changing your Master Page
• When to use Skins:
• • Foreground images can't be controlled by CSS
  • Advanced controls and collections
• What does not belong in themes
• Global images
• Shared, Print or other Style sheets

• I'm noticing that a lot of the women here are in the DB and BI world. Interesting.
• Along those lines this conference is dominated by white males. How much so? Think along the lines of how the NBA is dominated by black males. I've only heard Spanish spoken once by a attendee.
• I've now seen Visual Studio 2005 Beta 2 crash three times during the conference. Crashy, Crashy.
• Microsoft has announced the Microsoft Certified Architect program. But this isn't a take four test and your certified program. This is a certification with a peer board review process. Microsoft is allowing architects to certified architects. That's different. I don't think I'll be attempting this any time soon. They won't be targeting enterprise architects, software architects, component architects and academic architects.
• I had a demo of Office Writer from Software Artisans. The Office Writer product integrates with Reporting Services to allow true Word and Excel documents from Reporting Services. Very nice. If you need true office documents in Reporting Services it looks like a great product.
• I also had a good conversation with Infragistics. In my opinion they've got the best UI tools in the business. I also talked to them about, er, I better not mention this quite yet.
• The Thinkpad X41 is one phenomenal machine. I got the opportunity to walk-through a Visual Studio lab that used the Tablet-PC SDK on the X41 and I'm impressed. The screen was bright and easy to use. The swivel mechanism was sturdy and worked well. The only issue that I had was that the pen was too light. Also, since the machine was locked to the table I couldn't pick it up and walk around with it. The X41 is an impressive machine and I really want one.
• The wireless on the main convention floor is unusable and that sucks. The load must be incredible.
• One thing we don't do a whole lot of in our web application is caching. I need to come up with a caching strategy for the system.
• I grilled Rob Howard of Telligent Systems, the Community Server folks, on their documentation. It was a really good conversation. They just hired a tech writer so their functional docs should be appearing soon. I also asked if they are planning to use web parts soon, answer: yes. They are also planning some other cool features such as e-mail searching. There's a cabana on Community Server tomorrow. You know I'll be there.
• I got an e-mail last week regarding my post on the INSERT INTO EXEC in nested stored procedures issue. My solution was to take the code in the nested stored procedure and place it in a dynamic SQL statement. This will work fine unless you don't want/can't change the nested SP. I asked SQL Server guru Kimberly Tripp about this and her suggestion was to move all of the logic into the root SP.

 Speaker: Kimberly Tripp

• SQL Server stared from a team of five (Sybase) to 400 (for 7.0) to over 1,000 (for 2005). Geez, do you think that they've put some money into this thing?
• Query Analyzer and SQL Enterprise Manager are now lumped in to SQL Management Studio
• Analysis Manager turns into BI Developer Studio
• Profiler can now be run outside of the admin role.
• You can manage SQL Sever 2000, SQL Server 2005 and SQL Express from the SQL Management Studio.
• Source Safe (anything that uses the Windows Source Control API) integration is included into SQL Management Studio. ABOUT FREAKIN TIME!
• SQL Management Studio looks a lot whole like Visual Studio.
• Using SQL CMD Lines in a SQL Script allows the ability connect to multiple servers.
• If you are writing function to be run on the database work with the DBA to expect the proper results.
• Good Scenarios for CLR Usage
• • Data validation & network traffic reduction.
  • Writing general purpose function: Data passes as arguments, little/no additional data access, Complex computation applied on a row by row basis to the data.
  • Scalar types & custom aggregations
  • Leveraging the power of the .Net frameworks
• Bad uses of the CLR
• • Heavy data access - SQL set based access will be faster
  • Complex types 8K limitation
• TSQL Enhancements
• • ROW_NUMBER
  • RANK
  • PIVOT/UNPIVOT
  • Common Table Expressions
  • CROSS APPLY and OUTER APPLY
  • TRY/CATCH
  • DDL Triggers (synchronous)
  • Event notifications (asynchronous)
  • Parameterized TOP
• She demoed using .Net assemblies that are calling the Amazon Web services running in SQL Server. She called the assembly function from TSQL. Very powerful.
• You can create XML Indexes in SQL Server.
• XML Data is now shown as a hyperlink in SQL Management Studio. Click on the link and it shows the XML on a separate tab.
• SQL Server 2005 can listen to HTTP traffic using kernel mode HTTP.SYS. It does NOT depend on IIS. This is off by default.
• • Clients can use SOAP to interact with SQL Server. This is great for platforms with no SQL middleware support.
  • Trade-off of flexibility for performance. SQL clients will perform better.
  • This can be created in TSQL.
• Troubleshooting Tools:
• • Debugger support for TSLQ & CLR
  • Dynamic Mgt Views
  • Flight Recorder
  • SQLClient/OLEDB tracing
  • XML Showplan
  • Complete cleanup of error messages
  • SQL Profiler (with Perfmon integration) - You can open a perfmon trace and a profiler trace together. Both logs must be correlated by time. Also, the servers should have their clocks synchronized.
• SQL Server Express has most of the features of SQL Server 2005!

Disclaimer: These are my notes from my experience at TechEd 2005. I do not guarantee the validity or accuracy of these notes. They are my thoughts and what information I felt was important at the time.

 Speaker: Rob Howard

• You can now change settings in Web.Config dynamically. This should allow devs to store configuration changes on-the-fly.
• Declarative Data Binding
• • Controls bounds at appropriate time
  • Wire-up done through properties
  • Page lifecycle knowledge not required.
• Site Map allows the defining of how the ASP.Net website pages are laid out.
• The SQLDataSource is a server control that allows the defining of a SQL Sever Data Source without any code.
• • The SQL DataSource control enables caching on the object.
• Parameters of a SQLDataSource control can be bound. These parameters can be from the Query String, web controls, etc...
• The DataGrid now has a DataSourceID property to allow the DataGrid to be wired-up without code.
• DataBinder.Eval(Container…)) syntax can now be written as Eval(…)
• It looks like they decided that ASP.Net 2.0 needed more declarative syntax to reduce the amount of code written.
• "Smart" Data-Bound contorls. New GridView and DetailsView control
• No code is needed to sort, update, insert and delete data. This is done through the DataSource control.
• Paging by default will grab all of the data and show only what was requested. You can override this.
• Amount of view state that is generate has been reduced by 40%.
• ObjectDataSource control uses an object to retrieve data.
• • Bind to custom business objects
  • Visual Studio data components
  • Parallels SQLDataSource in object model.
  • The select method can return any object, IEnumerable list, collection or array
  • There are Update, Insert and Delete methods
• The GridView control renders sets of records as HTML tables.
• • Built-in sorting, paging, selecting, updating, deleting support.
• DetailsView Control renders individual records. Pair with GridView for master-detail views.
• SQL Cache Invalidation - New cache dependency type. It links cached items to database entities. Check into this…

Disclaimer: These are my notes from my experience at TechEd 2005. I do not guarantee the validity or accuracy of these notes. They are my thoughts and what information I felt was important at the time.