SSIS 2011 – what’s planned for the new version

May 30, 2010

This is continued live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv of Data Integration in Large Organizations.   The roadmap for SSIS 2011 - what will exist in the future version of Integration Services 11 Today everything exists in a package.In SQL Server 2011 there is an SSIS Server which uses SQL Server OS to manage data flows without being confined to a package. Most of the work is around building the server and the tools to manage the server. A new designer interface which will be built around common tasks. A designer with a...

SSIS 2008 Performance and Scalability

This is continued live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv of Data Integration in Large Organizations.   SSIS 2008 Performance and Scalability   The importance of measuring to improve performance Understand and measure hardware:How many CPU cores?How much memory?How fast is the I\O subsystem? Understand the potential bottlenecks:Understand the limits of the Source System (usually a bottleneck as it's usually slower than the new system) Gains from the source system:Find better driversConfigure the driverOptimize I\O and network configuration Measure Speed per Connection: Row / sec = Row Count / Time of the data flow   Improving the speed of...

SSIS 2008 improvements over SSIS 2005

This is continued live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv of Data Integration in Large Organizations. SSIS 2008 improvements over SSIS 2005 C# scripting can reference all .net assembliesVSA replaced by VSTA Pipeline Scale Up Tuning SSIS through looking at the buffers on the Data Flow.In SSIS 2005 you would add buffers and break up flows SSIS Tip: Tools > Options > BI Designers > IS Designers:Control Flow Data ConnectData Flow Data ConnectCheck them both to connect the components automatically Use Row Sampling component to do performance testing. One buffer structure goes all through the process.We...
5 comments

Live Blogging Data Integration in Large Organizations

This is live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv. I would really like to thank Hamada who lent me his netstick so I can blog - Thanks Hamada! Business Intelligence is about people not about IT.Your data is always connected to real world and in direct connection to it. It's important to know your business for you to design a good Decision Support system.BI has always been in the middle of the spectrum - tactical decisions. CEO and operational workers will usually look just at your BI reports, they won't create...

It’s a love thing…

May 29, 2010

It's been three years that me and the blog have been together (truthfully, the date was on the 15th, and I didn't forget honey, I was just really busy with work, so you understand now don't you?... Ok, I'll get you flowers :)) I have to admit that looking back at older posts is sorta weird, cause I think my own voice in my writing has changed since then. But then again, I guess you never stop changing your own voice in your writing, just as you never stop changing yourself.I also really learned to appreciate the blog more, as...
one comment

מפגש מעניין ב BI User Group

May 25, 2010

קהילת ה BI כולה בבאז ממפגש ה BI User Group הקרוב. המפגש יהיה ביום שני הקרוב, ה 31 לחודש. אישיות בכירה ממיקרוסופט עומדת להגיע ולהרצות על Data Mining. המפגש הוא ללא עלות.להרשמה ולפרטים נוספים אנא פנו לדף אירוע ה BIUG.
no comments

Microsoft SQL Server 2008 R2 Feature Pack Download

May 12, 2010

Hot off the press!  I just read on Teo Lachev's blog that Microsoft SQL Server 2008 R2 Feature Pack RTM - ed. Yeah, I know! I have to admit this is also slightly amusing for me, as just this morning I asked a Microsoft consultant if he knew when it's suppose to drop...So you know what this means, you can now download a standalone version of Report Builder 3.0, PowerPivot for Excel and Data Mining Add-ins for Office 2007. Each can be downloaded by itself or as a whole package. If you're looking to check out all the new...

BI capabilities in Office 2010 – SharePoint, Excel and Project

Office 2010 RTM - ed on the end of April. You probably heard already about PowerPivot and Excel 2010. And of course there's also SharePoint 2010 which has Excel Services, Visio Services, Access Services, PerformancePoint Services and PowerPivot integration. Still, that doesn't make for the entire BI scope in Office 2010. I have just recently learned that there are BI capabilities in Project Server 2010. Going deeper I have learned that there were already such capabilities in Project Server 2007 which integrated with PerformancePoint Services 2007... still, never too late to learn something new :) Project 2010 has multiple...

Report Builder 1.0 vs. Report Builder 3.0

May 4, 2010

The municipality has been planning to move to SQL Server 2008 R2. Now obviously I'm happy about it, but it also made me wonder about our Report Builder 1.0 models. I know Report Builder 3.0 doesn't have all the functionality that Report Builder 1.0 has. In some ways Report Builder 3.0 outdoes version 1.0 and in other ways it's lacking. I was deliberating on how the move of upgrading to SQL Server 2008 R2 may affect us in the municipality. I mean, does that make our Report Models from 1.0 obsolete? Maybe there's no point in continuing to develop...

Win a free pass to the SQL & BI convention

May 3, 2010

As you may have read, I've got a ticket to give away for the first SQL & BI convention which is taking place at the end of this month in Tel Aviv. Yes, I'm going to give you a ticket which will grant you a pass to a day of lectures about all the new features in SQL Server 2008 R2. The lectures in the convention are aimed at helping you learn of the new features and how they can help you in your day to day work. The ticket to a day at the convention is worth 900...