2013.08.27

  196회 SQLTag Daily Links    

SQL

   

• SQL Server ? Script to get Service Account for all local instances

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/26/sql-server-script-to-get-service-account-for-all-local-instances.aspx

     

• Bank Holiday Fun - DDL Trigger

  http://sqlserver365.blogspot.kr/2013/08/bank-holiday-fun-ddl-trigger.html

     

• The effect of VLF size on shrinking the log.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/26/the-effect-of-vlf-size-on-shrinking-the-log.aspx

     

• Mining transaction log backups

  http://sqlscope.wordpress.com/2013/08/26/mining-transaction-log-backups/

     

• Real time auditing of failed SQL Server logins with user settable performance counters in Performance Monitor

  http://www.mssqltips.com/sqlservertip/3017/real-time-auditing-of-failed-sql-server-logins-with-user-settable-performance-counters-in-performance-monitor/

     

• SQL ? Identify & Drop Duplicate Index

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/26/sql-identify-amp-drop-duplicate-index.aspx

     

• LAST WEEKS TOP "READING" LINKS #46

  http://www.jasonstrate.com/2013/08/last-weeks-top-reading-links-46/

     

• My Five Favorite That Conference Memories

  http://www.brentozar.com/archive/2013/08/my-five-favorite-that-conference-memories/

     

• SqlDev PowerShell 102: Working with Data and Variables

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/26/sqldev-powershell-102-working-with-data-and-variables.aspx

     

• Eight Steps to Effective SQL Server Monitoring

  http://www.sqlservercentral.com/redirect/articles/101599/

     

• Minimal Logging

  http://www.sqlservercentral.com/articles/Administration/100856/

     

• Powershell FAQ for the SQL Server DBA

  http://www.sqlserver-dba.com/2013/08/powershell-faq-for-the-sql-server-dba.html

     

• How to Become a Better DBA

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/26/how-to-become-a-better-dba.aspx

  좋은 내용이네요

     

Other

   

• Data Science and the Cloud

  http://sqlblog.com/blogs/buck_woody/archive/2013/08/26/data-science-and-the-cloud.aspx