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.…

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...

String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's...

Pop Rivett dispenses pearls of SQL Server wisdom, this time tackling the setting of variables from dynamic SQL. Bah, humbug.…

To celebrate the seventh anniversary of Robyn Page's classic workbench, Phil brings it right up to date. What starts as...

Extensive coverage of the query-time behaviour of SQL Server Full-text search, demonstrating how searches are expanded by the parser before...

Douglas Reilly in Learn SQL Server

How do you keep your skills current? How will you prepare yourself for what you will be doing 5 years...

SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient...

Douglas Reilly in Learn SQL Server

In Part I of this series, I discussed the role and value of conferences in the career development of SQL...

Douglas Reilly in Learn SQL Server

A number of years ago, I wrote a blog entry entitled "Who is Responsible for your Career?". It was perhaps...