Sharepoint notes from Matt Velloso

-
These are some notes from Matt Velloso's session at TechEd 09 on the 14th Sept. These are just my notes created whilst watching the session and they can be used as a start point to find out more information.

Myths to debunk:
  • You can change meta data easily. Well, yes you can, however, that doesn't mean you should. So don't. If you need to change your meta data, plan it out first and make sure that your changes don't break another part of the system.
  • There's no code so it's risk free. Cobblers. What do you think runs Sharepoint if it's not code? Always manage risk and plan for various eventualities.
  • It's an out of the box app, we don't need to test. Sigh.... just test it already and get over the 'testing isn't necessary' mentality.
Blobcache
  • Stop going to SQL Server all the time
  • Use Fiddler2 (HTTP debugging proxy) to check the status of your blobcache
  • Enable blobcache in web.config
  • How to break your blobcache: reset IIS, hit refresh on your page. You need to tell the service not to use the sharepoint DLLs. web.config change in http modules section. Remove all http modules that are sharepoint dlls and then do an IIS reset. Reason why it was broken? You lock your resources when you refresh as services run on a FIFO basis.
Content Types
  • When fixing/updating, don't uninstall the feature. Migrate properly to ensure all data types are updated correctly, including historical items.
  • Do things in an incremental manner
  • Script changes in .NET if they are major changes
Timer Job
  • Issue: Timer job service randomly stops. Why? Log on as a service policy was enforced by domain policy to all machines, including servers.

Other notes
  • Absinthe is a very cool tool for hacking databases via a web app. Uses SQL injection.
  • Full deployment deletes site and redeploys - DON'T do this after your first deployment. Use Incremental deployment instead. And if your incremental deployment isn't working then fix it!
  • Lists vs. Tables - make sure you use the correct tool for the job, i.e. use tables for complex data relationships and use lists for workflows. It's okay to use a mixture of both.
  • List performance - do NOT use GC.collect()
  • Check out tool: sp_disposecheck

Comments

Post a Comment

Popular posts from this blog

Yay - It works! Rebuild/Reorganize all indexes in one go - woo hoo

-
/*Version 1 of my script to fix all fragged indexes on a database */ /*Must be logged in as [sa] for this to work, if not, you will get permissions errors*/ /*You should be able to copy and paste this script in its entirity to your SQL 2005 or higher query window and run it without altering anything other than the USE .*/ /*Perform a 'USE ' to select the database in which to run the script.*/ USE AdventureWorks GO -- Make sure temp table doesn't exist IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tmp_fraglist]') AND type in (N'U')) DROP TABLE [dbo].[tmp_fraglist] GO -- Declare variables SET NOCOUNT ON DECLARE @tablename NVARCHAR (255) DECLARE @indexname NVARCHAR (255) DECLARE @indextype NVARCHAR (255) DECLARE @execstr NVARCHAR (255) DECLARE @pagecounts INT DECLARE @frag DECIMAL DECLARE @reorgFragSize DECIMAL DECLARE @rebldFragSize DECIMAL DECLARE @numrecords INT DECLARE @rowcount INT DECLARE @errorMessage
Read more

The Grace Jones

-
Well, we finished recording the CD and now all the hard work is starting, the editing, mixing, production etc... We've also got some guys working on a video for us which sounds as though it's going to be interesting. Time to sell the house in order to pay for the tour of Ireland next year I guess. :)
Read more

What is a geek?

-
Someone raised an interesting point on Monday night at a GGD dinner and I feel they have missed the entire point of Girl Geek Dinners and have also, with their comments, seriously undermined other women who are looking to come out of their shell and interact with other 'geeks'. If you don't agree with what we're doing then don't come to a Girl GEEK dinner, and certainly don't turn up and throw cold water on people, make belittling comments and then moan that it was too technical and you didn't enjoy it. So what is a geek? There seemed to be some confusion. These women throwing around the derogatory comments seem especially confused. So let's refresh everyones' minds. You don't need to be in IT to be a geek folks! It's not an exclusive club limited to women who don't baulk at the thought of writing code. We're a diverse crowd and we celebrate each others geekiness, even if it isn't something we're into. We certainly
Read more