‘Sql Server 2008’ Archives
Data Architect – Overview
Many times in the job descrition a title Data Architect is used. According to DAMA (Data Management Association) , Data Architect is often interchangeable with, but includes enterprise architecture considerations. A DAMA recognized Certified Data Management Professional would have a wide range of such skills. Translating this to Data [...]
Report Model – Business Intelligence Development Studio 2008
Report Model is a project type in Business Intelligence 2008. It is metadata description of data objects and the relationship between the data in the underlying source. Report model expose the data objects and relationship from the data sources as entities and relationships logically grouped together. These entities and relationship are easy to [...]
SQL Server Studios Overview
This post is in continuation of previous post of June 11th 09 SQL Server 2008 Express Edition with advanced service - Our experiance so far we have not been able to attach adventure works database due some unknown technicalities in 2008 SQL server studio and Business intelligence studio, despite innumerable readings on technical documentation. We [...]
SQL Server 2008 Express Edition with advanced service – Our experiance
Today we downloaded the SQL Server 2008 Express edition with advanced services. As mentioned on Microsoft website - Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to use version of SQL Server Express that includes more features and makes it easier than ever to start developing powerful data-driven applications for the [...]
Using Derived tables
In Sql language this is very common to use views instead of tables directly, for example we can create view; View_MarketingEmployees ; CREATE VIEW View_MarketingEmployees AS SELECT * FROM Employee WHERE department = "marketing" GO Then If we wanted to see all of the Employees from Marketing with the First name John, ordered [...]
OLTP and OLAP – contrast
Found another useful information highlighting difference between OLAP and OLTP in Delivering business intelligence with SQL Server 2008 by Brian Larson. OLTP build around the normalized data and dependencies are represented by complex foreign key relationships; the goal is to reduce redundant data. In OLAP just the opposite is true. [...]
