SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,669 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
SQL University: Diving into Authorization
It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...
2009-10-27
6,139 reads
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,867 reads
Another Year, Another Missed PASS Summit
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,666 reads
Habits and Activities for De-Stressing
I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's...
2009-10-22
924 reads
Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express
SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.
2009-10-21
5,928 reads
Review: ASUS Eee PC 1005HA Netbook
Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than...
2009-10-19
2,248 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,357 reads
Are you sticking to your goals? Do you know what they are?
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,186 reads
Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
Blogs
An LLM Saved My ATtiny85 From Certain Death
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Forums
Which Table I
Comments posted to this topic are about the item Which Table I
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
Comments posted to this topic are about the item Using Python notebooks to save...
Your AI Successes
Comments posted to this topic are about the item Your AI Successes
Question of the Day
Which Table I
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