This was really good.
Full kudos to Graham Seach for Organising this.
Couldn't go to all the sessions...but learnt a few new tricks.....
I presented Real World Access and Real World Excel...Two rapid fire ones about migrations to Office 2007 where we helped clients to upgrade microsoft office and discovered a few gotchas..
Wow these really stretch you...It's easier to talk for an hour than for 10 minutes!
Got back and now designing an Access 2007 picture gallery/viewer for your pc...
Access can read and show pictures in a directory without having to load them into the database.
Regards,
Tom
Wednesday, November 19, 2008
Re: Michael Noel and SharePoint Virtualisation
This was really good…
Michael Noel did a really good talk about virtualising SharePoint using either HyperV or Vmware. ( and he also mentioned no 3 in virtualisation - Cirtix Xen Server)
Still cannot believe Michael flew in from the states today and is flying out again today….just to talk to me and Peter regarding virtualising SharePoint…
Well actually there were a few others there….
He’s written a few SharePoint and isa server books and whitepapers for Microsoft etc…He knew his stuff.
One of his clients has 250,000 SharePoint Users!
Don’t virtualise Sql Server was one very important point…This is due to the high I/O of Sql Server
Next to go physical would be Index Server….
Other Virtuals only lose 2% to 3% of CPU performance so web servers do make a good case for Virtualisation.
Watch the NUMA boundaries…giving to much Ram for a virtual doesn’t equate to better performance if the NUMA boundary is hit..--> Too much paging etc...
Good rule of thumb … Ram per vm = Ram/CPUs…..
e.g two quad cores --> 8 cpus --> 64G of Ram --> 64/6 = 8G per virtual.
Hyper V guys need to get Ms Virtual Machine Manger 2008 – came out in Oct 2008…
Check out:
http://tinyurl.com/virtualsp
http://tinyurl.com/edgenoel2
http://tinyurl.com/edgenoel3
Virtual Machine Manager 2008 is out now….
System Centre Data Protection Manager 2007 great for shadow copies to restore sharepoint servers faster..
VMware has a cool tool P2V (free now!!) for copying physica to Virtual Machines…
Will need to email some people who asked me about this this year….
Big sites get vmware ESX or Citrix xen server 5 for vmotion or xen motion for great fail over if one server goes down.
Synergy and AvePoint have some SharePoint Replicators? … Will need to check these out…
Peter came along because apart from hyper v he is now playing with vmware---
It was good that Michael confirmed what I had hinted to the guys about -- don't virtualise SQL Server..That being said, up to 100 users should push sq server too far? Maybe not unless they are really using SharePoint by using an addon like Wisdom DMF where they can easily open and save their documents....Then take no chances...
Michael Noel did a really good talk about virtualising SharePoint using either HyperV or Vmware. ( and he also mentioned no 3 in virtualisation - Cirtix Xen Server)
Still cannot believe Michael flew in from the states today and is flying out again today….just to talk to me and Peter regarding virtualising SharePoint…
Well actually there were a few others there….
He’s written a few SharePoint and isa server books and whitepapers for Microsoft etc…He knew his stuff.
One of his clients has 250,000 SharePoint Users!
Don’t virtualise Sql Server was one very important point…This is due to the high I/O of Sql Server
Next to go physical would be Index Server….
Other Virtuals only lose 2% to 3% of CPU performance so web servers do make a good case for Virtualisation.
Watch the NUMA boundaries…giving to much Ram for a virtual doesn’t equate to better performance if the NUMA boundary is hit..--> Too much paging etc...
Good rule of thumb … Ram per vm = Ram/CPUs…..
e.g two quad cores --> 8 cpus --> 64G of Ram --> 64/6 = 8G per virtual.
Hyper V guys need to get Ms Virtual Machine Manger 2008 – came out in Oct 2008…
Check out:
http://tinyurl.com/virtualsp
http://tinyurl.com/edgenoel2
http://tinyurl.com/edgenoel3
Virtual Machine Manager 2008 is out now….
System Centre Data Protection Manager 2007 great for shadow copies to restore sharepoint servers faster..
VMware has a cool tool P2V (free now!!) for copying physica to Virtual Machines…
Will need to email some people who asked me about this this year….
Big sites get vmware ESX or Citrix xen server 5 for vmotion or xen motion for great fail over if one server goes down.
Synergy and AvePoint have some SharePoint Replicators? … Will need to check these out…
Peter came along because apart from hyper v he is now playing with vmware---
It was good that Michael confirmed what I had hinted to the guys about -- don't virtualise SQL Server..That being said, up to 100 users should push sq server too far? Maybe not unless they are really using SharePoint by using an addon like Wisdom DMF where they can easily open and save their documents....Then take no chances...
Tuesday, November 11, 2008
Re: Sydney Sql Server User Group Tuesday 11th November 2008
BI was the topic.
This was slightly different than a canned demo as open conversation and comments were the go..
The main things one got out of this would be that the more you know MDX, the better you can design reports, build cubes and anlyse the data....
There was a hint that one can do MDX in Excel 2007....Will try this out.....That would enable you to do more than just slice and dice.....
e.g. For power analytics...
This was slightly different than a canned demo as open conversation and comments were the go..
The main things one got out of this would be that the more you know MDX, the better you can design reports, build cubes and anlyse the data....
There was a hint that one can do MDX in Excel 2007....Will try this out.....That would enable you to do more than just slice and dice.....
e.g. For power analytics...
Sunday, November 02, 2008
Office Dev in two weeks time!
The Office Development Conference is only two weeks away!
If you are thinking of going, you need to let them know via email so there will be enough Pizza!
Oh my gosh!...Will need to get my Cholesterol checked before this weekend!
Same as last year, cannot go to all the sessions I want to go to!
FYI – I am doing two quick rapid fire sessions, as I will be the only Excel Expert speaking apart from Grant at Angry Koala talking about data mining....
plus I couldn’t help myself and just had to do something on Access rather than just sit and correct people all the time!
Will have to hand around a few WISDOM cubes……
Regards,
Tom Bizannes
Sydney, Australia
http://www.macroview.com.au
If you are thinking of going, you need to let them know via email so there will be enough Pizza!
Oh my gosh!...Will need to get my Cholesterol checked before this weekend!
Same as last year, cannot go to all the sessions I want to go to!
FYI – I am doing two quick rapid fire sessions, as I will be the only Excel Expert speaking apart from Grant at Angry Koala talking about data mining....
plus I couldn’t help myself and just had to do something on Access rather than just sit and correct people all the time!
Will have to hand around a few WISDOM cubes……
Regards,
Tom Bizannes
Sydney, Australia
http://www.macroview.com.au
Subscribe to:
Posts (Atom)
