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

Move Databases

NET START MSSQLSERVER /f /T3608
or
NET START MSSQL$instancename /f /T3608


use sqlcmd commands or SQL Server Management Studio to run the following statement.

ALTER DATABASE database_name MODIFY FILE( NAME = logical_name , FILENAME = 'new_path\os_file_name' )

use database_name

select file_name(1)


NET STOP MSSQLSERVER


NET START MSSQLSERVER.

Change schema name on Tables and Stored procedures in SQL Server 2005

SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name

FROM sys.tables p INNER JOIN sys.Schemas s on p.schema_id = s.schema_id

WHERE s.Name = 'CHANGE_ME_Username'


Results :ALTER SCHEMA dbo TRANSFER test.Table1

How to recover SA password on Microsoft SQL Server 2008 R2

http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/ create a new user. Enter following commands CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ Go grant the user a SYSADMIN roles using the same SQLCMD window. sp_addsrvrolemember ‘recovery’, ‘sysadmin’ go