Nigel Rivett Creating CSV Files Using BCP and Stored Procedures Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing on a stored procedure approach... 20 November 2006 13 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No.5: Pop on the Audit Trail Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables… 03 November 2006 7 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No.4: Pop does Log Shipping Pop Rivett demostrates the fine art of log shipping in SQL Server.… 30 October 2006 8 min read
Kirk Haselden SQL Server 2005 SSIS: Tuning the Dataflow Task Learn how to get maximum performance out of the dataflow task with an extract from Kirk Haselden's popular book on... 23 October 2006 18 min read
Phil Factor More Database Administration and Development Automation using DMO Phil Factor provides a handy DMO automation toolkit to take care of some core SQL Server administrative tasks.… 04 October 2006 2 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No2: Pop Backs Up Pop leaps into action to safeguard a young girls's data...… 22 September 2006 5 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... 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
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
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
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
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
