Robyn Page Robyn Page’s SQL Server Data Validation Workbench Robyn Page provides essential techniques for ensuring the validity of the data being entered into your SQL Server tables.… 11 December 2006 15 min read
Greg Larsen Building my First SQL Server 2005 CLR Greg Larsen provides a step-by-step tour of the hurdles he had to jump in building and deploying his first serious CLR stored procedure.… 06 December 2006 9 min read
Robyn Page Robyn Page’s SQL Server String Manipulation Workbench String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench...… 19 September 2006 23 min read
Pop Rivett Pop Rivett’s SQL Server FAQ Pop Rivett dispenses pearls of SQL Server wisdom, this time tackling the setting of variables from dynamic SQL. Bah, humbug.… 18 September 2006 3 min read
Robyn Page Robyn Page’s SQL Server DATE/TIME Workbench To celebrate the seventh anniversary of Robyn Page's classic workbench, Phil brings it right up to date. What starts as a gentle introduction to the... 16 August 2006 35 min read
Hilary Cotter SQL Server Full Text Search Language Features, Part 2 Extensive coverage of the query-time behaviour of SQL Server Full-text search, demonstrating how searches are expanded by the parser before hitting the full-text index.… 04 July 2006 13 min read
Learn SQL Server Douglas Reilly in Learn SQL Server SQL Server and .NET training and career development Part 3 How do you keep your skills current? How will you prepare yourself for what you will be doing 5 years from now? In this article,... 07 June 2006 11 min read
Hilary Cotter SQL Server Full Text Search Language Features SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large... 21 April 2006 24 min read
Learn SQL Server Douglas Reilly in Learn SQL Server SQL Server and .NET Training and Career Development (part 2) In Part I of this series, I discussed the role and value of conferences in the career development of SQL Server and .NET developers. In... 22 March 2006 15 min read
Learn SQL Server Douglas Reilly in Learn SQL Server SQL Server and .NET Training and Career Development A number of years ago, I wrote a blog entry entitled "Who is Responsible for your Career?". It was perhaps the second most popular post... 24 February 2006 15 min read
