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. Getting Started with Windows Template Studio

    Developers are always looking for shortcuts to make their programming more efficient and let them focus on the fun bits. Deep down inside developers are lazy people that don't want to do boring work. Repetitive work. About a year ago I finished a Pluralsight course on building your first Universal Windows App, which aimed to give developers a great shortcut for building apps for Windows 10. It took me three goes to finish the course (Microsoft kept moving the goal posts), but I was happy with the...
  4. Contributing to .NET for Dummies

    Over the past few months in the little spare time that I have, I’ve managed to submit a handful of pull requests to various .NET-related repositories (e.g. coreclr, corefx, docs, etc.) and incredibly, they were accepted.Now, for some, this may not seem like a big deal. But it felt like a pretty big one to me so I thought I would take some time to elaborate on the process itself, share my experience, and hopefully dispel a few myths or misconceptions that you might have that may be holding you back...
  5. 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...
  6. Continuous Deployment from GitHub to Azure

    Continuous Deployment from GitHub, the web based Git source repository service to Azure, the cloud offering from Microsoft, resolves many bottlenecks related to manual application deployment. Most of the open source developers use GitHub as a public or private repository to track code changes and as a collaboration tool. Integrating or deploying applications directly from GitHub to Azure reduce the time taken for manual deployment of applications. Let us quickly see how we can deploy a small...
  7. 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...
  8. The Power of PowerShell.. And the Shell..

    "What is the one technology I need to learn to get a job like the one you have?" - this is a question I've received from time to time, and my answer would vary, depending on who asked. Or rather; who I perceive the questioner to be - I cannot *know* for a fact what most suits his or her particular ambitions and style.. But in the last few years my answer, more often than not, has been "PowerShell"! Simply because I see it as one of the most important and game-changing technologies to come out of...
  9. 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...
  10. 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...
  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. Getting Started with Windows Template Studio

    Last updated: 2 years ago by Lars Klint
  4. Contributing to .NET for Dummies

    Last updated: 2 years ago by Rion Williams
  5. Tech skill and Salary analysis - United States and Australia

    Last updated: 2 years ago by Carl Joseph
  6. Continuous Deployment from GitHub to Azure

    Last updated: 3 years ago by Ambily KK
  7. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

    Last updated: 2 years ago by Dénes Martinidesz
  8. The Power of PowerShell.. And the Shell..

    Last updated: 3 years ago by Thomas Qvidahl
  9. Microsoft Business Intelligence approaches

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

    Last updated: 3 years ago by Velimir Kojic

Publishing guidelines

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