What about database development? In most projects, developers aren’t focused on database development and for proper CI, the database version should keep neck to neck with the application builds.
2016-06-08
4,223 reads
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process.
2016-02-23
4,082 reads
If it's deemed important to test application code as part of a CI process, the same must apply to the database. In this blog post, Jason Crease shows how to create a smooth process where you can build and deploy databases alongside your application code from within Jenkins with the SQL CI plugin.
2015-12-10
3,631 reads
Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated regularly and tested by an automated build system, and highlights problems early in the development process. But what about database development? Can the same advantages of CI be applied to production databases? Where do you start? How do you tackle it? Sjors Takes relates his experience.
2015-11-09
2,651 reads
Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.
2015-06-12
3,004 reads
This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.
2015-04-07
6,545 reads
Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code. Karsten Kempe explains how to use Team Foundation Server to drive better continuous integration, and walks through a simple open-source tool he built to make nightly builds more transparent, and more valuable.
2014-09-15
7,853 reads
Once databases are placed in source control, it is possible to integrate them into the existing build automation process. This will ensure that the whole development project, including the database, can be integrated regularly and tested by an automated build system. This, in turn, leads to opportunities for more frequent, reliable deployments.
2013-06-06
3,594 reads
Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.
2012-08-15
2,241 reads
We talk a lot about continuous integration here on the Atlassian Dev Tools blog, and many readers are bonafide CI gurus. Now that you are integrating your application code, test code, config files and deploy scripts, are you ready to take it to the next level? An increasing number of engineering shops are starting to bring the continuous integration discipline into their database development.
2012-05-29
2,744 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers