Insights

Holographic Brain ImageHolographic Brain Image

blog

  • 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
  • Blog

    Polymorphic Associations Using EF Core

    For this example, I will be modeling a website that has pictures, videos, and blogs that can all contain comments. There will also be certain pages/posts that cannot contain comments, and these pages inherit from a shared interface as the pictures, videos, and blogs. We want to use one table, “comments,” to store comments for…

    Concurrency
  • Blog

    How to Create a Custom SharePoint Theme

    How to Create a Custom SharePoint Theme Microsoft offers a great tool that allows you to create your own SharePoint themes through Office Fabric UI. It allows you to plug in three colors (primary color, text color, and background color) and will then generate a SharePoint theme that can be pushed to your SharePoint site…

    Concurrency
  • Blog

    Introduction to NGX-Formly for Automatic Form Generation

    Power of Form Models Formly is an Angular module that transforms HTML forms to Javascript/JSON configured forms. Over the past two weeks I have been using Formly to transform HTML forms and saw the benefits of how much time is saved and how much code has been condensed through this process. The image below shows a…

    Concurrency
  • Blog

    How to Delete Users from Azure AD After AD Connect instance has been deleted

    I encountered this issue while working on the Windows and Office Deployment Lab Kit, however, it may be useful to others who may be coming across this issue elsewhere. In my case, I had started the deployment lab just before it was set to expire on 6/16/19. I had configured my lab using AD connect…

    Concurrency, Inc.