What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
SQL SERVER – Generic Architecture Image
A Generic Architecture image of SQL Server I found on Wikipedia, with a short note on physical storage in MDF and LDF files and how data is grouped logically.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.
SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
Business Intelligence basic terms explained in plain words: BI, data warehouse, data mart, cube and more, so the BI vocabulary is easier to follow.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
Data Warehousing Interview Questions and Answers Part 3 explains slowly changing dimensions: SCD1, SCD2, SCD3 and hybrid SCD, and what each one keeps.
SQL SERVER – Data Warehousing Interview Questions and Answers Part 2
Data Warehousing Interview Questions and Answers Part 2: normalization forms, fact and dimension table keys, data mining, view vs materialized view and ER diagrams.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
Part 1 of my Data Warehousing interview questions and answers, starting with the basics: what a data warehouse is and how it supports decision making.