Speaking about Master Data Services

Hi folks, I’ll speak about Master Data Services at Microsoft Venue in Auckland on 9th of October of 2012. Session Topic and description: Managing Reference Data with Master Data Services In most of companies there are some reference data which are in use from different applications and databases, This reference data should be consistent and Read more about Speaking about Master Data Services[…]

I am Speaking at NZ CodeCamp 2012: SSIS Catalog in Action

Hi folks, I am speaking a 50 minute session on SSIS Catalog in Action at NZ CodeCamp 2012 in Auckland at 9th September. If you are attending there just come to me and say hi. New Zealand Code Camp 2012 will be running at 9th September at Auckland (University of Auckland, Business School). Sessions organized Read more about I am Speaking at NZ CodeCamp 2012: SSIS Catalog in Action[…]

I am Trainer of SQL Server for the Oracle DBA Course

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 about I am Trainer of SQL Server for the Oracle DBA Course[…]

SSIS Catalog: Part 6 – Operations

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 about SSIS Catalog: Part 6 – Operations[…]

SSIS Catalog: Part 5 – Logging and Execution Reports

In previous blog post of SSIS Catalog series, I talked about how to execute a package, and what are tables in SSISDB which store information about execution of package.  In this post I will talk about logging in SSIS 2012, and different logging options and how we can set logging level at the time of Read more about SSIS Catalog: Part 5 – Logging and Execution Reports[…]

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

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 about My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework[…]

SSIS Catalog: Part 4 – Execution

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 about SSIS Catalog: Part 4 – Execution[…]

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

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 about SSIS Catalog: Part 3 – Folder Hierarchy; Folder, Projects and Packages[…]

SSIS Catalog: Part 2 – How to Create Catalog?

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 about SSIS Catalog: Part 2 – How to Create Catalog?[…]

SSIS Catalog: Part 1 – What is the Catalog?

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 about SSIS Catalog: Part 1 – What is the Catalog?[…]