howdoisql

dumping ground for my sql reference

Run as a different Windows user

https://blog.sqlauthority.com/2015/10/10/sql-server-trick-running-ssms-with-different-windows-account/

replace AG group without dropping listener

https://support.microsoft.com/en-au/kb/2857849

Remote DAC

https://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx

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