howdoisql

dumping ground for my sql reference

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

litespeed extract

http://documents.software.dell.com/litespeed-for-sql-server/8.0/user-guide/use-command-line-interface/convert-litespeed-for-sql-server-backups-to-sql-server-backups

check if AG job

http://sqltomato.blogspot.com.au/2013/06/alwayson-and-sql-agent-jobs.html

ISS connection to named instance

http://www.igregor.net/post/2009/01/21/Connect-to-SSIS-on-Named-Instance-of-SQL-Server.aspx

Follow

Get every new post delivered to your Inbox.