Grant Fritchey 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
Saurabh Dhoble Developing a Custom SSIS Source Component SSIS was designed to be extensible. Although you can create tasks that will take data from a wide variety of... 30 June 2014 21 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 14 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
Jonathan Hickford Using Migration Scripts in Database Deployments A SQL migration script is similar to a SQL build script, except that it changes a database from one version... 17 June 2014 20 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
