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

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

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!

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/