Phil Factor Writing to Word from SQL Server Never a man to walk away from a challenge, Phil Factor set himself the task of automating the production of... 06 March 2007 7 min read
Phil Factor Robyn Page SQL Server Security Workbench Part 1 Robyn Page and Phil Factor present practical T-SQL techniques for controlling access to sensitive information within the database, and preventing... 06 March 2007 17 min read
Grant Fritchey SQL Server Error Handling Workbench Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000... 20 February 2007 15 min read
Phil Factor Robyn Page SQL Server Excel Workbench The need to produce Excel reports from SQL Server is very common. Here, Robyn Page and Phil Factor present practical... 06 February 2007 15 min read
Eric Brown Encryption without the Confusion Eric Brown demonstrates some practical encryption techniques in SQL Server 2005, to protect both your objects and your data.… 29 November 2006 14 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
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
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
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 Managing database changes Stored procedures are not the be-all and end-all of managing changes in a database, but they can be very important... 11 May 2005 8 min read
Douglas Reilly To SP or not to SP in SQL Server There have been a number of discussions about whether to use SPs or not, often shedding more heat than light,... 11 April 2005 16 min read
