GoorooTHINK

Thought provoking and helpful articles
from the Gooroo community.

Do you have something to say? Contribute or create an article and add it to your Gooroo bio.

  1. Another interesting trick with APPLY operator

    Some years ago, I was reading one book of Itzik Ben-Gan where he explained in depth the use of a new operator: APPLY, I told myself, it just another new feature more. I didn’t understand the relevance and the many versatile applications it had, through time, I have been using APPLY in many scenarios. Saving time and resources it is a fundamental part of each TSQL development, in this short article I would like to explain a simple trick with APPLY operator.The requirement can sound exotic but is...
  2. New Technology - Should You Learn It?

    It is one of those questions you constantly struggle with throughout any technical career: Should I learn this latest and greatest technology that is out? Do I need to learn it, do I want to learn it, do I get left behind if I don't? The truth is that you can't learn everything so how do you know what to focus on?The sections below are not mutually exclusive, nor do you have to fulfill all of them. If you can say "yes" to one of them, then you are probably okay to invest time in the technology in...
  3. Introduction to Progressive Web Apps

    As some people know, I have been very passionate about Windows Phone since the early days of the platform. I am still using a Windows 10 Mobile device, and I still love the operating system and the Windows 10 platform. However, I am not living in a cave, and I do realise that the future potential of the Windows mobile platform is limited. I still don't think it is "dead", but it is certainly limited. I started learning Xamarin a couple of years ago, to use my C# knowledge and skills for building...
  4. Spring Cloud and Netflix Ribbon: Client-side Load Balancing

    Eventually you'll reach a point where you need to run multiple instances of an application or a service for high availability or to manage increased load. That's what load balancers are for. There's generally two different types:What many people would call a "load balancer" is actually a server-side load balancer. It can be implemented in hardware or software. The traffic is sent to a dedicated service that decides where to send the traffic, using an algorithm like round-robin, to one of the...
  5. How to read and parse a CSV file using Node.JS

    I was recently asked by someone to give an example of how to read a csv file in their node.js application, and how to parse it to get it to be usable in their app. In fact what they wanted to do is very simple, and it is one of the many reasons I'm a big fan of Node.js, because not only can it do things like this in a few lines of JavaScript, it does it server side, and fast. So This article lays out step by step how to have node.js read and parse a CSV file stored in it's project, by using the CSV...
  6. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

    1. How much Disk Space is my Database currently using on Disk and what is the real Data Volume in the Database files?2. How close is the Data Volume to the Storage Limits?The following article will show you how to extract all relevant information using T-SQL for automation - step by step.If you simply need a quick and dirty solution without going through the details feel free to jump the code block labelled PUTTING IT ALL TOGETHER at the very end of this article.The first table we want to look...
  7. Karma Test Results with TFS Build

    Our team has been using JasmineJs for unit testing our client side JavaScript code. We now have over 3,000 tests! In order to run these tests on multiple browsers we use Karma, the "Spectacular Test Runner for JavaScript" created by people from Google to run all our tests on multiple browsers. We are also using Microsoft's TFS Build (which is leaps and bounds improved over the old XAML build system) to run our tests in Gated Check ins, create build artifacts (dlls, installers, Azure...
  8. An Introduction to R for Java Developers

    As a Software Engineer I'm always keeping up to date with technology and one of the things that helps me do that is book reviews. Right now, I'm reviewing The Book of R: A First Course in Programming and Statistics by Tilman M. Davies. R is a programming language used in statistical computing and has gained in popularity in the recent years due to the explosion of data and its applications like Machine Learning.
  9. Microsoft Business Intelligence approaches

    Time Intelligence is a common issue for every OLAP structure because Time as dimension apperars in every OLAP project, in every Cube you build, despite business model or type. To handle Time Intelligence good in calculations, aggregations and optimization, you need to use Timescale as well. With Timescale I mean: MonthToDate (MTD), YearToDate (YTD), LastYear(LY) etc..., all these very important to everyday use of Business Intelligence solutions.Now, I will take you to the technical steps of implemention...
  10. Must-Have PowerPoint App for Developers

    If you present to or collaborate with other developers, then there is one PowerPoint App that you must install ASAP: Code Presenter Pro.Developed by iGeek Studio for the Imagine Cup 2014 (the app won first place, by the way), this app turns PowerPoint, both the Presentation View and the standard Normal working view into an awesome code editor that supports customizable syntax highlighting for C#, Java, JavaScript, Python, PHP, ASP, JSP, Visual Basic, ASM, and C/C++. But the features do not end there....
  11. Edit DRAFT Edit

    • updated