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.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 17 of 31
Frequently Asked Questions Day 17: how to handle errors in SQL Server 2008 with TRY…CATCH, and what RAISERROR does, in my interview series.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31 – CTE- Joins
Day 16 of my interview questions and answers series covers CTE and joins, starting with why a CTE makes complex queries easier to read and maintain.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 15 of 31
Frequently Asked Questions Day 15: what Service Broker is, and where SQL Server stores usernames and passwords, with clear interview answers.