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...
מעבר ל PowerPivot , מתן כח נוסף למשתמשים מתקבל גם ב Report Builder 3.0 . אחד מהחידושים של SQL Server 2008 R2 הוא MDS – Master Data Services . מטרתו ניהול המידע בכל הארגון והבטחת עקביות ואיכות המידע בכל מאגרי המידע. חשיבות ה Data Warehouse היא בכך שהוא מאחסן מידע היסטורי כולל עבור הארגון, שהוא גם מידע נקי. ה MDS נוצר מתוך חשיבות שיתוף המידע הנקי בין כלל המערכות בארגון. MDS מכיל בתוכו שלושה שלבים: Import and Integration Modeling Export and Subscription חלק מה modeling הוא tracking of instances כלומר...
Microsoft just released SQL Server 2008 R2 November CTP. The November CTP is "feature complete" so this should be close to the real thing, before they ship SQL Server 2008 R2 in 2010. I guess you could tell from the news coming from PASS that this would be in the wings. First of all, there was word that the next CTP would be delivered during November (which translates to: now!) and secondly, projects that before would be code named - now have their formal name. Madison is now Parallel Data...