...your virtual communITy
Welcome to Sign in | Join | Help
in Search

Garth Jones

March 2010 - Posts

  • The Ottawa IT Day / Code Camp April 17th

    The Ottawa Code Camp is back with a new look and more sessions this year. We have included a new track for the IT Pro and we changed the name of the event to the Ottawa IT Day / Code Camp. This initiative from the Ottawa community is bigger this year with 20 sessions divided in 4 tracks. We have a brand new IT Pro track including the best speakers of Ottawa, a SQL Server track, a .Net track and a Fantastic  Silverlight application track.  We invite you all to come and join us at this free event for a free full day of training.

    Check out the agenda at this link:

    Register at this link:

    Digg This
  • Added Collection

    Select Distinct
        dbo.v_R_System sys
        JOIN dbo.v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
        JOIN dbo.v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
        join dbo.v_Collection Col on Col.CollectionId = fcm.CollectionID
        DisplayName0 = @displayname and

    Digg This
  • PCs with more than IP Address.

        IPAddress0 is NOT NULL
    Group by
    Order by

    Digg This
  • Hack and Defend

    MS Canada is bring back their “Hack and Defend” workshops!

    It’s back!  Last years popular Hack and Defend workshops are back!  Step inside the mind of a hacker at Microsoft’s Hack and Defend Workshop. Discover the tactics used to penetrate your PC, become aware of the most threatening viruses online, and most importantly, learn how to help protect yourself.

    Hands-on presentations by industry-leading professionals and Microsoft experts in security will demonstrate the most current hacking methods and propose practical ways to help protect yourself.  I won’t be able to attend this year as I’ll be on the road with EnergizeIT but if you are near I strongly urge you to attend.  This was a great workshop last year



    Wednesday, April 7

    Register for the morning session

    Register for the afternoon session


    For full detail see Rodney’s blog post.

    Digg This
    Posted Mar 18 2010, 08:24 AM by Garth with 1 comment(s)
    Filed under: ,
  • AI and Project

        join LU_SoftwareCode SC on GIS.SoftwareCode0 = SC.SoftwareCode
        join LU_SoftwareList SL on SC.SoftwareID = SL.SoftwareID
    --    GIS.SoftwareCode0 = '{90120000-0014-0000-0000-0000000ff1ce}'
        SL.CommonName = 'Microsoft Office Project 2007 Professional Edition'


    Digg This
  • Samsung “Galaxy” aka GT-I7500L

    Well, I purchase an Samsung Galaxy (GT-I7500L) on Friday. Over the weekend I played with it, setting it up and download the desktop sync software (dated Mar 10 2010!), etc. I ran into some issues with the software and the phone.

    Today I went back to the Bell store where I purchased this phone. To talk about issues I’m having with it. Although the store staff was helpful their hand are tied as to what they can do. So I got home and called Samsung Canada. I finally got to their mobile device support person. She started with a ton of irrelevant questions. I finally cut her off an said this is my problem.

    My problem is that “Samsung New PC Studio” does not work with Windows 7.

    She tells me that “She is sorry about that but Samsung will be coming out with a new version in the next year to solve that.”

    I say "In the next year! What should I do until it come out?”


    I ask “Will be finally support x64 bit OS?”

    Paraphrasing her, “Basically, she doubts it!”

    Ask to talk to a supervisors and I was told that they will not talk to me because it was a software issue.

    Again paraphrasing her, “Basically, I can do is wait and maybe if I’m lucky will Bell / Samsung do something to fix this.”

    So I ask you “the community”, Is it realist that a manufacture in this day and age, to still not support 64bit OS? Windows XP x64 came out 8+ years ago (Oct 21 2001)!

    Windows 7 was released on July 22, 2009, should it take them this long to support it too?


    I truly want to hear your feedback on this! am I being unrealistic to think that both Windows 7 and x64 bit OS should be supported?

    Also what I want to know is, when will MS start “putting the screws” to companies that don’t support x64 OS? It is nuts that x64 OS are not supported.

    BTW, I’m looking up the tech support number for Blackberry now, if they support Windows 7 on a x64bit OS, this Samsung is going back!

    Digg This
    Posted Mar 15 2010, 04:25 PM by Garth with no comments
    Filed under: ,
  • March 25 User Group Event – Windows 7 Deployment Deep Dive Take 2

    This event was incredibly popular last time and many could not make it either because the registration filled up or the storm so Pierre Roman has offered to run the event one more time!

    Topic: Deployment Deep Dive on Windows 7 Community Tour-Ottawa Take 2


    Are you running Windows XP?  Are you feeling the pressure of creating a deployment plan? Have no fear!  Leveraging learning’s from two Windows 7 early adopters this session will give you the skills you need to proceed with your own deployment.  The session will focus on free Windows 7 deployment planning and deployment tools that customize operating system packages and automate deployment planning and network deployments seamlessly. We will dive right into:        

    • How to use the Microsoft Assessment and Planning (MAP) tool to identify your current hardware and application inventory.
    • How to use the Windows Automated Install Kit (WAIK) to build a customized image for your organization.
    • How to use the Microsoft Deployment Toolkit (MDT) to build, deploy and maintain Windows installation images.
    • How to migrate the end users profile from their current installation to the Windows 7 installation using the User State Migration Toolkit (USMT).
    • How to integrate MDT and Windows Deployment Services (WDS) to perform Lite Touch installations of Windows 7.

    Finally we will look at how we can leverage the various tools to solve any application compatibility issues you might encounter.  We will look at how you can overcome common obstacles using the Application Compatibility Toolkit (ACT), or larger obstacles using Windows XP Mode and Microsoft Enterprise Desktop Virtualization (MED-V) and even how you can leverage Application Virtualization (App-V) to streamline application deployment and ensure all your applications work!

    Please note: there is no cost to attend this event.

    Microsoft Canada Co.
    100 Queen Street Suite 500
    Ottawa, Ontario
    K1P 1J9


    5:00 p.m.  Event registration
    7:30 p.m.  Q & A
    8:00 p.m.  Door Prizes


    · Pizza and Pop will be served, Please RSVP to help us order enough of both.

    · Please note that no one will be admitted after 5:55 p.m.!

    Registration site:

    Event Code: 146761

    Links Web Site Mailing list Blog         Forums  

    Digg This
  • 70-669 study guide material


    While reading another forum this morning I found this tidbit.

    Digg This
  • Query for a portion of a NetBIOS Name

    select * from dbo.v_GS_COMPUTER_SYSTEM
    where name0 like '___m%'

    Digg This
  • Free Windows 7 and MMS

    Do you want a free copy of Windows 7? if so check out this post!

    Digg This
    Posted Mar 03 2010, 07:04 AM by Garth with no comments
    Filed under: ,
  • ConfigMgr / SCCM Documentation Script v1.24

    The ConfigMgr / SCCM documentation script has been updated to v1.24 for more details please see

    Digg This
  • Office Count

        dbo.v_Add_Remove_Programs ARP
        DisplayName0 like '%office%'
    Group by
    Order by

    Digg This
    Posted Mar 01 2010, 03:45 PM by Garth with no comments
    Filed under: , , ,
  • JOTD – March 1 2010


    Digg This
    Posted Mar 01 2010, 01:56 PM by Garth with no comments
    Filed under: ,

This Blog




Powered by Community Server (Non-Commercial Edition), by Telligent Systems