I’m Speaking at #DataWeekender
With all our in-person events cancelled for the foreseeable future, I was so excited to find that some community folks are not sitting back and waiting for the social...
2020-04-25
24 reads
With all our in-person events cancelled for the foreseeable future, I was so excited to find that some community folks are not sitting back and waiting for the social...
2020-04-25
24 reads
I am super excited, and humbled, to have been selected to speak at the very first PASS virtual SQL Saturday, SQL Saturday Richmond, on Saturday, April 25, 2020. I...
2020-04-17
14 reads
We are living in some very interesting times and the technical conference community is facing some challenges like it never has before. So many in-person events have been postponed...
2020-04-16
13 reads
I am super excited to announce that I have been selected to speak at SQL Saturday Spokane on March 21, 2020. Not only have I been selected to speak,...
2020-01-20
13 reads
I am so happy to announce that I have been selected to speak at SQL Saturday Victoria on March 14, 2020. This will be my second time speaking at...
2020-01-14
16 reads
I am excited to announce that I have created a new session, Intro to Azure Data Catalog. This has been a long time in the planning and it’s about...
2020-01-13
20 reads
What an incredible year it’s been. I kept thinking that I was busy, but I had no idea until I looked at the final numbers (I have a Power...
2020-01-01
123 reads
I am so excited and honored to have been selected to speak at SQL Saturday Cleveland #930 on February 1, 2020. This will be my second time speaking at...
2019-12-27
15 reads
Some of you may have already heard, but I have decided to step down from being the PASS local group leader for the chapter in Greensboro, NC. I’ve been...
2019-12-21
40 reads
I am so excited to announce that I will be speaking at SQL Saturday DC on Saturday, December 14, 2019. I am so honored to have been selected. This...
2019-11-23
17 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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
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