Why Put Your Database into Source Control?

Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood....

08 July 2014 7 min read

SQL Server

Saurabh Dhoble in SQL Server

Building a Custom SSIS Source Component in C#: PipelineComponent Inheritance, Metadata Definition, and GAC Deployment

Building a custom SSIS source component in C# - inheriting from PipelineComponent, implementing ProvideComponentProperties for metadata definition, PreExecute for initialisation,...

30 June 2014 22 min read

Robert Chipperfield

Introduction to Continuous Integration Servers

So you've got your database under source control, and now you want to start running automatic tests and builds with...

19 June 2014 15 min read

Tony Davis

Database Branching and Merging Strategies

Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free....

18 June 2014 23 min read

Database Administration

Jonathan Hickford in Database Administration

Database Migration Scripts: When to Write Them and How

Database migration scripts handle changes that automated sync tools can't infer - table renames, column splits, data migrations. Learn when...

17 June 2014 21 min read

Kalen Delaney

Row Versioning Concurrency in SQL Server

The optimistic concurrency model assumes that several concurrent transactions can usually complete without interfering with each other, and therefore do...

05 June 2014 44 min read

Konrad Lukasik

Configuration Management with PowerShell and XML

For the rapid delivery of any software application, there must be an effective configuration management system that is scripted. As...

03 June 2014 13 min read

Saurabh Dhoble

Setting Up Your SQL Server Agent Correctly

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges', and ensure...

28 May 2014 15 min read

Konrad Lukasik

Branching and Merging: Ten Pretty-Good Practices

In the course of rescuing a development from 'merge misery', it became increasingly apparent that there were a number of...

13 May 2014 10 min read

Robert Sheldon

SQL Server Source Control Basics

For efficient team-based database development, and reliable and repeatable database deployments, source control is not optional. This book provides just...

01 May 2014 3 min read

Joseph Moody

Managing Printers with Group Policy, PowerShell, and Print Management

Just because it is possible to do many configuration jobs 'click by bleeding click', doesn't mean that it is a...

24 April 2014 10 min read

Hugh Bin-Haad

We don’t need Source Control: we’re Database Developers

As part of our long-running series of articles where we ask working database developers how database source control improves their...

01 April 2014 7 min read

Matt Wrock

Automate the Complete Windows Environment Setup and Configuration

Boxstarter is an open-source application that enables you to do the unattended install of everything required to turn bare metal,...

25 March 2014 20 min read

Warwick Rudd

AlwaysOn Availability Groups – What Not to do when Adding Databases

SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are...

10 March 2014 10 min read

Feodor Georgiev

Collect Your SQL Server Auditing and Troubleshooting Information Automatically

If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of...

28 January 2014 12 min read

Dino Esposito

ASP.NET MVC Paging with OData

It is natural for the user to want to browse through data within an application. Until recently, the interfaces with...

16 December 2013 11 min read

Laerte Junior

The PoSH DBA – SQLPSX: SQL Server PowerShell Extensions

Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed...

10 December 2013 26 min read

Michael Sorens

PowerShell Data Basics: File-Based Data

One of the frustrations of anyone beginning with PowerShell is the simple task of getting data in and out. To...

03 December 2013 25 min read

Michael Sorens

Acceptance Testing with FitNesse: Debugging, Control Flow, and Tracing

FitNesse is an automated testing tool for software. based on Ward Cunningham's Framework for Integrated Test. It is designed particularly...

15 November 2013 12 min read

Annette Allen

SSIS Basics: Using the Merge Join Transformation

SSIS is able to take sorted data from more than one OLE DB data source and merge them into one...

16 October 2013 19 min read