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. The Path is Null and Full of Squiggles

    I've been using Visual Studio 2017 since the earliest bits were available and I can confidently say, I'm a fan and highly recommend you give it a shot if you get a chance.With that being said, sometimes new features can cause things to blow up and this post is going to be discussing one of those such features, namely Lightweight Solution Load.Recently, I opened up a decently sized solution (~9 projects) and everything seemed in order. All of my dependencies were there, with no warning signs to be...
  4. Glyphfriend 2.1 Released! Now with Library Filtering

    It hasn't been too long since the latest 2.0 release of Glyphfriend, but with the release of Visual Studio 2017 coming around the corner, there were a few things that could use some improvement and polishing off before then.Message received, loud and clear.All of the changes that were made to make the extension more flexible actually resulted in it being more noisy. Glyphfriend would just serve everything it knew about. This has generally been regarded as a bad move, and thus library filtering is...
  5. Setup Eclipse CDT with cygwin

    Eclipse CDT is one of the powerful C++ IDEs in the world. However, it's not easy to configure it for a fresh new user. I found rare article to show the detail steps for setting up CDT with cygwin on the internet. So I decide to write down this tutorial for newbies.Purpose: This article intends to summary the steps to configure Eclipse CDT for the general C++ development.1. Project -> Properties -> C/C++ General -> Preprocessor Include, select CDT GCC Built-in Compiler Settings Cygwin, check...
  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. 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...
  8. 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...
  9. 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
  10. Why starting as a freelance software dev isn't always a good idea? Or is it?

    So you are young and energetic wannabe developer. Your head is full of ideas, stackoverflow is your bible and you are ready to face the struggles of software developement for money. Cool! Let me tell you something.You learn at the university or other school, you feel better in coding every month and the truth is you'd like to start with your career as soon as possible, but going to work everyday doesn't feel tempting for now, despite your lack of experience. But hey! You got some friends and friends...
  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. The Path is Null and Full of Squiggles

    Last updated: 2 years ago by Rion Williams
  4. Glyphfriend 2.1 Released! Now with Library Filtering

    Last updated: 2 years ago by Rion Williams
  5. Setup Eclipse CDT with cygwin

    Last updated: 2 years ago by Jingyu Ma
  6. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

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

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

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

    Last updated: 3 years ago by afsal
  10. Why starting as a freelance software dev isn't always a good idea? Or is it?

    Last updated: 3 years ago by Krzysztof Sikora

Publishing guidelines

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