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
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
