Articles having tag: SQL TOOLS

Checking Out SQL Backup Pro 7’s New Automatic Backup Verification

Wouldn't it be great to offload the daily chore of checking the integrity of your production databases, and checking that your backups can successfully be restored. It can be done, and managed automatically too, in one process; as Brad explains.

The PoSh DBA: Grown-Up PowerShell Functions

By Laerte Junior

Laerte goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more effective in helping to automate many of the working DBA's...

SQL Scripts Manager and IronPython

By Timothy Wiseman

As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows even more sophisticated scripting possibilities for managing automated database tasks.

Using SQL Test Database Unit Testing with TeamCity Continuous Integration

By Dave Green

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

SQL Cop Review

By Grant Fritchey

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

SQL Test: Seeing Red Change to Green

By Rob Sullivan

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

SSMS Tools Pack 2.0

By Grant Fritchey

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. Malden Prajdic certainly did, which is why he developed his free SSMS Tools Pack. Now on its second version, Grant Fritchey...

Implementing Checkpoints in an SSIS Package

By Robert Sheldon

Like any other application, an SSIS package can fail. Once the problem has been resolved, you'll usually restart the package, but if you implement SSIS checkpoints, then you have another option: you can restart from the point of failure.

SQL# (SQLsharp): A Review

By Grant Fritchey

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

Agile Techniques for developing SQL Source Control

By Richard Morris

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