SSIS Services 32 and 64 bit with Oracle Clients

Win2003+ SQL2005SSIS + two Oracle Homes (32,64bit)

Win2008+SQL2005SSIS + two Oracle Homes (32,64bit)

Win2008+SQL2008SSIS +One Oracle Home （32,64bit)

Rebuild System databases on SQL 2005

start /wait "T:\Installation\SQL 2005 64Ent\Disk1\setup.exe" /qn INSTANCENAME=PROD REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=1.uwsw0542

Error 1053: The service did not respond to the start or control request in a timely fashion ---- Fixed

1.Click Start, click Run, type regedit, and then click OK.

2.Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control

3.In the right pane, locate the ServicesPipeTimeout entry.

Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:

a.On the Edit menu, point to New, and then click DWORD Value.

b.Type ServicesPipeTimeout, and then press ENTER.

4.Right-click ServicesPipeTimeout, and then click Modify.

5.Click Decimal, type 60000, and then click OK.

This value represents the time in milliseconds before a service times out.

6.Restart the computer.

Github Vs Bitbucket

http://www.pocoo.org/~blackbird/github-vs-bitbucket/bitbucket.html

http://getcomparisons.com/github-vs-bitbucket

VMware for MAC OS X Mount Lion

mainMem.useNamedFile = "FALSE"

Search special colum name in all databases on SQL Server

sp_msforeachdb
'select "?" AS db, object_name(object_id,db_id("?")) , * from [?].sys.columns
where name=''user_login_name'''

SET TRANSACTION ISOLATION LEVEL (Transact-SQL)

ALTER DATABASE SET READ_COMMITTED_SNAPSHOT ON;


SELECT name ,is_read_committed_snapshot_on FROM
sys.databases WHERE is_read_committed_snapshot_on=1