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
Douglas Reilly Database Geek of the Week: Scott Forsyth Scott is the director of IT for a premier web hosting company called ORCS Web, and has spent a lot... 29 November 2005 12 min read
Douglas Reilly Database Geek of the Week: Adam Machanic Adam is a Microsoft MVP and a Microsoft Certified Professional. He speaks at Code Camps and has just become an... 22 November 2005 10 min read
Allan Mitchell DTS to SSIS Migration Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating... 18 November 2005 9 min read
Douglas Reilly Database Geek of the Week – Damian Mehers Damian Mehers created a tool called PromptSQL which brings Intellisense into the SQL Server world. … 26 October 2005 5 min read
Douglas Reilly Database Geek of the Week – Linchi Shea Linchi works at a major Wall Street firm and is responsible for SQL Server product engineering. He is a Microsoft... 17 October 2005 11 min read
Douglas Reilly Database Geek of the Week: Kent Tegels Kent Tegels is the man behind the Enjoy Every Sandwich blog on sqljunkies.com. He is also an author and an... 07 October 2005 14 min read
Douglas Reilly Database Geek of the Week: Itzik Ben-Gan Itzik Ben-Gan is a writer and mentor, he writes a monthly column for SQL Server Magazine and co-authored Advanced Transact-SQL... 05 September 2005 12 min read
Amirthalingam Prasanna Schema and metadata retrieval using ADO.NET How to obtain different types of information from your SQL Server 2000 database using ADO.NET 2.0, part of VS.NET 2005... 02 August 2005 7 min read
Simon Galbraith Attack of the predatory sales force Low-cost software is almost always a better solution, but if you must purchase the high-cost stuff, don't get caught with... 15 July 2005 8 min read
Hilary Cotter The identity crisis in replication This article discusses three common problems DBAs are likely to encounter when columns have an identity property that will auto-increment... 05 July 2005 16 min read
Douglas Reilly Geek of the Week – Wally McClure In addition to being a Microsoft MVP, Wally is an ASP Insider and one of the authors of a new... 19 May 2005 12 min read
Andy Warren Performance tuning tips for database developers Performance tuning is not easy and there aren't any silver bullets, but you can go a surprisingly long way with... 17 May 2005 4 min read
Simon Galbraith SQL Server Central Interview Steve Jones interviews Red Gate Software's Simon Galbraith and discusses Simon's current views on the industry.… 13 May 2005 1 min read
Douglas Reilly Database Geek of the Week – Hilary Cotter An interview with Hilary Cotter, a specialist in SQL Server full-text search and replication.… 11 May 2005 8 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
