Tag: wait statistics

My links of the week – February 9, 2014
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.
February 9, 2014
My links of the week – December 22, 2013
Here are the most interesting links I read or viewed during the past week.
- SQL Server:
  - Paul Randal’s SQLskills holiday gift to you: all 2012 Insider videos includes a link to all the 25 videos made available with the SQLskills Insiders newsletter during 2012. A great set of videos to watch during the upcoming holidays (or whenever you want to).
  - Brent Ozar’s How Would You Change Windows Azure SQL Database? asks the question – “what would Microsoft have to do to get you into Windows Azure SQL Database?” and there are some interesting answers. Although the cloud will gain a lot more importance in the coming years, I am not sure WASD is that interesting right now.
  - Kurt Survance’s The Tipping Point – Understanding how SQL Server’s query optimizer makes decisions is an older article, but a very good one explaining some of the reasons behind query optimizer’s choices on which indexes to use (or not).
  - Keeping with oldish articles, Phil Factor’s Temporary Tables in SQL Server is a very good article on temporary tables (and a contender in the 2013 Tribal Awards).
  - Aaron Bertrand’s Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers suggests the use of INSTEAD OF triggers as an alternative to AFTER triggers, when enforcing integrity rules, to avoid the need to rollback if the validation fails. By avoiding the need to log and rollback, INSTEAD OF triggers can offer performance improvements over AFTER triggers.
  - Patrick Keisler’s Collecting Historical Wait Statistics presents a script that allows for wait statistics persistence even with service restarts.
  - As it suits an end of year post, Jayleen Heft’s SQL Server Predictions for 2014 offers SQL Server predictions for 2014 from Brent Ozar, Denny Cherry, Tim Ford, Jen Underwood and Mark Kromer.
- Web Design and Development:
  - Matthew Beale’s Complex Architectures in Ember is a video presentation covering message passing in Ember.
  - Frederik Dohr’s Developing Modular JavaScript Components presents a strategy to evolve unstructured Javascript code to modular, reusable components.
  - Bipin Joshi’s 5 HTML5 Features Every Developer Should Know How to Use covers 5 features that are new in HTML5 and should be known by web developers: audio, video and canvas elements, new input types, some miscellaneous form features and custom data attributes.
  - Brock Allen’s CORS Support in ASP.NET Web API 2 presents some basic concepts on Cross Origin Resource Sharing (CORS) and explains ASP.NET Web API 2 support.
- Big Data / BI :
  - Lukas Eder’s Don’t jump the SQL ship just yet addresses some interesting subjects, including “scaling up” vs. “scaling out”, use of in memory databases, centralized vs. distributed architectures, data access from JAVA, dislike of ORM’s, RDBMS evolution and the ubiquity of SQL. A very interesting read.
  - Michael Hausenblas’s Open Source SQL-in-Hadoop Solutions: Where Are We? provides a status update of SQL support in available Hadoop solutions.
  - Rajesh Makhija’s Microsoft SQL Server: Faster Insights from Any Data presents a technical whitepaper on Microsoft’s BI related technologies.
- Software Development:
  - Allen Holub’s OO as a Prerequisite to Agile discusses the need to have a model based approach to be successful implementing Agile, the benefits of using such an approach and some of the pitfalls that may result otherwise.
  - Mark Levison’s A Tale of Two Daily Scrums reminds of the Daily Scrum’s goals and the need for it not being a simple checklist, but being about team collaboration. It includes links to several other interesting articles on the daily scrum.
- Random Interesting Stuff:
  - Scott Hanselman’s Scott Hanselman’s 2014 Ultimate Developer and Power Users Tool List for Windows is a great, extensive and comprehensive list of software tools for Windows developers and power users.
  - Phil Factor’s IT Aphorisms presents an interesting list of, well, IT aphorisms, that can be put to good use in multiple occasions.
That’s it for this week. Thanks for reading and Happy Holidays.
December 22, 2013

Tag: wait statistics

My links of the week – February 9, 2014

My links of the week – December 22, 2013