Mr. Kamal Hathi on SQL Server 2012, PowerPivot, SharePoint and Azure

Monday, April 30, 2012

In a short newspaper article a friend stumbled upon, he saw that Mr. Kamal Hathi, Director of Program Management at Microsoft is coming to Israel for the Think Next Convention. It was also detailed that Mr. Hathi was responsible for the SQL Server Business Intelligence technologies. As the time of the convention drew nearer, I felt more and more interested in trying to catch him for an interview about SQL Server 2012. At the end, I had to finish my questions quickly as Mr. Hathi did not stay till the convention, but I did feel like I had quite...

SQL Server 2012 Licensing Reviews and Views

Tuesday, November 8, 2011

Microsoft has recently announced the SQL Server 2012 Licensing. The main news is the new BI edition released with SQL Server 2012 which is positioned between the Standard edition and the Enterprise edition. You can read an SQL Server 2012 Licensing review on the Adatis blog which lists the pros and cons of the new edition and payment method. Amongst other things, they point out that: "The Business Intelligence edition strips away - Advanced Security (Advanced auditing, transparent data encryption) - Data Warehousing (ColumnStore, compression, partitioning) and provides a cut-down, basic (as opposed to advanced) level of High Availability (AlwaysOn)" I felt like I read mostly good feedback from different bloggers on the matter, coming from...

Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot

Monday, June 14, 2010

If you're following this blog, then you know that Sunday, May 30th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer's seminar on Data Integration in Large Organizations. I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture in Israel, I was like "What? Really? Like, Donald Farmer? Like THE...

Data mining in Excel 2007

Tuesday, June 1, 2010

Mr. Donald Farmer gave a lecture yesterday, May 31st 2010, at the Israeli BI User Group. This is what I summed up from the session. Predictive AnalyticsA good predictive analytics project would have:Actionable - you get useful information from itInnovative - gives something new, new insight from the modelTrustworthy - the model makes senseSeamless - part of your everyday operations, so that it will get used more easily by the users "All models are wrong, but some are useful" George BoxNo model is perfect, you can't predict everything, but even then the model is useful. Don't expect to build a perfect...

SSIS 2011 – what’s planned for the new version

Sunday, 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...