2014.02.18

   

SQL

   

• Why Your Slow SQL Server Doesn't Need a SQL Consultant (or Does It?)

  http://www.brentozar.com/archive/2014/02/slow-sql-server-doesnt-need-sql-consultant/

   

• DBA Myths: An index on a bit column will never be used.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/17/dba-myths-an-index-on-a-bit-column-will-never-be-used.aspx

     

• Script to Database Mirroring in SQL Server

  http://beyondrelational.com/modules/2/blogs/88/Posts/19838/script-to-database-mirroring-in-sql-server.aspx

     

• Unspecified Error SSIS Excel connection manager

  http://sqljunkieshare.com/2014/02/17/unspecified-error-ssis-excel-connection-manager/

     

• Using hash values in SSIS to determine when to insert or update rows

  http://www.mssqltips.com/sqlservertip/3170/using-hash-values-in-ssis-to-determine-when-to-insert-or-update-rows/

     

LINKS

   

• LAST WEEKS TOP "READING" LINKS #71

  http://www.jasonstrate.com/2014/02/last-weeks-top-reading-links-71/