As organizations realize the advantages they can gain by integrating database development into their DevOps pipelines, the conversation about database DevOps has moved from ‘why’ to ‘how’. This has been helped along the way by the growing availability of third-party tools and solutions which plug into and align with application development processes and workflows... Read more
Any database developer or DBA who spends much of their working week staring at SQL code quickly becomes set in their ways. They like to see the code laid out in a very particular way. They will struggle to look at, let alone digest and understand, code formatted in a ‘foreign’ style. It’s also... Read more
No, it almost certainly isn’t. Besides, how would you know either way? Let me explain. Most modern software development today includes some form of automated testing. While comprehensive unit testing is still sorely lacking in many organizations, it’s often mitigated by other forms of automated testing conducted later on in the development cycle. Code... Read more
In the open source world, there’s an increasing trend to offer personal or community editions of paid-for tools. There’s a damn good reason too. Many charities and educational institutions as well as individual users turn to open source software in an effort to lower costs. The flipside is, while there’s no upfront cost, there... Read more
For a long time, SQL Compare has been the industry standard for comparing and deploying SQL Server database schemas. Packed with features that can be used to maintain a history of deployments, it makes it possible to build up a record of which objects were changed, when a change was applied, who made it,... Read more
Sssshhh. There’s a revolution going on. Quietly, purposefully, and without fanfare, Database Lifecycle Management is looming on the horizon for every developer and DBA. A continuous, agile-based approach to integrating, coordinating and managing the different phases of database delivery. Whoah, there. Database Lifecycle Management? Application Lifecycle Management, yes, but how on earth can you... Read more