Notes from my meeting with outsourcing managers in Ahmedabad on IT outsourcing to India: quality of products, quality of developers and why companies outsource.
SQL SERVER – Grouping JOIN Clauses In SQL
Ben Nadel wrote a good article on grouping JOIN clauses in SQL, a powerful trick for mixed table relationship rules. The comments are worth a read too.
SQL SERVER – Q and A with Database Administrators
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 – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator
My article in SQL Server Magazine December 2007 helps you brush up on FILLFACTOR, ISNULL, NULLIF and % as a wildcard and operator. The link has since moved.
Finding the Right System View for the Question You Have
Choose SQL Server system views by the question they answer, distinguish catalog metadata from runtime counters, and understand reset boundaries.
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 – Correct Syntax for Stored Procedure SP
What is the correct syntax for stored procedure code? Anything between BEGIN and END is part of the procedure, and anything after GO is not, as my examples show.
SQL SERVER – 2005 – List All Stored Procedure in Database
Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.
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.
SQLite or SQL Server Express for a Small App
SQLite or SQL Server Express depends on write concurrency, deployment, backup, and the growth path your small application really needs.