Author: Reza Rad

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit. Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc. He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer. Reza’s passion is to help you find the best data solution, he is Data enthusiast. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

Error Handling in SSIS; Download presentation materials and recording

Posted on by Reza Rad

Thanks for all attendees of today’s webinar about Error Handling in SSIS. turnout was good, and good questions asked and responded. Here are topics that covered in this session: Error handling in SSIS Data Taps Logging SSIS Catalog stored procedures for Logging and execution Debugging and Troubleshooting SSIS packages some live demos about error handling, Read more about Error Handling in SSIS; Download presentation materials and recording[…]

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

Posted on by Reza Rad

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[…]

Deep Dive into Security Schema of Master Data Services Database

Posted on by Reza Rad

Master Data Services provides data governance and reference data management as part of SQL Server product. There is a security mechanism in MDS that provides robust role based security and authorization for domain accounts and groups. Security on data also can be applied on Model level, entity, or even in row level. Security in MDS Read more about Deep Dive into Security Schema of Master Data Services Database[…]

Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators

Posted on by Reza Rad

Thanks for attending in my session at Pass DWBIVC today, it was my pleasure to see you there. Today’s talk was about; Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators in SSIS Session description: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting Read more about Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators[…]

PIVOT Transformation Issue in SSIS

Posted on by Reza Rad

Today I’ve found a bug in SSIS Pivot Transform component reported as a question in TechNet forums here. Reported issue was related to pivoting some records based, result of PIVOT transformation in SSIS was not as expected to be. read below for detailed explanation; Scenario Explanation: This is a sample of incoming data set: The Read more about PIVOT Transformation Issue in SSIS[…]

Foreach Loop Enumerators in SSIS; My presentation on NetCom Learning

Posted on by Reza Rad

Thanks for all who attended on my presentation today supported by Netcom Learning. http://www.netcomlearning.com/webinars/886622/Free-Webinar-Foreach-Loop-Enumerators-in-SSIS–SQL-Server-2012-training.html?WebinarID=205 Today’s presentation was a webinar on Foreach Loop Enumerators in SSIS. In this session I explained 7 different types of enumerators in SSIS; From Variable Enumerator File Enumerator Item Enumerator ADO Enumerator ADO.NET Schema Rowset Enumerator Nodelist Enumerator SMO Enumerator In Read more about Foreach Loop Enumerators in SSIS; My presentation on NetCom Learning[…]

For Loop Container – SSIS 2012 Tutorial Videos

Posted on by Reza Rad

This Video Tutorial illustrates how to use For Loop Container to implement a simple loop structure. For Loop Continaer provides a simple loop structure such as programming languages. It contains Init Expression, Eval Expreseeion, and Assign Expression. These three expressions makes the three main part of loop structure in programming languages as well, InitExpression is Read more about For Loop Container – SSIS 2012 Tutorial Videos[…]

Script for Creating and Generating members for Time Dimension

Posted on by Reza Rad

Time Dimension is an important dimension in most of the Data Warehouses, especially when requirement for keeping hours, minutes, and seconds is vital for the business. Some blog and books and articles consider time dimension as a dimension that contains date columns, but in this post I only focus on the Time part of it, Read more about Script for Creating and Generating members for Time Dimension[…]

Foreach Loop : ADO Enumerator – SSIS 2012 Tutorial Videos

Posted on by Reza Rad

This Video Tutorial illustrates how to use ADO enumerator to loop through a data table that loaded within the package. ADO Enumerator loops through a data table that loaded into an Object type variable. The object type variable can be filled with a data table through an Execute SQL Task with a Full Result Set, Read more about Foreach Loop : ADO Enumerator – SSIS 2012 Tutorial Videos[…]

Foreach Loop : Item Enumerator – SSIS 2012 Tutorial Videos

Posted on by Reza Rad

This Video Tutorial illustrates how to use Item enumerator to loop through a pre-defined data table. A data table with multiple columns can be defined in the Item Enumerator, data type of columns can be different. Item Enumerator then will loops through each record, pick each column value and insert that into package variable. In Read more about Foreach Loop : Item Enumerator – SSIS 2012 Tutorial Videos[…]