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
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
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
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
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
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
Brian Moran Tracking tempdb growth Runaway tempdb growth can be a problem, so how do you track its growth and correlate the growth to specific... 11 April 2005 4 min read
Phil Basham Return on investment How to justify the purchase of a new software development tool. You might believe the benefits are obvious, but others... 13 April 2004 8 min read
Simon Galbraith Take emotion out of software purchasing decisions Do you find indecision each time a purchase decision needs to be made, a requirements analysis can help you provide... 13 October 2003 1 min read