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. How to create and assign roles in asp.net mvc 5

    Hello,I am writing this article to show you how to create and assign user role. Create a new asp.net web application project with MVC template along with individual authentication. You have noticed that  AspNetRoles, AspNetUsers etc tables are already  available in our project . So, we can make use of these  tables to fulfill our need . Find and open the Startup.cs file from the solution explorer .You can add  here function to create...
  3. 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.
  4. Configure SQL Database on premises with DB files on Azure.

    RequirementsBenefitsSteps
  5. Database migrations with Continuous Delivery in Entity Framework

    Who doesn't enjoy the big term, DevOps? It sounds promising and sounds interesting as well when someone says, they work as a DevOps engineer! But like they say, Similarly, in the case of DevOps, every process, which DevOps exposes has to be handled with a great care or the results are catastrophic. In this post, I am going to talk about the swissknife of continuous delivery, in the terms of database migrations and maintenance. It has been quite a while, since I have joined DevOps practices and...
  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. 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!
  9. 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...
  10. LDAP Connectivity

    I've been working a lot around an error in Active Directory LigthWeigth Directory Services, we provide services as consultant and one of our biggest clients asked us about LDS, the thing is that the client has an error 49, where them get troubles getting in from a web page. after they had worked a couple of years with the platform, this error started.After seeing the solutions components i've found that the instance service needed a domain account, and this account was removed obviously by error.
  11. Edit DRAFT Edit

    • updated