A collection of links which I have found extremely useful or to which I come back time after time
- The Only Interview Question That Matters This single question provides the depth and breadth of insight needed to reach a fast, unanimous Hire/Don't Hire decision.
-
The curse and blessings of dynamic SQL How you use dynamic SQL, when you should – and when you should not.
-
Arrays and Lists in SQL Server Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods. Two versions are available, one for SQL 2005 and one for SQL 2000 and earlier.
-
Error and Transaction Handling in SQL Server Article about error and transaction handling in SQL Server
- Practical PowerShell for SQL Server Developers and DBAs – Part 1 There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael explains how to install it, what it is, and some of the excellent things it has to offer.
- R Programming Language - Introduction to R for C# Programmers Introduction to R for C# Programmers
- 29 Books That Will Enrich Your Inner Literati For anyone who wants to attain the vaunted title of “being well-read,” it’s more about breadth than depth