Ftp Task Upload Multiple Files at One Time

Web log Moved

Honey friends,

I would no longer write here, as my weblog moved to this new address, please visit that address and stay tuned;

http://www.radacad.com/blog

SQLBits is Crawly, Just I cannot Attend! Why?!

It is with all regret that I cannot attend at the conference that is the largest SQL consequence in Europe, and always compared to SQLPASS Elevation considering 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.

Then with all my willingness to come to SQLBits, and with all preparation that I've done, considering that I volition be also close to the SQLBits (I will be at SQLRally Copenhagen with but 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 briefing and won't meet some of you considering of that. But if you are in Europe, or if you are shut enough to get benefits from this event, I highly recommend to you to get there. y'all will become many values from loftier quality sessions, y'all volition have opportunity to talk with professionals of DBA, DEV, BI fields of SQL Server. and If yous go there, delight also call up me while y'all are there.

I would like to thank to SQLBits team, and especially thank to Allan Mitchell considering of their efforts for organizing such nifty events.

My sessions that I've selected and prepared to speak in this event was:

Azure Information 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 encounter many demos comparing ADF (Azure Data Factory) with SSIS in dissimilar aspects. you lot volition also learn features that are available in ADF but not in SSIS with many demos.

ETL Architecture for Solving Data Warehouse Challenges

(Double Session)

Sat 7th March 2015, eleven:xv am

Data Warehouses are heavily in use nowadays in about of businesses around the world. Information Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. Past the manner there are some challenges in design and implementing Information 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 exist many demos through this session which helps you to sympathise design and implementation of the architecture.

I appologize from all of you that I cannot attend, but I have no otherway, otherwise I would practise it.

I really hope I could be able to come up for adjacent SQLBits, and see you all there for side by side years.

Referring SSIS Variables from SSIS Script Task

Today I got a very valued feedback from a reader of my SSIS 2012 volume, and based on that feedback I've institute that I had a mistake in one of the exersizes of the volume. 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 bundle variable from SSIS Script Job, the golden dominion is that variable name is Example Sensitive!

Continue reading "Referring SSIS Variables from SSIS Script Task"

Introduction 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 power to piece of work with large volume of information, working with data sources such as SQL Server on bounds, SQL Server Azure, or Azure Hulk storage. Data tin be transformed with Azure Data Factory and be loaded into the destination. Data Mill can be scheduled to run in Azure portal, and there are monitoring features that provide proficient information virtually the job.

Continue reading "Introduction to Azure Data Factory"

Power BI Now Available For Complimentary!

Information technology is really proficient news that Satya Nadella announced Ability BI service volition be bachelor 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 bang-up change, because equally a BI Consultant I've worked with many BI tools in the market, and I always institute Microsoft tools every bit one of the top BI tools, and I am proud to be part of the community to help spreading word about information technology.

The new pricing plan starts from free for 1 GB data user per month, and and then there is a 9.99$ per calendar month program for 10GB user.

Proceed reading "Power BI At present Bachelor For Free!"

Configure Information 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 Data Management Gateway.

Data Direction Gateways is a service that install on your automobile or whatsoever on premises server, and let cloud services (such as Power BI or Azure Information Manufacturing plant) to connect to on premises database. y'all can download Data Management Gateway from here:

http://www.microsoft.com/en-united states of america/download/details.aspx?id=39717

This link is an introduction about Data Direction Gateway and how to setup information technology:

http://blogs.technet.com/b/powerbisupport/annal/2014/12/17/information-direction-gateway-introduction.aspx

Equally you read through link in a higher place it simply explicate how to register gateway with the key that you lot get from Power BI admin middle.

