Geoff's profileGeoff Orr BlogPhotosBlogListsMore Tools Help

Blog


    October 11

    Server Consolidation - Peter Ward

    Consolidate SQL servers.  Less servers less footprint fundamentally reducing footprint.

    Analysis Services Metadata – knowledge is power - Darren Gosbell

    Darren shows us how to dive into Metadata for Analysis Services.  Must steal the scripts.

    Performance Data Collector - Brad Mc GeeHee

    Brad showed that given you can suck up the overhead this could be the montoring tool for you.

    I Can't Scope. Date dimensions in Analysis Services

    Ah.  Well the presenter was OK.  Me! 
     
    The session went well and has potential but I think I would cut the calculated members to another session and just have focused on the data dimension table, view and dimension structure.

    SQL Server Azure Service - Milind Kukday

    Milind really did well.  Presenting on a CTP version is always a challenge and Milind did well.
     
    Azure is a must have for guys who want to get out there and release a product on the net.
     
    He managed to catch my interest and show how Azure is going to be relevant.

    SSIS Debugging - John Walker

    Really good.  John knows his stuff.  This is my daily bread and butter so it was not a revelation for me but a good session none the less.

    Managing SQL Updates

    Adam presented on the challenges of implementing changes on databases.
     
    • Final solution is that it should be built into the application.
    • Development should be done using TFS data dude bought with the developer pack.
    • His own product SQLDeploy helps achieve this.
    • Have a single database implementer, owner or gatekeeper to maintain the database
    One thing you can say for Adam is that he talks from experience i.e. his company has been around for almost 20 years and developing and delivering systems.  I agreed with much of what was presented.  The point of these sessions is to discuss not agree.

    Practical SSIS - Kasim Wirama

    A good session.  Shows how important SSIS is these days.  I like his reference to cache tasks.  Always good to walk away wanting to use something new.
    October 10

    Grant Paisley

    Grant is still looking for an acceptable acrostic for his S.P.E.R.M. reports.  In fact they do look like tadpoles but even more impressive is the logic behind his reports.
     
    Quite a presentation.
     
    Linking and Presenting analysis services data.

    Brad McGeeHee DBA Best Practice

    Really good session on the basics of DBA. 
     
    Code camp has done well to balance presentations on basic skills with flashy stuff.
     
    A great guy to visit in Hawaii
     
     

    Greg Low on query execution plans

    This is my second time for this session and still it is fresh.
     
    This is a guy that really can't be missed.

    Working with Database Mirroring

    Julia Heather is covering Database Mirroring.  Julia is raising quite a level of discussion.  Julia works for Dimension Data.
     
    A good session.

    CSU Masters

    You can do a masters at CSU based on a Microsoft DBA or developer certification.  Or even an IT management certification.

    Rob Farley at Code Camp

    Rob is doing well to comment on using functions.
     
    The begin end implies that the function is really a procedure.  Though scalar functions do require the begin and end.