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
Thursday, September 18, 2008
PC versus Mac - you tube sending up the mac
They are cleverly done to send a certain message!
PC vs MAC - Money
The PC vs MAC war - from the PC's point of view.Written and directed by Laurie McGuinness. Watch the full series at www.lauriemcguinness.com
PC vs MAC - At work
The PC vs MAC war - from the PC's point of view.Written and directed by Laurie McGuinness. Watch the full series at www.lauriemcguinness.com
PC vs MAC - Music
The PC vs MAC war - from the PC's point of view. Written and directed by Laurie McGuinness. Watch the full series at www.lauriemcguinness.com
PC vs MAC - The girl
The PC vs MAC war - from the PC's point of view. Written and directed by Laurie McGuinness. Watch the full series at www.lauriemcguinness.com
Regards,
Tom Bizannes
Sydney Australia
Monday, September 15, 2008
Migrating to Office 2007
Microsoft has made this so much fun!
Well I'm being sarcastic...This is not a simple process if you have vba enhanced applications.
Many clients are now going through the process and asking us to assist.
Excel linked workbooks and vba saveas are just two that come to mind immediately.
Was asked to knock up a bit of code to report on which workbooks had links and/or macros that could break.
The saveas issue will cause weird issues complaining of compatibility errors when there aren't any...but there are!
Word 2007 has other issues as some of the vba is just a little bit different so search and replace act a little different.
Outlook 2007 does weird things to your Microsoft Sql Reporting Services Scheduled html reports...Now that's a mouthful to say all at once!
Had to upgrade a 2007 access application application that created a menu on the fly depending on the user's status in a staff list and activated or de-activated certain items. All that because Microsoft blew away the object permission model.
But the new queries are nice with built in totals etc...
Regards,
Tom Bizannes
Microsoft Office Soutions
Sydney Australia
http://www.macroview.com.au
Well I'm being sarcastic...This is not a simple process if you have vba enhanced applications.
Many clients are now going through the process and asking us to assist.
Excel linked workbooks and vba saveas are just two that come to mind immediately.
Was asked to knock up a bit of code to report on which workbooks had links and/or macros that could break.
The saveas issue will cause weird issues complaining of compatibility errors when there aren't any...but there are!
Word 2007 has other issues as some of the vba is just a little bit different so search and replace act a little different.
Outlook 2007 does weird things to your Microsoft Sql Reporting Services Scheduled html reports...Now that's a mouthful to say all at once!
Had to upgrade a 2007 access application application that created a menu on the fly depending on the user's status in a staff list and activated or de-activated certain items. All that because Microsoft blew away the object permission model.
But the new queries are nice with built in totals etc...
Regards,
Tom Bizannes
Microsoft Office Soutions
Sydney Australia
http://www.macroview.com.au
City to Surf Times
Finally got my Certificate showing 86:53 as the 2008 time.
The City to surf guys emailed me the last few times as follows:
2000 - 124.26
2002 - 108.30
2006 - 104.39
2007 - 98.12
2008 - 86 minutes 53 seconds
2010 - 84 minutes 42 seconds
2011 - 85 minutes 48 seconds
2012 - 95 minutes 53 seconds
2013 - 82 minutes 8 seconds
Now to dig up the other times when I actually ran it properly.
Just ran a normal 14km on 1st June 2014 in 75 minutes and 12 seconds.
Got to get under 75 minutes for the first time in decades!
The City to surf guys emailed me the last few times as follows:
2000 - 124.26
2002 - 108.30
2006 - 104.39
2007 - 98.12
2008 - 86 minutes 53 seconds
2010 - 84 minutes 42 seconds
2011 - 85 minutes 48 seconds
2012 - 95 minutes 53 seconds
2013 - 82 minutes 8 seconds
Now to dig up the other times when I actually ran it properly.
Just ran a normal 14km on 1st June 2014 in 75 minutes and 12 seconds.
Got to get under 75 minutes for the first time in decades!
Tuesday, September 09, 2008
Sydney SQL Server User 9th September 2008
Quite an interesting night based around SQL Server Reporting Services 2008…..
The pizza was plentiful…Cholesterol levels rose quite a bit last night.
Grant from Angry Koala, gave away some of his little koala bears for answers to some of his questions!
Interesting Marketing ploy!
Maybe MacroView needs to give away a lot more cubes!
The exciting news is that in October a SQL Server 2008 feature Pack will come out with lots more goodies such as report builder with a nice office 2007 look and being almost the same as the report designer!
Business users should get exciting.
There will be some other exciting new extras in this so will let you guys know…..
Hopefully will go through all this in the sql code camp in October etc…
There should be a lot more feature packs so that nice enhancements can be delivered faster and easier….
The new report designer is much nicer and changed quite a bit.
The tablix controls means smarter simpler and more powerful reporting without code gymnastics!
Big reports run smarter – eg. Only render the first page so they won’t bring the server to it’s knees!
Also the outputs to Excel are better along with the new output to Word. Nice!!!
Apparently one of the uses is to generate and send monthly invoicing etc….
The rich text stuff was only briefly flashed on the screen, but everything is so much nicer that you won’t want to do anything with the “old” stuff…
Two tips of the day:
1: Setting the interactive size for height and width to zero means it will fit the whole screen – e.g. no next page stuff.
The page size settings apply to printing…..
2: Name all reports starting with a number e.g. R001 – New Prospects.
That way every time a client ( or internal user ) calls about a report, it is really easy to figure out which one.
And what with the long names you use, many users will also get to know their favourite reports by number as well!
Coming up:
Next Wednesday at Microsoft, Adam Cogan at the .net user group will go over all the admin stuff..
I might go along and keep him in line and teach him a few tricks to do with incorporating this into SharePoint!
Also SQL Code Camp in Wagga Wagga is coming up this October so it should be quite interesting…
Tom Bizannes
Microsoft Certified Professional
Sql Server and Microsoft Office Development
Sydney, Australia
http://www.macroview.com.au/
The pizza was plentiful…Cholesterol levels rose quite a bit last night.
Grant from Angry Koala, gave away some of his little koala bears for answers to some of his questions!
Interesting Marketing ploy!
Maybe MacroView needs to give away a lot more cubes!
The exciting news is that in October a SQL Server 2008 feature Pack will come out with lots more goodies such as report builder with a nice office 2007 look and being almost the same as the report designer!
Business users should get exciting.
There will be some other exciting new extras in this so will let you guys know…..
Hopefully will go through all this in the sql code camp in October etc…
There should be a lot more feature packs so that nice enhancements can be delivered faster and easier….
The new report designer is much nicer and changed quite a bit.
The tablix controls means smarter simpler and more powerful reporting without code gymnastics!
Big reports run smarter – eg. Only render the first page so they won’t bring the server to it’s knees!
Also the outputs to Excel are better along with the new output to Word. Nice!!!
Apparently one of the uses is to generate and send monthly invoicing etc….
The rich text stuff was only briefly flashed on the screen, but everything is so much nicer that you won’t want to do anything with the “old” stuff…
Two tips of the day:
1: Setting the interactive size for height and width to zero means it will fit the whole screen – e.g. no next page stuff.
The page size settings apply to printing…..
2: Name all reports starting with a number e.g. R001 – New Prospects.
That way every time a client ( or internal user ) calls about a report, it is really easy to figure out which one.
And what with the long names you use, many users will also get to know their favourite reports by number as well!
Coming up:
Next Wednesday at Microsoft, Adam Cogan at the .net user group will go over all the admin stuff..
I might go along and keep him in line and teach him a few tricks to do with incorporating this into SharePoint!
Also SQL Code Camp in Wagga Wagga is coming up this October so it should be quite interesting…
Tom Bizannes
Microsoft Certified Professional
Sql Server and Microsoft Office Development
Sydney, Australia
http://www.macroview.com.au/
Sunday, August 08, 2004
MICR Enabled printers and on board printer calls.
Just changed jobs recently.
My old company specialised in reconciliation systesm and data processing systems using Powerbuilder 7 and Sybase or MsSql Server at the backend.
They also tried to sell MICR enabled printers using the on-board simms sold by source tech from the USA which go into IBM and Lexmakr printers.
They didn't know how to read the manuals supplied and thought incorrectly it was very difficult to make calls to the simms.
Prior to leaving, I discovered in word that you can make printer calls!
All technology is easy if you have the time to read and absord all the relevent information.
Maybe I will sell my knowledge to people who want to use these bits of hardware, as it seems no-one thinks they are easy to use!
As for reconciliation systems, they are simple but there are few good ones out there!
Looking carefully at using foxpro and MSDE or SQL Server Express as the new tools to tackle this
My old company specialised in reconciliation systesm and data processing systems using Powerbuilder 7 and Sybase or MsSql Server at the backend.
They also tried to sell MICR enabled printers using the on-board simms sold by source tech from the USA which go into IBM and Lexmakr printers.
They didn't know how to read the manuals supplied and thought incorrectly it was very difficult to make calls to the simms.
Prior to leaving, I discovered in word that you can make printer calls!
All technology is easy if you have the time to read and absord all the relevent information.
Maybe I will sell my knowledge to people who want to use these bits of hardware, as it seems no-one thinks they are easy to use!
As for reconciliation systems, they are simple but there are few good ones out there!
Looking carefully at using foxpro and MSDE or SQL Server Express as the new tools to tackle this
Subscribe to:
Posts (Atom)
