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. Securing your Exchange Online

    If your company its using Exchange Online services and you are responsible for email security, you have many options that you can implement to improve email security. By default every new Exchange Online tenant come with a defaults protections policy such as:Every default policy can be viewed, edited but not deleted. Its so recommended that you review all of this policies.As administrator, you can create additional malware or spam policies and applies it to specific users or groups.The malware filter...
  3. Issue converting AD user as Remote Mailbox in Exchange Hybrid environment.

    A few days ago, my friend Peter ask me about the process of convert an active directory user to remote mailbox in hybrid environment composed by Exchange Online and Exchange 2013 on premises. In some environment, your active directory has many users that not has a mailbox yet. But now, you need to create a mailbox for these users that response for both Exchange services. This process can be accomplish using enable-remotemailbox cmlet.When my friend Peter tried the conversion using the enable-remotemailbox...
  4. 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...
  5. Manage 365 Exchange Online with Powershell

    So, you implement Office 365 after transitioning from maybe an on-prem environment. You work with the Exchange Admin Panel which has a plethora of management capabilities but you miss using PowerShell to do stuff that simply is a lot easier to do in a shell prompt. Or maybe you've not used PowerShell before and and want to see what all the fuss is about.What I aim to give you is a little insight, a cheat sheet if you like, as to some common management scenarios you may use on a day to day basis that...
  6. 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...
  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. 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.
  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. Securing your Exchange Online

    Last updated: 2 years ago by Jose Beltre
  3. Issue converting AD user as Remote Mailbox in Exchange Hybrid environment.

    Last updated: 2 years ago by Jose Beltre
  4. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

    Last updated: 2 years ago by Dénes Martinidesz
  5. Manage 365 Exchange Online with Powershell

    Last updated: 2 years ago by Ryan Osman
  6. The Power of PowerShell.. And the Shell..

    Last updated: 3 years ago by Thomas Qvidahl
  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. Trying to demystify PowerShell conditional statements processing performance

    Last updated: 3 years ago by Ryen Tang

Publishing guidelines

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