I recently wrote about how deploying changes to a SQL Server database has become much easier than ever before and highlighted the three primary methods of automating the deployment of databases, which are Redgate’s DLM Automation, Redgate’s ReadyRoll and Microsoft Visual Studio SQL Server Projects. In this installment, I will go in to detail [...]
There are several approaches to SQL Server database development and Database Lifecycle Management (DLM). These approaches range from specialized tools and project types to the storage and cataloging of SQL scripts and everything in between. However, for true DLM, that encompasses all the phases, from development to deployment there are three main options. Option 1: SQL Server [...]
SQL Server 2016 is the most advanced and feature-packed release of SQL Server ever. From SQL Server 2005 through SQL Server 2014, there have been some very nice improvements and the product keeps getting better every release. However, SQL Server 2016 doesn’t just bring a new game, it brings a whole new playing field. Here are [...]
Recently Microsoft introduced SQL Elastic Database services to their suite of Azure offerings. There is a plethora of information available about exactly how the elastic services function, but if you are like me, reading through the material might just confuse you more than enlighten you. I am going to try to clear up the confusion [...]
There has been a great deal of talk recently around a re-discovered process known as DLM, or Database Lifecycle Management. DLM has been around for many years, but until recently has been virtually unknown and overshadowed by the complementing process of ALM, or Application Lifecycle Management. While ALM has seen widespread adoption along with a plethora of [...]
I’ve said before that I have a passion for databases. Remember you can see that passion, live in Bellevue WA, because I’m running a workshop for Redgate Software on Database Continuous Integration on 15 May. Continuous integration ensures software is in a working state all the time, even during the development process. As soon as [...]
I have a passion for databases. I have to admit that my passion sometimes runs afoul of developers looking to short-cut the data requirements of an application. It especially runs afoul of a software configuration management system that doesn’t recognize that databases exist at all. Fortunately, the folks at Redgate share my passion. They also [...]
I recently had the opportunity to attend Red Gate’s “SQL in the City” event in Seattle. As an Enterprise DBA, Architect and SQL Developer I had used Red Gate’s tools extensively for a number of years. I always loved them. However, after transitioning to my current position as an ALM consultant, I didn’t really have much need [...]
I am currently working on a Team Foundation Server – Project Server integration engagement. If you talk to people in the ALM community, many of them think that is like trying to integrate a motorcycle with a truck. Sure, you could do it, but why would you want to? It begs the question, “Where do [...]
I was recently onsite at a client location working with them on a TFS implementation along with a complete redesign of their ALM processes with an Agile adoption thrown in, just to keep things simple. The client is a medium-sized company with about 200 developers worldwide including some off-shore contractors. In the afternoon of the [...]