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 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...
  3. Tech skill and Salary analysis - United States and Australia

    Tech job seekers, both active and passive, are willing to make a move for the right offer. But when is the right time to move? Since the technology sector is ever expanding and evolving, it is hard to know when the market is best placed for a strategic relocation into another role. According to the Bureau of Labor Statistics, the employment of tech and computer occupations is expected to grow 12% by 2024, greater than the average for all other occupations. Now more than ever it is important that...
  4. 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...
  5. 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...
  6. How to remove HTML tag using SQL?

    If you have your data with tags like < div>,< span> , < br> , etc. You can use the function below to remove this characters from your string. Blog.The function removes all content between the characteres < , > and also that characteres too.The HTMLString is the input for the function below, the column ClearString is the output for the function below.I hope that will help you.Cheers!
  7. MS SQL: Google Maps API

    This article will show how to calculate the distance beween two addresses using Google Maps API. Blog.I was looking to an easy way to calculate the distance between two addresses using SQL and Google Maps Distance Matrix API and I found this post from stackoverflow very useful.Here is how I use the Google Maps Distance Matrix API:CREATE PROCEDURE [dbo].[CalculateDistance] ( @ToAddress NVARCHAR(100) = '', @FromAddress NVARCHAR(100) = '', @DistanceistanceInKm FLOAT OUTPUT ) ASBEGINDECLARE @Object...
  8. Data localization in DB

    Once we faced with the problem of data localization in our DB. Data was distributed on several tables. And we neede to choose a method accoring to requirements:We chose between next ways:For every table storing localizable data we introduce new additional table with localizable fields. Like this:In table Entity there is a description of some object, including default localization (our requirement number 2). CultureId is default language for the object.Table EntityLocalized stores all localizable...
  9. USA and Australian tech professionals see reversal of fortunes in the first quarter of 2016

    Australian tech salaries have fallen slightly in the first quarter of 2016 from a year end high, while the declining average salary of tech professionals in the USA have risen after huge declines in 2015, according to tech marketplace Gooroo.After ending 2016 on a high with salaries averaging, $105,098AUD, Australian tech professionals have seen a decline of 2.3% over the past three months to average $102,661AUD. Conversely after ending 2015 at their lowest point, US tech salaries have risen from...
  10. Australian Tech Salaries Rise While US Counterparts See Downturn in 2015

    Australian tech professionals ended the year on a high after seeing a steady rise in salaries throughout the year ending with an average salary of $104,907 AUD, an increase of approximately $5000 AUD. The USA conversely saw declining salaries across all industry areas to year’s end, with average salaries dipping below $100,000 USD to $77,696 USD.The United Kingdom fluctuated throughout the year for particular skill sets, but overall recorded a steady salary average of £45,388.“It was an interesting...
  11. Edit DRAFT Edit

    • updated

Top Tags

Trending Articles

  1. Another interesting trick with APPLY operator

    Last updated: one year ago by Geovanny Hernandez
  2. The state of Machine Learning and AI industry: insights from Gooroo data

    Last updated: 2 years ago by Brad Nguyen
  3. Tech skill and Salary analysis - United States and Australia

    Last updated: 2 years ago by Carl Joseph
  4. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

    Last updated: 2 years ago by Dénes Martinidesz
  5. Microsoft Business Intelligence approaches

    Last updated: 3 years ago by Besim Ismaili
  6. How to remove HTML tag using SQL?

    Last updated: 3 years ago by Brenner Lira
  7. MS SQL: Google Maps API

    Last updated: 3 years ago by Brenner Lira
  8. Data localization in DB

    Last updated: 3 years ago by Sergey Rogatnev
  9. USA and Australian tech professionals see reversal of fortunes in the first quarter of 2016

    Last updated: 3 years ago by Carl Joseph
  10. Australian Tech Salaries Rise While US Counterparts See Downturn in 2015

    Last updated: 3 years ago by Carl Joseph

Publishing guidelines

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