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
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
Douglas Reilly Database Geek of the Week – Glenn Johnson Meet Glenn Johnson; he runs Glenn Johnson Technical Training and has just written "Programming Microsoft ADO.NET Applications - Advanced Topics".… 04 April 2006 13 min read
Douglas Reilly Database Geek of the Week – Tom Moreau "In grad school, I had a temporary assignment as director of the undergrad labs, where I had to manage the... 13 March 2006 13 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
Phil Factor Survival tips for powerpoint The Database Mole Presents Survival tips for PowerPoint boredom… 17 January 2006 7 min read
Douglas Reilly Database Geek of the Week: Dave Sussman Dave Sussman is one of the ASP Insiders, and a well-known author and speaker.… 21 December 2005 10 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
Phil Factor Secrets of successful IT projects The database mole shares his secrets of successful IT projects, and pitfalls to avoid.… 17 November 2005 11 min read
Douglas Reilly Database Geek of the Week: Jim Hoffman Jim Hoffman is chief operating officer of Innovative Health Solutions, a company that creates web-based solutions for healthcare providers. … 09 November 2005 6 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
Amirthalingam Prasanna ADO.NET 2.0 Factory Classes This article explains how to use .NET 2.0's data provider factory classes to develop a pluggable data layer that is... 25 October 2005 6 min read
Phil Factor The database mole Bogus resumes and unblushing lies: navigating the database hiring waters and selecting a development team.… 18 October 2005 10 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: Gary Mallow Gary is director of a group of developers who build applications, sometimes using .NET and often using Oracle as a... 13 September 2005 8 min read