Author: Reza Rad

SSIS Catalog: Part 3 – Folder Hierarchy; Folder, Projects and Packages

Posted by on Jul 29, 2012 in SSIS, SSIS Catalog | No Comments

In previous post of SSIS Catalog series, I’ve explained how to create SSIS catalog and configure properties. In this post I talk about Folder hierarchy in SSIS catalog, and different parts of folder hierarchy: Folder, Projects, packages and Environment Variables. SSIS Catalog contains folders, in each folder there can be one or more projects. each ...

Read More

SSIS Catalog: Part 2 – How to Create Catalog?

Posted by on Jul 28, 2012 in SSIS, SSIS Catalog | No Comments

In previous post of SSIS Catalog Series, I explained what is the SSIS Catalog. In this post I will explain how to create SSIS Catalog. To Create SSIS Catalog you first need to install SQL Server 2012. after installation open SSMS and right click on "Integration Services Catalogs" node and select "Create Catalog" In the ...

Read More

SSIS Catalog: Part 1 – What is the Catalog?

Posted by on Jul 28, 2012 in SSIS, SSIS Catalog | One Comment

In this new series of posts I will explain SSIS Catalog of Integration Services 2012. Part 1 – What is the Catalog? SSIS Catalog is a new repository model for Integration Services, which introduced from SQL Server 2012. This new repository model brings a lot of abilities for developers, testers and administrators.  SQL Server Integration ...

Read More

Interview with Packt Publishing

Posted by on Jul 25, 2012 in Publications, SSIS | No Comments

Script of my interview with Packt Publishing about my latest book Microsoft SQL Server 2012 Integration Services: An Expert Cookbook. published on PacktPub website here. If you want to read more details about the book read this post. here you can read full story: Interview with Reza Rad , Author of ‘Microsoft SQL Server 2012 ...

Read More

SSDT as a Database Schema Compare Tool

Posted by on Jul 15, 2012 in SQL Server, SSDT | No Comments

Today I want to write about new feature in SSDT (SQL Server Data Tools) to compare two databases in term of structure. With a free installation of SSDT you can have ability to compare two SQL Server databases and review changes, create changes script and apply it on destination database. there are some options also ...

Read More

SSIS 2012: Execute Package from Another Project

Posted by on Jul 11, 2012 in SSIS | No Comments

Execute Package Task in SSIS 2012 has ability to use Project Deployment Model. With selecting Project Reference type as ReferenceType we can select any of packages But just from current project. This post shows a way to run package from another project in SSIS 2012. There are some ways to run a package in SSIS ...

Read More

T-SQL Script: Find Keyword in whole Database

Posted by on May 22, 2012 in SQL Server, T-SQL | No Comments

There are some times that you need to find all occurrence (or some of them) of a keyword in all columns/tables in a database, This is a usual scenario in data profiling. I wrote script below to fulfill this requirement, this script will search for specific keyword in all columns and tables of a database ...

Read More

MCITP – Business Intelligence Developer 2008

Posted by on Apr 29, 2012 in SQL Server | No Comments

Today I want to talk about exam 70-452 which is PRO exam for achieving MCITP BI 2008. for sitting on this exam you should pass 70-448 (MCTS – BI 2008) as first step. exam 70-452 access your solution design abilities with Microsoft SQL Server 2008 to create Business Intelligence technologies. exam may contains 64 questions ...

Read More