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. The state of gender diversity in the tech industry: Gooroo facts and data

    The discussion on gender diversity in tech recently heats up with the viral memo on gender issues (titled "Google's Ideological Echo Chamber") by ex-Googler James Damore. Since then it has attracted several follow ups, including prominent ones by the New York Times or by The Washington Post. At Gooroo, it is pretty relevant to us as the tech industry is our main focus. We are specifically interested in knowing the facts behind the state of gender balance/diversity in tech companies...
  3. Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL

    Hi! I wrote these tips after many hours of some ERP system speed optimization. It was very helpful for me and my team. I hope it will be helpful for you too.So, lets go. Read UncommittedRead Committed + read_committed_snapshot off(alter database xxx set read_committed_snapshot off)Read Committed + read_committed_snapshot on(alter database xxx set read_committed_snapshot on)Repeatable ReadSerializableSnapshot(alter database xxx set allow_snapshot_isolation on)Tested on MSSQL 2014.
  4. The state of Machine Learning and AI industry: insights from Gooroo data

    As Machine Learning (ML), a specialization of Data Science / Artificial Intelligence (AI), moves from a hype to becoming mainstream, there are still a lot of unknowns around the role ML plays in businesses. What exactly do companies hire ML for? What are the skills they need? As this article puts it For instance, did you know the top hiring role in Data Science is no longer "Data Scientist". In fact, it’s relating to Machine Learning skills. As it is happening, at Gooroo.io, we are...
  5. How innovative analytics improve the chance of success in finding jobs on Gooroo.io

    For the data science team at Gooroo.io, a question commonly asked is, how can big data be utilized to improve recruitment, for both those hiring and job seekers? Like many big HR tech companies, we also use data to produce insights and trends on jobs and salaries (like Stackoverflow Trend Survey or SEEK's job trend). What's more, at Gooroo we are looking beyond general insights and into smart, innovative analytics that can help individual recruiters and applicants with their job...
  6. Microsoft Project Online & Power BI (Combining two powerful platforms)

    Microsoft Project Online is a flexible online solution for end-to-end project portfolio management (PPM) and everyday work. As the leader in the PPM market, Microsoft Project Online enables organizations to manage project demand, prioritization, and execution of projects and deliver intended business value. Power BI is a new exciting suite of business analytics tools to analyze data, share insights and provide a 360-degree view for your business users with their most important metrics in one place....
  7. Portfolio Resource Utilization in Project Online using Power BI custom Reports

    With the growing number of projects across multiple LOBs, the PMO needs an easy and intuitive way to gain a quick insight into the resource capacity across the entire project portfolio. Traditionally, resource capacity planning is a challenging task due to the lack of enterprise-wide resource pools and/or lack of planning, in general. One of the most crucial responsibilities of a project/resource managers is the planning & monitoring of resource workloads. In most organizations today, resources...
  8. 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...
  9. 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.
  10. 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...
  11. Edit DRAFT Edit

    • updated

Top Tags

Trending Articles

  1. Another interesting trick with APPLY operator

    Last updated: 2 years ago by Geovanny Hernandez
  2. The state of gender diversity in the tech industry: Gooroo facts and data

    Last updated: 2 years ago by Brad Nguyen
  3. Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL

    Last updated: 2 years ago by Andrey Poturaev
  4. The state of Machine Learning and AI industry: insights from Gooroo data

    Last updated: 2 years ago by Brad Nguyen
  5. How innovative analytics improve the chance of success in finding jobs on Gooroo.io

    Last updated: 2 years ago by Brad Nguyen
  6. Microsoft Project Online & Power BI (Combining two powerful platforms)

    Last updated: 3 years ago by Ross G
  7. Portfolio Resource Utilization in Project Online using Power BI custom Reports

    Last updated: 3 years ago by Ross G
  8. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

    Last updated: 3 years ago by Dénes Martinidesz
  9. An Introduction to R for Java Developers

    Last updated: 3 years ago by Dustin Schultz
  10. Microsoft Business Intelligence approaches

    Last updated: 3 years ago by Besim Ismaili

Publishing guidelines

Gooroo is a professional community interested only in consuming quality content. Here are our pretty simple guidelines for all contributors to follow.