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. Operation Not Legal in the Current State - Debugging ASP.NET Core Web Applications

    The other evening I was playing around with an ASP.NET Core application. When I started debugging it, I immediately saw an error message pop up that said It was a bit of a head scratcher, so I decided to restart the debug session and see if the problem resolved itself. This didn't help and I saw the same error again.I also saw that my Chrome browser had started up, but it wasn't showing my web page. It was stuck on a notification page telling me that JavaScript debugging is now enabled in Visual...
  3. Image File Execution Options: Good, Evil, Fun.

    A #tbt from like 11 years ago...I like the Image File Execution Options section of the registry. Many developers I've encountered aren't familiar with it, though. It's under-used, and that's a shame. (For some background on IFEO, check out http://blogs.msdn.com/junfeng/archive/2004/04/28/121871.aspx and http://blogs.msdn.com/greggm/archive/2005/02/21/377663.aspx.) So far, I've been able to use it for many things, including perhaps some things that it wasn't intended for. The most common value to...
  4. How to debug Django web apps using chrome developer tools and Django Debug Panel

    Django is a great framework for developing fast web applications with python, and it can certainly save you a ton of time if you are using python.  It's one of my favorite frameworks that is around right now, and I think they do best at describing why right on their website. "Django, the web framework for perfectionists with deadlines"It's the framework that I choose if I need something up and running, yesterday, but I still want it to be something I would not be embarrassed that I'm 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. 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...
  7. 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...
  8. 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
  9. 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!
  10. 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...
  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. Operation Not Legal in the Current State - Debugging ASP.NET Core Web Applications

    Last updated: 2 years ago by Dirk Strauss
  3. Image File Execution Options: Good, Evil, Fun.

    Last updated: 2 years ago by Erik Schroeder
  4. How to debug Django web apps using chrome developer tools and Django Debug Panel

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

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

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

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

    Last updated: 3 years ago by afsal
  9. How to remove HTML tag using SQL?

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

    Last updated: 3 years ago by Brenner Lira

Publishing guidelines

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