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

PASS Summit 2015 Keynote 1

Posted by on Oct 29, 2015 in Presentations | No Comments

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

SSIS 2016; What’s New in CTP 2.3

Posted by on Sep 6, 2015 in SQL Server 2016, SSIS | 4 Comments

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

Book Published: Microsoft SQL Server 2014 Business Intelligence Development

Posted by on May 27, 2014 in Business Intelligence, Publications | No Comments

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

Lag and Lead Functions in SQL Server 2012

Posted by on Sep 10, 2013 in SQL Server, T-SQL | No Comments

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

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

Posted by on Aug 18, 2013 in SQL Server, T-SQL | No Comments

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