Blog

  • Configuring Power BI Report Server May Preview – Part 2

    May 20, 2017

    The May 2017 Preview of Power BI Report Server can be downloaded here. This post explains with guided video examples, how to configure Power BI Report Server May 2017 Preview edition.  This means the configuration part after installing.  If you missed the first part of this series, see the install process here.  To configure Power BI […]

    Read More
  • Create

    10 – TSQL Create Table Statement

    October 11, 2016

    Hi! Today I learned about the Create Table statement, it allows you to create and define tables, as what I studied on the last episode, it is a DDL statement (Data Definition Language). CREATE TABLE The syntax for this statement in SQL Server (TSQL) id: CREATE TABLE table_name ( column1 datatype [NULL […]

    Read More
  • Concepts

    9 – Learning DDL and DML concepts

    September 30, 2016

    Hello there! Learning about DDL and DML concepts is a fundamental foundation for becoming a Data Wrangling and Data Warehousing extraordinaire.  SQL statements are divided into two major categories: Data Definition Language (DDL) and Data Manipulation Language (DML).  In Short: DDL describes a bunch of commands that CREATE Data Structures, like […]

    Read More
  • Let the Good Times Flow in SharePoint Online

    September 28, 2016

    Flow has been available for some time now as a beta program wthin Office365 offering Cloud orchestrated business workflows.   What does this actually mean to a business user? These workflows offer businesses the opportunity to automate, improve operational efficiency, reduce room for error and encourage repeatable experience by automating […]

    Read More
  • T-SQL syntax not acceptable in Azure SQL Data Warehouse

    September 26, 2016

    In your code Migration from SQL Server to Azure SQL DW, you will have to review some T-SQL syntax that are not acceptable in Azure SQL Data Warehouse. Here are the list of commands that will not work in your Azure SQL Data warehouse: ANSI joins on updates ANSI joins on deletes merge statement cross-database […]

    Read More

Power Bi Blog