Advice I Like: Pyramid Schemes
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
15 reads
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
15 reads
2026-01-02
343 reads
2026-01-02
59 reads
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t do this natively, as this really needs an XEvent session. I decided to see if...
2026-01-02 (first published: 2025-12-17)
1,801 reads
Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.
2025-12-31 (first published: 2025-05-27)
4,054 reads
2025-12-31
73 reads
2025-12-31
1,086 reads
I’ve often done some analysis of my year in different ways. Last year I had a series of posts (health, music, reading, speaking, travel). This year, I took last...
2025-12-29
17 reads
2025-12-29 (first published: 2025-12-24)
535 reads
I was chatting with the product managers at Flyway and one asked me whether I’d seen the new tab for Automation in Flyway Desktop. I hadn’t and decided to...
2025-12-29 (first published: 2025-12-08)
152 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