#SqlServer Interview question: What is Usage Based Optimization in SSAS? How is it performed?

Usage Based Optimization is the process of defining aggregation design based on the actual queries executed by the users/applications accessing the cube, which is captured using a log. Continue reading #SqlServer Interview question: What is Usage Based Optimization in SSAS? How is it performed?

.Net Interview question: What is LINQ?

Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping (O/RM) framework provides the following basic features: Continue reading .Net Interview question: What is LINQ?

#Thresqlips series #XML, Auto & Path – Episode 2

Welcome back to the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series #XML, Auto & Path – Episode 2

SSAS Interview question: What are aggregates? What is the purpose of defining an aggregation design in Analysis Services?

Aggregates are summarized values, each of which corresponds to a combination of an attribute from each dimension and a measure group. An aggregate in SSAS is the differentiating factor between OLAP and OLTP, and is the fundamental principle of SSAS/OLAP, which offers blazing fast performance. Continue reading SSAS Interview question: What are aggregates? What is the purpose of defining an aggregation design in Analysis Services?

Banking OLTP Databases, Datawarehouses & Dimensions

In last week’s article “What an ODS is and how should you use it” I’ve explained the concept of an Operational Data Store and how it fits in the overall data warehouse picture.

Today I’m going get into the specific characteristics of OLTP Databases versus Data Warehouses and how the dimensional model fits into the overall picture in the interesting world of investment banking data warehouse and business intelligence reporting. Continue reading Banking OLTP Databases, Datawarehouses & Dimensions

%d bloggers like this: