NoSQL | R4

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.

Here are my chosen links for this week, covering SQL Server (with an emphasis on SQL Server 2014), web development, software development and big data.

SQL Server:
- Thomas LaRock’s SQL Server Troubleshooting useful links presents a set of useful resources to use when troubleshooting SQL Server performance issues. The set includes blog posts, books, videos and whitepapers.
- Microsoft’s SQL Server Team Boosting Transaction Performance in Windows Azure Virtual Machines with In-Memory OLTP presents recommended scenarios for the use on In-memory optimized tables in Azure Virtual Machines. It also offers recommendations regarding VM size and configuration, for optimized in-memory tables performance.
- Aaron Bertrand’s Hekaton with a twist: In-memory table-valued parameters raises the possibility of big improvements in performance when using memory-optimized table-valued parameters.
- Daniel Farina’s Updating statistics for Memory-Optimized tables in SQL Server addresses the lack of auto-updating statistics for memory optimized tables in SQL Server 2014. The article explains the reason for this absence and provides advice on how to handle situations where the data in the tables as changed in such a way that updating statistics would be recommended.
- John Daskalaskis’s SQL Server default settings that you might want to change presents several SQL Server defaults that may be useful to change, to achieve better performance.

Web Design and Development:
- Victor Savkin’s Contrasting Backbone and Angular is an interesting article that compares how regular web development tasks can be achieved with the Backbone,js and Angular JS Javascript frameworks.
- Steven Bradley’s Mobile Up, Widescreen Down, or Somewhere In-Between? compares the mobile up and widescreen down approaches, when designing a responsive website and provides advice on which to use considering the designer’s experience.
- Rob Dodson’s A Guide to Web Components addresses Web Components, a set of web standards with the goal of allowing the bundling of markup and styles into custom HTML elements, that fully encapsulate the HTML and CSS. An excellent read.
- Mike Wasson’s Single-Page Applications: Build Modern, Responsive Web Apps with ASP.NET shows how to build a Single Page Application (SPA) using Visual Studio 2013 and the ASP.NET Web API, while using Knockout.js and Ember.js for the front-end.

Software Development:
- Hadi Hariri’s Refactoring to Functional–Why Class? is a thought-provoking critique of object-oriented programming.
- Ulf Eriksson’s 6 Practical Agile Techniques You Can Start Using Today suggests 6 agile techniques that can be used to improve the any development process.
- Lukasz Szyrmer’s The Best Process Is No Process is another interesting and thought-provoking reflection, this time addressing process and process debt.
- Cecily Carver’s Things I Wish Someone Had Told Me When I Was Learning How to Code is yet another very interesting article on the lessons learned from experience, regarding “how to code”.

Big Data / BI :
- Craig S. Mullins’s A Primer on the Basics of NoSQL Databases provides a brief overview of the basics of NoSQL databases.
- Cindy Gross’s Your First HDInsight Cluster–Step by Step provides a simple tutorial on getting started with Hadoop, through a HDInsight cluster installation on Azure.
- Arshad Ali’s Understanding Microsoft Power BI – Self Service Solutions addresses Microsoft Power BI, a set of tools based on the ubiquitous Microsoft Excel, for data discovery, analysis and visualization. The article also includes links to relevant documentation on how to use the different Power BI components.
- Matt Asay’s Python Displacing R As The Programming Language For Data Science explains why Python has becoming a more common option for data science, increasingly replacing R.

That’s it for this week. Thanks for reading.

R4

Random Ramblings (on Technology, Programming and Databases,) by Rui Ribeiro

Tag Archives: NoSQL

My links of the week – February 9, 2014

My links of the week – December 1, 2013