2014.02.11

   

SQL

   

• SQL Server Diagnostic Information Queries for February 2014 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-february-2014

   

• Looking at read_microsec in sys.dm_os_buffer_descriptors in SQL Server 2012

  http://www.sqlskills.com/blogs/jonathan/looking-read_microsec-sys-dm_os_buffer_descriptors-sql-server-2012

   

• SQL Server: looking for disk errors and timeouts

  http://sql-sasquatch.blogspot.kr/2014/02/sql-server-looking-for-disk-errors-and.html

     

• Best Practices SQL Server Transaction Log

  http://sqldbpool.com/2014/02/10/best-practices-sql-server-transaction-log/

     

• One Preparation that makes SSMS Crash Dumps Easy to Survive

  http://aalamrangi.wordpress.com/2011/10/25/recover-queries-after-a-sql-server-management-studio-ssms-crash/

     

• Configure Kerberos for SQL with Virtual Accounts

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/configure-kerberos-for-sql-with-virtual-accounts.aspx

     

• SQL Server 2012 AlwaysOn Groups and FCIs Part 1

  http://www.sqlservercentral.com/articles/AlwaysOn/98619/

     

• Enabling Data Compression ? February 2014 Update

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/enabling-data-compression-february-2014-update.aspx

   

• Recover deleted SQL Server data and tables with the help of Transaction Log and LSNs

  http://www.mssqltips.com/sqlservertip/3160/recover-deleted-sql-server-data-and-tables-with-the-help-of-transaction-log-and-lsns/

     

• SQL SERVER ? Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group

  http://blog.sqlauthority.com/2014/02/10/sql-server-migration-of-sql-server-2012-database-mirroring-to-always-on-availability-group/

     

• SSRS ? Creating Drill Through reports with MDX

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/ssrs-creating-drill-through-reports-with-mdx.aspx

     

     

LINKS

   

• 구루의 기술뉴스 ? 오픈소스 수퍼 루키 10선 외 23건

  http://xguru.net/1880

     

Other

   

• Amazon Elastic Block Store (Amazon EBS) 소개

  http://sqlmvp.kr/140206463462

     

• Generating test data for MySQL tables

  http://www.mysqlperformanceblog.com/2014/02/10/generating-test-data-mysql-tables/