Articles tagged

28 August 2012
28 August 2012

Registered Servers and Central Management Server Stores

SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered Servers are typical: poorly documented, but essential for the busy DBA, since they are easily scriptable via TSQL or PowerShell as well as the SSMS GUI, to access groups of servers to perform a wide range of tasks.… Read more
26 July 2012
26 July 2012

Database Build and Release with Jenkins

One of the frustrations of implementing a Continuous Integration (CI) system is understanding how the individual components of the workflow work together to contribute to the process. The software engineer for a successful system describes how his team designed and use a useful CI system based on Jenkins, Subversion and Red Gate Tools. … Read more
02 February 2012
02 February 2012

Using SQL Test Database Unit Testing with TeamCity Continuous Integration

With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles, but how, exactly? Dave Green describes a successful process that integrates third-party tools.… Read more
19 January 2012
19 January 2012

SQL Cop Review

Static code analysis is used a lot by application programmers, but there have been surprisingly few tools for SQL development that perform a function analogous to Resharper, dotTest, or CodeRush. Wouldn't it be great to have something that can indicate where there are code-smells, lapses from best practice and so on, in your Database code? Now there is. … Read more
13 December 2011
13 December 2011

SQL Test: Seeing Red Change to Green

Now that we have some very good test frameworks for SQL Server, particularly tSQLt, all that was missing was a way of running your unit tests from within SQL Server Management Studio, and 'seeing red change to green'. Now the wait is over, with the arrival of SQL Test in preview. Rob Sullivan is one of those users who are helping shape the way that SQL Test develops, and explains what is going on, and why.… Read more
26 October 2011
26 October 2011

SSMS Tools Pack 2.0

If you work with SSMS, you'll know how frustrating it can be when tasks you perform every day aren't part of the core features. Mladen Prajdic certainly did, which is why he developed his free SSMS Tools Pack. Now on its second version, Grant Fritchey explains the functionality of this great free plugin.… Read more
13 September 2011
13 September 2011

SQL# (SQLsharp): A Review

Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you're a DBA or developer, there are plenty of times when a CLR routine will save a lot of time, and occasionally provide new functionality.… Read more
03 August 2011
03 August 2011

Agile Techniques for developing SQL Source Control

In this interview, Stephanie Herr, Development Manager for SQL Tools at Red Gate, talks about the recent SQL Source Control development project. As a certified Scrum Master, Stephanie was keen to use Agile techniques throughout the development process, and she explains how the team maximized user feedback and ensured that customers got what they wanted, as quickly as possible.… Read more
10 June 2011
10 June 2011

Fast and Free; SQL Scripts Manager’s Script Generator

When William produced his second article on the free tool 'SQL Scripts Manager', revealing that it worked just as well with PowerShell and Python scripts as it does with TSQL, he thought that would be the end of the series. Oh no; in response to feedback, comes a small add-in called 'Script Generator' that makes a big difference to the speed of developing and producing new scripts. … 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