2013.03.22

   

SQL

   

• Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection.-SQL Server SSIS

  http://beyondrelational.com/modules/2/blogs/88/Posts/19188/failed-to-acquire-connection-connection-may-not-be-configured-correctly-or-you-may-not-have-the-righ.aspx

     

• Which LOB pages are associated with a specific columnstore segment?

  http://www.sqlskills.com/blogs/joe/which-lob-pages-are-associated-with-a-segment/

   

• A SECOND MARCH 'INDEX ANALYSIS' UPDATE

  http://www.jasonstrate.com/2013/03/a-second-march-index-analysis-update        

     

• Log Shipping FAQ

  http://www.brentozar.com/archive/2013/03/log-shipping-faq/

     

• Considerations when starting a new SSDT database project - SSIS Junkie

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/21/considerations-when-starting-a-new-ssdt-database-project.aspx

     

• SQLServerCentral Runs sp_Blitz - Performance Part 2

  http://www.sqlservercentral.com/articles/SQLServerCentral/96158/

     

• SQL SERVER – Identify Last User Access of Table using T-SQL Script

  http://blog.sqlauthority.com/2013/03/21/sql-server-identify-last-user-access-of-table-using-t-sql-script/

     

• SQL Server Login Management using LOGINPROPERTY function

  http://www.mssqltips.com/sqlservertip/2906/sql-server-login-management-using-loginproperty-function/

  보안 관련 검토할 때 유용할 것 같네요