Database DevOps Phil Factor in Database DevOps But the Database Worked in Development! Preventing Broken Constraints Database table constraints such as foreign keys and default values ensure reliability of the data. In this article, Phil Factor... 08 January 2020 19 min read
Editorials Kathi Kellenberger in Editorials Why the Database Must be Part of DevOps According to Microsoft, DevOps is “the union of people, process, and products to enable continuous delivery of value to our... 01 January 2020 3 min read
Database DevOps Robert Sheldon in Database DevOps 10 Guidelines for Implementing DevOps Robert Sheldon discusses ten guidelines for implementing DevOps, helping organizations get started improving their application delivery processes.… 12 November 2019 13 min read
Database DevOps Robert Sheldon in Database DevOps DevOps Database Delivery Robert Sheldon explains the difference between state based and migrations based DevOps database delivery and the benefits of each.… 17 October 2019 13 min read
Database DevOps Rahul Varshneya in Database DevOps Establishing a DevOps Organization In this article, Rahul Varshneya explains some of the benefits and reviews the stages of establishing a DevOps organization.… 08 October 2019 7 min read
Editorials Kathi Kellenberger in Editorials The Data-Philes Team Meet the Time Traveler The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent... 11 September 2019 4 min read
Database DevOps Robert Sheldon in Database DevOps Database DevOps Robert Sheldon discusses the challenges involved with including the database in the DevOps pipeline and how to overcome them in... 08 August 2019 12 min read
Database DevOps Adam Hafner in Database DevOps Database unit testing As database changes are added to the DevOps pipeline, database unit testing becomes crucial. In this article, Adam Hafner describes... 30 May 2019 14 min read
Editorials Kathi Kellenberger in Editorials Why DBAs Must Embrace DevOps A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement... 09 May 2019 3 min read
Editorials Kendra Little in Editorials What is Automation? Today I got a bit closer to a meaningful definition of automation as it applies to the software development process.... 30 April 2019 5 min read
Database DevOps Grant Fritchey in Database DevOps DevOps Without the Database: A Cautionary Tale Communication is the foundation of DevOps. Grant Fritchey tells the tale of a project that failed because of previous communication... 07 February 2019 12 min read
Oracle Samuel Nitsche in Oracle Strongholds of Confidence: Self-Testing Your Database Unit testing and even Test-Driven Development is possible for databases. In this article Samuel Nitsche makes the case for introducing... 04 April 2018 17 min read
Database DevOps Phil Factor in Database DevOps Scripting the Description of Database Tables Using Extended Properties Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and... 03 March 2018 28 min read
Database DevOps Ben Brumm in Database DevOps Introduction to Agile with SQL Server Working with SQL Server in Agile software development can be difficult. Ben Brumm provides an overview of Agile, specifically Scrum,... 20 December 2017 12 min read
Tools Grant Fritchey in Tools Automated Database Provisioning for Development and Testing If your development team needs to work on anonymised copies of the current production database, and if changes are being... 02 August 2017 10 min read
Database DevOps William Brewer in Database DevOps Database Code Analysis Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the... 20 June 2017 12 min read
Database DevOps Edward Elliott in Database DevOps Continuous Database Deployment with Confidence To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for... 19 May 2017 13 min read
Opinion Pieces William Brewer in Opinion Pieces Personal Data, Privacy, and the GDPR Now that there have been well-publicised examples of the awful consequences of data breaches and data misuse, there is increasing... 10 May 2017 22 min read
Database DevOps Edward Elliott in Database DevOps A DLM Approach to Database Testing Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more... 13 April 2017 45 min read
Database DevOps Phil Factor in Database DevOps Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot When you are automating a number of tasks, or performing a batch of tests, you want a way of automating... 27 March 2017 12 min read
