Insights

Holographic Brain ImageHolographic Brain Image

blog

  • Blog

    PowerShell Basics – Filtering and Selecting

    The next topic in the PowerShell Basics series is focused on filtering and selecting PowerShell objects using the Where-Object and Select-Object commands.  Using these commands allows you to precisely define what items are displayed or acted on. Review of PowerShell Objects and the Pipeline To learn how to use the Where-Object and Select-Object commands, it’s important to…

    Concurrency
  • Blog

    Living the Corporate Life

    During my internship here at Concurrency there have been many learning moments that have contributed to my personal growth.  One of the most important skills I learned was how to work in a corporate setting.  This experience has taught me the importance of those unspoken rules, dressing for a professional job, and building rapport or…

    Concurrency
  • Blog

    ServiceNow Shortcuts – Editor Macros

    Editor Macros, found at “System Definition -> Syntax Editor Macros”, are code shortcuts that you can create in ServiceNow to automatically create code-blocks while in a script edito. For example, you can simply type vargr and hit the Tab key. This will create the code block for obtaining a GlideRecord. There are a handful of useful macros that are…

    Concurrency, Inc.
  • Blog

    ServiceNow – Centralized Project Management with Project Workspace

    ServiceNow – Project Portfolio Management Series Today in the second post of our Project Portfolio Management Series, I would like to discuss the ServiceNow Project Workspace.  If you have not yet had a chance to read my initial post on Demand Management, make sure to give it a read here. It will help you in understanding…

    Concurrency, Inc.
  • Blog

    Power BI vs SSRS

    Two common enterprise reporting & BI tools in use today are Microsoft Power BI and Microsoft SSRS (SQL Server Reporting Services). While both services are a part of the Microsoft Business Intelligence package, each system is intended to be used in a different manner. Power BI is a graphical modern reporting tool that has been…

    Concurrency
  • Blog

    SSIS Integration with Dynamics CRM

    SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading.  Pre-requisites:   Download the above software in order as they…

    Ajay Ravi
  • Blog

    Basics of Powershell Excel & JSON Parsing

    The Powershell scripting language is designed to help system administrators automate tasks and manage OSs: Windows is naturally supported, but so is Linux and Mac with the newest versions. It allows you to access data stored across the file system, including Excel and JSON files. Thanks to the integration on the Microsoft side, we do not need to download…

    Concurrency
  • Blog

    Conditionals and “For” in Terraform

    Those who came from a programming background will find infrastructure as code solutions and other configuration languages to be pretty syntactically different from traditional imperative programming languages. Naturally, this is due to the different application of these languages- we would not want to accidentally get stuck in an infinite loop while deploying virtual machines. Nonetheless, there…

    Concurrency
  • Blog

    Cumulative Sum by Period to Period Change in Power BI

    To first understand period to period change, you want to start by creating an expression in DAX (a library of functions and operators that can build formulas and expressions in Power BI Desktop) that calculates the sum of sales. You can do this by writing a measure like the following: Sum = SUM(‘Internet Sales'[Sales Amount]) Next you…

    Concurrency