#acl merlyn:read,write All:read
<<TableOfContents>>

= TIPS =
== How to Synchronize Two Microsoft SQL Databases ==
  * http://www.ehow.com/how_7466997_synchronize-two-microsoft-sql-databases.html
  * http://smallbusiness.chron.com/synchronize-two-microsoft-sql-databases-52142.html

= Peformance Tunning =
== MICROSOFT SQL SERVER PERFORMANCE TUNNING ==
  * https://netic.wordpress.com/2010/02/17/microsoft-sql-server-performance-tunning/
  * http://www.sqlsolutionsgroup.com/improve-io-performance/

== Determining a drive’s partition alignment offset ==
wmic partition get BlockSize, StartingOffset, Name, Index

== SQLIO - Block Size & IOs/sec ==
 * https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a7ce8a90-22fc-456d-9f56-4956c42a78b0/sqlio-block-size-iossec?forum=sqldatabaseengine
 * https://social.msdn.microsoft.com/Forums/sqlserver/en-US/36713a82-315d-45ef-b74e-5f342e0f22fa/sql-server-io-block-size?forum=sqldatabaseengine
 * http://www.midnightdba.com/Jen/2014/04/decree-set-your-partition-offset-and-block-size-make-sql-server-faster/
 * http://www.itpub.net/thread-1349921-1-1.html

== NBU MSSQL backup script ==
sql.bht
{{{
SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
SQLHOST "WIN-57NN25E3UC5"
NBSERVER "NBUMASTER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
}}}