Looking for a new SQL Server book? Look no further…
So I know it’s been a while since I last posted on this blog, but I promise I haven’t been...
2013-10-18 (first published: 2013-10-10)
3,343 reads
So I know it’s been a while since I last posted on this blog, but I promise I haven’t been...
2013-10-18 (first published: 2013-10-10)
3,343 reads
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And...
2013-04-15
626 reads
Digging the new logo
Last week I was fortunate enough to attend SQLSkills IE1 class in Tampa. Fortunate to have an...
2013-02-15 (first published: 2013-02-11)
2,475 reads
Last month I mentioned that I’d like to start including Oracle stuff on this blog. I’m getting back into that...
2013-01-28
697 reads
So, you may have noticed that things have been a little quiet around here of late. Sorry about that, I’ve...
2012-12-21
810 reads
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-11-28
1,253 reads
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-10-24
1,098 reads
One thing I failed to touch on during my series on SQL Audit was the use of user-defined events in...
2012-10-18
3,226 reads
This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171. They picked the perfect time...
2012-10-09
571 reads
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-09-26
1,121 reads
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
The thread for the league in 2026. Players from last year have priority.
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
hi , i know this is a sql server forum but i think my...
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