Rob van der Meijden

This article describes a possible implementation scenario with Windows 2003 Authorization Manager (AzMan) in a webservice environment with a load balancer. To create the right context for this article be sure that you are familiar with the following writings: 

• Use Role-Based Security in Your Middle Tier .NET Apps with Authorization Manager 
• Role-Based Access Control for Multi-tier Applications Using Authorization Manager 
• http://www.dotnetperformance.com/downloads/AzMan.doc

Target for today: only visit maximum level sessions. Well I did 5 tracks and with a average off 431 … not bad. Here are the results. 

Session ‘An In-Depth Look at Windows Forms in VS 2005’ by Brian Noyes. A few windows forms 2.0 controls where showed. Much better support for databinding and the datagrid has been replaced by a better datagridview. I hope that this and other changes are good enough to be less dependent on 3-third party tools. You can download the great demo here and the must-have backgroundworker for .NET version 1.1 here.

Next session was ‘VS 2005 Team System  Enterprise-Class Source Control’ by Brian A. Randell and Ashwin Karuhatty. So one session on what the possibilities are and how TS source control is working. Most shocking where the NON-windows support (they actually demonstrated a check-in from Unix machine) and the support for VS 2003, vb6 & vc6 so that you can put all you’re sources into one store. Great demo about creating your own check-in rule . Promising stats about the performance of TS source control in an enterprise deployment.

The session ‘VSTO Programming and deployment’ by BJ Holtgrewe was ended in 45 min by throwing goodies to the audience. A 400 session, not, more like 200, but I don’t care, the only that matters is my daily average. Nice overview on deploying VSTO apps unfortunate to little demo’s.

After lunch I went to the forum for the more comfort chairs ‘Smart Client Offline Data Synchronization and Caching’ by Brian Noyes (again). Different scenarios for creating a offline smart client guided by great examples (download here). Also showed how to deal with the offline application block. Needs lot of config in code, but manages all on- offline issues.

Last session of this Tech-Ed ‘Choose  Your  Approach to Design and Develop Web Services Applications’ by Christian Weyer. Very good story about how you should design you’re webservices guided by great demo’s (watch his blog for the sources). Nutshell: Contract-first bases with a XSD schema, Versioning using the xs:choise, XSD schema validation. The WSCF tool was giving great support on the demo’s and you should consider using them instead of the VS build in generators.

Started this morning in easy mode with a few hand-on labs focused on Visual Studio 2005 TS. Al worked well and fine until Rene Schrieken joined me and we started to do something on our own. We wanted an application design with multiple deployment scenarios, for instance development and test … we got close but failed. Later this day I did also some labs on VSTO (programming forms in Visual Studio for the MS-Office system) … they all worked.

The session ‘Indigo Under the hood’ by Steve Swartz and Clemens Vasters was … interesting … very good concepts … 45 min I’m lost … gladly the smart guys said that normally you don’t have know and do this … I hope so.

‘Web Services Interoperability’ by Simon Guest and Gurpreet S. Pall started with a nice promising play but stopped after showing the top ten 10 tips for web service interoperability. After that ‘what can you do with WS-*’ was the main topic.

‘Optimizing Scalability  Performance and Availability with Systems Built on the  NET Framework’ by Ingo Rammer. Great session with tips and tricks from Ingo on finding performance issues in distributed systems. 1. Trace the Network Interactions (EtherReal, TcpTrace, Fiddler, ProxyTrace), 2. Trace you’re Sql (SQL Profiler), 3. Memory profiling (CLR Profiler 2.0 (free), Compuware DevPartner, Redgate ANTS, AutomatedQA AQTime) … and above all … never assume anything. When using MS-datasets be aware of two things: extreme memory consumption and possible query overkill when using updates in data adapters.

The latest session today ‘What s New in the Visual C# 2005 IDE’ by Juval Lowy. Nice to see the great new support in the 2005 IDE. Some highlights  

• Setting and Resource editor which take care off the app.config settings and resource file by generating helper classes for you. 
• Import/Export VS settings and team support for these settings 
• Back and forward navigation trough source !! 
• See all references to type or variable 
• Instant watch and build-in or customizable visualizers 
• Good support for refactoring (Changing the code structure without affecting what it does)

Tech-Ed party ….

Started the day with a fine 400 serie: 'Server 2005 Table and Index Partitioning'. Although the speaker was hard to hear it was a very interesting feature in SQL 2005. After creating a partition function and add a partition schema to you’re table definition you can use the (large) table as a single object in you’re queries. This table can be partitioned over max. 1000 disks.

Next session: 'Implementing  Indigo  Endpoints   Secure  Reliable  Transacted Messaging' with Steve Swartz and Ingo Rammer. Very nice demo on reliable messaging with images … you must try it.

Some Other Architecture or SOAP without the P or Stupid Overhyped Acronym or Save Our A..es or 'Same Old Architecture', the last option seems the fit best according to Gregor Hohpe.

After lunch I choose a session with comfortable chairs (auditorium or forum), 'Microsoft s Blogging Engine' by Betsy Aoki's ; a very fast session but interesting to hear how Microsoft created and implemented their community blogs with Community Server.

Net Friend demonstrated 'how to develop forms using managed code in InfoPath 2003'. Especially the demo where the content of an InfoPath form was generated into a MS-Word document using a XSLT was great.

The last session for today was about 'What’s New in Biztalk 2006 server runtime'. I did not understand the applause for the a drag and drop column splitter for the text files import or the buttons to select files … or am I just too spoilt or unfamiliar with the previous releases … probably … anyway … the demo’s of importing a very complex never seen before flat file within 15 min into xml and recoverable interchanges where very cool.

Top ten highlights from the TechEd 2005 pre-conf session SQL 2005 management tool by Kimbery Tripp (originally named Taming the tools … but this was a little bit to aggressive according to Microsoft).

1. DVD with excellent labs which covers all the topics for today and a VPC (5Gb) with installed versions of SQL 2000, 3 instances off SQL 2005, Visual Studio an Visual Sourcesafe.
2. SQL Profiler which collects xml query plans. You can examine the plans within the SQL server 2005 management studio later.
3. SQL Profiler with to ability to map Windows performance counters with the trace file off the profiler based on time (works also for SQL 2000) which gives very nice graphs tot analyze.
4. Solutions en projects can be created in SQL Server 2005 management studio, typically to create scripts for maintaining the database/server. These projects can be controlled by a source control provider  as long as it uses the Windows Source Control API. These projects are not the same type of projects which can be used in Visual Studio.
5. Sqlcmd replaces the osql en isql tools. Now Sqlcmd can use parameters which replaces text in the script (USE $(DB) -> USE Nothwind. The parameters can be set in the script, or passed in at the command line or linked with an environment variable. (try hitting F7)
6. All actions in SQL server 2005 management studio can be saved as a script, copied to clipboard or scheduled to be executed.
7. Faster file initialization, files are “zero initialized” except when there is a certain set off settings applied to the server.
8. Upgrading to SQL server 2005 can simply done by attach and de-attach. Be careful !! The upgrade uses the file you select and once updated there is no way back !! Be sure to have good backups.
9. SQL Server Surface Area Configuration tool (SQLSAC) can be used to configure services and protocols in a disconnected way. Every option is off by default, even the CLR integration checkbox. This must be an admin whish J
10. Dedicated Administrator connection (DAD). You can always connect with the server through this connection.

 You now already can use the SQL 2005 management tools for you're SQL 2000 database (sp3 and sp4).