SQL University: Architecting SQL Server Security, the Big Picture
Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...
2011-02-07
3,318 reads
Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...
2011-02-07
3,318 reads
Cross-posted from the Goal Keeping DBA blog:
Personal appearance matters. We all know this. Yet a lot of times we don’t...
2011-02-04
1,141 reads
As I annouced earlier, Oracle and database expert, Bert Scalzo and I collaborated on an introductory text appropriately titled Introduction to SQL...
2011-01-26
702 reads
Want a legitimate chance to win an eBook reader like a Kindle? Would having it loaded down with eBooks on...
2011-01-25
823 reads
We're gearing up the advertising for SQL Saturday #70 since we're about 8 weeks out. In keeping with that, our...
2011-01-24
2,013 reads
I'm speaking in context of Getting Things Done, not a legal or contractual agreement. What brought this up is me...
2011-01-24
793 reads
We're finally getting a handle on things with the new baby. 🙂 As a result, I've started this weekly accumulation of...
2011-01-21
830 reads
Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...
2011-01-19
595 reads
When I first saw Andy Leonard's post about a new SQL People event, I was intrigued. It's not a training...
2011-01-13
2,501 reads
I know I missed out on the massive meme yesterday (T-SQL Tuesday #14), but I blame dealing with the weather...
2011-01-12
796 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
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
exec('SELECT ProductName FROM product;')
END;
GO
exec etl.GettheProduct
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