Useful tips

1. How to load all the assemblies?

var loadedAssemblies = AppDomain.CurrentDomain.GetAssemblies();

2. Combine absolute & relative paths

var relativePath = "..\\bling.txt";

var baseDirectory = "C:\\blah\\";

var absolutePath = Path.GetFullPath(baseDirectory + relativePath);

3. Get x86 Program folder

    static string ProgramFilesx86()

    {

       if( 8 == IntPtr.Size

       || (!String.IsNullOrEmpty(Environment.GetEnvironmentVariable( 

                "PROCESSOR_ARCHITEW6432"))))

       {

            return Environment.GetEnvironmentVariable("ProgramFiles(x86)");

       }

        return Environment.GetEnvironmentVariable("ProgramFiles");

    }

4. Delete a windows server

   sc delete [servicename]

5. Sometimes Server.Databases[name].Drop() will fail with 'Currently in use' error 

   or FailedOperationException. These scenarios we have to 'Server.KillDatabase()).

6. Script to create User with server admin role

 USE [master];

 GO

 CREATE LOGIN SimpleUser

    WITH PASSWORD    = N'SimpleUser',

    CHECK_POLICY     = OFF,

    CHECK_EXPIRATION = OFF;

 GO

 EXEC sp_addsrvrolemember

    @loginame = N'SimpleUser',

    @rolename = N'sysadmin';

7. Sn -T [assembly] to get PublicKeyToken.

8. Remove database(s) based on name

DECLARE @Temp TABLE (Id INT IDENTITY(1, 1), name nvarchar(max));
DECLARE @RowCounter INT;
DECLARE @i INT;

INSERT INTO @Temp select name from sys.databases where name like N'GS_81%'

SELECT @RowCounter = MAX(Id) FROM @Temp

SET @i = 1

DECLARE @DBDeleteByName NVARCHAR(max);

WHILE @i <= @RowCounter
BEGIN
    SELECT @DBDeleteByName = 'DROP DATABASE [' + name + ']'  FROM @Temp WHERE Id = @i

    EXEC sp_executesql @DBDeleteByName;

    SET @i = @i + 1;
END