howdoisql

dumping ground for my sql reference

register instances from list

https://www.mssqltips.com/sqlservertip/3252/automate-registering-and-maintaining-servers-in-sql-server-management-studio-ssms/

Advertisements

Powershell find all SQL

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()

 

 

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