Pauls Blog

Rarely do you need select from a select statement. Occasionally this pops up with complex PIVOTs and UNPIVOTs. The tip when doing this is (in MSSQL) is the "table" select statement needs to be aliased. For example, the following statement will not work: SELECT * FROM ( SELECT * FROM blah )  However, the following statement will work: SELECT * FROM ( SELECT * FROM blah ) x

https://technet.microsoft.com/en-us/library/ff432698.aspx change user /install change user /execute change user /query 

runas /netonly /user:HYPERV.\Administrator "mmc virtmgmt.msc"

Drove me freakin nuts. Under services. SMB, parameters, add the following to "Auxiliary parameters" ntlm auth = yes

Use this type of SQL to generate a listing of field names and properties for an MSSQL table USE //Your Database Name// SELECT c .object_id , c .column_id , c .name , types.name , c .[max_length] , c .[ precision ] , c .[ scale ] FROM sys.all_columns c JOIN sys.tables t ON c .object_id = t.object_id JOIN sys.types types ON c .user_type_id = types.user_type_id WHERE t.name = '//Your Table Name//'