howdoisql

dumping ground for my sql reference

how-to-run-programs-as-a-domain-user-from-a-non-domain-computer

http://codebetter.com/jameskovacs/2009/10/12/tip-how-to-run-programs-as-a-domain-user-from-a-non-domain-computer/

Improved AlwaysOn Availability Group Lease Timeout Diagnostics

Improved AlwaysOn Availability Group Lease Timeout Diagnostics

Diagnose Unexpected Failover or Availability Group in RESOLVING State

Diagnose Unexpected Failover or Availability Group in RESOLVING State

powershell sql

http://stefanteixeira.com/2015/09/01/automating-sqlserver-config-with-powershell-wmi/

Diff backups and copy only

http://sqlmag.com/blog/breaking-backup-chain-redux-or-eating-crow

Alter path of data files in AG group

https://blogs.msdn.microsoft.com/sqlserverfaq/2014/02/06/how-to-move-databases-configured-for-sql-server-alwayson/

Excel compare data in one colum to another

=COUNTIF($B$2:$B$5,A2)>0

Connect in single use & restore master

c:\>net start mssql$sqloo1 /m

SQLCMD -S Clusterresourcename\instancename -E

 

Restore database name with replace

Unprotect Word file

http://smallbusiness.chron.com/unprotect-word-doc-44160.html

Core based licensing

http://sqlperformance.com/2012/11/system-configuration/2012-cal-problems