The case for "Understanding our business" training
Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.
2025-11-19
129 reads
Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.
2025-11-19
129 reads
There is something in the tech mindset that simultaneously loves and loathes a standard. Having standards is important, what those standards are is less so.
2025-01-22
2,320 reads
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
2024-12-02
3,609 reads
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2024-06-14 (first published: 2015-08-27)
867 reads
Learn how you can query JSON data from a CLI to check it before importing the data into a database.
2024-02-16
8,091 reads
Time has brought clarity for changes which could and should have been provided by its instigators. We compare a change where clarity was sought to those that were chaotic and the approaches that were taken at their two poles.
2023-08-16
1,481 reads
Git hooks are a useful way of triggering code quality scripts. The pre-commit tool provides us with a way of doing this and tapping into the huge library of scripts already in existence to ensure our code complies with general linting and formatting good practice.
2023-01-13
6,427 reads
I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation. The UK Financial Services Authority (FSA) was seen to be a toothless tiger. The UK government replaced the FSA with two separate bodies, each with its own more […]
2021-10-25
1,582 reads
A few lessons from a SQL Server DBA that is working on PostgreSQL. David Poole tells us where the similarities in the platforms can cause problems.
2021-07-30
4,071 reads
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
425 reads
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