Change the T-SQL Script of a Power BI Table without Add/Remove from the Model

If you have been using T-SQL queries to build the tables of your Power BI data model, you probably know what I’m talking about. Sometimes after a while using a query in the Power BI model, you might change the script and want the change to be applied in the data model. One of the Read more about Change the T-SQL Script of a Power BI Table without Add/Remove from the Model[…]

Export data from Power Query to Local Machine or SQL Server using R scripts

There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show how to do it by writing R scripts inside Power Query.   First how to Store Files to PC To store data back to a file Read more about Export data from Power Query to Local Machine or SQL Server using R scripts[…]

Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway

I have mentioned previously that one of the ways to step beyond Power BI 10GB limitation is to use Power BI with Live Connection. In this post I will explain in a full step by step walk through how to use SQL Server as a DirectQuery or Live source for Power BI, and how to Read more about Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway[…]

Temporal Tables and Their Roles in ETL and Data Warehouse

It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP. 24HOP 24 Hours of PASS is Read more about Temporal Tables and Their Roles in ETL and Data Warehouse[…]

PASS Summit 2015 Keynote 1

And the PASS Summit 2015 Starts with the Keynote Good crowd turnout for this summit Blogger table Let’s start then This will be live blog of Pass Keynote day 1, so watch here; 8:21: Narrator of promotion video:  40 zeta bytes of data will be created by 2020 8:22: PASS President Thomas LaRock on stage Read more about PASS Summit 2015 Keynote 1[…]

SSIS 2016; What’s New in CTP 2.3

SQL Server 2016 is under a heavy improvement plan, The latest CTP version (Community Test Preview) of it is 2.3 which released as preview three days ago. CTP 2.3 has some new features across all components of SQL Server, such as SSRS, SSAS, SSIS, MDS and etc. Previously I wrote about some new changes in Read more about SSIS 2016; What’s New in CTP 2.3[…]

Book Published: Microsoft SQL Server 2014 Business Intelligence Development

I am happy to announce that my new book published today. (both paper and eBook version are available now) Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide This book covers introduction to all components of Microsoft Business Intelligence (one chapter for each component). topics that covered in the book are Dimensional Modeling, SQL Server Read more about Book Published: Microsoft SQL Server 2014 Business Intelligence Development[…]

Fixing the error: The multi-part identifier … could not be bound in Join statements

One of the most common errors that you might face in join statements is this error: Msg 4104, Level 16, State 1, Line … The multi-part identifier …… could not be bound. The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, Read more about Fixing the error: The multi-part identifier … could not be bound in Join statements[…]

Lag and Lead Functions in SQL Server 2012

SQL Server 2012 has a set of useful functions to work in T-SQL environment. Lead and Lag are one of the most useful functions introduced in 2012. Lag function helps to access values from previous records, and Lead function helps to access values from next records in the data set. structure of working with these Read more about Lag and Lead Functions in SQL Server 2012[…]

T-SQL Script to get row count of all tables in the database

Today I’ve wrote a simple script to get number of records for all tables in a database and fetch those tables that contains at least one record. This picture shows an example of result set: Here is the script: declare @tempTable table(tablename varchar(max), rowscount int,processed bit) insert into @tempTable select TABLE_NAME,0,0 from INFORMATION_SCHEMA.TABLES where TABLE_CATALOG=‘DEMO’ Read more about T-SQL Script to get row count of all tables in the database[…]