Sharing Time, Factory Patterns

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

Exploring Factory Pattern (CodeProject)

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

Get it FastStack Linux Installer 5.2.0f

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

Resolution found here: Troubleshooting Microsoft SQL Server : Performance Dashboard error ...

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!!!