Articles tagged

21 February 2014
21 February 2014

Rapid SQL Server Database Deployment

With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software. Tony Davis explains.… Read more
13 December 2012
13 December 2012

The Benefits of Regular Deployment

When developing software, it makes sense to 'fail early, fail often'; to become aware of mistakes quickly and to learn from them. This means being able to deliver software as early in development as possible. This makes it easier to gather opinions and promote discussions with the people who would want to use the application; and then respond to the feedback. … Read more
23 March 2011
23 March 2011

The unnecessary evil of the shared development database

One of the greatest pain-points in developing a database-driven application happens when the application is in source control,but the database isn't. When the development database is shared, the pain increases, and it is not alleviated by source control alone. Troy Hunt spells out why each database developer must have their own version of the database. … Read more
16 February 2011
16 February 2011

Red Gate’s new Scary DBA: Coming to a town near you

Grant Fritchey, The Scary DBA, has now taken the leap from being a Simple-Talk author and FoRG(Friend of Red Gate) to being employed by Red Gate as 'product evangelist'. As Bob Cramblitt finds out, it means that Grant gets more time to do what he enjoys doing; talking and writing about SQL Server topics that fascinate him, such as query tuning, execution plans, performance monitoring and backups. … Read more
08 December 2010
08 December 2010

Foolproof Atomic Versioning of Applications

Bad things tend to happen to developments where the scripts for the database layer are left out of source control. Now that we have the means to do it properly, there are many reasons to make the database an equal partner in the development process. Troy discusses some of those reasons. … Read more
10 August 2010
10 August 2010

Optimizing my client and server with ANTS Performance Profiler

It might seem a hopeless task to reduce the time an application takes to do a task from three minutes to a second. However, after getting hold of a tool that showed him precisely what was taking the time, Jonathan Evans gained a renewed fascination with performance that led to him shaving what he terms the "banana seconds" off the execution time down to that last second. … Read more