A guest post by Rick Morelan, author of the Joes 2 Pros series, on the few interview questions that come up again and again and separate good answers from great.
SQL SERVER – Interview Questions and Answers – Guest Post by Malathi Mahadevan – Day 26 of 31
Malathi Mahadevan’s guest post for my interview questions and answers series: why interviewers ask about your toughest challenge at work and how to answer.
SQL SERVER – Azure Interview Questions and Answers – Guest Post by Paras Doshi – Day 25 of 31
Paras Doshi’s Azure interview contribution remains part of the 2011 series. Historical answers are clearly separated from current editorial context.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehousing Concepts Day 24 of 31
Data warehousing concepts Day 24 interview questions: hybrid slowly changing dimensions, BUS schema, star schema and snowflake schema.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehousing Concepts Day 23 of 31
Data warehousing concepts Day 23: what ETL is and how the extract, transform and load steps work together, as interview questions and answers.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehousing Concepts Day 22 of 31
Data warehousing concepts Day 22 interview questions: what OLTP and OLAP are, and the main differences between the two.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehousing Concepts Day 21 of 31
Interview questions on data warehousing concepts Day 21: what a data warehouse is and why analysts use one for complex queries and analysis.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 20 of 31
Frequently Asked Questions Day 20 explains the key Policy-Based Management terms in SQL Server: target, facet, condition and policy.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 19 of 31
Frequently Asked Questions Day 19: tracking changes with Change Data Capture, what CPU pressure means and how to get data from another server.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 18 of 31
Frequently Asked Questions Day 18: copy data from one table to another with INSERT INTO SELECT or SELECT INTO, and learn what catalog views are.










