2013.02.06

SQL

• SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013) - Grenn

  http://sqlserverperformance.wordpress.com/2013/02/05/sql-server-2008-r2-diagnostic-information-queries-feb-2013/

   

• Partitioning Relational Data – (Part – 2)

  http://basitaalishan.com/2013/02/05/partitioning-relational-data-part-2/

     

• Partitioning in SQL Server - Part 3

  http://www.databasejournal.com/features/mssql/partitioning-in-sql-server-part-3.html

   

• Incorrect Results with Indexed Views

  http://sqlblog.com/blogs/paul_white/archive/2013/02/06/incorrect-results-with-indexed-views.aspx

   

• DBCC WRITEPAGE: an introduction

  http://www.sqlskills.com/blogs/paul/dbcc-writepage/
  와우^^ 괜찮은 명령어네.. 단.. 책임을 못지는 ㅎ.ㅎ
  

  1. To allow automated testing of DBCC CHECKDB and repair by the SQL Server team.
  2. To engineer corruptions for demos and testing.
  3. To allow for last-ditch disaster recovery by manually editing a live, corrupt database.

   

• Connettersi via SSMS a SQL Azure Databases

  http://blogs.dotnethell.it/suxstellino/Connettersi-via-SSMS-a-SQL-Azure-Databases__19038.aspx

   

• Windows Azure SQL Database and SQL Server -- Performance and Scalability Compared and Contrasted

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/05/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted.aspx

   

• How Does the Cloud Change a Systems Administrator's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/02/05/how-does-the-cloud-change-a-systems-administrator-s-job.aspx

   

• Modify sql transaction log file size - increase or decrease

  http://www.sqlserver-dba.com/2013/02/modify-sql-transaction-log-file-size-increase-or-decrease.html

     

• Sysprep improvements in SQL Server 2012 SP1 CU2

  http://sqlblog.com/blogs/greg_low/archive/2013/02/05/sysprep-improvements-in-sql-server-2012-sp1-cu2.aspx

     

• SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name

  http://blog.sqlauthority.com/2013/02/05/sql-server-fix-error-1505-the-create-unique-index-statement-terminated-because-a-duplicate-key-was-found-for-the-object-name-and-the-index-name/

     

• Important Trace Flags for DBA

  http://sqldbpool.com/2013/02/05/important-trace-flags-for-dba/

     

ETC        

   

• [입 개발] memcached 는 predictable 하고 Redis는 unpredictable 하다.

  http://charsyam.wordpress.com/2013/02/05/%EC%9E%85-%EA%B0%9C%EB%B0%9C-memcached-%EB%8A%94-predictable-%ED%95%98%EA%B3%A0-redis%EB%8A%94-unpredictable-%ED%95%98%EB%8B%A4/

     

• SQL Reporting Services Pricing Update

  http://www.dzone.com/articles/sql-reporting-services-pricing

     

• API와 서비스를 스마트하게 모니터링 하는 방법, Safari Tour 를 소개합니다.

  http://dev.kthcorp.com/2013/02/05/smart-api-monitoring-safari-tour/