Database First or Application First
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
2025-04-16
175 reads
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
2025-04-16
175 reads
DevOps has transformed software delivery, but with rapid deployments come increased security risks. As a DevOps engineer, I’ve seen firsthand how small security oversights can lead to major vulnerabilities.
2025-04-16
This article series will teach you what you need to know to take advantage of GitHub Actions, especially for deploying database code.
2025-04-07
DevOps includes the idea of measuring how code flows through your organization and looking for ways to improve your software development process. Steve has a few thoughts on the four main metrics many developments use.
2025-04-02
73 reads
This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes.
2025-01-20
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series.
2024-11-29
The executives at CrowdStrike testify before the US Congress, noting their software development process needs work.
2024-10-11
159 reads
Platform engineering is a new area of focus for some, but it's already being seen as passé by some. Steve notes that there isn't a magic bullet for building better software. It comes about by us working together.
2024-09-30
108 reads
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
2024-09-18
122 reads
Database DevOps practices can help you ship features faster, but how do you safely enable this, and ensure those updates will successfully deploy? Redgate Test Data Manager was developed to resolve bottlenecks and challenges, helping organizations ship deployments they can trust by enabling developers and testers to self-serve test data that walks and talks like production with sensitive customer data taken care of. Read more on the blog.
2024-08-28
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....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
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