2013.02.22

   

   

SQL

   

• FIVE VIRTUAL LABS FOR THE SQL SERVER 2012 DBA

  http://www.jasonstrate.com/2013/02/five-virtual-labs-for-the-sql-server-2012-dba/

     

• SQL Server 2008 Interview Questions & Answers – Part I

  http://sqldbpool.com/2010/02/20/sql-server-2008-interview-questions-answers/

  압축 관련 질답?

     

• Link List: Becoming a Data Professional

  http://sqlblog.com/blogs/buck_woody/archive/2013/02/21/link-list-becoming-a-data-professional.aspx

  괜찮은 링크가 많네요^^ 오호~~ 제가 관심 있어하는 자료들이에요~!

     

• Rolling Averages in SQL Server

  http://www.brentozar.com/archive/2013/02/rolling-averages-in-sql-server/

     

• SQL Server 2012 Integration Services - Introduction to PowerShell-based Management of SSIS

  http://www.databasejournal.com/features/mssql/ssis-2012-introduction-to-powershell-based-management-of-ssis.html

     

• Filtered Indexes - Simple Partitioning without Enterprise Edition?

  http://www.sqlservercentral.com/articles/Partitioning/96247/

     

• Resource Governor in SQL Server 2012

  http://technet.microsoft.com/en-us/library/jj573256.aspx

     

• How to Partition an existing SQL Server Table

  http://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/

     

• SQL SERVER – Shortcut to SELECT only 1 Row from Table

  http://blog.sqlauthority.com/2013/02/21/sql-server-shortcut-to-select-only-1-row-from-table/

     

• Halloween Protection – The Complete Series

  http://sqlblog.com/blogs/paul_white/archive/2013/02/21/halloween-protection-the-complete-series.aspx

     

ETC

   

• MySQL 5.5 and 5.6 default variable values differences

  http://www.mysqlperformanceblog.com/2013/02/21/mysql-5-5-and-5-6-default-variable-values-differences/

     

• Solving RPM installation conflicts

  http://www.mysqlperformanceblog.com/2013/02/21/solving-rpm-installation-conflicts/