Dec 08

My links of the week – December 8, 2013


Here is choice of links for this week.

  • SQL Server:
    • Phil Factor’s Primary Key Primer for SQL Server is an excellent primer on choosing primary keys for SQL Server databases. It also includes links to several related and relevant resources.
    • Brent Ozar’s The Secrets of TempDB is a very interesting video on TempDB, one of SQL Server’s system databases. The video covers multiple aspects related to TempDB, presenting its purpose, how SQL Server uses it, how it should be setup and how it can affect SQL Server performance. The post also includes a link to multiple valuable TempDB related resources.
    • Jez Schultz Borland’s Filtered Indexes vs. Table Partitioning explains some of differences between filtered indexes and table partitioning and suggests use cases for both. It also includes links to additional resources on both subjects.
    • Thomas LaRock’s Doing it Right: Performance Monitoring and Troubleshooting compares tracing and polling as strategies for collection performance metrics in terms of advantages, disadvantages and risks and advises a strategy that includes both, while stating his preference for polling for regular monitoring.
    • Brent Ozar’s How to Build a SQL Server Support Matrix presents his version of a SQL Server support matrix and, in a very interesting post, explains how it can be used and some of the advantages that it can bring about.
    • Glenn Berry’s General Database Server Build and Deployment Instructions provides a useful build checklist for setting up new SQL Server instances.
    • Jack Li’s How Simple Parameterization works addresses query parameterization, explaining how SQL Server versions since 2005 includes two modes of parameterization (simple and forced), how SQL Server behaves in each and how it can be determined whether a given query is being parameterized or not.
    • Karen Lopez’s 10 Tips for the Minimalist DBA presents a set of 10 tips about concerns and skills needed for anyone in a DBA role.
    • Bill Karwin’s How to Design Indexes, Really, is a very good presentation on index design that, although addressing MySQL indexes, can also be of valued for anyone designing indexes for  other database management systems.

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

Dec 01

My links of the week – December 1, 2013


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.

  • 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. 

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