I am Trainer of SQL Server for the Oracle DBA Course

Posted by on Aug 28, 2012 in Presentations, SQL Server | No Comments

Hi folks, I want to give you a heads up about my new course which will be presented at 15-16 of November in Auckland. Title of Course is : Microsoft SQL Server 2012 for the Oracle DBA. Registration are open now under this website: http://www.auldhouse.co.nz/courses-schedules/vendors/microsoft-technical/sql-server/microsoft-sql-server-2012-for-the-oracle-dba This is a 2 day course, and I and Dave ...

Read More

SSIS Catalog: Part 6 – Operations

Posted by on Aug 20, 2012 in SSIS, SSIS Catalog | No Comments

In previous post of SSIS 2012 Catalog series, I talked about Logging and query log tables from Catalog. In this post you will read more about Operations tables about different tasks like deploy project with detailed information about each operation. I also provide some helper tables to help for writing more descriptive queries on operation ...

Read More

My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework

Posted by on Aug 6, 2012 in ETL, Presentations, SSIS, SSIS Catalog | No Comments

Hi folks, I will speak at 10th of August at Pass Data Warehousing and Business Intelligence Virtual Chapter. Session Title: SSIS Catalog; Big Step for ETL Framework Time: Fri August 10th 2:00 PM at NZDT , 12:00 PM at Brisbane = 9th August 10:00 PM EST Fri  August 10th 12pm – 1pm Brisbane, AU Timezone (GMT+10) (= ...

Read More

SSIS Catalog: Part 4 – Execution

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

In previous blog post of SSIS Catalog series, I described folder hierarchy. In this post I will explain tables which deals with execution of packages and projects. At the time of package’s execution, you can map environment variables to package’s parameters, set values to the connection string’s properties, set package’s property values, and set 32bit run ...

Read More

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