2014.02.28

   

SQL

   

• The ACID Properties of Statements & Transactions - Paul White

  http://www.sqlperformance.com/2014/02/t-sql-queries/confusion-caused-by-trusting-acid

   

• What is the most worrying wait type?

  http://www.sqlskills.com/blogs/paul/worrying-wait-type/

   

• How to Use Partitioning to Make kCura Relativity Faster

  http://www.brentozar.com/archive/2014/02/partitioning-kcura-relativity-audithistory-table/

     

• Issue with sys.dm_db_index_usage_stats in SQL Server 2012

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/27/issue-with-sys-dm-db-index-usage-stats-in-sql-server-2012.aspx

     

• DBAs Checklist for Designing and Reviewing SQL Server System Architectures

  http://www.mssqltips.com/sqlservertip/3166/dbas-checklist-for-designing-and-reviewing-sql-server-system-architectures/

     

• Identify the Backup used to Restore the Database

  http://www.sqlservercentral.com/articles/Backup+Restore/106622/

     

• Virtual Lab ? Setting up a new VM

  http://voiceofthedba.wordpress.com/2014/02/27/virtual-lab-setting-up-a-new-vm/

     

• PowerShell ? SSRS Inventory ? Automatic ? Excel File ? EMAIL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/27/powershell-ssrs-inventory-automatic-excel-file-email.aspx

     

     

Other

   

• Gaming on AWS요약

  http://wapj.postach.io/gaming-on-awsyoyag

     

• DBA 101: Sometimes forgotten functionality in the MySQL client

  http://www.mysqlperformanceblog.com/2014/02/27/dba-101-sometimes-forgotten-functionality-mysql-client/

     

• Where Are All the DBAs in NoSQL?

  http://java.dzone.com/articles/where-are-all-dbas-nosql