Showing posts with label SQL Saturday. Show all posts
Showing posts with label SQL Saturday. Show all posts

Sunday, March 18, 2012

BI Session – First Look to SSIS 2012

The day after...
The SQL Saturdays #115 that held in Portugal yesterday at Universidade Autónoma de Lisboa was in my perspective a fantastic conference. The organization provided by the Portuguese SQL user group SQL Port, was absolutely amazing! Everything worked perfectly and all the small issues raised, were faster resolved by volunteers that has a common passion like me: the SQL Serer. Speaking on the some track of persons that I follow for some years, like Alan Mitchel, Rui Quintino and Andro Moreira was a big honor to me… also, having the room complete on a Saturday at 9h30 AM was a big surprise. I just want to mention a fact that made me a little disappointed… some submitted sessions was not approved and I’m absolutely sure that the conference would be even better with the speakers like Rui Romano, Tiago Moreiras and Tiago Rente. But I understand that it’s impossible to have all speakers in action.

I've submitted two sessions about SSIS 2012, but just one session was approved by the organization. It were understandable but forced me to summarize the two sessions in only one. I was a little fast presenting my session, because my main goal was to provide the first impact to SSIS 2012 and cover the most new features and improvements to the attendees. I think almost attendees got the overall vision about this new version and I have no doubts that they will now go into deep detail on the new features and improvements they think more usefully.

I've included below my session slides presentation that I hope you enjoy and can share some feedback with me. As I already wrote on this blog, I’m finishing the book on the SSIS 2012 version and I hope you could help me to continue writing on the future about subjects I love!

A special thanks to the organizers, master BI students, friends, colleagues an all the attendees who chose my session.

Sunday, March 11, 2012

BI Conference – SQL Saturdays #115 Portugal 2012

Dear Friends,
Next Saturday I’ll present a session on SQL Saturdays Portugal! On this session I’ll show the first look to the SQL Integration Services 2012 based on my last 6 months experiences writing a book about it with my friend Reza Rad. We are currently writing the latest chapters and very excited with the updates made to this version. Some of those, are highlighted below:


Legacy and Project deployment Models
The deployment approach used in the previous version of SSIS is called Legacy Deployment Model and the new one is the Project Deployment Model. If the new approach (Project Deployment Model) is used, almost custom logging made in the legacy deployment mode (previous versions) doesn’t make more sense now. This new approach has an important new SSIS Catalog that automatically logs all package execution activity along with some built-in reports that provide a more intuitive perspective over log activity and performance


Change Data Capture (CDC) tasks and components
Change Data Capture (CDC) feature was included in SQL 2008 version and provides other possibility to detect change on data under a database. This version include a new CDC task and components to make the life easier for those persons that choose this approach to deal with changed data


SQL Server Data Tools
The old Business Intelligence Development Studio (BIDS) does not exist anymore. Now is the SQL Server Data Tools (SSDT) and has a very intuitive layout with new tasks and components design and is under the very interesting Visual Studio 2010 environment


Simple and important improvements
Several simple and important improvements were made. Some examples are the improvement on the variables toolbar, Undo & Redo capabilities, easier way to zoom and several other improvements


More new features
In addition to CDC task and components, I should highlight some other new features like: data flow column mapper, the expression task, package parameters, data quality services and several other very interesting features that I’ll highlight on the next weeks!

I hope to see you next Saturday on my session! More details about the conference could be shown here!
I’ll add the slide presentation soon here
Just to remember that the book I wrote with Reza is not on Pre-Order here! I hope to get feedback from you soon! :-)

Wednesday, April 13, 2011

BI Event - SQL Saturday Portugal

The SQL Saturday, owned by the Professional Association for SQL Server (PASS), is organizing for the first time outside USA, an SQL event here in Portugal! The SQL Saturday goal, is to provide the tools and knowledge to groups and event leaders that need to organize and host, a free day of training for SQL Server professionals. This SQL event will be realized all day, and will take place next 15-April at the Microsoft Portugal auditorium. It’s for sure a very interesting event, mainly for those professionals in the SQL DBA and DEV fields.

The session’s schedules are the following:
09:00 AM Niko Neugebauer
SQL Server Denali CTP1 and more
10:15 AM Nuno Godinho
SQL Azure Overview - How to Develop and Manage it
11:30 AM Ramesh Meyyappan
SAP/SQL Server - Software Integration at its best!
01:30 PM Artur Santos
Optimizing SQL Server for Sharepoint 2010
02:45 PM Scott Stauffer++
SSIS: Overcoming Common Challenges
04:00 PM Pedro Rosa
Introduction to SQL Azure Reporting?
05:15 PM Ramesh Meyyappan
SQL Server Performance Monitoring and Tuning

Click here to Register

LinkWithin

Related Posts Plugin for WordPress, Blogger...