Database DevOps William Brewer in Database DevOps DevOps and Database Lifecycle Management Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective... 18 November 2016 13 min read
General Vishwas Parameshwarappa in General Setting up developer workstations On both Windows and Linux, the chore of setting up developer workstations can take several days, and there always seem... 17 November 2016 13 min read
Database DevOps Grant Fritchey in Database DevOps SQL Server Database Provisioning Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and... 04 November 2016 8 min read
Database DevOps William Brewer in Database DevOps Questions About SQL Server Security and Access Control You Were Too Shy to Ask For many developers, database security and Access control is just something that gets in the way of development work. However,... 04 November 2016 23 min read
Database DevOps Daniel Nolan in Database DevOps How to Fix Ten SSDT Deployment Snags, With or Without ReadyRoll Even a database development framework like Sql Server Data Tools (SSDT) doesn't get it right all the time, and there... 21 October 2016 18 min read
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