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,220 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,541 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
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers