Browse by Tags
All Tags »
Donald Farmer (
RSS)
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...
If you're following this blog, then you know that Sunday, May 30 th 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...
Mr. Donald Farmer gave a lecture yesterday, May 31 st 2010, at the Israeli BI User Group. This is what I summed up from the session. Predictive Analytics A good predictive analytics project would have: Actionable - you get useful information from it Innovative - gives something new, new insight from the model Trustworthy - the model makes sense Seamless - 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...
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...
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...
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 assemblies VSA 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 Connect Data Flow Data Connect...
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...