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. 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...
  4. 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...
  5. 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...
  6. Trying to demystify PowerShell conditional statements processing performance

    Recently, I was drafting some PowerShell codes and stumbled across which conditional statement should I use for a very simple task and decided to explore abit more on their performance differences.Below is a sample code that I have coded to display the result of the overall performance between some of the conditional statements method and it is purely for educational coding purposes.If anyone is interested to find out, copy the codes below, paste it on PowerShell ISE and run it.
  7. 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!
  8. 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...
  9. Get all current Client Access Sessions per each CAS Exchange 2010 Server

    This script is based on Mike Pfeiffer'sIt shows how many users are currently connected to each CAS detailing each sessions per protocol (RPC, OWA and EAS)You can get the client load distribution per server, how many users are connected in each server and know when the mail client services are ready after a maintenance reboot.The following powershell script will grab performance counter data from each CAS server to determine the number of active EAS, OWA and RPC sessions:~~~powershell[PSObject[]]...
  10. You never believe how easily schedule VMs in Hyper-V

    In our company we has VDI infrastrucure with virtual machines pools working at Windows Server Hyper-V 2012 R2. Because we has many GPO, that fast changed, applied to workstation we need to reboot machines occasionally. But not used machines went to save state if not using about 10 minutes. So we decide write this script to "reboot machines" at night and create a task in windows scheduler. As we has 4 pools we create 4 scripts for pools VMs and 4 tasks, that run at night with interval...
  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: one year ago by Andrey Poturaev
  3. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

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

    Last updated: 2 years ago by Thomas Qvidahl
  5. Microsoft Business Intelligence approaches

    Last updated: 2 years ago by Besim Ismaili
  6. Trying to demystify PowerShell conditional statements processing performance

    Last updated: 2 years ago by Ryen Tang
  7. How to remove HTML tag using SQL?

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

    Last updated: 3 years ago by Brenner Lira
  9. Get all current Client Access Sessions per each CAS Exchange 2010 Server

    Last updated: 3 years ago by David Ramos Perez
  10. You never believe how easily schedule VMs in Hyper-V

    Last updated: 3 years ago by Andrei Pryymak

Publishing guidelines

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