enables the SQL Server Agent extended stored procedures in SQL Server 2012

The possible values are:

0, indicating that SQL Server Agent extended stored procedures are not available (the default).

1, indicating that SQL Server Agent extended stored procedures are available.


The following example enables the SQL Server Agent extended stored procedures.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

Installing Web Front End Only requires install from command line

If you want to install just a web front end, you have to run the install from the command line. 

Follow the instructions at http://technet.microsoft.com/en-us/library/cc262897.aspx and create a config file for server type="WFE"

Allowing other machines to use filesharing via the DNS Alias in Windows OS

Allowing other machines to use filesharing via the DNS Alias (DisableStrictNameChecking)

This change alone will allow other machines on the network to connect to the machine using any arbitrary hostname. (However this change will not allow a machine to connect to itself via a hostname, see BackConnectionHostNames below).

    Edit the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters and add a value DisableStrictNameChecking of type DWORD set to 1.

    Edit the registry key (on 2008 R2) HKLM\SYSTEM\CurrentControlSet\Control\Print and add a value DnsOnWire of type DWORD set to 1

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