Nov 10

My links of the week – November 10, 2013

download

Here are my personal choice of links for the week ending today.

  • SQL Server:
    • Courtenay Bernier’s Virtualizing SQL Server on Hyper-V and on Windows Azure VMs addresses Hyper V / Windows Server 2012 capabilities that need to be considered, when contemplating SQL Server virtualization. The article also addresses Azure as another possibility for SQL Server virtualization and covers some of the resulting limitations and advantages. Includes multiple links for additional relevant information. It’s an interesting resource to keep bookmarked.
    • Bruno Terkaly’s and Ricardo’s VillaLobo’s Migrating Database Workloads to the Cloud discusses several scenarios  for SQL Server migration to Azure including Windows Azure SQL Server databases or the use of an Azure VM.
    • Mary Hutson’s Top Support Solutions for Microsoft SQL Server provides a considerable number of links to Microsoft’s support solutions on the most frequent issues experienced with SQL Server.
    • Microsoft’s SQL Server Team’s IO Resource Governance in SQL Server 2014 addresses changes introduced to SQL Server’s Resource Governor in SQL Server 2014 and shows how the changes can be used to control resource usage in a SQL Server instance. This article was also added to my list of SQL Server 2014 links.
    • Jez Schultz Borland’s Document Your SQL Server Databases with Extended Properties shows how extended properties can be used to document multiple database objects, with examples of T-SQL to create, update and delete such properties. The comments to the article also provide useful information on other ways to use extended properties for the same or other purposes, especially if you use SSDT.
    • Simon Liew’s Different Ways to Restore a SQL Server Database provides examples of the multiple alternatives to restore a database using the full recovery model to a specific point in time, from the full, differential and transaction log backups available.
    • Thomas LaRock’s SQL Server Plan Cache: The Junk Drawer for Your Queries explains what the SQL Server plan cache is and presents a few queries that can be used to determine plans that are similar, used only once or plans that may need tuning. Such plans can provide performance improvement opportunities and can thus be part of the tools used by a DBA to keep a server optimized for the best possible performance.
    • Mark S. Rasmussen’s SQL Server Corruption Recovery – When All Else Fails presents some corruption recovery techniques, based on his own OrcaMDF, a C# MDF parser, available on GitHub. These techniques have the possibility to minimize data loss, if no other recovery strategies work or are unavailable.
  • Web Design and Development:
    • Julien Knebel’s An In-Depth Introduction To Ember.js is an excellent introduction to one of the most popular Javacript framework for front-end development, Ember.js. The goal of the article is to provide an easier start for developers beginning with Ember and it is very good at that.
    • Lauren Orsini’s What You Need To Know About Node.js gives a few  the reasons for Node.js’s increased popularity and provides a link to a good introductory tutorial.
    • Andy Leverenz’s The beginner’s guide to Sass provides an easy to read guide to Sass, explaining it’s advantages, providing examples of different possible syntaxes supported and presenting Sass’s features, like variables, operations and functions, nesting and mixins.
    • Dudley Storey’s Better Pop-Up Windows With JavaScript and CSS3, Part 1 is the first article in a series that addresses the design of popup windows combining the best of Javascript and CSS3. 
    • CJ Gammon’s Killer Responsive Layouts With CSS Regions presents Regions, a new part of the CSS specification that has been seeing increased support by more browsers. Regions features and advantages are explained and demoed, especially from a responsive design perspective. Links and suggestions for further reading are included, as well.
    • The Visual Studio 2013 Resources post, includes several updates to the Visual Studio 2013 links and videos.
  • Software Development:
    • Ivar Jacobson et al.’s Agile and SEMAT – Perfect Partners addresses how combining SEMAT (Software Engineering Method and Theory) with Agile, can help developers and teams improve their own software development practices. A very interesting article, from the creator of Use Cases.
    • Zain Naboulsi’s The Case For Agile Over Waterfall addresses the question of whether Agile still holds advantages over the classic waterfall approach to software development. The doubt was raised on the author from interactions with customers. The article presents links and data that back the idea that Agile is, of course, still advantageous, even if it seems there are many holdouts out there.
    • Josh Symonds’s What Makes a Good Programmer Good? addresses some of the qualities exhibited by good programmers and I cannot but agree with him.

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

