2013.04.08

   

   

SQL

   

• SQLIOSim Checksum Validations

  http://blogs.msdn.com/b/psssql/archive/2013/04/05/sqliosim-checksum-validations.aspx

     

• Next version features

  http://sqlscope.wordpress.com/2013/04/07/next-version-features/

     

• The All-New 'Database Lifecycle Management" is available on MSDN

  http://sqlblog.com/blogs/kevin_kline/archive/2013/04/05/the-all-new-database-lifecycle-management-is-available-on-msdn.aspx

     

• sp_Blitz™ Version 18 Out: Lots of Bug Fixes

  http://www.brentozar.com/archive/2013/04/sp_blitz-version-18-out-lots-of-bug-fixes/

  굉장히 유용한 sp이죠^^

     

• AdventureWorks2012 now available for all on SQL Azure

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/03/27/adventureworks2012-now-available-to-all-on-sql-azure.aspx

     

• SQL SERVER – Pass One Stored Procedure's Result as Another Stored Procedure's Parameter

  http://blog.sqlauthority.com/2013/04/07/sql-server-pass-one-stored-procedures-result-as-another-stored-procedures-parameter/

   

• SQL Server - TempDB performance and strategy checklist

  http://www.sqlserver-dba.com/2011/04/tempdb-performance-and-strategy-checklist.html

  tempdb 정리해 두었네요^^

     

• FIX: SSIS Project Issues with SQL Server 2012 SP1 CU3 (Also applies to Maintenance Plans)

  http://sqlblog.com/blogs/greg_low/archive/2013/04/06/fix-ssis-project-issues-with-sql-server-2012-sp1-cu3-also-applies-to-maintenance-plans.aspx

     

• Free Webinar: Medical Data Integration with SSIS 2012!

  http://sqlblog.com/blogs/andy_leonard/archive/2013/04/05/free-webinar-medical-data-integration-with-ssis-2012.aspx

     

• Moving table or indexes on another filegroup - SQL Server

  http://beyondrelational.com/modules/2/blogs/88/Posts/19312/moving-table-or-indexes-on-another-filegroup-sql-server.aspx

     

• Data Execution Prevention

  http://www.sqlserver-dba.com/2013/04/data-execution-prevention.html

     

• Long-running job

  http://sqlmonitormetrics.red-gate.com/long-running-job/

     

• Generating Sequence Numbers Using the Sequence Object

  http://www.databasejournal.com/features/mssql/generating-sequence-numbers-using-the-sequence-object.html

     

• Rolling up multiple rows into a single row and column for SQL Server data

  http://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/

  신기하네요^^ 쥑이는 script에요.

     

기타

   

• Using Redis as a Secondary Index for MySQL

  http://code.flickr.net/2013/03/26/using-redis-as-a-secondary-index-for-mysql/

  오호^^