Latest Power BI and AI articles from RADACAD team
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?[…]
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?[…]
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 about Interview with Packt Publishing[…]
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 about SSDT as a Database Schema Compare Tool[…]
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 about SSIS 2012: Execute Package from Another Project[…]
Hi folks, As I mentioned previously,َ Today I am happy to inform you that my book on SSIS 2012 published already, Me (Reza Rad) with my friend (Pedro Perfeito) who is another SQL Server MVP from Portugal wrote a book on SSIS 2012,we had Phil Brammer as technical reviewer. and book published already, If you Read more about Book Published: Microsoft SQL Server 2012 Integration Services: An Expert Cookbook[…]
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 about T-SQL Script: Find Keyword in whole Database[…]
Hi folks, I had a presentation on New Features of SSIS 2012 on Auckland SQL User Group at Microsoft NZ venue at 16 May 2012. in following you will find more details about my presentation Session Topic: New Features of SSIS 2012 Description: SQL Server Integration Services (SSIS) is a leading tool in the data Read more about My Presentation on New Features of SSIS 2012 – Auckland SQL User Group[…]
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 about MCITP – Business Intelligence Developer 2008[…]
In this post I will talk about MCTS BI 2008; Microsoft certification plan for Business Intelligence in SQL Server 2008 contains two exams: 70-448 ; MCTS (Microsoft Certified Technology Specialist) – SQL Server 2008, Business Itelligence Development and Maintenance 70-452 ; MCITP (Microsoft Certified IT Professional) – Business Intelligence Developer 2008 so if you want Read more about MCTS – SQL Server 2008, Business Itelligence Development and Maintenance[…]