rad.pasfu.comReza Rad's Technical blog

My technical scripts on MS BI, SSIS, SSAS, MDS, DQS and Programming, and news about technical presentations and publications Homepage About Me Publications Presentations Search Publications Web Casts Free Online MS BI Video Tutorials Certifications Business Intelligence Developer 2008 SQL Server 2008, Business Intelligence Development and Maintenance Database Administrator 2008 SQL Server 2008, Implementation and Maintenance Search Recent Entries Blog Moved SQLBits is Awesome, But I cannot Attend! Why?! Referring SSIS Variables from SSIS Script Task Introduction to Azure Data Factory Power BI Now Available For Free! Configure Data Management Gateway from Azure Portal Agenda of my Speaking: TechDays Hong Kong 2015 Power BI; from Rookie to Rockstar Renewed MVP for one year more; Fifth now :) SQL Bits Voting is Open Now Links reza_rad at Experts Exchange Reza Raad at Microsoft TechNet SSIS blogs: SSIS Team Blog Todd McDermid’s Blog Pedro’s Blog SSIS Junkie (Jamie Thomson) Rafael Salas SSIS Talk (Phil Brammer) SSISBI (Duane Douglas) Shahriar Nikkhah’s Blog BI Solutions ( Amin’s BI blog ) Popular Entries PIVOT Transformation - SSIS - Complete Tutorial (30) Insert, Update, and Delete Destination table with SSIS (21) SSIS Upsert With Lookup Transform (21) Foreach Loop based on Variable - SSIS (19) Transfer Multiple Files from or to FTP remote path to local path - SSIS (15) Microsoft SQL Server MVP Award for 2012 (15) Dynamic connection string in SSIS (13) SSIS - Sql Server to XML - Save to file (10) Update image column with the physical file with SSIS (10) My new SSIS 2012 Book Will be Published Soon (10) Awards Speaking Sessions and Presentations Categories Awards (5) Azure Data Factory (2) Big Data (1) Certifications (3) Data Mining (2) Diary (5) Master Data Services (7) Power BI (4) Power Query (10) Presentations (32) Programming (8) Publications (3) SQL Server 2012 (3) SSAS (5) SSIS (66) SSIS 2012 Tutorial Videos (13) SSIS Catalog (6) T-SQL (12) Archives Recent... Older... Calendar February ’20 Mo Tu We Th Fr Sa Su 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Syndicate This Blog Statistics Last entry: 2015-04-07 04:51 162 entries written 355 comments have been made 0 visitor(s) online Blog Administration Open login screen Powered by Twitter Tweets by @Rad_Reza Blog Moved Dear friends, I would no longer write here, as my blog moved to this new address, please visit that address and stay tuned; http://www.radacad.com/blog Posted by Reza Rad on Tuesday, April 07. 2015 at 04:51 18822 hitsSQLBits is Awesome, But I cannot Attend! Why?! It is with all regret that I cannot attend at the conference that is the largest SQL event in Europe, and always compared to SQLPASS Summit because of the high quality of content and large number of audience. I was honored to be selected to speak for couple of sessions in SQLBits 2015, and I was really prepared for that. However I couldn’t manage to get my UK Visa because of the long process of the visa application. So with all my willingness to come to SQLBits, and with all preparation that I’ve done, considering that I will be too close to the SQLBits (I will be at SQLRally Copenhagen with only couple of hours flight distance to SQLBits), and also considering the fact that I’ve purchased flight tickets and so on, I have to cancel my speaking engagement. This is really a sadness that I cannot attend at this wonderful conference and won’t meet some of you because of that. But if you are in Europe, or if you are close enough to get benefits from this event, I highly recommend to you to go there. you will get many values from high quality sessions, you will have opportunity to talk with professionals of DBA, DEV, BI fields of SQL Server. and If you go there, please also remember me while you are there. I would like to thank to SQLBits team, and specially thank to Allan Mitchell because of their efforts for organizing such great events. My sessions that I’ve selected and prepared to speak in this event was: Azure Data Factory vs SSIS (Regular Sesssion) Friday 6th March 2015, 5:00 pm SSIS is a well known ETL tool on premisses. Azure Data Factory is a managed service on cloud which provides ability to extract data from different sources, transform it with data driven pipelines, and process the data. in this session you will see many demos comparing ADF (Azure Data Factory) with SSIS in different aspects. you will also learn features that are available in ADF but not in SSIS with many demos. ETL Architecture for Solving Data Warehouse Challenges (Double Session) Saturday 7th March 2015, 11:15 am Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. By the way there are some challenges in design and implementing Data Warehouses which needs robust and reliable ETL implementation. In this session you will learn an ETL Architecture implemented by SSIS and MDS to solve couple of most challengeable Data Warehousing scenarios which are Slowly Changing Dimension and Inferred Dimension Member. There will be many demos through this session which helps you to understand design and implementation of the architecture. I appologize from all of you that I cannot attend, but I have no otherway, otherwise I would do it. I really hope I could be able to come for next SQLBits, and see you all there for next years. Posted by Reza Rad on Saturday, February 21. 2015 at 14:45 in Presentations no comments yet, be the first! Trackbacks (0) 32161 hitsReferring SSIS Variables from SSIS Script Task Today I got a very valued feedback from a reader of my SSIS 2012 book , and based on that feedback I’ve found that I had a mistake in one of the exersizes of the book. an important note was not mentioned there. So in this post I want to mention that and applogize for any inconvinence that it caused for readers of my book. If you want to refer to a package variable from SSIS Script Task, the golden rule is that variable name is Case Sensitive ! Continue reading "Referring SSIS Variables from SSIS Script Task" Posted by Reza Rad on Sunday, February 15. 2015 at 17:24 in SSIS no comments yet, be the first! Trackbacks (0) 49747 hitsIntroduction to Azure Data Factory Many of you worked with SSIS and are familiar with term of ETL. Azure Data Factory is Microsoft Cloud based ETL technology, which has ability to work with large volume of data, working with data sources such as SQL Server on premises, SQL Server Azure, or Azure Blob storage. Data can be transformed with Azure Data Factory and be loaded into the destination. Data Factory can be scheduled to run in Azure portal, and there are monitoring features that provide good information about the job. Continue reading "Introduction to Azure Data Factory" Posted by Reza Rad on Thursday, January 29. 2015 at 01:09 in Azure Data Factory no comments yet, be the first! Trackbacks (0) 39301 hitsPower BI Now Available For Free! It is really good news that Satya Nadella announced Power BI service will be available for free . I believe this is to compete with BI tools in the market and Microsoft seeks for wider range of customers. From my point of view this is a great change, because as a BI Consultant I’ve worked with many BI tools in the market, and I always found Microsoft tools as one of the top BI tools, and I am proud to be part of the community to help spreading word about it. The new pricing plan starts from free for 1 GB data user per month, and then there is a 9.99$ per month plan for 10GB user. Continue reading "Power BI Now Available For Free!" Posted by Reza Rad on Wednesday, January 28. 2015 at 02:33 in Power BI no comments yet, be the first! Trackbacks (0) 30073 hitsConfigure Data Management Gateway from Azure Portal Today I’ve faced an issue; when the Power BI Admin Center does not work I want to configure and set up...