Sharing Time, Factory Patterns

Just came across this, fairly fresh and relative to my current projects framework. 



My thoughts: Flexible, Scalable, Affords abiblity to be quick to adapt and change with little stress or impact on system.

Trader joe

It's a small world

Disneyland

Installing SugarCRM


After download complete, change properties to allow execution. Then double click on package. Go through the motions



VM ESXI Cloning/Copying

Granted, you must already have SSH enabled.(http://www.yellow-bricks.com/2008/08/10/howto-esxi-and-ssh/)
Here's what you do:('~' = Type it)

START --> RUN --> ~CMD
~CD "C:\Program Files\WinSCP\winscp"
~OPEN {sever name / ip}
Searching for host...
Connecting to host...
{sever name / ip} session userName: ~{username}
{sever name / ip} session password: ~{password}
Authenticated.
Starting the session...
Reading remote directory...
Session started.
Active session: [1] {sever name / ip}
winscp>
~call vmkfstools -i /vmfs/volumes/{datastore}/{copyFromFolder}/{vmtocopy}.vmdk /vmfs/volumes/{datastore}/{newfolder}/{newvmname}.vmdk
Destination disk format: VMFS thick
Cloning disk '/vmfs/volumes/{datastore}/{copyFromFolder}/{vmtocopy}.vmdk'...
Clone: 100% done.
winscp>
~Happy Cloning

ICS no bueno, FreeProxy great alternative

ICS has alot of limitations, buggest being the inability to specifiy a default gateway. It's alway 192.168.0.1. For most, this is the default gateway on their LAN.  After much wasted effort i came across this, FreeProxy. A godsend of a free blessing to get around the "ICS  sucks" factor. They have  great documentation and have been widely implemented with great succes, me for one. To boot, it will run right after installation will minimal effort.

Big for nothin

Check out the size of box to item

Performance Dashboard error

FYI on this error: "Difference of two datetime values caused an overflow at runtime" in SQL Performance Dashboard


Bamboo good

Pic pic

Get you red hot Foreign and primary keys here!!!

Reduce the human factor, auto-generate/ boiler plate / conserve your brain...

Autogenereate base classes from solid DB design with proper contraints and relations. One of my developers did some googling and head scratching, and we got this...

WITH CTE AS (
SELECT      
OBJECT_NAME(sic.OBJECT_ID) PK_TableName
,COL_NAME(sic.OBJECT_ID,sic.column_id) PK_ColumnName
,OBJECT_NAME(sfkc.parent_object_id) FK_TableName
,COL_NAME(sfkc.referenced_object_id,sfkc.referenced_column_id) FK_ColumnName
FROM 
INFORMATION_SCHEMA.TABLES AS T
    JOIN sys.foreign_key_columns AS sfkc ON OBJECT_NAME(sfkc.parent_object_id) = T.Table_Name
LEFT JOIN sys.index_columns sic on OBJECT_NAME(sic.OBJECT_ID) = OBJECT_NAME(sfkc.referenced_object_id) 
WHERE  
T.Table_Type = 'Base Table'  
 UNION ALL 
 SELECT      
OBJECT_NAME(sic.OBJECT_ID) PK_TableName
,COL_NAME(sic.OBJECT_ID,sic.column_id) PK_ColumnName
,NULL FK_TableName
,NULL FK_ColumnName
FROM 
INFORMATION_SCHEMA.TABLES AS T
    JOIN sys.index_columns sic ON OBJECT_NAME(sic.OBJECT_ID) =  T.Table_Name    
WHERE 
 T.Table_Type = 'Base Table')
Select 
PK_TableName
, PK_ColumnName
, FK_TableName
, FK_ColumnName
From CTE;

If you have a solid db design you can auto generate your base classes / UI / whatever from this info.  Left join this to your INFORMATION_SCHEMA.TABLE and you should see the benefits. If not send me a comment :P. 

WOOT TO BOB!!!