July 2009 - Posts

1
Comments

SQL for SMS/ConfigMgr Tip - Distribute data evenly from 1 SQL file to multiple SQL files by jnelson

BACKGROUND When you first install an application like SMS or ConfigManager, the underlying SQL database is sitting in one data file. Now, depending on...
0
Comments

Outlook - How do I empty the Sync Issues\Local Failures folder in Outlook? by jnelson

So your mailbox at work keeps filling up and you get these messages from your Exchange admin saying you need to clean up your mailbox. Problem is, even...
3
Comments

ConfigMgr 2007 - Where is v_GS_COMPUTER_SYSTEM_PRODUCT in CM? I think it's missing! by jnelson

If you're building reports in Configuration Manager 2007 like you did in SMS 2003, you may be looking for the view: V_GS_COMPUTER_SYSTEM_PRODUCT I...
2
Comments

UPDATED: SQL Function - udf_ConvertBytes - Converts any Byte-based unit of measure to any other Byte-based unit of measure (Bytes, MB, GB, TB, PB, EB, ZB, YB, BB, GeopBytes) by jnelson

Yesterday I wrote THIS article to convert between different byte-based units of measure...in it I wrote that the ideal way to convert is to have a lookup...
3
Comments

SQL Function - udf_ConvertBytes - Converts any Byte-based unit of measure to any other Byte-based unit of measure (Bytes, MB, GB, TB, PB, EB, ZB, YB, BB, GeopBytes) by jnelson

(UPDATE: This article has been updated HERE based on some performance testing I conducted) By far, the most popular article I've ever written is THIS...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems