2013.08.23

   

Update

   

• SQL Server 2012 RTM CU9

  http://sqlserverperformance.wordpress.com/2013/08/22/sql-server-2012-rtm-cu9/

     

  KB article: http://support.microsoft.com/kb/2867319

  Build # is 11.0.2419

  This build has 7 fixes, including an interesting one involving LIKE        

   

SQL

   

• Five Myths About Big Data

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/22/five-myths-about-big-data.aspx

   

• Introduction to SQL Server Failover Clusters (video)

  http://www.brentozar.com/archive/2013/08/introduction-sql-server-failover-clusters-video/

   

• The Stages of Performance Tuning

  http://www.brentozar.com/archive/2013/08/the-stages-of-performance-tuning/

     

• Get Started with Windows Azure SQL Database

  http://www.scarydba.com/2013/08/22/get-started-with-windows-azure-sql-database/

     

• Six SQL Server management tools you can't live without

  http://searchsqlserver.techtarget.com/tip/Six-SQL-Server-management-tools-you-cant-live-without

     

• Techniques For Improving SQL Query Performance - Indexing, Parameterization and Partitioning

  http://www.mssqltips.com/sqlservertip/3026/techniques-for-improving-sql-query-performance--indexing-parameterization-and-partitioning/

   

• Some FileTable and FILESTREAM functions        

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/22/some-filetable-and-filestream-functions.aspx

     

• Service status watcher in SQL Server Management Studio ? How it works

  http://blogs.msdn.com/b/psssql/archive/2013/08/22/service-status-watcher-in-sql-server-management-studio-how-it-works.aspx

     

• View DTS packages with Powershell ? DTS to SSIS planning        

  http://www.sqlserver-dba.com/2013/08/view-dts-packages-with-powershell-dts-to-ssis-planning.html

     

• Power BI News Roundup

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/22/power-bi-news-roundup.aspx

     

• Getting started with Power View Reports with SharePoint, Excel and SQL Server

  http://www.sqlservercentral.com/redirect/articles/101266/

     

• Logging Data Flow Workload in SSIS 2012

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/21/logging-data-flow-workload-in-ssis-2012.aspx

     

Other

   

• Amazon RDS with MySQL 5.6: Configuration Variables

  http://cloud.dzone.com/articles/amazon-rds-mysql-56