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. 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.
  3. 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...
  4. 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...
  5. 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!
  6. 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...
  7. Log Shipping for SQL Server 2012 - Part 1

    • updated 3 years ago
    Log Shipping is a true and tried method of making databases available in case of a Disaster. From books online , SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances.Here we discussed advantages and disadvantages of logshippin as disaster recovery solution for SQL Server. I will write about how to create log shipping in my next post.
  8. The Vital Guide to Web Design Interviewing

    The goal of this guide is to help you find the perfect web designer for your team or project. This can be achieved by better understanding the different roles a web designer fills, and by having a good idea of the sort of strategic questions you can ask during the hiring process.Hiring web designers can be difficult. There are many disciplines under the common term ‘designer,’ and experts in one field may be novices in another, while others are a “Jack of all trades, master of none.” To make things...
  9. Programming languages - salaries and demand (March 2015)

    We've released a few of these reports before, and here is the first for 2015. With our database now analysing ~500,000 tech jobs every single month, we have a unique dataset which can tell us what skills organisations are hiring for and what salaries they're advertising.This year we have seen quite a lot of change in the popularity of various programming languages. Whether this is a feature of different industry's hiring cycles is still to be determined.Battling for 1st position are Java and C# with...
  10. Press Release: The average tech salary in Australia fell by 6% between January and March 2015

    Tech career marketplace, Gooroo, has released it’s tech career and salary trends for Q1 2015.These trends have indicated that 2015 so far has not followed the rising salaries seen towards the end of 2014. The average tech salary in Australia has indeed fallen by 6% between January and March 2015. This varies by technology and industry, although the general trend is represented in most areas examined.The downturn is most noticeable in advertised salaries for Mobile Developers and jobs asking for skills...
  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. Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL

    Last updated: 2 years ago by Andrey Poturaev
  3. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

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

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

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

    Last updated: 3 years ago by Brenner Lira
  7. Log Shipping for SQL Server 2012 - Part 1

    Last updated: 3 years ago by AL
  8. The Vital Guide to Web Design Interviewing

    Last updated: 3 years ago by Irina Papuc
  9. Programming languages - salaries and demand (March 2015)

    Last updated: 4 years ago by Carl Joseph
  10. Press Release: The average tech salary in Australia fell by 6% between January and March 2015

    Last updated: 4 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.