RADACAD Blog

Latest Power BI and AI articles from RADACAD team

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

Foreach Loop : SMO Enumerator – SSIS 2012 Tutorial Videos

Posted on by Reza Rad

This Video Tutorial illustrates how to use SMO enumerator to loop through linked servers. SMO stands for SQL Server Management Objects, and using SMO provides ability to loop through list of metadata objects of SQL Server database or instance. This enumerator can be used for looping through jobs, linked servers, data files of database, and Read more about Foreach Loop : SMO Enumerator – SSIS 2012 Tutorial Videos[…]