2013.06.12

   

SQL

   

• The Accidental DBA (Day 11 of 30): Backups: Backup Storage and Retention

  http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-11-of-30-backups-backup-storage-and-retention

   

• SQL Server Standard Edition High Availability Futures

  http://www.sqlperformance.com/2013/06/system-configuration/sql-server-standard-edition-high-availability-futures

     

• A performance issue involving CLR garbage collection and SQL CPU affinity setting

  http://blogs.msdn.com/b/psssql/archive/2013/06/11/a-performance-issue-involving-clr-garbage-collection-and-sql-cpu-affinity-setting.aspx

   

• Getting a SharePoint List Data Source to work with Reporting Services Native Mode

  http://blogs.msdn.com/b/psssql/archive/2013/06/11/getting-a-sharepoint-list-data-source-to-work-with-reporting-services-native-mode.aspx

   

• Painless management of a logging table in SQL Server

  https://www.simple-talk.com/sql/t-sql-programming/painless-management-of-a-logging-table-in-sql-server/

     

• A Practical Guide to Microsoft Hyper-V Replica: Part I

  https://www.simple-talk.com/sysadmin/virtualization/a-practical-guide-to-microsoft-hyper-v-replica-part-i/

   

• Nested CTEs

  http://stevestedman.com/2013/06/nested-ctes/

     

• Using an auto-execute Stored Procedure to resolve 'Recovery Pending' development database

  http://sql-sasquatch.blogspot.kr/2013/06/using-auto-execute-stored-procedure-to.html

     

• Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

  http://blogs.lessthandot.com/index.php/DataMgmt/business-intelligence-1/sharepoint-2013-bi-part-9

     

• Nested Loops and Parallelism

  http://www.dbnewsfeed.com/2013/06/11/nested-loops-and-parallelism

     

• Avoiding Parameter Sniffing in SQL Server

  http://www.sql-server-performance.com/2013/avoiding-parameter-sniffing-in-sql-server

     

• A Quick Tour of the Performance Dashboard Reports

  http://www.sqlservercentral.com/articles/Performance+Dashboard+Reports/98932/

     

• Spooling in SQL execution plans

  http://sqlblog.com/blogs/rob_farley/archive/2013/06/11/spooling-in-sql-execution-plans.aspx

     

Other

   

• Percona Live MySQL Conference and Expo 2013 참관기

  http://helloworld.naver.com/helloworld/textyle/396777

     

• Beyond Google I/O 2013 – It's Quality and Speed, Stupid!

  http://readme.skplanet.com/?p=5072