Oct 07

Book review: jQuery Succinctly

jquery_succinctly_download

 

  1. Introduction
    For developers, there is a need to keep up to date with the latest technologies, in a rapidly changing landscape. While the internet does allow for easier access to information resources, the truth is that there is probably nothing like a good book to provide a structured approach to a given technology. With a book, readers can benefit from the author’s experience and knowledge right from the beginning, and can be given a guided tour that makes learning probably a lot easier than going through a series of website articles.

    Recently I became aware of a series of free books made available by Syncfusion. I am sucker for books, so I downloaded a few, relevant to some of the technologies I use, to check them. One of those books is the subject of this review – jQuery Succinctly. The book author is Cody Lindley, described in the book as having been a jQuery evangelist with the jQuery team.

    jQuery is one of the technologies that powers the Web, these days. In most websites with a great user experience, most certainly jQuery is used to provide such experience. So my goal on reviewing this book is to evaluate it as a useful resource for someone wanting to how to use it for website development.

  2. Book Structure

    The book is organized in 10 chapters, starting with Core jQuery and including chapters such as Selecting, Traversing, Manipulation, HTML Forms, Events, jQuery and the web browser, Plugins, Effects and Ajax. This seems a decent coverage of the subjects related to jQuery to allow any developer to use it effectively for website development. The presentation is supported by examples, that are usually well chosen and helpful. The code can be downloaded, making it easier to follow the examples as the reading proceeds.

     Chapter 1, Core jQuery, introduces the reader to the core concepts of jQuery – in the words of the author, “find something, do something”, that is then extended to “create something, select it and do something with it”. This chapter also deals with other relevant introductory aspects like dealing with the wait for the DOM to be parsed or waiting for the full window to load, jQuery chaining, jQuery methods that break the chain and how recovery from such destruction can be achieved using end(). It also introduces the this keyword, iterating over multiple selected elements using .each(), accessing selected elements by index using get() and creating DOM elements. The chapter provides a decent introduction to all these subjects, even if in a rather brief way. 

    Chapter 2, Selecting is devoted to DOM elements selection. It starts with a presentation of filters or, as some other authors name them, jQuery type extension selectors. The is() method, to determine if a given element is present in the selected set of elements and the length property, are presented. The chapter also shows how custom selectors (filters) can be created, when jQuery does not provide the selectors you may need. A decent presentation of selectors that explore relationships between elements follows, as well as selector stacking and nesting. I found the chapter quite interesting and it did cover some selection techniques I hadn’t found in other jQuery books I read before.

    Traversing is the 3rd book chapter, dedicated to DOM traversing. Strangely it starts with the filter() and find() methods, which probably would make more sense in the previous chapter. The coverage is succinctly good. The DOM traversing methods parent(), parents(), closest() are introduced and differences explained. Other traversing methods are also briefly addressed.

    Chapter 4, Manipulation, addresses the creation, operation and addition of HTML, using jQuery. HTML creation is exemplified as is the addition of such HTML to the DOM using appendTo(). The Index() method and why you’d use it is also presented. The use of text() and other methods such as replace(), contents() or remove() are exemplified.

    Chapter 5, HTML Forms, presents jQuery features to handle HTML forms. The attr() and removeAttr() methods to change or disable form elements, as well as the use of filter attributes such as :enabled and :disabled. Radio and checkbox selection and checking is exemplified, using val() and filter attributes such as :checked or :hidden. Use of val() to set the value of input elements and <textarea> is presented. Multiple examples are given of common tasks of elements edition, using methods such as prepend(), html() or replacewith(). Form elements selection by type is demonstrated through examples. Overall, the chapter is a good read but, similar to what I found regarding Ajax as a general subject, it is a shame that Ajax form submission is not covered.

    Chapter 6 deals with Events. Dealing with events is one of the most important features of jQuery and the chapter covers the subject nicely. It starts with an explanation about how there can be multiple ready() events declared. It then addresses the use of bind() and unbind() with multiple handlers. It also shows how event handlers can be invoked through short methods and addresses the event normalization performed by jQuery, showing how access to the normalized event can be achieved. Event namespacing advantages, and how namespacing can be achieved, are presented. Event delegation is introduced and its advantages are highlighted. The use of live() to bind event handlers that will be applied even to DOM elements created after the binding is perform is also shown and the methods specificities are explained. Preventing the browser from taking default behaviors or stopping event propagation, using stopPropagation or using return false, when opening a link or submitting a form is also addressed. The creation of custom events using bind and their invocation using trigger is also presented, as is cloning events using clone. I found this to be a very interesting chapter, addressing most situations a developer may need regarding event handling.

    Chapter 7, jQuery and the browser, is a bit of a weird one. It covers two small subjects only – disabling the right click button and scrolling the browser window. In its succinctness, it’s pretty similar to chapter 10 and I confess I fail to see the point of having a chapter with such small amount of content.

    Chapter 8 addresses Plugins. It starts with the recommendation to use the $ alias only within a private scope to avoid conflicts and the way to do that is demonstrated. The use of $.fn to make plugin methods chainable, just as jQuery native methods, is explained and exemplified. Default and custom plugin options are presented. Programmatic invocation of plugins is addressed. Although useful and addressing relevant contents related to the subject, a reference to utility functions could have been made, even if succinctly.

    Chapter 9 deals with Effects. This chapter starts in a bit of a weird manner. The first statement is that all jQuery animation effects can be disabled by setting the value of the off property to true. If you consider that the book may be read by someone who never used jQuery’s animation effects, this introduction may actually lack some context. The text proceeds in the same tone by stating that the stop() method should be used to stop an ongoing animation, before starting a new one. The rest of the chapter discusses the use of show(), hide() and toggle() without animation. Exemplifies sequential and non sequential animations, using animate(). Presents it as a base abstraction and offers detailed suggestions on how it can be used. The chapter also presents jQuery’s fading methods, fadeIn(), fadeout() and fadeTo()

    Chapter 10, Ajax, address jQuery Ajax related features. I found this chapter a bit disappointing. It basically presents the $.ajax() function as the low level abstraction by the shortcut methods load(), get(), getJSON(), getScript(), and post(), but without actually providing examples of their use. There is another additional paragraph stating that jQuery supports cross-domain JSONP and shows how browser XHR requests caching can be disabled – this is a piece of actually useful info, much to the contrary of the rest of the chapter.

  3. Conclusion

    The author states, in the book introduction, that the book was written to express the concepts essential to intermediate and advanced jQuery development, with each chapter containing concepts essential to becoming a jQuery developer. I confess I didn’t really look at it under this perspective. Although maybe a bit unfairly, I suspect, considering Syncfusion’s audience, that it will be used, at least in a relevant part, by developers fluent in Microsoft’s web technologies, to become familiar with jQuery, to use it in the development of websites. So, from a web developer’s point of view, I found the book rather useful, with some very good chapters (2, 5 and 6 are my favorites) and others not as good (especially 7 and 10). Even if some chapters could benefit from a bit better coverage of the underlying subjects or a better organization, the book can be a valuable resource. All the subjects are dealt with in a succinct manner, which is the purpose of the Syncfusion ebook series, anyway, which means it cannot probably be the single book to have on jQuery, but it does provide some valuable information and you can’t beat the cost. It is also a book that you can keep nearby, to be used as a reference. I will keep my copy within easy reach.