Tony Davis

Shawn McGehee

Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth

You've just become responsible for a database, only to find that the log file is growing out of control. Why...

14 March 2013 13 min read

James Gilmore

Profiling PowerShell cmdlets with ANTS Performance Profiler

Following the early lead of Exchange Server 2007, Citrix’s XenDesktop SDK (which I was fortunate enough to work on), and...

13 March 2013 3 min read

Melanie Townsend

An eBook by any other name, would be just as useful

UPDATED March 26 The Red Gate team is compiling an eBook of SQL performance tips and we want YOUR help....

13 March 2013 3 min read

Dominic Delmolino

Bridging the Developer/DBA Divide: Advances in Database Source Control

For over 10 years now, I’ve been a huge advocate of integrating database development, design and architecture practices into application...

13 March 2013 7 min read

Jan Leers

Introduction to Table Partitioning

Divide and conquer is what Oracle was thinking with this one. Table partitioning is about optimizing “medium selectivity queries”. The...

07 March 2013 8 min read

Alex Davies

Chunks of development work are like database transactions

I noticed something recently, that I was using exactly the same logic in two seemingly unrelated aspects of my job....

07 March 2013 4 min read

Phil Factor

Project Mismanager

In IT, it is difficult to measure individual productivity, and it is particularly difficult to determine whether a project manager...

07 March 2013 10 min read

Jeremy Jarrell

Speeding up your application with the IIS Auto-Start feature

Red Gate recently polled the ASP.NET developer community for tips on improving the performance of ASP.NET web applications. The result...

05 March 2013 6 min read

Ben Emmett

Join us for a bug hunt – there are prizes!

Join us right now on Google Hangouts: https://plus.google.com/events/cq2p82jvkp7i0fsl9v8faq09qig Testers need to have creatively nefarious minds; abusing applications in ways which...

05 March 2013 2 min read

Seth Delconte

Ad-Hoc XML File Querying

When you need to shred just part of the data within a large XML file into a SQL Server table,...

05 March 2013 15 min read

Fabiano Amorim

Join Reordering and Bushy Plans

Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from...

05 March 2013 17 min read

Robert Sheldon

SQL Server 2012 Window Function Basics

For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard....

05 March 2013 21 min read

Jonathan Allen

SQL Saturday Exeter is next weekend

There is still time to register for the Friday and/or Saturday, follow the links below and join us for...

03 March 2013 1 min read

Satishbabu Gunukula

Oracle Database Source Control made easy using Red Gate’s new tool

Red Gate is launching new tool “Source Control for Oracle tool” on March 12, 2013. How this tool can help...

01 March 2013 2 min read

Tony Davis

Aversion to Version Control

Why shouldn’t we enjoy the benefits of distributed version control systems (DVCS) on Windows? I agree that we’ve made a...

28 February 2013 3 min read

Jonathan Lewis

Compression in Oracle – part 5: Costs of Index Compression

In the previous article in this series we looked at index compression, and the way in which Oracle stored index...

27 February 2013 13 min read

Alexander Karmanov

Automating SQL Server Database Deployments: A Worked Example

Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it...

27 February 2013 21 min read

Michael Williamson

Phil Wise

Bureaucracy-Free Software Development

Could it be that, if you adopt Test Driven Development, Continuous Integration and Continuous Deployment, then much of the bureaucracy...

27 February 2013 14 min read