Azure SQL VM | R4

Here is my selection of the links from the past week.

SQL Server:
- Last week was T-SQL Tuesday week, Waits being this month’s subject. Robert L. Davis was the host, and several interesting posts are included in his roundup: T-SQL Tuesday #49: Wait For It Roundup.
- Basit Farooq’s Understanding SQL Server Query Optimization – Part 3 is the third of a series of four articles on query optimization. The previous 2 articles can be found here and here.
- Jeremiah Peschka’s Keep it Constrained addresses unique, primary key and check constraints in SQL Server, including a smart way to deal with NULLs in unique constraints.
- John Sterrett’s Throwback Thursday #3: SQL Server & Disks presents several very interesting articles on disks,storage systems and SQL Server.
- Tracy McKibben’s Don’t Get Slimed By Bad Parameter Sniffing addresses parameter sniffing, explaining what it is, how it can create performance problems what can be done to overcome such problems.
- Kenneth Fisher’s A better way to find missing indexes presents an interesting script to find missing indexes and present them alongside the queries where their absence can make a difference.
- Jonathan Allen’s I Thought Everyone Did It Like That – SSMS Templates is an interesting article that covers SQL Server Management Studio Templates, showing how they can be useful, how they can be customized through the use of parameters, and how new templates can be added.
- Microsoft’s SQL Server Team SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines presents one of the new wizards in SQL Server 2014 SSMS,that assists in the deployment of a database to a Windows Azure VM and gives a step by step description of the deployment process, using the wizard.

Web Design and Development:
- Sara Souiedan’s Creating Non-Rectangular Layouts with CSS Shapes is a very detailed and interesting article on CSS Shapes, a current W3C Draft meant to allow inline content to wrap around floats of shape other than the regular floats’ bounding box.
- Sorin Pintilie’s The Line Of Least Resistance is an excellent article that addresses the importance of context in designing an enjoyable experiences for users.
- John Tabita’s How to Keep Web Projects Moving Forward, Part 1 and How to Keep Web Projects Moving Forward, Part 2 addresses common difficulties in web projects and provides advice on how to overcome those difficulties.
- Andi Smith’s Make better websites with browser developer tools provides a set of interesting tips and tricks to help developing better websites, using a varied assortment of tools.
- David Paquette’s Browser Link–Tracking Unused CSS shows how Browser Link, a new feature of Visual Studio 2013, can be used to identify unused CSS in a website.

Software Development:
- Monjurul Habib’s Agile software development methodologies and how to apply them provides an introduction and overview of development methodologies based on Agile.
- Damien Guard’s Probable C# 6.0 features illustrated presents some of the probable new features for the 6.0 version of C#.

Big Data / BI :
- Doug Turnbull’s Codd’s Relational Vision – Has NoSQL Come Full Circle? is a very interesting article that goes back to the original Codd’s work on relational databases, analyzing Codd’s criticism of the database systems that existed at the time, to raise the question of whether we have come full circle. Codd’s original arguments that lead to his proposal ofthe relational database model, are used to warn about the risks of denormalization, while taking advantage of that very denormalization in NoSQL databases.
- Software Engineering Radio’s Episode 199 is a podcast, featuring Michael Stonebraker, a leading MIT database reasearcher. The podcast covers multiple database related subjects of great interest, including “NewSQL” databases.
- Andrew Burst’s Predicting Big Data’s 2014 presents a few predictions about what 2014 can bring to Big Data, from a set of companies working in the field.

That’s it for this week. Thanks 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: Azure SQL VM

My links of the week – December 15, 2013

My links of the week – December 1, 2013