2014.04.28

   

SQL

   

• Video: SQL Server Performance Tuning with Wait Statistics (CXPACKET)

  http://www.connectsql.com/2014/04/video-sql-server-performance-tuning_27.html

     

• SQLAuthority News ? Microsoft Whitepaper ? Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

  http://blog.sqlauthority.com/2014/04/26/sqlauthority-news-microsoft-whitepaper-optimizing-your-query-plans-with-the-sql-server-2014-cardinality-estimator/

     

• Introduction to Extended Events (video)

  http://www.brentozar.com/archive/2014/04/introduction-extended-events/

     

• Whaddayaknow 'bout #SQLServer Trace Flag 4134?

  http://sql-sasquatch.blogspot.kr/2014/04/whaddayaknow-bout-sqlserver-trace-flag.html

     

• Excessive logging pre-SQL 2012 when changing variable length columns from NULL to NOT NULL

  http://sqlscope.wordpress.com/2014/04/26/excessive-logging-pre-sql-2012-when-changing-variable-length-columns-from-null-to-not-null/

     

• SQL Injection: How it Works and How to Thwart it

  https://www.simple-talk.com/sql/database-administration/sql-injection-how-it-works-and-how-to-thwart-it/

     

• How to Create a Database Master Key

  http://sqlity.net/en/2373/create-database-master-key/

     

• 10 reasons why I HAte you!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/25/10-reasons-why-i-hate-you.aspx

     

• Database Performance Investigation/Intervention, MTPoD, Last Resorts

  http://sql-sasquatch.blogspot.kr/2014/04/database-performance.html

     

• SQL Server Reporting Services Basics: Building SSRS Reports

  https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-building-ssrs-reports/

     

• MDX Cell Properties Supported By Excel

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/25/mdx-cell-properties-supported-by-excel.aspx

     

• What does PCI DSS mean for your SQL Server environment?

  http://www.mssqltips.com/sqlservertip/3216/what-does-pci-dss-mean-for-your-sql-server-environment/

     

LINKS

   

• Friday Followup For April 25, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/25/friday-followup-for-april-25-2014.aspx

     

     

Other

   

• The other side of Big Data. Interview with Michael L. Brodie.

  http://www.odbms.org/blog/2014/04/side-big-data-interview-michael-l-brodie/

     

• Managing farms of MySQL servers with MySQL Fabric

  http://www.mysqlperformanceblog.com/2014/04/25/managing-farms-of-mysql-servers-with-mysql-fabric/

     

• 왜 일이 예상대로 끝나지 않는가?

  http://www.mimul.com/pebble/default/2014/04/25/1398387387079.html