2013.01.17

   

SQL

   

• Storage Allocation and Management for Memory-Optimized Tables

  http://www.sqlserver.co.uk/index.php/storage-allocation-and-management-for-memory-optimized-tables/

   

• One Intel Processor Family to Avoid For SQL Server 2012/2014 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/one-intel-processor-family-to-avoid-for-sql-server-20122014

     

• Webcast Follow-Up: Necessary Evils, Building Optimized CRUD Procedures

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/16/webcast-follow-up-necessary-evils-building-optimized-crud-procedures.aspx

     

• #0319 - SQL Server - CTE and UNION

  http://beyondrelational.com/modules/2/blogs/77/Posts/19802/0319-sql-server-cte-and-union.aspx

     

• What would you do?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/16/what-would-you-do.aspx

     

• #0318 - SQL Server - Performance Tuning - Use Temp tables instead of table variables when working with large data sets

  http://beyondrelational.com/modules/2/blogs/77/Posts/19801/0318-sql-server-performance-tuning-use-temp-tables-instead-of-table-variables-when-working-with-larg.aspx

   

• VIRTUALIZING SQL SERVER: 8 THINGS TO AVOID

  http://thomaslarock.com/2014/01/virtualizing-sql-server-8-things-avoid-2

     

• Careful Adding Indexes with AlwaysOn Availability Groups

  http://www.brentozar.com/archive/2014/01/careful-adding-indexes-with-alwayson-availability-groups/

   

• Scaling-out SQL Server disks and data files on Windows Azure Virtual Machines…a real-world example

  http://blogs.msdn.com/b/sqlcat/archive/2014/01/16/scaling-out-sql-server-disks-and-data-files-on-windows-azure-virtual-machines-a-real-world-example.aspx

     

• Default Trace?Performance Issues

  http://troubleshootingsql.com/2014/01/16/default-traceperformance-issues/

     

• How write the a SQL Server agent Job status to the Windows Application log

  http://www.sqlserver-dba.com/2014/01/question-does-sql-server-allow-a-sql-server-agent-job-to-write-the-job-status-to-the-windows-application-log-answer-writ.html

   

• SQL Server 2014 Backup Basics

  https://www.simple-talk.com/sql/backup-and-recovery/sql-server-2014-backup-basics/

     

• Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

  http://www.sqlservercentral.com/articles/T-SQL/103343/

     

• Generating Test Data in TSQL

  https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/

     

• [SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!

  http://thesqlpro.com/2014/01/16/sqlsnacks/

     

• [SQL Snacks Video] Tail Log Backup and Recovery Demo

  http://thesqlpro.com/2014/01/16/sql-snacks-video-tail-log-backup-and-recovery-demo/

     

• Working with Spatial Data Part I ? Geocoding Text-Based Spatial Data for Use In SSIS Packages

  http://www.sql-server-performance.com/2014/spatial-data-geocoding/

     

Other

   

• Analyzing WordPress MySQL queries with Query Analytics

  http://www.mysqlperformanceblog.com/2014/01/16/analyzing-wordpress-mysql-queries-query-analytics/

     

• Sharding, Scaling, Data Storage Methodologies, and More: Insights on Big Data

  http://java.dzone.com/articles/sharding-scaling-data-storage