Here is my choice of links for the past week.

• SQL Server:
  • Paul Randal’s Avoiding Knee-Jerk Performance Troubleshooting warns against superficial analysis of performance problems and offers examples of situations where that can happen, related to wait statistics.
  • Kendra Little’s Statistics Matter on Temp Tables, Too shows that statistics are relevant in temp tables too and suggests a way to change the threshold for statistics to update automatically.
  • Alex Grinberg’s Sending a Variable Number of Elements in a Parameter presents three ways to send multiple rows of values, as parameters to stored procedures.
  • Jeremiah Peschka’s Using SQL Server’s Table Valued Parameters goes a bit deeper with tabled value parameters than the previous article from Alex Grinberg, showing how they can be used from C# and addressing some of the gotchas of using them.
  • Joe Celko’s SQL Server SEQUENCE Basics explains how Sequences can be used in SQL Server 2012. It also provides a historical justification for the use of IDENTITY columns and explains why they shouldn’t be used for primary keys, while sequences should.
  • Tibor Nagy’s SQL Server Security Checklist provides advice on the security configuration of a SQL Server production server.
  • Sanjay Mishra’s AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments explains the differences in deploying AlwayOn Availability Groups between on-premises and Azure VMs.
  • Francesco Diaz’s Configuring SQL Server Database Mirroring across two Windows Azure datacenters shows how database mirroring accross Windows Azure datacenters can be setup.

• Web Design and Development:
  • Jeremy Likness’s 10 Reasons Web Developers Should Learn Angular offers 10 reasons for web developers to adopt Angular.JS, from  data-binding, to dependency injection, filtering of output, and advanced templating.
  • Lara Swanson’s Responsive Web Design Performance argues for a mobile (and performance) design first approach and offers good reasons for that.
  • Scott Hanselman’s Checklist: What NOT to do in ASP.NET offers advice on anti-patterns to avoid in ASP.NET development, with an interesting set of links to further reading (and viewing) on the subject.
  • Gavyn McKenzie’s One Solution To Responsive Images presents an interesting solution for the responsive images problem.
  • Jimmy Bogard’s Rendering ASP.NET content as PDF shows a quick way of obtaining a PDF printout, from ASP.NET MVC pages, but the approach can be extended to other scenarios.

• Big Data:
  • James Kinley’s The Lambda architecture: principles for architecting realtime Big Data systems presents the principles of the Lambda architecture, proposed by Nathan Marz and James Warren in their Big Data book.
  • Soren Riise’s NoSQL Vs. RDBMS for Interactive Analytics: Leveraging the Right and Left Brain of Data provides some interesting advice on NoSQL vs. RDBMS choices.
  • Alex Giamas’s Interactive SQL in Apache Hadoop with Impala and Hive compares some aspects of current interactive SQL choices for Hadoop installations.

• Software development:
  • Yaniv Yehuda’s The Secrets of Database Change Deployment Automation presents the difficulties associated with database change deployment and argues for a better solution to the problem of database change deployment than the traditional versioning or compare and sync tools.
  • Scott Ambler’s Architecture and Design Are So Important is a presentation on the importance of architecture and design and how they are integrated in a daily agile approach.

That’s it for this week. Thank you for reading.