Database DevOps Margaret Cruise O'Brien in Database DevOps Introducing DLM Techniques for a Multi-Database Multi-Server System Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems,... 09 March 2017 18 min read
BI Nat Sundar in BI Deploying Multiple SSIS Projects via PowerShell When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as... 27 February 2017 29 min read
Database DevOps Bob Walker in Database DevOps Introducing a DevOps Workgroup to Farm Credit Services of America If you are introducing DevOps workflows into a large organization, you’ll need to plan carefully and prioritize tasks, adapt, maintain... 16 February 2017 10 min read
BI Nat Sundar in BI Deployment Automation for SQL Server Integration Services (SSIS) SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages... 12 January 2017 16 min read
Database DevOps Bob Walker in Database DevOps Introducing DevOps to Farm Credit Services of America Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization.... 11 January 2017 15 min read
Database DevOps Stephanie Herr in Database DevOps DevOps and “Shift Left” for Databases The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to... 16 December 2016 16 min read
PowerShell Nicolas Prigent in PowerShell Managing Hyper-V VMs using PowerShell Direct Virtual machines are easier to manage via PowerShell than with the the Hyper-V Manager console. PowerShell Direct takes this further... 13 December 2016 11 min read
Database DevOps William Brewer in Database DevOps Questions About the Use of PowerShell That you were Too Shy to Ask Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did... 12 December 2016 15 min read
Database DevOps Knut Jürgensen in Database DevOps Planning for Successful Data Management It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities,... 29 November 2016 26 min read
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
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
