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... 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
Damon Armstrong .NET Application Architecture: Logging SQL Exceptions in the Data Access Layer Damon Armstrong demonstrates an efficient way to capture and manage SQL exceptions in your .NET application, by adding a SQL... 11 September 2006 35 min read
Douglas Reilly Database Geek of the Week: Kirk Haselden Author and SQL Server development manager, Kirk Haselden, talks about SSIS, gruelling interviews on an empty stomach, and his role... 07 September 2006 9 min read
Nigel Rivett Executing SSIS Packages Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS control package, a... 30 August 2006 8 min read
Tony Davis SQL Server, PostgresSQL and Fish Curry An interview with Adam Machanic, discussing hot new features of SQL 2005, stored procedures, fish curry and mor… 16 August 2006 18 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... 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... 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... 07 June 2006 11 min read
Adam Machanic To SP or not to SP in SQL Server: an argument for stored procedures A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve... 06 June 2006 12 min read
Tony Davis SQL Bundle 5: the developer’s perspective Last month saw the release of the SQL Bundle 5. Here, some key members of the Red Gate development team... 17 May 2006 11 min read
Grant Fritchey SQL Server Performance Testing When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound... 15 May 2006 2 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... 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... 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... 24 February 2006 15 min read
Arthur Fuller Intelligent Database Design Using Hash Keys Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or... 17 February 2006 5 min read
Douglas Reilly Database Geek of the Week – Michael Rys Dr. Michael Rys is the program manager for the SQL Server Engine Team at Microsoft, represents Microsoft on the W3C... 06 February 2006 8 min read
Arthur Fuller A case for canned SQL Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many... 18 January 2006 4 min read
Phil Factor Cursors and embedded SQL The database mole turns his attention to take a look at cursors and embedded SQL… 19 December 2005 7 min read
Douglas Reilly Database Geek of the Week: Peter DeBetta Peter runs a consulting firm that develops data-driven enterprise solutions, he is also a programming instructor for Wintellect and a... 13 December 2005 9 min read