[Image from Microsoft: http://blogs.technet.com/b/powerbisupport/annal/2014/12/17/data-management-gateway-introduction.aspx]

In beneath I explicate how to get the registration central of Data Management Gateway from Azure Portal;

Continue reading "Configure Data Management Gateway from Azure Portal"

Agenda of my Speaking: TechDays Hong Kong 2015

I am pleased that I've been selected to speak once more for another yr in TechDays Hong Kong,

I was honored previously by speaking in TechDays Hong Kong 2013 and 2014. and this is the 3rd year in a row. and I actually capeesh information technology.

I desire to thank all Microsoft Hong Kong people who made this year's TechDays.

TechDays Hong Kong 2015 will happen from 11th to 13th of February, and I will exist speaking 4 sessions:

• ETL on Cloud? Azure Data Factory
• SSIS vs Azure Data Factory
• Tell Me Which One to Use; MS Information Visualization Tools Comparison
• Data Warehouse Architecture Best Practices

Details of each session described below;

Continue reading "Agenda of my Speaking: TechDays Hong Kong 2015"

Power BI; from Rookie to Rockstar

Have you heard nearly Power BI? Do yous know Ability BI Components?

Have you worked with Power Query Formula language chosen M? Practice you know what are strong capabilities of this linguistic communication and tool?

Accept you build PowerPivot models with strong DAX expressions and deployed in Power BI site?

Exercise you know different types of data visualization with Power View and enhanced using information technology with connection to a PowerPivot model?

Do yous know how to employ 3D Geo Spatial visualization with Power Map and are you familiar with its new features?

Do yous want to learn more than well-nigh Ability Q&A and acquire how to apply it more efficiently?

Accept yous heard well-nigh new Power BI Designer tool, and practice you know how to piece of work with it?

If your answer is no to any of questions above, then come and join u.s. in our pre-con in SQL Sat Vienna on 27th of February 2015. Leila and I will go through all headings higher up in a full day grooming course of Power BI. Hither are more than details near this pre-con:

Keep reading "Power BI; from Rookie to Rockstar"

Renewed MVP for 1 twelvemonth more than; Fifth at present :)

Happy new year to you all, I wish you lot a twelvemonth full of happiness and success.

I am honored that I've been awarded by Microsoft for Fifth yr (which can be called every bit a milestone) equally MVP in SQL Server.

I would like to give thanks Microsoft for their support and understanding, and for such slap-up way to create community of technology passionate people from effectually the world. Last year I've been in my first MVP top and I enjoyed it a lot, I've met many of my MVP friends at that place, and many Microsoft Product Group engineers and managers. I am really honored to be office of this community.

I would like to give thanks my MVP pb (And then Young Lee), and likewise my SQL Family unit friends, other MVPs, Microsoft New Zealand, New Zealand BI user group attendees and speaker, and everyone who organized or was partly organized SQL Saturdays, SQL Pass Summit and TechEds in all conferences that I spoke, all readers of my books and blog posts. all audition of my presentations, and listeners to my video recordings. I believe my MVP accolade gained for my speaking engagement, and authoring activities, and all other methods of contribution within SQL community.

I volition definitely go along my path through SQL Server and BI as I was earlier to assistance the community with more than contribution, and as well to enjoy myself working with high-tech tools and engines.

I wish you again a very happy new yr

Thanks,

Reza

SQL Bits Voting is Open Now

SQL Bits 2015 (XIV) is shut to happen in March from 4th to seventh in London.

I have submitted some sessions in upcoming SQLBits, and I hope to get one or more than accepted. SQLBits usually picks sessions based on customs'due south voice. so delight become to link below and vote for any session you like to encounter in this conference;

https://sqlbits.com/information/PublicSessions.aspx

My sessions are:

Deep Dive into Power Query K Language

Power Map in Real earth Scenarios

SSIS Extensibility

Tell Me Which One to Utilize; MS Information VIZ Tools Comparison

Azure Information Factory vs SSIS

ETL Architecture for Solving Data Warehouse Challenges

SSIS and Spider web Service; Battle of XML

Vote for your desired sessions hither:

https://sqlbits.com/information/PublicSessions.aspx

(Page 1 of 17, totaling 162 entries) next page »

nelsonledis1950.blogspot.com

Source: http://www.rad.pasfu.com/index.php?%2Farchives%2F28-Transfer-Multiple-Files-from-or-to-FTP-remote-path-to-local-path-SSIS.html

Share this post