I am Speaking at 2013 PASS Member Summit!
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,274 reads
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,274 reads
It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk
T-SQL Tuesday!
about our experiences with change in our work lives. I’d...
2013-05-14
571 reads
Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...
2013-03-06 (first published: 2013-02-25)
4,361 reads
The following is a recording of my Performance Tuning for Pirates session recorded by UserGroup.TV at SQL Saturday 125 in...
2013-01-14
932 reads
[UPDATE] Video recording from PASS Virtual Performance Chapter’s Winter 2012 Performance Palooza can be found here.
I am a huge fan...
2012-12-05
871 reads
The following is my highlights and thoughts about the day two keynote at the SQL PASS Member Summit.
Douglas McDowell started...
2012-11-08
688 reads
The following are five recommendations I would like to share with anyone attending the #sqlpass member summit. I hope you...
2012-11-07
694 reads
I love the SQL Community because it usually is a great environment to connect, share and learn. With that said,...
2012-10-30
1,617 reads
First SQL Saturday in Pittsburgh
It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I
We...
2012-10-12
625 reads
Tonight, October 8th at 6:30pm I am virtually speaking at the OKC SQL Server User Group. I had a blast...
2012-10-08
541 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