Just in case anyone thinks a week at TechEd in Barcelona is a jolly, you are sadly mistaken. FIVE days of rapid fire presentations is total DATA overload, which despite the doing apparently nothing is extremely tiring.
So Day 4…..
Session 1. PHP on windows, now don???t laugh. Monday saw the release of fastCGI for windows server 2003, this is a Microsoft bolt on to run supporting CGI apps almost 15 times faster. CGI is traditionally very slow on windows due to the over head involved in creating and destroying a NEW process. CGI creates a NEW process for EVERY request. In fastCGI the process is persisted and re-used offering almost a 15 folder performance improvement. Add to that you can use asp.net forms authentication in front of the zend PHP and obtain the login credentials i may just have to try standing up a copy of WordPress on windows, Cuz I can !!!
Session 2. IIS7 on Server core, Server core is the NEW low foot print install for windows server 2008, it is not actually a SKU, but an install option you buy standard edition licence and install CORE or Full, (I wonder if they will rebrand ARCADE edition like the XBOX 360) Core will present some interesting challenges for the ???right click??? boys, as there is NO GUI, it is CMD line (hooray) or remote admin. I have never fully understood why a server needs a GUI, but my first server was novell 2, Shame that server CORE does not support managed code, so you can’t install a .net frame work, which sort of cripples a windows web server
Session 3. SQL Server indexing by Kimberly Tripp, OH MY GOD,??a serious session on SQL indexing and tools and scripts., using DMVs on SQL 2005, she demonstrated scripts she had created that woudl recomend index creates and index drops. the most enlightening statement she made (which made so much sense , but i had never though of it before) dont just look at the long runing queries, but run a trace over the a fully daily workload and look for common queries,??shaving 50% of a query which is run 5000 times day provides better overall performance gain than looking at the long runing query which only runs a few times a day.