My Q and A with Database Administrators from interviews in India: the technical questions we discussed and my opinion on each, with a link to the full article.
SQL SERVER – Database Interview Questions and Answers Complete List
My Database Interview Questions and Answers series in one list, from the introduction through part 6, plus a complete list download and a link to the update.
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.
SQLAuthority News – Best Articles on SQLAuthority.com
Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility
A list of my best articles so far, from killing all processes in a database and shrinking the log file to deleting duplicate rows and UNION vs UNION ALL.
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
My Data Warehousing interview questions and answers complete list, with links to every part of the series and one PDF to download.
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.