Database DevOps Phil Factor in Database DevOps Reading, Writing, and Creating SQL Server Extended Properties There is a great gulf between wanting to document your database properly with extended properties and actually doing it. Extended... 21 October 2016 22 min read
Database DevOps Hari Yadav in Database DevOps Master Data Services – The Basics Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained,... 07 September 2016 16 min read
Database DevOps Hari Yadav in Database DevOps Master Data Management (MDM) Using SQL Server So many of the problems that organisations have with their IT applications are due to the struggle with data, in... 10 August 2016 13 min read
Database DevOps Sudha Rani Polapragada in Database DevOps Web.config and Entity Framework Transformation Process When it comes to releasing and delivering an Entity Framework application, you will be faced with the problem of deploying... 12 July 2016 20 min read
Platform as a Service Robert Sheldon in Platform as a Service Windows Containers and Docker Windows Server 2016 features support for containers. These are not Linux-based, but containers that run on Windows and run Windows... 04 July 2016 11 min read
William Brewer Planning for a Successful Database Lifecycle Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture,... 09 June 2016 35 min read
Knut Jürgensen Master Data Management (MDM): Help or Hindrance? Knut Jürgensen shares his experiences, both positive and negative, with regard to the function that Master Data Management fulfils within... 16 May 2016 22 min read
Matthew Skelton Database Version Control By placing under source control everything we need to describe any version of a database, we make it much easier... 24 March 2016 34 min read
Elizabeth Ayer The Comeback of Migrations-Based Deployments With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which... 17 March 2016 11 min read
Matthew Skelton Database Lifecycle Management for ETL Systems Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL... 16 March 2016 32 min read
Matthew Skelton Database Migrations: Modifying Existing Databases It should be simple to upgrade a database to a new version. It certainly can be, but if you need... 09 March 2016 34 min read
Matthew Skelton Issue Tracking for Databases Any database development project will be hard to manage without a system for reporting bugs in the code, anomalies and... 25 February 2016 20 min read
Grant Fritchey Better Ways to Build a Database The purpose of a database build is simple: prove that what you have in version control can successfully create a... 19 February 2016 40 min read
Peter Gerrard Jodie Beay and the Deployment of the Cross-Database Dependency When you use AdventureWorks as a practice database, have you ever looked at the code and thought 'what idiot did... 03 November 2015 13 min read
Sjors Takes Implementing Continuous Integration for Databases Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated... 02 November 2015 8 min read
Jason Crease Writing Build vNext tasks for Visual Studio Online Hosted TFS, now called Visual Studio Online (VSO), has a new way of writing build processes called Build vNext. Agent... 09 September 2015 9 min read
Frazier Kendrick Stumbling Towards Database Change Management The scale of change in the insurance and financial markets is such that there is little time for the application... 09 September 2015 22 min read
Edward Elliott Non-Breaking Online Database Deployments For an experienced database developer, the idea of doing non-breaking database deployments while the database is still online holds respect... 21 July 2015 11 min read
Tim Hidalgo Managing Test Data as a Database CI Component – Part 2 Once you're clear about what data the developers and testers need to be able to be effective, you have several... 28 May 2015 10 min read
Seb Rose What is Behaviour Driven (Database) Development? Behaviour Driven Development is not always clearly understood, and the term is particularly unfamiliar in database circles. Seb Rose introduces... 05 March 2015 16 min read
