2013.02.19

안녕하세요. 주디아줌마입니다.

아 춥다 추워~~

   

Update

   

• SQL Server 2012 RTM Cumulative Update #6 is available!

  http://sqlblog.com/blogs/aaron_bertrand/archive/2013/02/18/sql-server-2012-rtm-cumulative-update-6-is-available.aspx

   

• KB article: http://support.microsoft.com/kb/2728897
• Build # is 11.0.2401
• This build has 22 fixes

   

SQL

   

• Implement SSAS MD cell security using dimension security with blazing performance

  http://sqlblog.com/blogs/jorg_klein/archive/2013/02/18/implement-ssas-md-cell-security-using-dimension-security-with-blazing-performance.aspx

     

• The Halloween Problem – Part 3

  http://www.sqlperformance.com/2013/02/sql-plan/halloween-problem-part-3

  MERGE 이슈들을 다루고 있네요.

     

• Getting Started with SSAS Multidimensional - Part 8: Aggregations, Partitions and Perspectives

  http://beyondrelational.com/modules/12/tutorials/799/tutorials/18127/getting-started-with-ssas-multidimensional-part-8-aggregations-partitions-and-perspectives.aspx

     

• Sometimes It's The Little Things That Get You

  http://shaunjstuart.com/archive/2013/02/sometimes-its-the-little-things/

     

• SQL Server 2012: Debugging Deadlocked Schedulers

  http://troubleshootingsql.com/2013/02/18/sql-server-2012-debugging-deadlocked-schedulers/

     

• List SQL Server DBCC commands using trace 2520 – documented and undocumented commands

  http://www.sqlserver-dba.com/2013/02/list-all-sql-server-dbcc-commands-using-trace-2520-documented-and-undocumented-commands.html

   

dbcc traceon(2520)

dbcc help ('?')

GO

   

• Merge statement with TOP clause - SQL Server                

  http://beyondrelational.com/modules/2/blogs/88/Posts/18979/merge-statement-with-top-clause-sql-server.aspx        

• Stored Procedures and SQL Injection

  http://www.sqlservercentral.com/articles/Security/96328/

     

• Troubleshooting and Fixing SQL Server Page Level Corruption        

  http://www.mssqltips.com/sqlservertip/2871/troubleshooting-and-fixing-sql-server-page-level-corruption

  오호~~ hex editor로 변경을 하고~ 룰루~~.

     

• Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

  http://www.mssqltips.com/sqlservertip/2883/using-the-sql-server-merge-statement-to-process-type-2-slowly-changing-dimensions/

     

• When will my SQL Server Evaluation Edition expire?

  http://sqlblog.com/blogs/sqlos_team/archive/2013/02/17/when-will-my-sql-server-evaluation-edition-expire.aspx

  오호 평가판 잔여일 뽑는 것도 있네~~

     

• Kerberos With an AlwaysOn Availability Group Listener

  http://sqlsalt.com/kerberos-with-an-alwayson-availability-group-listener/        

   

• Stored procedures and temporary tables - Scope, Modification and some fun

  http://beyondrelational.com/modules/2/blogs/77/Posts/18571/0222-sql-server-stored-procedures-and-temporary-tables-scope-modification-and-some-fun.aspx

     

     

기타

   

• Is MySQL 5.6 slower than MySQL 5.5 ?

  http://www.mysqlperformanceblog.com/2013/02/18/is-mysql-5-6-slower-than-mysql-5-5/        

     

• SHA1 + salt로 패스워드 보안 이슈 회피가 가능한가?

  http://www.mimul.com/pebble/default/2013/02/18/1361189648941.html

     

• The Cloudcast - Cloud-Enabling Memcached and Redis for NoSQL

  http://cloud.dzone.com/articles/cloudcast-cloud-enabling