2013.01.29

   

Update

   

• KB Article For CU2 of SQL Server 2012 SP1

  CU#2 KB Article: http://support.microsoft.com/kb/2790947

  추가된 기능 2가지 http://blogs.technet.com/b/stbnewsbytes/archive/2013/01/24/january-24-2013-news-thursday-microsoft-virtualization-jump-start-and-more-server-and-tools-news.aspx

     

• KB Article For CU9 of SQL Server 2008 SP3

  CU#9 KB Article: http://support.microsoft.com/kb/2799883 

     

SQL

   

• Using constraints to enforce uniqueness of ordered sets of rows

  http://sqlblog.com/blogs/alexander_kuznetsov/archive/2013/01/28/using-constraints-to-enforce-uniqueness-of-ordered-sets-of-rows.aspx

     

• SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?

  http://mssqlfun.com/2013/01/21/sql-server-reserve-1-user-connection-for-dac-dedicated-administrator-connection-want-to-confirm/

   

• SQL Server Table Partitioning Tutorial: Videos and Scripts

  http://www.brentozar.com/archive/2013/01/sql-server-table-partitioning-tutorial-videos-and-scripts/

     

• SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell

  http://www.databasejournal.com/features/mssql/ssis-2012-introduction-to-managing-sql-server-with-powershell.html

     

• Update statistics in parallel

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/95820/

     

• SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query

  http://blog.sqlauthority.com/2013/01/28/sql-server-basic-explanation-of-set-lock_timeout-how-to-not-wait-on-locked-query/

     

• Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC

  http://www.sqlsoldier.com/wp/sqlserver/day22of31daysofdisasterrecoverywhichdbcccheckcommandsupdatelastknowngooddbcc

     

• Do you need sysadmin rights to backup a database?

  http://spaghettidba.com/2013/01/09/do-you-need-sysadmin-rights-to-backup-a-database/