Friend of Redgate 2016
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective...
2016-02-07
580 reads
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective...
2016-02-07
580 reads
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2016-02-07
7 reads
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my...
2016-01-29
848 reads
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my first SQLSaturday event and I’m really excited that I...
2016-01-29
3 reads
This past week I had the pleasure of speaking for my first time professionally to the Chicago Suburban SQL Server...
2016-01-25
501 reads
Update for T-SQL Tuesday #84
Well, this year I was challenged with the goal of speaking publicly three times, well I blew that out of the water and have spoken...
2016-01-25
3 reads
2016-01-15
3 reads
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this...
2015-12-29
885 reads
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this year Paul Randal ( b | t ), in...
2015-12-29
1 reads
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output from Diskspd and run some tests and interpret results....
2015-10-06
4 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