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.
Leave a Reply