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. Lessons Learned Writing Spring Boot Auto Configurations

    My team and I make heavy use of Spring Boot to build microservices that power our applications at our company. We've even gone so far as to write our own custom auto configurations to ease development. We package these auto configurations along with other goodies into what we call our platform.Recently, after releasing a new platform version, we encountered an issue where one of our microservices would fail to start at what appeared to be random intervals. After further digging, we noticed specifically...
  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. 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...
  6. 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.
  7. Spring Boot 1.4: @MockBean and @SpyBean

    It's August 2016 and the Spring Boot team recently released Spring Boot 1.4 ( on July 28th, 2016 ). Some of the biggest improvements and simplifications are around unit and integration testing. We'll take a focused look at two of the newly added features: @MockBean and @SpyBeanThe newly introduced annotation, (@MockBean), adds generalized support for mocking of any Spring bean. If you've used Mockito Annotations before, @MockBean is simliar to @Mock but with Spring support.Suppose we have a simple...
  8. 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...
  9. Configure RoundCube on Debian 8 (Jessie) - Perfect Server Debian 8 (Apache, BIND, Dovecot, ISPConfig 3)

    Debian 8 (Jessie) doesn't contain RoundCube in it's repositories. Why, I don't know :) . In ISPConfig3, Perfect Server, Debian 8, you get SquirrelMail, but I don't like how it looks. With some trouble setting it up, I managed to configure RoundCube on Debian 8 and make it wokring with ISPConfig3. Used many sources to make it work and decided to create this manual that you’re reading.I presume that you have configured your server with Perfect Server Debian 8 (Apache, BIND, Dovecot, ISPConfig 3) configuraton...
  10. Initiating the Git

    How to initiate git through sshlogin using shh~~~git $ ssh [email protected] ~~~creating a folder ~~~git $ mkdir folder_name ~~~changing to that newly created folder~~~git $ cd folder_name ~~~initiating as a master branch~~~git $ git init --bare ~~~changing the windows pack~~~git $ git config pack.window 0 ~~~##step 5 : clone to local machine usingcloning the newly created folder to local~~~git $ git clone [email protected]:/home/folder_name ~~~adding the all files which are created
  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. Lessons Learned Writing Spring Boot Auto Configurations

    Last updated: 2 years ago by Dustin Schultz
  4. Spring Cloud and Netflix Ribbon: Client-side Load Balancing

    Last updated: 2 years ago by Dustin Schultz
  5. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

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

    Last updated: 2 years ago by Dustin Schultz
  7. Spring Boot 1.4: @MockBean and @SpyBean

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

    Last updated: 3 years ago by Besim Ismaili
  9. Configure RoundCube on Debian 8 (Jessie) - Perfect Server Debian 8 (Apache, BIND, Dovecot, ISPConfig 3)

    Last updated: 2 years ago by Velimir Kojic
  10. Initiating the Git

    Last updated: 3 years ago by afsal

Publishing guidelines

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