Pauls Blog

First, create your certificate with something like... CREATE CERTIFICATE YourTestKey1    ENCRYPTION BY PASSWORD = 'a secure password    WITH SUBJECT = 'My Test Key',      EXPIRY_DATE = '20201231'; GO More to follow.....

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//'

I created this procedure to help me with Data Warehouse work. Ordinarily, SQL Studio can do this all for you automatically, but recently I've adopted a more hands on approach. 1) Insert data into a new table