Getting Started with Business Intelligence: Data Warehouse (T-SQL, Indexes, Isolation Levels and Performance)

Getting Started with Business Intelligence: Data Warehouse (T-SQL, Indexes, Isolation Levels and Performance)
5 (100%) 1 vote

Hello.

When we’re talking about Business Intelligence (BI), we straightly imagine all Kimball concepts, star-schema, the famous slow changing dimensions among others, but we forget where it all begins.┬áToday I will talk about some basic concepts (but quite important) in database concepts before things can start serious. The key points for this post are T-SQL, Indexes, Isolations Levels and Performance.

If you know how to answer the questions below, probably you should jump straight away to my next post I am going to post regarding this category.

Review questions: