DCSIMG
May 2007 - Posts - Ella Maschiach's BI Blog

Ella Maschiach's BI Blog

BI, Olap Technologies, Tools, System Analysis and Design

News

About Ella Maschiach

Business Inteligence

May 2007 - Posts

Katmai - SqlServer 2008

The future is here! The future is now!

So, for a minute there I was feeling like I was at the fore front of technology, working on the SQL Server 2005 platform. But soon enough that too might be out of date ;)

Microsoft had just announced a new SQL Server 2008 called "Katmai".
The new platform is advertised as having:

  1. Mission critical platform for all – providing a more secure platform and less time demanding in the field of data infrastructure management.
  2. Beyond relational – allowing developers to use any type of data from xml to documents
  3. Redefining pervasive insight – integrating data into scalable DWH and integrating reports with Microsoft Office.
  4. Dynamic development for data management solutions- providing integrated development with the .Net Framework 3.0.

I think what I liked best about it is a new concept called LINQ which they’re advertising. According to the datasheet, it will enable developers to define business entities (like Product) using Entity Data Model. I find that very consistent with the Kimball Method which argues that a Business Entity should group all of its own attributes.

Also interesting is the spatial data types moving the geographical information forward.
All in all, good news… and more to learn!

The platform is suppose to air in 2008.

For further details see:     
http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx

Hello World

Hi, my name is Ella Maschiach and I am a System Analyst and OLAP Developer. I Have supervised over several BI projects.
During the time I have gained vast experience in Business Intelligence tools and methodologies. Kimball's books are the main stream books with which I work.
Among these books are The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) and The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset. Having my Masters from the Management School in Tel Aviv University, she strives to excel herself to higher positions.  

As every first lesson in programming goes, I have decided to make my first post quick and easy, a small appetizer to start your taste buds and also let me just slowly dip my feet in the water, before diving in...

So who am I? (A very good question btw)

I have studied Industrial Engineering in the Tel Aviv University, majoring in Information Systems. That paved the way to work in the field of BI. I started off as a system analyst following the Kimball discipline. I have slowly built myself up to a place where I supervise over my very own projects. I am currently working with an SQL Server 2005 Platform and using Panorama web access reports. In my previous work place I have worked with Business Objects which resided on an Oracle DB.

I'm here to share my knowledge and experience in the BI field. 

Hope to see you next time,
Ella